/** * @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; }
/** * @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; }
/** * @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; }
/** * @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; }