//获得城市下拉选项直到车间
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 <WorkshopDto> 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 = _workshopRepository.GetAll().Where(d => d.IsDeleted == false).Where(w => w.Factory.City.CityName == CityName)
.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 async Task <IEnumerable <WorkshopShortViewModel> > GetAll()
{
using (var scope = _dbContextScope.CreateReadOnly())
{
var workshopsData = await _workshopRepo.GetAll();
return(Mapper.Map <IEnumerable <WorkshopShortViewModel> >(workshopsData));
}
}
public PagedResultDto <GatewayDto> GetByWorkshop(string WorkshopName)
{
var workQuery = _workshopRepository.GetAll().Where(w => w.WorkshopName == WorkshopName).Where(g => g.IsDeleted == false);
if (!workQuery.Any())
{
throw new ApplicationException("workshop不存在或已被删除");
}
var query = _gatewayRepository.GetAll().Where(d => d.IsDeleted == false).Where(g => g.Workshop.WorkshopName == WorkshopName)
.Include(g => g.Workshop)
.Include(g => g.Workshop.Factory)
.Include(g => g.Workshop.Factory.City)
.Include(g => g.GatewayType);
var total = query.Count();
var result = query.ToList();
return(new PagedResultDto <GatewayDto>(total, ObjectMapper.Map <List <GatewayDto> >(result)));
}
public IQueryable <Workshop> GetAll()
{
return(_workshopRepositories.GetAll());
}