private void dataGridView1_DoubleClick(object sender, EventArgs e) { try { if (dataGridView1.CurrentCell == null) { return; } DataTable tb = (DataTable)dataGridView1.DataSource; if (tb.Rows.Count == 0) { return; } int nrow = this.dataGridView1.CurrentCell.RowIndex; bool shbz = Convert.ToBoolean(tb.Rows[nrow]["已入院"]); _ID = new Guid(tb.Rows[nrow]["id"].ToString()); if (funName == "ryk") { if (shbz == true) { MessageBox.Show("该住院证已审核入院,不能再次入院", "", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } bok = true; if (InstanceForm._communicateValue.Length > 4) { InstanceForm._communicateValue[2] = _ID; InstanceForm._communicateValue[3] = true; InstanceForm._communicateValue[4] = tb; } this.Close(); } else { tabControl1.SelectedTab = tabPage1; mzys_zyz s = new mzys_zyz(_ID, InstanceForm.BDatabase); txttjys.Text = Fun.SeekEmpName(s.tjys, InstanceForm.BDatabase); txttjys.Tag = s.tjys; txtmzzd.Text = s.mzzdmc; txtmzzd.Tag = s.mzzd; txtryks.Text = Fun.SeekDeptName(s.dryks, InstanceForm.BDatabase); txtryks.Tag = s.dryks; txtyjj.Text = s.jyyj.ToString(); txtbz.Text = s.bz; cmbrytj.SelectedValue = s.rytj.ToString(); lbldjsj.Text = s.djsj.ToString(); butsave.Text = "修改(&F2)"; } } catch (System.Exception err) { MessageBox.Show(err.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public Frmzyz(MenuTag menuTag, string chineseName, Form mdiParent, Guid _brxxid) { InitializeComponent(); _menuTag = menuTag; _chineseName = chineseName; _mdiParent = mdiParent; //入院途径 string ssql = "select id,name from jc_rytj"; DataTable tbry = InstanceForm.BDatabase.GetDataTable(ssql); cmbrytj.DisplayMember = "name"; cmbrytj.ValueMember = "id"; cmbrytj.DataSource = tbry; this.Text = _chineseName; txttjys.Text = InstanceForm.BCurrentUser.Name; txttjys.Tag = InstanceForm.BCurrentUser.EmployeeId.ToString(); chkrq.Checked = false; if (_brxxid != Guid.Empty) { //Blh = InstanceForm.BDatabase.GetDataResult("SELECT BLH FROM dbo.MZ_GHXX WHERE GHXXID='" + Dqcf.ghxxid + "'").ToString(); GetBrxx(0, "", _brxxid, Guid.Empty); DataTable tb = mzys_zyz.GetRecord("", "", InstanceForm.BCurrentUser.EmployeeId, -1, 0, "", "", _brxxid, InstanceForm.BDatabase); dataGridView1.DataSource = tb; DataTable tb2 = mzys_zyz.GetRecord("", "", InstanceForm.BCurrentUser.EmployeeId, 0, 0, "", "", _brxxid, InstanceForm.BDatabase); if (tb2.Rows.Count > 0) { mzys_zyz s = new mzys_zyz(new Guid(tb2.Rows[tb2.Rows.Count - 1]["ID"].ToString()), InstanceForm.BDatabase); _ID = new Guid(tb2.Rows[tb2.Rows.Count - 1]["ID"].ToString()); txttjys.Text = Fun.SeekEmpName(s.tjys, InstanceForm.BDatabase); txttjys.Tag = s.tjys; txtmzzd.Text = s.mzzdmc; txtmzzd.Tag = s.mzzd; txtryks.Text = Fun.SeekDeptName(s.dryks, InstanceForm.BDatabase); txtryks.Tag = s.dryks; txtyjj.Text = s.jyyj.ToString(); txtbz.Text = s.bz; cmbrytj.SelectedValue = s.rytj.ToString(); lbldjsj.Text = s.djsj.ToString(); butsave.Text = "修改(&F2)"; } } else { chkrq.Checked = true; } funName = "ys"; }
private void mnubtg_Click(object sender, EventArgs e) { try { if (MessageBox.Show("您确定要作废当前住院证吗? ", "询问", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.Cancel) { return; } if (dataGridView1.CurrentCell == null) { return; } DataTable tb = (DataTable)dataGridView1.DataSource; if (tb.Rows.Count == 0) { return; } int nrow = this.dataGridView1.CurrentCell.RowIndex; Guid zyzid = new Guid(tb.Rows[nrow]["id"].ToString()); mzys_zyz s = new mzys_zyz(zyzid, InstanceForm.BDatabase); if (s.djy != InstanceForm.BCurrentUser.EmployeeId) { throw new Exception("该住院证不是您登记的,您不能删除"); } if (s.brybz == true) { throw new Exception("该住院证已审核入院,您不能删除"); } else { s.Delete(zyzid, InstanceForm.BDatabase); } butref_Click(sender, e); } catch (System.Exception err) { MessageBox.Show(err.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public Frmzyz(MenuTag menuTag, string chineseName, Form mdiParent, Guid _brxxid, string _blh) { InitializeComponent(); _menuTag = menuTag; _chineseName = chineseName; _mdiParent = mdiParent; Blh = _blh; //入院途径(选项初始化) string ssql = "select id,name from jc_rytj"; DataTable tbry = InstanceForm.BDatabase.GetDataTable(ssql); cmbrytj.DisplayMember = "name"; cmbrytj.ValueMember = "id"; cmbrytj.DataSource = tbry; this.Text = _chineseName; txttjys.Text = InstanceForm.BCurrentUser.Name; txttjys.Tag = InstanceForm.BCurrentUser.EmployeeId.ToString(); chkrq.Checked = false; if (_brxxid != Guid.Empty) { GetBrxx(0, "", _brxxid, Guid.Empty); DataTable tb = mzys_zyz.GetRecord("", "", InstanceForm.BCurrentUser.EmployeeId, -1, 0, "", "", _brxxid, InstanceForm.BDatabase); dataGridView1.DataSource = tb; DataTable tb2 = mzys_zyz.GetRecord("", "", InstanceForm.BCurrentUser.EmployeeId, 0, 0, "", "", _brxxid, InstanceForm.BDatabase); if (tb2.Rows.Count > 0) { mzys_zyz s = new mzys_zyz(new Guid(tb2.Rows[tb2.Rows.Count - 1]["ID"].ToString()), InstanceForm.BDatabase); _ID = new Guid(tb2.Rows[tb2.Rows.Count - 1]["ID"].ToString()); txttjys.Text = Fun.SeekEmpName(s.tjys, InstanceForm.BDatabase); txttjys.Tag = s.tjys; txtmzzd.Text = s.mzzdmc; txtmzzd.Tag = s.mzzd; txtryks.Text = Fun.SeekDeptName(s.dryks, InstanceForm.BDatabase); txtryks.Tag = s.dryks; txtyjj.Text = s.jyyj.ToString(); txtbz.Text = s.bz; cmbrytj.SelectedValue = s.rytj.ToString(); lbldjsj.Text = s.djsj.ToString(); butsave.Text = "修改(&F2)"; } else if (!String.IsNullOrEmpty(_blh)) { //150310 chencan 初始化门诊诊断 string sql = string.Format("select ZDBM,ZDMC from MZ_GHXX where BLH='{0}'", _blh); DataTable dt = InstanceForm.BDatabase.GetDataTable(sql); if (dt.Rows.Count > 0) { txtmzzd.Tag = dt.Rows[0]["ZDBM"].ToString(); txtmzzd.Text = dt.Rows[0]["ZDMC"].ToString(); } } } else { chkrq.Checked = true; } funName = "ys"; }
private void butsave_Click(object sender, EventArgs e) { try { if (Dqcf.brxxid == Guid.Empty) { MessageBox.Show("请输入病人信息", "", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (cmbrytj.Text.Trim() == "") { MessageBox.Show("入院途径必填", "", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (txtmzzd.Text == "") { MessageBox.Show("请输入门诊诊断", "", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (txtryks.Text == "") { MessageBox.Show("请输入待入院的科室", "", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (Convertor.IsNumeric(txtyjj.Text) == false) { MessageBox.Show("入院押金请输入数字", "", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } int err_code = -1; string err_text = ""; Guid newid = Guid.Empty; DateTime djsj = DateManager.ServerDateTimeByDBType(InstanceForm.BDatabase); mzys_zyz zyz = new mzys_zyz(_ID, InstanceForm.BDatabase); if (zyz.brybz == true) { MessageBox.Show("该住院证已入院,您不能修改", "", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (zyz.djy != InstanceForm.BCurrentUser.EmployeeId && zyz.djy > 0) { MessageBox.Show("该住院证不是您登记的,您不能修改", "", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } zyz.id = _ID; zyz.jgbm = InstanceForm._menuTag.Jgbm; zyz.brxxid = Dqcf.brxxid; zyz.mzzd = Convertor.IsNull(txtmzzd.Tag, ""); zyz.mzzdmc = txtmzzd.Text.Trim(); zyz.dryks = Convert.ToInt32(Convertor.IsNull(txtryks.Tag, "0")); zyz.tjys = Convert.ToInt32(Convertor.IsNull(txttjys.Tag, "0")); zyz.jyyj = Convert.ToDecimal(Convertor.IsNull(txtyjj.Text, "0")); zyz.bz = txtbz.Text; zyz.djsj = djsj; zyz.djy = InstanceForm.BCurrentUser.EmployeeId; zyz.rytj = Convert.ToInt32(Convertor.IsNull(cmbrytj.SelectedValue, "0")); zyz.tjks = InstanceForm.BCurrentDept.DeptId; //Modify By zp 2013-10-22 zyz.mzh = Blh; zyz.Save(out newid, out err_code, out err_text, InstanceForm.BDatabase); if (err_code != 0) { throw new Exception(err_text); } MessageBox.Show(err_text); _ID = newid; } catch (System.Exception err) { MessageBox.Show(err.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } }