/**
* 根据处理状态查询计费信息
*
* @author 左香勇 2014-9-25
* @update
* @param state 处理状态 pageRoll 分页查询对象
* @return List<ConsumerOrderGoodsinfoData> 计费信息
* @since vmaque 1.5
*/
public List<ConsumerOrderGoodsinfoData> getAccountList(PageRoll pageRoll, Integer state) {
// 定义查询语句
StringBuffer querySql = new StringBuffer("select * from(SELECT ");
querySql.append("MCG.ID AS ID,");
querySql.append("MCO.PAYTYPE AS PAYTYPE,MCO.PRICE AS PRICE,");
querySql.append("MCO.STATE AS STATE,MCO.PAYTIME AS PAYTIME,");
querySql.append("MCO.ID AS MCOID,MCO.TRANSFERTIME AS TRANSFERTIME,");
querySql.append("MCO.TRANSFERPRICE AS TRANSFERPRICE,");
querySql.append("MCO.TRANSFERPEOPLE AS TRANSFERPEOPLE,");
querySql.append("ac.receivableaccount AS RECEIVABLEACCOUNT, ");
querySql.append("ac.accounttype as acctype ");
querySql.append("FROM MINI_CONSUMERORDER_GOODSINFO MCG ");
querySql.append("JOIN MINI_CONSUMERORDER MCO ON MCG.CONSUMERORDERID = MCO.ID ");
querySql.append("JOIN MINI_PAGE MPG ON MCO.PAGEID = MPG.ID ");
querySql.append("JOIN CTN_SYSUSER CSU ON MPG.USER_ID = CSU.ID ");
querySql.append("join MINI_ACCOUNTNUMBER ac on ac.userid=csu.id ");
querySql.append("WHERE MCO.STATE = ? ) ");
querySql.append("where PAYTYPE=acctype");
List<Object> objects = new ArrayList<Object>();
objects.add(state);
// 分页查询
pageRoll.setCountSQL("SELECT COUNT(1) FROM (" + querySql.toString() + ")");
pageRoll.setSearchSQL(querySql.toString());
JdbcDao jdbcDao = (JdbcDao) SpringContextHelper.getBean("jdbc"); // 获取jdbc
List<ETIPResultSet> rsList = jdbcDao.search(pageRoll, objects);
List<ConsumerOrderGoodsinfoData> consumerOrderGoodsinfoDatas =
new ArrayList<ConsumerOrderGoodsinfoData>();
for (int i = 0; i < rsList.size(); i++) {
ConsumerOrderGoodsinfoData consumerOrderGoodsinfoData = new ConsumerOrderGoodsinfoData();
ConSumerOrderData sumerOrderData = new ConSumerOrderData();
UserData userData = new UserData();
PageData pageData = new PageData();
userData.setReceivableAccount(rsList.get(i).getString("RECEIVABLEACCOUNT"));
pageData.setUserData(userData);
sumerOrderData.setPageData(pageData);
sumerOrderData.setId(rsList.get(i).getString("MCOID"));
sumerOrderData.setPrice(rsList.get(i).getDouble("PRICE"));
sumerOrderData.setState(rsList.get(i).getInt("STATE"));
sumerOrderData.setPayType(rsList.get(i).getInt("PAYTYPE"));
sumerOrderData.setPayTime(rsList.get(i).getDate("PAYTIME"));
sumerOrderData.setTransferPeople(rsList.get(i).getString("TRANSFERPEOPLE"));
sumerOrderData.setTransferPrice(rsList.get(i).getDouble("TRANSFERPRICE"));
sumerOrderData.setTransferTime(rsList.get(i).getDate("TRANSFERTIME"));
consumerOrderGoodsinfoData.setConSumerOrderData(sumerOrderData);
consumerOrderGoodsinfoData.setId(rsList.get(i).getString("ID"));
consumerOrderGoodsinfoDatas.add(consumerOrderGoodsinfoData);
}
return consumerOrderGoodsinfoDatas;
}
