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