1、类修改:
1)查询类
public class DataBaseQueryCriteria {
/*附件数量*/
@Query(type = Query.Type.BETWEEN)
private List<Integer> fileNum;
/*有无附件*/
private Boolean hasFile;
public void setHasFile(Boolean hasFile) {
this.hasFile = hasFile;
fileNum = new ArrayList<>();
if(hasFile){
fileNum.add(1);
fileNum.add(5);
}else{
fileNum.add(-1);
fileNum.add(0);
}
}
}
2)Dto类
/*附件数量*/
private Integer filenum;
3)Entity类
@ApiModelProperty(value = "附件数量")
private Integer fileNum;
2、页面增加字段定义:
file_num 表单字段:附件数量 */
const defaultForm = { id: null,hasFile:null, file_num: null,
3、增加查询条件:
<el-select v-model="query.hasFile" style="width: 100px;" class="el-form-item-label" filterable placeholder="附件">
<el-option label="有" value="1"/>
<el-option label="无" value="0"/>
</el-select>
<rrOperation :crud="crud" />
4、附件移除修改:
if (!this.form.enabled && file.hasOwnProperty('uuid')) {
this.fileList = fileList
fileRemove(file.uuid, file.id)
}
},
5、表单保存修改
const existFile = this.fileList.length > 0 ? this.fileList.find(f => f.hasOwnProperty('raw')) : false
this.form.fileNum = this.fileList.length
...
}
6、数据增加字段
ALTER TABLE data_teacher_otherduty ADD file_num varchar(255) comment '附件数量' ;
ALTER TABLE data_teacher_otherduty alter column file_num set default 0 ;