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;
}
}
