/// <summary>
/// 仓库设置点击货架查询货架的货位信息
/// </summary>
/// <param name="shelfCode">货架Code</param>
/// <returns></returns>
public object GetCell(string shelfCode)
{
HashSet <WareTree> wareSet = new HashSet <WareTree>();
var cells = CellRepository.GetQueryable().Where(c => c.Shelf.ShelfCode == shelfCode)
.OrderBy(c => c.CellCode).Select(c => c);
foreach (var cell in cells)//货位
{
WareTree cellTree = new WareTree();
cellTree.Code = cell.CellCode;
cellTree.Name = "货位：" + cell.CellName;
cellTree.CellCode = cell.CellCode;
cellTree.CellName = cell.CellName;
cellTree.WarehouseCode = cell.Warehouse.WarehouseCode;
cellTree.WarehouseName = cell.Warehouse.WarehouseName;
cellTree.AreaCode = cell.Area.AreaCode;
cellTree.AreaName = cell.Area.AreaName;
cellTree.ShelfCode = cell.Shelf.ShelfCode;
cellTree.ShelfName = cell.Shelf.ShelfName;
cellTree.Type = cell.CellType;
cellTree.Description = cell.Description;
cellTree.IsActive = cell.IsActive == "1" ? "可用" : "不可用";
cellTree.UpdateTime = cell.UpdateTime.ToString("yyyy-MM-dd hh:mm:ss");
cellTree.ShortName = cell.ShortName;
cellTree.Layer = cell.Layer;
cellTree.MaxQuantity = cell.MaxQuantity;
cellTree.ProductName = cell.Product == null ? string.Empty : cell.Product.ProductName;
cellTree.attributes = "cell";
wareSet.Add(cellTree);
}
return(wareSet);
}
/// <summary>
/// 仓库设置时用的TreeGrid的树形结构，可根据仓库Code查询
/// </summary>
/// <param name="wareCode">仓库Code</param>
/// <returns></returns>
public object GetSearch(string wareCode)
{
var warehouses = WarehouseRepository.GetQueryable().AsEnumerable();
if (wareCode != null && wareCode != string.Empty)
{
warehouses = warehouses.Where(w => w.WarehouseCode == wareCode);
}
HashSet <WareTree> wareSet = new HashSet <WareTree>();
foreach (var warehouse in warehouses)//仓库
{
WareTree wareTree = new WareTree();
wareTree.Code = warehouse.WarehouseCode;
wareTree.Name = "仓库：" + warehouse.WarehouseName;
wareTree.WarehouseCode = warehouse.WarehouseCode;
wareTree.WarehouseName = warehouse.WarehouseName;
wareTree.Type = warehouse.WarehouseType;
wareTree.Description = warehouse.Description;
wareTree.IsActive = warehouse.IsActive == "1" ? "可用" : "不可用";
wareTree.UpdateTime = warehouse.UpdateTime.ToString("yyyy-MM-dd hh:mm:ss");
wareTree.ShortName = warehouse.ShortName;
wareTree.attributes = "ware";
var areas = AreaRepository.GetQueryable().Where(a => a.Warehouse.WarehouseCode == warehouse.WarehouseCode)
.OrderBy(a => a.AreaCode).Select(a => a);
HashSet <WareTree> areaSet = new HashSet <WareTree>();
foreach (var area in areas)//库区
{
WareTree areaTree = new WareTree();
areaTree.Code = area.AreaCode;
areaTree.Name = "库区：" + area.AreaName;
areaTree.AreaCode = area.AreaCode;
areaTree.AreaName = area.AreaName;
areaTree.WarehouseCode = area.Warehouse.WarehouseCode;
areaTree.WarehouseName = area.Warehouse.WarehouseName;
areaTree.Type = area.AreaType;
areaTree.Description = area.Description;
areaTree.IsActive = area.IsActive == "1" ? "可用" : "不可用";
areaTree.UpdateTime = area.UpdateTime.ToString("yyyy-MM-dd hh:mm:ss");
areaTree.ShortName = area.ShortName;
areaTree.AllotInOrder = area.AllotInOrder;
areaTree.AllotOutOrder = area.AllotOutOrder;
areaTree.attributes = "area";
var shelfs = ShelfRepository.GetQueryable().Where(s => s.Area.AreaCode == area.AreaCode)
.OrderBy(s => s.ShelfCode).Select(s => s);
HashSet <WareTree> shelfSet = new HashSet <WareTree>();
foreach (var shelf in shelfs)//货架
{
WareTree shelfTree = new WareTree();
shelfTree.Code = shelf.ShelfCode;
shelfTree.Name = "货架：" + shelf.ShelfName;
shelfTree.ShelfCode = shelf.ShelfCode;
shelfTree.ShelfName = shelf.ShelfName;
shelfTree.WarehouseCode = shelf.Warehouse.WarehouseCode;
shelfTree.WarehouseName = shelf.Warehouse.WarehouseName;
shelfTree.AreaCode = shelf.Area.AreaCode;
shelfTree.AreaName = shelf.Area.AreaName;
shelfTree.Type = shelf.ShelfType;
shelfTree.Description = shelf.Description;
shelfTree.IsActive = shelf.IsActive == "1" ? "可用" : "不可用";
shelfTree.UpdateTime = shelf.UpdateTime.ToString("yyyy-MM-dd hh:mm:ss");
shelfTree.ShortName = shelf.ShortName;
shelfTree.attributes = "shelf";
shelfSet.Add(shelfTree);
}
areaTree.children = shelfSet.ToArray();
areaSet.Add(areaTree);
}
wareTree.children = areaSet.ToArray();
wareSet.Add(wareTree);
}
return(wareSet.ToArray());
}
