private NoitruDmucGiuongbenh createBed() { NoitruDmucGiuongbenh objBed = new NoitruDmucGiuongbenh(); objBed.IsNew = true; if (m_enAct == action.Update) { objBed = NoitruDmucGiuongbenh.FetchByID(Utility.Int16Dbnull(txtID.Text)); objBed.MarkOld(); objBed.IsNew = false; } objBed.IdKhoanoitru = Utility.Int16Dbnull(cboKhoaNoiTru.SelectedValue); objBed.IdBuong = Utility.Int16Dbnull(txtBuong.MyID); objBed.MotaThem = Utility.sDbnull(txt_Mo_Ta.Text); objBed.SonguoiToida = Utility.Int16Dbnull(txtSuChua.Value); objBed.SttHthi = Utility.Int16Dbnull(txt_STT_HTHI.Value); objBed.MaGiuong = Utility.sDbnull(txtMa.Text); objBed.MaBhyt = Utility.sDbnull(txtMaBHYT.Text); objBed.TenGiuong = Utility.sDbnull(txtTEN.Text); objBed.TenBhyt = Utility.sDbnull(txtTen_BHYT.Text); objBed.MaDonvitinh = txtDonvitinh.myCode; objBed.TthaiTunguyen = Utility.Bool2byte(chktutuc.Checked); objBed.GiaDichvu = Utility.DecimaltoDbnull(txtDongia.Text, 0); objBed.GiaBhyt = Utility.DecimaltoDbnull(txtGiaBHYT.Text, 0); objBed.GiaKhac = Utility.DecimaltoDbnull(txtGiakhac.Text, 0); objBed.PhuthuDungtuyen = Utility.DecimaltoDbnull(txtPTDT.Text, 0); objBed.PhuthuTraituyen = Utility.DecimaltoDbnull(txtPTTT.Text, 0); objBed.TrangThai = (byte?)(chkTrangThai.Checked ? 1 : 0); return(objBed); }
/// <summary> /// hàm thưucj hiện việc cập nhập lại thông tin thành công /// </summary> private void UpdateData() { objBed = createBed(); objBed.MarkOld(); objBed.IsNew = false; objBed.Save(); if (MyGetData != null) { MyGetData(); Utility.GonewRowJanus(grdList, NoitruDmucGiuongbenh.Columns.IdGiuong, Utility.sDbnull(txtID.Text)); } if (chkApDungGia.Checked) { new Delete().From(NoitruQheDoituongBuonggiuong.Schema) .Where(NoitruQheDoituongBuonggiuong.Columns.IdGiuong).IsEqualTo(Utility.Int32Dbnull(txtID.Text)).Execute(); foreach (Janus.Windows.GridEX.GridEXRow gridExRow in grdQuanheGiuong.GetCheckedRows()) { NoitruQheDoituongBuonggiuong objectType = new NoitruQheDoituongBuonggiuong(); objectType.DonGia = (objectType.MaDoituongKcb == "DV" ? Utility.DecimaltoDbnull(gridExRow.Cells[NoitruQheDoituongBuonggiuong.Columns.DonGia].Value, objBed.GiaDichvu) : (objectType.MaDoituongKcb == "BHYT" ? Utility.DecimaltoDbnull(gridExRow.Cells[NoitruQheDoituongBuonggiuong.Columns.DonGia].Value, objBed.GiaBhyt) : Utility.DecimaltoDbnull(gridExRow.Cells[NoitruQheDoituongBuonggiuong.Columns.DonGia].Value, objBed.GiaKhac)) ) ; objectType.PhuthuDungtuyen = Utility.DecimaltoDbnull(gridExRow.Cells[NoitruQheDoituongBuonggiuong.Columns.PhuthuDungtuyen].Value, 0); objectType.PhuthuTraituyen = Utility.DecimaltoDbnull(gridExRow.Cells[NoitruQheDoituongBuonggiuong.Columns.PhuthuTraituyen].Value, 0); objectType.MaDoituongKcb = Utility.sDbnull(gridExRow.Cells[NoitruQheDoituongBuonggiuong.Columns.MaDoituongKcb].Value); SqlQuery sqlQuery = new Select().From(DmucDoituongkcb.Schema).Where(DmucDoituongkcb.Columns.MaDoituongKcb).IsEqualTo( objectType.MaDoituongKcb); DmucDoituongkcb objectType1 = sqlQuery.ExecuteSingle <DmucDoituongkcb>(); if (objectType1 != null) { objectType.IdLoaidoituongKcb = Utility.Int32Dbnull(objectType1.IdLoaidoituongKcb); } objectType.KieuThue = "GIUONG"; // DmucDoituongkcb objectType1=DmucDoituongkcb.FetchByID() objectType.IdBuong = Utility.Int16Dbnull(txtBuong.MyID); objectType.IdGiuong = Utility.Int16Dbnull(objBed.IdGiuong, -1); objectType.IsNew = true; objectType.Save(); } } Utility.SetMsg(lblMsg, "Bạn thực hiện sửa thông tin thành công", true); if (chkthemmoilientuc.Checked) { ClearControl(); } else { this.Close(); } }
void grdBed_UpdatingCell(object sender, UpdatingCellEventArgs e) { try { if (!Utility.isValidGrid(grdBed)) { return; } if (e.InitialValue.ToString() != e.Value.ToString()) { NoitruDmucGiuongbenh _obj = NoitruDmucGiuongbenh.FetchByID(Utility.Int32Dbnull(Utility.GetValueFromGridColumn(grdBed, NoitruDmucGiuongbenh.Columns.IdGiuong))); _obj.MaGiuong = e.Column.DataMember.ToUpper() == NoitruDmucGiuongbenh.Columns.MaGiuong.ToUpper() ? e.Value.ToString() : Utility.sDbnull(Utility.GetValueFromGridColumn(grdBed, NoitruDmucGiuongbenh.Columns.MaGiuong), ""); _obj.TenGiuong = e.Column.DataMember.ToUpper() == NoitruDmucGiuongbenh.Columns.TenGiuong.ToUpper() ? e.Value.ToString() : Utility.sDbnull(Utility.GetValueFromGridColumn(grdBed, NoitruDmucGiuongbenh.Columns.TenGiuong), ""); _obj.GiaDichvu = e.Column.DataMember.ToUpper() == NoitruDmucGiuongbenh.Columns.GiaDichvu.ToUpper() ? (decimal)e.Value : Utility.DecimaltoDbnull(Utility.GetValueFromGridColumn(grdBed, NoitruDmucGiuongbenh.Columns.GiaDichvu), 0); _obj.GiaBhyt = e.Column.DataMember.ToUpper() == NoitruDmucGiuongbenh.Columns.GiaBhyt.ToUpper() ? (decimal)e.Value : Utility.DecimaltoDbnull(Utility.GetValueFromGridColumn(grdBed, NoitruDmucGiuongbenh.Columns.GiaBhyt), 0); _obj.GiaKhac = e.Column.DataMember.ToUpper() == NoitruDmucGiuongbenh.Columns.GiaKhac.ToUpper() ? (decimal)e.Value : Utility.DecimaltoDbnull(Utility.GetValueFromGridColumn(grdBed, NoitruDmucGiuongbenh.Columns.GiaKhac), 0); _obj.PhuthuDungtuyen = e.Column.DataMember.ToUpper() == NoitruDmucGiuongbenh.Columns.PhuthuDungtuyen.ToUpper() ? (decimal)e.Value : Utility.DecimaltoDbnull(Utility.GetValueFromGridColumn(grdBed, NoitruDmucGiuongbenh.Columns.PhuthuDungtuyen), 0); _obj.PhuthuTraituyen = e.Column.DataMember.ToUpper() == NoitruDmucGiuongbenh.Columns.PhuthuTraituyen.ToUpper() ? (decimal)e.Value : Utility.DecimaltoDbnull(Utility.GetValueFromGridColumn(grdBed, NoitruDmucGiuongbenh.Columns.PhuthuTraituyen), 0); _obj.SonguoiToida = e.Column.DataMember.ToUpper() == NoitruDmucGiuongbenh.Columns.SonguoiToida.ToUpper() ? (byte)e.Value : Utility.Int16Dbnull(Utility.GetValueFromGridColumn(grdBed, NoitruDmucGiuongbenh.Columns.SonguoiToida), 1); _obj.MotaThem = e.Column.DataMember.ToUpper() == NoitruDmucGiuongbenh.Columns.MotaThem.ToUpper() ? e.Value.ToString() : Utility.sDbnull(Utility.GetValueFromGridColumn(grdBed, NoitruDmucGiuongbenh.Columns.MotaThem), ""); _obj.TrangThai = e.Column.DataMember.ToUpper() == NoitruDmucGiuongbenh.Columns.TrangThai.ToUpper() ? (byte)e.Value : Utility.ByteDbnull(Utility.GetValueFromGridColumn(grdBed, NoitruDmucGiuongbenh.Columns.TrangThai), 1); _obj.TthaiTunguyen = e.Column.DataMember.ToUpper() == NoitruDmucGiuongbenh.Columns.TthaiTunguyen.ToUpper() ? (byte)e.Value : Utility.ByteDbnull(Utility.GetValueFromGridColumn(grdBed, NoitruDmucGiuongbenh.Columns.TthaiTunguyen), 0); _obj.DangSudung = e.Column.DataMember.ToUpper() == NoitruDmucGiuongbenh.Columns.DangSudung.ToUpper() ? (byte)e.Value : Utility.ByteDbnull(Utility.GetValueFromGridColumn(grdBed, NoitruDmucGiuongbenh.Columns.DangSudung), 1); _obj.SttHthi = e.Column.DataMember.ToUpper() == NoitruDmucGiuongbenh.Columns.SttHthi.ToUpper() ? (Int16)e.Value : Utility.Int16Dbnull(Utility.GetValueFromGridColumn(grdBed, NoitruDmucGiuongbenh.Columns.SttHthi), 1); _obj.TenBhyt = e.Column.DataMember.ToUpper() == NoitruDmucGiuongbenh.Columns.TenBhyt.ToUpper() ? e.Value.ToString() : Utility.sDbnull(Utility.GetValueFromGridColumn(grdBed, NoitruDmucGiuongbenh.Columns.TenBhyt), ""); _obj.IsNew = false; _obj.MarkOld(); SqlQuery sqlQuery = new Select().From(NoitruDmucGiuongbenh.Schema) .Where(NoitruDmucGiuongbenh.Columns.IdBuong).IsEqualTo(_obj.IdBuong) .And(NoitruDmucGiuongbenh.Columns.MaGiuong).IsEqualTo(_obj.MaGiuong) .And(NoitruDmucGiuongbenh.Columns.IdGiuong).IsNotEqualTo(_obj.IdGiuong); if (sqlQuery.GetRecordCount() > 0) { Utility.ShowMsg("Mã giường đã tồn tại. Đề nghị bạn nhập mã khác", "Thông báo", MessageBoxIcon.Warning); return; } _obj.Save(); } } catch (Exception ex) { } }
public void Update(short IdGiuong,string MaGiuong,string TenGiuong,short IdKhoanoitru,short IdBuong,decimal DonGia,short SonguoiToida,string MotaThem,string MaDonvitinh,byte? TrangThai,byte? TthaiTunguyen,byte? DangSudung,short? SttHthi,string TenBhyt) { NoitruDmucGiuongbenh item = new NoitruDmucGiuongbenh(); item.MarkOld(); item.IsLoaded = true; item.IdGiuong = IdGiuong; item.MaGiuong = MaGiuong; item.TenGiuong = TenGiuong; item.IdKhoanoitru = IdKhoanoitru; item.IdBuong = IdBuong; item.DonGia = DonGia; item.SonguoiToida = SonguoiToida; item.MotaThem = MotaThem; item.MaDonvitinh = MaDonvitinh; item.TrangThai = TrangThai; item.TthaiTunguyen = TthaiTunguyen; item.DangSudung = DangSudung; item.SttHthi = SttHthi; item.TenBhyt = TenBhyt; item.Save(UserName); }
/// <summary> /// hàm thưucj hiện việc cập nhập lại thông tin thành công /// </summary> private void UpdateData() { objBed= createBed(); objBed.MarkOld(); objBed.IsNew = false; objBed.Save(); if (MyGetData != null) { MyGetData(); Utility.GonewRowJanus(grdList, NoitruDmucGiuongbenh.Columns.IdGiuong, Utility.sDbnull(txtID.Text)); } if (chkApDungGia.Checked) { new Delete().From(NoitruQheDoituongBuonggiuong.Schema) .Where(NoitruQheDoituongBuonggiuong.Columns.IdGiuong).IsEqualTo(Utility.Int32Dbnull(txtID.Text)).Execute(); foreach (Janus.Windows.GridEX.GridEXRow gridExRow in grdQuanheGiuong.GetCheckedRows()) { NoitruQheDoituongBuonggiuong objectType = new NoitruQheDoituongBuonggiuong(); objectType.DonGia = (objectType.MaDoituongKcb == "DV" ? Utility.DecimaltoDbnull(gridExRow.Cells[NoitruQheDoituongBuonggiuong.Columns.DonGia].Value, objBed.GiaDichvu) : (objectType.MaDoituongKcb == "BHYT" ? Utility.DecimaltoDbnull(gridExRow.Cells[NoitruQheDoituongBuonggiuong.Columns.DonGia].Value, objBed.GiaBhyt) : Utility.DecimaltoDbnull(gridExRow.Cells[NoitruQheDoituongBuonggiuong.Columns.DonGia].Value, objBed.GiaKhac)) ) ; objectType.PhuthuDungtuyen = Utility.DecimaltoDbnull(gridExRow.Cells[NoitruQheDoituongBuonggiuong.Columns.PhuthuDungtuyen].Value,0); objectType.PhuthuTraituyen = Utility.DecimaltoDbnull(gridExRow.Cells[NoitruQheDoituongBuonggiuong.Columns.PhuthuTraituyen].Value,0); objectType.MaDoituongKcb = Utility.sDbnull(gridExRow.Cells[NoitruQheDoituongBuonggiuong.Columns.MaDoituongKcb].Value); SqlQuery sqlQuery = new Select().From(DmucDoituongkcb.Schema).Where(DmucDoituongkcb.Columns.MaDoituongKcb).IsEqualTo( objectType.MaDoituongKcb); DmucDoituongkcb objectType1 = sqlQuery.ExecuteSingle<DmucDoituongkcb>(); if (objectType1 != null) { objectType.IdLoaidoituongKcb = Utility.Int32Dbnull(objectType1.IdLoaidoituongKcb); } objectType.KieuThue = "GIUONG"; // DmucDoituongkcb objectType1=DmucDoituongkcb.FetchByID() objectType.IdBuong = Utility.Int16Dbnull(txtBuong.MyID); objectType.IdGiuong = Utility.Int16Dbnull(objBed.IdGiuong, -1); objectType.IsNew = true; objectType.Save(); } } Utility.SetMsg(lblMsg, "Bạn thực hiện sửa thông tin thành công", true); if (chkthemmoilientuc.Checked) { ClearControl(); } else this.Close(); }
private void MultiInsertData() { try { Int16 STTHthi=Utility.Int16Dbnull(txt_STT_HTHI.Text); for (int i = Utility.Int32Dbnull(Utility.DecimaltoDbnull(txtCodefrom.Text), 0); i <= Utility.Int32Dbnull(Utility.DecimaltoDbnull(txtCode2.Text), 0); i++) { NoitruDmucGiuongbenh objBed = new NoitruDmucGiuongbenh(); objBed.IdKhoanoitru = Utility.Int16Dbnull(cboKhoaNoiTru.SelectedValue); objBed.IdBuong = Utility.Int16Dbnull(txtBuong.MyID); objBed.MotaThem = Utility.sDbnull(txt_Mo_Ta.Text); objBed.SonguoiToida = Utility.Int16Dbnull(txtSuChua.Value); objBed.SttHthi = Utility.Int16Dbnull(txt_STT_HTHI.Value); objBed.MaGiuong = Utility.sDbnull(txtMa.Text)+i.ToString(); objBed.TenGiuong = Utility.sDbnull(txtTEN.Text)+ " "+i.ToString(); objBed.TenBhyt = Utility.sDbnull(txtTEN.Text) + " " + i.ToString(); objBed.MaDonvitinh = txtDonvitinh.myCode; objBed.TthaiTunguyen = Utility.Bool2byte(chktutuc.Checked); objBed.GiaDichvu = Utility.DecimaltoDbnull(txtDongia.Text, 0); objBed.GiaBhyt = Utility.DecimaltoDbnull(txtGiaBHYT.Text, 0); objBed.GiaKhac = Utility.DecimaltoDbnull(txtGiakhac.Text, 0); objBed.PhuthuDungtuyen = Utility.DecimaltoDbnull(txtPTDT.Text, 0); objBed.PhuthuTraituyen = Utility.DecimaltoDbnull(txtPTTT.Text, 0); objBed.TrangThai = (byte?)(chkTrangThai.Checked ? 1 : 0); NoitruDmucGiuongbenh objcheck = new Select().From(NoitruDmucGiuongbenh.Schema) .Where(NoitruDmucGiuongbenh.Columns.MaGiuong).IsEqualTo(objBed.MaGiuong) .And(NoitruDmucGiuongbenh.Columns.IdKhoanoitru).IsEqualTo(objBed.IdKhoanoitru) .And(NoitruDmucGiuongbenh.Columns.IdBuong).IsEqualTo(objBed.IdBuong) .ExecuteSingle<NoitruDmucGiuongbenh>(); if (objcheck != null) { if (chkAutoupdate.Checked) { objBed.IdGiuong = objcheck.IdGiuong; objBed.MarkOld(); objBed.IsNew = false; } else { continue; } } else { STTHthi += 1; objBed.IsNew = true; } objBed.SttHthi = STTHthi; objBed.Save(); if (objBed != null) { if (chkApDungGia.Checked) { new Delete().From(NoitruQheDoituongBuonggiuong.Schema) .Where(NoitruQheDoituongBuonggiuong.Columns.IdGiuong).IsEqualTo(Utility.Int32Dbnull(txtID.Text)).Execute(); foreach (Janus.Windows.GridEX.GridEXRow gridExRow in grdQuanheGiuong.GetCheckedRows()) { NoitruQheDoituongBuonggiuong objectType = new NoitruQheDoituongBuonggiuong(); objectType.DonGia =(objectType.MaDoituongKcb=="DV"? Utility.DecimaltoDbnull(gridExRow.Cells[NoitruQheDoituongBuonggiuong.Columns.DonGia].Value, objBed.GiaDichvu) :(objectType.MaDoituongKcb=="BHYT"? Utility.DecimaltoDbnull(gridExRow.Cells[NoitruQheDoituongBuonggiuong.Columns.DonGia].Value, objBed.GiaBhyt): Utility.DecimaltoDbnull(gridExRow.Cells[NoitruQheDoituongBuonggiuong.Columns.DonGia].Value, objBed.GiaKhac)) ) ; objectType.PhuthuDungtuyen = Utility.DecimaltoDbnull(gridExRow.Cells[NoitruQheDoituongBuonggiuong.Columns.PhuthuDungtuyen].Value,0); objectType.PhuthuTraituyen = Utility.DecimaltoDbnull(gridExRow.Cells[NoitruQheDoituongBuonggiuong.Columns.PhuthuTraituyen].Value,0); objectType.MaDoituongKcb = Utility.sDbnull(gridExRow.Cells[NoitruQheDoituongBuonggiuong.Columns.MaDoituongKcb].Value); // DmucDoituongkcb objectType1=DmucDoituongkcb.FetchByID() SqlQuery sqlQuery = new Select().From(DmucDoituongkcb.Schema).Where(DmucDoituongkcb.Columns.MaDoituongKcb).IsEqualTo( objectType.MaDoituongKcb); DmucDoituongkcb objectType1 = sqlQuery.ExecuteSingle<DmucDoituongkcb>(); if (objectType1 != null) { objectType.IdLoaidoituongKcb = Utility.Int32Dbnull(objectType1.IdLoaidoituongKcb); } objectType.KieuThue = "GIUONG"; objectType.IdBuong = Utility.Int16Dbnull(txtBuong.MyID); objectType.IdGiuong = Utility.Int16Dbnull(objBed.IdGiuong, -1); objectType.IsNew = true; objectType.Save(); } } } } if (MyGetData != null) { MyGetData(); Utility.GonewRowJanus(grdList, NoitruDmucGiuongbenh.Columns.IdGiuong, Utility.sDbnull(txtID.Text)); } Utility.SetMsg(lblMsg, "Bạn thực hiện thêm mới thành công", true); if (chkthemmoilientuc.Checked) ClearControl(); else Close(); } catch (Exception) { } }
private NoitruDmucGiuongbenh createBed() { NoitruDmucGiuongbenh objBed=new NoitruDmucGiuongbenh(); objBed.IsNew = true; if (m_enAct == action.Update) { objBed = NoitruDmucGiuongbenh.FetchByID(Utility.Int16Dbnull(txtID.Text)); objBed.MarkOld(); objBed.IsNew = false; } objBed.IdKhoanoitru = Utility.Int16Dbnull(cboKhoaNoiTru.SelectedValue); objBed.IdBuong = Utility.Int16Dbnull(txtBuong.MyID); objBed.MotaThem = Utility.sDbnull(txt_Mo_Ta.Text); objBed.SonguoiToida = Utility.Int16Dbnull(txtSuChua.Value); objBed.SttHthi = Utility.Int16Dbnull(txt_STT_HTHI.Value); objBed.MaGiuong = Utility.sDbnull(txtMa.Text); objBed.TenGiuong = Utility.sDbnull(txtTEN.Text); objBed.TenBhyt = Utility.sDbnull(txtTen_BHYT.Text); objBed.MaDonvitinh = txtDonvitinh.myCode; objBed.TthaiTunguyen = Utility.Bool2byte(chktutuc.Checked); objBed.GiaDichvu = Utility.DecimaltoDbnull( txtDongia.Text,0); objBed.GiaBhyt = Utility.DecimaltoDbnull(txtGiaBHYT.Text, 0); objBed.GiaKhac = Utility.DecimaltoDbnull(txtGiakhac.Text, 0); objBed.PhuthuDungtuyen = Utility.DecimaltoDbnull(txtPTDT.Text, 0); objBed.PhuthuTraituyen = Utility.DecimaltoDbnull(txtPTTT.Text, 0); objBed.TrangThai = (byte?) (chkTrangThai.Checked ? 1 : 0); return objBed; }
private void MultiInsertData() { try { Int16 STTHthi = Utility.Int16Dbnull(txt_STT_HTHI.Text); for (int i = Utility.Int32Dbnull(Utility.DecimaltoDbnull(txtCodefrom.Text), 0); i <= Utility.Int32Dbnull(Utility.DecimaltoDbnull(txtCode2.Text), 0); i++) { NoitruDmucGiuongbenh objBed = new NoitruDmucGiuongbenh(); objBed.IdKhoanoitru = Utility.Int16Dbnull(cboKhoaNoiTru.SelectedValue); objBed.IdBuong = Utility.Int16Dbnull(txtBuong.MyID); objBed.MotaThem = Utility.sDbnull(txt_Mo_Ta.Text); objBed.SonguoiToida = Utility.Int16Dbnull(txtSuChua.Value); objBed.SttHthi = Utility.Int16Dbnull(txt_STT_HTHI.Value); objBed.MaGiuong = Utility.sDbnull(txtMa.Text) + i.ToString(); objBed.MaBhyt = Utility.sDbnull(txtMaBHYT.Text) + i.ToString(); objBed.TenGiuong = Utility.sDbnull(txtTEN.Text) + " " + i.ToString(); objBed.TenBhyt = Utility.sDbnull(txtTEN.Text) + " " + i.ToString(); objBed.MaDonvitinh = txtDonvitinh.myCode; objBed.TthaiTunguyen = Utility.Bool2byte(chktutuc.Checked); objBed.GiaDichvu = Utility.DecimaltoDbnull(txtDongia.Text, 0); objBed.GiaBhyt = Utility.DecimaltoDbnull(txtGiaBHYT.Text, 0); objBed.GiaKhac = Utility.DecimaltoDbnull(txtGiakhac.Text, 0); objBed.PhuthuDungtuyen = Utility.DecimaltoDbnull(txtPTDT.Text, 0); objBed.PhuthuTraituyen = Utility.DecimaltoDbnull(txtPTTT.Text, 0); objBed.TrangThai = (byte?)(chkTrangThai.Checked ? 1 : 0); NoitruDmucGiuongbenh objcheck = new Select().From(NoitruDmucGiuongbenh.Schema) .Where(NoitruDmucGiuongbenh.Columns.MaGiuong).IsEqualTo(objBed.MaGiuong) .And(NoitruDmucGiuongbenh.Columns.IdKhoanoitru).IsEqualTo(objBed.IdKhoanoitru) .And(NoitruDmucGiuongbenh.Columns.IdBuong).IsEqualTo(objBed.IdBuong) .ExecuteSingle <NoitruDmucGiuongbenh>(); if (objcheck != null) { if (chkAutoupdate.Checked) { objBed.IdGiuong = objcheck.IdGiuong; objBed.MarkOld(); objBed.IsNew = false; } else { continue; } } else { STTHthi += 1; objBed.IsNew = true; } objBed.SttHthi = STTHthi; objBed.Save(); if (objBed != null) { if (chkApDungGia.Checked) { new Delete().From(NoitruQheDoituongBuonggiuong.Schema) .Where(NoitruQheDoituongBuonggiuong.Columns.IdGiuong).IsEqualTo(Utility.Int32Dbnull(txtID.Text)).Execute(); foreach (Janus.Windows.GridEX.GridEXRow gridExRow in grdQuanheGiuong.GetCheckedRows()) { NoitruQheDoituongBuonggiuong objectType = new NoitruQheDoituongBuonggiuong(); objectType.DonGia = (objectType.MaDoituongKcb == "DV"? Utility.DecimaltoDbnull(gridExRow.Cells[NoitruQheDoituongBuonggiuong.Columns.DonGia].Value, objBed.GiaDichvu) :(objectType.MaDoituongKcb == "BHYT"? Utility.DecimaltoDbnull(gridExRow.Cells[NoitruQheDoituongBuonggiuong.Columns.DonGia].Value, objBed.GiaBhyt): Utility.DecimaltoDbnull(gridExRow.Cells[NoitruQheDoituongBuonggiuong.Columns.DonGia].Value, objBed.GiaKhac)) ) ; objectType.PhuthuDungtuyen = Utility.DecimaltoDbnull(gridExRow.Cells[NoitruQheDoituongBuonggiuong.Columns.PhuthuDungtuyen].Value, 0); objectType.PhuthuTraituyen = Utility.DecimaltoDbnull(gridExRow.Cells[NoitruQheDoituongBuonggiuong.Columns.PhuthuTraituyen].Value, 0); objectType.MaDoituongKcb = Utility.sDbnull(gridExRow.Cells[NoitruQheDoituongBuonggiuong.Columns.MaDoituongKcb].Value); // DmucDoituongkcb objectType1=DmucDoituongkcb.FetchByID() SqlQuery sqlQuery = new Select().From(DmucDoituongkcb.Schema).Where(DmucDoituongkcb.Columns.MaDoituongKcb).IsEqualTo( objectType.MaDoituongKcb); DmucDoituongkcb objectType1 = sqlQuery.ExecuteSingle <DmucDoituongkcb>(); if (objectType1 != null) { objectType.IdLoaidoituongKcb = Utility.Int32Dbnull(objectType1.IdLoaidoituongKcb); } objectType.KieuThue = "GIUONG"; objectType.IdBuong = Utility.Int16Dbnull(txtBuong.MyID); objectType.IdGiuong = Utility.Int16Dbnull(objBed.IdGiuong, -1); objectType.IsNew = true; objectType.Save(); } } } } if (MyGetData != null) { MyGetData(); Utility.GonewRowJanus(grdList, NoitruDmucGiuongbenh.Columns.IdGiuong, Utility.sDbnull(txtID.Text)); } Utility.SetMsg(lblMsg, "Bạn thực hiện thêm mới thành công", true); if (chkthemmoilientuc.Checked) { ClearControl(); } else { Close(); } } catch (Exception) { } }