public object GetDetail(string type, string id)
{
IQueryable <CMD_AREA> areaQuery = CMDAreaRepository.GetQueryable();
IQueryable <CMD_SHELF> shelfQuery = CMDShelfRepository.GetQueryable();
IQueryable <CMD_CELL> cellQuery = CMDCellRepository.GetQueryable();
var area = areaQuery.OrderBy(b => b.AREA_CODE).AsEnumerable().Select(b => new { b.AREA_CODE, b.AREA_NAME, b.WAREHOUSE_CODE, b.MEMO });
if (type == "shelf")
{
var areaCode = shelfQuery.Where(s => s.SHELF_CODE == id).Select(s => new{ s.AREA_CODE }).ToArray();
area = area.Where(a => a.AREA_CODE == areaCode[0].AREA_CODE);
}
else if (type == "cell")
{
var areaCode = cellQuery.Where(c => c.CELL_CODE == id).Select(c => new { c.AREA_CODE }).ToArray();
area = area.Where(a => a.AREA_CODE == areaCode[0].AREA_CODE);
}
else if (type == "area")
{
area = area.Where(a => a.AREA_CODE == id);
}
return(area.ToArray());
}
public object GetDetail(int page, int rows, string type, string id)
{
IQueryable <CMD_WAREHOUSE> wareQuery = CMDWarehouseRepository.GetQueryable();
IQueryable <CMD_SHELF> shelfQuery = CMDShelfRepository.GetQueryable();
IQueryable <CMD_AREA> areaQuery = CMDAreaRepository.GetQueryable();
IQueryable <CMD_CELL> cellQuery = CMDCellRepository.GetQueryable();
var warehouse = wareQuery.OrderBy(b => b.WAREHOUSE_CODE).AsEnumerable().Select(b => new { b.WAREHOUSE_CODE });
if (type == "ware")
{
warehouse = warehouse.Where(w => w.WAREHOUSE_CODE == id);
}
else if (type == "area")
{
var WarehouseCode = areaQuery.Where(a => a.AREA_CODE == id).Select(a => new { a.WAREHOUSE_CODE }).ToArray();
warehouse = warehouse.Where(w => w.WAREHOUSE_CODE == WarehouseCode[0].WAREHOUSE_CODE);
}
else if (type == "shelf")
{
var WarehouseCode = shelfQuery.Where(s => s.SHELF_CODE == id).Select(s => new { s.WAREHOUSE_CODE }).ToArray();
warehouse = warehouse.Where(w => w.WAREHOUSE_CODE == WarehouseCode[0].WAREHOUSE_CODE);
}
else if (type == "cell")
{
var WarehouseCode = cellQuery.Where(c => c.CELL_CODE == id).Select(c => new { c.WAREHOUSE_CODE }).ToArray();
warehouse = warehouse.Where(w => w.WAREHOUSE_CODE == WarehouseCode[0].WAREHOUSE_CODE);
}
else
{
warehouse = warehouse.Select(w => w);
}
int total = warehouse.Count();
warehouse = warehouse.Skip((page - 1) * rows).Take(rows);
return(new { total, rows = warehouse.ToArray() });
}
