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