| | |
| | | { |
| | | if (Get_AllowLoadData(HBarCode, HProcNumber, flag_1, AllProcessExchangeHProcExchBillNo, AllProcessExchangeHProcExchInterID, out flag_2)) |
| | | { |
| | | //新增条码数据 |
| | | string sql = $@"insert into Sb_EquipMentCollection_SN(HSourceCode,HEmpCode,HType,HBarCode,HCount,HCreateTime,HDate,HResult,HProcNumber,HFlag) |
| | | DataSet ds = oCN.RunProcReturn(@"select HItemID from Sb_EquipMentCollectionTechParam_SN where HBarCode='" + HBarCode + "' and HCreateTime='" + HCreateTime + "'", "Sb_EquipMentCollectionTechParam_SN"); |
| | | |
| | | if (ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | //新增条码数据 |
| | | string sql = $@"insert into Sb_EquipMentCollection_SN(HSourceCode,HEmpCode,HType,HBarCode,HCount,HCreateTime,HDate,HResult,HProcNumber,HFlag) |
| | | values('{HSourceCode}','{HEmpCode}','{HType}','{HBarCode}','{HCount}','{HCreateTime}',GETDATE(),'{HResult}','{HProcNumber}','{HFlag}')"; |
| | | oCN.RunProc(sql); |
| | | ListSelect.Items.Add("条码:" + HBarCode + ",当前日期;" + DateTime.Now.ToString() + ",日期:" + HCreateTime + ",结果:" + HResult); |
| | | listData.Add(HBarCode); |
| | | oCN.RunProc(sql); |
| | | ListSelect.Items.Add("条码:" + HBarCode + ",当前日期;" + DateTime.Now.ToString() + ",日期:" + HCreateTime + ",结果:" + HResult); |
| | | listData.Add(HBarCode); |
| | | } |
| | | |
| | | } |
| | | else |
| | | { |
| | |
| | | { |
| | | if (MessageBox.Show("是否启用检索补漏?", "确认", MessageBoxButtons.YesNo) == DialogResult.Yes) |
| | | { |
| | | SelectTime = -90; |
| | | SelectTime = -420; |
| | | Read_Txt(); |
| | | } |
| | | } |