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();
}
