public JsonResult GetStaffs(int page, int rows, string birthBegin, string birthEnd)
{
MongoDbRemoteRepository<Staff> repository = new MongoDbRemoteRepository<Staff>();
repository.Connect();
List<Staff> list = repository.List(i => i.GRADUATION_SCHOOL=="四川大学");
repository.CloseConnect();
var json2 = new
{
total = list.Count,
rows = list.ToArray(),
};
return Json(json2, JsonRequestBehavior.AllowGet);
}
public JsonResult GetStaffs(int page, int rows, string birthBegin, string birthEnd)
{
MongoDbRemoteRepository <Staff> repository = new MongoDbRemoteRepository <Staff>();
repository.Connect();
List <Staff> list = repository.List(i => i.GRADUATION_SCHOOL == "四川大学");
repository.CloseConnect();
var json2 = new
{
total = list.Count,
rows = list.ToArray(),
};
return(Json(json2, JsonRequestBehavior.AllowGet));
}
public string TagData(string tagNo)
{
this.mongoDbRemoteRepository = new MongoDbRemoteRepository<OpcModel>();
mongoDbRemoteRepository.Connect();
var opcModels = mongoDbRemoteRepository.List(i => i.TagNo == tagNo).OrderBy(i => i.Time).ToList();
string sd = "[";
int k = 1;
foreach (var modle in opcModels)
{
sd = sd + "{" + "\"Time\":\"" + modle.Id.Created.ToString("yyyy-MM-dd hh:mm:ss") + "\"," + "\"Value\"" + ":" + modle.Value + "},";
k++;
if(k>=100)
{
break;
}
}
sd = sd.Substring(0, sd.Length - 1) + "]";
string content = JsonConvert.SerializeObject(opcModels);
mongoDbRemoteRepository.CloseConnect();
return sd;
}
public string TagData(string tagNo)
{
this.mongoDbRemoteRepository = new MongoDbRemoteRepository <OpcModel>();
mongoDbRemoteRepository.Connect();
var opcModels = mongoDbRemoteRepository.List(i => i.TagNo == tagNo).OrderBy(i => i.Time).ToList();
string sd = "[";
int k = 1;
foreach (var modle in opcModels)
{
sd = sd + "{" + "\"Time\":\"" + modle.Id.Created.ToString("yyyy-MM-dd hh:mm:ss") + "\"," + "\"Value\"" + ":" + modle.Value + "},";
k++;
if (k >= 100)
{
break;
}
}
sd = sd.Substring(0, sd.Length - 1) + "]";
string content = JsonConvert.SerializeObject(opcModels);
mongoDbRemoteRepository.CloseConnect();
return(sd);
}
public FirstReportController(MongoDbRemoteRepository<OpcModel> remote)
{
this.mongoDbRemoteRepository = remote;
}
public FirstReportController(MongoDbRemoteRepository <OpcModel> remote)
{
this.mongoDbRemoteRepository = remote;
}
