需求:
按条件设置考核对象保存选中的条件
所需要的表:JXKH_CONDITION
注意:保存时可同时保存多组条件需要保存
入参:jxkh2200 考核方案id,jxkh6700 考核分组id,查询条件字段所在表,查询条件的字段
步骤:保存的数据除了入参的这些数据,还需要额外生成一个主键id进行保存。
接口参数显示形式
list中可批量添加多个对象,这里只显示了一个
xml:
<insert id="SaveSetCondition" parameterType="map">
insert into JXKH_CONDITION(recordid,jxkh2200,jxkh6700,TBLCOD,FLDCOD) values(#{recordid},#{jxkh2200},#{jxkh6700},#{TBLCOD},#{FLDCOD})
</insert>
实现层
// <!-- 按条件设置考核对象保存选中的条件-->
@Override
public boolean SaveSetCondition(SaveSetConditionVo saveSetConditionVo, HttpServletRequest request) {
boolean result=true;
Map<String, Object> map = new HashMap<>();
List<jxkhCondition> savejxkhConditionList = saveSetConditionVo.getSavejxkhConditionList();
if(!CollectionUtils.isEmpty(savejxkhConditionList)){
for(jxkhCondition jxkhCondition:savejxkhConditionList){
String recordid = UUID.randomUUID().toString().toUpperCase();
map.put("recordid",recordid);
map.put("jxkh2200",jxkhCondition.getJxkh2200());
map.put("jxkh6700",jxkhCondition.getJxkh6700());
map.put("fldcod",jxkhCondition.getFLDCOD());
map.put("tblcod",jxkhCondition.getTBLCOD());
result= pmJxkhConditionMapper.SaveSetCondition(map);
}
}
实体类设置:
public class SaveSetConditionVo {
@ApiModelProperty(value = "存放保存的内容,保存考核条件")
private List<jxkhCondition> savejxkhConditionList;
public class jxkhCondition {
@ApiModelProperty(value = “考核方案id”)
@NotBlank(message = “考核方案id不能为空”)
private String jxkh2200;
@ApiModelProperty(value = "考核对象分组id")
@NotBlank(message = "考核对象分组id不能为空")
private String jxkh6700;
@ApiModelProperty(value = "主键id")
@NotNull(message = "主键id不能为空")
private String recordid;
@ApiModelProperty(value = "查询条件字段所在表")
@NotBlank(message = "查询条件字段所在表")
private String TBLCOD;
@ApiModelProperty(value = "查询条件的字段")
@NotNull(message = "查询条件的字段")
private String FLDCOD;
@ApiModelProperty(value = "字段值")
@NotBlank(message = "字段值")
private String FLDVALUE;
@ApiModelProperty(value = "是否多选")
@NotBlank(message = "是否多选")
private String ISMULTISELECT;
@ApiModelProperty(value = "默认值")
@NotNull(message = "默认值")
private String DEFAULTVALUE;
@ApiModelProperty(value = "关系符(=,>,<,>=,<=)")
@NotNull(message = "关系符(=,>,<,>=,<=)")
private String RELATIONMARK;
}