コード例 #1
0
 @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));
 }
コード例 #2
0
 @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));
 }