@Override
public List<PersonJoinBrhBean> pagedQuery(PersonJoinBrhBean t) {
List<Object> ls = new ArrayList<Object>();
StringBuffer cond = new StringBuffer();
PubFunc.personBeanToListAndWhere(t, ls, cond);
String baseSql = PubDefine.personBaseSql + cond.toString();
// 权限判断语句
baseSql = PubFunc.authoritySQL(baseSql);
String sqlStr =
PubFunc.simpleTableQuery(
baseSql,
"t_joinbrh",
new String[] {
"rankID as \"joinRankID\"",
"workDate",
"postDate",
"annuitytag",
"workBegin",
"insYears",
"recruitFrom",
"recruitType",
"localAttr",
"recommUID",
"recommName"
},
new String[] {"pid"},
new String[] {"pid"},
new String[] {});
t.setParams(ls);
t.setSql(sqlStr);
t.setFilter(true);
return dao.queryPage(
t, new POJORowMapper<PersonJoinBrhBean>(new String[] {}, PersonJoinBrhBean.class));
}
@Override
public List<PersonBankBean> pagedQuery(PersonBankBean t) {
List<Object> ls = new ArrayList<Object>();
StringBuffer cond = new StringBuffer();
PubFunc.personBeanToListAndWhere(t, ls, cond);
String baseSql = PubDefine.personBaseSql + cond.toString();
// 权限判断语句
baseSql = PubFunc.authoritySQL(baseSql);
String sqlStr =
PubFunc.simpleTableQuery(
baseSql,
"t_psnBank",
new String[] {
"serNo", "bankNo", "bankBranch", "acctOwner", "acctNo", "startDate", "endDate"
},
new String[] {"pid"},
new String[] {"pid"},
new String[] {});
t.setParams(ls);
t.setSql(sqlStr);
t.setFilter(true);
return dao.queryPage(
t, new POJORowMapper<PersonBankBean>(new String[] {}, PersonBankBean.class));
}