private void cmdAccept_Click(object sender, EventArgs e) { try { QueryCommand cmd = DmucNoiKCBBD.CreateQuery().BuildCommand(); cmd.CommandType = CommandType.Text; cmd.CommandSql = "Select * from dmuc_noiKCBBD WHERE ma_kcbbd='" + txtMa.Text + "' AND ma_diachinh='" + txtMaThanhPho.Text.Trim() + "'"; DataTable temdt = DataService.GetDataSet(cmd).Tables[0]; if (temdt.Rows.Count <= 0) { DmucNoiKCBBD newItem = new DmucNoiKCBBD(); newItem.MaDiachinh = txtMaThanhPho.Text.Trim(); newItem.MaKcbbd = txtMa.Text.Trim(); newItem.TenKcbbd = txtTen.Text.Trim(); newItem.SttHthi = 9999; newItem.IsNew = true; newItem.Save(); this.DialogResult = DialogResult.OK; this.Close(); } else { Utility.ShowMsg(string.Format("Mã {0}: đang thuộc về nơi KCBBĐ {1}. Mời bạn kiểm tra lại", txtMa, Utility.sDbnull(temdt.Rows[0]["ten_kcbbd"].ToString(), ""))); txtMa.Focus(); } } catch { } }
private void cmdAccept_Click(object sender, EventArgs e) { try { QueryCommand cmd = DmucNoiKCBBD.CreateQuery().BuildCommand(); cmd.CommandType = CommandType.Text; cmd.CommandSql = "Select * from dmuc_noiKCBBD WHERE ma_kcbbd='" + txtMa.Text + "' AND ma_diachinh='" + txtMaThanhPho.Text.Trim() + "'"; DataTable temdt = DataService.GetDataSet(cmd).Tables[0]; if (temdt.Rows.Count <= 0) { DmucNoiKCBBD newItem = new DmucNoiKCBBD(); newItem.MaDiachinh = txtMaThanhPho.Text.Trim(); newItem.MaKcbbd = txtMa.Text.Trim(); newItem.TenKcbbd = txtTen.Text.Trim(); newItem.SttHthi = 9999; newItem.IsNew = true; newItem.Save(); this.DialogResult = DialogResult.OK; this.Close(); } else { Utility.ShowMsg(string.Format("Mã {0}: đang thuộc về nơi KCBBĐ {1}. Mời bạn kiểm tra lại", txtMa, Utility.sDbnull(temdt.Rows[0]["ten_kcbbd"].ToString(), ""))); txtMa.Focus(); } } catch { } }
/// <summary> /// hàm thực hiện kiểm tra thông tin của phần Update /// </summary> /// <returns></returns> private bool InValiUpdateData() { if (string.IsNullOrEmpty(txtClinicCode.Text)) { Utility.SetMsgError(errorProvider1, txtClinicCode, "Bạn phải nhập mã KCBBĐ"); txtClinicCode.Focus(); return(false); } if (string.IsNullOrEmpty(txtDieaseName.Text)) { Utility.SetMsgError(errorProvider2, txtDieaseName, "Bạn phải nhập tên KCBBĐ"); txtClinicCode.Focus(); return(false); } if (cboSurveys.SelectedIndex <= -1) { Utility.SetMsgError(errorProvider3, cboSurveys, "Bạn phải chọn địa chính"); cboSurveys.Focus(); return(false); } DmucNoiKCBBDCollection objDmucNoiKCBBDCollection = new DmucNoiKCBBDController().FetchByQuery( DmucNoiKCBBD.CreateQuery().AddWhere(DmucNoiKCBBD.Columns.MaKcbbd, Comparison.Equals, txtClinicCode.Text) .AND(DmucNoiKCBBD.Columns.IdKcbbd, Comparison.NotEquals, Utility.Int32Dbnull(txtClinic_ID.Text, -1)).AND (DmucNoiKCBBD.Columns.MaDiachinh, Comparison.Equals, Utility.sDbnull(cboSurveys.SelectedValue, ""))); if (objDmucNoiKCBBDCollection.Count() > 0) { Utility.ShowMsg("Đã tồn tại mã khám chữa bệnh này"); txtClinicCode.Focus(); return(false); } if (objDmucNoiKCBBDCollection.Count() > 0) { Utility.ShowMsg("Đã tồn tại tên khám chữa bệnh này"); txtDieaseName.Focus(); return(false); } DmucNoiKCBBDCollection objClinicCollection = new DmucNoiKCBBDController().FetchByQuery( DmucNoiKCBBD.CreateQuery().AddWhere(DmucNoiKCBBD.Columns.TenKcbbd, Comparison.Equals, txtDieaseName.Text).AND( DmucNoiKCBBD.Columns.IdKcbbd, Comparison.NotEquals, Utility.Int32Dbnull(txtClinic_ID.Text, -1)).AND( DmucNoiKCBBD.Columns.MaDiachinh, Comparison.Equals, Utility.sDbnull(cboSurveys.SelectedValue, ""))); if (objClinicCollection.Count() > 0) { Utility.ShowMsg("Đã tồn tại tên khám chữa bệnh này"); txtDieaseName.Focus(); return(false); } return(true); }
private void GetData() { DmucNoiKCBBD objDisease = DmucNoiKCBBD.FetchByID(Utility.Int32Dbnull(txtClinic_ID.Text, -1)); if (objDisease != null) { txtsDesc.Text = objDisease.MotaThem; txtClinicCode.Text = objDisease.MaKcbbd; txtDieaseName.Text = objDisease.TenKcbbd; cboSurveys.SelectedIndex = Utility.GetSelectedIndex(cboSurveys, objDisease.MaDiachinh.ToString()); txtIntOrder.Value = Utility.Int16Dbnull(objDisease.SttHthi, 1); } }
/// <summary> /// hàm thực hiện chèn thêm thông tin /// </summary> private void PerformActionInsert() { DmucNoiKCBBD.Insert(Utility.sDbnull(cboSurveys.SelectedValue, ""), txtClinicCode.Text, Utility.sDbnull(txtDieaseName.Text, ""), Utility.Int16Dbnull(txtIntOrder.Text, 1), txtsDesc.Text, ""); DataRow dr = globalVariables.gv_dtDmucNoiKCBBD.NewRow(); dr[DmucNoiKCBBD.Columns.IdKcbbd] = Utility.Int32Dbnull(_Query.GetMax(DmucNoiKCBBD.Columns.IdKcbbd), -1); dr[DmucNoiKCBBD.Columns.MaKcbbd] = txtClinicCode.Text; dr[DmucNoiKCBBD.Columns.TenKcbbd] = Utility.sDbnull(txtDieaseName.Text, ""); dr[DmucNoiKCBBD.Columns.MaDiachinh] = Utility.sDbnull(cboSurveys.SelectedValue, ""); dr[DmucNoiKCBBD.Columns.MotaThem] = Utility.sDbnull(txtsDesc.Text, ""); dr[DmucNoiKCBBD.Columns.SttHthi] = Utility.Int16Dbnull(txtIntOrder.Text, 1); dr[DmucDiachinh.Columns.TenDiachinh] = Utility.sDbnull(cboSurveys.Text, ""); globalVariables.gv_dtDmucNoiKCBBD.Rows.Add(dr); Utility.GotoNewRowJanus(grdList, DmucNoiKCBBD.Columns.MaKcbbd, txtClinicCode.Text); this.Close(); }
public void Insert(string MaDiachinh,string MaKcbbd,string TenKcbbd,short? SttHthi,string MotaThem,string DiaChi) { DmucNoiKCBBD item = new DmucNoiKCBBD(); item.MaDiachinh = MaDiachinh; item.MaKcbbd = MaKcbbd; item.TenKcbbd = TenKcbbd; item.SttHthi = SttHthi; item.MotaThem = MotaThem; item.DiaChi = DiaChi; item.Save(UserName); }
public void Update(int IdKcbbd,string MaDiachinh,string MaKcbbd,string TenKcbbd,short? SttHthi,string MotaThem,string DiaChi) { DmucNoiKCBBD item = new DmucNoiKCBBD(); item.MarkOld(); item.IsLoaded = true; item.IdKcbbd = IdKcbbd; item.MaDiachinh = MaDiachinh; item.MaKcbbd = MaKcbbd; item.TenKcbbd = TenKcbbd; item.SttHthi = SttHthi; item.MotaThem = MotaThem; item.DiaChi = DiaChi; item.Save(UserName); }