特批申请单、信用额度申请单、收款单、应收退款单、销售订单变更单、生产订单变更单：列表查询顺序根据单据号降序排列

duhe

2023-11-12 8b8ad4b523f4625b29226617ded9ecd69a7f3332

 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,34 +468,16 @@
                //进行需要进行的审核/反审核操作
                if (IsAudit == 0) //审核提交
                {
                    //反写客户信用额度
                    oCN.BeginTran();
                    string sql = "select * from Gy_Customer_Credit where HCusID = " + oBill.omodel.HCusID;
                    ds = oCN.RunProcReturn(sql, "Gy_Customer_Credit");
                    if (ds.Tables[0].Rows.Count == 0)
                    {
                        sql = "insert into Gy_Customer_Credit" +
                            "(HCusID,HCreditRating_Now,HUpdateTime,HUpdateMan)" +
                            " values(" +
                            "" + oBill.omodel.HCusID +
                            "," + oBill.omodel.HNewRating +
                            ",'" + DateTime.Now.ToString("yyyy-MM-dd") + "'" +
                            ",'" + CurUserName + "'" +
                            ")";
                        oCN.RunProc(sql);
                    }
                    else
                    {
                        sql = "update Gy_Customer_Credit set " +
                            "HCreditRating_Now = " + oBill.omodel.HNewRating +
                            ",HUpdateTime = '" + DateTime.Now.ToString("yyyy-MM-dd") + "'" +
                            ",HUpdateMan = '" + CurUserName + "'" +
                            " where HCusID = " + oBill.omodel.HCusID;
                        oCN.RunProc(sql);
                    }
                    
                    
                    //审核提交
                    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";