/** * 根据处理状态查询计费信息 * * @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; }