示例#1
0
文件: OrderBill.cs 项目: op706/-
        /// <summary>
        /// 查询单据分页
        /// </summary>
        /// <param name="entity"></param>
        /// <param name="pageInfo"></param>
        /// <returns></returns>
        public override List <OrdersEntity> GetList(OrdersEntity entity, ref Framework.DataTypes.PageInfo pageInfo)
        {
            entity.IncludeAll();
            entity.Where(a => a.IsDelete == (int)EIsDelete.NotDelete);
            entity.OrderBy(a => a.ID, EOrderBy.DESC);
            AdminEntity admin = new AdminEntity();

            admin.Include(a => new { CreateUserName = a.UserName });
            entity.Left <AdminEntity>(admin, new Params <string, string>()
            {
                Item1 = "CreateUser", Item2 = "UserCode"
            });
            OrderDetailEntity detail = new OrderDetailEntity();

            detail.Include(a => new { BarCode = a.BarCode, ProductNum = a.ProductNum, ProductName = a.ProductName });
            entity.Left <OrderDetailEntity>(detail, new Params <string, string>()
            {
                Item1 = "SnNum", Item2 = "OrderSnNum"
            });
            int rowCount = 0;
            List <OrdersEntity> listResult = this.Orders.GetList(entity, pageInfo.PageSize, pageInfo.PageIndex, out rowCount);

            pageInfo.RowCount = rowCount;
            return(listResult);
        }
示例#2
0
        /// <summary>
        /// 查询单据分页
        /// </summary>
        /// <param name="entity"></param>
        /// <param name="pageInfo"></param>
        /// <returns></returns>
        public override List <OutStorageEntity> GetList(OutStorageEntity entity, ref Framework.DataTypes.PageInfo pageInfo)
        {
            entity.IncludeAll();
            entity.Where(a => a.IsDelete == (int)EIsDelete.NotDelete);
            entity.OrderBy(a => a.ID, EOrderBy.DESC);
            AdminEntity admin = new AdminEntity();

            admin.Include(a => new { CreateUserName = a.UserName });
            entity.Left <AdminEntity>(admin, new Params <string, string>()
            {
                Item1 = "CreateUser", Item2 = "UserCode"
            });
            int rowCount = 0;
            List <OutStorageEntity> listResult = this.OutStorage.GetList(entity, pageInfo.PageSize, pageInfo.PageIndex, out rowCount);

            pageInfo.RowCount = rowCount;
            if (!listResult.IsNullOrEmpty())
            {
                foreach (OutStorageEntity item in listResult)
                {
                    OutStoDetailEntity detail = new OutStoDetailEntity();
                    detail.IncludeAll();
                    detail.Where(a => a.OrderNum == item.OrderNum);
                    List <OutStoDetailEntity> listDetail = this.OutStoDetail.GetList(detail);
                    if (!listDetail.IsNullOrEmpty())
                    {
                        foreach (OutStoDetailEntity detailItem in listDetail)
                        {
                            item.ProductNames += string.Format("[{0}]", detailItem.ProductName);
                        }
                    }
                }
            }
            return(listResult);
        }
示例#3
0
        /// <summary>
        /// 查询单据分页
        /// </summary>
        /// <param name="entity"></param>
        /// <param name="pageInfo"></param>
        /// <returns></returns>
        public override List <MoveOrderEntity> GetList(MoveOrderEntity entity, ref Framework.DataTypes.PageInfo pageInfo)
        {
            entity.IncludeAll();
            entity.Where(a => a.IsDelete == (int)EIsDelete.NotDelete)
            .And(a => a.CompanyID == this.CompanyID);
            entity.OrderBy(a => a.ID, EOrderBy.DESC);

            if (!entity.OrderNum.IsEmpty())
            {
                entity.Where("OrderNum", ECondition.Like, "%" + entity.OrderNum + "%");
            }
            if (entity.StorageNum.IsNotEmpty())
            {
                entity.And(a => a.StorageNum == entity.StorageNum);
            }
            if (entity.MoveType > 0)
            {
                entity.And(a => a.MoveType == entity.MoveType);
            }
            if (!entity.ContractOrder.IsEmpty())
            {
                entity.And("ContractOrder", ECondition.Like, "%" + entity.ContractOrder + "%");
            }
            if (entity.Status > 0)
            {
                entity.And(a => a.Status == entity.Status);
            }
            if (entity.BeginTime.IsNotEmpty())
            {
                DateTime Begin = ConvertHelper.ToType <DateTime>(entity.BeginTime, DateTime.Now.Date.AddDays(-10)).Date;
                entity.And(a => a.CreateTime >= Begin);
            }
            if (entity.EndTime.IsNotEmpty())
            {
                DateTime End = ConvertHelper.ToType <DateTime>(entity.EndTime, DateTime.Now).AddDays(1).Date;
                entity.And(a => a.CreateTime < End);
            }

            AdminEntity admin = new AdminEntity();

            admin.Include(a => new { CreateUserName = a.UserName });
            entity.Left <AdminEntity>(admin, new Params <string, string>()
            {
                Item1 = "CreateUser", Item2 = "UserNum"
            });
            int rowCount = 0;
            List <MoveOrderEntity> listResult = this.MoveOrder.GetList(entity, pageInfo.PageSize, pageInfo.PageIndex, out rowCount);

            pageInfo.RowCount = rowCount;
            return(listResult);
        }
示例#4
0
        /// <summary>
        /// 查询单据分页
        /// </summary>
        /// <param name="entity"></param>
        /// <param name="pageInfo"></param>
        /// <returns></returns>
        public override List <ReturnOrderEntity> GetList(ReturnOrderEntity entity, ref Framework.DataTypes.PageInfo pageInfo)
        {
            entity.IncludeAll();
            entity.Where(a => a.IsDelete == (int)EIsDelete.NotDelete);
            entity.OrderBy(a => a.ID, EOrderBy.DESC);
            AdminEntity admin = new AdminEntity();

            admin.Include(a => new { CreateUserName = a.UserName });
            entity.Left <AdminEntity>(admin, new Params <string, string>()
            {
                Item1 = "CreateUser", Item2 = "UserCode"
            });
            int rowCount = 0;
            List <ReturnOrderEntity> listResult = this.ReturnOrder.GetList(entity, pageInfo.PageSize, pageInfo.PageIndex, out rowCount);

            pageInfo.RowCount = rowCount;
            return(listResult);
        }
示例#5
0
        /// <summary>
        /// 采购退货单明细分页列表
        /// </summary>
        /// <param name="entity"></param>
        /// <param name="pageInfo"></param>
        /// <returns></returns>
        public override List <PurchaseReturnDetailEntity> GetDetailList(PurchaseReturnDetailEntity entity, ref Framework.DataTypes.PageInfo pageInfo)
        {
            PurchaseReturnDetailEntity detail = new PurchaseReturnDetailEntity();

            detail.And(a => a.CompanyID == this.CompanyID)
            ;
            if (!entity.OrderSnNum.IsEmpty())
            {
                detail.And(a => a.OrderSnNum == entity.OrderSnNum);
            }
            if (!entity.BarCode.IsEmpty())
            {
                detail.And("BarCode", ECondition.Like, "%" + entity.BarCode + "%");
            }
            if (!entity.ProductName.IsEmpty())
            {
                detail.And("ProductName", ECondition.Like, "%" + entity.ProductName + "%");
            }

            PurchaseReturnEntity returnOrder = new PurchaseReturnEntity();

            detail.Left <PurchaseReturnEntity>(returnOrder, new Params <string, string>()
            {
                Item1 = "OrderSnNum", Item2 = "SnNum"
            });
            returnOrder.Include(a => new { SupNum = a.SupNum, SupName = a.SupName, Phone = a.Phone, Contact = a.Contact, PurchaseSnNum = a.PurchaseSnNum, PurchaseOrderNum = a.PurchaseOrderNum, Status = a.Status });
            returnOrder.And(a => a.IsDelete == (int)EIsDelete.NotDelete);

            if (!entity.SupNum.IsEmpty())
            {
                returnOrder.AndBegin <PurchaseReturnEntity>()
                .And <PurchaseReturnEntity>("SupNum", ECondition.Like, "%" + entity.SupNum + "%")
                .Or <PurchaseReturnEntity>("SupName", ECondition.Like, "%" + entity.SupNum + "%")
                .End <PurchaseReturnEntity>()
                ;
            }
            if (!entity.SupName.IsEmpty())
            {
                returnOrder.AndBegin <PurchaseReturnEntity>()
                .And <PurchaseReturnEntity>("SupNum", ECondition.Like, "%" + entity.SupName + "%")
                .Or <PurchaseReturnEntity>("SupName", ECondition.Like, "%" + entity.SupName + "%")
                .End <PurchaseReturnEntity>()
                ;
            }
            if (!entity.Phone.IsEmpty())
            {
                returnOrder.And("Phone", ECondition.Like, "%" + entity.Phone + "%");
            }
            if (!entity.PurchaseSnNum.IsEmpty())
            {
                returnOrder.And(item => item.PurchaseSnNum == entity.PurchaseSnNum);
            }
            if (!entity.PurchaseOrderNum.IsEmpty())
            {
                returnOrder.And("PurchaseOrderNum", ECondition.Like, "%" + entity.PurchaseOrderNum + "%");
            }
            if (!entity.BeginTime.IsEmpty())
            {
                DateTime time = ConvertHelper.ToType <DateTime>(entity.BeginTime, DateTime.Now.Date.AddDays(-1));
                returnOrder.And(a => a.CreateTime >= time);
            }
            if (!entity.EndTime.IsEmpty())
            {
                DateTime time = ConvertHelper.ToType <DateTime>(entity.EndTime, DateTime.Now.Date.AddDays(1));
                returnOrder.And(a => a.CreateTime < time);
            }
            if (entity.Status > 0)
            {
                returnOrder.And(item => item.Status == entity.Status);
            }

            detail.IncludeAll();
            detail.Exclude(item => new { item.Status });
            detail.OrderBy(a => a.ID, EOrderBy.DESC);
            int rowCount = 0;
            List <PurchaseReturnDetailEntity> listResult = this.PurchaseReturnDetail.GetList(detail, pageInfo.PageSize, pageInfo.PageIndex, out rowCount);

            pageInfo.RowCount = rowCount;
            if (!listResult.IsNullOrEmpty())
            {
                ProductProvider productProvider = new ProductProvider(this.CompanyID);
                foreach (PurchaseReturnDetailEntity item in listResult)
                {
                    ProductEntity product = productProvider.GetProduct(item.ProductNum);
                    item.UnitName = product != null ? product.UnitName : string.Empty;
                    item.Size     = product != null ? product.Size : string.Empty;
                }
            }
            return(listResult);
        }
示例#6
0
        /// <summary>
        /// 查询采购退货单分页列表
        /// </summary>
        /// <param name="entity"></param>
        /// <param name="pageInfo"></param>
        /// <returns></returns>
        public override List <PurchaseReturnEntity> GetList(PurchaseReturnEntity entity, ref Framework.DataTypes.PageInfo pageInfo)
        {
            entity.IncludeAll();
            entity.Where(a => a.IsDelete == (int)EIsDelete.NotDelete)
            .And(a => a.CompanyID == this.CompanyID);
            entity.OrderBy(a => a.ID, EOrderBy.DESC);

            if (entity.OrderNum.IsNotEmpty())
            {
                entity.And("OrderNum", ECondition.Like, "%" + entity.OrderNum + "%");
            }
            if (entity.SupNum.IsNotEmpty())
            {
                entity.And("SupNum", ECondition.Like, "%" + entity.SupNum + "%");
            }
            if (entity.SupName.IsNotEmpty())
            {
                entity.And("SupName", ECondition.Like, "%" + entity.SupName + "%");
            }
            if (entity.Contact.IsNotEmpty())
            {
                entity.And("Contact", ECondition.Like, "%" + entity.Contact + "%");
            }
            if (entity.Phone.IsNotEmpty())
            {
                entity.And("Phone", ECondition.Like, "%" + entity.Phone + "%");
            }
            if (entity.PurchaseSnNum.IsNotEmpty())
            {
                entity.And(item => item.PurchaseSnNum == entity.PurchaseSnNum);
            }
            if (entity.PurchaseOrderNum.IsNotEmpty())
            {
                entity.And("PurchaseOrderNum", ECondition.Like, "%" + entity.PurchaseOrderNum + "%");
            }
            if (entity.Status > 0)
            {
                entity.And(item => item.Status == entity.Status);
            }
            if (entity.BeginTime.IsNotEmpty())
            {
                DateTime begin = ConvertHelper.ToType <DateTime>(entity.BeginTime, DateTime.Now.AddDays(-30)).Date;
                entity.And(item => item.CreateTime >= begin);
            }
            if (entity.EndTime.IsNotEmpty())
            {
                DateTime end = ConvertHelper.ToType <DateTime>(entity.EndTime, DateTime.Now).AddDays(1).Date;
                entity.And(item => item.CreateTime < end);
            }

            AdminEntity admin = new AdminEntity();

            admin.Include(a => new { CreateUserName = a.UserName });
            entity.Left <AdminEntity>(admin, new Params <string, string>()
            {
                Item1 = "CreateUser", Item2 = "UserNum"
            });

            int rowCount = 0;
            List <PurchaseReturnEntity> listResult = this.PurchaseReturn.GetList(entity, pageInfo.PageSize, pageInfo.PageIndex, out rowCount);

            pageInfo.RowCount = rowCount;
            return(listResult);
        }
示例#7
0
        /// <summary>
        /// 查询单据详细数据分页
        /// </summary>
        /// <param name="entity"></param>
        /// <param name="pageInfo"></param>
        /// <returns></returns>
        public override List <OutStoDetailEntity> GetDetailList(OutStoDetailEntity entity, ref Framework.DataTypes.PageInfo pageInfo)
        {
            OutStoDetailEntity detail = new OutStoDetailEntity();

            detail.Where(a => a.OrderNum == entity.OrderNum);
            detail.IncludeAll();
            detail.OrderBy(a => a.ID, EOrderBy.DESC);
            int rowCount = 0;
            List <OutStoDetailEntity> listResult = this.OutStoDetail.GetList(detail, pageInfo.PageSize, pageInfo.PageIndex, out rowCount);

            pageInfo.RowCount = rowCount;
            if (!listResult.IsNullOrEmpty())
            {
                List <LocationEntity> listLocation = new LocationProvider().GetList();
                listLocation = listLocation == null ? new List <LocationEntity>() : listLocation;
                foreach (OutStoDetailEntity item in listResult)
                {
                    LocationEntity location = listLocation.FirstOrDefault(a => a.LocalNum == item.LocalNum);
                    item.LocalName = location == null ? "" : location.LocalName;
                    if (item.Amount == 0)
                    {
                        item.Amount = item.OutPrice * item.Num;
                    }
                }
            }
            return(listResult);
        }
示例#8
0
文件: OrderBill.cs 项目: op706/-
        /// <summary>
        /// 查询单据详细数据分页
        /// </summary>
        /// <param name="entity"></param>
        /// <param name="pageInfo"></param>
        /// <returns></returns>
        public override List <OrderDetailEntity> GetDetailList(OrderDetailEntity entity, ref Framework.DataTypes.PageInfo pageInfo)
        {
            OrderDetailEntity detail = new OrderDetailEntity();

            detail.Where(a => a.OrderNum == entity.OrderNum);
            detail.IncludeAll();
            detail.OrderBy(a => a.ID, EOrderBy.DESC);
            int rowCount = 0;
            List <OrderDetailEntity> listResult = this.OrderDetail.GetList(detail, pageInfo.PageSize, pageInfo.PageIndex, out rowCount);

            pageInfo.RowCount = rowCount;
            return(listResult);
        }
示例#9
0
        /// <summary>
        /// 查询单据详细数据分页
        /// </summary>
        /// <param name="entity"></param>
        /// <param name="pageInfo"></param>
        /// <returns></returns>
        public override List <OutStoDetailEntity> GetDetailList(OutStoDetailEntity entity, ref Framework.DataTypes.PageInfo pageInfo)
        {
            OutStoDetailEntity detail = new OutStoDetailEntity();

            detail.IncludeAll();
            detail.OrderBy(a => a.ID, EOrderBy.DESC);
            detail.And(a => a.CompanyID == this.CompanyID);
            if (!entity.BarCode.IsEmpty())
            {
                detail.And("BarCode", ECondition.Like, "%" + entity.BarCode + "%");
            }
            if (!entity.ProductName.IsEmpty())
            {
                detail.And("ProductName", ECondition.Like, "%" + entity.ProductName + "%");
            }
            if (!entity.StorageNum.IsEmpty())
            {
                detail.And(a => a.StorageNum == entity.StorageNum);
            }

            OutStorageEntity OutOrder = new OutStorageEntity();

            detail.Left <OutStorageEntity>(OutOrder, new Params <string, string>()
            {
                Item1 = "OrderSnNum", Item2 = "SnNum"
            });
            OutOrder.Include(a => new { CusNum = a.CusNum, CusName = a.CusName, SendDate = a.SendDate, Status = a.Status, OutType = a.OutType, AuditeTime = a.AuditeTime, CarrierName = a.CarrierName, LogisticsNo = a.LogisticsNo });
            OutOrder.And(a => a.IsDelete == (int)EIsDelete.NotDelete);
            if (!entity.CusNum.IsEmpty())
            {
                OutOrder.AndBegin <OutStorageEntity>()
                .And <OutStorageEntity>("CusNum", ECondition.Like, "%" + entity.CusNum + "%")
                .Or <OutStorageEntity>("CusName", ECondition.Like, "%" + entity.CusNum + "%")
                .End <OutStorageEntity>()
                ;
            }
            if (!entity.CusName.IsEmpty())
            {
                OutOrder.AndBegin <OutStorageEntity>()
                .And <OutStorageEntity>("CusNum", ECondition.Like, "%" + entity.CusName + "%")
                .Or <OutStorageEntity>("CusName", ECondition.Like, "%" + entity.CusName + "%")
                .End <OutStorageEntity>()
                ;
            }
            if (!entity.BeginTime.IsEmpty())
            {
                DateTime time = ConvertHelper.ToType <DateTime>(entity.BeginTime, DateTime.Now.Date.AddDays(30)).Date;
                OutOrder.And(a => a.CreateTime >= time);
            }
            if (!entity.EndTime.IsEmpty())
            {
                DateTime time = ConvertHelper.ToType <DateTime>(entity.EndTime, DateTime.Now).Date.AddDays(1);
                OutOrder.And(a => a.CreateTime < time);
            }
            if (entity.Status > 0)
            {
                OutOrder.And(item => item.Status == entity.Status);
            }
            if (entity.OutType > 0)
            {
                OutOrder.And(item => item.OutType == entity.OutType);
            }
            if (entity.OrderNum.IsNotEmpty())
            {
                OutOrder.And("OrderNum", ECondition.Like, "%" + entity.OrderNum + "%");
            }
            if (!entity.CarrierNum.IsEmpty())
            {
                OutOrder.And(item => item.CarrierNum == entity.CarrierNum);
            }
            if (!entity.CarrierName.IsEmpty())
            {
                OutOrder.And("CarrierName", ECondition.Like, "%" + entity.CarrierName + "%");
            }
            if (!entity.LogisticsNo.IsEmpty())
            {
                OutOrder.And("LogisticsNo", ECondition.Like, "%" + entity.LogisticsNo + "%");
            }
            ProductEntity product = new ProductEntity();

            product.Include(item => new { Size = item.Size });
            detail.Left <ProductEntity>(product, new Params <string, string>()
            {
                Item1 = "ProductNum", Item2 = "SnNum"
            });

            AdminEntity admin = new AdminEntity();

            admin.Include(a => new { CreateUserName = a.UserName });
            OutOrder.Left <AdminEntity>(admin, new Params <string, string>()
            {
                Item1 = "CreateUser", Item2 = "UserNum"
            });

            AdminEntity auditeAdmin = new AdminEntity();

            auditeAdmin.Include(a => new { AuditeUserName = a.UserName });
            OutOrder.Left <AdminEntity>(auditeAdmin, new Params <string, string>()
            {
                Item1 = "AuditUser", Item2 = "UserNum"
            });

            int rowCount = 0;
            List <OutStoDetailEntity> listResult = this.OutStoDetail.GetList(detail, pageInfo.PageSize, pageInfo.PageIndex, out rowCount);

            pageInfo.RowCount = rowCount;
            if (!listResult.IsNullOrEmpty())
            {
                List <LocationEntity> listLocation = new LocationProvider(this.CompanyID).GetList();
                listLocation = listLocation == null ? new List <LocationEntity>() : listLocation;
                foreach (OutStoDetailEntity item in listResult)
                {
                    LocationEntity location = listLocation.FirstOrDefault(a => a.LocalNum == item.LocalNum);
                    item.LocalName   = location == null ? "" : location.LocalName;
                    item.StorageName = location == null ? "" : location.StorageName;
                }
            }
            return(listResult);
        }
示例#10
0
        /// <summary>
        /// 查询单据详细数据分页
        /// </summary>
        /// <param name="entity"></param>
        /// <param name="pageInfo"></param>
        /// <returns></returns>
        public override List <MoveOrderDetailEntity> GetDetailList(MoveOrderDetailEntity entity, ref Framework.DataTypes.PageInfo pageInfo)
        {
            MoveOrderDetailEntity detail = new MoveOrderDetailEntity();

            detail
            .And(a => a.CompanyID == this.CompanyID);

            if (entity.OrderSnNum.IsNotEmpty())
            {
                detail.And(item => item.OrderSnNum == entity.OrderSnNum);
            }
            if (entity.ProductName.IsNotEmpty())
            {
                detail.And("ProductName", ECondition.Like, "%" + entity.ProductName + "%");
            }
            if (entity.BarCode.IsNotEmpty())
            {
                detail.And("BarCode", ECondition.Like, "%" + entity.BarCode + "%");
            }
            detail.IncludeAll();
            detail.OrderBy(a => a.ID, EOrderBy.DESC);

            MoveOrderEntity moveOrder = new MoveOrderEntity();

            moveOrder.Include(item => new { Status = item.Status, MoveType = item.MoveType, AuditeTime = item.AuditeTime });
            detail.Left <MoveOrderEntity>(moveOrder, new Params <string, string>()
            {
                Item1 = "OrderSnNum", Item2 = "SnNum"
            });
            moveOrder.And(item => item.IsDelete == (int)EIsDelete.NotDelete);
            if (entity.OrderNum.IsNotEmpty())
            {
                moveOrder.And("OrderNum", ECondition.Like, "%" + entity.OrderNum + "%");
            }
            if (entity.Status > 0)
            {
                moveOrder.And(item => item.Status == entity.Status);
            }
            if (entity.BeginTime.IsNotEmpty())
            {
                DateTime begin = ConvertHelper.ToType <DateTime>(entity.BeginTime, DateTime.Now.AddDays(-10)).Date;
                moveOrder.And(item => item.CreateTime >= begin);
            }
            if (entity.EndTime.IsNotEmpty())
            {
                DateTime end = ConvertHelper.ToType <DateTime>(entity.EndTime, DateTime.Now).AddDays(1).Date;
                moveOrder.And(item => item.CreateTime < end);
            }
            if (entity.MoveType > 0)
            {
                moveOrder.And(item => item.MoveType == entity.MoveType);
            }
            if (entity.StorageNum.IsNotEmpty())
            {
                moveOrder.And(item => item.StorageNum == entity.StorageNum);
            }

            AdminEntity admin = new AdminEntity();

            admin.Include(a => new { CreateUserName = a.UserName });
            moveOrder.Left <AdminEntity>(admin, new Params <string, string>()
            {
                Item1 = "CreateUser", Item2 = "UserNum"
            });

            AdminEntity auditeAdmin = new AdminEntity();

            auditeAdmin.Include(a => new { AuditUserName = a.UserName });
            moveOrder.Left <AdminEntity>(auditeAdmin, new Params <string, string>()
            {
                Item1 = "AuditUser", Item2 = "UserNum"
            });

            int rowCount = 0;
            List <MoveOrderDetailEntity> listResult = this.MoveOrderDetail.GetList(detail, pageInfo.PageSize, pageInfo.PageIndex, out rowCount);

            pageInfo.RowCount = rowCount;
            if (!listResult.IsNullOrEmpty())
            {
                List <LocationEntity> listLocation = new LocationProvider(this.CompanyID).GetList();
                listLocation = listLocation == null ? new List <LocationEntity>() : listLocation;

                ProductProvider productProvider = new ProductProvider(this.CompanyID);
                foreach (MoveOrderDetailEntity item in listResult)
                {
                    LocationEntity location = listLocation.FirstOrDefault(a => a.LocalNum == item.FromLocalNum);
                    item.FromLocalName = location == null ? "" : location.LocalName;
                    location           = listLocation.FirstOrDefault(a => a.LocalNum == item.ToLocalNum);
                    item.ToLocalName   = location == null ? "" : location.LocalName;
                    item.StorageName   = location == null ? "" : location.StorageName;

                    ProductEntity productEntity = productProvider.GetProduct(item.ProductNum);
                    item.UnitName = productEntity != null ? productEntity.ProductName : string.Empty;
                    item.Size     = productEntity != null ? productEntity.Size : string.Empty;
                }
            }
            return(listResult);
        }