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