private void login_Load(object sender, EventArgs e)
{
if (DataValid.PingHost(ftpAddress))
{
IsUpate();
}
}
/// <summary>
/// 保存按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnAdd_Click(object sender, EventArgs e)
{
try
{
if (textBoxCode.Text != "")
{
string IPaddress = "132.147.160.27";
bool flag = DataValid.PingHost(IPaddress, 1000);
if (flag == false)
{
MessageBox.Show("器械追溯数据库未连接，请检查网络");
return;
}
int rs = Wzdb.UpdateQXB(paID, textBoxCode.Text.Trim());///插入器械追溯的数据库
if (rs > 0)
{
}
else
{
MessageBox.Show("没找到改条码号对应的住院号！");
return;
}
//插入本地数据库
DataTable dt = dal.QXCodes(paID, Ddate);
int result = 0;
if (dt.Rows.Count > 0)
{
result = dal.UpdateQXCodes(paID, Ddate, textBoxCode.Text.Trim());
}
else
{
result = dal.insertQXCodes(paID, Ddate, textBoxCode.Text.Trim());
int results = dal.UpdatePaiban(paID, Ddate, 1);//修改器械状态
}
if (result > 0)
{
MessageBox.Show("保存成功！");
}
//int rss = Wzdb.UpdateQXB(paID, textBox6.Text.Trim());
//if (rss>0)
//{
// MessageBox.Show("保存成功！");
//}
//else
//{
// MessageBox.Show("没找到改条码号对应的住院号！");
//}
}
else
{
MessageBox.Show("条码号不能为空！");
}
}
catch (Exception ex)
{
DataValid.SaveScanLog(ex.ToString());
MessageBox.Show("保存失败!" + ex.ToString());
}
}
/// <summary>
/// 刷新麻醉药品
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button2_Click(object sender, EventArgs e)
{
string IPaddress = "132.147.160.5";
bool flag = DataValid.PingHost(IPaddress, 1000);
if (flag == true)
{
// HismzypBind();
HisMzLBBind();
HisMzKSBind();
BindMZYYType();
BindMZYYZTType();
}
else
{
MessageBox.Show("HIS数据库未连接，请检查网络");
}
}
private void btnCheckHis_Click(object sender, EventArgs e)
{
if (txtPatid.Controls[0].Text.Trim().Length != 8)
{
MessageBox.Show("请输入八位完整住院号");
}
else
{
string IPaddress = "132.147.160.60";
bool flag = DataValid.PingHost(IPaddress, 1000);
if (flag == true)
{
DataTable dt = HisHelp.GetHisInfoByPatID(txtPatid.Controls[0].Text.Trim());
if (dt.Rows.Count == 1)
{
txtPatid.Controls[0].Text = dt.Rows[0]["BRBH"].ToString(); //住院号
txtBednumber.Controls[0].Text = dt.Rows[0]["CWHM"].ToString(); //床号
txtPatname.Controls[0].Text = dt.Rows[0]["BRXM"].ToString(); //姓名
txtPatage.Controls[0].Text = dt.Rows[0]["RYNL"].ToString(); //年龄
txtPatNation.Controls[0].Text = dt.Rows[0]["dmmc"].ToString(); //名族
txtSex.Controls[0].Text = dt.Rows[0]["BRXB"].ToString(); //性别
cmbKeshi.Text = dt.Rows[0]["ksmc"].ToString(); //科室
//txtSqzd.Controls[0].Text = dt.Rows[0]["SQZD"].ToString();
//txtTSQK.Controls[0].Text = dt.Rows[0]["bz"].ToString();
//txtNssss.Controls[0].Text = dt.Rows[0]["oname"].ToString();
//cmbMZFF.Text = dt.Rows[0]["mzff"].ToString();
}
else
{
MessageBox.Show("无此住院号病人信息,请手动填写完整的住院号及病人的信息！");
}
}
else
{
MessageBox.Show("HIS网络连接错误，请检查");
}
}
}
private void btnCheckHis_Click(object sender, EventArgs e)
{
if (checkmenzhen.Checked == true)
{
string IPaddress = "192.168.18.89";
bool flag = DataValid.PingHost(IPaddress, 1000);
if (flag == true)
{
DataTable dt = hisdb.GetHISpaibanmenzhen(txtPatid.Controls[0].Text.Trim());
if (dt.Rows.Count > 0)
{
//txtPatid.Controls[0].Text = dt.Rows[0]["BRBH"].ToString();//住院号
txtBednumber.Controls[0].Text = dt.Rows[0]["INP_NO"].ToString(); //床号
txtPatname.Controls[0].Text = dt.Rows[0]["NAME"].ToString(); //姓名
mzmzdjcs = dt.Rows[0]["CLINIC_VISIT_ID"].ToString();
//txtPatage.Controls[0].Text = dt.Rows[0]["RYNL"].ToString();//年龄
txtPatNation.Controls[0].Text = dt.Rows[0]["NATION"].ToString(); //名族
txtSex.Controls[0].Text = dt.Rows[0]["SEX"].ToString(); //性别
cmbKeshi.Text = dt.Rows[0]["DEPT_NAME"].ToString(); //科室
txtSqzd.Controls[0].Text = dt.Rows[0]["PRELIMINARY_DIAGNOSIS"].ToString();
//txtTSQK.Controls[0].Text = dt.Rows[0]["bz"].ToString();
//txtNssss.Controls[0].Text = dt.Rows[0]["oname"].ToString();
//cmbMZFF.Text = dt.Rows[0]["mzff"].ToString();
}
else
{
MessageBox.Show("无此住院号病人信息,请手动填写完整的住院号及病人的信息！");
}
}
else
{
MessageBox.Show("HIS网络连接错误，请检查");
}
}
else if (checkzhuyuan.Checked == true)
{
string IPaddress = "192.168.18.89";
bool flag = DataValid.PingHost(IPaddress, 1000);
if (flag == true)
{
DataTable dt = hisdb.GetHISpaibanzhuyuan(txtPatid.Controls[0].Text.Trim());
if (dt.Rows.Count > 0)
{
//txtPatid.Controls[0].Text = dt.Rows[0]["BRBH"].ToString();//住院号
txtBednumber.Controls[0].Text = dt.Rows[0]["BED_NO"].ToString(); //床号
txtPatname.Controls[0].Text = dt.Rows[0]["NAME"].ToString(); //姓名
mzmzdjcs = txtPatid.Controls[0].Text.Trim(); //住院
txtPatage.Controls[0].Text = dt.Rows[0]["AGE"].ToString(); //年龄
txtPatNation.Controls[0].Text = dt.Rows[0]["NATION"].ToString(); //名族
txtSex.Controls[0].Text = dt.Rows[0]["SEX"].ToString(); //性别
cmbKeshi.Text = dt.Rows[0]["DEPT_NAME"].ToString(); //科室
txtSqzd.Controls[0].Text = dt.Rows[0]["pattmd"].ToString();
//txtTSQK.Controls[0].Text = dt.Rows[0]["bz"].ToString();
//txtNssss.Controls[0].Text = dt.Rows[0]["oname"].ToString();
//cmbMZFF.Text = dt.Rows[0]["mzff"].ToString();
}
else
{
MessageBox.Show("无此住院号病人信息,请手动填写完整的住院号及病人的信息！");
}
}
else
{
MessageBox.Show("HIS网络连接错误，请检查");
}
}
}
