public IEnumerable <Smsn> GetSmsnListBySalesRepAndName(GetSmsnListBySalesRepAndNameRequestApi getGetSmsnListBySalesRepAndNameRequestApi)
{
var where = new StringBuilder();
where.Append($"smsn.cono = {this.smsnRepository.Cono}");
if (!string.IsNullOrEmpty(getGetSmsnListBySalesRepAndNameRequestApi.slsrep))
{
where.AppendFormatWithEscape(" AND smsn.slsrep BEGINS '{0}'", getGetSmsnListBySalesRepAndNameRequestApi.slsrep);
}
if (!string.IsNullOrEmpty(getGetSmsnListBySalesRepAndNameRequestApi.name))
{
where.AppendFormatWithEscape(" AND smsn.name BEGINS '{0}'", getGetSmsnListBySalesRepAndNameRequestApi.name);
}
if (!string.IsNullOrEmpty(getGetSmsnListBySalesRepAndNameRequestApi.slsrepboth))
{
where.AppendFormatWithEscape(" AND (smsn.slsrep BEGINS '{0}' or smsn.name BEGINS '{0}')", getGetSmsnListBySalesRepAndNameRequestApi.slsrepboth);
}
return(this.smsnRepository.GetList(
where.ToString(),
getGetSmsnListBySalesRepAndNameRequestApi.batchsize,
getGetSmsnListBySalesRepAndNameRequestApi.fldlist));
}
public IEnumerable <Smsn> GetSmsnListBySalesRepAndName(GetSmsnListBySalesRepAndNameRequestApi GetSmsnListBySalesRepAndNameRequestApi)
{
return(this.smsnService.GetSmsnListBySalesRepAndName(GetSmsnListBySalesRepAndNameRequestApi));
}
