角色、Mapper权限组合过滤

DbSqlService$WherePopedomSql

RG3.BO.DB\Services\DbSqlService$WherePopedomSql.cs

ResponseField 机构 _depId

 if (sqlConfig.ResponseFieldTemp.PopedomRoleSql != null)
            {
                var lstId = dictionary[SystemParamConst.CURRENT_ROLE_ID] as List<string>;
                foreach (var id in lstId)
                {
                    sbSql.Append(GetPopedomSql(id, sqlConfig.ResponseFieldTemp.PopedomRoleSql));
                }
            }

ResponseField 职位 _jobId

   if (sqlConfig.ResponseFieldTemp.PopedomJobSql != null)
            {
                var lstId = dictionary[SystemParamConst.CURRENT_JOB_ID] as List<string>;
                foreach (var id in lstId)
                {
                    sbSql.Append(GetPopedomSql(id, sqlConfig.ResponseFieldTemp.PopedomJobSql));
                }
            }

ResponseField 角色 _roleId

  if (sqlConfig.ResponseFieldTemp.PopedomDepSql != null)
            {
                var lstId = dictionary[SystemParamConst.CURRENT_DEP_ID] as List<string>;
                foreach (var id in lstId)
                {
                    sbSql.Append(GetPopedomSql(id, sqlConfig.ResponseFieldTemp.PopedomDepSql));
                }
            }

ResponseField 行政区 _areaCode

            if (sqlConfig.ResponseFieldTemp.PopedomAreaCodeSql != null)
            {
                var lstId = dictionary[SystemParamConst.CURRENT_AREA_CODE] as List<string>;
                foreach (var id in lstId)
                {
                    sbSql.Append(GetPopedomSql(id, sqlConfig.ResponseFieldTemp.PopedomAreaCodeSql));
                }
            }

ResponseField配置

    "manager": {
      "auth": true,

          "popedomRoleSql": {
            "member": [
              // #region 开始空格 start  角色  key对应roleId
              {
                "value": " and role_id in @_roleId",
                "sortId": 1
              }
              // #endregion 开始空格 start
            ]
          },
          "popedomJobSql": {
            "99999": [
              // #region 开始空格 start    key对应jobId
              {
                "value": " and job_id in @_jobId",
                "sortId": 1
              }
              // #endregion 开始空格 start
            ]
          },
          "popedomDepSql": {
            "ded": [
              // #region 开始空格 start  key 对应 depId
              {
                "value": " and dep_id in @_depId",
                "sortId": 1
              }
              // #endregion 开始空格 start
            ]
          },
          "popedomAreaCodeSql": {
            "ee": [
              // #region 开始空格 start   新政区 key对应 areaCode
              {
                "value": " and area_code in @_areaCode",
                "sortId": 1
              }
              // #endregion 开始空格 start
            ]
          },
    },