/// <summary> /// hàm thực hiện việc xử lý thông tin chuyển khoa /// </summary> private void ProcessChuyenKhoa() { DataRow query = (from khoa in PDanhSachPhanBuongGiuong.AsEnumerable() where Utility.Int32Dbnull(khoa[NoitruPhanbuonggiuong.Columns.Id]) == Utility.Int32Dbnull(Utility.Int32Dbnull(txtPatientDept_ID.Text)) select khoa).FirstOrDefault(); if (query != null) { NoitruDmucBuong objRoom = NoitruDmucBuong.FetchByID(Utility.Int32Dbnull(grdBuong.GetValue(NoitruDmucBuong.Columns.IdBuong))); if (objRoom != null) { query[NoitruDmucBuong.Columns.IdBuong] = Utility.Int32Dbnull(objRoom.IdBuong, -1); query[NoitruDmucBuong.Columns.TenBuong] = Utility.sDbnull(objRoom.TenBuong); } NoitruDmucGiuongbenh objBed = NoitruDmucGiuongbenh.FetchByID( Utility.Int32Dbnull(grdGiuong.GetValue(NoitruDmucGiuongbenh.Columns.IdGiuong))); if (objBed != null) { query[NoitruDmucGiuongbenh.Columns.IdGiuong] = Utility.Int32Dbnull(objBed.IdGiuong, -1); query[NoitruDmucGiuongbenh.Columns.TenGiuong] = Utility.sDbnull(objBed.TenGiuong); } query[NoitruPhanbuonggiuong.Columns.Id] = Utility.sDbnull(txtPatientDept_ID.Text); query.AcceptChanges(); } }
private void cmdXoaGiuong_Click(object sender, EventArgs e) { if (grdBed.GetCheckedRows().Length <= 0) { Utility.ShowMsg("Bạn chưa chọn bản ghi nào", "Thông báo", MessageBoxIcon.Error); return; } foreach (GridEXRow gridExRow in grdBed.GetCheckedRows()) { int idgiuong = Utility.Int32Dbnull(gridExRow.Cells[NoitruDmucGiuongbenh.Columns.IdGiuong].Value); string TenGiuong = Utility.sDbnull(gridExRow.Cells[NoitruDmucGiuongbenh.Columns.TenGiuong].Value); SqlQuery sqlQuery = new Select().From(NoitruPhanbuonggiuong.Schema) .Where(NoitruPhanbuonggiuong.Columns.IdGiuong).IsEqualTo(idgiuong); if (sqlQuery.GetRecordCount() > 0) { Utility.ShowMsg("Giường nội trú " + TenGiuong + " đã được sử dụng trong quá trình phân buồng giường, Bạn không thể xóa\n Mời bạn xem lại", "Thông báo"); return; } } if (Utility.AcceptQuestion("Bạn có muốn xóa thông tin bản ghi đang chọn không ?", "Thông báo", true)) { foreach (GridEXRow gridExRow in grdBed.GetCheckedRows()) { short idphong = Utility.Int16Dbnull(gridExRow.Cells[NoitruDmucGiuongbenh.Columns.IdGiuong].Value); NoitruDmucGiuongbenh.Delete(idphong); gridExRow.Delete(); } grdBed.UpdateData(); m_dtDataGiuong.AcceptChanges(); } ModifyCommand(); }
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(); } }
private void cmdThemGiuong_Click(object sender, EventArgs e) { var objBed = new NoitruDmucGiuongbenh(); var frm = new frm_Add_GiuongNoiTru(); frm.objBed = objBed; frm.m_enAct = action.Insert; frm.p_dtDataGiuong = m_dtDataGiuong; frm.grdList = grdBed; frm.MyGetData = new frm_Add_GiuongNoiTru.timkiem(LoadData); frm.ShowDialog(); ModifyCommand(); }
private void BindData() { SqlQuery sqlQuery = new Select().From(KcbLuotkham.Schema) .Where(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(txtMaLanKham.Text); if (sqlQuery.GetRecordCount() > 0) { objLuotkham = sqlQuery.ExecuteSingle <KcbLuotkham>(); if (objLuotkham != null) { txtMaLanKham.Text = Utility.sDbnull(objLuotkham.MaLuotkham); txtSoBHYT.Text = Utility.sDbnull(objLuotkham.MatheBhyt); DmucKhoaphong objDmucKhoaphong = DmucKhoaphong.FetchByID(objLuotkham.IdKhoanoitru); if (objDmucKhoaphong != null) { txtDepartmentName.Tag = Utility.sDbnull(objDmucKhoaphong.IdKhoaphong); txtDepartment_ID.Text = Utility.sDbnull(objDmucKhoaphong.IdKhoaphong); txtDepartmentName.Text = Utility.sDbnull(objDmucKhoaphong.TenKhoaphong); } KcbDanhsachBenhnhan objPatientInfo = KcbDanhsachBenhnhan.FetchByID(objLuotkham.IdBenhnhan); if (objPatientInfo != null) { txtPatient_Name.Text = Utility.sDbnull(objPatientInfo.TenBenhnhan); txtPatient_ID.Text = Utility.sDbnull(objLuotkham.IdBenhnhan); txtNamSinh.Text = Utility.sDbnull(objPatientInfo.NamSinh); txtTuoi.Text = Utility.sDbnull(DateTime.Now.Year - objPatientInfo.NamSinh); txtPatientSex.Text = objPatientInfo.GioiTinh;// Utility.Int32Dbnull(objPatientInfo.PatientSex) == 0 ? "Nam" : "Nữ"; } objPhanbuonggiuong = NoitruPhanbuonggiuong.FetchByID(objLuotkham.IdRavien); dtNgayvao.Value = objPhanbuonggiuong.NgayVaokhoa; if (objPhanbuonggiuong != null) { txtPatientDept_ID.Text = Utility.sDbnull(objPhanbuonggiuong.Id); NoitruDmucBuong objRoom = NoitruDmucBuong.FetchByID(objPhanbuonggiuong.IdBuong); if (objRoom != null) { txtSoPhong.Text = Utility.sDbnull(objRoom.TenBuong); txtSoPhong.Tag = Utility.sDbnull(objPhanbuonggiuong.IdBuong); } NoitruDmucGiuongbenh objNoitruDmucGiuongbenh = NoitruDmucGiuongbenh.FetchByID(objPhanbuonggiuong.IdGiuong); if (objNoitruDmucGiuongbenh != null) { txtSoGiuong.Text = Utility.sDbnull(objNoitruDmucGiuongbenh.TenGiuong); txtSoGiuong.Tag = Utility.sDbnull(objPhanbuonggiuong.IdGiuong); } } } } ModifyCommand(); }
private void cmdSuaGiuong_Click(object sender, EventArgs e) { int idphong = Utility.Int32Dbnull(grdBed.GetValue(NoitruDmucGiuongbenh.Columns.IdGiuong)); NoitruDmucGiuongbenh objBed = NoitruDmucGiuongbenh.FetchByID(idphong); if (objBed != null) { var frm = new frm_Add_GiuongNoiTru(); frm.objBed = objBed; frm.m_enAct = action.Update; frm.p_dtDataGiuong = m_dtDataGiuong; frm.grdList = grdBed; frm.MyGetData = new frm_Add_GiuongNoiTru.timkiem(LoadData); frm.ShowDialog(); } ModifyCommand(); }
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 static void LayThongTinGia(NoitruPhanbuonggiuong objPhanbuonggiuong, KcbLuotkham objPatientExam) { objPhanbuonggiuong.TuTuc = 0; SqlQuery sqlQuery = new Select().From <NoitruQheDoituongBuonggiuong>() .Where(NoitruQheDoituongBuonggiuong.Columns.IdGiuong).IsEqualTo(objPhanbuonggiuong.IdGiuong) .And(NoitruQheDoituongBuonggiuong.Columns.MaDoituongKcb).IsEqualTo(objPatientExam.MaDoituongKcb); NoitruQheDoituongBuonggiuong objRoomBedObjectType = sqlQuery.ExecuteSingle <NoitruQheDoituongBuonggiuong>(); if (objRoomBedObjectType != null) { objPhanbuonggiuong.DonGia = Utility.DecimaltoDbnull(objRoomBedObjectType.DonGia); objPhanbuonggiuong.PhuThu = Utility.Byte2Bool(objPatientExam.DungTuyen) ? Utility.DecimaltoDbnull(objRoomBedObjectType.PhuthuDungtuyen) : Utility.DecimaltoDbnull(objRoomBedObjectType.PhuthuTraituyen); NoitruDmucGiuongbenh objLBed = NoitruDmucGiuongbenh.FetchByID(objPhanbuonggiuong.IdGiuong); { objPhanbuonggiuong.TuTuc = objLBed.TthaiTunguyen; objPhanbuonggiuong.TenHienthi = Utility.sDbnull(objLBed.TenGiuong); objPhanbuonggiuong.GiaGoc = Utility.DecimaltoDbnull(objLBed.DonGia); objPhanbuonggiuong.KieuThue = "GIUONG"; } } else { NoitruDmucGiuongbenh objLBed = NoitruDmucGiuongbenh.FetchByID(objPhanbuonggiuong.IdGiuong); if (objLBed != null) { objPhanbuonggiuong.TenHienthi = Utility.sDbnull(objLBed.TenGiuong); objPhanbuonggiuong.DonGia = Utility.DecimaltoDbnull(objLBed.DonGia); objPhanbuonggiuong.PhuThu = Utility.DecimaltoDbnull(0); objPhanbuonggiuong.TuTuc = objLBed.TthaiTunguyen; objPhanbuonggiuong.KieuThue = "GIUONG"; objPhanbuonggiuong.GiaGoc = Utility.DecimaltoDbnull(objLBed.DonGia); if (!THU_VIEN_CHUNG.IsBaoHiem(objPatientExam.IdLoaidoituongKcb)) { objPhanbuonggiuong.TuTuc = 0; } } } objPhanbuonggiuong.TrongGoi = 0; // Utility.ByteDbnull(objPhanbuonggiuong.TrongGoi); if (objPhanbuonggiuong.IdGiuong > 0 || objPhanbuonggiuong.IdBuong > 0) //Có giường thì mới tính { TinhToanPtramBHYT.TinhPhanTramBHYT(objPhanbuonggiuong, objPatientExam, Utility.DecimaltoDbnull(objPatientExam.PtramBhytGoc)); } }
public void Insert(string MaGiuong,string TenGiuong,short IdKhoanoitru,short IdBuong,decimal GiaDichvu,decimal? GiaBhyt,decimal? PhuthuDungtuyen,decimal? PhuthuTraituyen,decimal? GiaKhac,short SonguoiToida,string MotaThem,string MaDonvitinh,byte? TrangThai,byte? TthaiTunguyen,byte? DangSudung,short? SttHthi,string TenBhyt) { NoitruDmucGiuongbenh item = new NoitruDmucGiuongbenh(); item.MaGiuong = MaGiuong; item.TenGiuong = TenGiuong; item.IdKhoanoitru = IdKhoanoitru; item.IdBuong = IdBuong; item.GiaDichvu = GiaDichvu; item.GiaBhyt = GiaBhyt; item.PhuthuDungtuyen = PhuthuDungtuyen; item.PhuthuTraituyen = PhuthuTraituyen; item.GiaKhac = GiaKhac; 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); }
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) { } }
/// <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(); }
public void Insert(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.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); }
private void BindData() { SqlQuery sqlQuery = new Select().From(KcbLuotkham.Schema) .Where(KcbLuotkham.Columns.MaLuotkham).IsEqualTo(txtMaLanKham.Text); if (sqlQuery.GetRecordCount() > 0) { objLuotkham = sqlQuery.ExecuteSingle <KcbLuotkham>(); if (objLuotkham != null) { txtMaLanKham.Text = Utility.sDbnull(objLuotkham.MaLuotkham); txtSoBHYT.Text = Utility.sDbnull(objLuotkham.MatheBhyt); DmucKhoaphong objLDepartment = DmucKhoaphong.FetchByID(objLuotkham.IdKhoanoitru); if (objLDepartment != null) { txtDepartment_ID.Text = Utility.sDbnull(objLDepartment.IdKhoaphong); txtDepartmentName.Tag = Utility.sDbnull(objLDepartment.IdKhoaphong); txtDepartmentName.Text = Utility.sDbnull(objLDepartment.TenKhoaphong); } KcbDanhsachBenhnhan objPatientInfo = KcbDanhsachBenhnhan.FetchByID(objLuotkham.IdBenhnhan); if (objPatientInfo != null) { txtPatient_Name.Text = Utility.sDbnull(objPatientInfo.TenBenhnhan); txtPatient_ID.Text = Utility.sDbnull(objLuotkham.IdBenhnhan); txtNamSinh.Text = Utility.sDbnull(objPatientInfo.NamSinh); txtTuoi.Text = Utility.sDbnull(DateTime.Now.Year - objPatientInfo.NamSinh); txtPatientSex.Text = objPatientInfo.GioiTinh; // Utility.Int32Dbnull(objPatientInfo.) == 0 ? "Nam" : "Nữ"; } NoitruPhanbuonggiuong objPhanbuonggiuong = NoitruPhanbuonggiuong.FetchByID(IDBuonggiuong); // noitru_nhapvien.LaythongtinBuonggiuongHtai(objLuotkham); if (objPhanbuonggiuong != null) { dtNgayvao.Value = objPhanbuonggiuong.NgayVaokhoa; txtPatientDept_ID.Text = Utility.sDbnull(objPhanbuonggiuong.Id); NoitruDmucBuong objRoom = NoitruDmucBuong.FetchByID(objPhanbuonggiuong.IdBuong); if (objRoom != null) { txtSoPhong.Text = Utility.sDbnull(objRoom.TenBuong); txtSoPhong.Tag = Utility.sDbnull(objPhanbuonggiuong.IdBuong); } NoitruDmucGiuongbenh objNoitruDmucGiuongbenh = NoitruDmucGiuongbenh.FetchByID(objPhanbuonggiuong.IdGiuong); if (objNoitruDmucGiuongbenh != null) { txtSoGiuong.Text = Utility.sDbnull(objNoitruDmucGiuongbenh.TenGiuong); txtSoGiuong.Tag = Utility.sDbnull(objPhanbuonggiuong.IdGiuong); } } DataTable dtGia = new dmucgiagiuong_busrule().dsGetList("-1").Tables[0]; dtGia.DefaultView.Sort = NoitruGiabuonggiuong.Columns.SttHthi + "," + NoitruGiabuonggiuong.Columns.TenGia; txtGia.Init(dtGia, new List <string>() { NoitruGiabuonggiuong.Columns.IdGia, NoitruGiabuonggiuong.Columns.MaGia, NoitruGiabuonggiuong.Columns.TenGia }); cboGia.DataSource = dtGia; cboGia.DataMember = NoitruGiabuonggiuong.Columns.IdGia; cboGia.ValueMember = NoitruGiabuonggiuong.Columns.IdGia; cboGia.DisplayMember = NoitruGiabuonggiuong.Columns.TenGia; m_dtDataRoom = THU_VIEN_CHUNG.NoitruTimkiembuongTheokhoa(Utility.Int32Dbnull(txtDepartment_ID.Text)); Utility.SetDataSourceForDataGridEx_Basic(grdBuong, m_dtDataRoom, true, true, "1=1", "sluong_giuong_trong desc,ten_buong"); txtRoom_code.Init(m_dtDataRoom, new List <string>() { NoitruDmucBuong.Columns.IdBuong, NoitruDmucBuong.Columns.MaBuong, NoitruDmucBuong.Columns.TenBuong }); if (grdBuong.DataSource != null) { grdBuong.MoveFirst(); } } else { string tempt = txtMaLanKham.Text; ClearControl(); if (m_dtDataRoom != null) { m_dtDataRoom.Clear(); } if (m_dtDatabed != null) { m_dtDataRoom.Clear(); } txtMaLanKham.Text = tempt; txtMaLanKham.SelectAll(); txtMaLanKham.Focus(); } } }