| | |
|---|
| | | |
|---|
| | | public bool Update(GwSp o) |
|---|
| | | { |
|---|
| | | /** |
|---|
| | | StringBuilder stringBuilder = new StringBuilder(); |
|---|
| | | stringBuilder.Append("UPDATE GW_SP SET "); |
|---|
| | | stringBuilder.Append(" AP_ID=:APID, COMBINATION_MODE=:COMBINATION_MODE,CLIENT_ID=:CLIENTID,STRATEGY_ID=:STRATEGYID,PASSWORD=:PASSWORD "); |
|---|
| | | stringBuilder.Append(" , CLIENT_IP=:CLIENTIP,CLIENT_PORT=:CLIENTPORT,ACCESS_CODE=:ACCESSCODE "); |
|---|
| | | stringBuilder.Append(" , PRIORITY=:PRIORITY,PRICE=:PRICE,CHARGE_TYPE=:CHARGETYPE "); |
|---|
| | | stringBuilder.Append(" , THRESHOLD=:THRESHOLD,MAX_CONN_COUNT=:MAXCONNCOUNT,REMARK=:REMARK "); |
|---|
| | | stringBuilder.Append(" , TIME_PERMITTING=:TIME_PERMITTING,AUDITING_MODE=:AUDITINGMODE "); |
|---|
| | | stringBuilder.Append(" , DEDUCT_PERCENT=:DEDUCTPERCENT "); |
|---|
| | | stringBuilder.Append(" , CM_OP_ID=:CM_OP_ID,CT_OP_ID=:CT_OP_ID,UN_OP_ID=:UN_OP_ID "); |
|---|
| | | stringBuilder.Append(" , DEFISHING_TIMEOUT = :DEFISHING_TIMEOUT,DEFISHING_THRESHOLD =:DEFISHING_THRESHOLD "); |
|---|
| | | stringBuilder.Append(" , REJECT_IF_FORBIDDEN =:REJECT_IF_FORBIDDEN "); |
|---|
| | | stringBuilder.Append(" , REFUND_IF_UNDELIVERED =:REFUND_IF_UNDELIVERED "); |
|---|
| | | stringBuilder.Append(" , ROUTER_TYPE=:ROUTER_TYPE,STATUS=:STATUS,ACCESSCODE_MODE=:ACCESSCODE_MODE "); |
|---|
| | | stringBuilder.Append(" , EXTNOEXTENSION_MODE=:EXTNOEXTENSION_MODE,DEFISHING_OP_ID =:DEFISHING_OP_ID "); |
|---|
| | | stringBuilder.Append(" , MODIFY_TIME=SYSDATE,FEE_SHORT_LENGTH=:FEE_SHORT_LENGTH,FEE_LONG_LENGTH=:FEE_LONG_LENGTH "); |
|---|
| | | stringBuilder.Append(" , BLACK_MODE=:BLACK_MODE "); |
|---|
| | | stringBuilder.Append(" , DIVERTER_ID=:DIVERTER_ID "); |
|---|
| | | stringBuilder.Append(" , MCPM=:MCPM "); |
|---|
| | | stringBuilder.Append(" , MC_EXPRESSION=:MC_EXPRESSION "); |
|---|
| | | stringBuilder.Append(" , CM_EXT_PARAMS=:CM_EXT_PARAMS "); |
|---|
| | | stringBuilder.Append(" , CT_EXT_PARAMS=:CT_EXT_PARAMS "); |
|---|
| | | stringBuilder.Append(" , CU_EXT_PARAMS=:CU_EXT_PARAMS "); |
|---|
| | | stringBuilder.Append(" , CM_GROUP_ID=:CM_GROUP_ID "); |
|---|
| | | stringBuilder.Append(" , CU_GROUP_ID=:CU_GROUP_ID "); |
|---|
| | | stringBuilder.Append(" , CT_GROUP_ID=:CT_GROUP_ID "); |
|---|
| | | stringBuilder.Append(" , BALANCE_THRESHOLD = :BALANCE_THRESHOLD "); |
|---|
| | | stringBuilder.Append(" , ALARM_MOBILE = :ALARM_MOBILE "); |
|---|
| | | stringBuilder.Append(" , FORCE_SIGN_FLAG = :FORCE_SIGN_FLAG "); |
|---|
| | | stringBuilder.Append(" , FORCE_SIGN = :FORCE_SIGN "); |
|---|
| | | stringBuilder.Append(" , SIGNATURE_MODE=:SIGNATURE_MODE "); |
|---|
| | | stringBuilder.Append(" , SIGNATURES=:SIGNATURESE "); |
|---|
| | | stringBuilder.Append(" , VerCodeMode=:VerCodeMode "); |
|---|
| | | stringBuilder.Append(" , ProvincialNetworkMode=:ProvincialNetworkMode "); |
|---|
| | | stringBuilder.Append(" , RESEND_STATUS =:RESEND_STATUS "); |
|---|
| | | stringBuilder.Append(" , RESEND_CM_GROUPID =:RESEND_CM_GROUPID "); |
|---|
| | | stringBuilder.Append(" , RESEND_CU_GROUPID =:RESEND_CU_GROUPID "); |
|---|
| | | stringBuilder.Append(" , RESEND_CT_GROUPID =:RESEND_CT_GROUPID "); |
|---|
| | | stringBuilder.Append(" , RANSFERFLAG =:TRANSFERFLAG "); |
|---|
| | | stringBuilder.Append(" WHERE SP_ID=:SPID" ); |
|---|
| | | |
|---|
| | | |
|---|
| | | return OracleHelper.ExecuteSql(stringBuilder.ToString(), OracleHelper.Connection, |
|---|
| | | new OracleParameter(":APID", (object)o.ApID), |
|---|
| | | new OracleParameter(":COMBINATION_MODE", (object)o.CombinationMode), |
|---|
| | | new OracleParameter(":CLIENTID", (object)o.ClientID), |
|---|
| | | new OracleParameter(":STRATEGYID", (object)o.StrategyID), |
|---|
| | | new OracleParameter(":PASSWORD", (object)o.Password), |
|---|
| | | new OracleParameter(":CLIENTIP", (object)o.ClientIp), |
|---|
| | | new OracleParameter(":CLIENTPORT", (object)o.ClientPort), |
|---|
| | | new OracleParameter(":ACCESSCODE", (object)o.AccessCode), |
|---|
| | | new OracleParameter(":PRIORITY", (object)o.Priority), |
|---|
| | | new OracleParameter(":PRICE", (object)o.Price), |
|---|
| | | new OracleParameter(":CHARGETYPE", (object)o.ChargeType), |
|---|
| | | new OracleParameter(":THRESHOLD", (object)o.Threshold), |
|---|
| | | new OracleParameter(":MAXCONNCOUNT", (object)o.MaxConnCount), |
|---|
| | | new OracleParameter(":REMARK", (object)o.Remark), |
|---|
| | | new OracleParameter(":TIME_PERMITTING", (object)o.TimePermitting), |
|---|
| | | new OracleParameter(":AUDITINGMODE", (object)o.AuditingMode), |
|---|
| | | new OracleParameter(":DEDUCTPERCENT", (object)o.DeductPercent), |
|---|
| | | new OracleParameter(":SPID", (object)o.SpID), |
|---|
| | | new OracleParameter(":CM_OP_ID", (object)o.CMOPID), |
|---|
| | | new OracleParameter(":CT_OP_ID", (object)o.CTOPID), |
|---|
| | | new OracleParameter(":UN_OP_ID", (object)o.UNOPID), |
|---|
| | | new OracleParameter(":DEFISHING_TIMEOUT", (object)o.DefishingTimeout), |
|---|
| | | new OracleParameter(":DEFISHING_THRESHOLD", (object)o.DefishingThreshold), |
|---|
| | | new OracleParameter(":REJECT_IF_FORBIDDEN", (object)o.RejectIfForbidden), |
|---|
| | | new OracleParameter(":REFUND_IF_UNDELIVERED", (object)o.RefundIfUndelivered), |
|---|
| | | new OracleParameter(":STATUS", (object)o.Status), |
|---|
| | | new OracleParameter(":ACCESSCODE_MODE", (object)o.AccessCodeMode), |
|---|
| | | new OracleParameter(":EXTNOEXTENSION_MODE", (object)o.ExtnoExtensionMode), |
|---|
| | | new OracleParameter(":DEFISHING_OP_ID", (object)o.DefishingOPID), |
|---|
| | | new OracleParameter(":ROUTER_TYPE", (object)o.RouterType), |
|---|
| | | new OracleParameter(":CM_EXT_PARAMS", (object)o.CMextparms), |
|---|
| | | new OracleParameter(":CT_EXT_PARAMS", (object)o.CTextparams), |
|---|
| | | new OracleParameter(":CU_EXT_PARAMS", (object)o.CUextparams), |
|---|
| | | new OracleParameter(":FEE_SHORT_LENGTH", (object)o.FeeShortLength), |
|---|
| | | new OracleParameter(":FEE_LONG_LENGTH", (object)o.FeeLongLength), |
|---|
| | | new OracleParameter(":BLACK_MODE", (object)o.BlackMode), |
|---|
| | | new OracleParameter(":DIVERTER_ID", (object)o.DiverterID), |
|---|
| | | new OracleParameter(":MCPM", (object)o.MCPM), |
|---|
| | | new OracleParameter(":MC_EXPRESSION", (object)o.McExpression), |
|---|
| | | new OracleParameter(":CM_GROUP_ID", (object)o.CMGroupID), |
|---|
| | | new OracleParameter(":CU_GROUP_ID", (object)o.CUGroupID), |
|---|
| | | new OracleParameter(":CT_GROUP_ID", (object)o.CTGroupID), |
|---|
| | | new OracleParameter(":BALANCE_THRESHOLD", (object)o.BalanceThreshold), |
|---|
| | | new OracleParameter(":ALARM_MOBILE", (object)o.AlarmMobile), |
|---|
| | | new OracleParameter(":FORCE_SIGN_FLAG", (object)o.ForceSignFlag), |
|---|
| | | new OracleParameter(":FORCE_SIGN", (object)o.ForceSign), |
|---|
| | | new OracleParameter(":SIGNATURE_MODE", (object)o.SignatureMode), |
|---|
| | | new OracleParameter(":SIGNATURES", (object)o.Signatures), |
|---|
| | | new OracleParameter(":VerCodeMode", (object)o.VerCodeMode), |
|---|
| | | new OracleParameter(":ProvincialNetworkMode",(object)o.ProvincialNetworkMode), |
|---|
| | | new OracleParameter(":RESEND_STATUS", (object)o.RESEND_STATUS), |
|---|
| | | new OracleParameter(":RESEND_CM_GROUPID", (object)o.RESEND_CM_GROUPID), |
|---|
| | | new OracleParameter(":RESEND_CU_GROUPID", (object)o.RESEND_CU_GROUPID), |
|---|
| | | new OracleParameter(":RESEND_CT_GROUPID",(object)o.RESEND_CT_GROUPID), |
|---|
| | | new OracleParameter(":TRANSFERFLAG",(object)o.TransferFlag) |
|---|
| | | ) > 0; |
|---|
| | | **/ |
|---|
| | | |
|---|
| | | return OracleHelper.ExecuteSql("UPDATE GW_SP SET AP_ID=:APID,COMBINATION_MODE=:COMBINATION_MODE,CLIENT_ID=:CLIENTID," + |
|---|
| | | "STRATEGY_ID=:STRATEGYID,PASSWORD=:PASSWORD,\r\nCLIENT_IP=:CLIENTIP,CLIENT_PORT=:CLIENTPORT," + |
|---|
| | | "ACCESS_CODE=:ACCESSCODE,\r\nPRIORITY=:PRIORITY,PRICE=:PRICE,CHARGE_TYPE=:CHARGETYPE," + |
|---|
