| | |
|---|
| | | list.Add(dic); |
|---|
| | | } |
|---|
| | | //获取当前时间 |
|---|
| | | DateTime ActionTime = DateTime.Parse(DateTime.Now.AddMinutes(-2).ToString("yyyy-MM-dd HH:mm:ss")); |
|---|
| | | DateTime ActionTime = DateTime.Parse(DateTime.Now.AddMinutes(-4).ToString("yyyy-MM-dd HH:mm:ss")); |
|---|
| | | DateTime EndTime = DateTime.Parse(DateTime.Now.AddMinutes(1).ToString("yyyy-MM-dd HH:mm:00")); |
|---|
| | | bool flag_1 = false; |
|---|
| | | bool flag_2 = false; |
|---|
| | |
|---|
| | | if (dataSet.Tables[0].Rows.Count > 0) |
|---|
| | | { |
|---|
| | | string HBillNo = dataSet.Tables[0].Rows[0]["HBillNo"].ToString(); |
|---|
| | | dataSet = oCN.RunProcReturn("select * from Sc_ICMOBillStatus_Tmp where HSourceBillNo='" + HBillNo + "' and HICMOStatus='1'", "Sc_ICMOBillStatus_Tmp"); |
|---|
| | | dataSet = oCN.RunProcReturn("select * from Sc_ICMOBillStatus_Tmp where HSourceBillNo='" + HBillNo + "' and HICMOStatus<>'0'", "Sc_ICMOBillStatus_Tmp"); |
|---|
| | | |
|---|
| | | if (dataSet.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}','{HDate}','{HResult}','{HProcNumber}','{HFlag}')"; |
|---|
| | | oCN.RunProc(sql); |
|---|
| | | ListSelect.Items.Add("条码:" + HBarCode + ",日期:" + HCreateTime + ",结果:" + HResult); |
|---|
| | | ListSelect.Items.Add("条码:" + HBarCode + ",当前日期;"+DateTime.Now.ToString()+",日期:" + HCreateTime + ",结果:" + HResult); |
|---|
| | | } |
|---|
| | | else |
|---|
| | | { |
|---|
