_mapperType=defv

   //#region 默认值,便于条件判断
            if (!dictionaryUrl.ContainsKey(SystemParamConst.API_MAPPER_TYPE))
            {
                dictionaryUrl[SystemParamConst.API_MAPPER_TYPE] = "defv";
            }
            //#endregion 默认值,便于条件判断

RG3.PF.Abstractions.Consts

/************************************************************************************************************
* file    :     SystemParamConst.cs
* author  : cbg
* function: 系统 公共的参数信息
* history : created by CBG
************************************************************************************************************/

namespace RG3.PF.Abstractions.Consts
{
    /// <summary>
    /// 系统 公共的参数信息
    /// </summary>
    public partial class SystemParamConst
    {

        /// <summary>
        /// 存储token KEY accessToken
        /// </summary>
        public const string TOKEN_KEY = "Authorization";

        #region  系统参数
        /// <summary>
        /// 星期几
        /// </summary>
        public const string CURRENT_DAY_WEEK = "_currentDayWeek";



        /// <summary>
        /// 当日 开始时间
        /// </summary>
        public const string CURRENT_DAY_S = "_currentDayS";
        /// <summary>
        /// 
        /// </summary>
        public const string CURRENT_DAY_E = "_currentDayE";
        /// <summary>
        /// 近7日、近1周 开始时间
        /// </summary>
        public const string CURRENT_DAY7_S = "_currentDay7S";
        /// <summary>
        /// 近7日、近1周 接收时间
        /// </summary>
        public const string CURRENT_DAY7_E = "_currentDay7E";

        /// <summary>
        /// 当周 开始时间
        /// </summary>
        public const string CURRENT_WEEK_S = "_currentWeekS";
        /// <summary>
        /// 当周 结束时间
        /// </summary>
        public const string CURRENT_WEEK_E = "_currentWeekE";

        /// <summary>
        /// 当月 开始时间
        /// </summary>
        public const string CURRENT_MONTH_S = "_currentMonthS";
        /// <summary>
        /// 当月 结束时间
        /// </summary>
        public const string CURRENT_MONTH_E = "_currentMonthE";
        /// <summary>
        /// 当年 开始时间
        /// </summary>
        public const string CURRENT_YEAR_S = "_currentYearS";
        /// <summary>
        /// 当年 结束时间
        /// </summary>
        public const string CURRENT_YEAR_E = "_currentYearE";
        /// <summary>
        ///当前 小时 开始时间
        /// </summary>
        public const string CURRENT_HOUR_S = "_currentHourS";
        /// <summary>
        /// 当前 小时 结束时间
        /// </summary>
        public const string CURRENT_HOUR_E = "_currentHourE";
        /// <summary>
        /// 最近5分钟 开始时间
        /// </summary>
        public const string CURRENT_MINUTE5_S = "_currentMinute5S";
        /// <summary>
        /// 最近5分钟 结束时间
        /// </summary>
        public const string CURRENT_MINUTE5_E = "_currentMinute5E";
        /// <summary>
        /// 最近10分钟 开始时间
        /// </summary>
        public const string CURRENT_MINUTE10_S = "_currentMinute10S";
        /// <summary>
        /// 最近10分钟 结束时间
        /// </summary>
        public const string CURRENT_MINUTE10_E = "_currentMinute10E";
        /// <summary>
        /// 最近15分钟 开始时间
        /// </summary>
        public const string CURRENT_MINUTE15_S = "_currentMinute15S";
        /// <summary>
        /// 最近15分钟 结束时间
        /// </summary>
        public const string CURRENT_MINUTE15_E = "_currentMinute15E";
        /// <summary>
        /// 最近30分钟 开始时间
        /// </summary>
        public const string CURRENT_MINUTE30_S = "_currentMinute30S";
        /// <summary> 结束时间
        /// 最近30分钟
        /// </summary>
        public const string CURRENT_MINUTE30_E = "_currentMinute30E";
        /// <summary>
        /// 最近45分钟 开始时间
        /// </summary>
        public const string CURRENT_MINUTE45_S = "_currentMinute45S";
        /// <summary>
        /// 最近45分钟 结束时间
        /// </summary>
        public const string CURRENT_MINUTE45_E = "_currentMinute45E";
        /// <summary>
        /// 最近60分钟 开始时间
        /// </summary>
        public const string CURRENT_MINUTE60_S = "_currentMinute60S";
        /// <summary>
        /// 最近60分钟 结束时间
        /// </summary>
        public const string CURRENT_MINUTE60_E = "_currentMinute60E";


        /// <summary>
        /// 上周 开始时间
        /// </summary>
        public const string CURRENT_PREV_WEEK_S = "_currentPrevWeekS";
        /// <summary>
        /// 上周 结束时间
        /// </summary>
        public const string CURRENT_PREV_WEEK_E = "_currentPrevWeekE";
        /// <summary>
        /// 上个月 开始时间
        /// </summary>
        public const string CURRENT_PREV_MONTH_S = "_currentPrevMonthS";
        /// <summary>
        /// 上个月 结束时间
        /// summary
        /// </summary>
        public const string CURRENT_PREV_MONTH_E = "_currentPrevMonthE";
        /// <summary>
        /// 去年 开始时间
        /// </summary>
        public const string CURRENT_PREV_YEAR_S = "_currentPrevYearS";
        /// <summary>
        /// 去年 结束时间
        /// </summary>
        public const string CURRENT_PREV_YEAR_E = "_currentPrevYearE";
        /// <summary>
        /// 昨日 开始时间
        /// </summary>
        public const string CURRENT_PREV_DAY_S = "_currentPrevDayS";
        /// <summary>
        /// 昨日 结束时间
        /// </summary>
        public const string CURRENT_PREV_DAY_E = "_currentPrevDayE";

        /// <summary>
        /// 图表时间轴信息 ["1","2"]
        /// </summary>
        public const string CURRENT_CHART_RANGE = "_currentChartRange";

        /// <summary>
        /// 下周 开始时间
        /// </summary>
        public const string CURRENT_NEXT_WEEK_S = "_currentNextWeekS";
        /// <summary>
        /// 下周 结束时间
        /// </summary>
        public const string CURRENT_NEXT_WEEK_E = "_currentNextWeekE";
        /// <summary>
        /// 下个月 开始时间
        /// </summary>
        public const string CURRENT_NEXT_MONTH_S = "_currentNextMonthS";
        /// <summary>
        /// 下个月 结束时间
        /// summary
        /// </summary>
        public const string CURRENT_NEXT_MONTH_E = "_currentNextMonthE";
        /// <summary>
        /// 下年 开始时间
        /// </summary>
        public const string CURRENT_NEXT_YEAR_S = "_currentNextYearS";
        /// <summary>
        /// 下年 结束时间
        /// </summary>
        public const string CURRENT_NEXT_YEAR_E = "_currentNextYearE";
        /// <summary>
        /// 下日 开始时间
        /// </summary>
        public const string CURRENT_NEXT_DAY_S = "_currentNextDayS";
        /// <summary>
        /// 下日 结束时间
        /// </summary>
        public const string CURRENT_NEXT_DAY_E = "_currentNextDayE";

        #endregion


        #region 未来参数
        /// <summary>
        /// 当前月份
        /// </summary>
        public const string CURRENT_MONTH = "_currentMonth";
        /// <summary>
        /// 当前年
        /// </summary>
        public const string CURRENT_YEAR = "_currentYear";

        /// <summary>
        /// 未来近1周 
        /// </summary>
        public const string FUTURE_WEEK01_S = "_futureWeek01S";
        /// <summary>
        /// 未来近1周
        /// </summary>
        public const string FUTURE_WEEK01_E = "_futureWeek01E";

        /// <summary>
        /// 未来近1个月份 
        /// </summary>
        public const string FUTURE_MONTH01_S = "_futureMonth01S";
        /// <summary>
        /// 未来近1个月份
        /// </summary>
        public const string FUTURE_MONTH01_E = "_futureMonth01E";
        /// <summary>
        /// 未来近3个月份 
        /// </summary>
        public const string FUTURE_MONTH03_S = "_futureMonth03S";
        /// <summary>
        /// 未来近3个月份
        /// </summary>
        public const string FUTURE_MONTH03_E = "_futureMonth03E";
        /// <summary>
        /// 未来近6个月份 
        /// </summary>
        public const string FUTURE_MONTH06_S = "_futureMonth06S";
        /// <summary>
        /// 未来近6个月份
        /// </summary>
        public const string FUTURE_MONTH06_E = "_futureMonth06E";

        /// <summary>
        /// 未来近12个月份 
        /// </summary>
        public const string FUTURE_MONTH12_S = "_futureMonth12S";
        /// <summary>
        /// 未来近12个月份
        /// </summary>
        public const string FUTURE_MONTH012_E = "_futureMonth12E";
        #endregion

        #region  当前公共参数  存储到缓存

        /// <summary>
        ///当前时间   常用  开始时间结尾   00:00:00
        /// </summary>
        public const string FILTER_DATE_S = "_filterDateS";

        /// <summary>
        ///当前时间   常用  开始时间结尾   23:59:59
        /// </summary>
        public const string FILTER_DATE_E = "_filterDateE";

        /// <summary>
        ///当前时间   常用
        /// </summary>
        public const string CURRENT_DATE = "_currentDate";

        /// <summary>
        /// 当前年月份
        /// </summary>
        public const string CURRENT_YEAR_MONTH = "_currentYearMonth";

        /// <summary>
        /// 当前年月份  yyyy-MM-01
        /// </summary>
        public const string CURRENT_YEAR_MONTH_01 = "_currentYearMonth01";

        /// <summary>
        /// 当前用户 id  常用
        /// </summary>
        public const string CURRENT_USER_ID = "_userId";

        /// <summary>
        /// 当前用户显示的名称 id  常用
        /// </summary>
        public const string CURRENT_USER_PUSH_NAME = "_userPushName";

        /// <summary>
        /// 平台默认密码 md加密的结果
        /// </summary>
        public const string CURRENT_DEF_PWSD = "_defaultPwsd";

        /// <summary>
        /// 当前用户手机号  常用
        /// </summary>
        public const string CURRENT_TELEPHONE = "_telephone";

        /// <summary>
        /// 当前 登录账号名
        /// </summary>
        public const string CURRENT_USER_NAME = "_userName";



        /// <summary>
        /// 
        /// </summary>
        public const string DEFAULT_ROLE_ID = "_defaultRoleId";
        /// <summary>
        /// 
        /// </summary>
        public const string DEFALUE_AREA_CODE = "_defaultAreaCode";
        /// <summary>
        /// 
        /// </summary>
        public const string DEFAULT_DEP_ID = "_defaultDepId";
        /// <summary>
        /// 
        /// </summary>
        public const string DEFAULT_JOB_ID = "_defaultJobId";
        /// <summary>
        /// 
        /// </summary>
        public const string DEFAULT_SYS_ID = "_defaultSysId";




        /// <summary>
        /// 开发者
        /// </summary>
        public const string CURRENT_USER_DEVELOPER = "_developer";

        /// <summary>
        ///当前系统ID
        /// </summary>
        public const string CURRENT_SYS_ID = "_sysId";

        /// <summary>
        ///nodejs转换
        ///\Config\AppNodeJs\Plugins  common-data
        /// </summary>
        public const string CURRENT_NODE_JS = "_nodejs";

        /// <summary>
        ///当前所属部门 depId  数组  
        /// </summary>
        public const string CURRENT_DEP_ID = "_depId";



        /// <summary>
        ///当前用户拥有的其它用户id
        /// </summary>
        public const string CURRENT_MERGE_USER_ID = "_mergeUserId";

        /// <summary>
        ///当前三方 机构 ID
        /// </summary>
        public const string CURRENT_OPEN_ORG_ID = "_openOrgId";

        /// <summary>
        ///当前三方 角色 ID
        /// </summary>
        public const string CURRENT_OPEN_ROLE_ID = "_openrRoleId";

        /// <summary>
        ///当前三方ID
        /// </summary>
        public const string CURRENT_OPEN_ID = "_openId";


        /// <summary>
        ///当前职位 depId  数组
        /// </summary>
        public const string CURRENT_JOB_ID = "_jobId";

        /// <summary>
        ///当前用户拥有查看的行政区划  数组
        /// </summary>
        public const string CURRENT_AREA_CODE = "_areaCode";



        /// <summary>
        ///当前过滤的行政区
        /// </summary>
        public const string CURRENT_FILTER_AREA_CODE = "_filterAreaCode";


        /// <summary>
        ///开启 当前用户过滤
        /// </summary>
        public const string FILTER_OPEN_USER = "_filterOpenUser";

        /// <summary>
        /// 特殊权限的用户ID
        /// </summary>
        public const string FILTER_USER_ID = "_filterUser";


        /// <summary>
        ///当前角色 roleId  存储数组
        /// </summary>
        public const string CURRENT_ROLE_ID = "_roleId";


        /// <summary>
        ///当前系统 参数全部信息   _sysParam
        ///RG3.PF  缓存里面需要设置
        /// </summary>
        public const string CURRENT_SYS_PARAM = "_sysParam";

        #endregion

        #region 头部参数
        /// <summary>
        ///  API有效性验证  值存储在 header里面  _verifyApi
        /// </summary>
        public const string VERIFY_API = "_verifyApi";

        /// <summary>
        ///  短信验证  验证码等 存储表示key的名称
        /// </summary>
        public const string VERIFY_GUID = "verifyGuid";
        /// <summary>
        ///  短信验证  验证码等 存储表示值的名称
        /// </summary>
        public const string VERIFY_CODE = "verifyCode";

        /// <summary>
        ///  //当前经度  GC102  _userLng
        /// </summary>
        public const string USER_LNG = "_userLng";

        /// <summary>
        ///  当前纬度  GC102  _userLat
        /// </summary>
        public const string USER_LAT = "_userLat";

        /// <summary>
        ///  当前 行政编码
        /// </summary>
        public const string USER_AREA_CODE = "_userAreaCode";

        /// <summary>
        ///  来源应用 
        /// </summary>
        public const string FROM_APP_ID = "_fromAppId";

        /// <summary>
        ///  项目
        /// </summary>
        public const string OWNER_ID = "_ownerId";

        /// <summary>
        ///  项目 URL 传递
        /// </summary>
        public const string PARAM_OWNER_ID = "ownerId";

        /// <summary>
        ///  头前缀
        /// </summary>
        public const string HEADER_BEFORE_SUFFIX = "X";

        /// <summary>
        /// 来至用户分享的id
        /// </summary>
        public const string USER_FROM_FIRST_SHARE_ID = "_userFromFirstShareId";
        /// <summary>
        /// 来至用户分享的二级ID
        /// </summary>
        public const string USER_FROM_SECOND_SHARE_ID = "_userFromSecondShareId";

        /// <summary>
        /// 特定api验证
        /// </summary>
        public const string API_VERIFY_SOURCE = "_verifySource";

        #endregion

        /// <summary>
        /// mapper文件和参数映射,根据值二次处理请求结果
        /// </summary>
        public const string API_MAPPER_TYPE = "_mapperType";

        /// <summary>
        ///二级排序  _order=sort_id:asc|id:desc
        /// </summary>
        public const string API_ORDER = "_order";

        /// <summary>
        ///二级排序  _sortchild =[commoditys]sort_id:asc|id:desc[commoditys] sort_id:asc|id:desc
        /// </summary>
        public const string API_SORT_CHILD = "_sortchild";
    }
}

参数值


{
    "pageIndex":1,
    "pageSize":15,
    "_menuId":"4130373032461996032",
    "_nodejs":"common-data",
    "_sysId":[
        ""
    ],
    "_verifyApi":[
        "bkUD/78+V/vRXf8UQ6/H0OGQBTKKdfWeJ4AqFWyVD78OpGVNMCECh3UiS/prp6q+fWJaCIt6ZIY="
    ],
    "Authorization":[
        "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJSRzMiLCJhdWQiOiJhcGkiLCJpZCI6InB0ZGV2IiwibmFtZSI6ImRldiIsImNsaWVudF9pZCI6InB0ZGV2IiwiZXhwaXJlcyI6IjIwMjMtMDEtMDQgMTM6MDg6NDIiLCJvcGVuX2lkIjoiIiwid2JfaWQiOiIiLCJ3eF9vcGVuX2lkIjoiIiwid3hfdW5pb25faWQiOiIiLCJ0ZWxlcGhvbmUiOiIiLCJwdXNoX25hbWUiOiLlvIDlj5HnrqHnkIblkZgiLCJoZWFkX2ljb24iOiIiLCJkZXBfaWQiOiIiLCJzeXNfaWQiOiIiLCJtZXJnZV91c2VyX2lkIjoiYnQtZGV2ZS1idC0yMDIwMC1kYjM2YzMxMC0yYmE3LTRhODAsYnQtdC1wcm9kLWJ0LTIwMjAwLTJjYWQ5MGI2LTRkMDAtNDgyLHJnLWctZGV2ZS1yZy0yMDIwMC0xZmRhNzk5Ny00YmZiLTQ0MSxyZy1nLWRldmUtcmctMjAyMDAtMzYyZjliMWItNWIyNi00MjgiLCJhcmVhX2NvZGUiOiIiLCJyb2xlX2lkIjoiZGV2ZWxvcG1lbnQiLCJkZXZlbG9wZXIiOiIxIiwibmJmIjoxNjcyODA4ODAyLCJleHAiOjE2NzI4MDg5MjIsImlhdCI6MTY3MjgwODgwMn0.2VcnN6_ssXAoXDSe2omeeUG3sosLD-MJbBywihCNGLg"
    ],
    "_ownerId":[
        "bt"
    ],
    "_userFromFirstShareId":[
        "null"
    ],
    "_userFromSecondShareId":[
        "null"
    ],
    "ownerId":[
        "bt"
    ],
    "_clientUserIp":"127.0.0.1",
    "_routePath":"/bo/api/v3/bs-booking-info/page/res/manager",
    "rmt":"page",
    "_rmt":"page",
    "_mkey":"bs-booking-info",
    "_resField":"manager",
    "_userId":"ptdev",
    "_userName":"dev",
    "_roleId":[
        "development"
    ],
    "_depId":[
        ""
    ],
    "_jobId":[
        "member"
    ],
    "_areaCode":[
        ""
    ],
    "_mergeUserId":[
        "bt-deve-bt-20200-db36c310-2ba7-4a80",
        "bt-t-prod-bt-20200-2cad90b6-4d00-482",
        "rg-g-deve-rg-20200-1fda7997-4bfb-441",
        "rg-g-deve-rg-20200-362f9b1b-5b26-428"
    ],
    "_openOrgId":"-1",
    "_openrRoleId":"-1",
    "_developer":1,
    "_filterUser":[
        "ptdev"
    ],
    "_filterAreaCode":"0",
    "_currentDate":"2023-01-04T13:06:51",
    "_currentYearMonth":"2023-01",
    "_currentYearMonth01":"2023-01-01T00:00:00",
    "_currentDayS":"2023-01-04T00:00:00",
    "_currentDayE":"2023-01-04T23:59:59",
    "_currentDay7S":"2022-12-28T00:00:00",
    "_currentDay7E":"2023-01-04T23:59:59",
    "_currentDayWeek":3,
    "_currentWeekS":"2023-01-02T00:00:00",
    "_currentWeekE":"2023-01-08T23:59:59",
    "_currentMonthS":"2023-01-01T00:00:00",
    "_currentMonthE":"2023-01-31T23:59:59",
    "_currentYearS":"2023-01-01T00:00:00",
    "_currentYearE":"2023-12-31T23:59:59",
    "_currentHourS":"2023-01-04T13:00:00",
    "_currentHourE":"2023-01-04T13:59:59",
    "_currentMinute5S":"2023-01-04T13:01:00",
    "_currentMinute5E":"2023-01-04T13:06:59",
    "_currentMinute10S":"2023-01-04T12:47:00",
    "_currentMinute10E":"2023-01-04T13:06:59",
    "_currentMinute15S":"2023-01-04T12:51:00",
    "_currentMinute15E":"2023-01-04T13:06:59",
    "_currentMinute30S":"2023-01-04T12:36:00",
    "_currentMinute30E":"2023-01-04T13:06:59",
    "_currentMinute45S":"2023-01-04T12:21:00",
    "_currentMinute45E":"2023-01-04T13:06:59",
    "_currentMinute60S":"2023-01-04T12:06:00",
    "_currentMinute60E":"2023-01-04T13:06:59",
    "_currentPrevDayS":"2023-01-03T00:00:00",
    "_currentPrevDayE":"2023-01-03T23:59:59",
    "_currentPrevWeekS":"2022-12-26T00:00:00",
    "_currentPrevWeekE":"2023-01-01T23:59:59",
    "_currentPrevMonthS":"2022-12-01T00:00:00",
    "_currentPrevMonthE":"2022-12-31T23:59:59",
    "_currentPrevYearS":"2022-01-01T00:00:00",
    "_currentPrevYearE":"2022-12-31T23:59:59",
    "_currentNextDayS":"2023-01-05T00:00:00",
    "_currentNextDayE":"2023-01-05T23:59:59",
    "_currentNextWeekS":"2023-01-09T00:00:00",
    "_currentNextWeekE":"2023-01-15T23:59:59",
    "_currentNextMonthS":"2023-02-01T00:00:00",
    "_currentNextMonthE":"2023-02-28T23:59:59",
    "_currentNextYearS":"2024-01-01T00:00:00",
    "_currentNextYearE":"2024-12-31T23:59:59",
    "_currentMonth":1,
    "_currentYear":2023,
    "_futureWeek01S":"2023-01-04T00:00:00",
    "_futureWeek01E":"2023-01-10T23:59:59",
    "_futureMonth01S":"2023-01-04T00:00:00",
    "_futureMonth01E":"2023-02-03T23:59:59",
    "_futureMonth03S":"2023-04-03T23:59:59",
    "_futureMonth06S":"2023-01-04T00:00:00",
    "_futureMonth06E":"2023-07-03T23:59:59",
    "_futureMonth12S":"2023-01-04T00:00:00",
    "_futureMonth12E":"2024-01-03T23:59:59",
    "_filterDateS":"00:00:00",
    "_filterDateE":"23:59:59",
    "_filterDateEn":" 23:59:59",
    "_currentChartValues":[

    ],
    "_defaultAreaCode":"350000",
    "_defaultDepId":"member",
    "_defaultJobId":"member",
    "_defaultOpenUserRoleId":"dbadmim,development",
    "_defaultRoleId":"member",
    "_defaultSysId":"1b5d7033-6c15-485e-7ea517509d1b-be1b",
    "_defaultUserId":"member",
    "_userPushName":"开发管理员",
    "_whereValueCpcFxyRoleId":[
        ""
    ],
    "_whereValueCpcFxyUserType":[
        ""
    ],
    "_whereValueCpcPdyRoleId":[
        ""
    ],
    "_whereValueCpcPdyUserType":[
        ""
    ],
    "_whereValueCpcSbyRoleId":[
        ""
    ],
    "_whereValueCpcSbyUserType":[
        ""
    ],
    "_whereSqlCpcFxyRoleId":"",
    "_whereSqlCpcFxyUserType":"",
    "_whereSqlCpcPdyRoleId":"",
    "_whereSqlCpcPdyUserType":"",
    "_whereSqlCpcSbyRoleId":"",
    "_whereSqlCpcSbyUserType":"",
    "_whereSqlFamilyMy":"(select family_id from bt_family where audit_status=1 and (create_user_id=@_userid or create_user_id in @_mergeUserId))",
    "_whereSqlFamilyShare":"(select family_id from bt_family_share where target_user_id=@_userid and audit_status=1)",
    "_whereSqlPolicyItemShare":"(select policy_id from bt_policy where family_id in (select family_id from bt_family_share where target_user_id=@_userid and audit_status=1))",
    "_whereSqlDateId":"{s-if:_filterDateId}{op-eq:0} and {{_filterDateCol}} between @_currentMonthS and @_currentMonthE {op-eq:0}{e-if:_filterDateId}{s-if:_filterDateId}{op-eq:1} and {{_filterDateCol}} between @_currentPrevMonthS and @_currentPrevMonthE {op-eq:1}{e-if:_filterDateId}{s-if:_filterDateId}{op-eq:2} and {{_filterDateCol}} between @_currentWeekS and @_currentWeekE {op-eq:2}{e-if:_filterDateId}{s-if:_filterDateId}{op-eq:3} and {{_filterDateCol}} between @_currentPrevWeekS and @_currentPrevWeekE {op-eq:3}{e-if:_filterDateId}{s-if:_filterDateId}{op-eq:4} and {{_filterDateCol}} between @_currentYearS and @_currentYearE {op-eq:4}{e-if:_filterDateId}{s-if:_filterDateId}{op-eq:5} and {{_filterDateCol}} between @_currentPrevYearS and @_currentPrevYearE {op-eq:5}{e-if:_filterDateId}{s-if:_filterDateId}{op-eq:6} and {{_filterDateCol}} between @_currentDayS  and @_currentDayS {op-eq:6}{e-if:_filterDateId}{s-if:_filterDateId}{op-eq:7} and {{_filterDateCol}} between @_currentPrevDayS and @_currentPrevDayE {op-eq:7}{e-if:_filterDateId}",
    "_fromOpenAuth":null,
    "_dataFromType":"database",
    "_cache":"B84E9DD14F2F86F30FDC0C722E9DBD38",
    "_currentSeasonS":"2023-01-01T00:00:00",
    "_currentSeasonE":"2023-03-31T23:59:59",
    "_filterRole":[
        "ptrole",
        "ptadmin"
    ],
    "_filterEnum":[

    ],
    "_filterAction":[

    ],
    "_filterMenu":[

    ],
    "_filterDepartment":[

    ],
    "_filterArea":[

    ],
    "_filterSystem":[

    ],
    "_filterProject":[

    ],
    "_primaryIdV":"4131057293087346688",
    "limtStartIndex":0,
    "bookingId":null,
    "bookingName":null,
    "createTimeB":null,
    "createTimeE":null,
    "_fromPrimaryIds":[
        "4130400836184444929",
        "4130393339449053184"
    ],
    "_filterDimAreaCode":[
        "110000"
    ],
    "transmissionSecurityVI":"0",
    "transmissionSecurityMethod":"des",
    "transmissionSecurityKey":""
}

参数值


KeyValuePair`2,KeyValuePair`2.key,KeyValuePair`2.value,KeyValuePair`2.Key,KeyValuePair`2.Value
"[_userId, ptdev]",_userId,ptdev,_userId,ptdev
"[_userName, dev]",_userName,dev,_userName,dev
"[_telephone, ]",_telephone,"",_telephone,""
"[_roleId, System.Collections.Generic.List`1[System.String]]",_roleId,System.Collections.Generic.List`1[System.String],_roleId,System.Collections.Generic.List`1[System.String]
"[_depId, System.Collections.Generic.List`1[System.String]]",_depId,System.Collections.Generic.List`1[System.String],_depId,System.Collections.Generic.List`1[System.String]
"[_jobId, System.Collections.Generic.List`1[System.String]]",_jobId,System.Collections.Generic.List`1[System.String],_jobId,System.Collections.Generic.List`1[System.String]
"[_areaCode, System.Collections.Generic.List`1[System.String]]",_areaCode,System.Collections.Generic.List`1[System.String],_areaCode,System.Collections.Generic.List`1[System.String]
"[_mergeUserId, System.Collections.Generic.List`1[System.String]]",_mergeUserId,System.Collections.Generic.List`1[System.String],_mergeUserId,System.Collections.Generic.List`1[System.String]
"[_openId, ]",_openId,"",_openId,""
"[_openOrgId, -1]",_openOrgId,-1,_openOrgId,-1
"[_openrRoleId, -1]",_openrRoleId,-1,_openrRoleId,-1
"[_fromAppId, ]",_fromAppId,"",_fromAppId,""
"[_userFromFirstShareId, ]",_userFromFirstShareId,"",_userFromFirstShareId,""
"[_userFromSecondShareId, ]",_userFromSecondShareId,"",_userFromSecondShareId,""
"[_developer, 1]",_developer,1,_developer,1
"[_filterUser, System.Collections.Generic.List`1[System.String]]",_filterUser,System.Collections.Generic.List`1[System.String],_filterUser,System.Collections.Generic.List`1[System.String]
"[_filterAreaCode, 0]",_filterAreaCode,0,_filterAreaCode,0
"[_currentDate, 2022-10-01 19:31:53]",_currentDate,"2022-10-01 19:31:53",_currentDate,"2022-10-01 19:31:53"
"[_currentYearMonth, 2022-10]",_currentYearMonth,2022-10,_currentYearMonth,2022-10
"[_currentYearMonth01, 2022-10-01 00:00:00]",_currentYearMonth01,"2022-10-01 00:00:00",_currentYearMonth01,"2022-10-01 00:00:00"
"[_currentDayS, 2022-10-01 00:00:00]",_currentDayS,"2022-10-01 00:00:00",_currentDayS,"2022-10-01 00:00:00"
"[_currentDayE, 2022-10-01 23:59:59]",_currentDayE,"2022-10-01 23:59:59",_currentDayE,"2022-10-01 23:59:59"
"[_currentDay7S, 2022-09-24 00:00:00]",_currentDay7S,"2022-09-24 00:00:00",_currentDay7S,"2022-09-24 00:00:00"
"[_currentDay7E, 2022-10-01 23:59:59]",_currentDay7E,"2022-10-01 23:59:59",_currentDay7E,"2022-10-01 23:59:59"
"[_currentDayWeek, 6]",_currentDayWeek,6,_currentDayWeek,6
"[_currentWeekS, 2022-09-26 00:00:00]",_currentWeekS,"2022-09-26 00:00:00",_currentWeekS,"2022-09-26 00:00:00"
"[_currentWeekE, 2022-10-02 23:59:59]",_currentWeekE,"2022-10-02 23:59:59",_currentWeekE,"2022-10-02 23:59:59"
"[_currentMonthS, 2022-10-01 00:00:00]",_currentMonthS,"2022-10-01 00:00:00",_currentMonthS,"2022-10-01 00:00:00"
"[_currentMonthE, 2022-10-31 23:59:59]",_currentMonthE,"2022-10-31 23:59:59",_currentMonthE,"2022-10-31 23:59:59"
"[_currentYearS, 2022-01-01 00:00:00]",_currentYearS,"2022-01-01 00:00:00",_currentYearS,"2022-01-01 00:00:00"
"[_currentYearE, 2022-12-31 23:59:59]",_currentYearE,"2022-12-31 23:59:59",_currentYearE,"2022-12-31 23:59:59"
"[_currentHourS, 2022-10-01 19:00:00]",_currentHourS,"2022-10-01 19:00:00",_currentHourS,"2022-10-01 19:00:00"
"[_currentHourE, 2022-10-01 19:59:59]",_currentHourE,"2022-10-01 19:59:59",_currentHourE,"2022-10-01 19:59:59"
"[_currentMinute5S, 2022-10-01 19:26:00]",_currentMinute5S,"2022-10-01 19:26:00",_currentMinute5S,"2022-10-01 19:26:00"
"[_currentMinute5E, 2022-10-01 19:31:59]",_currentMinute5E,"2022-10-01 19:31:59",_currentMinute5E,"2022-10-01 19:31:59"
"[_currentMinute10S, 2022-10-01 19:12:00]",_currentMinute10S,"2022-10-01 19:12:00",_currentMinute10S,"2022-10-01 19:12:00"
"[_currentMinute10E, 2022-10-01 19:31:59]",_currentMinute10E,"2022-10-01 19:31:59",_currentMinute10E,"2022-10-01 19:31:59"
"[_currentMinute15S, 2022-10-01 19:16:00]",_currentMinute15S,"2022-10-01 19:16:00",_currentMinute15S,"2022-10-01 19:16:00"
"[_currentMinute15E, 2022-10-01 19:31:59]",_currentMinute15E,"2022-10-01 19:31:59",_currentMinute15E,"2022-10-01 19:31:59"
"[_currentMinute30S, 2022-10-01 19:01:00]",_currentMinute30S,"2022-10-01 19:01:00",_currentMinute30S,"2022-10-01 19:01:00"
"[_currentMinute30E, 2022-10-01 19:31:59]",_currentMinute30E,"2022-10-01 19:31:59",_currentMinute30E,"2022-10-01 19:31:59"
"[_currentMinute45S, 2022-10-01 18:46:00]",_currentMinute45S,"2022-10-01 18:46:00",_currentMinute45S,"2022-10-01 18:46:00"
"[_currentMinute45E, 2022-10-01 19:31:59]",_currentMinute45E,"2022-10-01 19:31:59",_currentMinute45E,"2022-10-01 19:31:59"
"[_currentMinute60S, 2022-10-01 18:31:00]",_currentMinute60S,"2022-10-01 18:31:00",_currentMinute60S,"2022-10-01 18:31:00"
"[_currentMinute60E, 2022-10-01 19:31:59]",_currentMinute60E,"2022-10-01 19:31:59",_currentMinute60E,"2022-10-01 19:31:59"
"[_currentPrevDayS, 2022-09-30 00:00:00]",_currentPrevDayS,"2022-09-30 00:00:00",_currentPrevDayS,"2022-09-30 00:00:00"
"[_currentPrevDayE, 2022-09-30 23:59:59]",_currentPrevDayE,"2022-09-30 23:59:59",_currentPrevDayE,"2022-09-30 23:59:59"
"[_currentPrevWeekS, 2022-09-19 00:00:00]",_currentPrevWeekS,"2022-09-19 00:00:00",_currentPrevWeekS,"2022-09-19 00:00:00"
"[_currentPrevWeekE, 2022-09-25 23:59:59]",_currentPrevWeekE,"2022-09-25 23:59:59",_currentPrevWeekE,"2022-09-25 23:59:59"
"[_currentPrevMonthS, 2022-09-01 00:00:00]",_currentPrevMonthS,"2022-09-01 00:00:00",_currentPrevMonthS,"2022-09-01 00:00:00"
"[_currentPrevMonthE, 2022-09-30 23:59:59]",_currentPrevMonthE,"2022-09-30 23:59:59",_currentPrevMonthE,"2022-09-30 23:59:59"
"[_currentPrevYearS, 2021-01-01 00:00:00]",_currentPrevYearS,"2021-01-01 00:00:00",_currentPrevYearS,"2021-01-01 00:00:00"
"[_currentPrevYearE, 2021-12-31 23:59:59]",_currentPrevYearE,"2021-12-31 23:59:59",_currentPrevYearE,"2021-12-31 23:59:59"
"[_currentNextDayS, 2022-10-02 00:00:00]",_currentNextDayS,"2022-10-02 00:00:00",_currentNextDayS,"2022-10-02 00:00:00"
"[_currentNextDayE, 2022-10-02 23:59:59]",_currentNextDayE,"2022-10-02 23:59:59",_currentNextDayE,"2022-10-02 23:59:59"
"[_currentNextWeekS, 2022-10-03 00:00:00]",_currentNextWeekS,"2022-10-03 00:00:00",_currentNextWeekS,"2022-10-03 00:00:00"
"[_currentNextWeekE, 2022-10-09 23:59:59]",_currentNextWeekE,"2022-10-09 23:59:59",_currentNextWeekE,"2022-10-09 23:59:59"
"[_currentNextMonthS, 2022-11-01 00:00:00]",_currentNextMonthS,"2022-11-01 00:00:00",_currentNextMonthS,"2022-11-01 00:00:00"
"[_currentNextMonthE, 2022-11-30 23:59:59]",_currentNextMonthE,"2022-11-30 23:59:59",_currentNextMonthE,"2022-11-30 23:59:59"
"[_currentNextYearS, 2023-01-01 00:00:00]",_currentNextYearS,"2023-01-01 00:00:00",_currentNextYearS,"2023-01-01 00:00:00"
"[_currentNextYearE, 2023-12-31 23:59:59]",_currentNextYearE,"2023-12-31 23:59:59",_currentNextYearE,"2023-12-31 23:59:59"
"[_currentMonth, 10]",_currentMonth,10,_currentMonth,10
"[_currentYear, 2022]",_currentYear,2022,_currentYear,2022
"[_futureWeek01S, 2022-10-01 00:00:00]",_futureWeek01S,"2022-10-01 00:00:00",_futureWeek01S,"2022-10-01 00:00:00"
"[_futureWeek01E, 2022-10-07 23:59:59]",_futureWeek01E,"2022-10-07 23:59:59",_futureWeek01E,"2022-10-07 23:59:59"
"[_futureMonth01S, 2022-10-01 00:00:00]",_futureMonth01S,"2022-10-01 00:00:00",_futureMonth01S,"2022-10-01 00:00:00"
"[_futureMonth01E, 2022-10-31 23:59:59]",_futureMonth01E,"2022-10-31 23:59:59",_futureMonth01E,"2022-10-31 23:59:59"
"[_futureMonth03S, 2022-12-31 23:59:59]",_futureMonth03S,"2022-12-31 23:59:59",_futureMonth03S,"2022-12-31 23:59:59"
"[_futureMonth06S, 2022-10-01 00:00:00]",_futureMonth06S,"2022-10-01 00:00:00",_futureMonth06S,"2022-10-01 00:00:00"
"[_futureMonth06E, 2023-03-31 23:59:59]",_futureMonth06E,"2023-03-31 23:59:59",_futureMonth06E,"2023-03-31 23:59:59"
"[_futureMonth12S, 2022-10-01 00:00:00]",_futureMonth12S,"2022-10-01 00:00:00",_futureMonth12S,"2022-10-01 00:00:00"
"[_futureMonth12E, 2023-09-30 23:59:59]",_futureMonth12E,"2023-09-30 23:59:59",_futureMonth12E,"2023-09-30 23:59:59"
"[_filterDateS, 00:00:00]",_filterDateS,00:00:00,_filterDateS,00:00:00
"[_filterDateE, 23:59:59]",_filterDateE,23:59:59,_filterDateE,23:59:59
"[_filterDateEn,  23:59:59]",_filterDateEn," 23:59:59",_filterDateEn," 23:59:59"
"[_currentChartValues, System.Collections.Generic.List`1[System.String]]",_currentChartValues,System.Collections.Generic.List`1[System.String],_currentChartValues,System.Collections.Generic.List`1[System.String]
"[_defaultAreaCode, 350000]",_defaultAreaCode,350000,_defaultAreaCode,350000
"[_defaultDepId, member]",_defaultDepId,member,_defaultDepId,member
"[_defaultJobId, member]",_defaultJobId,member,_defaultJobId,member
"[_defaultOpenUserRoleId, dbadmim,development]",_defaultOpenUserRoleId,"dbadmim,development",_defaultOpenUserRoleId,"dbadmim,development"
"[_defaultRoleId, member]",_defaultRoleId,member,_defaultRoleId,member
"[_defaultSysId, 1b5d7033-6c15-485e-7ea517509d1b-be1b]",_defaultSysId,1b5d7033-6c15-485e-7ea517509d1b-be1b,_defaultSysId,1b5d7033-6c15-485e-7ea517509d1b-be1b
"[_defaultUserId, member]",_defaultUserId,member,_defaultUserId,member
"[_sysId, System.Collections.Generic.List`1[System.String]]",_sysId,System.Collections.Generic.List`1[System.String],_sysId,System.Collections.Generic.List`1[System.String]
"[_userPushName, 开发管理员]",_userPushName,开发管理员,_userPushName,开发管理员
文档更新时间: 2023-01-04 13:08   作者:admin