public ActionResult ThemPhieudieutri(NoitruPhieudieutri objTreatment) { try { using (var scope = new TransactionScope()) { using (var dbscope = new SharedDbConnectionScope()) { //if(Convert.ToDateTime(objTreatment.NgayLapPhieu)) SqlQuery sqlQuery = new Select().From(NoitruPhieudieutri.Schema) .Where(NoitruPhieudieutri.Columns.IdPhieudieutri).IsEqualTo(objTreatment.IdPhieudieutri); if (sqlQuery.GetRecordCount() <= 0) { objTreatment.NgaySua = null; objTreatment.NguoiSua = string.Empty; objTreatment.IsNew = true; objTreatment.Save(); } else { objTreatment.TenMaysua = globalVariables.gv_strComputerName; objTreatment.IpMaysua = globalVariables.gv_strIPAddress; objTreatment.NgaySua = DateTime.Now; objTreatment.NguoiSua = globalVariables.UserName; objTreatment.MarkOld(); objTreatment.IsNew = false; objTreatment.IsLoaded = true; objTreatment.Save(); new Update(KcbChidinhcl.Schema) .Set(KcbChidinhcl.Columns.NgayChidinh).EqualTo(objTreatment.NgayDieutri) .Where(KcbChidinhcl.Columns.IdDieutri).IsEqualTo(objTreatment.IdPhieudieutri).Execute(); new Update(KcbDonthuoc.Schema) .Set(KcbDonthuoc.Columns.NgayKedon).EqualTo(objTreatment.NgayDieutri) .Where(KcbDonthuoc.Columns.IdPhieudieutri).IsEqualTo(objTreatment.IdPhieudieutri).Execute(); } new Update(KcbLuotkham.Schema) .Set(KcbLuotkham.Columns.TrangthaiNoitru).EqualTo(2) .Where(KcbLuotkham.Columns.IdBenhnhan).IsEqualTo(objTreatment.IdBenhnhan) .And(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(objTreatment.MaLuotkham).Execute(); } scope.Complete(); return(ActionResult.Success); } } catch (Exception exception) { log.Error("loi trong qua trinh tao phieu dieu tri: {0}", exception.ToString()); return(ActionResult.Error); } }
public ActionResult ThemPhieudieutri(NoitruPhieudieutri objTreatment) { try { using (var scope = new TransactionScope()) { using (var dbscope = new SharedDbConnectionScope()) { if (objTreatment.IdPhieudieutri <= 0) { objTreatment.NgaySua = null; objTreatment.NguoiSua = string.Empty; objTreatment.IsNew = true; objTreatment.Save(); } else { objTreatment.MarkOld(); objTreatment.IsNew = false; objTreatment.IsLoaded = true; objTreatment.Save(); new Update(KcbChidinhcl.Schema) .Set(KcbChidinhcl.Columns.NgayChidinh).EqualTo(objTreatment.NgayDieutri) .Where(KcbChidinhcl.Columns.IdDieutri).IsEqualTo(objTreatment.IdPhieudieutri).Execute(); new Update(KcbDonthuoc.Schema) .Set(KcbDonthuoc.Columns.NgayKedon).EqualTo(objTreatment.NgayDieutri) .Where(KcbDonthuoc.Columns.IdPhieudieutri).IsEqualTo(objTreatment.IdPhieudieutri).Execute(); } new Update(KcbLuotkham.Schema) .Set(KcbLuotkham.Columns.TrangthaiNoitru).EqualTo(2) .Where(KcbLuotkham.Columns.IdBenhnhan).IsEqualTo(objTreatment.IdBenhnhan) .And(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(objTreatment.MaLuotkham).Execute(); } scope.Complete(); return(ActionResult.Success); } } catch (Exception exception) { log.Error("loi trong qua trinh tao phieu dieu tri: {0}", exception.ToString()); return(ActionResult.Error); } }
public void Update(int IdPhieudieutri,string MaLuotkham,int? IdBenhnhan,short? IdBacsi,int? IdBuongGiuong,long? IdBuong,long? IdGiuong,short? IdKhoanoitru,string Thu,string ThongtinTheodoi,string ThongtinDieutri,DateTime? NgayDieutri,string GioDieutri,byte? TthaiBosung,byte? TthaiIn,byte? TrangThai,int? IdGoi,byte? TrongGoi,DateTime? NgayTao,string NguoiTao,DateTime? NgaySua,string NguoiSua,string IpMaytao,string IpMaysua,string TenMaytao,string TenMaysua) { NoitruPhieudieutri item = new NoitruPhieudieutri(); item.MarkOld(); item.IsLoaded = true; item.IdPhieudieutri = IdPhieudieutri; item.MaLuotkham = MaLuotkham; item.IdBenhnhan = IdBenhnhan; item.IdBacsi = IdBacsi; item.IdBuongGiuong = IdBuongGiuong; item.IdBuong = IdBuong; item.IdGiuong = IdGiuong; item.IdKhoanoitru = IdKhoanoitru; item.Thu = Thu; item.ThongtinTheodoi = ThongtinTheodoi; item.ThongtinDieutri = ThongtinDieutri; item.NgayDieutri = NgayDieutri; item.GioDieutri = GioDieutri; item.TthaiBosung = TthaiBosung; item.TthaiIn = TthaiIn; item.TrangThai = TrangThai; item.IdGoi = IdGoi; item.TrongGoi = TrongGoi; item.NgayTao = NgayTao; item.NguoiTao = NguoiTao; item.NgaySua = NgaySua; item.NguoiSua = NguoiSua; item.IpMaytao = IpMaytao; item.IpMaysua = IpMaysua; item.TenMaytao = TenMaytao; item.TenMaysua = TenMaysua; item.Save(UserName); }
private void ThemPhieuDieuTri() { if (objPhieudieutri == null) { objPhieudieutri = new NoitruPhieudieutri(); } if (em_Action == action.Update) { objPhieudieutri.MarkOld(); objPhieudieutri.IsLoaded = true; objPhieudieutri.IsNew = false; objPhieudieutri.IdPhieudieutri = Utility.Int32Dbnull(txtTreat_ID.Text, -1); objPhieudieutri.NguoiSua = globalVariables.UserName; objPhieudieutri.NgaySua = globalVariables.SysDate; objPhieudieutri.TenMaysua = globalVariables.gv_strComputerName; objPhieudieutri.IpMaysua = globalVariables.gv_strIPAddress; } else { objPhieudieutri.TrangThai = 0; objPhieudieutri.IsNew = true; objPhieudieutri.TenMaytao = globalVariables.gv_strComputerName; objPhieudieutri.IpMaytao = globalVariables.gv_strIPAddress; objPhieudieutri.NguoiTao = globalVariables.UserName; objPhieudieutri.NgayTao = globalVariables.SysDate; objPhieudieutri.TthaiIn = 0; } objPhieudieutri.TthaiBosung = Utility.Bool2byte(chkPhieuBoSung.Checked); objPhieudieutri.IdPhieudieutri = Utility.Int32Dbnull(txtTreat_ID.Text, -1); objPhieudieutri.ThongtinDieutri = Utility.DoTrim(txtBstheodoi.Text); objPhieudieutri.ThongtinTheodoi = Utility.DoTrim(txtDieuduongtheodoi.Text); objPhieudieutri.NgayDieutri = dtNgayLapPhieu.Value.Date; objPhieudieutri.GioDieutri = dtGioLapPhieu.Text; objPhieudieutri.Thu = Utility.ConvertDayVietnamese(dtNgayLapPhieu.Value.DayOfWeek.ToString()); objPhieudieutri.MaLuotkham = Utility.sDbnull(objLuotkham.MaLuotkham, ""); objPhieudieutri.IdKhoanoitru = objBuongGiuong.IdKhoanoitru; objPhieudieutri.IdBuongGiuong = objBuongGiuong != null?Utility.Int32Dbnull(objBuongGiuong.Id) : -1; objPhieudieutri.IdBuong = objBuongGiuong != null?Utility.Int32Dbnull(objBuongGiuong.IdBuong) : -1; objPhieudieutri.IdGiuong = objBuongGiuong != null?Utility.Int32Dbnull(objBuongGiuong.IdGiuong) : -1; objPhieudieutri.IdBenhnhan = Utility.Int32Dbnull(objLuotkham.IdBenhnhan, -1); objPhieudieutri.IdBuong = objLuotkham.IdBuong; objPhieudieutri.IdGiuong = objLuotkham.IdGiuong; if (cboBacSy.SelectedIndex > 0) { objPhieudieutri.IdBacsi = Utility.Int16Dbnull(cboBacSy.SelectedValue); } else { objPhieudieutri.IdBacsi = globalVariables.gv_intIDNhanvien; } ActionResult actionResult = new noitru_phieudieutri().ThemPhieudieutri(objPhieudieutri); switch (actionResult) { case ActionResult.Success: txtTreat_ID.Text = Utility.sDbnull(objPhieudieutri.IdPhieudieutri, -1); DataRow drv = p_TreatMent.NewRow(); Utility.FromObjectToDatarow(objPhieudieutri, ref drv); drv["sngay_dieutri"] = dtNgayLapPhieu.Value.ToString("dd/MM/yyyy"); if (cboBacSy.SelectedIndex > 0) { drv["ten_bacsidieutri"] = cboBacSy.Text; } p_TreatMent.Rows.Add(drv); Utility.GotoNewRowJanus(grdList, NoitruPhieudieutri.Columns.IdPhieudieutri, objPhieudieutri.IdPhieudieutri.ToString()); b_Cancel = true; Close(); break; case ActionResult.Error: Utility.ShowMsg("Lỗi trong quá trình thêm phiếu điều trị", "Thông báo lỗi", MessageBoxIcon.Error); break; } }
public ActionResult ThemPhieudieutri(NoitruPhieudieutri objTreatment) { try { using (var scope = new TransactionScope()) { using (var dbscope = new SharedDbConnectionScope()) { if (objTreatment.IdPhieudieutri<=0) { objTreatment.NgaySua = null; objTreatment.NguoiSua = string.Empty; objTreatment.IsNew = true; objTreatment.Save(); } else { objTreatment.MarkOld(); objTreatment.IsNew = false; objTreatment.IsLoaded = true; objTreatment.Save(); new Update(KcbChidinhcl.Schema) .Set(KcbChidinhcl.Columns.NgayChidinh).EqualTo(objTreatment.NgayDieutri) .Where(KcbChidinhcl.Columns.IdDieutri).IsEqualTo(objTreatment.IdPhieudieutri).Execute(); new Update(KcbDonthuoc.Schema) .Set(KcbDonthuoc.Columns.NgayKedon).EqualTo(objTreatment.NgayDieutri) .Where(KcbDonthuoc.Columns.IdPhieudieutri).IsEqualTo(objTreatment.IdPhieudieutri).Execute(); } new Update(KcbLuotkham.Schema) .Set(KcbLuotkham.Columns.TrangthaiNoitru).EqualTo(2) .Where(KcbLuotkham.Columns.IdBenhnhan).IsEqualTo(objTreatment.IdBenhnhan) .And(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(objTreatment.MaLuotkham).Execute(); } scope.Complete(); return ActionResult.Success; } } catch (Exception exception) { log.Error("loi trong qua trinh tao phieu dieu tri: {0}", exception.ToString()); return ActionResult.Error; } }
public ActionResult ThemPhieudieutri(NoitruPhieudieutri objTreatment) { try { using (var scope = new TransactionScope()) { using (var dbscope = new SharedDbConnectionScope()) { //if(Convert.ToDateTime(objTreatment.NgayLapPhieu)) SqlQuery sqlQuery = new Select().From(NoitruPhieudieutri.Schema) .Where(NoitruPhieudieutri.Columns.IdPhieudieutri).IsEqualTo(objTreatment.IdPhieudieutri); if (sqlQuery.GetRecordCount() <= 0) { objTreatment.NgaySua = null; objTreatment.NguoiSua = string.Empty; objTreatment.IsNew = true; objTreatment.Save(); } else { objTreatment.TenMaysua = globalVariables.gv_strComputerName; objTreatment.IpMaysua = globalVariables.gv_strIPAddress; objTreatment.NgaySua = DateTime.Now; objTreatment.NguoiSua = globalVariables.UserName; objTreatment.MarkOld(); objTreatment.IsNew = false; objTreatment.IsLoaded = true; objTreatment.Save(); new Update(KcbChidinhcl.Schema) .Set(KcbChidinhcl.Columns.NgayChidinh).EqualTo(objTreatment.NgayDieutri) .Where(KcbChidinhcl.Columns.IdDieutri).IsEqualTo(objTreatment.IdPhieudieutri).Execute(); new Update(KcbDonthuoc.Schema) .Set(KcbDonthuoc.Columns.NgayKedon).EqualTo(objTreatment.NgayDieutri) .Where(KcbDonthuoc.Columns.IdPhieudieutri).IsEqualTo(objTreatment.IdPhieudieutri).Execute(); } new Update(KcbLuotkham.Schema) .Set(KcbLuotkham.Columns.TrangthaiNoitru).EqualTo(2) .Where(KcbLuotkham.Columns.IdBenhnhan).IsEqualTo(objTreatment.IdBenhnhan) .And(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(objTreatment.MaLuotkham).Execute(); } scope.Complete(); return ActionResult.Success; } } catch (Exception exception) { log.Error("loi trong qua trinh tao phieu dieu tri: {0}", exception.ToString()); return ActionResult.Error; } }