/**
* 获取案件列表
* @param qp
* 查询参数,只在分页查询时可用,否则为null
* @return Object 当为分页查询时,需要返回IPagableData对象,否则可为任意pojo
*/
public Object queryAjs(IQueryInfo qp) {
DefaultPagableData data = new DefaultPagableData();
int currPage = qp.getCurrPageNo();
int perPageCount = qp.getRowsPerPage();
String fybh = getCorpId();
List<SimpleAj> ajs = ajglService.queryAjs(currPage, perPageCount, fybh);
int count = ajglService.countAj(fybh);
qp.setRowCount(count);
data.setData(ajs);
data.setPageInfo(qp);
return data;
//或者:return QueryManager.queryPageDataByList(ajs, qp);
//或者:在dao层写分页
//或者:在dao层这样写:
<span style="white-space:pre"> </span>public IPagableData getUserList(IQueryInfo qp){
<span style="white-space:pre"> </span>StringBuffer sql = new StringBuffer();
<span style="white-space:pre"> </span>sql.append("select u.C_Name name,");
<span style="white-space:pre"> </span>sql.append("u.C_DEPT deptId,");
<span style="white-space:pre"> </span>sql.append("u.N_SEX NSex,");
<span style="white-space:pre"> </span>sql.append("u.D_CSNY DCsny,");
<span style="white-space:pre"> </span>sql.append("u.C_DH CDh,");
<span style="white-space:pre"> </span>sql.append("u.C_SJ CSj,");
<span style="white-space:pre"> </span>sql.append("u.C_JSZBH CJszbh,");
<span style="white-space:pre"> </span>sql.append("u.C_ZJCX CZjcx,");
<span style="white-space:pre"> </span>sql.append("u.C_CCLZRQ CClzrq,");
<span style="white-space:pre"> </span>sql.append("u.C_SFZZSJ CSfzzsj ");
<span style="white-space:pre"> </span>sql.append("from DB_ATY..T_Aty_User u ");
<span style="white-space:pre"> </span>return queryPageDataBySql(sql.toString(),qp);
<span style="white-space:pre"> </span>}
}