| | |
|---|
| | | return OracleHelper.ExecuteSql("UPDATE GW_SP SET ALARM_MOBILE=:ALARM_MOBILE,BALANCE_THRESHOLD=:BALANCE_THRESHOLD WHERE CLIENT_ID=:CLIENT_ID", OracleHelper.Connection, new OracleParameter(":ALARM_MOBILE", (object)client.AlarmMobile), new OracleParameter(":BALANCE_THRESHOLD", (object)client.BalanceThreshold), new OracleParameter(":CLIENT_ID", (object)client.ClientID)) > 0; |
|---|
| | | } |
|---|
| | | |
|---|
| | | //更新充值金额AMOUNT |
|---|
| | | public bool UpdateClientAmount(GwClient client) |
|---|
| | | { |
|---|
| | | return OracleHelper.ExecuteSql("UPDATE GW_CLIENT SET BALANCE=:BALANCE, TOP_UP_AMOUNT_TOTAL=:TOP_UP_AMOUNT_TOTAL WHERE CLIENT_ID=:CLIENT_ID", OracleHelper.Connection, new OracleParameter(":BALANCE", (object)client.Balance), new OracleParameter(":TOP_UP_AMOUNT_TOTAL", (object)client.Top_up_Amount_Total), new OracleParameter(":CLIENT_ID", (object)client.ClientID)) > 0; |
|---|
| | | } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 更新账号的信息 |
|---|
| | | /// </summary> |
|---|
| | |
|---|
| | | o.Agent = oracleReaderWrapper.GetString("AGENT", ""); |
|---|
| | | o.AlarmMobile = oracleReaderWrapper.GetString("ALARM_MOBILE", ""); |
|---|
| | | o.BalanceThreshold = oracleReaderWrapper.GetInt("BALANCE_THRESHOLD", 0); |
|---|
| | | o.Balance = oracleReaderWrapper.GetInt("BALANCE", 0); |
|---|
| | | o.PermissionData = oracleReaderWrapper.GetString("PERMISSION_DATA", ""); |
|---|
| | | o.Id = oracleReaderWrapper.GetInt("ID", 0); |
|---|
| | | o.Certification_Status = oracleReaderWrapper.GetInt("CERTIFICATION_STATUS", 0); |
|---|
