예제 #1
0
  /**
   * @todo Implement this ces.architect.util.QueryBean method
   * @param aform ActionForm
   * @return AdvQueryString
   */
  protected AdvQueryString generateListQuery(ActionForm aform) {
    RepairPartForm form = (RepairPartForm) aform;
    AdvQueryString listQuery = new AdvQueryString();

    ArrayList paramList = this.queryCondition(form);
    String queryString = "from RepairPartForm as rsf " + whereIn + " order by rsf.partsId desc ";

    listQuery.setQueryString(queryString);
    listQuery.setParameters(paramList);

    return listQuery;
  }
예제 #2
0
  /**
   * @todo Implement this ces.architect.util.QueryBean method
   * @param aform ActionForm
   * @return AdvQueryString
   */
  protected AdvQueryString generateCountQuery(ActionForm aform) {
    RepairPartForm form = (RepairPartForm) aform;
    AdvQueryString countQuery = new AdvQueryString();

    ArrayList paramList = this.queryCondition(form);
    String queryString = "select count(rsf) from RepairPartForm as rsf " + whereIn;

    countQuery.setQueryString(queryString);
    countQuery.setParameters(paramList);

    return countQuery;
  }
예제 #3
0
  /**
   * @todo Implement this ces.architect.util.QueryBean method
   * @param actionform ActionForm
   * @return AdvQueryString
   */
  protected AdvQueryString generateCountQuery(ActionForm aform) {
    SaleDetailForm form = (SaleDetailForm) aform;
    AdvQueryString countQuery = new AdvQueryString();

    String queryString =
        "select count(distinct pa.saleDetailId) from SaleDetailForm as pa,StockInfoForm as sif ";

    ArrayList paramList = this.queryCondition(form);

    queryString = queryString + where;

    countQuery.setQueryString(queryString);
    countQuery.setParameters(paramList);

    return countQuery;
  }
예제 #4
0
  /**
   * @todo Implement this ces.architect.util.QueryBean method
   * @param actionform ActionForm
   * @return AdvQueryString
   */
  protected AdvQueryString generateListQuery(ActionForm aform) {
    SaleDetailForm form = (SaleDetailForm) aform;
    AdvQueryString listQuery = new AdvQueryString();

    String queryString =
        "select distinct pa.saleDetailId,pa.saleNo,pa.stuffNo,pa.skuCode,"
            + "pa.skuUnit,pa.partNum,pa.modelCode,pa.modelSerialNo,pa.salePerPrice,"
            + "(sif.skuNum),pa.createBy,pa.createDate,pa.version "
            + "from SaleDetailForm as pa,StockInfoForm as sif ";

    ArrayList paramList = this.queryCondition(form);

    queryString = queryString + where + " order by pa.saleNo,pa.stuffNo ";

    listQuery.setQueryString(queryString);
    listQuery.setParameters(paramList);

    return listQuery;
  }