public KcbChandoanKetluanCollection FetchAll() { KcbChandoanKetluanCollection coll = new KcbChandoanKetluanCollection(); Query qry = new Query(KcbChandoanKetluan.Schema); coll.LoadAndCloseReader(qry.ExecuteReader()); return coll; }
public KcbChandoanKetluanCollection FetchByQuery(Query qry) { KcbChandoanKetluanCollection coll = new KcbChandoanKetluanCollection(); coll.LoadAndCloseReader(qry.ExecuteReader()); return(coll); }
public KcbChandoanKetluanCollection FetchAll() { KcbChandoanKetluanCollection coll = new KcbChandoanKetluanCollection(); Query qry = new Query(KcbChandoanKetluan.Schema); coll.LoadAndCloseReader(qry.ExecuteReader()); return(coll); }
public KcbChandoanKetluanCollection FetchByID(object IdChandoan) { KcbChandoanKetluanCollection coll = new KcbChandoanKetluanCollection().Where("id_chandoan", IdChandoan).Load(); return(coll); }
public KcbChandoanKetluanCollection FetchByQuery(Query qry) { KcbChandoanKetluanCollection coll = new KcbChandoanKetluanCollection(); coll.LoadAndCloseReader(qry.ExecuteReader()); return coll; }
public KcbChandoanKetluanCollection FetchByID(object IdChandoan) { KcbChandoanKetluanCollection coll = new KcbChandoanKetluanCollection().Where("id_chandoan", IdChandoan).Load(); return coll; }
/// <summary> /// hàm thực hiện việc update thông tin xác nhận gói /// </summary> /// <param name="objThongtinGoiDvuBnhan"></param> /// <returns></returns> public ActionResult UpdateExamInfo(KcbChandoanKetluan objDiagInfo, KcbDangkyKcb objRegExam, KcbLuotkham objPatientExam) { try { using (var scope = new TransactionScope()) { using (var sh = new SharedDbConnectionScope()) { if (objDiagInfo.IsNew) { objDiagInfo.Save(); } else { objDiagInfo.MarkOld(); objDiagInfo.Save(); } SqlQuery sqlQuery = new Select().From( KcbChandoanKetluan.Schema) .Where(KcbChandoanKetluan.Columns.MaLuotkham).IsEqualTo(objPatientExam.MaLuotkham) .And(KcbChandoanKetluan.Columns.IdBenhnhan).IsEqualTo(objPatientExam.IdBenhnhan).OrderAsc( KcbChandoanKetluan.Columns.NgayChandoan); KcbChandoanKetluanCollection objInfoCollection = sqlQuery.ExecuteAsCollection <KcbChandoanKetluanCollection>(); var query = (from chandoan in objInfoCollection.AsEnumerable() let y = Utility.sDbnull(chandoan.Chandoan) where (y != "") select y).ToArray(); string cdchinh = string.Join(";", query); //KcbChandoanKetluanCollection objInfoCollection = sqlQuery.ExecuteAsCollection<KcbChandoanKetluanCollection>(); var querychandoanphu = (from chandoan in objInfoCollection.AsEnumerable() let y = Utility.sDbnull(chandoan.ChandoanKemtheo) where (y != "") select y).ToArray(); string cdphu = string.Join(";", querychandoanphu); var querybenhchinh = (from benhchinh in objInfoCollection.AsEnumerable() let y = Utility.sDbnull(benhchinh.MabenhChinh) where (y != "") select y).ToArray(); string mabenhchinh = string.Join(";", querybenhchinh); var querybenhphu = (from benhphu in objInfoCollection.AsEnumerable() let y = Utility.sDbnull(benhphu.MabenhPhu) where (y != "") select y).ToArray(); string mabenhphu = string.Join(";", querybenhphu); new Update(KcbLuotkham.Schema) .Set(KcbLuotkham.Columns.MabenhChinh).EqualTo(mabenhchinh) .Set(KcbLuotkham.Columns.MabenhPhu).EqualTo(mabenhphu) .Set(KcbLuotkham.Columns.ChanDoan).EqualTo(cdchinh) .Set(KcbLuotkham.Columns.ChandoanKemtheo).EqualTo(cdphu) .Set(KcbLuotkham.Columns.TrieuChung).EqualTo(objPatientExam.TrieuChung) .Set(KcbLuotkham.Columns.NguoiSua).EqualTo(globalVariables.UserName) .Set(KcbLuotkham.Columns.NgaySua).EqualTo(globalVariables.SysDate) .Set(KcbLuotkham.Columns.Locked).EqualTo(objPatientExam.Locked) .Set(KcbLuotkham.Columns.NguoiKetthuc).EqualTo(objPatientExam.NguoiKetthuc) .Set(KcbLuotkham.Columns.NgayKetthuc).EqualTo(objPatientExam.NgayKetthuc) .Where(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(objPatientExam.MaLuotkham) .And(KcbLuotkham.Columns.IdBenhnhan).IsEqualTo(objPatientExam.IdBenhnhan).Execute(); //Tạm bỏ tránh việc bị cập nhật sai bác sĩ chỉ định nếu bác sĩ đó chỉ lưu thông tin kết luận //SPs.KcbThamkhamCappnhatBsyKham(Utility.Int32Dbnull(objRegExam.IdKham, -1), objPatientExam.MaLuotkham, // Utility.Int32Dbnull(objPatientExam.IdBenhnhan, -1), // Utility.Int32Dbnull(objDiagInfo.DoctorId, -1)).Execute(); if (objRegExam != null) { new Update(KcbDangkyKcb.Schema) .Set(KcbDangkyKcb.Columns.NgaySua).EqualTo(globalVariables.SysDate) .Set(KcbDangkyKcb.Columns.NguoiSua).EqualTo(globalVariables.UserName) //.Set(KcbDangkyKcb.Columns.IpMacSua).EqualTo(BusinessHelper.GetMACAddress()) //.Set(KcbDangkyKcb.Columns.IpMaySua).EqualTo(BusinessHelper.GetIP4Address()) .Set(KcbDangkyKcb.Columns.IdBacsikham).EqualTo(objDiagInfo.IdBacsikham) .Set(KcbDangkyKcb.Columns.TrangThai).EqualTo(objRegExam.TrangThai) .Where(KcbDangkyKcb.Columns.IdKham).IsEqualTo(Utility.Int32Dbnull(objRegExam.IdKham, -1)). Execute(); } } scope.Complete(); // Reg_ID = Utility.Int32Dbnull(objRegExam.IdKham, -1); return(ActionResult.Success); } } catch (Exception exception) { log.Error("Loi trong qua trinh chuyen vien khoi noi tru {0}", exception); return(ActionResult.Error); } }
public ActionResult CapnhatChandoan(KcbChandoanKetluan objKcbChandoanKetluan) { try { if (objKcbChandoanKetluan == null) { return(ActionResult.Cancel); } using (TransactionScope scope = new TransactionScope()) { using (SharedDbConnectionScope sh = new SharedDbConnectionScope()) { if (objKcbChandoanKetluan.IsNew) { objKcbChandoanKetluan.Save(); } else { objKcbChandoanKetluan.MarkOld(); objKcbChandoanKetluan.Save(); } SqlQuery sqlQuery = new Select().From(KcbChandoanKetluan.Schema) .Where(KcbChandoanKetluan.Columns.MaLuotkham).IsEqualTo(objKcbChandoanKetluan.MaLuotkham) .And(KcbChandoanKetluan.Columns.IdBenhnhan).IsEqualTo(objKcbChandoanKetluan.IdBenhnhan).OrderAsc( KcbChandoanKetluan.Columns.NgayChandoan); KcbChandoanKetluanCollection objInfoCollection = sqlQuery.ExecuteAsCollection <KcbChandoanKetluanCollection>(); var query = (from chandoan in objInfoCollection.AsEnumerable() let y = Utility.sDbnull(chandoan.Chandoan) where (y != "") select y).ToArray(); string cdchinh = string.Join(";", query); var querychandoanphu = (from chandoan in objInfoCollection.AsEnumerable() let y = Utility.sDbnull(chandoan.ChandoanKemtheo) where (y != "") select y).ToArray(); string cdphu = string.Join(";", querychandoanphu); var querybenhchinh = (from benhchinh in objInfoCollection.AsEnumerable() let y = Utility.sDbnull(benhchinh.MabenhChinh) where (y != "") select y).ToArray(); string mabenhchinh = string.Join(";", querybenhchinh); var querybenhphu = (from benhphu in objInfoCollection.AsEnumerable() let y = Utility.sDbnull(benhphu.MabenhPhu) where (y != "") select y).ToArray(); string mabenhphu = string.Join(";", querybenhphu); new Update(KcbLuotkham.Schema) .Set(KcbLuotkham.Columns.MabenhChinh).EqualTo(mabenhchinh) .Set(KcbLuotkham.Columns.MabenhPhu).EqualTo(mabenhphu) .Set(KcbLuotkham.Columns.ChanDoan).EqualTo(cdchinh) .Set(KcbLuotkham.Columns.NguoiSua).EqualTo(globalVariables.UserName) .Set(KcbLuotkham.Columns.NgaySua).EqualTo(globalVariables.SysDate) .Where(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(objKcbChandoanKetluan.MaLuotkham) .And(KcbLuotkham.Columns.IdBenhnhan).IsEqualTo(objKcbChandoanKetluan.IdBenhnhan).Execute(); } scope.Complete(); // Reg_ID = Utility.Int32Dbnull(objRegExam.IdKham, -1); return(ActionResult.Success); } } catch (Exception exception) { log.Error("Loi trong qua trinh chuyen vien khoi noi tru {0}", exception); return(ActionResult.Error); } }
/// <summary> /// hàm thực hiện việc update thông tin xác nhận gói /// </summary> /// <param name="objThongtinGoiDvuBnhan"></param> /// <returns></returns> public ActionResult UpdateExamInfo(KcbChandoanKetluan objDiagInfo, KcbDangkyKcb objRegExam, KcbLuotkham objPatientExam) { try { using (var scope = new TransactionScope()) { using (var sh = new SharedDbConnectionScope()) { if (objDiagInfo != null) { log.Trace("1.1 Bat dau ket thuc benh nhan: " + objDiagInfo.MaLuotkham); if (objDiagInfo.IsNew) { // objDiagInfo.Save(); SPs.SpKcbThemmoiChandoanKetluan(objDiagInfo.IdChandoan, objDiagInfo.IdKham, objDiagInfo.IdBenhnhan, objDiagInfo.MaLuotkham, objDiagInfo.IdBacsikham, objDiagInfo.NgayChandoan, objDiagInfo.NguoiTao, objDiagInfo.NgayTao, objDiagInfo.IdKhoanoitru, objDiagInfo.IdBuonggiuong, objDiagInfo.IdBuong, objDiagInfo.IdGiuong , objDiagInfo.IdPhieudieutri, objDiagInfo.Noitru, objDiagInfo.IdPhongkham, objDiagInfo.TenPhongkham, objDiagInfo.Mach, objDiagInfo.Nhietdo, objDiagInfo.Huyetap , objDiagInfo.Nhiptim, objDiagInfo.Nhiptho, objDiagInfo.Cannang, objDiagInfo.Chieucao, objDiagInfo.Nhommau, objDiagInfo.Ketluan, objDiagInfo.ChedoDinhduong, objDiagInfo.HuongDieutri, objDiagInfo.SongayDieutri, objDiagInfo.TrieuchungBandau , objDiagInfo.Chandoan, objDiagInfo.ChandoanKemtheo, objDiagInfo.MabenhChinh, objDiagInfo.MabenhPhu, objDiagInfo.MotaBenhchinh, objDiagInfo.IpMaytao, objDiagInfo.TenMaytao, objDiagInfo.PhanungSautiemchung, objDiagInfo.KPL1 , objDiagInfo.KPL2, objDiagInfo.KPL3, objDiagInfo.KPL4, objDiagInfo.KPL5, objDiagInfo.KPL6, objDiagInfo.KPL7, objDiagInfo.KPL8, objDiagInfo.KL1, objDiagInfo.KL2, objDiagInfo.KL3, objDiagInfo.KetluanNguyennhan, objDiagInfo.NhanXet , objDiagInfo.ChongchidinhKhac, objDiagInfo.SoNgayhen, objDiagInfo.ChisoIbm, objDiagInfo.ThilucMp, objDiagInfo.ThilucMt, objDiagInfo.NhanapMp, objDiagInfo.NhanapMt ).Execute(); } else { SPs.SpKcbCapnhatChandoanKetluan(objDiagInfo.IdChandoan, objDiagInfo.IdBacsikham, objDiagInfo.NgayChandoan, objDiagInfo.NguoiSua, objDiagInfo.NgaySua, objDiagInfo.IdPhieudieutri , objDiagInfo.Noitru, objDiagInfo.IdPhongkham, objDiagInfo.TenPhongkham, objDiagInfo.Mach, objDiagInfo.Nhietdo, objDiagInfo.Huyetap, objDiagInfo.Nhiptim, objDiagInfo.Nhiptho, objDiagInfo.Cannang, objDiagInfo.Chieucao , objDiagInfo.Nhommau, objDiagInfo.Ketluan, objDiagInfo.ChedoDinhduong, objDiagInfo.HuongDieutri, objDiagInfo.SongayDieutri, objDiagInfo.TrieuchungBandau, objDiagInfo.Chandoan, objDiagInfo.ChandoanKemtheo, objDiagInfo.MabenhChinh , objDiagInfo.MabenhPhu, objDiagInfo.MotaBenhchinh, objDiagInfo.IpMaysua, objDiagInfo.TenMaysua, objDiagInfo.PhanungSautiemchung, objDiagInfo.KPL1 , objDiagInfo.KPL2, objDiagInfo.KPL3, objDiagInfo.KPL4, objDiagInfo.KPL5, objDiagInfo.KPL6, objDiagInfo.KPL7, objDiagInfo.KPL8, objDiagInfo.KL1, objDiagInfo.KL2, objDiagInfo.KL3, objDiagInfo.KetluanNguyennhan, objDiagInfo.NhanXet, objDiagInfo.ChongchidinhKhac, objDiagInfo.SoNgayhen, objDiagInfo.ChisoIbm, objDiagInfo.ThilucMp, objDiagInfo.ThilucMt, objDiagInfo.NhanapMp, objDiagInfo.NhanapMt).Execute(); } } log.Trace("1.2 Luu xong chan doan cua benh nhan: " + objDiagInfo.MaLuotkham); SqlQuery sqlQuery = new Select().From( KcbChandoanKetluan.Schema) .Where(KcbChandoanKetluan.Columns.MaLuotkham).IsEqualTo(objPatientExam.MaLuotkham) .And(KcbChandoanKetluan.Columns.IdBenhnhan).IsEqualTo(objPatientExam.IdBenhnhan) .And(KcbChandoanKetluan.Columns.IdKham).IsEqualTo(objRegExam.IdKham).OrderAsc( KcbChandoanKetluan.Columns.NgayChandoan); KcbChandoanKetluanCollection objInfoCollection = sqlQuery.ExecuteAsCollection <KcbChandoanKetluanCollection>(); var query = (from chandoan in objInfoCollection.AsEnumerable() let y = Utility.sDbnull(chandoan.Chandoan) where (y != "") select y).ToArray(); string cdchinh = string.Join(";", query); //KcbChandoanKetluanCollection objInfoCollection = sqlQuery.ExecuteAsCollection<KcbChandoanKetluanCollection>(); var querychandoanphu = (from chandoan in objInfoCollection.AsEnumerable() let y = Utility.sDbnull(chandoan.ChandoanKemtheo) where (y != "") select y).ToArray(); string cdphu = string.Join(";", querychandoanphu); var querybenhchinh = (from benhchinh in objInfoCollection.AsEnumerable() let y = Utility.sDbnull(benhchinh.MabenhChinh) where (y != "") select y).ToArray(); string mabenhchinh = string.Join(";", querybenhchinh); var querybenhphu = (from benhphu in objInfoCollection.AsEnumerable() let y = Utility.sDbnull(benhphu.MabenhPhu) where (y != "") select y).ToArray(); string mabenhphu = string.Join(";", querybenhphu); SPs.KcbLuotkhamTrangthaiketthuckham(objPatientExam.IdBenhnhan, objPatientExam.MaLuotkham, objPatientExam.TrangthaiNgoaitru, objPatientExam.Noitru, mabenhchinh, mabenhphu, objPatientExam.KetLuan, objPatientExam.HuongDieutri, cdchinh , cdphu, objPatientExam.Locked, objPatientExam.SongayDieutri, objPatientExam.TrieuChung, globalVariables.UserName, globalVariables.SysDate, globalVariables.gv_strIPAddress, globalVariables.gv_strComputerName, objDiagInfo.IdBacsikham, objRegExam.TrangThai, objRegExam.IdKham).Execute(); log.Trace("1.3 Update thanh cong trang thai cua benh nhan: " + objDiagInfo.MaLuotkham); //new Update(KcbLuotkham.Schema) // .Set(KcbLuotkham.Columns.MabenhChinh).EqualTo(mabenhchinh) // .Set(KcbLuotkham.Columns.MabenhPhu).EqualTo(mabenhphu) // .Set(KcbLuotkham.Columns.KetLuan).EqualTo(objPatientExam.KetLuan) // .Set(KcbLuotkham.Columns.HuongDieutri).EqualTo(objPatientExam.HuongDieutri) // .Set(KcbLuotkham.Columns.ChanDoan).EqualTo(cdchinh) // .Set(KcbLuotkham.Columns.SongayDieutri).EqualTo(objPatientExam.SongayDieutri) // .Set(KcbLuotkham.Columns.ChandoanKemtheo).EqualTo(cdphu) // .Set(KcbLuotkham.Columns.TrieuChung).EqualTo(objPatientExam.TrieuChung) // .Set(KcbLuotkham.Columns.NguoiSua).EqualTo(globalVariables.UserName) // .Set(KcbLuotkham.Columns.NgaySua).EqualTo(globalVariables.SysDate) // .Set(KcbLuotkham.Columns.Locked).EqualTo(objPatientExam.Locked) // .Set(KcbLuotkham.Columns.NguoiKetthuc).EqualTo(objPatientExam.NguoiKetthuc) // .Set(KcbLuotkham.Columns.NgayKetthuc).EqualTo(objPatientExam.NgayKetthuc) // .Set(KcbLuotkham.Columns.TrangthaiNgoaitru).EqualTo(objPatientExam.TrangthaiNgoaitru) // .Where(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(objPatientExam.MaLuotkham) // .And(KcbLuotkham.Columns.IdBenhnhan).IsEqualTo(objPatientExam.IdBenhnhan).Execute(); ////Tạm bỏ tránh việc bị cập nhật sai bác sĩ chỉ định nếu bác sĩ đó chỉ lưu thông tin kết luận ////SPs.KcbThamkhamCappnhatBsyKham(Utility.Int32Dbnull(objRegExam.IdKham, -1), objPatientExam.MaLuotkham, //// Utility.Int32Dbnull(objPatientExam.IdBenhnhan, -1), //// Utility.Int32Dbnull(objDiagInfo.DoctorId, -1)).Execute(); //if (objRegExam != null) //{ // new Update(KcbDangkyKcb.Schema) // .Set(KcbDangkyKcb.Columns.NgaySua).EqualTo(globalVariables.SysDate) // .Set(KcbDangkyKcb.Columns.NguoiSua).EqualTo(globalVariables.UserName) // .Set(KcbDangkyKcb.Columns.IpMaysua).EqualTo(globalVariables.gv_strIPAddress) // .Set(KcbDangkyKcb.Columns.TenMaysua).EqualTo(globalVariables.gv_strComputerName) // .Set(KcbDangkyKcb.Columns.IdBacsikham).EqualTo(objDiagInfo.IdBacsikham) // .Set(KcbDangkyKcb.Columns.TrangThai).EqualTo(objRegExam.TrangThai) // .Where(KcbDangkyKcb.Columns.IdKham).IsEqualTo(Utility.Int32Dbnull(objRegExam.IdKham, -1)). // Execute(); //} sh.Dispose(); } scope.Complete(); // Reg_ID = Utility.Int32Dbnull(objRegExam.IdKham, -1); return(ActionResult.Success); } } catch (Exception exception) { log.Error("Loi trong qua trinh ket thuc benh nhan", exception); return(ActionResult.Error); } }