示例#1
0
    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);
      }
    }
示例#2
0
 /**
  * 得到固定查询的用户输入的值
  *
  * @param col 查询项名称
  * @return 用户输入的值
  */
 public final String getFixedQueryValue(String col) {
   return fixedQuery.getSearchRow().get(col);
 }