智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
yusijie
2023-11-15 33cfe29fcdd731c3c759dcae74bdcfaeecd309ea 
 WebAPI/Controllers/XSGL/Xs_ExceptiveCheckRequestBillController.cs


@@ -48,12 +48,12 @@




                if (sWhere == null || sWhere.Equals(""))


                {


                    ds = oCN.RunProcReturn("select * from h_v_Xs_ExceptiveCheckRequestBillList_Query order by 单据号 ", "h_v_Xs_ExceptiveCheckRequestBillList_Query");


                    ds = oCN.RunProcReturn("select * from h_v_Xs_ExceptiveCheckRequestBillList_Query order by 单据号 desc", "h_v_Xs_ExceptiveCheckRequestBillList_Query");


                }


                else


                {


                    string sql1 = "select * from h_v_Xs_ExceptiveCheckRequestBillList_Query where 1 = 1 ";


                    string sql = sql1 + sWhere + " order by 单据号 ";


                    string sql = sql1 + sWhere + " order by 单据号 desc";


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


                }




@@ -469,8 +469,15 @@


                if (IsAudit == 0) //审核提交


                {


                    //审核提交


                    //oBill.oCn.BeginTran();


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


                    {


                        //审核源单


                        oCN.BeginTran();


                        string sql = "exec h_p_Xs_ExceptiveCheckRequestBill_ReWriteSourceStatus " + oBill.omodel.HMainSourceInterID + ",'" + oBill.omodel.HMainSourceBillType + "','" + CurUserName + "'";


                        oCN.RunProc(sql);


                        oCN.Commit();


                       


                        objJsonResult.code = "1";


                        objJsonResult.count = 1;


                        objJsonResult.Message = "审核成功";


@@ -479,6 +486,7 @@


                    }


                    else


                    {


                        //oBill.oCn = new SQLHelper.ClsCN();


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "审核失败!原因:" + DBUtility.ClsPub.sExeReturnInfo;