//获取竖井最高温度 // public string GetMaxTempByDID() { StringBuilder sbtitle = new StringBuilder(); sbtitle.Append("<div class=\"station_room_monitor_top\">"); string strsql = "select top 1 AlarmAddress,AlarmArea,AlarmValue,ALarmType,AlarmState from t_AlarmTable_en where AlarmState>0 and (did >= 422 and did <= 437 or did = 397) order by AlarmState desc,AlarmValue desc"; //判断是否存在报警数据 List <AlarmInfo> alist = bll.ExecuteStoreQuery <AlarmInfo>(strsql).ToList(); if (alist.Count > 0) { AlarmInfo alarm = alist.First(); sbtitle.Append("<h2>" + alarm.ALarmType + "</h2>"); sbtitle.Append("<span>设备运行状况</span></div>"); sbtitle.Append("<div class=\"station_room_monitor_hr state_bg_" + alarm.AlarmState + "\"></div>"); sbtitle.Append("<div class=\"station_room_monitor_content\"><strong>HT:<h1 class=\"state_fc_" + alarm.AlarmState + "\">" + alarm.AlarmValue + "℃</h1><br />" + alarm.AlarmArea + "<br />" + alarm.AlarmAddress + "</strong>"); } else { //获取配电房最高温度 strsql = "select top 1 Position AlarmAddress,DeviceName AlarmArea,PV AlarmValue,'正常' ALarmType,0 AlarmState from V_DeviceInfoState_PDR1 where (did >= 422 and did <= 437 or did = 397) and DataTypeID=1 order by PV desc,TagID"; alist = bll.ExecuteStoreQuery <AlarmInfo>(strsql).ToList(); if (alist.Count > 0) { AlarmInfo alarm = alist.First(); sbtitle.Append("<h2>正常</h2>"); sbtitle.Append(" <span>设备运行状况</span></div>"); sbtitle.Append("<div class=\"station_room_monitor_hr\"></div>"); sbtitle.Append("<div class=\"station_room_monitor_content\"><strong>HT:<h1 class=\"state_fc_0\">" + alarm.AlarmValue + "℃</h1><br />" + alarm.AlarmArea + "<br />" + alarm.AlarmAddress + "</strong>"); } else { sbtitle.Append("<h2>正常</h2>"); sbtitle.Append(" <span>设备运行状况</span></div>"); sbtitle.Append("<div class=\"station_room_monitor_hr\"></div>"); sbtitle.Append("<div class=\"station_room_monitor_content\"><strong>HT:<h1 class=\"state_fc_0\"> N/A</h1><br /></strong>"); } } //获取室内环境温度 strsql = "select top 1 Position AlarmAddress,DeviceName AlarmArea,PV AlarmValue,'正常' ALarmType,0 AlarmState from V_DeviceInfoState_PDR1 where (did >= 422 and did <= 437 or did = 397) and DataTypeID=12 order by PV desc,TagID"; alist = bll.ExecuteStoreQuery <AlarmInfo>(strsql).ToList(); if (alist.Count > 0) { AlarmInfo alarm = alist.First(); sbtitle.Append("<span>负荷:N/A</span> <span>环境温度:" + alarm.AlarmValue + "℃</span></div>"); } else { sbtitle.Append("<span>负荷:N/A</span> <span>环境温度:N/A</span></div>"); } sbtitle.Append("</div></div>"); return(sbtitle.ToString()); }
public RoomInfo(AlarmInfo alarm, TempInfo tempInfo) { // TODO: Complete member initialization this.alarm = alarm; this.tempInfo = tempInfo; }