销售出库单：源单选择，新增时保存主表和子表源单信息

duhe

2023-11-13 108f3eaf33cd723201454d567db753643e97a120

 WebAPI/Controllers/XSGL/Xs_CusRatingChangeBillController.cs

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

                if (sWhere == null || sWhere.Equals(""))
                {
                    ds = oCN.RunProcReturn("select * from h_v_Xs_CusRatingChangeBillList_Query order by 单据号 ", "h_v_Xs_CusRatingChangeBillList_Query");
                    ds = oCN.RunProcReturn("select * from h_v_Xs_CusRatingChangeBillList_Query order by 单据号 desc", "h_v_Xs_CusRatingChangeBillList_Query");
                }
                else
                {
                    string sql1 = "select * from h_v_Xs_CusRatingChangeBillList_Query where 1 = 1 ";
                    string sql = sql1 + sWhere + " order by 单据号 ";
                    string sql = sql1 + sWhere + " order by 单据号 desc";
                    ds = oCN.RunProcReturn(sql, "h_v_Xs_CusRatingChangeBillList_Query");
                }

@@ -468,9 +468,18 @@
                //进行需要进行的审核/反审核操作
                if (IsAudit == 0) //审核提交
                {
                    
                    
                    //审核提交
                    if (oBill.CheckBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true)
                    {

                        //反写客户信用额度
                        oCN.BeginTran();
                        string sql = "exec h_p_Xs_CusRatingChangeBill_ReWriteCustomerCredit " + oBill.omodel.HCusID + "," + oBill.omodel.HNewRating + ",'" + CurUserName + "'";
                        oCN.RunProc(sql);
                        oCN.Commit();

                        objJsonResult.code = "1";
                        objJsonResult.count = 1;
                        objJsonResult.Message = "审核成功";