/// <summary> /// 获取待完成拣货商品列表(通过总的拣货单) /// </summary> /// <returns></returns> public List <PickingSubOrderdtlDto> GetPickingOrderdtlDto(PickingSubOrderdtlApo pageDataApo, out int totalCount) { totalCount = 0; List <PickingSubOrderdtlDto> data; //查询语句 var queryable = Db.Queryable <PickingSubOrderdtl, PickingSubOrder>((psod, pso) => new object[] { JoinType.Left, psod.picking_sub_orderid == pso.id }) .Where((psod, pso) => psod.status == (int)RPOStatusType.待完成 && pso.picking_order_code == pageDataApo.picking_order_code) .OrderBy((psod, pso) => psod.birth_date, OrderByType.Desc) .Select <PickingSubOrderdtlDto>(); //如果小于0,默认查全部 if (pageDataApo.PageSize > 0) { data = queryable.ToPageList(pageDataApo.PageIndex, pageDataApo.PageSize, ref totalCount); } else { data = queryable.ToList(); totalCount = data.Count(); } return(data); }
public List <PickingSubOrderdtlDto> GetPickingSubOrderdtlDto(PickingSubOrderdtlApo pageDataApo, out int totalCount) { totalCount = 0; List <PickingSubOrderdtlDto> data; //查询语句 var queryable = Db.Queryable <PickingSubOrderdtl>() .Where(it => it.status == 0 && it.picking_sub_orderid == pageDataApo.picking_sub_orderid) .OrderBy(it => it.birth_date, OrderByType.Desc) .Select <PickingSubOrderdtlDto>(); //如果小于0,默认查全部 if (pageDataApo.PageSize > 0) { data = queryable.ToPageList(pageDataApo.PageIndex, pageDataApo.PageSize, ref totalCount); } else { data = queryable.ToList(); totalCount = data.Count(); } return(data); }