//改
public IList <t_EE_AlarmConfig> UpdataeAlarm(t_EE_AlarmConfig alarm)
{
IList <t_EE_AlarmConfig> data = new List <t_EE_AlarmConfig>();
try
{
data = _dbFactory.pueError.UpdataeAlarm(alarm);
}
catch (Exception ex)
{
throw ex;
}
return(data);
}
public IList <t_EE_AlarmConfig> GetPueAlarmAfter(t_EE_AlarmConfig alarm)
{
string sql = "";
if (alarm.TypeId != null)
{
sql = $"SELECT *,null TypeName FROM t_EE_AlarmConfig WHERE PID={alarm.PID} AND TypeId={alarm.TypeId}";
}
else if (alarm.TypeName != "")
{
sql = $"SELECT* FROM t_EE_AlarmConfig a INNER JOIN t_EE_AlarmType b" +
$" ON a.TypeId = b.TypeId" +
$" WHERE a.PID = {alarm.PID} AND b.TypeName = '{alarm.TypeName}'";
}
return(SQLQuery <t_EE_AlarmConfig>(sql));
}
//删
public IList <t_EE_AlarmConfig> DeleteAlarm(t_EE_AlarmConfig alarm)
{
string sql = $" DELETE FROM t_EE_AlarmConfig OUTPUT deleted.*,null TypeName WHERE PID = {alarm.PID} AND TypeId={alarm.TypeId}";
return(SQLQuery <t_EE_AlarmConfig>(sql));
}
//改
public IList <t_EE_AlarmConfig> UpdataeAlarm(t_EE_AlarmConfig alarm)
{
string sql = $" UPDATE t_EE_AlarmConfig SET TypeId = {alarm.TypeId},LimitH1={alarm.LimitH1},LimitH2={alarm.LimitH2},LimitH3={alarm.LimitH3},LimitL1={alarm.LimitL1},LimitL2={alarm.LimitL2}, LimitL3={alarm.LimitL3} OUTPUT Inserted.*,null TypeName WHERE PID = {alarm.PID} AND TypeId={alarm.TypeId}";
return(SQLQuery <t_EE_AlarmConfig>(sql));
}
//增
public IList <t_EE_AlarmConfig> AppendAlarm(t_EE_AlarmConfig alarm)
{
string sql = $"INSERT INTO t_EE_AlarmConfig(UID,PID,TypeId,LimitH1,LimitH2,LimitH3,LimitL1,LimitL2,LimitL3) output inserted.*,null TypeName VALUES({alarm.UID},{alarm.PID},{alarm.TypeId},{alarm.LimitH1},{alarm.LimitH2},{alarm.LimitH3},{alarm.LimitL1},{alarm.LimitL2},{alarm.LimitL3}) ";
return(SQLQuery <t_EE_AlarmConfig>(sql));
}
