/**
* @Project: hehenian-biz-service Maven Webapp
* @Package com.hehenian.biz.dal.wygj
* @Title: ParkingFeeDaoimpl.java
* @Description: TODO
*
* @author: zhangjhmf
* @date 2015-4-27 下午4:56:57
* @Copyright: HEHENIAN Co.,Ltd. All rights reserved.
* @version V1.0
*/
package com.hehenian.biz.dal.wygj.impl;
import java.util.List;
import java.util.Map;
import javax.annotation.Resource;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate;
import org.springframework.jdbc.core.simple.ParameterizedBeanPropertyRowMapper;
import com.hehenian.biz.common.wygj.dataobject.ParkingFeeDo;
import com.hehenian.biz.dal.wygj.IParkingFeeBusinessDataDao;
import com.hehenian.biz.service.dao.AbstractBaseDaoImpl;
public class ParkingFeeBusinessDataDaoimpl extends AbstractBaseDaoImpl<ParkingFeeDo> implements IParkingFeeBusinessDataDao{
@Resource
private JdbcTemplate sp2pJdbcTemplate;
@Resource
private NamedParameterJdbcTemplate sp2pNameJdbcTemplate;
private static RowMapper<ParkingFeeDo> rowMapper = ParameterizedBeanPropertyRowMapper
.newInstance(ParkingFeeDo.class);
/**
*
* @Description: 预留权限查询
* @param authorityCode
* @return
* @author: zhangjhmf
* @date 2015-4-28 上午10:21:12
*/
public Map<String,Object> listParkingFeeBusiness(Map<String,Object> map) {
String sql = " SELECT a.*,b.period,b.rate,b.money_scope,c.realName user_name,f.* FROM td_fund_trade a INNER JOIN td_product_rate b ON a.rate_id = b.product_rate_id INNER JOIN t_person c ON a.user_id = c.userId INNER join t_parking_property_detailinfo d on a.trade_id = d.trade_id INNER JOIN t_parking_detailinfo f on d.id = f.id;";
try {
this.queryForMap(sp2pNameJdbcTemplate, sql, map);
} catch (Exception e) {
e.printStackTrace();
}
return null;
}
/**
*
* @Description: 预留权限查询
* @param authorityCode
* @return
* @author: zhangjhmf
* @date 2015-4-28 上午10:21:12
*/
public List<Map<String,Object>> exportParkingFeeBusiness(Object[] object) {
String sql = " SELECT a.*,b.period,b.rate,b.money_scope,c.realName user_name,f.* FROM td_fund_trade a INNER JOIN td_product_rate b ON a.rate_id = b.product_rate_id INNER JOIN t_person c ON a.user_id = c.userId INNER join t_parking_property_detailinfo d on a.trade_id = d.trade_id INNER JOIN t_parking_detailinfo f on d.id = f.id;";
try {
return this.queryForMap(sp2pJdbcTemplate, sql, object);
} catch (Exception e) {
e.printStackTrace();
}
return null;
}
@Override
public RowMapper<ParkingFeeDo> getRowMapper() {
return null;
}
}