/// <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()); } }