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.TbE2eOneStopKxOrder;

public class TbE2eKxOrderDao extends OracleBaseDao {

	public TbE2eKxOrderDao(Map<String, String> params) {
		super(params);
	}
	
	/**取一条指定时间、指定CRM工单号、指定P6号的数据。政企一站式用*/
	public List<TbE2eOneStopKxOrder> selectTbE2eOneStopKxOrder(Date fileTime, String crmId, String p6Id) {
		HashMap<String, Object> map = new HashMap<String, Object>();
		map.put("FILE_TIME", fileTime);
		map.put("crmId", crmId);
		map.put("p6Id", p6Id);
		try {
			return sqlmapClient.queryForList("selectTbE2eOneStopKxOrder", map);
		} catch (SQLException e) {
			error.error("Exception while selectTbE2eOneStopKxOrder", e);
			return null;
		}
	}
	
	/**取指定时间点的客响数据列表*/
	public List<TbE2eOneStopKxOrder> selectTbE2eOneStopKxOrder2(Date fileTime) {
		HashMap<String, Object> map = new HashMap<String, Object>();
		map.put("FILE_TIME", fileTime);
		try {
			return sqlmapClient.queryForList("selectTbE2eOneStopKxOrder2", map);
		} catch (SQLException e) {
			error.error("Exception while selectTbE2eOneStopKxOrder2", e);
			return null;
		}
	}
}