private void butref1_Click(object sender, EventArgs e)
{
try
{
if (cmbks.ComboBox.SelectedValue == null)
{
return;
}
if (cmbks.ComboBox.SelectedValue.ToString() == "System.Data.DataRowView")
{
return;
}
int ksdm = Convert.ToInt32(Convertor.IsNull(cmbks.ComboBox.SelectedValue, "0"));//DateManager.ServerDateTimeByDBType(InstanceForm.BDatabase).ToShortDateString()
string rq1 = DateManager.ServerDateTimeByDBType(InstanceForm.BDatabase).ToShortDateString() + " 00:00:00";
string rq2 = DateManager.ServerDateTimeByDBType(InstanceForm.BDatabase).ToShortDateString() + " 23:59:59";
int klx = 0;
string kh = "";
string blh = "";
DataTable tb = MZHS_FZJL.Select_whzbr(ksdm, rq1, rq2, klx, kh, blh, InstanceForm.BDatabase).Tables[0];
AddListView1(tb);
}
catch (System.Exception err)
{
MessageBox.Show(err.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void txtkh_KeyPress(object sender, KeyPressEventArgs e)
{
try
{
if ((int)e.KeyChar != 13)
{
return;
}
Guid NewFzid = Guid.Empty;
int err_code = -1;
string err_text = "";
Control control = (Control)sender;
int ksdm = Convert.ToInt32(Convertor.IsNull(cmbks.ComboBox.SelectedValue, "0"));
string rq1 = DateManager.ServerDateTimeByDBType(InstanceForm.BDatabase).ToShortDateString() + " 00:00:00";
string rq2 = DateManager.ServerDateTimeByDBType(InstanceForm.BDatabase).ToShortDateString() + " 23:59:59";
int klx = Convert.ToInt32(Convertor.IsNull(cmbklx.SelectedValue, "0"));
if (control.Name == "txtkh")
{
txtkh.Text = Fun.returnKh(klx, txtkh.Text.Trim(), InstanceForm.BDatabase);
txtkh.SelectAll();
}
if (control.Name == "txtmzh" || control.Name == "listView1")
{
txtmzh.Text = Fun.returnMzh(txtmzh.Text.Trim(), InstanceForm.BDatabase);
txtmzh.SelectAll();
}
string kh = control.Name == "txtkh" ? Fun.returnKh(klx, txtkh.Text.Trim(), InstanceForm.BDatabase) : "";
string blh = control.Name == "txtmzh" || control.Name == "listView1" ? Fun.returnMzh(txtmzh.Text.Trim(), InstanceForm.BDatabase) : "";
DataSet dset = MZHS_FZJL.Select_whzbr(ksdm, rq1, rq2, klx, kh, blh, InstanceForm.BDatabase);
DataTable tb = dset.Tables[0];
//如果多行，则由用户选择
if (tb.Rows.Count > 1)
{
AddListView1(tb);
}
//如果找到一行。则直接候诊
if (tb.Rows.Count == 1)
{
try
{
InstanceForm.BDatabase.BeginTransaction();
MZHS_FZJL.AddHz(TrasenFrame.Forms.FrmMdiMain.Jgbm, new Guid(tb.Rows[0]["ghxxid"].ToString()), Convert.ToInt32(tb.Rows[0]["hzks"]), out NewFzid, out err_code, out err_text, InstanceForm.BDatabase);
if (NewFzid == Guid.Empty || err_code != 0)
{
throw new Exception(err_text);
}
InstanceForm.BDatabase.CommitTransaction();
butref1_Click(sender, e);
butref2_Click(sender, e);
control.Text = "";
}
catch (System.Exception err)
{
InstanceForm.BDatabase.RollbackTransaction();
throw new Exception(err.Message);
}
}
//如果没有找到行
if (tb.Rows.Count == 0 && ksdm != 0)
{
DataTable tbxx = dset.Tables[1];
if (tbxx.Rows.Count == 0)
{
throw new Exception("没有找到这个病人的挂号信息");
}
}
}
catch (System.Exception err)
{
MessageBox.Show(err.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
