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网络连接错误,请检查"); } } }