void grdRoom_UpdatingCell(object sender, UpdatingCellEventArgs e) { try { if (!Utility.isValidGrid(grdRoom)) { return; } if (e.InitialValue.ToString() != e.Value.ToString()) { NoitruDmucBuong _obj = NoitruDmucBuong.FetchByID(Utility.Int32Dbnull(Utility.GetValueFromGridColumn(grdRoom, NoitruDmucBuong.Columns.IdBuong))); _obj.MaBuong = e.Column.DataMember.ToUpper() == NoitruDmucBuong.Columns.MaBuong.ToUpper() ? e.Value.ToString() : Utility.sDbnull(Utility.GetValueFromGridColumn(grdRoom, NoitruDmucBuong.Columns.MaBuong), ""); _obj.TenBuong = e.Column.DataMember.ToUpper() == NoitruDmucBuong.Columns.TenBuong.ToUpper() ? e.Value.ToString() : Utility.sDbnull(Utility.GetValueFromGridColumn(grdRoom, NoitruDmucBuong.Columns.TenBuong), ""); _obj.DonGia = e.Column.DataMember.ToUpper() == NoitruDmucBuong.Columns.DonGia.ToUpper() ? (int)e.Value : Utility.Int32Dbnull(Utility.GetValueFromGridColumn(grdRoom, NoitruDmucBuong.Columns.DonGia), 0); _obj.MotaThem = e.Column.DataMember.ToUpper() == NoitruDmucBuong.Columns.MotaThem.ToUpper() ? e.Value.ToString() : Utility.sDbnull(Utility.GetValueFromGridColumn(grdRoom, NoitruDmucBuong.Columns.MotaThem), ""); _obj.TrangThai = e.Column.DataMember.ToUpper() == NoitruDmucBuong.Columns.TrangThai.ToUpper() ? (byte)e.Value : Utility.ByteDbnull(Utility.GetValueFromGridColumn(grdRoom, NoitruDmucBuong.Columns.TrangThai), 1); _obj.SttHthi = e.Column.DataMember.ToUpper() == NoitruDmucBuong.Columns.SttHthi.ToUpper() ? (Int16)e.Value : Utility.Int16Dbnull(Utility.GetValueFromGridColumn(grdRoom, NoitruDmucBuong.Columns.SttHthi), 1); _obj.IsNew = false; _obj.MarkOld(); _obj.Save(); } } catch (Exception ex) { } }
/// <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 cmdThemMoi_Click(object sender, EventArgs e) { var objRoom = new NoitruDmucBuong(); var frm = new frm_Add_PhongNoiTru(); frm.objRoom = objRoom; frm.m_enAct = action.Insert; frm.p_dtDataPhong = globalVariables.gv_PhongNoitru; frm.MyGetData = new frm_Add_PhongNoiTru.timkiem(LoadData); frm.grdList = grdRoom; 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 cmdSua_Click(object sender, EventArgs e) { int idphong = Utility.Int32Dbnull(grdRoom.GetValue(NoitruDmucBuong.Columns.IdBuong)); NoitruDmucBuong objRoom = NoitruDmucBuong.FetchByID(idphong); if (objRoom != null) { var frm = new frm_Add_PhongNoiTru(); frm.objRoom = objRoom; frm.m_enAct = action.Update; frm.p_dtDataPhong = globalVariables.gv_PhongNoitru; frm.grdList = grdRoom; frm.MyGetData = new frm_Add_PhongNoiTru.timkiem(LoadData); frm.ShowDialog(); } ModifyCommand(); }
/// <summary> /// hàm thực hiện viẹc thêmm ới thông tin /// </summary> private void InsertData() { try { objRoom = new NoitruDmucBuong(); objRoom.IdBuong = -1; objRoom.IdBuong = Utility.Int16Dbnull(txtID.Text); objRoom.MaBuong = Utility.DoTrim(txtMa.Text); objRoom.TenBuong = Utility.DoTrim(txtTEN.Text); objRoom.MotaThem = Utility.DoTrim(txt_Mo_Ta.Text); objRoom.TrangThai = Utility.Bool2byte(chkTrangThai.Checked); objRoom.IdKhoanoitru = Utility.Int16Dbnull(cboKhoaNoiTru.SelectedValue); objRoom.SttHthi = Utility.Int16Dbnull(txt_STT_HTHI.Text); objRoom.IsNew = true; objRoom.Save(); if (objRoom != null) { DataRow newDR = p_dtDataPhong.NewRow(); Utility.FromObjectToDatarow(objRoom, ref newDR); newDR["ten_khoanoitru"] = cboKhoaNoiTru.Text; p_dtDataPhong.Rows.Add(newDR); if (MyGetData != null) { MyGetData(); } Utility.GonewRowJanus(grdList, NoitruDmucBuong.Columns.IdBuong, Utility.sDbnull(txtID.Text)); } Utility.SetMsg(lblMessage, "Bạn thực hiện thêm mới thành công", true); if (chkthemmoilientuc.Checked) { ClearControl(); } else { Close(); } } catch (Exception exception) { Utility.CatchException(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() { try { objRoom = new NoitruDmucBuongController().FetchByID(txtID.Text)[0]; objRoom.IdBuong = Utility.Int16Dbnull(txtID.Text); objRoom.MaBuong = txtMa.Text; objRoom.TenBuong = txtTEN.Text; txt_Mo_Ta.Text = objRoom.MotaThem; objRoom.TrangThai = Utility.Bool2byte(chkTrangThai.Checked); objRoom.IdKhoanoitru = Utility.Int16Dbnull(cboKhoaNoiTru.SelectedValue); objRoom.SttHthi = Utility.Int16Dbnull(txt_STT_HTHI.Text); objRoom.MotaThem = Utility.DoTrim(txt_Mo_Ta.Text); objRoom.IsNew = false; objRoom.MarkOld(); objRoom.Save(); if (MyGetData != null) { DataRow newDR = p_dtDataPhong.Select(NoitruDmucBuong.Columns.IdBuong + "=" + objRoom.IdBuong.ToString())[0]; Utility.FromObjectToDatarow(objRoom, ref newDR); newDR["ten_khoanoitru"] = cboKhoaNoiTru.Text; p_dtDataPhong.AcceptChanges(); MyGetData(); } Utility.GonewRowJanus(grdList, NoitruDmucBuong.Columns.IdBuong, Utility.sDbnull(txtID.Text)); if (chkthemmoilientuc.Checked) { ClearControl(); } else { Close(); } Utility.SetMsg(lblMessage, "Bạn thực hiện sửa thông tin thành công", true); } catch (Exception ex) { Utility.CatchException(ex); } }
private void MultiInsert() { 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++) { objRoom = new NoitruDmucBuong(); objRoom.IdBuong = -1; objRoom.IdBuong = Utility.Int16Dbnull(txtID.Text); objRoom.MaBuong = Utility.DoTrim(txtMa.Text) + i.ToString(); objRoom.TenBuong = Utility.DoTrim(txtTEN.Text) + " " + i.ToString(); objRoom.MotaThem = Utility.DoTrim(txt_Mo_Ta.Text); objRoom.TrangThai = Utility.Bool2byte(chkTrangThai.Checked); objRoom.IdKhoanoitru = Utility.Int16Dbnull(cboKhoaNoiTru.SelectedValue); NoitruDmucBuong objcheck = new Select().From(NoitruDmucBuong.Schema).Where(NoitruDmucBuong.Columns.MaBuong).IsEqualTo(objRoom.MaBuong).ExecuteSingle <NoitruDmucBuong>(); if (objcheck != null) { if (chkAutoupdate.Checked) { objRoom.IdBuong = objcheck.IdBuong; objRoom.MarkOld(); objRoom.IsNew = true; } else { continue; } } { STTHthi += 1; objRoom.IsNew = true; } objRoom.SttHthi = STTHthi; objRoom.Save(); if (objRoom != null) { DataRow newDR = p_dtDataPhong.NewRow(); Utility.FromObjectToDatarow(objRoom, ref newDR); newDR["ten_khoanoitru"] = cboKhoaNoiTru.Text; p_dtDataPhong.Rows.Add(newDR); if (MyGetData != null) { MyGetData(); } Utility.GonewRowJanus(grdList, NoitruDmucBuong.Columns.IdBuong, Utility.sDbnull(txtID.Text)); } } Utility.SetMsg(lblMessage, "Bạn thực hiện thêm mới thành công", true); if (chkthemmoilientuc.Checked) { ClearControl(); } else { Close(); } } catch (Exception exception) { Utility.CatchException(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() { try { objRoom = new NoitruDmucBuongController().FetchByID(txtID.Text)[0]; objRoom.IdBuong = Utility.Int16Dbnull(txtID.Text); objRoom.MaBuong = txtMa.Text; objRoom.TenBuong = txtTEN.Text; txt_Mo_Ta.Text = objRoom.MotaThem; objRoom.TrangThai = Utility.Bool2byte(chkTrangThai.Checked); objRoom.IdKhoanoitru = Utility.Int16Dbnull(cboKhoaNoiTru.SelectedValue); objRoom.SttHthi = Utility.Int16Dbnull(txt_STT_HTHI.Text); objRoom.MotaThem = Utility.DoTrim(txt_Mo_Ta.Text); objRoom.IsNew = false; objRoom.MarkOld(); objRoom.Save(); if (MyGetData != null) { DataRow newDR = p_dtDataPhong.Select(NoitruDmucBuong.Columns.IdBuong + "=" + objRoom.IdBuong.ToString())[0]; Utility.FromObjectToDatarow(objRoom, ref newDR); newDR["ten_khoanoitru"] = cboKhoaNoiTru.Text; p_dtDataPhong.AcceptChanges(); MyGetData(); } Utility.GonewRowJanus(grdList, NoitruDmucBuong.Columns.IdBuong, Utility.sDbnull(txtID.Text)); if (chkthemmoilientuc.Checked) ClearControl(); else Close(); Utility.SetMsg(lblMessage, "Bạn thực hiện sửa thông tin thành công", true); } catch(Exception ex) { Utility.CatchException(ex); } }
private void MultiInsert() { 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++) { objRoom = new NoitruDmucBuong(); objRoom.IdBuong = -1; objRoom.IdBuong = Utility.Int16Dbnull(txtID.Text); objRoom.MaBuong = Utility.DoTrim(txtMa.Text) + i.ToString(); objRoom.TenBuong = Utility.DoTrim(txtTEN.Text) + " " + i.ToString(); objRoom.MotaThem = Utility.DoTrim(txt_Mo_Ta.Text); objRoom.TrangThai = Utility.Bool2byte(chkTrangThai.Checked); objRoom.IdKhoanoitru = Utility.Int16Dbnull(cboKhoaNoiTru.SelectedValue); NoitruDmucBuong objcheck = new Select().From(NoitruDmucBuong.Schema).Where(NoitruDmucBuong.Columns.MaBuong).IsEqualTo(objRoom.MaBuong).ExecuteSingle<NoitruDmucBuong>(); if (objcheck != null) { if (chkAutoupdate.Checked) { objRoom.IdBuong = objcheck.IdBuong; objRoom.MarkOld(); objRoom.IsNew = true; } else { continue; } } { STTHthi += 1; objRoom.IsNew = true; } objRoom.SttHthi = STTHthi; objRoom.Save(); if (objRoom != null) { DataRow newDR = p_dtDataPhong.NewRow(); Utility.FromObjectToDatarow(objRoom, ref newDR); newDR["ten_khoanoitru"] = cboKhoaNoiTru.Text; p_dtDataPhong.Rows.Add(newDR); if (MyGetData != null) { MyGetData(); } Utility.GonewRowJanus(grdList, NoitruDmucBuong.Columns.IdBuong, Utility.sDbnull(txtID.Text)); } } Utility.SetMsg(lblMessage, "Bạn thực hiện thêm mới thành công", true); if (chkthemmoilientuc.Checked) ClearControl(); else Close(); } catch (Exception exception) { Utility.CatchException(exception); } }
/// <summary> /// hàm thực hiện viẹc thêmm ới thông tin /// </summary> private void InsertData() { try { objRoom = new NoitruDmucBuong(); objRoom.IdBuong = -1; objRoom.IdBuong =Utility.Int16Dbnull( txtID.Text); objRoom.MaBuong = Utility.DoTrim(txtMa.Text); objRoom.TenBuong = Utility.DoTrim(txtTEN.Text); objRoom.MotaThem=Utility.DoTrim(txt_Mo_Ta.Text); objRoom.TrangThai =Utility.Bool2byte( chkTrangThai.Checked); objRoom.IdKhoanoitru =Utility.Int16Dbnull( cboKhoaNoiTru.SelectedValue); objRoom.SttHthi = Utility.Int16Dbnull(txt_STT_HTHI.Text); objRoom.IsNew = true; objRoom.Save(); if (objRoom != null) { DataRow newDR = p_dtDataPhong.NewRow(); Utility.FromObjectToDatarow(objRoom, ref newDR); newDR["ten_khoanoitru"] = cboKhoaNoiTru.Text; p_dtDataPhong.Rows.Add(newDR); if (MyGetData != null) { MyGetData(); } Utility.GonewRowJanus(grdList, NoitruDmucBuong.Columns.IdBuong, Utility.sDbnull(txtID.Text)); } Utility.SetMsg(lblMessage, "Bạn thực hiện thêm mới thành công", true); if (chkthemmoilientuc.Checked) ClearControl(); else Close(); } catch (Exception exception) { Utility.CatchException(exception); } }
private void cmdThemMoi_Click(object sender, EventArgs e) { var objRoom = new NoitruDmucBuong(); var frm = new frm_Add_PhongNoiTru(); frm.objRoom = objRoom; frm.m_enAct = action.Insert; frm.p_dtDataPhong = globalVariables.gv_PhongNoitru; frm.MyGetData=new frm_Add_PhongNoiTru.timkiem(LoadData); frm.grdList = grdRoom; frm.ShowDialog(); ModifyCommand(); }
public void Insert(string MaBuong,string TenBuong,short IdKhoanoitru,int DonGia,string MotaThem,byte? TrangThai,short? SttHthi) { NoitruDmucBuong item = new NoitruDmucBuong(); item.MaBuong = MaBuong; item.TenBuong = TenBuong; item.IdKhoanoitru = IdKhoanoitru; item.DonGia = DonGia; item.MotaThem = MotaThem; item.TrangThai = TrangThai; item.SttHthi = SttHthi; 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(); } } }