public IEnumerable <PvSapbq> GetPvSapbqListByQueueNameAndDemand(GetPvSapbqListByQueueAndDemandRequestApi criteria)
{
var where = new StringBuilder();
if (string.IsNullOrEmpty(criteria.demand))
{
criteria.demand = "a";
}
where.AppendFormatWithEscape("((pv_sapbq.demand_only = true and '{0}' = 'd')", criteria.demand);
where.AppendFormatWithEscape(" or (pv_sapbq.demand_only = false and '{0}' = 's')", criteria.demand);
where.AppendFormatWithEscape(" or '{0}' = 'a') ", criteria.demand);
if (!string.IsNullOrWhiteSpace(criteria.queueName))
{
where.AppendFormatWithEscape(" and pv_sapbq.queue_name begins '{0}'", criteria.queueName);
}
return(this.pvSapbqRepository.GetList(where.ToString(), criteria.batchsize, criteria.fldlist));
}
public IEnumerable <PvSapbq> ListByQueueNameAndDemand(GetPvSapbqListByQueueAndDemandRequestApi criteria)
{
return(this.pvSapbqService.GetPvSapbqListByQueueNameAndDemand(criteria));
}
