各工序趋势图后端查询

zrg

2024-08-30 52fdbb3d0c065abc0bba434188c98affed024e76

 DAL/¹¤Î»¿´°å/ClsGy_SOPBill.cs

@@ -88,7 +88,12 @@
            try
            {
                //得到mainid
                omodel.HInterID = DBUtility.ClsPub.CreateBillID(BillType, ref DBUtility.ClsPub.sExeReturnInfo);
                if (omodel.HInterID.ToString() == null || omodel.HInterID == 0 || omodel.HInterID.ToString() == "undefined")
                {
                    omodel.HInterID = DBUtility.ClsPub.CreateBillID(BillType, ref DBUtility.ClsPub.sExeReturnInfo);
                }

               
                //若MAINDI重复则重新获取
                oCn.BeginTran();
                //主表
@@ -106,10 +111,11 @@
                {
                    oCn.RunProc("Insert into Gy_SOPBillSub " +
                          "(HInterID,HEntryID,HProcID,HProcNO" +
                          ",HWorkStationID,HCenterID,HRemark" +
                          ",HWorkStationID,HCenterID,HRemark,HSourceID,HMouldID" +
                          ") values("
                          + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + "," + oSub.HProcID.ToString() + "," + oSub.HProcNo.ToString() +
                          "," + oSub.HWorkStationID.ToString() + "," + oSub.HCenterID.ToString() + ",'" + oSub.HRemark.ToString() + "'" +
                          "," + oSub.HWorkStationID.ToString() + "," + oSub.HCenterID.ToString() + ",'" + oSub.HRemark.ToString() + "'," + oSub.HSourceID +
                          "," + oSub.HMouldID +
                          ") ");
                }
                sReturn = "新增单据成功！";