public KcbDonthuocCollection FetchAll() { KcbDonthuocCollection coll = new KcbDonthuocCollection(); Query qry = new Query(KcbDonthuoc.Schema); coll.LoadAndCloseReader(qry.ExecuteReader()); return coll; }
public KcbDonthuocCollection FetchByQuery(Query qry) { KcbDonthuocCollection coll = new KcbDonthuocCollection(); coll.LoadAndCloseReader(qry.ExecuteReader()); return(coll); }
public KcbDonthuocCollection FetchAll() { KcbDonthuocCollection coll = new KcbDonthuocCollection(); Query qry = new Query(KcbDonthuoc.Schema); coll.LoadAndCloseReader(qry.ExecuteReader()); return(coll); }
public KcbDonthuocCollection FetchByQuery(Query qry) { KcbDonthuocCollection coll = new KcbDonthuocCollection(); coll.LoadAndCloseReader(qry.ExecuteReader()); return coll; }
public KcbDonthuocCollection FetchByID(object IdDonthuoc) { KcbDonthuocCollection coll = new KcbDonthuocCollection().Where("id_donthuoc", IdDonthuoc).Load(); return coll; }
public ActionResult SaochepDonthuoc(int CurrentTreatID, KcbLuotkham objLuotkham, KcbDonthuocCollection lstPres, DateTime pres_date) { try { using (var scope = new TransactionScope()) { using (var dbscope = new SharedDbConnectionScope()) { foreach (KcbDonthuoc pre in lstPres) { int oldPreID = pre.IdDonthuoc; pre.IdPhieudieutri = CurrentTreatID; pre.NgayKedon = pres_date; pre.NguoiTao = globalVariables.UserName; pre.Noitru = 1; pre.IdKham = -1; pre.IdGoi = -1; pre.TrongGoi = 0; pre.TenDonthuoc = THU_VIEN_CHUNG.TaoTenDonthuoc(objLuotkham.MaLuotkham, Utility.Int32Dbnull( objLuotkham.IdBenhnhan, -1)); pre.TrangThai = 0; //pre.PresStatus = null; pre.IdDonthuocthaythe = -1; pre.TrangthaiThanhtoan = 0; pre.NgayThanhtoan = null; pre.NgayCapphat = null; pre.NgayXacnhan = null; pre.NguoiSua = null; pre.NgaySua = null; pre.IsNew = true; pre.Save(); KcbDonthuocChitietCollection lstobjChitietdonthuoc = new Select().From(KcbDonthuocChitiet.Schema) .Where(KcbDonthuocChitiet.IdDonthuocColumn) .IsEqualTo(oldPreID) .ExecuteAsCollection<KcbDonthuocChitietCollection>(); foreach (KcbDonthuocChitiet _detail in lstobjChitietdonthuoc) { _detail.IdDonthuoc = pre.IdDonthuoc; _detail.IdKham = -1; _detail.TrangThai = 0; _detail.TrangthaiTonghop = 0; _detail.TrangthaiThanhtoan = 0; _detail.IdGoi = 0; _detail.TrongGoi = 0; _detail.SoluongHuy = 0; _detail.TrangthaiHuy = 0; _detail.NgayThanhtoan = null; _detail.NguonThanhtoan = 1; _detail.IdThanhtoan = -1; _detail.NguoiHuy = null; _detail.NgayHuy = null; _detail.SoluongHuy = 0; _detail.NgayXacnhan = null; _detail.SoLuong = Utility.Int32Dbnull(_detail.SluongSua, -1) <= 0 ? _detail.SoLuong : _detail.SluongSua.Value; _detail.SluongSua = null; ; _detail.SluongLinh = null; _detail.IsNew = true; _detail.Save(); } } } scope.Complete(); return ActionResult.Success; } } catch (Exception exception) { return ActionResult.Error; } }
public ActionResult SaochepDonthuoc(int CurrentTreatID, KcbLuotkham objLuotkham, KcbDonthuocCollection lstPres, DateTime pres_date) { try { using (var scope = new TransactionScope()) { using (var dbscope = new SharedDbConnectionScope()) { foreach (KcbDonthuoc pre in lstPres) { long oldPreID = pre.IdDonthuoc; pre.IdPhieudieutri = CurrentTreatID; pre.NgayKedon = pres_date; pre.NguoiTao = globalVariables.UserName; pre.KieuDonthuoc = 0; pre.Noitru = 1; pre.IdKham = -1; pre.IdGoi = -1; pre.TrongGoi = 0; pre.TenDonthuoc = THU_VIEN_CHUNG.TaoTenDonthuoc(objLuotkham.MaLuotkham, Utility.Int32Dbnull( objLuotkham.IdBenhnhan, -1)); pre.TrangThai = 0; //pre.PresStatus = null; pre.IdDonthuocthaythe = -1; pre.TrangthaiThanhtoan = 0; pre.NgayThanhtoan = null; pre.NgayCapphat = null; pre.NgayXacnhan = null; pre.NguoiSua = null; pre.NgaySua = null; pre.IsNew = true; pre.Save(); KcbDonthuocChitietCollection lstobjChitietdonthuoc = new Select().From(KcbDonthuocChitiet.Schema) .Where(KcbDonthuocChitiet.IdDonthuocColumn) .IsEqualTo(oldPreID) .ExecuteAsCollection <KcbDonthuocChitietCollection>(); foreach (KcbDonthuocChitiet _detail in lstobjChitietdonthuoc) { _detail.IdDonthuoc = pre.IdDonthuoc; _detail.IdKham = -1; _detail.TrangThai = 0; _detail.TrangthaiTonghop = 0; _detail.TrangthaiThanhtoan = 0; _detail.IdGoi = 0; _detail.TrongGoi = 0; _detail.SoluongHuy = 0; _detail.TrangthaiHuy = 0; _detail.NgayThanhtoan = null; _detail.NguonThanhtoan = 1; _detail.IdThanhtoan = -1; _detail.NguoiHuy = null; _detail.NgayHuy = null; _detail.SoluongHuy = 0; _detail.NgayXacnhan = null; _detail.SoLuong = Utility.Int32Dbnull(_detail.SluongSua, -1) <= 0 ? _detail.SoLuong : _detail.SluongSua.Value; _detail.SluongSua = null; ; _detail.SluongLinh = null; _detail.IsNew = true; _detail.Save(); } } } scope.Complete(); return(ActionResult.Success); } } catch (Exception exception) { return(ActionResult.Error); } }
public KcbDonthuocCollection FetchByID(object IdDonthuoc) { KcbDonthuocCollection coll = new KcbDonthuocCollection().Where("id_donthuoc", IdDonthuoc).Load(); return(coll); }