public string Get() { Users users1 = new Users(); List <highchartsmodel> highchartsmodels = new List <highchartsmodel>(); highchartsmodel highchartsmodel = new highchartsmodel(); List <Users> users = SQLcmd.SQLcmdData(); //foreach (var item in users) //{ // highchartsmodel highchartsmodel1 = new highchartsmodel() // { // data = new List<int>() // }; // highchartsmodel1.name = item.Name.ToString(); // highchartsmodel1.data.Add(item.January); // highchartsmodel1.data.Add(item.February); // highchartsmodel1.data.Add(item.March); // highchartsmodels.Add(highchartsmodel1); //} String hingeString = Newtonsoft.Json.JsonConvert.SerializeObject(users); return(hingeString); }
/// <summary> /// 根据国家ID查询数据 /// </summary> /// <param name="id">国家ID</param> /// <returns>国家所有月份的值</returns> public string GetMonthDatagetByCountryId(int id) { Users users1 = new Users(); List <highchartsmodel> highchartsmodels = new List <highchartsmodel>(); highchartsmodel highchartsmodel = new highchartsmodel(); List <Users> users = SQLcmd.SQLcmdData(id); String hingeString = Newtonsoft.Json.JsonConvert.SerializeObject(users); return(hingeString); }
public string GetSearchHighcharts(string name) { Users users1 = new Users(); List <highchartsmodel> highchartsmodels = new List <highchartsmodel>(); List <Users> users = SQLcmd.SQLcmdSearch(name); foreach (var item in users) { highchartsmodel highchartsmodel1 = new highchartsmodel() { data = new List <int>() }; highchartsmodel1.name = item.Name.ToString(); highchartsmodel1.data.Add(item.January); highchartsmodel1.data.Add(item.February); highchartsmodel1.data.Add(item.March); highchartsmodels.Add(highchartsmodel1); } String hingeString = Newtonsoft.Json.JsonConvert.SerializeObject(highchartsmodels); return(hingeString); }