@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));
}
