/// <summary> /// Insert một bản ghi vào bảng Danh mục dùng chung /// </summary> /// <param name="obj"></param> /// <returns></returns> public void InsertList(DmucKieukham obj, int intSTTCu, ref string ActResult) { try { ActionResult _act = isExistedRecord(obj.MaKieukham); if (_act == ActionResult.ExistedRecord || _act == ActionResult.Exception) { ActResult = _act.ToString(); return; } //B1: Tim ban ghi co STT=STT moi DmucKieukhamCollection v_lstDmuc = new DmucKieukhamController().FetchByQuery(DmucKieukham.CreateQuery().AddWhere(DmucKieukham.Columns.SttHthi, Comparison.Equals, obj.SttHthi)); if (v_lstDmuc.Count > 0) { new Update(DmucKieukham.Schema).Set(DmucKieukham.Columns.SttHthi).EqualTo(intSTTCu) .Where(DmucKieukham.Columns.IdKieukham).IsEqualTo(v_lstDmuc[0].IdKieukham).Execute(); } obj.IsNew = true; obj.Save(); ActResult = ActionResult.Success.ToString(); } catch { ActResult = ActionResult.Exception.ToString(); } }
/// <summary> /// Đóng gói dữ liệu vào DataTable để gửi lên Webservice xử lý /// </summary> /// <returns></returns> private DmucKieukham GetObject() { try { DmucKieukham obj = new DmucKieukham(); obj.MaKieukham = Utility.DoTrim(txtMa.Text); obj.TenKieukham = Utility.DoTrim(txtTen.Text); obj.NhomBaocao = Utility.sDbnull(cbonhombaocao.SelectedValue, "-1"); obj.TrangThai = Convert.ToByte(chkTrangthai.Checked ? 1 : 0); obj.DonGia = nmrDongia.Value; obj.MaDoituongkcb = cbodoituongkcb.SelectedIndex == 0 ? "ALL" : cbodoituongkcb.SelectedValue.ToString(); if (m_enAct == action.Update) { obj.IdKieukham = Utility.Int16Dbnull(txtID.Text); obj.NguoiSua = globalVariables.UserName; obj.NgaySua = globalVariables.SysDate; } else { obj.NguoiTao = globalVariables.UserName; obj.NgayTao = globalVariables.SysDate; } obj.SttHthi = short.Parse(txtSTT.Text); return(obj); } catch (Exception ex) { Utility.ShowMsg("Lỗi xảy ra khi đóng gói dữ liệu vào DataTable để gửi lên Webservice\n" + ex.Message, "Thông báo"); return(null); } }
private void cboLoaiKham_SelectedIndexChanged(object sender, EventArgs e) { try { if (!m_blnLoaded) { return; } string _RowFilter = "1=1"; DmucKieukham objExamTypeList = DmucKieukham.FetchByID(Utility.Int32Dbnull(cboLoaiKham.SelectedValue)); if (objExamTypeList != null) { if (objExamTypeList.MaDoituongkcb == "ALL") { _RowFilter = string.Format("{0}", "1=1"); } else { _RowFilter = string.Format("{0}='{1}'", DmucDoituongkcb.Columns.MaDoituongKcb, objExamTypeList.MaDoituongkcb); } } v_ObjectTypeList.DefaultView.RowFilter = _RowFilter; v_ObjectTypeList.AcceptChanges(); } catch (Exception ex) { Utility.ShowMsg("Lỗi:" + ex.Message); // throw; } }
/// <summary> /// Update một bản ghi vào bảng Danh mục dùng chung /// </summary> /// <param name="obj"></param> /// <returns></returns> public void UpdateList(DmucKieukham obj, string strOldCode, int intSTTCu, ref string ActResult) { try { ActionResult _act = isExistedRecord4Update(obj.MaKieukham, strOldCode); if (_act == ActionResult.ExistedRecord || _act == ActionResult.Exception) { ActResult = _act.ToString(); return; } //B1: Tim ban ghi co STT=STT moi DmucKieukhamCollection v_lstDmuc = new DmucKieukhamController().FetchByQuery(DmucKieukham.CreateQuery().AddWhere(DmucKieukham.Columns.SttHthi, Comparison.Equals, obj.SttHthi)); if (v_lstDmuc.Count > 0) { new Update(DmucKieukham.Schema).Set(DmucKieukham.Columns.SttHthi).EqualTo(intSTTCu) .Where(DmucKieukham.Columns.MaKieukham).IsEqualTo(v_lstDmuc[0].MaKieukham) .Execute(); } int record = new Update(DmucKieukham.Schema) .Set(DmucKieukham.Columns.MaKieukham).EqualTo(obj.MaKieukham) .Set(DmucKieukham.Columns.TenKieukham).EqualTo(obj.TenKieukham) .Set(DmucKieukham.Columns.DonGia).EqualTo(obj.DonGia) .Set(DmucKieukham.Columns.SttHthi).EqualTo(obj.SttHthi) .Set(DmucKieukham.Columns.MaDoituongkcb).EqualTo(obj.MaDoituongkcb) .Set(DmucKieukham.Columns.NhomBaocao).EqualTo(obj.NhomBaocao) .Set(DmucKieukham.Columns.TrangThai).EqualTo(obj.TrangThai) .Set(DmucKieukham.Columns.NgaySua).EqualTo(obj.NgaySua) .Set(DmucKieukham.Columns.NguoiSua).EqualTo(obj.NguoiSua) .Where(DmucKieukham.Columns.IdKieukham).IsEqualTo(obj.IdKieukham) .Execute(); if (record > 0) { ActResult = ActionResult.Success.ToString(); } else { ActResult = ActionResult.Error.ToString(); } } catch { ActResult = ActionResult.Exception.ToString(); } }
public ActionResult isExistedRecord4Update(string MaMoi, string MaCu) { try { DmucKieukhamCollection v_obj = new DmucKieukhamController().FetchByQuery(DmucKieukham.CreateQuery() .AddWhere(DmucKieukham.Columns.MaKieukham, Comparison.NotEquals, MaCu) ); List <DmucKieukham> q = (from p in v_obj where p.MaKieukham == MaMoi select p).ToList <DmucKieukham>(); if (q.Count() > 0) { return(ActionResult.ExistedRecord); } return(ActionResult.Success); } catch { return(ActionResult.Exception); } }
public short GetMaxSTT(string m_strListType) { try { DmucKieukhamCollection CollectionData = new DmucKieukhamController().FetchByQuery(DmucKieukham.CreateQuery()); Int16 shtMaxSTT = 0; //Phải kiểm tra nếu Có dữ liệu mới lấy STT hiện tại=MaxSTT+1 if (CollectionData.Count > 0) { shtMaxSTT = CollectionData.Max(c => c.SttHthi).Value; } return(Convert.ToInt16(shtMaxSTT + 1)); } catch { return(Convert.ToInt16(1)); } }
public void Insert(string MaKieukham,string TenKieukham,decimal? DonGia,decimal? PhuthuDungtuyen,decimal? PhuthuTraituyen,short? SttHthi,string MaDoituongkcb,string NhomBaocao,byte? TrangThai,string NguoiTao,DateTime? NgayTao,string NguoiSua,DateTime? NgaySua) { DmucKieukham item = new DmucKieukham(); item.MaKieukham = MaKieukham; item.TenKieukham = TenKieukham; item.DonGia = DonGia; item.PhuthuDungtuyen = PhuthuDungtuyen; item.PhuthuTraituyen = PhuthuTraituyen; item.SttHthi = SttHthi; item.MaDoituongkcb = MaDoituongkcb; item.NhomBaocao = NhomBaocao; item.TrangThai = TrangThai; item.NguoiTao = NguoiTao; item.NgayTao = NgayTao; item.NguoiSua = NguoiSua; item.NgaySua = NgaySua; item.Save(UserName); }
/// <summary> /// Thực hiện thêm mới dữ liệu /// </summary> private bool PerformInserAct() { try { //Kiem tra su hop le cua du lieu if (!IsValidInputData()) { return(false); } m_intOldOrder = Convert.ToInt32(txtSTT.Text); string ActResult = ""; DmucKieukham _item = GetObject(); m_BusRules.InsertList(_item, m_intOldOrder, ref ActResult); if (ActResult == ActionResult.Success.ToString()) { txtID.Text = _item.IdKieukham.ToString(); //Cho phép chọn trên lưới để fill dữ liệu xuống Vùng nhập liệu m_blnAllowCurrentCellChanged = true; //Thêm mới dòng này vào DataTable để phản ánh lại lên lưới InsertDataTable(); //Update lại STT nếu có UpdateSTT(m_intOldOrder); //Tự động nhảy đến dòng mới thêm trên lưới Utility.GonewRowJanus(grdList, DmucKieukham.Columns.IdKieukham, txtID.Text.Trim()); //Gán biến dòng hiện thời trên lưới m_intCurrIdx = grdList.CurrentRow.Position; //Quay về trạng thái cancel PerformCancelAction(); //Hiển thị thông báo thành công Utility.SetMsg(lblMsg, "Thêm mới dịch vụ khám thành công", false); if (chkAutoNew.Checked) { cmdNew_Click(cmdNew, new EventArgs()); } else { //Tự động Focus vào nút Sửa cmdNew.Focus(); } } else if (ActResult == ActionResult.ExistedRecord.ToString()) { Utility.SetMsg(lblMsg, m_lstHeaders[0] + "(" + txtMa.Text + ") đã được sử dụng. Đề nghị bạn nhập mã khác!", true); txtMa.Focus(); return(false); } else if (ActResult == ActionResult.Exception.ToString()) { Utility.ShowMsg("Lỗi khi thực hiện thêm mới " + m_strListName + "\n" + ActResult, "Thông báo"); return(false); } return(true); } catch (Exception ex) { return(false); Utility.ShowMsg(ex.Message); } }
/// <summary> /// Đóng gói dữ liệu vào DataTable để gửi lên Webservice xử lý /// </summary> /// <returns></returns> private DmucKieukham GetObject() { try { DmucKieukham obj = new DmucKieukham(); obj.MaKieukham = Utility.DoTrim(txtMa.Text); obj.TenKieukham = Utility.DoTrim(txtTen.Text); obj.NhomBaocao = Utility.sDbnull(cbonhombaocao.SelectedValue, "-1"); obj.TrangThai = Convert.ToByte(chkTrangthai.Checked ? 1 : 0); obj.DonGia =nmrDongia.Value; obj.MaDoituongkcb = cbodoituongkcb.SelectedIndex == 0 ? "ALL" : cbodoituongkcb.SelectedValue.ToString(); if (m_enAct == action.Update) { obj.IdKieukham = Utility.Int16Dbnull(txtID.Text); obj.NguoiSua = globalVariables.UserName; obj.NgaySua = globalVariables.SysDate; } else { obj.NguoiTao = globalVariables.UserName; obj.NgayTao = globalVariables.SysDate; } obj.SttHthi = short.Parse(txtSTT.Text); return obj; } catch (Exception ex) { Utility.ShowMsg("Lỗi xảy ra khi đóng gói dữ liệu vào DataTable để gửi lên Webservice\n" + ex.Message, "Thông báo"); return null; } }
/// <summary> /// Update một bản ghi vào bảng Danh mục dùng chung /// </summary> /// <param name="obj"></param> /// <returns></returns> public void UpdateList(DmucKieukham obj, string strOldCode, int intSTTCu, ref string ActResult) { try { ActionResult _act = isExistedRecord4Update(obj.MaKieukham, strOldCode); if (_act == ActionResult.ExistedRecord || _act == ActionResult.Exception) { ActResult = _act.ToString(); return; } //B1: Tim ban ghi co STT=STT moi DmucKieukhamCollection v_lstDmuc = new DmucKieukhamController().FetchByQuery(DmucKieukham.CreateQuery().AddWhere(DmucKieukham.Columns.SttHthi, Comparison.Equals, obj.SttHthi)); if (v_lstDmuc.Count > 0) { new Update(DmucKieukham.Schema).Set(DmucKieukham.Columns.SttHthi).EqualTo(intSTTCu) .Where(DmucKieukham.Columns.MaKieukham).IsEqualTo(v_lstDmuc[0].MaKieukham) .Execute(); } int record = new Update(DmucKieukham.Schema) .Set(DmucKieukham.Columns.MaKieukham).EqualTo(obj.MaKieukham) .Set(DmucKieukham.Columns.TenKieukham).EqualTo(obj.TenKieukham) .Set(DmucKieukham.Columns.DonGia).EqualTo(obj.DonGia) .Set(DmucKieukham.Columns.SttHthi).EqualTo(obj.SttHthi) .Set(DmucKieukham.Columns.MaDoituongkcb).EqualTo(obj.MaDoituongkcb) .Set(DmucKieukham.Columns.NhomBaocao).EqualTo(obj.NhomBaocao) .Set(DmucKieukham.Columns.TrangThai).EqualTo(obj.TrangThai) .Set(DmucKieukham.Columns.NgaySua).EqualTo(obj.NgaySua) .Set(DmucKieukham.Columns.NguoiSua).EqualTo(obj.NguoiSua) .Where(DmucKieukham.Columns.IdKieukham).IsEqualTo(obj.IdKieukham) .Execute(); if (record > 0) { ActResult = ActionResult.Success.ToString(); } else ActResult = ActionResult.Error.ToString(); } catch { ActResult = ActionResult.Exception.ToString(); } }
/// <summary> /// /hàm thực heien thông tin update thông tin lại /// </summary> private void PerformActionUpdate() { string MaDoituongKcb = "ALL"; string NhomBaocao = "-1"; DmucDoituongkcb objectType = DmucDoituongkcb.FetchByID(Utility.Int16Dbnull(cboDoituong.SelectedValue, -1)); if (objectType != null) { MaDoituongKcb = objectType.MaDoituongKcb; } else { MaDoituongKcb = "ALL"; } DmucKieukham objKieukham = DmucKieukham.FetchByID(Utility.Int16Dbnull(cboLoaiKham.SelectedValue, -1)); if (objKieukham != null) { NhomBaocao = Utility.sDbnull(objKieukham.NhomBaocao, ""); } else { NhomBaocao = "-1"; } int record = new Update(DmucDichvukcb.Schema) .Set(DmucDichvukcb.Columns.IdKhoaphong).EqualTo(Utility.Int16Dbnull(cboDepartment1.SelectedValue, 1)) .Set(DmucDichvukcb.Columns.MaDichvukcb).EqualTo(txtCode.Text.Trim()) .Set(DmucDichvukcb.Columns.HoatDong).EqualTo(chkhoatdong.Checked) .Set(DmucDichvukcb.Columns.MaGia).EqualTo(txtmagiabhyt.Text.Trim()) .Set(DmucDichvukcb.Columns.TenDichvukcb).EqualTo(txtName.Text.Trim()) .Set(DmucDichvukcb.Columns.MotaThem).EqualTo(txtDesc.Text.Trim()) .Set(DmucDichvukcb.Columns.SttHthi).EqualTo(Utility.Int16Dbnull(nmrSTT.Value)) .Set(DmucDichvukcb.Columns.NhomBaocao).EqualTo(NhomBaocao) .Set(DmucDichvukcb.Columns.MaDoituongKcb).EqualTo(MaDoituongKcb) .Set(DmucDichvukcb.Columns.IdPhongkham).EqualTo(Utility.Int16Dbnull(cboRoomDept.SelectedValue, 1)) .Set(DmucDichvukcb.Columns.IdBacsy).EqualTo( Convert.ToInt16(cboBacSy.Items.Count > 0 ? Utility.Int16Dbnull(cboBacSy.SelectedValue, 1) : -1)) .Set(DmucDichvukcb.Columns.IdKieukham).EqualTo(Utility.Int16Dbnull(cboLoaiKham.SelectedValue, 1)) .Set(DmucDichvukcb.Columns.IdDoituongKcb).EqualTo(Utility.Int16Dbnull(cboDoituong.SelectedValue, -1)) .Set(DmucDichvukcb.Columns.DonGia).EqualTo(Utility.DecimaltoDbnull(txtDongia.Text, 0)) .Set(DmucDichvukcb.Columns.DongiaNgoaigio).EqualTo(Utility.DecimaltoDbnull(txtGiangoaigio.Text, 0)) .Set(DmucDichvukcb.Columns.PhuthuNgoaigio).EqualTo(Utility.DecimaltoDbnull(txtPhuthungoaigio.Text, 0)) .Set(DmucDichvukcb.Columns.TuTuc).EqualTo(Utility.Bool2byte(chkTutuc.Checked)) .Set(DmucDichvukcb.Columns.PhuthuDungtuyen).EqualTo(Utility.DecimaltoDbnull(txtPTDT.Text, 0)) .Set(DmucDichvukcb.Columns.PhuthuTraituyen).EqualTo(Utility.DecimaltoDbnull(txtPTTT.Text, 0)) .Where(DmucDichvukcb.Columns.IdDichvukcb).IsEqualTo(Utility.DecimaltoDbnull(txtInsObject_ID.Text, -1)). Execute(); if (record > 0) { DataRow[] dr = m_dtDataRelation.Select(DmucDichvukcb.Columns.IdDichvukcb + "=" + Utility.Int32Dbnull(txtInsObject_ID.Text, -1)); if (dr.GetLength(0) > 0) { dr[0][DmucDichvukcb.Columns.IdDoituongKcb] = Utility.DecimaltoDbnull(cboDoituong.SelectedValue); dr[0][DmucDichvukcb.Columns.IdKhoaphong] = Utility.Int16Dbnull(cboDepartment1.SelectedValue, -1); dr[0][DmucDichvukcb.Columns.IdPhongkham] = Utility.Int16Dbnull(cboRoomDept.SelectedValue, -1); dr[0][DmucDichvukcb.Columns.IdBacsy] = cboBacSy.Items.Count > 0 ? Utility.Int16Dbnull(cboBacSy.SelectedValue, -1) : -1; dr[0][DmucDichvukcb.Columns.IdKieukham] = Utility.Int16Dbnull(cboLoaiKham.SelectedValue, -1); dr[0][DmucKieukham.Columns.TenKieukham] = cboLoaiKham.Text; dr[0]["ten_khoa"] = cboDepartment1.SelectedIndex <= -1 ? "Tất cả các khoa KCB" : cboDepartment1.Text; dr[0]["ten_phong"] = cboRoomDept.Text; dr[0][DmucDichvukcb.Columns.MaDichvukcb] = txtCode.Text.Trim(); dr[0][DmucDichvukcb.Columns.MaBhyt] = txtMaBhyt.Text.Trim(); dr[0][DmucDichvukcb.Columns.MaGia] = txtmagiabhyt.Text.Trim(); dr[0][DmucDichvukcb.Columns.TenDichvukcb] = txtName.Text.Trim(); dr[0]["ten_bacsi"] = cboBacSy.SelectedIndex > 0 ? cboBacSy.Text : ""; dr[0][DmucDichvukcb.Columns.MaDoituongKcb] = objectType != null ? objectType.MaDoituongKcb : "ALL"; dr[0][DmucDoituongkcb.Columns.TenDoituongKcb] = objectType != null ? cboDoituong.Text : "Tất cả các đối tượng"; dr[0][DmucDichvukcb.Columns.MotaThem] = Utility.DoTrim(txtDesc.Text); dr[0][DmucDichvukcb.Columns.SttHthi] = Utility.Int16Dbnull(nmrSTT.Value, 1); dr[0][DmucDichvukcb.Columns.DonGia] = Utility.DecimaltoDbnull(txtDongia.Text, 0); dr[0][DmucDichvukcb.Columns.DongiaNgoaigio] = Utility.DecimaltoDbnull(txtGiangoaigio.Text, 0); dr[0][DmucDichvukcb.Columns.PhuthuNgoaigio] = Utility.DecimaltoDbnull(txtPhuthungoaigio.Text, 0); dr[0][DmucDichvukcb.Columns.TuTuc] = Utility.Bool2byte(chkTutuc.Checked); dr[0][DmucDichvukcb.Columns.HoatDong] = Utility.Bool2byte(chkhoatdong.Checked); dr[0][DmucDichvukcb.Columns.PhuthuDungtuyen] = Utility.DecimaltoDbnull(txtPTDT.Text, 0); dr[0][DmucDichvukcb.Columns.PhuthuTraituyen] = Utility.DecimaltoDbnull(txtPTTT.Text, 0); } m_dtDataRelation.AcceptChanges(); Close(); } else { Utility.ShowMsg("Lỗi trong quá trình cập nhập dữ liệu"); return; } }
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(); }