public Iot_MeterAlarmPara GetMeterAlarmPara(string meterNo)
{
string configName = System.Configuration.ConfigurationManager.AppSettings["defaultDatabase"];
//Linq to SQL 上下文对象
DataContext dd = new DataContext(System.Configuration.ConfigurationManager.ConnectionStrings[configName].ConnectionString);
try
{
Iot_MeterAlarmPara map = dd.GetTable <Iot_MeterAlarmPara>().Where(p => p.MeterNo == meterNo).SingleOrDefault();
return(map);
}
catch
{
return(null);
}
}
public void UpdateMeterAlarmPar(string meterNo, IoT_SetAlarm para)
{
string configName = System.Configuration.ConfigurationManager.AppSettings["defaultDatabase"];
//Linq to SQL 上下文对象
DataContext dd = new DataContext(System.Configuration.ConfigurationManager.ConnectionStrings[configName].ConnectionString);
try
{
Iot_MeterAlarmPara map = dd.GetTable <Iot_MeterAlarmPara>().Where(p => p.MeterNo == meterNo).SingleOrDefault();
if (map == null)
{
map = new Iot_MeterAlarmPara();
map.MeterNo = meterNo;
map.Par1 = para.Par1;
map.Par2 = para.Par2;
map.Par3 = para.Par3;
map.Par4 = para.Par4;
map.Par5 = para.Par5;
map.Par6 = para.Par6;
map.Par7 = para.Par7;
map.Par8 = para.Par8;
map.Par9 = para.Par9;
map.SwitchTag = para.SwitchTag;
Table <Iot_MeterAlarmPara> tbl = dd.GetTable <Iot_MeterAlarmPara>();
tbl.InsertOnSubmit(map);
dd.SubmitChanges();
}
else
{
map.Par1 = para.Par1;
map.Par2 = para.Par2;
map.Par3 = para.Par3;
map.Par4 = para.Par4;
map.Par5 = para.Par5;
map.Par6 = para.Par6;
map.Par7 = para.Par7;
map.Par8 = para.Par8;
map.Par9 = para.Par9;
map.SwitchTag = para.SwitchTag;
dd.SubmitChanges();
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
}
