/// <summary> /// 根据仓库编码获取生成的库区编码 /// </summary> /// <param name="wareCode">仓库编码</param> /// <returns></returns> public object GetAreaCode(string wareCode) { string areaCodeStr = ""; IQueryable <CMD_AREA> areaQuery = CMDAreaRepository.GetQueryable(); var areaCode = areaQuery.Where(a => a.WAREHOUSE_CODE == wareCode).Max(a => a.AREA_CODE); if (areaCode == string.Empty || areaCode == null) { areaCodeStr = wareCode + "-01"; } else { int i = Convert.ToInt32(areaCode.ToString().Substring(wareCode.Length, 2)); i++; string newcode = i.ToString(); if (newcode.Length <= 2) { for (int j = 0; j < 2 - i.ToString().Length; j++) { newcode = "0" + newcode; } areaCodeStr = wareCode + "-" + newcode; } } return(areaCodeStr); }
public object GetWareArea() { var warehouses = CMDWarehouseRepository.GetQueryable().AsEnumerable(); HashSet <Tree> wareSet = new HashSet <Tree>(); foreach (var warehouse in warehouses)//仓库 { Tree wareTree = new Tree(); wareTree.id = warehouse.WAREHOUSE_CODE; wareTree.text = "仓库:" + warehouse.WAREHOUSE_CODE; wareTree.state = "open"; wareTree.attributes = "ware"; var areas = CMDAreaRepository.GetQueryable().Where(a => a.CMD_WAREHOUSE.WAREHOUSE_CODE == warehouse.WAREHOUSE_CODE) .OrderBy(a => a.AREA_CODE).Select(a => a); HashSet <Tree> areaSet = new HashSet <Tree>(); foreach (var area in areas)//库区 { Tree areaTree = new Tree(); areaTree.id = area.AREA_CODE; areaTree.text = "库区:" + area.AREA_NAME; areaTree.state = "open"; areaTree.attributes = "area"; areaSet.Add(areaTree); } wareTree.children = areaSet.ToArray(); wareSet.Add(wareTree); } return(wareSet.ToArray()); }
/// <summary> /// 查询参数Code查询库区信息 /// </summary> /// <param name="areaCode">库区Code</param> /// <returns></returns> public object FindArea(string areaCode) { IQueryable <CMD_AREA> areaQuery = CMDAreaRepository.GetQueryable(); var area = areaQuery.Where(a => a.AREA_CODE == areaCode).OrderBy(b => b.AREA_CODE).AsEnumerable().Select(b => new { b.AREA_CODE, b.AREA_NAME, b.WAREHOUSE_CODE, b.MEMO }); return(area.First(a => a.AREA_CODE == areaCode)); }
public bool Save(CMD_AREA area) { var areaSave = CMDAreaRepository.GetQueryable().FirstOrDefault(a => a.AREA_CODE == area.AREA_CODE); var warehouse = CMDWarehouseRepository.GetQueryable().FirstOrDefault(w => w.WAREHOUSE_CODE == area.WAREHOUSE_CODE); areaSave.AREA_CODE = area.AREA_CODE; areaSave.AREA_NAME = area.AREA_NAME; areaSave.WAREHOUSE_CODE = area.WAREHOUSE_CODE; areaSave.MEMO = area.MEMO; CMDAreaRepository.SaveChanges(); return(true); }
public new bool Add(CMD_AREA area) { var areaAdd = new CMD_AREA(); var warehouse = CMDWarehouseRepository.GetQueryable().FirstOrDefault(w => w.WAREHOUSE_CODE == area.WAREHOUSE_CODE); areaAdd.AREA_CODE = area.AREA_CODE; areaAdd.AREA_NAME = area.AREA_NAME; areaAdd.WAREHOUSE_CODE = area.WAREHOUSE_CODE; areaAdd.MEMO = area.MEMO; CMDAreaRepository.Add(areaAdd); CMDAreaRepository.SaveChanges(); return(true); }
public object GetDetails(string warehouseCode, string areaCode) { IQueryable <CMD_AREA> areaQuery = CMDAreaRepository.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 (warehouseCode != null && warehouseCode != string.Empty) { area = area.Where(a => a.WAREHOUSE_CODE == warehouseCode).OrderBy(a => a.AREA_CODE).Select(a => a); } if (areaCode != null && areaCode != string.Empty) { area = area.Where(a => a.AREA_CODE == areaCode).OrderBy(a => a.AREA_CODE).Select(a => a); } return(area.ToArray()); }
public bool Delete(string areaCode) { var area = CMDAreaRepository.GetQueryable() .FirstOrDefault(a => a.AREA_CODE == areaCode); if (area != null) { CMDAreaRepository.Delete(area); CMDAreaRepository.SaveChanges(); } else { return(false); } return(true); }
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() }); }