充值功能优化，客户表增加余额、订单表增加充值金额

yzh

2022-05-10 a027508b5818236d0a46bc7036394c63978a68b0

 web/Dao/GwOrderDao.cs

@@ -170,11 +170,11 @@
        {
            StringBuilder stringBuilder = new StringBuilder();
            stringBuilder.Append("INSERT INTO GW_ORDER ( ");
            stringBuilder.Append(" ORDER_ID, SP_ID, CLIENT_ID, PRODUCT_ID, COMBO_ID, BASIC_NUM, GIVING_NUM, PRICE, ORDER_NUM_TOTAL, ORDER_AMOUNT_TOTAL, BEFORE_BALANCE_NUM ");
            stringBuilder.Append(" ORDER_ID, SP_ID, CLIENT_ID, PRODUCT_ID, COMBO_ID, BASIC_NUM, GIVING_NUM, PRICE, ORDER_NUM_TOTAL, ORDER_AMOUNT_TOTAL, PAY_AMOUNT, BEFORE_BALANCE_NUM ");
            stringBuilder.Append(" , CREATOR, CREATE_TIME, STATUS, REMARK ");
            //stringBuilder.Append(" , AUDITOR, AUDIT_TIME ");
            stringBuilder.Append(" ) ");
            stringBuilder.Append(" VALUES (:ORDER_ID, :SP_ID, :CLIENT_ID, :PRODUCT_ID, :COMBO_ID, :BASIC_NUM, :GIVING_NUM, :PRICE, :ORDER_NUM_TOTAL, :ORDER_AMOUNT_TOTAL, :BEFORE_BALANCE_NUM ");
            stringBuilder.Append(" VALUES (:ORDER_ID, :SP_ID, :CLIENT_ID, :PRODUCT_ID, :COMBO_ID, :BASIC_NUM, :GIVING_NUM, :PRICE, :ORDER_NUM_TOTAL, :ORDER_AMOUNT_TOTAL, :PAY_AMOUNT, :BEFORE_BALANCE_NUM ");
            stringBuilder.Append(" , :CREATOR, :CREATE_TIME, :STATUS, :REMARK ");
            //stringBuilder.Append(" , :AUDITOR, :AUDIT_TIME ");
            stringBuilder.Append("  ) ");
@@ -193,6 +193,7 @@
                new OracleParameter(":PRICE", (object)o.Price),
                new OracleParameter(":ORDER_NUM_TOTAL", (object)o.OrderNumTotal),
                new OracleParameter(":ORDER_AMOUNT_TOTAL", (object)o.OrderAmountTotal),
                new OracleParameter(":PAY_AMOUNT", (object)o.PayAmount),
                new OracleParameter(":BEFORE_BALANCE_NUM", (object)o.BeforeBalanceNum),
                new OracleParameter(":CREATOR", (object)o.Creator),
                new OracleParameter(":CREATE_TIME", (object)o.CreateTime),
@@ -219,16 +220,17 @@
        }

        //更新订单修改前余额
        public bool UpdateBalanceAndStatus(int basicNum, int givingNum, int orderNumTotal, int orderAmountTotal, int beforeGivingNum , int orderStatus, string orderId )
        public bool UpdateBalanceAndStatus(int basicNum, int givingNum, int orderNumTotal, int orderAmountTotal, int payAmount , int beforeGivingNum, int orderStatus, string orderId )
        {
            if (string.IsNullOrEmpty(orderId))
                return false;
            //status:4-取消
            return OracleHelper.ExecuteSql("update GW_ORDER SET BASIC_NUM=:BASIC_NUM, GIVING_NUM=:GIVING_NUM, ORDER_NUM_TOTAL=:ORDER_NUM_TOTAL, ORDER_AMOUNT_TOTAL=:ORDER_AMOUNT_TOTAL, BEFORE_BALANCE_NUM=:BEFORE_BALANCE_NUM, STATUS = :STATUS where ORDER_ID=:ORDER_ID", OracleHelper.Connection
            return OracleHelper.ExecuteSql("update GW_ORDER SET BASIC_NUM=:BASIC_NUM, GIVING_NUM=:GIVING_NUM, ORDER_NUM_TOTAL=:ORDER_NUM_TOTAL, ORDER_AMOUNT_TOTAL=:ORDER_AMOUNT_TOTAL, PAY_AMOUNT=:PAY_AMOUNT, BEFORE_BALANCE_NUM=:BEFORE_BALANCE_NUM, STATUS = :STATUS where ORDER_ID=:ORDER_ID", OracleHelper.Connection
                , new OracleParameter(":BASIC_NUM", (object)basicNum)
                , new OracleParameter(":GIVING_NUM", (object)givingNum)
                , new OracleParameter(":ORDER_NUM_TOTAL", (object)orderNumTotal)
                , new OracleParameter(":ORDER_AMOUNT_TOTAL", (object)orderAmountTotal)
                , new OracleParameter(":PAY_AMOUNT", (object)payAmount)
                , new OracleParameter(":BEFORE_BALANCE_NUM", (object)beforeGivingNum)
                , new OracleParameter(":STATUS", (object)orderStatus)
                , new OracleParameter(":ORDER_ID", (object)orderId)
@@ -249,6 +251,7 @@
                new OracleParameter(":PRICE", (object)o.Price),
                new OracleParameter(":ORDER_NUM_TOTAL", (object)o.OrderNumTotal),
                new OracleParameter(":ORDER_AMOUNT_TOTAL", (object)o.OrderAmountTotal),
                new OracleParameter(":PAY_AMOUNT", (object)o.PayAmount),
                new OracleParameter(":BEFORE_BALANCE_NUM", (object)o.BeforeBalanceNum),
                new OracleParameter(":CREATOR", (object)o.Creator),
                new OracleParameter(":CREATE_TIME", (object)o.CreateTime),
@@ -264,7 +267,7 @@
            stringBuilder.Append(" , PRODUCT_ID =:PRODUCT_ID ");
            stringBuilder.Append(" , COMBO_ID =:COMBO_ID ");
            stringBuilder.Append(" , BASIC_NUM=:BASIC_NUM, GIVING_NUM=:GIVING_NUM, PRICE=:PRICE, ORDER_NUM_TOTAL=:ORDER_NUM_TOTAL, ORDER_AMOUNT_TOTAL=:ORDER_AMOUNT_TOTAL ");
            stringBuilder.Append(" , BEFORE_BALANCE_NUM =:BEFORE_BALANCE_NUM, CREATOR=:CREATOR, CREATE_TIME=:CREATE_TIME ");
            stringBuilder.Append(" , PAY_AMOUNT =:PAY_AMOUNT, BEFORE_BALANCE_NUM =:BEFORE_BALANCE_NUM, CREATOR=:CREATOR, CREATE_TIME=:CREATE_TIME ");
            stringBuilder.Append(" , STATUS=:STATUS, REMARK=:REMARK ");
            stringBuilder.Append(" WHERE ORDER_ID=:ORDER_ID ");

@@ -311,6 +314,7 @@
            o.Price = oracleReaderWrapper.GetInt("PRICE", 0);
            o.OrderNumTotal = oracleReaderWrapper.GetInt("ORDER_NUM_TOTAL", 0);
            o.OrderAmountTotal = oracleReaderWrapper.GetInt("ORDER_AMOUNT_TOTAL", 0);
            o.PayAmount = oracleReaderWrapper.GetInt("PAY_AMOUNT", 0);
            o.BeforeBalanceNum = oracleReaderWrapper.GetInt("BEFORE_BALANCE_NUM", 0);
            o.Creator = oracleReaderWrapper.GetString("CREATOR", "");
            o.CreateTime = oracleReaderWrapper.GetDateTime("CREATE_TIME");