public bool SendParameter(int shipId, string str) { string[] strs = str.Split('|'); foreach (var item in strs) { waterdataEntities entity = new waterdataEntities(); task lasttask = entity.task.Where(s => s.ship_id == shipId && s.route_id != null).OrderByDescending(s => s.create_time).First(); ship ship = entity.ship.SingleOrDefault(s => s.ship_id == shipId); WaterData waterdata = DataParse.dealSensorData(item); parameter parameter = entity.parameter.SingleOrDefault(s => s.parameter_name == waterdata.ParameterName && s.company_id == ship.company_id); waterdata.ParameterId = parameter.parameter_id.ToString(); waterdata.TaskId = lasttask.task_id.ToString(); water_data newdata = new water_data() { task_id = Convert.ToInt32(waterdata.TaskId), parameter_id = Convert.ToInt32(waterdata.ParameterId), parameter_value = Convert.ToDouble(waterdata.ParameterValue), longitude = Convert.ToDouble(waterdata.Longitude), latitude = Convert.ToDouble(waterdata.Latitude), create_time = DateTime.Now }; entity.water_data.Add(newdata); entity.SaveChanges(); } return(true); }
public bool DeleteData(int waterdataId) { waterdataEntities entity = new waterdataEntities(); bool result = false; water_data waterdata = entity.water_data.SingleOrDefault(s => s.watedata_id == waterdataId); if (waterdata != null) { entity.water_data.Remove(waterdata); entity.SaveChanges(); result = true; } return(result); }