//获得城市下拉选项直到车间
public List <object> GetCityCascaderOptionsTilWorkshop()
{
var cityQuery = _cityRepository.GetAll().Where(c => c.IsDeleted == false);
List <City> cities1 = cityQuery.ToList();
List <CityDto> cities = ObjectMapper.Map <List <CityDto> >(cities1);
List <object> result = new List <object>();
result.Add(new { value = "全部", label = "全部" });
foreach (CityDto c in cities)
{
List <object> children = new List <object>();
var factoryQuery = _factoryRepository.GetAll().Where(f => f.IsDeleted == false).Where(f => f.City.CityName == c.CityName);
List <Factory> factories1 = factoryQuery.ToList();
List <FactoryDto> factories = ObjectMapper.Map <List <FactoryDto> >(factories1);
children.Add(new { value = "全部", label = "全部" });
foreach (FactoryDto f in factories)
{
List <object> subchildren = new List <object>();
var workshopQuery = _workshopRepository.GetAll().Where(w => w.IsDeleted == false).Where(w => w.Factory.FactoryName == f.FactoryName);
List <Workshop> workshops1 = workshopQuery.ToList();
List <WorkshopDto> workshops = ObjectMapper.Map <List <WorkshopDto> >(workshops1);
subchildren.Add(new { value = "全部", label = "全部" });
foreach (WorkshopDto w in workshops)
{
subchildren.Add(new { value = w.WorkshopName, label = w.WorkshopName });
}
children.Add(new { value = f.FactoryName, label = f.FactoryName, Workshop = subchildren });
}
result.Add(new { value = c.CityName, label = c.CityName, Factory = children });
}
return(result);
}
public PagedResultDto <FactoryDto> GetByCity(string CityName)
{
var cityQuery = _cityRepository.GetAll().Where(c => c.CityName == CityName).Where(g => g.IsDeleted == false);
if (!cityQuery.Any())
{
throw new ApplicationException("城市不存在或已被删除");
}
var query = _factoryRepository.GetAll().Where(d => d.IsDeleted == false).Where(f => f.City.CityName == CityName)
.Include(f => f.City);
var total = query.Count();
var result = query.ToList();
return(new PagedResultDto <FactoryDto>(total, ObjectMapper.Map <List <FactoryDto> >(result)));
}
public PagedResultDto <WorkshopDto> GetByFactory(string FactoryName)
{
var factoryQuery = _factoryRepository.GetAll().Where(f => f.FactoryName == FactoryName).Where(g => g.IsDeleted == false);
if (!factoryQuery.Any())
{
throw new ApplicationException("factory不存在或已被删除");
}
var query = _workshopRepository.GetAll().Where(d => d.IsDeleted == false).Where(w => w.Factory.FactoryName == FactoryName)
.Include(w => w.Factory)
.Include(w => w.Factory.City);
var total = query.Count();
var result = query.ToList();
return(new PagedResultDto <WorkshopDto>(total, ObjectMapper.Map <List <WorkshopDto> >(result)));
}
public IQueryable <Factory> GetAll()
{
return(_factoryRepositories.GetAll());
}
public async Task <IEnumerable <Tank> > GetAll()
{
return(await _tankRepository.GetAll());
}
public async Task <IEnumerable <Factory> > GetAll()
{
return(await _factoryRepository.GetAll());
}
public async Task <IEnumerable <Unit> > GetAll()
{
return(await _unitRepository.GetAll());
}
