public string D3Json() { if (mongoDbRemoteRepository != null) { mongoDbRemoteRepository.Connect(); var opcModels = mongoDbRemoteRepository.List(i => i.TagNo == "1TIC516JRQ-5A").OrderBy(i => i.Time).ToList(); if (opcModels.Count > 0) { string time = opcModels.ElementAt(0).Id.Created.ToString("yyyy-MM-dd hh:mm:ss"); string times = opcModels.ElementAt(0).Time; } string sd = "["; int k = 1; foreach (var modle in opcModels) { sd = sd + "{" + "\"Time\":" + k + "," + "\"Value\"" + ":" + modle.Value + "},"; k++; } sd = sd.Substring(0, sd.Length - 1) + "]"; string content = JsonConvert.SerializeObject(opcModels); mongoDbRemoteRepository.CloseConnect(); return(sd); } List <D3JsonC> list = new List <D3JsonC>(); for (int i = 0; i < 3; i++) { D3JsonC json = new D3JsonC(); json.date = i + 1; json.close = 20 + i; list.Add(json); } StringBuilder builder = new StringBuilder(); builder.Append(@"[{" + "\"date\"" + ":" + "\"1\"" + "," + "\"close\"" + ":" + "\"582.13\"" + "},"); builder.Append(@"{" + "\"date\"" + ":" + "\"2\"" + "," + "\"close\"" + ":" + "\"583.98\"" + "},"); builder.Append(@"{" + "\"date\"" + ":" + "\"3\"" + "," + "\"close\"" + ":" + "\"603\"" + "}]"); var s = Json(list, JsonRequestBehavior.AllowGet); //return Line(); return(Dc()); }
public string D3Json() { if (mongoDbRemoteRepository != null) { mongoDbRemoteRepository.Connect(); var opcModels = mongoDbRemoteRepository.List(i => i.TagNo == "1TIC516JRQ-5A").OrderBy(i=>i.Time).ToList(); if(opcModels.Count>0) { string time = opcModels.ElementAt(0).Id.Created.ToString("yyyy-MM-dd hh:mm:ss"); string times = opcModels.ElementAt(0).Time; } string sd = "["; int k=1; foreach(var modle in opcModels) { sd = sd + "{" +"\"Time\":"+ k + "," + "\"Value\"" + ":" + modle.Value + "},"; k++; } sd = sd.Substring(0, sd.Length - 1) + "]"; string content = JsonConvert.SerializeObject(opcModels); mongoDbRemoteRepository.CloseConnect(); return sd; } List<D3JsonC> list = new List<D3JsonC>(); for(int i=0;i<3;i++) { D3JsonC json = new D3JsonC(); json.date = i + 1; json.close = 20 + i; list.Add(json); } StringBuilder builder = new StringBuilder(); builder.Append(@"[{" + "\"date\"" + ":" + "\"1\"" + "," + "\"close\"" + ":" + "\"582.13\"" + "},"); builder.Append(@"{" + "\"date\"" + ":" + "\"2\"" + "," + "\"close\"" + ":" + "\"583.98\"" + "},"); builder.Append(@"{" + "\"date\"" + ":" + "\"3\"" + "," + "\"close\"" + ":" + "\"603\"" + "}]"); var s = Json(list,JsonRequestBehavior.AllowGet); //return Line(); return Dc(); }