public void execute(String action, Obationable o, RunData data, Object arg) throws Exception {
HttpServletRequest request = data.getRequest();
initQueryItem(data.getRequest());
QueryBasic queryBasic = fixedQuery;
queryBasic.setSearchValue(data.getRequest());
String SQL = ""; // queryBasic.getWhereQuery();
dwdm = request.getParameter("dwdm");
dwmc = request.getParameter("dwmc");
cpbm = request.getParameter("cpbm");
product = request.getParameter("product");
String dwtxid = request.getParameter("dwtxid");
String cpid = request.getParameter("cpid");
String zk$a = request.getParameter("zk$a");
String zk$b = request.getParameter("zk$b");
if (dwtxid.length() > 0) SQL = SQL + " AND a.dwtxid=" + dwtxid;
if (cpid.length() > 0) SQL = SQL + " AND a.cpid=" + cpid;
if (zk$a.length() > 0) SQL = SQL + " AND a.zk>=" + zk$a;
if (zk$b.length() > 0) SQL = SQL + " AND a.zk<=" + zk$b;
SQL =
combineSQL(
CUSTOMER_PRODUCT_DISCOUNT_SQL,
"?",
new String[] {fgsid, user.getHandleDeptValue(), SQL});
if (!dsxs_khcpzkTable.getQueryString().equals(SQL)) {
dsxs_khcpzkTable.setQueryString(SQL);
dsxs_khcpzkTable.setRowMax(null);
}
}
/**
* 得到固定查询的用户输入的值
*
* @param col 查询项名称
* @return 用户输入的值
*/
public final String getFixedQueryValue(String col) {
return fixedQuery.getSearchRow().get(col);
}
