| | |
| | | } |
| | | |
| | | //更新订单修改前余额 |
| | | 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; |
| | |
| | | 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()) |
| | | { |
| | |
| | | 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($" ) 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 "); |