| | |
|---|
| | | * clientId：客户ID |
|---|
| | | * |
|---|
| | | */ |
|---|
| | | public bool UpdateClientAmount(int AddBalance, int payAmount, string clientId ) |
|---|
| | | public bool UpdateClientAmount(Int64 AddBalance, Int64 payAmount, string clientId ) |
|---|
| | | { |
|---|
| | | return OracleHelper.ExecuteSql("UPDATE GW_CLIENT SET BALANCE=(BALANCE + :BALANCE), TOP_UP_AMOUNT_TOTAL=(TOP_UP_AMOUNT_TOTAL + :TOP_UP_AMOUNT_TOTAL) WHERE CLIENT_ID=:CLIENT_ID", OracleHelper.Connection, new OracleParameter(":BALANCE", (object)AddBalance), new OracleParameter(":TOP_UP_AMOUNT_TOTAL", (object)payAmount), new OracleParameter(":CLIENT_ID", (object)clientId)) > 0; |
|---|
| | | } |
|---|
