public static ListData<QueryFormItem> getAll(
QueryFormItem vo, String start, String offset, String orderBy, String order) {
// 指定值对象类型(VOClass)。例子VOClass=User
// 指定插入表名称(tableName)。例子：如user表，tableName=user
// 指定O-R映射规则对象。默认mapping
return SimpleDaoTemplate.query(
"SELECT * FROM app_queryform_item WHERE 1 = 1 and tableId = " + vo.getTableId() + " ",
new DymaticCondition()
.addSimpleCondition(vo, "name", "showName")
.addCondition("ORDER BY {0} {1}", orderBy, order),
mapping,
QueryFormItem.class,
start,
offset);
}
public static int sort(String id) {
QueryFormItem vo = get(id);
String sort = vo.getSort();
if ("boolean.true".equals(sort)) {
vo.setSort("boolean.false");
vo.setSortName("否");
} else {
vo.setSort("boolean.true");
vo.setSortName("是");
}
return edit(vo);
}
public static int condition(String id) {
QueryFormItem vo = get(id);
String condtion = vo.getCondition();
if ("boolean.true".equals(condtion)) {
vo.setCondition("boolean.false");
vo.setConditionName("否");
} else {
vo.setCondition("boolean.true");
vo.setConditionName("是");
}
return edit(vo);
}
public static int hidden(String id) {
QueryFormItem vo = get(id);
String hidden = vo.getHidden();
if ("visible.true".equals(hidden)) {
vo.setHidden("visible.false");
vo.setHiddenName("隐藏");
} else {
vo.setHidden("visible.true");
vo.setHiddenName("显示");
}
return edit(vo);
}
public static int edit(QueryFormItem vo) {
// 指定值对象类型(VOClass)。例子：User
// 指定插入表名称(tableName)。例子：如user表3个列，tableName=user
// 指定修改列信息(modify)。例子：name=?, value=?
// 根据修改列的顺序获取值对象的属性值。例子：vo.getName(), vo.getValue(), vo.getId()
return SimpleDaoTemplate.update(
"UPDATE app_queryform_item SET name = ?, showName = ?, tableId = ?, `condition` = ?, conditionName = ?, hidden = ?, hiddenName = ?, sort = ?, sortName = ?, width = ?, format = ?, dict = ?, type = ?, typeName = ? WHERE id = ?",
vo.getName(),
vo.getShowName(),
vo.getTableId(),
vo.getCondition(),
vo.getConditionName(),
vo.getHidden(),
vo.getHiddenName(),
vo.getSort(),
vo.getSortName(),
vo.getWidth(),
vo.getFormat(),
vo.getDict(),
vo.getType(),
vo.getTypeName(),
vo.getId());
}
public static int add(QueryFormItem vo) {
// 指定值对象类型(VOClass)。例子：User
// 指定插入表名称(tableName)。例子：如user表3个列，tableName=user(id, name, gender)
// 根据列的顺序获取值对象的属性值。例子：vo.getId(), vo.getName(), vo.getGender()
if (getByName(vo.getName(), vo.getTableId()) != null) {
return 0;
}
return SimpleDaoTemplate.update(
"INSERT INTO app_queryform_item(name, showName, tableId, `condition`, conditionName, hidden, hiddenName, sort, sortName, width, format, dict, type, typeName) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
vo.getName(),
vo.getShowName(),
vo.getTableId(),
vo.getCondition(),
vo.getConditionName(),
vo.getHidden(),
vo.getHiddenName(),
vo.getSort(),
vo.getSortName(),
vo.getWidth(),
vo.getFormat(),
vo.getDict(),
vo.getType(),
vo.getTypeName());
}