优化待审核页面

wzp

2022-11-23 c3acb0bf589ba6de244e4eae737152688e5d3e61

 web/Dao/GwOrderDao.cs

@@ -169,7 +169,7 @@
        }


        //添加产品或产品分类信息
        //添加信息
        public bool Add(GwOrder o)
        {
            StringBuilder stringBuilder = new StringBuilder();
@@ -224,24 +224,23 @@
        }

        //更新订单修改前余额
        public bool UpdateBalanceAndStatus(int basicNum, int givingNum, int orderNumTotal, int orderAmountTotal, int payAmount , int beforeGivingNum, int orderStatus, string orderId )
        public bool UpdateBalanceAndStatus(Int64 basicNum, Int64 givingNum, Int64 orderNumTotal, Int64 orderAmountTotal, Int64 payAmount , Int64 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, PAY_AMOUNT=:PAY_AMOUNT, 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, 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)
                ) > 0;
        }

        //更新产品或产品分类信息
        //更新信息
        public bool Update(GwOrder o)
        {
            OracleParameter[] cmdParms = new OracleParameter[] {
@@ -285,7 +284,7 @@
            GwOrder o = new GwOrder();
            if (string.IsNullOrEmpty(orderId))
                return o;
            using (OracleDataReader reader = OracleHelper.ExecuteReader(string.Format("select * from GW_ORDER where ORDER_ID=:ORDER_ID"), OracleHelper.Connection, new OracleParameter(":ORDER_ID", (object)orderId)))
            using (OracleDataReader reader = OracleHelper.ExecuteReader(string.Format("select gwo.*, gc.Client_Name, gp.name PRODUCT_NAME from gw_order gwo left join gw_client gc on gc.client_id = gwo.client_id left join gw_product gp on gp.id = gwo.product_id where gwo.ORDER_ID=:ORDER_ID"), OracleHelper.Connection, new OracleParameter(":ORDER_ID", (object)orderId)))
            {
                if (((DbDataReader)reader).Read())
                {
@@ -294,6 +293,76 @@
                }
            }
            return o;
        }

        //今日已完成订单数及总额
        public List<Dictionary<string, object>> GetOrderDay(string permissionsSQL)
        {
            List<Dictionary<string, object>> list = new List<Dictionary<string, object>>();
            StringBuilder builder = new StringBuilder();
            builder.Append(" SELECT COUNT(1) order_num, SUM(order_amount_total) order_amount_total FROM ( ");
            builder.Append(" SELECT a.order_id, a.client_id, a.status, a.order_amount_total ");
            builder.Append(" , CASE WHEN b.update_time is null then TO_CHAR(a.create_time, 'yyyyMMdd') ELSE TO_CHAR(b.update_time, 'yyyyMMdd') END AS update_time ");
            builder.Append(" FROM gw_order a ");
            builder.Append(" LEFT JOIN ( ");
            builder.Append(" SELECT order_id, max(audit_time) update_time FROM gw_order_audit goa ");
            builder.Append(" GROUP BY order_id ");
            builder.Append($" ) b ON b.order_id = a.order_id where update_time>=TO_date('{DateTime.Now.Date}','yyyy-MM-dd HH24:mi:ss')  ");
            builder.Append(" ) ");
            builder.Append(" WHERE 1=1 AND status=2 ");
            //builder.Append(" AND update_time=:UPDATE_TIME ");
            builder.Append(permissionsSQL);

            //using (OracleDataReader reader = OracleHelper.ExecuteReader(builder.ToString(), OracleHelper.Connection, new OracleParameter(":UPDATE_TIME", (object)DateTime.Now.ToString("yyyyMMdd"))))
            using (OracleDataReader reader = OracleHelper.ExecuteReader(builder.ToString(), OracleHelper.Connection))
            {
                while (reader != null && ((DbDataReader)reader).Read())
                {
                    OracleReaderWrapper oracleReaderWrapper = new OracleReaderWrapper(reader);
                    int orderNum = oracleReaderWrapper.GetInt("ORDER_NUM", 0);
                    int orderAmountTotal = oracleReaderWrapper.GetInt("ORDER_AMOUNT_TOTAL", 0);

                    Dictionary<string, object> map = new Dictionary<string, object>();
                    map.Add("orderNum", orderNum);
                    map.Add("orderAmountTotal", orderAmountTotal);
                    list.Add(map);
                }
            }
            return list;
        }

        //待审核订单数及总额
        public List<Dictionary<string, object>> GetOrderAudit(string permissionsSQL)
        {
            List<Dictionary<string, object>> list = new List<Dictionary<string, object>>();
            StringBuilder builder = new StringBuilder();
            builder.Append(" SELECT COUNT(1) order_num, SUM(order_amount_total) order_amount_total FROM ( ");
            builder.Append(" SELECT a.order_id, a.client_id, a.status, a.order_amount_total ");
            //builder.Append(" , CASE WHEN b.update_time is null then TO_CHAR(a.create_time, 'yyyyMMdd') ELSE TO_CHAR(b.update_time, 'yyyyMMdd') END AS update_time ");
            builder.Append(" FROM gw_order a ");
            builder.Append(" LEFT JOIN ( ");
            builder.Append(" SELECT order_id, max(audit_time) update_time FROM gw_order_audit goa ");
            builder.Append(" GROUP BY order_id ");
            builder.Append(" ) b ON b.order_id = a.order_id ");
            builder.Append(" ) ");
            builder.Append(" WHERE 1=1 AND status IN (0,1) ");
            builder.Append(permissionsSQL);

            using (OracleDataReader reader = OracleHelper.ExecuteReader(builder.ToString(), OracleHelper.Connection))
            {
                while (reader != null && ((DbDataReader)reader).Read())
                {
                    OracleReaderWrapper oracleReaderWrapper = new OracleReaderWrapper(reader);
                    int orderNum = oracleReaderWrapper.GetInt("ORDER_NUM", 0);
                    int orderAmountTotal = oracleReaderWrapper.GetInt("ORDER_AMOUNT_TOTAL", 0);

                    Dictionary<string, object> map = new Dictionary<string, object>();
                    map.Add("orderNum", orderNum);
                    map.Add("orderAmountTotal", orderAmountTotal);
                    list.Add(map);
                }
            }
            return list;
        }

        //统计记录数
@@ -313,6 +382,7 @@
            o.Company = oracleReaderWrapper.GetString("COMPANY", "");
            o.ClientName = oracleReaderWrapper.GetString("CLIENT_NAME", "");
            o.ProductId = oracleReaderWrapper.GetString("PRODUCT_ID", "");
            o.ProductName = oracleReaderWrapper.GetString("PRODUCT_NAME", "");
            o.ComboId = oracleReaderWrapper.GetString("COMBO_ID", "");
            o.BasicNum = oracleReaderWrapper.GetInt("BASIC_NUM", 0);
            o.GivingNum = oracleReaderWrapper.GetInt("GIVING_NUM", 0);