优化

yangle

2025-01-03 95e6a23bc5a604184657a0baaee180ea55c41f5f

 WFormSynchronizeData_SMR/WFormReadData_SMR/JZ_ReadDate.cs

@@ -415,7 +415,7 @@
                                                    }
                                                }
                                                DBHelper.CustomWriteLog("Insert into QC_ProcessCheckBillSub " +
                          " (HInterID,HBillNo_bak,HEntryID,HCloseMan" +
                          " (HInterID,HBillNo_bak,HEntryID,HSNO,HCloseMan" +
                          ",HEntryCloseDate,HCloseType,HRemark,HSourceInterID" +
                          ",HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
                           ",HQCCheckClassID,HQCCheckItemID,HQCStd,HQCRelValue,HResult" +
@@ -423,7 +423,7 @@
                          ",HRejectQty,HSampleUnRightQty,HStatus,HUnitID,HInspectVal,HTargetVal" +
                          ",HUpLimit,HDownLimit,HUpOffSet,HDownOffSet,HKeyInspect,HAnalysisMethod,HInspectInstruMentID,HInspectResult" +
                          ",HQCNote) values("
                          + HInterID + ",'" + HBillNo + "'," + num + ",''" +
                          + HInterID + ",'" + HBillNo + "'," + num + "," + (k -10) + "''" +
                          ",getdate(),0,''," + HProcExchInterID +
                          "," + HProcExchEntryID + ",'" + HProcExchBillNo + "','',0,0" +
                          ",0," + dataSet.Tables[0].Rows[i]["HQCCheckItemID"].ToString() + ",'" + dataSet.Tables[0].Rows[i]["HTargetVal"].ToString() + "','','" + HInSpectResult + "'" +
@@ -435,7 +435,7 @@
                                                num += 1;

                                                oCN.RunProc("Insert into QC_ProcessCheckBillSub " +
                          " (HInterID,HBillNo_bak,HEntryID,HCloseMan" +
                          " (HInterID,HBillNo_bak,HEntryID,HSNO,HCloseMan" +
                          ",HEntryCloseDate,HCloseType,HRemark,HSourceInterID" +
                          ",HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
                           ",HQCCheckClassID,HQCCheckItemID,HQCStd,HQCRelValue,HResult" +
@@ -443,7 +443,7 @@
                          ",HRejectQty,HSampleUnRightQty,HStatus,HUnitID,HInspectVal,HTargetVal" +
                          ",HUpLimit,HDownLimit,HUpOffSet,HDownOffSet,HKeyInspect,HAnalysisMethod,HInspectInstruMentID,HInspectResult" +
                          ",HQCNote) values("
                          + HInterID + ",'" + HBillNo + "'," + num + ",''" +
                          + HInterID + ",'" + HBillNo + "'," + num + "," + (k - 10) + ",''" +
                          ",getdate(),0,''," + HProcExchInterID +
                          "," + HProcExchEntryID + ",'" + HProcExchBillNo + "','',0,0" +
                          ",0," + dataSet.Tables[0].Rows[i]["HQCCheckItemID"].ToString() + ",'" + dataSet.Tables[0].Rows[i]["HTargetVal"].ToString() + "','','" + HInSpectResult + "'" +