智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
yangle
2023-11-13 0e63b6a9fc9d9d4c07244edeb54233bbccacae24 
 WebAPI/Controllers/SCGL/Sc_ICMOChangeBillController.cs


@@ -487,8 +487,7 @@


                        return objJsonResult;


                    }




                    //反写源单数据


                    oCN.BeginTran();


                    //检查源单是否存在


                    string sql = "select * from Sc_ICMOBillSub where HInterID = " + oBill.omodel.HMainSourceInterID + " and HEntryID =" + oBill.omodel.HMainSourceEntryID;


                    ds = oCN.RunProcReturn(sql, "Sc_ICMOBillSub");


                    if(ds==null || ds.Tables[0].Rows.Count == 0)


@@ -499,12 +498,14 @@


                        objJsonResult.data = null;


                        return objJsonResult;


                    }


                    sql = "update Sc_ICMOBillSub set HQty = " + oBill.DetailColl[0].HQty_New + " where HInterID = " + oBill.omodel.HMainSourceInterID + " and HEntryID =" + oBill.omodel.HMainSourceEntryID;


                    oCN.RunProc(sql);




                    


                    //审核提交


                    if (oBill.CheckBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true)


                    {


                        //反写源单数据


                        oCN.BeginTran();


                        sql = "exec h_p_Sc_ICMOBill_ReWriteByICMOChangeBill " + oBill.omodel.HInterID;


                        oCN.RunProc(sql);


                        oCN.Commit();




                        objJsonResult.code = "1";