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() }); }