/**
* 删除自定义字段
*
* @param cmId 表单ID
* @param request 请求
* @param response 响应
*/
@RequestMapping("/{fieldId}/delete")
public void delete(
@PathVariable int fieldId, HttpServletRequest request, HttpServletResponse response) {
//
DiyFormFieldEntity diyFormField = (DiyFormFieldEntity) this.diyFormFieldBiz.getEntity(fieldId);
if (diyFormField == null) {
this.outJson(
response,
null,
false,
this.getResString("err.not.exist", this.getResString("diy.form.field")));
return;
}
DiyFormEntity diyForm =
(DiyFormEntity) this.diyFormBiz.getEntity(diyFormField.getDiyFormFieldFormId());
if (diyForm == null) {
this.outJson(
response, null, false, this.getResString("err.not.exist", this.getResString("diy.form")));
return;
}
Map fields = new HashMap();
// 要删除的字段名
fields.put("fieldName", diyFormField.getDiyFormFieldFieldName());
// 删除列
diyFormFieldBiz.alterTable(diyForm.getDiyFormTableName(), fields, "drop");
diyFormFieldBiz.deleteEntity(diyFormField.getDiyFormFieldId());
this.outJson(response, null, true);
}
/**
* 更新字段信息
*
* @param field 要更新的字段信息的id
* @param response
*/
@RequestMapping("/update")
@ResponseBody
public void update(
@ModelAttribute DiyFormFieldEntity diyFormfield, HttpServletResponse response) {
// 更新前判断数据是否合法
if (!StringUtil.checkLength(diyFormfield.getDiyFormFieldTipsName(), 1, 20)) {
this.outJson(
response,
null,
false,
getResString("err.length", this.getResString("fieldTipsName"), "1", "20"));
return;
}
if (!StringUtil.checkLength(diyFormfield.getDiyFormFieldFieldName(), 1, 20)) {
this.outJson(
response,
null,
false,
getResString("err.length", this.getResString("fieldFieldName"), "1", "20"));
return;
}
// 获取自定义表单实体
DiyFormEntity diyForm =
(DiyFormEntity) diyFormBiz.getEntity(diyFormfield.getDiyFormFieldFormId());
// 读取属性配置文件
Map<String, String> maps = new LinkedHashMap<String, String>();
maps = getMapByProperties("com/mingsoft/basic/resources/field_data_type");
// 获取更改前的字段实体
DiyFormFieldEntity oldField =
(DiyFormFieldEntity) diyFormFieldBiz.getEntity(diyFormfield.getDiyFormFieldId());
Map fields = new HashMap();
// 更改前的字段名
fields.put("fieldOldName", oldField.getDiyFormFieldFieldName());
// 新字段名
fields.put("fieldName", diyFormfield.getDiyFormFieldFieldName());
// 字段的数据类型
fields.put("fieldType", maps.get(String.valueOf(diyFormfield.getDiyFormFieldType())));
if (diyForm == null) {
this.outJson(response, null, false, this.getResString("err.not.exist"));
return;
}
// 更新表的字段名
diyFormFieldBiz.alterTable(diyForm.getDiyFormTableName(), fields, "modify");
diyFormFieldBiz.updateEntity(diyFormfield);
this.outJson(response, null, true, null);
}
/**
* @param diyFormfield
* @param cmTableName
* @param response
*/
@RequestMapping("/{diyFormId}/save")
@ResponseBody
public void save(
@ModelAttribute DiyFormFieldEntity diyFormfield,
@PathVariable int diyFormId,
HttpServletResponse response) {
// 获取自定义表单实体
DiyFormEntity diyForm = (DiyFormEntity) diyFormBiz.getEntity(diyFormId);
if (diyForm == null) {
this.outJson(
response, null, false, this.getResString("err.not.exist", this.getResString("diy.form")));
return;
}
// 更新前判断数据是否合法
if (!StringUtil.checkLength(diyFormfield.getDiyFormFieldTipsName(), 1, 20)) {
this.outJson(
response,
null,
false,
getResString("err.length", this.getResString("fieldTipsName"), "1", "20"));
return;
}
if (!StringUtil.checkLength(diyFormfield.getDiyFormFieldFieldName(), 1, 20)) {
this.outJson(
response,
null,
false,
getResString("err.length", this.getResString("fieldFieldName"), "1", "20"));
return;
}
// 读取属性配置文件
Map<String, String> maps = new LinkedHashMap<String, String>();
maps = getMapByProperties("com/mingsoft/basic/resources/field_data_type");
// 动态的修改表结构
// 获取字段信息
Map fileds = new HashMap();
// 压入字段名
fileds.put("fieldName", diyFormfield.getDiyFormFieldFieldName());
// 字段的数据类型
fileds.put("fieldType", maps.get(String.valueOf(diyFormfield.getDiyFormFieldType())));
fileds.put("default", diyFormfield.getDiyFormFieldDefault());
// 在表中创建字段
diyFormFieldBiz.alterTable(diyForm.getDiyFormTableName(), fileds, "add");
this.diyFormFieldBiz.saveEntity(diyFormfield);
this.outJson(response, null, true, null);
}