app_config.json

\RG3.Web.Host.PaaS\Config\AppConfig\basis\app_config.json

 "whereSqlsA": {
    //连接组合后的语句添加到 whereSqls
    "_whereSqlDateId": [
      // #endregion 本月
      "{s-if:_filterDateId}{op-eq:0} and {{_filterDateCol}} between @_currentMonthS and @_currentMonthE {op-eq:0}{e-if:_filterDateId}",
      // #endregion 本月
      // #region 上个月
      "{s-if:_filterDateId}{op-eq:1} and {{_filterDateCol}} between @_currentPrevMonthS and @_currentPrevMonthE {op-eq:1}{e-if:_filterDateId}",
      // #endregion 上个月
      // #region 本周
      "{s-if:_filterDateId}{op-eq:2} and {{_filterDateCol}} between @_currentWeekS and @_currentWeekE {op-eq:2}{e-if:_filterDateId}",
      // #endregion 本周
      // #region 上一周
      "{s-if:_filterDateId}{op-eq:3} and {{_filterDateCol}} between @_currentPrevWeekS and @_currentPrevWeekE {op-eq:3}{e-if:_filterDateId}",
      // #endregion 上一周
      // #region 今年
      "{s-if:_filterDateId}{op-eq:4} and {{_filterDateCol}} between @_currentYearS and @_currentYearE {op-eq:4}{e-if:_filterDateId}",
      // #endregion 今年
      // #region 去年
      "{s-if:_filterDateId}{op-eq:5} and {{_filterDateCol}} between @_currentPrevYearS and @_currentPrevYearE {op-eq:5}{e-if:_filterDateId}",
      // #endregion 去年
      // #region 当日
      "{s-if:_filterDateId}{op-eq:6} and {{_filterDateCol}} between @_currentDayS  and @_currentDayS {op-eq:6}{e-if:_filterDateId}",
      // #endregion 当日
      // #region 昨日
      "{s-if:_filterDateId}{op-eq:7} and {{_filterDateCol}} between @_currentPrevDayS and @_currentPrevDayE {op-eq:7}{e-if:_filterDateId}"
      // #endregion 昨日
    ]
  },