public IEnumerable <Swsj> ListSwsjByTypePCatChargeOEType(ListSwsjByTypePCatChargeOETypeRequestApi criteria)
{
var where = new StringBuilder();
where.AppendFormatWithEscape("swsj.cono = {0}", this.swsjRepository.Cono);
if (!string.IsNullOrWhiteSpace(criteria.jobtype))
{
where.AppendFormatWithEscape(" AND swsj.jobtype = '{0}'", criteria.jobtype);
}
if (!string.IsNullOrWhiteSpace(criteria.oetype) && criteria.oetype.ToLower() != "b")
{
where.AppendFormatWithEscape(" AND swsj.gentype = {0}", criteria.oetype.ToLower() == "s" ? "true" : "false");
}
if (!string.IsNullOrWhiteSpace(criteria.prodcat))
{
where.AppendFormatWithEscape(" AND swsj.prodcat = '{0}'", criteria.prodcat);
}
if (!string.IsNullOrWhiteSpace(criteria.warrantycd) && criteria.warrantycd.ToLower() != "a")
{
where.AppendFormatWithEscape(" AND swsj.warrantycd = '{0}'", criteria.warrantycd.ToLower());
}
return(this.swsjRepository.GetList(where.ToString(), criteria.batchsize, criteria.fldlist));
}
public IEnumerable <Swsj> ListSwsjByTypePCatChargeOEType(ListSwsjByTypePCatChargeOETypeRequestApi criteria)
{
return(this.swsjService.ListSwsjByTypePCatChargeOEType(criteria));
}