| | |
| | | } |
| | | |
| | | |
| | | //添加产品或产品分类信息 |
| | | //添加信息 |
| | | public bool Add(GwOrder o) |
| | | { |
| | | StringBuilder stringBuilder = new StringBuilder(); |
| | |
| | | } |
| | | |
| | | //更新订单修改前余额 |
| | | 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; |
| | |
| | | ) > 0; |
| | | } |
| | | |
| | | //更新产品或产品分类信息 |
| | | //更新信息 |
| | | public bool Update(GwOrder o) |
| | | { |
| | | OracleParameter[] cmdParms = new OracleParameter[] { |
| | |
| | | GwOrder o = new GwOrder(); |
| | | if (string.IsNullOrEmpty(orderId)) |
| | | return o; |
| | | using (OracleDataReader reader = OracleHelper.ExecuteReader(string.Format("select gwo.*, gc.COMPANY, 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))) |
| | | 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()) |
| | | { |
| | |
| | | } |
| | | } |
| | | 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 "); |
| | | 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; |
| | | } |
| | | |
| | | //统计记录数 |
| | |
| | | o.OrderId = oracleReaderWrapper.GetString("ORDER_ID", ""); |
| | | o.SpId = oracleReaderWrapper.GetString("SP_ID", ""); |
| | | o.ClientId = oracleReaderWrapper.GetString("CLIENT_ID", ""); |
| | | o.Company = oracleReaderWrapper.GetString("COMPANY", ""); |
| | | o.Company = oracleReaderWrapper.GetString("Client_Name", ""); |
| | | o.ClientName = oracleReaderWrapper.GetString("CLIENT_NAME", ""); |
| | | o.ProductId = oracleReaderWrapper.GetString("PRODUCT_ID", ""); |
| | | o.ProductName = oracleReaderWrapper.GetString("PRODUCT_NAME", ""); |