| | |
| | | using System.Collections.Generic; |
| | | using System.Linq.Expressions; |
| | | using System.Text; |
| | | using Model.ModelDto.BllAsnDto; |
| | | using Model.ModelVm.BllAsnVm; |
| | | using SqlSugar; |
| | | using WMS.DAL; |
| | |
| | | } |
| | | |
| | | //获取标签箱码信息 |
| | | public List<BllLabelBoxNo> GetLabelBoxList(LabelBoxVm model, out int count) |
| | | public List<LabelBoxDto> GetLabelBoxList(LabelBoxVm model, out int count) |
| | | { |
| | | try |
| | | { |
| | |
| | | var data = GetAllWhereAsync(item) |
| | | .LeftJoin<SysUserInfor>((a, b) => a.CreateUser == b.Id) |
| | | .LeftJoin<SysUserInfor>((a, b, c) => a.UpdateUser == c.Id) |
| | | .Select((a, b, c) => new BllLabelBoxNo() |
| | | .Select((a, b, c) => new LabelBoxDto() |
| | | { |
| | | Id = a.Id, |
| | | ASNNo = a.ASNNo, |
| | | ASNDetailNo = a.ASNDetailNo, |
| | | AsnNo = a.ASNNo, |
| | | AsnDetailNo = a.ASNDetailNo, |
| | | BoxNo = a.BoxNo, |
| | | ParentBoxNo = a.ParentBoxNo, |
| | | Qty = a.Qty, |
| | |
| | | UDF4 = a.UDF4, |
| | | UDF5 = a.UDF5, |
| | | |
| | | //CreateUserName = b.RealName, |
| | | //UpdateUserName = c.RealName, |
| | | CreateUserName = b.RealName, |
| | | UpdateUserName = c.RealName, |
| | | CreateTime = a.CreateTime, |
| | | UpdateTime = a.UpdateTime |
| | | |
| | | }).OrderByDescending(a => a.CreateTime).OrderBy(a => a.BoxNo).ToOffsetPage(model.Page, model.Limit, ref total); |
| | | count = total; |
| | | //return data; |
| | | return data; |
| | | } |
| | | catch (Exception e) |
| | | { |