public ActionResult CenterSettingSetTimeSelect(TBL_SITE siteinfo) { try { if (siteinfo.siteId != 0) { TBL_CTRCONTROL[] allInfo = SelectTools.SelectCtrcontrolInfo(u => u.siteId == u.siteId, u => u.siteId); TBL_CTRCONTROL[] info = SelectTools.SelectCtrcontrolInfo(u => u.siteId == siteinfo.siteId, u => u.siteId); TBL_SITE[] site = SelectTools.SelectSiteInfo(u => u.siteId == u.siteId, u => u.siteId); if (info == null || info.Length == 0) { return(Content("没有此展示!")); } if (Request.Cookies["userId"] != null) { string user = Request.Cookies["userId"].Value;//输出全部的值 ViewBag.user = user; } ViewBag.sitearray = site; ViewBag.allInfo = allInfo; ViewBag.info = info; return(View()); } else { TBL_SITE[] search = SelectTools.SelectSiteInfo(u => u.siteName == siteinfo.siteName, u => u.siteId); int id = search[0].siteId; TBL_CTRCONTROL[] allInfo = SelectTools.SelectCtrcontrolInfo(u => u.siteId == u.siteId, u => u.siteId); TBL_CTRCONTROL[] info = SelectTools.SelectCtrcontrolInfo(u => u.siteId == id, u => u.siteId); TBL_SITE[] site = SelectTools.SelectSiteInfo(u => u.siteId == u.siteId, u => u.siteId); if (info == null || info.Length == 0) { return(Content("没有此展示!")); } if (Request.Cookies["userId"] != null) { string user = Request.Cookies["userId"].Value;//输出全部的值 ViewBag.user = user; } ViewBag.sitearray = site; ViewBag.allInfo = allInfo; ViewBag.info = info; return(View()); } } catch { return(Content("查询失败!(ERROR)")); } }
//集中设置-定时设置 public ActionResult CenterSettingSetTime() { TBL_SITE[] sitearray = SelectTools.SelectSiteInfo(u => u.siteId == u.siteId, u => u.siteId); TBL_CTRCONTROL[] ctrarray = SelectTools.SelectCtrcontrolInfo(u => u.siteId == u.siteId, u => u.siteId); if (Request.Cookies["userId"] != null) { string user = Request.Cookies["userId"].Value;//输出全部的值 ViewBag.user = user; } ViewBag.sitearray = sitearray; ViewBag.ctrarray = ctrarray; ViewBag.allInfo = ctrarray; return(View()); }
//集中设置-时钟设置 public ActionResult CenterSettingTime() { TBL_SITE[] sitearray = SelectTools.SelectSiteInfo(u => u.siteId == u.siteId, u => u.siteId); TBL_CTRCONTROL[] ctrarray = SelectTools.SelectCtrcontrolInfo(u => u.siteId == u.siteId, u => u.siteId); ViewBag.sitearray = sitearray; ViewBag.ctrarray = ctrarray; HttpCookie cookie = Request.Cookies["userId"]; if (cookie.Name != null) { ViewBag.user = cookie.Value; } return(View()); }
//集中设置-光控设置 public ActionResult CenterSettingLight() { TBL_SITE[] sitearray = SelectTools.SelectSiteInfo(u => u.siteId == u.siteId, u => u.siteId); TBL_CTRCONTROL[] ctrarray = SelectTools.SelectCtrcontrolInfo(u => u.siteId == u.siteId, u => u.siteId); TBL_CTRCONTROL[] allInfo = GetPagedList(1, 30, u => u.siteId == u.siteId, u => u.siteId); if (Request.Cookies["userId"] != null) { string user = Request.Cookies["userId"].Value;//输出全部的值 ViewBag.user = user; } ViewBag.allInfo = allInfo; ViewBag.info = ctrarray[0]; ViewBag.sitearray = sitearray; ViewBag.ctrarray = ctrarray; HttpCookie cookie = Request.Cookies["userId"]; if (cookie.Name != null) { ViewBag.user = cookie.Value; } return(View()); }
public void CenterSettingTimeUpdate() { try { HttpCookie cookie = Request.Cookies["userId"]; if (cookie.Name != null) { ViewBag.user = cookie.Value; } TBL_CTRCONTROL[] ctrarray = SelectTools.SelectCtrcontrolInfo(u => u.siteId == u.siteId, u => u.siteId); foreach (var info in ctrarray) { DateTime td = DateTime.Now; info.ctrcontrolSystime = td; if (td.DayOfWeek.ToString() == "Monday") { info.ctrcontrolSysweek = 1; } else if (td.DayOfWeek.ToString() == "Tuesday") { info.ctrcontrolSysweek = 2; } else if (td.DayOfWeek.ToString() == "Wednesday") { info.ctrcontrolSysweek = 3; } else if (td.DayOfWeek.ToString() == "Thursday") { info.ctrcontrolSysweek = 4; } else if (td.DayOfWeek.ToString() == "Friday") { info.ctrcontrolSysweek = 5; } else if (td.DayOfWeek.ToString() == "Saturday") { info.ctrcontrolSysweek = 6; } else { info.ctrcontrolSysweek = 7; } if (UpdateTools.UpdateCtrcontrolInfo(u => u.siteId == info.siteId, info) == true) { Response.Write("<script language='javascript'>alert('更新成功!');</script>"); Response.Redirect("/CenterControl/CenterSettingTime"); } else { Response.Write("<script language='javascript'>alert('更新失败!');</script>"); Response.Redirect("/CenterControl/CenterSettingTime"); } } } catch { Response.Write("<script language='javascript'>alert('更新出错!');</script>"); Response.Redirect("/CenterControl/CenterSettingTime"); } }
// GET: DataScreen public ActionResult Index() { HttpCookie cookie = Request.Cookies["userId"]; if (cookie.Name != null) { ViewBag.user = cookie.Value; } TBL_ENERGY[] energyInfo = SelectTools.SelectEnergyInfo(u => u.siteId == u.siteId, u => u.siteId); TBL_SITE[] siteInfo = SelectTools.SelectSiteInfo(u => u.siteId == u.siteId, u => u.siteId); TBL_AMMETER[] ammeterInfo = SelectTools.SelectAmmeterInfo(u => u.siteId == u.siteId, u => u.siteId); TBL_SIGCONTROL[] sigcontrolInfo = SelectTools.SelectSigcontrolInfo(u => u.ammeterId == u.ammeterId, u => u.ammeterId); TBL_CTRCONTROL[] ctrcontrolInfo = SelectTools.SelectCtrcontrolInfo(u => u.siteId == u.siteId, u => u.siteId); //单灯额定能耗数据 ViewBag.power = ammeterInfo[0].ammeterRefpower; //总额定功率数据 double totalpower = 0; foreach (var item in ammeterInfo) { totalpower += Convert.ToDouble(item.ammeterRefpower); } totalpower *= 1000; ViewBag.totalpower = totalpower; //本期能耗 double curenergy = 0; foreach (var item in energyInfo) { curenergy += Convert.ToDouble(item.energyCurpower); } ViewBag.curenergy = curenergy; //上期能耗 double preenergy = 0; foreach (var item in energyInfo) { preenergy += Convert.ToDouble(item.energyPrepower); } ViewBag.preenergy = preenergy; //单灯总数 ViewBag.ammetercount = ammeterInfo.Count() * 10; //站点总数 ViewBag.sitecount = siteInfo.Count() * 10; //单灯在线数 int ammeterOnline = 0; foreach (var item in ammeterInfo) { if (item.ammeterStatus == 0) { ammeterOnline += 1; } } ViewBag.ammeterOnline = ammeterOnline; //单灯警告数 int ammeterAlarm = 0; foreach (var item in ammeterInfo) { if (item.ammeterStatus == 2 || item.ammeterStatus == 3) { ammeterAlarm += 1; } } ViewBag.ammeterAlarm = ammeterAlarm; //单灯开灯数 int ammeterOn = 0; foreach (var item in ammeterInfo) { if (item.ammeterSwistatus == 1) { ammeterOn += 1; } } ViewBag.ammeterOn = ammeterOn; //站点在线数 int siteOnline = 0; foreach (var item in siteInfo) { if (item.siteStatus == 0) { siteOnline += 1; } } ViewBag.siteOnline = siteOnline; //站点警告数 int siteAlarm = 0; foreach (var item in siteInfo) { if (item.siteStatus == 2 || item.siteStatus == 3) { siteAlarm += 1; } } ViewBag.siteAlarm = siteAlarm; //站点工作数 int siteOn = 0; foreach (var item in siteInfo) { if (item.siteSwistatus == 1) { siteOn += 1; } } ViewBag.siteOn = siteOn; //开灯时间 ViewBag.opentime = ctrcontrolInfo[0].ctrcontrolTimopetime; //关灯时间 ViewBag.closetime = ctrcontrolInfo[0].ctrcontrolTimclotime; //巡检开始时间 ViewBag.xjstatime = sigcontrolInfo[0].sigcontrolInsstatime; //巡检结束时间 ViewBag.xjendtime = sigcontrolInfo[0].sigcontrolInsendtime; //告警类型名称 TBL_RUNNOTE[] runnote = SelectTools.SelectRunnoteInfo(u => u.runnoteAlastatus == 2 || u.runnoteAlastatus == 3, u => u.infoId); ViewBag.alarmCount = runnote.Count(); //告警信息提示 ArrayList ammeter = new ArrayList(); ArrayList site = new ArrayList(); foreach (var item in runnote) { if (item.ammeterId != 0) { foreach (var name in ammeterInfo) { if (item.ammeterId == name.ammeterId) { ammeter.Add(name.ammeterName); } } } else { foreach (var name in siteInfo) { if (item.siteId == name.siteId) { site.Add(name.siteName); } } } } ViewBag.noticecount = ammeter.Count + site.Count; ViewBag.ammeter = ammeter; ViewBag.site = site; return(View()); }