器具维修派工单 删除

杨乐

2022-01-13 8b5b510f27ac7be8a7e92f90dcb7752850e7e466

 WebAPI/DLL/ClsSc_MESReturnStepWorkBill.cs

@@ -66,11 +66,12 @@
                oCn.RunProc("Insert Into Sc_ProcessPlanSub " +
                    "(HInterID,HEntryID,HBillNo" +
                    ",HICMOInterID,HICMOBillNo,HProcNo,HProcID" +
                    ",HGroupID,HDeptID,HWorkerID,HQty,HPlanBeginDate" +
                    ",HGroupID,HDeptID,HWorkerID,HQty,HPlanBeginDate,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType" +
                    ") " +
                    " values(" + omodel.HInterID.ToString() + ",0,'" + omodel.HBillNo +
                    "'," + omodel.HICMOInterID.ToString() + ",'" + omodel.HICMOBillNo + "','" + omodel.HProcNo + "'," + omodel.HProcID.ToString() + "," + omodel.HGroupID.ToString() +
                    "," + omodel.HDeptID.ToString() + "," + omodel.HWorkerID.ToString() + "," + omodel.HQty.ToString() + ",'" + omodel.HPlanBeginDate.ToString() +
                    "," + omodel.HDeptID.ToString() + "," + omodel.HWorkerID.ToString() + "," + omodel.HQty.ToString() + ",'" + omodel.HPlanBeginDate.ToString() + "'," + omodel.HSourceInterID.ToString() +
                    "," + omodel.HSourceEntryID.ToString() + ",'" + omodel.HSourceBillNo + "','" + omodel.HSourceBillType +
                     "') ");
                sReturn = "修改单据成功！";
                oCn.Commit();
@@ -106,12 +107,13 @@
                oCn.RunProc("Insert Into Sc_ProcessPlanSub " +
                    "(HInterID,HEntryID,HBillNo" +
                    ",HICMOInterID,HICMOBillNo,HProcNo,HProcID" +
                    ",HGroupID,HDeptID,HWorkerID,HQty,HPlanBeginDate" +
                    ",HGroupID,HDeptID,HWorkerID,HQty,HPlanBeginDate,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HSourceID" +
                    ") " +
                    " values(" + omodel.HInterID.ToString() + ",0,'" + omodel.HBillNo +
                    "'," + omodel.HICMOInterID.ToString() + ",'" + omodel.HICMOBillNo + "','" + omodel.HProcNo + "'," + omodel.HProcID.ToString() + "," + omodel.HGroupID.ToString() +
                    "," + omodel.HDeptID.ToString() + "," + omodel.HWorkerID.ToString() + "," + omodel.HQty.ToString() + ",'" + omodel.HPlanBeginDate.ToString() +
                     "') ");
                    "," + omodel.HDeptID.ToString() + "," + omodel.HWorkerID.ToString() + "," + omodel.HQty.ToString() + ",'" + omodel.HPlanBeginDate.ToString() +"',"+ omodel.HSourceInterID.ToString()+
                    ","+ omodel.HSourceEntryID.ToString()+",'"+ omodel.HSourceBillNo+"','"+ omodel.HSourceBillType+","+ omodel.HSourceID.ToString()+
                     ") ");
                sReturn = "新增单据成功！";
                oCn.Commit();
                return true;