wzp
2022-11-23 c052583025ff87735d2120dc63aeee7ea5e5524e
web/Dao/GwSpDao.cs
@@ -249,7 +249,7 @@
            return list1;
        }
        public List<GwSp> LoadInfoList(string spId, string apId, string clientId, string clientName, int routerType, string opID, int chargeType, int pageIndex, int pageSize
        public List<GwSp> LoadInfoList(string spId, string apId, string clientId, string company, int routerType, string opId, int chargeType, int pageIndex, int pageSize
            , string resendStatus, string productId, string permissionsSQL, out int recordCount)
        {
            List<GwSp> list1 = new List<GwSp>();
@@ -288,9 +288,9 @@
                list2.Add(new OracleParameter(":ClientID", (object)('%' + clientId + '%')));
                stringBuilder.Append(" and CLIENT_ID like :ClientID");
            }
            if (clientName != null && clientName != "")
            if (company != null && company != "")
            {
                stringBuilder.Append(" and CLIENT_ID IN (SELECT CLIENT_ID FROM GW_CLIENT WHERE CLIENT_NAME like '%" + clientName + "%' )");
                stringBuilder.Append(" and CLIENT_ID IN (SELECT CLIENT_ID FROM GW_CLIENT WHERE COMPANY like '%" + company + "%' )");
            }
            /**
            if (chargeType > 0)
@@ -309,20 +309,20 @@
                {
                    list2.Add(new OracleParameter(":ROUTER_TYPE", (object)routerType));
                    stringBuilder.Append(" and ROUTER_TYPE=:ROUTER_TYPE");
                    if (!string.IsNullOrEmpty(opID))
                    if (!string.IsNullOrEmpty(opId))
                    {
                        stringBuilder.Append(" and (CM_OP_ID=:OPID) OR (CT_OP_ID=:OPID) OR (UN_OP_ID=:OPID) ");
                        list2.Add(new OracleParameter(":OPID", (object)opID));
                        list2.Add(new OracleParameter(":OPID", (object)opId));
                    }
                }
                if (routerType == 3)
                {
                    list2.Add(new OracleParameter(":ROUTER_TYPE", (object)routerType));
                    stringBuilder.Append(" and ROUTER_TYPE=:ROUTER_TYPE");
                    if (!string.IsNullOrEmpty(opID))
                    if (!string.IsNullOrEmpty(opId))
                    {
                        stringBuilder.Append(" and (CM_GROUP_ID=:OPID) OR (CU_GROUP_ID=:OPID) OR (CT_GROUP_ID=:OPID) ");
                        list2.Add(new OracleParameter(":OPID", (object)opID));
                        list2.Add(new OracleParameter(":OPID", (object)opId));
                    }
                }
            }
@@ -355,107 +355,6 @@
        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," +
@@ -475,7 +374,7 @@
                "ProvincialNetworkMode=:ProvincialNetworkMode \r\n,RESEND_STATUS=:RESEND_STATUS \r\n," +
                "RESEND_CM_GROUPID=:RESEND_CM_GROUPID \r\n,RESEND_CU_GROUPID=:RESEND_CU_GROUPID\r\n," +
                "RESEND_CT_GROUPID=:RESEND_CT_GROUPID,TRANSFERFLAG=:TRANSFERFLAG," +
                "IS_DISPALY_PRICE=:IS_DISPALY_PRICE WHERE SP_ID=:SPID", OracleHelper.Connection,
                "IS_DISPALY_PRICE=:IS_DISPALY_PRICE,PRODUCT_ID=:PRODUCT_ID WHERE SP_ID=:SPID", OracleHelper.Connection,
                new OracleParameter(":APID", (object)o.ApID),
                new OracleParameter(":COMBINATION_MODE", (object)o.CombinationMode),
                new OracleParameter(":CLIENTID", (object)o.ClientID),
@@ -532,7 +431,8 @@
                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),
                new OracleParameter(":IS_DISPALY_PRICE", (object)o.IsDispalyPrice)) > 0;
                new OracleParameter(":IS_DISPALY_PRICE", (object)o.IsDispalyPrice),
                new OracleParameter(":PRODUCT_ID", (object)o.ProductId)) > 0;
        }
        //更新账号充值数据