public DeviceANDItemRefOR(DeviceOREx obj) { DeviceID = obj.DeviceID; Performance = obj.Performance; PerformanceVal = obj.PerformanceVal; LastPollingTime = obj.LastPollingTime.ToString("yyyy-MM-dd HH:mm:ss"); NextPollingTime = obj.NextPollingTime.ToString("yyyy-MM-dd HH:mm:ss"); Status = obj.State; StatusVal = obj.StatusVal; HealthStatus = obj.HealthStatus; HealthStatusVal = obj.HealthStatusVal; }
public DeviceOREx SelectDeviceORExByID(string m_id) { string sql = string.Format(@"select dt.TypeName,sty.name ClassName,WarningStatus.MonitorValue WarningStatus, State.MonitorValue State,HealthStatus.MonitorValue HealthStatus,dev.*, case(dev.Performance) when '故障' then 0 when '报警' then 2 when '未启动' then 3 else 0 end perf from t_Device dev left join t_DeviceType dt on dev.DeviceTypeID = dt.DeviceTypeID left join t_ServersType sty on sty.typeid= dt.typeid and sty.ServerID= dt.ServerID left join t_TmpValue WarningStatus on WarningStatus.DeviceID= dev.DeviceID and WarningStatus.ChannelNO=11101 left join t_TmpValue HealthStatus on HealthStatus.DeviceID= dev.DeviceID and HealthStatus.ChannelNO=11102 left join t_TmpValue State on State.DeviceID= dev.DeviceID and State.ChannelNO=11103 where dev.Deviceid='{0}'", m_id); DataTable dt = null; try { dt = db.ExecuteQueryDataSet(sql).Tables[0]; } catch (Exception ex) { throw ex; } if (dt == null) return null; if (dt.Rows.Count == 0) return null; DataRow dr = dt.Rows[0]; DeviceOREx m_obj = new DeviceOREx(dr); return m_obj; }