| | |
| | | string HType = ""; |
| | | int HCount = 1; |
| | | |
| | | //DataSet ds = oCN.RunProcReturn(@"select * from Sb_EquipMentCollection_SN where HBarCode='" + HBarCode + "' and HCreateTime='" + HCreateTime + "'", "Sb_EquipMentCollection_SN"); |
| | | |
| | | if (true) |
| | | DataSet ds = oCN.RunProcReturn(@"select * from Sb_EquipMentCollection_SN with(nolock) where HBarCode='" + HBarCode + "' and HProcNumber='" + HProcNumber + "'", "Sb_EquipMentCollection_SN"); |
| | | if (ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | if (Get_AllowLoadData(HBarCode, HProcNumber, flag_1, out flag_2)) |
| | | { |
| | |
| | | { |
| | | string sql1 = $@"insert into Sb_EquipMentCollectionTechParam_SN(HSourceCode,HEmpCode,HType,HBarCode,HCount,HCreateTime,HDate,HResult,HProcNumber,HFlag) |
| | | values('{HSourceCode}','{HEmpCode}','{HType}','{HBarCode}','{HCount_1}','{HCreateTime}',GETDATE(),'{HResult}','{HProcNumber}','{HFlag}')"; |
| | | oCN.RunProc(sql1); |
| | | //ListSelect.Items.Add("条码:" + HBarCode + ",日期:" + HCreateTime + ",结果:" + HResult); |
| | | oCN.RunProc(sql1); |
| | | } |
| | | } |
| | | } |