public static string Update(SensorTagModel s) { try { using (tsmc14BDataContext db = new tsmc14BDataContext()) { var r = (from row in db.plc_info where row.plc_id == s.plc_id select row).SingleOrDefault(); if (r != null) { r.LinkProcessData = s.LinkProcessData; r.SensorTag = s.sensorTag; r.ChamberTag = s.chamberTag; //if (!r.Any()) //{ // db.SenSorTag_info.InsertOnSubmit(tmp); //} db.SubmitChanges(); } } } catch (Exception ex) { return(ex.Message); } return(null); }
public static SensorTagModel GetSensorTag(String SensorId) { SensorTagModel tmp = new SensorTagModel(); using (tsmc14BDataContext db = new tsmc14BDataContext()) { var r = (from row in db.vw_SensorTag_info where row.Sensor == SensorId select row).FirstOrDefault(); tmp.plc_id = r.plc_id; tmp.chamber = r.chamber; tmp.chamberTag = r.chamberTag; tmp.PeriodicReportInterval = r.PeriodicReportInterval; tmp.LinkProcessData = r.LinkProcessData; tmp.Sensor = r.Sensor; tmp.sensorTag = r.sensorTag; tmp.Tool = r.Tool; tmp.ToolType = r.ToolType; } return(tmp); }