public IEnumerable <Item> GetTWLItems(GetTWLItemsApi getTWLItemsApi)
{
var sb = new StringBuilder();
if (!string.IsNullOrWhiteSpace(getTWLItemsApi.coNum))
{
sb.AppendFormatWithEscape("item.co_num = '{0}'", getTWLItemsApi.coNum);
if (!string.IsNullOrWhiteSpace(getTWLItemsApi.whNum))
{
sb.AppendFormatWithEscape(" AND item.wh_num = '{0}'", getTWLItemsApi.whNum);
}
if (!string.IsNullOrWhiteSpace(getTWLItemsApi.absNum))
{
sb.AppendFormatWithEscape(" AND item.abs_num = '{0}'", getTWLItemsApi.absNum);
}
if (!string.IsNullOrWhiteSpace(getTWLItemsApi.itemType))
{
sb.AppendFormatWithEscape(" AND item.item_type = '{0}'", getTWLItemsApi.itemType);
}
if (!string.IsNullOrWhiteSpace(getTWLItemsApi.prodGrp))
{
sb.AppendFormatWithEscape(" AND item.prod_grp = '{0}'", getTWLItemsApi.prodGrp);
}
}
var where = sb.ToString();
return(this.itemRepository.GetList(where, getTWLItemsApi.batchsize, getTWLItemsApi.fldlist));
}
public IEnumerable <Item> GetTWLItems(string coNum, string whNum, int batchsize = 0, string fldlist = "")
{
var getTWLItemsApi = new GetTWLItemsApi()
{
coNum = coNum,
whNum = whNum,
batchsize = batchsize,
fldlist = fldlist
};
return(this.itemService.GetTWLItems(getTWLItemsApi));
}
public IEnumerable <Item> GetTWLItems(string coNum, string whNum, string absNum, string itemType, string prodGrp, int batchsize = 0, string fldlist = "")
{
var getTWLItemsApi = new GetTWLItemsApi()
{
coNum = coNum,
whNum = whNum,
absNum = absNum,
itemType = itemType,
prodGrp = prodGrp,
batchsize = batchsize,
fldlist = fldlist
};
return(this.itemService.GetTWLItems(getTWLItemsApi));
}
public IEnumerable <Item> GetTWLItems(GetTWLItemsApi getTWLItemsApi)
{
return(this.itemService.GetTWLItems(getTWLItemsApi));
}