|

楼主 |
发表于 2015-10-12 11:01:32
|
显示全部楼层
public static Table queryOrderList(String cardId, java.sql.Date orderDate, String mealType, String orderStatus, String mealTime, String orderId, String stbh) {
Map<String, Object> params = new HashMap<String, Object>();
params.put("STBH", stbh);
params.put("cardId", cardId);
params.put("orderDate", orderDate);
params.put("mealType", mealType);
params.put("orderStatus", orderStatus);
params.put("mealTime", mealTime);
params.put("orderId", orderId);
String sql = "select a.DDBH,a.XDSJ,a.XM from DC_DD a "
+ " optional join ZH_KPXX b on b.YGKXPXLH = a.YGKXPXLH and b.KPZT = '0'"
+ " optional join ZH_RYDAXX c on c.GMSFHM = b.GMSFHM"
+ " where a.STBH = :STBH and substring(a.XDSJ,1,10) = rderDate";
if (cardId != null && !cardId.trim().isEmpty()) {
sql += " and (c.YGKH=:cardId or b.GMSFHM=:cardId ) ";
}
if (mealType != null && !mealType.trim().isEmpty()) {
sql += " and a.DDLX=:mealType ";
}
if (orderStatus != null && !orderStatus.trim().isEmpty()) {
sql += " and a.DDZT= rderStatus ";
}
if (mealTime != null && !mealTime.trim().isEmpty()) {
sql += " and a.DCCC=:mealTime";
}
if (orderId != null && !orderId.trim().isEmpty()) {
sql += " and a.DDBH= rderId ";
}
Table ddbTable = KSQL.select(sql, params, "/BJBusWYST/scj/data", null);
return ddbTable;
} |
|