Beispiel #1
0
 /// <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());
     }
 }