public List browseBForm(String classid) throws Exception {
String sql =
"select a.id,a.cname,a.url,a.descript,b.cname classname "
+ " from t_sys_wfbform a left join t_sys_wfbflowclass b on a.classid=b.id where a.classid="
+ SQLParser.charValue(classid.trim());
return jdbcDao.getJdbcTemplate().queryForList(sql);
}
public String get_browse_sql(Map map) {
String cname = (String) map.get("cname");
String classname = (String) map.get("classname");
StringBuffer sql = new StringBuffer();
sql.append(" select f.id id,f.cname cname,f.url url,c.cname classname ").append("\n");
sql.append(" from t_sys_wfbform f left join t_sys_wfbflowclass c on f.classid=c.id ");
sql.append(" where 1=1 ").append("\n");
if (!StringToolKit.isBlank(cname)) {
sql.append(" and Lower(f.cname) like Lower(" + SQLParser.charLikeValue(cname) + ")")
.append("\n");
}
if (!StringToolKit.isBlank(classname)) {
sql.append(" and Lower(c.cname) like Lower(" + SQLParser.charLikeValue(classname) + ")")
.append("\n");
}
sql.append("order by f.cname");
return sql.toString();
}
public DynamicObject select_fk_bflow(String flowdefid) throws Exception {
StringBuffer sql = new StringBuffer();
sql.append(
"select a.id, a.cname, a.url, a.descript from T_SYS_WFbflow b left join T_SYS_WFbform a on a.id = b.formid where b.id = ");
sql.append(SQLParser.charValueRT(flowdefid));
DynamicObject dvo =
new DynamicObject(DyDaoHelper.queryForMap(jdbcDao.getJdbcTemplate(), sql.toString()));
return dvo;
}