参数设置

前端调用后台接口

/** 查询参数列表 */
getList() {
  this.loading = true;
  listConfig(this.addDateRange(this.queryParams, this.dateRange)).then(response => {
      this.configList = response.rows;
      this.total = response.total;
      this.loading = false;
    }
  );
}

/**
 * 获取参数配置列表
 */
@PreAuthorize("@ss.hasPermi('system:config:list')")
@GetMapping("/list")
public TableDataInfo list(SysConfig config)
{
    startPage();
    List<SysConfig> list = configService.selectConfigList(config);
    return getDataTable(list);
}

List<SysConfig> list = configService.selectConfigList(config);

/**
 * 查询参数配置列表
 * 
 * @param config 参数配置信息
 * @return 参数配置集合
 */
@Override
public List<SysConfig> selectConfigList(SysConfig config)
{
    return configMapper.selectConfigList(config);
}

configMapper.selectConfigList(config);

执行sql:

select config_id, config_name, config_key, config_value, config_type, create_by, create_time, update_by, update_time, remark
      from sys_config
      <where>
   <if test="configName != null and configName != ''">
      AND config_name like concat('%', #{configName}, '%')
   </if>
   <if test="configType != null and configType != ''">
      AND config_type = #{configType}
   </if>
   <if test="configKey != null and configKey != ''">
      AND config_key like concat('%', #{configKey}, '%')
   </if>
   <if test="params.beginTime != null and params.beginTime != ''"><!-- 开始时间检索 -->
      and date_format(create_time,'%y%m%d') &gt;= date_format(#{params.beginTime},'%y%m%d')
   </if>
   <if test="params.endTime != null and params.endTime != ''"><!-- 结束时间检索 -->
      and date_format(create_time,'%y%m%d') &lt;= date_format(#{params.endTime},'%y%m%d')
   </if>
</where>

获取系统内置字典

<el-form-item label="系统内置" prop="configType">
  <el-radio-group v-model="form.configType">
    <el-radio
      v-for="dict in typeOptions"
      :key="dict.dictValue"
      :label="dict.dictValue"
    >{{dict.dictLabel}}</el-radio>
  </el-radio-group>
</el-form-item>

created() {
  this.getList();
  this.getDicts("sys_yes_no").then(response => {
    this.typeOptions = response.data;
  });
}

/**
 * 根据字典类型查询字典数据信息
 */
@PreAuthorize("@ss.hasPermi('system:dict:query')")
@GetMapping(value = "/dictType/{dictType}")
public AjaxResult dictType(@PathVariable String dictType)
{
    return AjaxResult.success(dictDataService.selectDictDataByType(dictType));
}

执行sql：

select dict_code, dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, remark
from sys_dict_data
where status = '0' and dict_type = "sys_yes_no" order by dict_sort asc