本文整理汇总了C#中System.Data.Select.ToList方法的典型用法代码示例。如果您正苦于以下问题:C# Select.ToList方法的具体用法?C# Select.ToList怎么用?C# Select.ToList使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.Select
的用法示例。
在下文中一共展示了Select.ToList方法的1个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: CapnhatLichsuDoituongKCB
public static ActionResult CapnhatLichsuDoituongKCB(List<KcbLichsuDoituongKcb> lstLichsu,List<long> lstDelete)
{
try
{
ActionResult _ActionResult = ActionResult.Success;
using (var Scope = new TransactionScope())
{
using (var dbScope = new SharedDbConnectionScope())
{
KcbLichsuDoituongKcb _item=lstLichsu[0];
List<long> lstID = new List<long>();
KcbDangkyKcbCollection lstDangkyKCB = new Select().From(KcbDangkyKcb.Schema)
.Where(KcbDangkyKcb.Columns.IdBenhnhan).IsEqualTo(_item.IdBenhnhan)
.And(KcbDangkyKcb.Columns.MaLuotkham).IsEqualTo(_item.MaLuotkham)
.ExecuteAsCollection<KcbDangkyKcbCollection>();
NoitruPhanbuonggiuongCollection lstbuonggiuong=new Select().From(NoitruPhanbuonggiuong.Schema)
.Where(NoitruPhanbuonggiuong.Columns.IdBenhnhan).IsEqualTo(_item.IdBenhnhan)
.And(NoitruPhanbuonggiuong.Columns.MaLuotkham).IsEqualTo(_item.MaLuotkham)
.ExecuteAsCollection<NoitruPhanbuonggiuongCollection>();
KcbDonthuocCollection lstDonthuoc = new Select().From(KcbDonthuoc.Schema)
.Where(KcbDonthuoc.Columns.IdBenhnhan).IsEqualTo(_item.IdBenhnhan)
.And(KcbDonthuoc.Columns.MaLuotkham).IsEqualTo(_item.MaLuotkham)
.ExecuteAsCollection<KcbDonthuocCollection>();
lstID = lstDonthuoc.Select(c => c.IdDonthuoc).ToList<long>();
KcbDonthuocChitietCollection lstDonthuocChitiet = new KcbDonthuocChitietCollection();
if (lstID.Count > 0)
lstDonthuocChitiet = new Select().From(KcbDonthuocChitiet.Schema)
.Where(KcbDonthuocChitiet.Columns.IdDonthuoc).In(lstID)
.ExecuteAsCollection<KcbDonthuocChitietCollection>();
KcbChidinhclCollection lstChidinh = new Select().From(KcbChidinhcl.Schema)
.Where(KcbChidinhcl.Columns.IdBenhnhan).IsEqualTo(_item.IdBenhnhan)
.And(KcbChidinhcl.Columns.MaLuotkham).IsEqualTo(_item.MaLuotkham)
.ExecuteAsCollection<KcbChidinhclCollection>();
lstID = lstChidinh.Select(c => c.IdChidinh).ToList<long>();
KcbChidinhclsChitietCollection lstChidinhChitiet = new KcbChidinhclsChitietCollection();
if (lstID.Count > 0)
lstChidinhChitiet = new Select().From(KcbChidinhclsChitiet.Schema)
.Where(KcbChidinhclsChitiet.Columns.IdChidinh).In(lstID)
.ExecuteAsCollection<KcbChidinhclsChitietCollection>();
if (lstDelete.Count > 0)
new Delete().From(KcbLichsuDoituongKcb.Schema).Where(KcbLichsuDoituongKcb.Columns.IdLichsuDoituongKcb).In(lstDelete).Execute();
foreach (KcbLichsuDoituongKcb objLichsu in lstLichsu)
{
//Gán thông tin nội trú
if (objLichsu.TrangthaiNoitru > 0)
{
var q = from p in lstbuonggiuong
where Utility.Int32Dbnull(Utility.GetYYYYMMDD(p.NgayVaokhoa), 0) >= Utility.Int32Dbnull(Utility.GetYYYYMMDD(objLichsu.NgayHieuluc), 0)
select p;
if (q.Any())
{
objLichsu.IdKhoanoitru = q.FirstOrDefault().IdKhoanoitru;
objLichsu.IdBuong = q.FirstOrDefault().IdBuong;
objLichsu.IdGiuong = q.FirstOrDefault().IdGiuong;
objLichsu.IdRavien = q.FirstOrDefault().IdKhoanoitru;
}
}
objLichsu.Save();
_ActionResult= CapnhatChiphiKCB(objLichsu, lstDangkyKCB.ToList<KcbDangkyKcb>());
if (_ActionResult == ActionResult.Cancel)
return _ActionResult;
List<KcbChidinhcl> _chidinhCLS = (from p in lstChidinh
where Utility.Int32Dbnull(Utility.GetYYYYMMDD(p.NgayChidinh), 0) >= Utility.Int32Dbnull(Utility.GetYYYYMMDD(objLichsu.NgayHieuluc), 0)
&& Utility.Int32Dbnull(Utility.GetYYYYMMDD(p.NgayChidinh), 0) <= Utility.Int32Dbnull(Utility.GetYYYYMMDD(objLichsu.NgayHethieuluc,new DateTime(2099,1,1)), 0)
select p).ToList<KcbChidinhcl>();
lstID = _chidinhCLS.Select(c => c.IdChidinh).ToList<long>();
List<KcbChidinhclsChitiet> _chidinhCLsChitiet = (from p in lstChidinhChitiet
where lstID.Contains(p.IdChidinh)
select p).ToList<KcbChidinhclsChitiet>();
_ActionResult= CapnhatChiphiCLS(objLichsu, _chidinhCLS, _chidinhCLsChitiet);
if (_ActionResult == ActionResult.Cancel)
return _ActionResult;
List<KcbDonthuoc> _donthuoc = (from p in lstDonthuoc
where Utility.Int32Dbnull(Utility.GetYYYYMMDD(p.NgayKedon), 0) >= Utility.Int32Dbnull(Utility.GetYYYYMMDD(objLichsu.NgayHieuluc), 0)
&& Utility.Int32Dbnull(Utility.GetYYYYMMDD(p.NgayKedon), 0) <= Utility.Int32Dbnull(Utility.GetYYYYMMDD(objLichsu.NgayHethieuluc, new DateTime(2099, 1, 1)), 0)
select p).ToList<KcbDonthuoc>();
lstID = _donthuoc.Select(c => c.IdDonthuoc).ToList<long>();
List<KcbDonthuocChitiet> _donthuocChitiet = (from p in lstDonthuocChitiet
where lstID.Contains(p.IdDonthuoc)
select p).ToList<KcbDonthuocChitiet>();
_ActionResult= CapnhatChiphiThuoc(objLichsu, _donthuoc, _donthuocChitiet);
if (_ActionResult == ActionResult.Cancel)
return _ActionResult;
List<NoitruPhanbuonggiuong> _Bg = (from p in lstbuonggiuong
where p.NgayVaokhoa >= objLichsu.NgayHieuluc && p.NgayVaokhoa <= objLichsu.NgayHethieuluc
select p).ToList<NoitruPhanbuonggiuong>();
_ActionResult= CapnhatBuonggiuong(objLichsu, _Bg);
if (_ActionResult == ActionResult.Cancel)
//.........这里部分代码省略.........