1

yangle

3 天以前 861794e4cc962de1059ab01ca1e2bd81e2bac643

 WFormSynchronizeData_SMR/WFormSynchronizeData_SMR/Form1.cs

@@ -404,6 +404,7 @@
                    CustomWriteLog("条码:" + HBadCodeSN + "工序:" + HProcNumber + ",出站时间:" + HMakeTime, "TM" + DateTime.Now.ToString("yyyy-MM-dd"));
                    //反写工序出站单的合格数量
                    oCN.RunProc("update Sc_StationOutBillMain  set HQty+=1  where HInterID='" + HInterID + "'");
                    CustomWriteLog("反写合格数量!条码:" + HBadCodeSN + ",工序:" + HProcNumber + ",出站单ID" + HInterID, DateTime.Now.ToString("yyyy-MM-dd"));
                    CustomWriteLog("2.1.12 条码反写 :" + HProcNumber + "----" + timer.Elapsed, DateTime.Now.ToString("yyyy-MM-dd"));
                }
                else if (HResult == "NG")
@@ -425,12 +426,14 @@
                            if (DateTime.Parse(HBadDate) < DateTime.Parse(HRepairDate)) {
                                //反写工序出站单的不良数量
                                oCN.RunProc("update Sc_StationOutBillMain  set HBadCount+=1,HWasterQty_Work+=1 where HInterID='" + HInterID + "'");
                                CustomWriteLog("反写不合格数量!条码:"+ HBadCodeSN+",工序:"+ HProcNumber+",出站单ID"+ HInterID, DateTime.Now.ToString("yyyy-MM-dd"));
                            }
                        }

                    } else {
                        //反写工序出站单的不良数量
                        oCN.RunProc("update Sc_StationOutBillMain  set HBadCount+=1,HWasterQty_Work+=1 where HInterID='" + HInterID + "'");
                        CustomWriteLog("反写不合格数量!条码:" + HBadCodeSN + ",工序:" + HProcNumber + ",出站单ID" + HInterID, DateTime.Now.ToString("yyyy-MM-dd"));
                    }

                    CustomWriteLog("2.1.14 不合格反写 :" + HProcNumber + "----" + timer.Elapsed, DateTime.Now.ToString("yyyy-MM-dd"));
@@ -524,6 +527,8 @@
values('{DateTime.Now.Year}','{DateTime.Now.Month}','3727','3727',{HInterID1},getdate()
,'{HBillNo1}','1','{HMakers}',getdate(),{HProcExchInterID},{HProcExchEntryID},'{HProcExchBillNo}'
,{HICMOInterID},'{HICMOBillNo}','{HBadCodeSN}',{HMaterID},0,'汇报',{HPRDOrgIDs})";

                    CustomWriteLog("2.1.21 sql语句 :" + sql + "----" + timer.Elapsed, DateTime.Now.ToString("yyyy-MM-dd"));
                    oCN.RunProc(sql);

                    CustomWriteLog("2.1.22 保存主表 :" + HProcNumber + "----" + timer.Elapsed, DateTime.Now.ToString("yyyy-MM-dd"));