| | |
|---|
| | | return OracleHelper.ExecuteSql("update GW_ORDER SET STATUS = :STATUS where ORDER_ID=:ORDER_ID", OracleHelper.Connection, new OracleParameter(":STATUS", (object)status), new OracleParameter(":ORDER_ID", (object)orderId)) > 0; |
|---|
| | | } |
|---|
| | | |
|---|
| | | //更新订单修改前余额 |
|---|
| | | public bool UpdateBalanceAndStatus(int basicNum, int givingNum, int orderNumTotal, int orderAmountTotal, 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 |
|---|
| | | , 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(":BEFORE_BALANCE_NUM", (object)beforeGivingNum) |
|---|
| | | , new OracleParameter(":STATUS", (object)orderStatus) |
|---|
| | | , new OracleParameter(":ORDER_ID", (object)orderId) |
|---|
| | | ) > 0; |
|---|
| | | } |
|---|
| | | |
|---|
| | | //更新产品或产品分类信息 |
|---|
| | | public bool Update(GwOrder o) |
|---|
| | | { |
|---|
