public LoraData GetLoraData() { LoraPlatformEntities db = new LoraPlatformEntities(); LoraData data = new LoraData(); if (ConnectCheck()) { string DataString = serialPort1.ReadLine(); if (DataString == "NO_GPS\r") { data = null; } else { List <string> DataList = DataString.Split(',').ToList(); Device device = db.Device.Find(Convert.ToInt32(DataList[3])); data.DeviceId = device.DeviceId; data.Latitude = DataList[0]; data.Longitude = DataList[1]; data.Time = DateTime.Now; } db.Dispose(); } return(data); }
public void SaveLoraData() { LoraPlatformEntities db = new LoraPlatformEntities(); if (ConnectCheck()) { string DataString = serialPort1.ReadLine(); if (DataString != "NO_GPS\r") { LoraData data = new LoraData(); List <string> DataList = DataString.Split(',').ToList(); Device device = db.Device.Find(Convert.ToInt32(DataList[3])); device.ConnectState = "已連接"; device.ConnectTime = DateTime.Now; data.DeviceId = device.DeviceId; data.Latitude = DataList[0]; data.Longitude = DataList[1]; data.Time = DateTime.Now; db.LoraData.Add(data); db.SaveChanges(); db.Dispose(); } } }
public ActionResult GetData() { LoraData data = loraService.GetLoraData(); return(Json(data, JsonRequestBehavior.AllowGet)); }