// 更新设计信息
private boolean updateDesign(String funcId, String pageType, String content) {
String sql =
"update fun_design set page_content = ? "
+ "where fun_id = '"
+ funcId
+ "' and page_type = '"
+ pageType
+ "' ";
return BigFieldUtil.updateStream(sql, content, DefineName.DESIGN_NAME);
}
/**
* 取功能的页面设计信息
*
* @param funcId
* @param pageType
* @return
*/
private String readDesignPage(String funcId, String pageType) {
String sql =
"select page_content from fun_design "
+ "where fun_id = '"
+ funcId
+ "' and page_type = '"
+ pageType
+ "' ";
return BigFieldUtil.readStream(sql, "page_content", DefineName.DESIGN_NAME);
}
// 新增设计信息
private boolean insertDesign(String funcId, String pageType, String content) {
String sql = "insert into fun_design(design_id, fun_id, page_type) " + "values(?, ?, ?)";
// 创建主键
String keyId = KeyCreator.getInstance().createKey("fun_design");
DaoParam param = _dao.createParam(sql);
param.setDsName(DefineName.DESIGN_NAME);
param.addStringValue(keyId).addStringValue(funcId).addStringValue(pageType);
_dao.update(param);
// 保存大字段信息
String usql = "update fun_design set page_content = ? where design_id = '" + keyId + "'";
return BigFieldUtil.updateStream(usql, content, DefineName.DESIGN_NAME);
}