TbE2eCaOrderDao.java
2.26 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
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.TbE2eCaOrder;
public class TbE2eCaOrderDao extends OracleBaseDao {
public TbE2eCaOrderDao(Map<String, String> params) {
super(params);
}
/**
* 查询资源重派时间不为空的工单
*/
@SuppressWarnings("unchecked")
public List<TbE2eCaOrder> selectTbE2eCaOrder1(Date fileTime,
String productTag, String clientType, String operType) {
HashMap<String, Object> map = new HashMap<String, Object>();
map.put("FILE_TIME", fileTime);
map.put("PRODUCT_TAG", productTag);
map.put("CLIENT_TYPE", clientType);
map.put("OPER_TYPE", operType);
map.put("ORDER_STATUS", "('BOOK','SUSPEND','BILLDEAL','AUDIT','REVERT_CONFIRM')");
try {
return sqlmapClient.queryForList("selectTbE2eCaOrder1", map);
} catch (SQLException e) {
error.error("Exception while selectTbE2eCaOrder1", e);
return null;
}
}
/**
* 查询资源重派时间为空的工单
*/
@SuppressWarnings("unchecked")
public List<TbE2eCaOrder> selectTbE2eCaOrder2(Date fileTime,
String productTag, String clientType, String operType) {
HashMap<String, Object> map = new HashMap<String, Object>();
map.put("FILE_TIME", fileTime);
map.put("PRODUCT_TAG", productTag);
map.put("CLIENT_TYPE", clientType);
map.put("OPER_TYPE", operType);
map.put("ORDER_STATUS", "('BOOK','SUSPEND','BILLDEAL','AUDIT','REVERT_CONFIRM')");
try {
return sqlmapClient.queryForList("selectTbE2eCaOrder2", map);
} catch (SQLException e) {
error.error("Exception while selectTbE2eCaOrder", e);
return null;
}
}
public List<TbE2eCaOrder> selectTbE2eCaOrder(String crmId, String id) {
// TODO Auto-generated method stub
return null;
}
public List<TbE2eCaOrder> selectTbE2eCaOrderForOneStop(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("selectTbE2eCaOrderForOneStop", map);
} catch (SQLException e) {
error.error("Exception while selectTbE2eCaOrderForOneStop", e);
return null;
}
}
}