Merge branch 'master' of http://101.37.171.70:10101/r/MES-WEB-API

YL

2022-02-21 a905b3df0d0c9ae045b51d1299fbb2f2dcbc2e2d

 WebAPI/DLL/ClsSc_MouldProdBackBill.cs

@@ -79,7 +79,7 @@
                        //",HPOOrderInterID,HPOOrderEntryID,HPOOrderBillNo" +
                        //",HSeOrderInterID,HSeOrderEntryID,HSeOrderBillNo" +
                        ",HNewModel,HWallThickness,HHardness,HLastProdModel,HDiameter,HBackFlag" +
                        ",HQtyRel" +
                        ",HQtyRel,HStockOrgID" +

                        ") values("
                        + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + ",'" + oSub.HCloseMan + "','" + oSub.HEntryCloseDate.ToShortDateString() + "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'" +
@@ -91,7 +91,7 @@
                        //"," + oSub.HPOOrderInterID.ToString() + "," + oSub.HPOOrderEntryID.ToString() + ",'" + oSub.HPOOrderBillNo + "'" +
                        //"," + oSub.HSeOrderInterID.ToString() + "," + oSub.HSeOrderEntryID.ToString() + ",'" + oSub.HSeOrderBillNo + "'" +
                        ",'" + oSub.HNewModel + "','" + oSub.HWallThickness + "','" + oSub.HHardness + "','" + oSub.HLastProdModel + "','" + oSub.HDiameter + "','" + oSub.HBackFlag + "'" +
                        "," + 0 +
                        "," + 0 + "," + oSub.HStockOrgID.ToString() +
                        ") ");
                }
                //
@@ -137,7 +137,6 @@
                ", " + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "','" + omodel.HMaker+ "',getdate()" +
                ", " + omodel.HSupTypeID.ToString() + "," + omodel.HSupID.ToString() + "," + omodel.HWHID.ToString() + "," + omodel.HSCWHID.ToString() + "," + omodel.HEmpID.ToString() + "," + omodel.HManagerID.ToString() + "," + omodel.HSecManagerID.ToString() +
                ", " + omodel.HKeeperID.ToString() + "," + omodel.HDeptID.ToString() + ",'" + omodel.HExplanation + "','" + omodel.HInnerBillNo + "'," + DBUtility.ClsPub.BoolToString(omodel.HRedBlueFlag) +
          
                ") ");
                //插入子表
                foreach (Model.ClsSc_MouldProdBackBillSub oSub in DetailColl)
@@ -153,7 +152,7 @@
                      //",HPOOrderInterID,HPOOrderEntryID,HPOOrderBillNo" +
                      //",HSeOrderInterID,HSeOrderEntryID,HSeOrderBillNo" +
                      ",HNewModel,HWallThickness,HHardness,HLastProdModel,HDiameter,HBackFlag" +
                      ",HQtyRel"+
                      ",HQtyRel,HStockOrgID" +

                      ") values("
                      + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + ",'" + oSub.HCloseMan + "','" + oSub.HEntryCloseDate.ToShortDateString() + "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'" +
@@ -165,7 +164,7 @@
                      //"," + oSub.HPOOrderInterID.ToString() + "," + oSub.HPOOrderEntryID.ToString() + ",'" + oSub.HPOOrderBillNo + "'" +
                      //"," + oSub.HSeOrderInterID.ToString() + "," + oSub.HSeOrderEntryID.ToString() + ",'" + oSub.HSeOrderBillNo + "'" +
                      ",'" + oSub.HNewModel + "','" + oSub.HWallThickness + "','" + oSub.HHardness + "','" + oSub.HLastProdModel + "','" + oSub.HDiameter + "','" + oSub.HBackFlag + "'" +
                      ","+0+
                      ","+0+ "," + oSub.HStockOrgID.ToString() +
                      ") ");
                }
                //