package com.sitech.ismp.coll.busi.e2e.dao;

import java.sql.SQLException;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import com.sitech.ismp.coll.busi.e2e.domain.TbE2eOneStopCrmOrder;

public class TbE2eOneStopCrmOrderDao extends OracleBaseDao {
	public TbE2eOneStopCrmOrderDao(Map<String, String> params) {
		super(params);
	}
	
	@SuppressWarnings("unchecked")
	public List<TbE2eOneStopCrmOrder> selectTbE2eOneStopCrmOrder(Date fileTime) {
		HashMap<String, Object> map = new HashMap<String, Object>();
		map.put("CLIENT_TYPE", "%政企%");
		map.put("PRODUCT_NUM", "'524','482','MSTP510','SDH272'");
		map.put("OPER_TYPE", "新建");
		map.put("FILE_TIME", fileTime);
		try {
			return sqlmapClient.queryForList("selectTbE2eOneStopCrmOrder", map);
		} catch (SQLException e) {
			error.error("Exception while selectTbE2eOneStopCrmOrder", e);
			return null;
		}
	}
}