public async Task <IActionResult> PointsMap() { var username = _httpContextAccessor.HttpContext.User.FindFirst(ClaimTypes.Name).Value; ViewData["UserName"] = username; var city = "北京"; var specie = "侧柏"; var citySpecies = await GetSpeciesAsync(city);//传输单一城市的植物清单 IEnumerable <IGrouping <string, allpoint> > plantl = citySpecies.GroupBy(u => u.物名); List <SpieciesResult> species = new List <SpieciesResult>(); foreach (IGrouping <string, allpoint> item in plantl) { List <allpoint> plantlist = item.ToList(); SpieciesResult speciesname = new SpieciesResult(); speciesname.species = plantlist[0].物名; species.Add(speciesname); } ViewBag.citySpecies = Newtonsoft.Json.JsonConvert.SerializeObject(species); var onlyOnePlant = await GetDatasAsync(city, specie);//传输“单一城市单一植物”数据 List <plantResult> plantsData = new List <plantResult>(); foreach (var item in onlyOnePlant) { plantResult plant = new plantResult(); plant.datax1 = convertDate(item.叶芽开始膨大期); plant.datax2 = convertDate(item.叶芽开放期); plant.datax3 = convertDate(item.花芽开始膨大期); plant.datax4 = convertDate(item.花芽开放期); plant.datax5 = convertDate(item.开始展叶期); plant.datax6 = convertDate(item.展叶盛期); plant.datax7 = convertDate(item.花序或花蕾出现期); plant.datax8 = convertDate(item.开花始期); plant.datax9 = convertDate(item.开花盛期); plant.datax10 = convertDate(item.开花末期); plant.datax11 = convertDate(item.第二次开花期); plant.datax12 = convertDate(item.果实成熟期); plant.datax13 = convertDate(item.果实脱落开始期); plant.datax14 = convertDate(item.果实脱落末期); plant.datax15 = convertDate(item.叶开始变色期); plant.datax16 = convertDate(item.叶全部变色期); plant.datax17 = convertDate(item.开始落叶期); plant.datax18 = convertDate(item.落叶末期); plant.datay = item.年份 + '年'; plant.zhuji = item.注记; plantsData.Add(plant); } ViewBag.onlyPlant = Newtonsoft.Json.JsonConvert.SerializeObject(plantsData); return(View()); }
public async Task <IActionResult> stationsAnalysis(string species, string year) { var username = _httpContextAccessor.HttpContext.User.FindFirst(ClaimTypes.Name).Value; ViewData["UserName"] = username; var Stationslist = await GetStationLocation(species); ViewBag.stationsLocation = Newtonsoft.Json.JsonConvert.SerializeObject(Stationslist); List <allpoint> citySpecies = new List <allpoint>(); citySpecies = _context.allpoint.Where(a => a.物名 == species).ToList(); IEnumerable <IGrouping <string, allpoint> > plantl = citySpecies.GroupBy(u => u.年份); List <CityResult> yearl = new List <CityResult>(); foreach (IGrouping <string, allpoint> item in plantl) { List <allpoint> plantlist = item.ToList(); CityResult yearname = new CityResult(); yearname.city = plantlist[0].年份; yearl.Add(yearname); } var yearo = yearl.OrderByDescending(u => u.city); ViewBag.Species = species; ViewBag.yearSpecies = Newtonsoft.Json.JsonConvert.SerializeObject(yearo); ViewBag.year = year; var onlyOnePlant = await GetYearDistAsync(species, year); if (onlyOnePlant != null) { List <plantResult> plantsData = new List <plantResult>(); foreach (var item in onlyOnePlant) { plantResult plant = new plantResult(); plant.datax1 = convertDate(item.叶芽开始膨大期); plant.datax2 = convertDate(item.叶芽开放期); plant.datax3 = convertDate(item.花芽开始膨大期); plant.datax4 = convertDate(item.花芽开放期); plant.datax5 = convertDate(item.开始展叶期); plant.datax6 = convertDate(item.展叶盛期); plant.datax7 = convertDate(item.花序或花蕾出现期); plant.datax8 = convertDate(item.开花始期); plant.datax9 = convertDate(item.开花盛期); plant.datax10 = convertDate(item.开花末期); plant.datax11 = convertDate(item.第二次开花期); plant.datax12 = convertDate(item.果实成熟期); plant.datax13 = convertDate(item.果实脱落开始期); plant.datax14 = convertDate(item.果实脱落末期); plant.datax15 = convertDate(item.叶开始变色期); plant.datax16 = convertDate(item.叶全部变色期); plant.datax17 = convertDate(item.开始落叶期); plant.datax18 = convertDate(item.落叶末期); plant.datay = item.年份 + '年'; plant.species = species; plant.city = item.站点; plantsData.Add(plant); } ViewBag.onlyPlant = Newtonsoft.Json.JsonConvert.SerializeObject(plantsData); } return(View()); }