public bool blnIsExisted(int ID, string code, int objectType_Id, int Department_Id, int ExamType_ID, int Doctor_ID) { try { DmucDichvukcbCollection v_DmucDichvukcb = new DmucDichvukcbController().FetchByQuery( DmucDichvukcb.CreateQuery().AddWhere(DmucDichvukcb.Columns.MaDichvukcb, Comparison.Equals, txtCode.Text.Trim()).AND( DmucDichvukcb.Columns.IdPhongkham, Comparison.Equals, Department_Id).AND( DmucDichvukcb.Columns.IdDoituongKcb, Comparison.Equals, objectType_Id).AND( DmucDichvukcb.Columns.IdKieukham, Comparison.Equals, ExamType_ID).AND( DmucDichvukcb.Columns.IdBacsy, Comparison.Equals, Doctor_ID).AND( DmucDichvukcb.Columns.IdDichvukcb, Comparison.NotEquals, ID)); return(v_DmucDichvukcb.Count > 0); return(true); } catch (Exception) { return(false); } }
public static ActionResult ChuyenPhong(long IdKham,string LydoChuyen, DmucDichvukcb objDichvuKcb) { try { ActionResult _ActionResult = ActionResult.Success; using (var Scope = new TransactionScope()) { using (var dbScope = new SharedDbConnectionScope()) { new Update(KcbDangkyKcb.Schema) .Set(KcbDangkyKcb.Columns.IdPhongkham).EqualTo(objDichvuKcb.IdPhongkham) .Set(KcbDangkyKcb.Columns.IdDichvuKcb).EqualTo(objDichvuKcb.IdDichvukcb) .Set(KcbDangkyKcb.Columns.IdKieukham).EqualTo(objDichvuKcb.IdKieukham) .Set(KcbDangkyKcb.Columns.TenDichvuKcb).EqualTo(objDichvuKcb.TenDichvukcb) .Set(KcbDangkyKcb.Columns.NgayDangky).EqualTo(globalVariables.SysDate) .Set(KcbDangkyKcb.Columns.NguoiChuyen).EqualTo(globalVariables.UserName) .Set(KcbDangkyKcb.Columns.NgayChuyen).EqualTo(globalVariables.SysDate) .Set(KcbDangkyKcb.Columns.LydoChuyen).EqualTo(LydoChuyen) .Set(KcbDangkyKcb.Columns.TrangthaiChuyen).EqualTo(1) .Where(KcbDangkyKcb.Columns.IdKham).IsEqualTo(IdKham) .Execute(); } Scope.Complete(); return ActionResult.Success; } } catch (Exception ex) { Utility.ShowMsg("Lỗi khi chuyển đối tượng:\n"+ex.Message); return ActionResult.Exception; } }
public static ActionResult ChuyenPhong(long IdKham, string LydoChuyen, DmucDichvukcb objDichvuKcb) { try { ActionResult _ActionResult = ActionResult.Success; using (var Scope = new TransactionScope()) { using (var dbScope = new SharedDbConnectionScope()) { new Update(KcbDangkyKcb.Schema) .Set(KcbDangkyKcb.Columns.IdPhongkham).EqualTo(objDichvuKcb.IdPhongkham) .Set(KcbDangkyKcb.Columns.IdDichvuKcb).EqualTo(objDichvuKcb.IdDichvukcb) .Set(KcbDangkyKcb.Columns.IdKieukham).EqualTo(objDichvuKcb.IdKieukham) .Set(KcbDangkyKcb.Columns.TenDichvuKcb).EqualTo(objDichvuKcb.TenDichvukcb) .Set(KcbDangkyKcb.Columns.NgayDangky).EqualTo(globalVariables.SysDate) .Set(KcbDangkyKcb.Columns.NguoiChuyen).EqualTo(globalVariables.UserName) .Set(KcbDangkyKcb.Columns.NgayChuyen).EqualTo(globalVariables.SysDate) .Set(KcbDangkyKcb.Columns.LydoChuyen).EqualTo(LydoChuyen) .Set(KcbDangkyKcb.Columns.TrangthaiChuyen).EqualTo(1) .Where(KcbDangkyKcb.Columns.IdKham).IsEqualTo(IdKham) .Execute(); } Scope.Complete(); return(ActionResult.Success); } } catch (Exception ex) { Utility.ShowMsg("Lỗi khi chuyển đối tượng:\n" + ex.Message); return(ActionResult.Exception); } }
public static ActionResult ChuyenPhong(long idKham, string lydoChuyen, DmucDichvukcb objDichvuKcb) { try { ActionResult actionResult = ActionResult.Success; using (var scope = new TransactionScope()) { using (var dbScope = new SharedDbConnectionScope()) { int sttkham = THU_VIEN_CHUNG.LaySothutuKCB(objDichvuKcb.IdPhongkham); new Update(KcbDangkyKcb.Schema) .Set(KcbDangkyKcb.Columns.IdPhongkham).EqualTo(objDichvuKcb.IdPhongkham) .Set(KcbDangkyKcb.Columns.IdBacsikham).EqualTo(-1) .Set(KcbDangkyKcb.Columns.SttKham).EqualTo(sttkham) .Set(KcbDangkyKcb.Columns.IdDichvuKcb).EqualTo(objDichvuKcb.IdDichvukcb) .Set(KcbDangkyKcb.Columns.IdKieukham).EqualTo(objDichvuKcb.IdKieukham) .Set(KcbDangkyKcb.Columns.TenDichvuKcb).EqualTo(objDichvuKcb.TenDichvukcb.ToUpper()) .Set(KcbDangkyKcb.Columns.NgayDangky).EqualTo(globalVariables.SysDate) .Set(KcbDangkyKcb.Columns.NguoiChuyen).EqualTo(globalVariables.UserName) .Set(KcbDangkyKcb.Columns.NgayChuyen).EqualTo(globalVariables.SysDate) .Set(KcbDangkyKcb.Columns.LydoChuyen).EqualTo(lydoChuyen) .Set(KcbDangkyKcb.Columns.TrangthaiChuyen).EqualTo(1) .Where(KcbDangkyKcb.Columns.IdKham).IsEqualTo(idKham) .Execute(); } scope.Complete(); return(ActionResult.Success); } } catch (Exception ex) { Utility.ShowMsg("Lỗi khi chuyển đối tượng:\n" + ex.Message); return(ActionResult.Exception); } }
/// <summary> /// lấy thông tin của khi load sửa thông tin của Form /// </summary> private void GetData() { try { DmucDichvukcb Obj = DmucDichvukcb.FetchByID(Utility.Int32Dbnull(txtInsObject_ID.Text, -1)); if (Obj != null) { Id = Obj.IdDichvukcb; cboDepartment1.SelectedIndex = Utility.GetSelectedIndex(cboDepartment1, Obj.IdKhoaphong.ToString()); //cboDepartment1_SelectedIndexChanged(cboDepartment1, new EventArgs()); BindRoomDept(Obj.IdKhoaphong); cboRoomDept.SelectedValue = Utility.Int32Dbnull(Obj.IdPhongkham); //cboRoomDept.SelectedIndex = Utility.GetSelectedIndex(cboRoomDept, // Obj.IdPhongkham.ToString()); //cboRoomDept_SelectedIndexChanged(cboRoomDept, new EventArgs()); BindStaffList(Obj.IdKhoaphong); cboBacSy.SelectedValue = Utility.Int32Dbnull(Obj.IdBacsy); //cboBacSy.SelectedIndex = Utility.GetSelectedIndex(cboBacSy, // Obj.IdBacsy. // ToString()); cboLoaiKham.SelectedIndex = Utility.GetSelectedIndex(cboLoaiKham, Obj.IdKieukham. ToString()); cboDoituong.SelectedIndex = Utility.GetSelectedIndex(cboDoituong, Obj.IdDoituongKcb. ToString()); // cboRoomDept.SelectedIndex = Utility.GetSelectedIndex(cboRoomDept,Obj.IdPhongkham) txtDongia.Text = Utility.DecimaltoDbnull(Obj.DonGia, 0).ToString(); txtGiangoaigio.Text = Utility.DecimaltoDbnull(Obj.DongiaNgoaigio, 0).ToString(); txtPhuthungoaigio.Text = Utility.DecimaltoDbnull(Obj.PhuthuNgoaigio, 0).ToString(); txtPTDT.Text = Utility.DecimaltoDbnull(Obj.PhuthuDungtuyen, 0).ToString(); txtPTTT.Text = Utility.DecimaltoDbnull(Obj.PhuthuTraituyen, 0).ToString(); chkTutuc.Checked = Utility.Byte2Bool(Obj.TuTuc); chkhoatdong.Checked = Utility.Byte2Bool(Obj.HoatDong); txtmagiabhyt.Text = Utility.sDbnull(Obj.MaGia); txtMaBhyt.Text = Utility.sDbnull(Obj.MaBhyt); txtDesc.Text = Obj.MotaThem; nmrSTT.Value = Utility.DecimaltoDbnull(Obj.SttHthi, 1); txtCode.Text = Obj.MaDichvukcb; txtName.Text = Obj.TenDichvukcb; } } catch (Exception ex) { Utility.ShowMsg("Lỗi:" + ex.Message); } }
private void AutoLoadKieuKham() { try { if (Utility.Int32Dbnull(txtKieuKham.MyID, -1) == -1 || Utility.Int32Dbnull(txtPhongkham.MyID, -1) == -1) { _DmucDichvukcb = null; return; } DataRow[] arrDr = m_ExamTypeRelationList.Select("(ma_doituong_kcb='ALL' OR ma_doituong_kcb='" + MA_DTUONG + "') AND id_kieukham=" + txtKieuKham.MyID.ToString().Trim() + " AND id_phongkham=" + txtPhongkham.MyID.ToString().Trim()); //nếu ko có đích danh phòng thì lấy dịch vụ bất kỳ theo kiểu khám và đối tượng if (arrDr.Length <= 0) { arrDr = m_ExamTypeRelationList.Select("(ma_doituong_kcb='ALL' OR ma_doituong_kcb='" + MA_DTUONG + "') AND id_kieukham=" + txtKieuKham.MyID.ToString().Trim() + " AND id_phongkham=-1 "); } if (arrDr.Length <= 0) { _DmucDichvukcb = null; return; } else { _DmucDichvukcb = new Select().From(DmucDichvukcb.Schema).Where(DmucDichvukcb.Columns.IdDichvukcb) .IsEqualTo(arrDr[0][DmucDichvukcb.Columns.IdDichvukcb]).ExecuteSingle <DmucDichvukcb>(); return; } } catch { _DmucDichvukcb = null; } finally { AutoLoad = false; } }
private static ActionResult CapnhatChiphiKCB(KcbLuotkham objLuotkham) { using (var Scope = new TransactionScope()) { KcbDangkyKcbCollection objRegExamCollection = new Select().From(KcbDangkyKcb.Schema).Where(KcbDangkyKcb.Columns.MaLuotkham).IsEqualTo( objLuotkham.MaLuotkham).And(KcbDangkyKcb.Columns.IdBenhnhan).IsEqualTo(objLuotkham.IdBenhnhan) .And(KcbDangkyKcb.Columns.LaPhidichvukemtheo).IsEqualTo(0) .ExecuteAsCollection <KcbDangkyKcbCollection>(); if (objRegExamCollection.Count > 0) { //CHUYỂN GIÁ KHÁM BỆNH VÀO PHÒNG foreach (KcbDangkyKcb objRegExam in objRegExamCollection) { if (objRegExam.TrangthaiThanhtoan == 0) { DmucDichvukcb _DichvukcbCu = DmucDichvukcb.FetchByID(objRegExam.IdDichvuKcb); var _DichvukcbMoi = new Select().From(DmucDichvukcb.Schema) .Where(DmucDichvukcb.Columns.IdKhoaphong).IsEqualTo(_DichvukcbCu.IdKhoaphong) .And(DmucDichvukcb.Columns.IdPhongkham).IsEqualTo(_DichvukcbCu.IdPhongkham) .And(DmucDichvukcb.Columns.IdKieukham).IsEqualTo(_DichvukcbCu.IdKieukham) .AndExpression(DmucDichvukcb.Columns.MaDoituongKcb).IsEqualTo(objLuotkham.MaDoituongKcb) .Or(DmucDichvukcb.Columns.MaDoituongKcb).IsEqualTo("ALL").CloseExpression() .ExecuteSingle <DmucDichvukcb>(); if (_DichvukcbMoi != null) { objRegExam.IdDichvuKcb = Utility.Int16Dbnull(_DichvukcbMoi.IdDichvukcb, -1); if (Utility.Int32Dbnull(_DichvukcbMoi.TuTuc, 0) == 1) { objRegExam.TuTuc = 1; //Ke ca co trong bang quan he } if (objLuotkham.IdLoaidoituongKcb == 1) //Đối tượng dịch vụ-->ko cần phải đánh dấu tự túc { objRegExam.TuTuc = 0; } objRegExam.TenDichvuKcb = _DichvukcbMoi.TenDichvukcb; objRegExam.DonGia = Utility.DecimaltoDbnull(_DichvukcbMoi.DonGia); objRegExam.PhuThu = !Utility.Byte2Bool(objLuotkham.DungTuyen) ? Utility.DecimaltoDbnull(_DichvukcbMoi.PhuthuDungtuyen) : Utility.DecimaltoDbnull(_DichvukcbMoi.PhuthuTraituyen); objRegExam.PtramBhyt = objLuotkham.PtramBhyt;//% BHYT ngoại trú if (Utility.Byte2Bool(objRegExam.KhamNgoaigio)) { objRegExam.KhamNgoaigio = 1; objRegExam.DonGia = Utility.DecimaltoDbnull(_DichvukcbMoi.DongiaNgoaigio, 0); objRegExam.PhuThu = !Utility.Byte2Bool(objLuotkham.DungTuyen) ? Utility.DecimaltoDbnull(_DichvukcbMoi.PhuthuNgoaigio, 0) : Utility.DecimaltoDbnull(_DichvukcbMoi.PhuthuDungtuyen); } if (Utility.Int32Dbnull(objRegExam.TuTuc, 0) == 0) { objRegExam.BhytChitra = Utility.DecimaltoDbnull(objRegExam.DonGia) * Utility.DecimaltoDbnull(objLuotkham.PtramBhyt) / 100; objRegExam.BnhanChitra = Utility.DecimaltoDbnull(objRegExam.DonGia, 0) - Utility.DecimaltoDbnull(objRegExam.BhytChitra, 0); } else { objRegExam.BhytChitra = 0; objRegExam.BnhanChitra = Utility.DecimaltoDbnull(objRegExam.DonGia, 0); } } } else { return(ActionResult.Cancel); } } objRegExamCollection.SaveAll(); } Scope.Complete(); return(ActionResult.Success); } }
private void PerformActionInsert() { var objDmucDichvukcb = new DmucDichvukcb(); objDmucDichvukcb.MaDichvukcb = Utility.sDbnull(txtCode.Text, ""); objDmucDichvukcb.TenDichvukcb = Utility.sDbnull(txtName.Text, ""); objDmucDichvukcb.IdKieukham = Utility.Int16Dbnull(cboLoaiKham.SelectedValue, -1); objDmucDichvukcb.IdKhoaphong = Utility.Int16Dbnull(cboDepartment1.SelectedValue, -1); objDmucDichvukcb.IdBacsy = Convert.ToInt16(cboBacSy.Items.Count > 0 ? Utility.Int16Dbnull(cboBacSy.SelectedValue, -1) : -1); objDmucDichvukcb.MotaThem = Utility.DoTrim(txtDesc.Text); objDmucDichvukcb.SttHthi = Utility.Int16Dbnull(nmrSTT.Value); objDmucDichvukcb.IdDoituongKcb = Utility.Int16Dbnull(cboDoituong.SelectedValue, -1); DmucDoituongkcb objectType = DmucDoituongkcb.FetchByID(objDmucDichvukcb.IdDoituongKcb); if (objectType != null) objDmucDichvukcb.MaDoituongKcb = Utility.sDbnull(objectType.MaDoituongKcb, ""); else objDmucDichvukcb.MaDoituongKcb = "ALL"; DmucKieukham objKieukham = DmucKieukham.FetchByID(Utility.Int16Dbnull(cboLoaiKham.SelectedValue, -1)); if (objKieukham != null) objDmucDichvukcb.NhomBaocao = Utility.sDbnull(objKieukham.NhomBaocao, ""); else objDmucDichvukcb.NhomBaocao = "-1"; objDmucDichvukcb.IdPhongkham = Utility.Int16Dbnull(cboRoomDept.SelectedValue); objDmucDichvukcb.PhuthuDungtuyen = Utility.DecimaltoDbnull(txtPTDT.Text, 0); objDmucDichvukcb.PhuthuTraituyen = Utility.DecimaltoDbnull(txtPTTT.Text, 0); objDmucDichvukcb.DonGia = Utility.DecimaltoDbnull(txtDongia.Text, 0); objDmucDichvukcb.DongiaNgoaigio = Utility.DecimaltoDbnull(txtGiangoaigio.Text, 0); objDmucDichvukcb.PhuthuNgoaigio = Utility.DecimaltoDbnull(txtPhuthungoaigio.Text, 0); objDmucDichvukcb.TuTuc = Utility.Bool2byte(chkTutuc.Checked); objDmucDichvukcb.IsNew = true; objDmucDichvukcb.Save(); DataRow dr = m_dtDataRelation.NewRow(); dr[DmucDichvukcb.Columns.IdDichvukcb] = Utility.Int32Dbnull( _Query.GetMax(DmucDichvukcb.Columns.IdDichvukcb), -1); dr[DmucDichvukcb.Columns.IdDoituongKcb] = Utility.DecimaltoDbnull(cboDoituong.SelectedValue); dr[DmucDichvukcb.Columns.IdKhoaphong] = Utility.Int16Dbnull(cboDepartment1.SelectedValue, -1); dr[DmucDichvukcb.Columns.IdPhongkham] = Utility.Int16Dbnull(cboRoomDept.SelectedValue, -1); dr[DmucDichvukcb.Columns.IdBacsy] = cboBacSy.Items.Count > 0 ? Utility.Int16Dbnull(cboBacSy.SelectedValue, -1) : -1; dr[DmucDichvukcb.Columns.DonGia] = Utility.DecimaltoDbnull(txtDongia.Text, 0); dr[DmucDichvukcb.Columns.PhuthuDungtuyen] = Utility.DecimaltoDbnull(txtPTDT.Text, 0); dr[DmucDichvukcb.Columns.PhuthuTraituyen] = Utility.DecimaltoDbnull(txtPTTT.Text, 0); dr[DmucDichvukcb.Columns.DongiaNgoaigio] = Utility.DecimaltoDbnull(txtGiangoaigio.Text, 0); dr[DmucDichvukcb.Columns.PhuthuNgoaigio] = Utility.DecimaltoDbnull(txtPhuthungoaigio.Text, 0); dr[DmucDichvukcb.Columns.MotaThem] = Utility.DoTrim(txtDesc.Text); dr[DmucDichvukcb.Columns.SttHthi] = Utility.Int16Dbnull(nmrSTT.Value, 1); dr[DmucDichvukcb.Columns.TuTuc] = Utility.Bool2byte(chkTutuc.Checked); dr["ten_phong"] = cboRoomDept.Text; dr[DmucDichvukcb.Columns.IdKieukham] = Utility.Int16Dbnull(cboLoaiKham.SelectedValue, -1); dr[DmucKieukham.Columns.TenKieukham] = cboLoaiKham.Text; dr[DmucDichvukcb.Columns.MaDichvukcb] = txtCode.Text.Trim(); dr[DmucDichvukcb.Columns.TenDichvukcb] = txtName.Text.Trim(); dr["ten_khoa"] = cboDepartment1.SelectedIndex <= -1 ? "Tất cả các khoa KCB" : cboDepartment1.Text; dr["ten_bacsi"] = cboBacSy.SelectedIndex > 0 ? cboBacSy.Text : ""; dr[DmucDoituongkcb.Columns.TenDoituongKcb] = objectType != null ? cboDoituong.Text : "Tất cả các đối tượng"; m_dtDataRelation.Rows.Add(dr); //this.Close(); }
public void Insert(string MaDichvukcb,string TenDichvukcb,short IdKieukham,short IdKhoaphong,short IdBacsy,short IdDoituongKcb,short IdPhongkham,decimal DonGia,decimal? PhuthuDungtuyen,decimal? PhuthuTraituyen,decimal? DongiaNgoaigio,decimal? PhuthuNgoaigio,string MaDoituongKcb,int? IdPhikemtheo,int? IdPhikemtheongoaigio,string NhomBaocao,byte? TuTuc,short? SttHthi,string MotaThem) { DmucDichvukcb item = new DmucDichvukcb(); item.MaDichvukcb = MaDichvukcb; item.TenDichvukcb = TenDichvukcb; item.IdKieukham = IdKieukham; item.IdKhoaphong = IdKhoaphong; item.IdBacsy = IdBacsy; item.IdDoituongKcb = IdDoituongKcb; item.IdPhongkham = IdPhongkham; item.DonGia = DonGia; item.PhuthuDungtuyen = PhuthuDungtuyen; item.PhuthuTraituyen = PhuthuTraituyen; item.DongiaNgoaigio = DongiaNgoaigio; item.PhuthuNgoaigio = PhuthuNgoaigio; item.MaDoituongKcb = MaDoituongKcb; item.IdPhikemtheo = IdPhikemtheo; item.IdPhikemtheongoaigio = IdPhikemtheongoaigio; item.NhomBaocao = NhomBaocao; item.TuTuc = TuTuc; item.SttHthi = SttHthi; item.MotaThem = MotaThem; item.Save(UserName); }
private void AutoLoadKieuKham() { try { if (Utility.Int32Dbnull(txtKieuKham.MyID, -1) == -1 || Utility.Int32Dbnull(txtPhongkham.MyID, -1) == -1) { _DmucDichvukcb= null; return; } //_DmucDichvukcb=new Select().From(DmucDichvukcb.Schema). // Where(DmucDichvukcb.Columns.IdKieukham).IsEqualTo(Utility.Int32Dbnull(txtKieuKham.MyID, -1)) // .And(DmucDichvukcb.Columns.IdPhongkham).IsEqualTo(Utility.Int32Dbnull(txtPhongkham.MyID, -1)) // .And(DmucDichvukcb.Columns.DonGia).IsEqualTo(Utility.Int32Dbnull(txtPhongkham.MyID, -1)) DataRow[] arrDr = m_ExamTypeRelationList.Select("(ma_doituong_kcb='ALL' OR ma_doituong_kcb='" + MA_DTUONG + "') AND id_kieukham=" + txtKieuKham.MyID.ToString().Trim() + " AND id_phongkham=" + txtPhongkham.MyID.ToString().Trim()); //nếu ko có đích danh phòng thì lấy dịch vụ bất kỳ theo kiểu khám và đối tượng if (arrDr.Length <= 0) arrDr = m_ExamTypeRelationList.Select("(ma_doituong_kcb='ALL' OR ma_doituong_kcb='" + MA_DTUONG + "') AND id_kieukham=" + txtKieuKham.MyID.ToString().Trim() + " AND id_phongkham=-1 "); if (arrDr.Length <= 0) { _DmucDichvukcb = null; return ; } else { _DmucDichvukcb= new Select().From(DmucDichvukcb.Schema).Where(DmucDichvukcb.Columns.IdDichvukcb) .IsEqualTo(arrDr[0][DmucDichvukcb.Columns.IdDichvukcb]).ExecuteSingle<DmucDichvukcb>(); return; } } catch { _DmucDichvukcb= null; } finally { AutoLoad = false; } }
public void Update(int IdDichvukcb,string MaDichvukcb,string TenDichvukcb,short IdKieukham,short IdKhoaphong,short IdBacsy,short IdDoituongKcb,short IdPhongkham,decimal DonGia,decimal? PhuthuDungtuyen,decimal? PhuthuTraituyen,decimal? DongiaNgoaigio,decimal? PhuthuNgoaigio,string MaDoituongKcb,int? IdPhikemtheo,int? IdPhikemtheongoaigio,string NhomBaocao,byte? TuTuc) { DmucDichvukcb item = new DmucDichvukcb(); item.MarkOld(); item.IsLoaded = true; item.IdDichvukcb = IdDichvukcb; item.MaDichvukcb = MaDichvukcb; item.TenDichvukcb = TenDichvukcb; item.IdKieukham = IdKieukham; item.IdKhoaphong = IdKhoaphong; item.IdBacsy = IdBacsy; item.IdDoituongKcb = IdDoituongKcb; item.IdPhongkham = IdPhongkham; item.DonGia = DonGia; item.PhuthuDungtuyen = PhuthuDungtuyen; item.PhuthuTraituyen = PhuthuTraituyen; item.DongiaNgoaigio = DongiaNgoaigio; item.PhuthuNgoaigio = PhuthuNgoaigio; item.MaDoituongKcb = MaDoituongKcb; item.IdPhikemtheo = IdPhikemtheo; item.IdPhikemtheongoaigio = IdPhikemtheongoaigio; item.NhomBaocao = NhomBaocao; item.TuTuc = TuTuc; item.Save(UserName); }
private void PerformActionInsert() { var objDmucDichvukcb = new DmucDichvukcb(); objDmucDichvukcb.MaDichvukcb = Utility.sDbnull(txtCode.Text.Trim(), ""); objDmucDichvukcb.MaGia = Utility.sDbnull(txtmagiabhyt.Text.Trim(), ""); objDmucDichvukcb.HoatDong = chkhoatdong.Checked; objDmucDichvukcb.TenDichvukcb = Utility.sDbnull(txtName.Text, ""); objDmucDichvukcb.IdKieukham = Utility.Int16Dbnull(cboLoaiKham.SelectedValue, -1); objDmucDichvukcb.IdKhoaphong = Utility.Int16Dbnull(cboDepartment1.SelectedValue, -1); objDmucDichvukcb.IdBacsy = Convert.ToInt16(cboBacSy.Items.Count > 0 ? Utility.Int16Dbnull(cboBacSy.SelectedValue, -1) : -1); objDmucDichvukcb.MotaThem = Utility.DoTrim(txtDesc.Text); objDmucDichvukcb.SttHthi = Utility.Int16Dbnull(nmrSTT.Value); objDmucDichvukcb.IdDoituongKcb = Utility.Int16Dbnull(cboDoituong.SelectedValue, -1); DmucDoituongkcb objectType = DmucDoituongkcb.FetchByID(objDmucDichvukcb.IdDoituongKcb); if (objectType != null) { objDmucDichvukcb.MaDoituongKcb = Utility.sDbnull(objectType.MaDoituongKcb, ""); } else { objDmucDichvukcb.MaDoituongKcb = "ALL"; } DmucKieukham objKieukham = DmucKieukham.FetchByID(Utility.Int16Dbnull(cboLoaiKham.SelectedValue, -1)); if (objKieukham != null) { objDmucDichvukcb.NhomBaocao = Utility.sDbnull(objKieukham.NhomBaocao, ""); } else { objDmucDichvukcb.NhomBaocao = "-1"; } objDmucDichvukcb.IdPhongkham = Utility.Int16Dbnull(cboRoomDept.SelectedValue); objDmucDichvukcb.PhuthuDungtuyen = Utility.DecimaltoDbnull(txtPTDT.Text, 0); objDmucDichvukcb.PhuthuTraituyen = Utility.DecimaltoDbnull(txtPTTT.Text, 0); objDmucDichvukcb.DonGia = Utility.DecimaltoDbnull(txtDongia.Text, 0); objDmucDichvukcb.DongiaNgoaigio = Utility.DecimaltoDbnull(txtGiangoaigio.Text, 0); objDmucDichvukcb.PhuthuNgoaigio = Utility.DecimaltoDbnull(txtPhuthungoaigio.Text, 0); objDmucDichvukcb.TuTuc = Utility.Bool2byte(chkTutuc.Checked); objDmucDichvukcb.MaBhyt = Utility.sDbnull(txtMaBhyt.Text.Trim(), ""); objDmucDichvukcb.IsNew = true; objDmucDichvukcb.Save(); DataRow dr = m_dtDataRelation.NewRow(); dr[DmucDichvukcb.Columns.IdDichvukcb] = Utility.Int32Dbnull( _Query.GetMax(DmucDichvukcb.Columns.IdDichvukcb), -1); dr[DmucDichvukcb.Columns.IdDoituongKcb] = Utility.DecimaltoDbnull(cboDoituong.SelectedValue); dr[DmucDichvukcb.Columns.IdKhoaphong] = Utility.Int16Dbnull(cboDepartment1.SelectedValue, -1); dr[DmucDichvukcb.Columns.IdPhongkham] = Utility.Int16Dbnull(cboRoomDept.SelectedValue, -1); dr[DmucDichvukcb.Columns.IdBacsy] = cboBacSy.Items.Count > 0 ? Utility.Int16Dbnull(cboBacSy.SelectedValue, -1) : -1; dr[DmucDichvukcb.Columns.DonGia] = Utility.DecimaltoDbnull(txtDongia.Text, 0); dr[DmucDichvukcb.Columns.PhuthuDungtuyen] = Utility.DecimaltoDbnull(txtPTDT.Text, 0); dr[DmucDichvukcb.Columns.PhuthuTraituyen] = Utility.DecimaltoDbnull(txtPTTT.Text, 0); dr[DmucDichvukcb.Columns.DongiaNgoaigio] = Utility.DecimaltoDbnull(txtGiangoaigio.Text, 0); dr[DmucDichvukcb.Columns.PhuthuNgoaigio] = Utility.DecimaltoDbnull(txtPhuthungoaigio.Text, 0); dr[DmucDichvukcb.Columns.MotaThem] = Utility.DoTrim(txtDesc.Text); dr[DmucDichvukcb.Columns.SttHthi] = Utility.Int16Dbnull(nmrSTT.Value, 1); dr[DmucDichvukcb.Columns.TuTuc] = Utility.Bool2byte(chkTutuc.Checked); dr[DmucDichvukcb.Columns.HoatDong] = Utility.Bool2byte(chkhoatdong.Checked); dr["ten_phong"] = cboRoomDept.Text; dr[DmucDichvukcb.Columns.IdKieukham] = Utility.Int16Dbnull(cboLoaiKham.SelectedValue, -1); dr[DmucKieukham.Columns.TenKieukham] = cboLoaiKham.Text; dr[DmucDichvukcb.Columns.MaDichvukcb] = txtCode.Text.Trim(); dr[DmucDichvukcb.Columns.MaBhyt] = txtMaBhyt.Text.Trim(); dr[DmucDichvukcb.Columns.MaGia] = txtmagiabhyt.Text.Trim(); dr[DmucDichvukcb.Columns.TenDichvukcb] = txtName.Text.Trim(); dr["ten_khoa"] = cboDepartment1.SelectedIndex <= -1 ? "Tất cả các khoa KCB" : cboDepartment1.Text; dr["ten_bacsi"] = cboBacSy.SelectedIndex > 0 ? cboBacSy.Text : ""; dr[DmucDoituongkcb.Columns.TenDoituongKcb] = objectType != null ? cboDoituong.Text : "Tất cả các đối tượng"; m_dtDataRelation.Rows.Add(dr); //this.Close(); }