public IEnumerable <CarrierService> GetTWLCarrierServices(string coNum, string whNum, int batchsize = 0, string fldlist = "")
{
var getTWLCarrierServicesApi = new GetTWLCarrierServicesApi()
{
coNum = coNum,
whNum = whNum,
batchsize = batchsize,
fldlist = fldlist
};
return(this.carrierServiceService.GetTWLCarrierServices(getTWLCarrierServicesApi));
}
public IEnumerable <CarrierService> GetTWLCarrierServices(GetTWLCarrierServicesApi getTWLCarrierServicesApi)
{
return(this.carrierServiceService.GetTWLCarrierServices(getTWLCarrierServicesApi));
}
public IEnumerable <Infor.Sxe.TWL.Data.Models.PdscarrierService.CarrierService> GetTWLCarrierServices(GetTWLCarrierServicesApi getTWLCarrierServicesApi)
{
var sb = new StringBuilder();
if (!string.IsNullOrWhiteSpace(getTWLCarrierServicesApi.coNum))
{
sb.AppendFormatWithEscape("carrier_service.co_num = '{0}'", getTWLCarrierServicesApi.coNum);
if (!string.IsNullOrWhiteSpace(getTWLCarrierServicesApi.whNum))
{
sb.AppendFormatWithEscape(" AND carrier_service.wh_num = '{0}'", getTWLCarrierServicesApi.whNum);
}
if (!string.IsNullOrWhiteSpace(getTWLCarrierServicesApi.carrierId))
{
sb.AppendFormatWithEscape(" AND carrier_service.carrier_id = '{0}'", getTWLCarrierServicesApi.carrierId);
}
if (!string.IsNullOrWhiteSpace(getTWLCarrierServicesApi.service))
{
sb.AppendFormatWithEscape(" AND carrier_service.service = '{0}'", getTWLCarrierServicesApi.service);
}
}
var where = sb.ToString();
return(this.carrierServiceRepository.GetList(where, getTWLCarrierServicesApi.batchsize, getTWLCarrierServicesApi.fldlist));
}
