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)); }