// GET: CenterControl //集中控制 public ActionResult CenterControl() { int sumPage = GetSumPage(30); int nowPage = 1; TBL_CTRCONTROL[] allInfo = GetPagedList(1, 30, u => u.siteId == u.siteId, u => u.siteId); ViewBag.nowPage = nowPage; ViewBag.sumPage = sumPage; TBL_SITE[] sitearray = SelectTools.SelectSiteInfo(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.allInfo = allInfo; HttpCookie cookie = Request.Cookies["userId"]; if (cookie.Name != null) { ViewBag.user = cookie.Value; } return(View()); }
public ActionResult AmmeterUpdate(int ammeterId) { TBL_AMMETER[] allInfo = SelectTools.SelectAmmeterInfo(u => u.ammeterId == ammeterId, u => u.ammeterId); TBL_AMMETER[] array = SelectTools.SelectAmmeterInfo(u => u.ammeterId == u.ammeterId, u => u.ammeterId); ArrayList SiteList = new ArrayList(); foreach (var item in array) { //依次获得站点名 int siteId = Convert.ToInt32(item.siteId); TBL_SITE[] siteName = SelectTools.SelectSiteInfo(u => u.siteId == siteId, u => u.siteId); if (siteName != null && siteName.Length != 0) { SiteList.Add(siteName[0].siteName); } else { SiteList.Add("【出错数据】"); } } ViewBag.allInfo = allInfo; ViewBag.SiteName = SiteList; ViewBag.array = array; TBL_SITE[] siteInfo = SelectTools.SelectSiteInfo(u => u.siteId == u.siteId, u => u.siteId); ViewBag.siteInfo = siteInfo; if (Request.Cookies["userId"] != null) { string user = Request.Cookies["userId"].Value;//输出全部的值 ViewBag.user = user; } return(View()); }
// GET: ProtectDataDevice public ActionResult Index() { int sumPage = GetSumPage(30); int nowPage = 1; TBL_DEVICEPROTECT[] ProtectDeviceInfo = GetPagedList(1, 30, u => u.userId == u.userId, u => u.userId); ViewBag.ProtectDeviceInfo = ProtectDeviceInfo; ViewBag.nowPage = nowPage; ViewBag.sumPage = sumPage; TBL_SITE[] siteInfo = SelectTools.SelectSiteInfo(u => u.siteId == u.siteId, u => u.siteId); TBL_AMMETER[] ammeterInfo = SelectTools.SelectAmmeterInfo(u => u.ammeterId == u.ammeterId, u => u.ammeterId); TBL_USER[] userInfo = SelectTools.SelectUserInfo(u => u.userId == u.userId, u => u.userId); ViewBag.userInfo = userInfo; ViewBag.siteInfo = siteInfo; ViewBag.ammeterInfo = ammeterInfo; HttpCookie cookie = Request.Cookies["userId"]; if (cookie.Name != null) { ViewBag.user = cookie.Value; } return(View()); }
// GET: EnergyData public ActionResult Index() { int sumPage = GetSumPage(15); int nowPage = 1; TBL_ENERGY[] energyInfo = GetPagedList(1, 15, u => u.siteId == u.siteId, u => u.siteId); ViewBag.energyInfo = energyInfo; ViewBag.nowPage = nowPage; ViewBag.sumPage = sumPage; TBL_SITE[] siteInfo = SelectTools.SelectSiteInfo(u => u.siteId == u.siteId, u => u.siteId); if (Request.Cookies["userId"] != null) { string user = Request.Cookies["userId"].Value;//输出全部的值 ViewBag.user = user; } ViewBag.siteInfo = siteInfo; HttpCookie cookie = Request.Cookies["userId"]; if (cookie.Name != null) { ViewBag.user = cookie.Value; } return(View()); }
public ActionResult SiteSelect(TBL_SITE site) { try { if (site.siteId != 0) { int sumPage = GetSumPage(30); int nowPage = 1; TBL_SITE[] allInfo = GetPagedList(1, 30, u => u.siteId == u.siteId, u => u.siteId); ViewBag.nowPage = nowPage; ViewBag.sumPage = sumPage; TBL_SITE[] info = SelectTools.SelectSiteInfo(u => u.siteId == site.siteId, u => u.siteId); if (info == null || info.Length == 0) { return(Content("没有此展示!")); } ViewBag.allInfo = allInfo; ViewBag.info = info; HttpCookie cookie = Request.Cookies["userId"]; if (cookie.Name != null) { ViewBag.user = cookie.Value; } return(View()); } else { int sumPage = GetSumPage(30); int nowPage = 1; TBL_SITE[] allInfo = GetPagedList(1, 30, u => u.siteId == u.siteId, u => u.siteId); ViewBag.nowPage = nowPage; ViewBag.sumPage = sumPage; TBL_SITE[] info = SelectTools.SelectSiteInfo(u => u.siteName == site.siteName, u => u.siteId); if (info == null || info.Length == 0) { return(Content("没有此展示!")); } ViewBag.allInfo = allInfo; ViewBag.info = info; HttpCookie cookie = Request.Cookies["userId"]; if (cookie.Name != null) { ViewBag.user = cookie.Value; } 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 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 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 SiteUpdate(int siteId) { TBL_SITE[] allInfo = SelectTools.SelectSiteInfo(u => u.siteId == siteId, u => u.siteId); TBL_SITE[] array = SelectTools.SelectSiteInfo(u => u.siteId == u.siteId, u => u.siteId); ViewBag.array = array; ViewBag.allInfo = allInfo; HttpCookie cookie = Request.Cookies["userId"]; if (cookie.Name != null) { ViewBag.user = cookie.Value; } return(View()); }
// GET: SiteManagement public ActionResult Index() { int sumPage = GetSumPage(15); int nowPage = 1; TBL_SITE[] allInfo = GetPagedList(1, 15, u => u.siteId == u.siteId, u => u.siteId); ViewBag.nowPage = nowPage; ViewBag.sumPage = sumPage; TBL_SITE[] array = SelectTools.SelectSiteInfo(u => u.siteId == u.siteId, u => u.siteId); ViewBag.array = array; HttpCookie cookie = Request.Cookies["userId"]; if (cookie.Name != null) { ViewBag.user = cookie.Value; } return(View()); }
// GET: RunData public ActionResult Index() { int sumPage = GetSumPage(30); int nowPage = 1; TBL_RUN[] runInfo = GetPagedList(1, 30, u => u.siteId == u.siteId, u => u.siteId); ViewBag.runInfo = runInfo; ViewBag.nowPage = nowPage; ViewBag.sumPage = sumPage; TBL_SITE[] siteInfo = SelectTools.SelectSiteInfo(u => u.siteId == u.siteId, u => u.siteId); ViewBag.siteInfo = siteInfo; HttpCookie cookie = Request.Cookies["userId"]; if (cookie.Name != null) { ViewBag.user = cookie.Value; } return(View()); }
// GET: AmmeterManagement public ActionResult Index() { int sumPage = GetSumPage(30); int nowPage = 1; TBL_AMMETER[] allInfo = GetPagedList(1, 30, u => u.ammeterId == u.ammeterId, u => u.ammeterId); ViewBag.nowPage = nowPage; ViewBag.sumPage = sumPage; TBL_AMMETER[] array = SelectTools.SelectAmmeterInfo(u => u.ammeterId == u.ammeterId, u => u.ammeterId); ArrayList SiteList = new ArrayList(); foreach (var item in array) { //依次获得站点名 int siteId = Convert.ToInt32(item.siteId); TBL_SITE[] siteName = SelectTools.SelectSiteInfo(u => u.siteId == siteId, u => u.siteId); if (siteName != null && siteName.Length != 0) { SiteList.Add(siteName[0].siteName); } else { SiteList.Add("【出错数据】"); } } ViewBag.SiteName = SiteList; ViewBag.array = array; if (Request.Cookies["userId"] != null) { string user = Request.Cookies["userId"].Value;//输出全部的值 ViewBag.user = user; } 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 ActionResult ProtectDataDeviceSelect(TBL_DEVICEPROTECT table) { try { if (table.userId != 0) { //按照用户号查找 int sumPage = GetSumPage(30); int nowPage = 1; TBL_DEVICEPROTECT[] ProtectDeviceInfo = GetPagedList(1, 30, u => u.userId == table.userId, u => u.userId); ViewBag.nowPage = nowPage; ViewBag.sumPage = sumPage; TBL_SITE[] siteInfo = SelectTools.SelectSiteInfo(u => u.siteId == u.siteId, u => u.siteId); TBL_AMMETER[] ammeterInfo = SelectTools.SelectAmmeterInfo(u => u.ammeterId == u.ammeterId, u => u.ammeterId); TBL_USER[] userInfo = SelectTools.SelectUserInfo(u => u.userId == u.userId, u => u.userId); ViewBag.userInfo = userInfo; ViewBag.siteInfo = siteInfo; ViewBag.ammeterInfo = ammeterInfo; ViewBag.ProtectDeviceInfo = ProtectDeviceInfo; HttpCookie cookie = Request.Cookies["userId"]; if (cookie.Name != null) { ViewBag.user = cookie.Value; } return(View()); } else if (table.siteId != -1) { //按站点查找 int sumPage = GetSumPage(30); int nowPage = 1; TBL_DEVICEPROTECT[] ProtectDeviceInfo = GetPagedList(1, 30, u => u.siteId == table.siteId, u => u.siteId); ViewBag.nowPage = nowPage; ViewBag.sumPage = sumPage; TBL_SITE[] siteInfo = SelectTools.SelectSiteInfo(u => u.siteId == u.siteId, u => u.siteId); TBL_AMMETER[] ammeterInfo = SelectTools.SelectAmmeterInfo(u => u.ammeterId == u.ammeterId, u => u.ammeterId); TBL_USER[] userInfo = SelectTools.SelectUserInfo(u => u.userId == u.userId, u => u.userId); ViewBag.userInfo = userInfo; ViewBag.siteInfo = siteInfo; ViewBag.ammeterInfo = ammeterInfo; ViewBag.ProtectDeviceInfo = ProtectDeviceInfo; HttpCookie cookie = Request.Cookies["userId"]; if (cookie.Name != null) { ViewBag.user = cookie.Value; } return(View()); } else if (table.ammeterId != -1) { //按照电表查找 int sumPage = GetSumPage(30); int nowPage = 1; TBL_DEVICEPROTECT[] ProtectDeviceInfo = GetPagedList(1, 30, u => u.ammeterId == table.ammeterId, u => u.ammeterId); ViewBag.nowPage = nowPage; ViewBag.sumPage = sumPage; TBL_SITE[] siteInfo = SelectTools.SelectSiteInfo(u => u.siteId == u.siteId, u => u.siteId); TBL_AMMETER[] ammeterInfo = SelectTools.SelectAmmeterInfo(u => u.ammeterId == u.ammeterId, u => u.ammeterId); TBL_USER[] userInfo = SelectTools.SelectUserInfo(u => u.userId == u.userId, u => u.userId); ViewBag.userInfo = userInfo; ViewBag.siteInfo = siteInfo; ViewBag.ammeterInfo = ammeterInfo; ViewBag.ProtectDeviceInfo = ProtectDeviceInfo; HttpCookie cookie = Request.Cookies["userId"]; if (cookie.Name != null) { ViewBag.user = cookie.Value; } return(View()); } else if (table.deviceprotectKind != -1) { //按照电表查找 int sumPage = GetSumPage(30); int nowPage = 1; TBL_DEVICEPROTECT[] ProtectDeviceInfo = GetPagedList(1, 30, u => u.deviceprotectKind == table.deviceprotectKind, u => u.userId); ViewBag.nowPage = nowPage; ViewBag.sumPage = sumPage; TBL_SITE[] siteInfo = SelectTools.SelectSiteInfo(u => u.siteId == u.siteId, u => u.siteId); TBL_AMMETER[] ammeterInfo = SelectTools.SelectAmmeterInfo(u => u.ammeterId == u.ammeterId, u => u.ammeterId); TBL_USER[] userInfo = SelectTools.SelectUserInfo(u => u.userId == u.userId, u => u.userId); ViewBag.userInfo = userInfo; ViewBag.siteInfo = siteInfo; ViewBag.ammeterInfo = ammeterInfo; ViewBag.ProtectDeviceInfo = ProtectDeviceInfo; HttpCookie cookie = Request.Cookies["userId"]; if (cookie.Name != null) { ViewBag.user = cookie.Value; } return(View()); } else if (table.deviceprotectModule != -1) { //按照电表查找 int sumPage = GetSumPage(30); int nowPage = 1; TBL_DEVICEPROTECT[] ProtectDeviceInfo = GetPagedList(1, 30, u => u.deviceprotectModule == table.deviceprotectModule, u => u.userId); ViewBag.nowPage = nowPage; ViewBag.sumPage = sumPage; TBL_SITE[] siteInfo = SelectTools.SelectSiteInfo(u => u.siteId == u.siteId, u => u.siteId); TBL_AMMETER[] ammeterInfo = SelectTools.SelectAmmeterInfo(u => u.ammeterId == u.ammeterId, u => u.ammeterId); TBL_USER[] userInfo = SelectTools.SelectUserInfo(u => u.userId == u.userId, u => u.userId); ViewBag.userInfo = userInfo; ViewBag.siteInfo = siteInfo; ViewBag.ammeterInfo = ammeterInfo; ViewBag.ProtectDeviceInfo = ProtectDeviceInfo; HttpCookie cookie = Request.Cookies["userId"]; if (cookie.Name != null) { ViewBag.user = cookie.Value; } return(View()); } else { return(Content("查询信息为空!")); } } catch { return(Content("查询失败!(ERROR)")); } }
public ActionResult RunDataSelect(string siteName, TBL_RUN run) { try { if (run.siteId != 0) { //如果有站点号,按照站点号查找 int sumPage = GetSumPage(30); int nowPage = 1; TBL_RUN[] runInfo = GetPagedList(1, 30, u => u.siteId == run.siteId, u => u.siteId); ViewBag.nowPage = nowPage; ViewBag.sumPage = sumPage; TBL_SITE[] siteInfo = SelectTools.SelectSiteInfo(u => u.siteId == u.siteId, u => u.siteId); if (siteInfo == null || siteInfo.Length == 0) { return(Content("没有此展示!")); } ViewBag.runInfo = runInfo; ViewBag.siteInfo = siteInfo; HttpCookie cookie = Request.Cookies["userId"]; if (cookie.Name != null) { ViewBag.user = cookie.Value; } return(View()); } else if (run.runFreshtime != null) { //如果输入了时间,按时间查找 int sumPage = GetSumPage(30); int nowPage = 1; TimeSpan ts1 = new TimeSpan(DateTime.Now.Ticks); DateTime dt = Convert.ToDateTime(run.runFreshtime); TBL_RUN[] runInfo = GetPagedList(1, 30, u => u.runFreshtime == dt, u => u.siteId); ViewBag.nowPage = nowPage; ViewBag.sumPage = sumPage; TBL_SITE[] siteInfo = SelectTools.SelectSiteInfo(u => u.siteId == u.siteId, u => u.siteId); if (siteInfo == null || siteInfo.Length == 0) { return(Content("没有此展示!")); } ViewBag.runInfo = runInfo; ViewBag.siteInfo = siteInfo; HttpCookie cookie = Request.Cookies["userId"]; if (cookie.Name != null) { ViewBag.user = cookie.Value; } return(View()); } else { //如果没有时间和站点号,则按照名称查找 int sumPage = GetSumPage(30); int nowPage = 1; TBL_SITE[] info = SelectTools.SelectSiteInfo(u => u.siteName == siteName, u => u.siteId); int siteId = info[0].siteId; TBL_RUN[] runInfo = GetPagedList(1, 30, u => u.siteId == siteId, u => u.siteId); ViewBag.nowPage = nowPage; ViewBag.sumPage = sumPage; TBL_SITE[] siteInfo = SelectTools.SelectSiteInfo(u => u.siteId == u.siteId, u => u.siteId); if (siteInfo == null || siteInfo.Length == 0) { return(Content("没有此展示!")); } ViewBag.runInfo = runInfo; ViewBag.siteInfo = siteInfo; HttpCookie cookie = Request.Cookies["userId"]; if (cookie.Name != null) { ViewBag.user = cookie.Value; } return(View()); } } catch { return(Content("查询失败!(ERROR)")); } }
public ActionResult AmmeterSelect(TBL_AMMETER ammeter) { try { if (ammeter.ammeterId != 0) { int sumPage = GetSumPage(30); int nowPage = 1; TBL_AMMETER[] allInfo = GetPagedList(1, 30, u => u.ammeterId == u.ammeterId, u => u.ammeterId); ViewBag.nowPage = nowPage; ViewBag.sumPage = sumPage; TBL_AMMETER[] info = SelectTools.SelectAmmeterInfo(u => u.ammeterId == ammeter.ammeterId, u => u.ammeterId); if (info == null || info.Length == 0) { return(Content("没有此展示!")); } ArrayList SiteList = new ArrayList(); foreach (var item in info) { //依次获得站点名 int siteId = Convert.ToInt32(item.siteId); TBL_SITE[] siteName = SelectTools.SelectSiteInfo(u => u.siteId == siteId, u => u.siteId); if (siteName != null && siteName.Length != 0) { SiteList.Add(siteName[0].siteName); } else { SiteList.Add("【出错数据】"); } } if (Request.Cookies["userId"] != null) { string user = Request.Cookies["userId"].Value;//输出全部的值 ViewBag.user = user; } ViewBag.SiteName = SiteList; ViewBag.allInfo = allInfo; ViewBag.info = info; return(View()); } else { int sumPage = GetSumPage(30); int nowPage = 1; TBL_AMMETER[] allInfo = GetPagedList(1, 30, u => u.ammeterId == u.ammeterId, u => u.ammeterId); ViewBag.nowPage = nowPage; ViewBag.sumPage = sumPage; TBL_AMMETER[] info = SelectTools.SelectAmmeterInfo(u => u.ammeterName == ammeter.ammeterName, u => u.ammeterId); if (info == null || info.Length == 0) { return(Content("没有此展示!")); } ArrayList SiteList = new ArrayList(); foreach (var item in info) { //依次获得站点名 int siteId = Convert.ToInt32(item.siteId); TBL_SITE[] siteName = SelectTools.SelectSiteInfo(u => u.siteId == siteId, u => u.siteId); if (siteName != null && siteName.Length != 0) { SiteList.Add(siteName[0].siteName); } else { SiteList.Add("【出错数据】"); } } if (Request.Cookies["userId"] != null) { string user = Request.Cookies["userId"].Value;//输出全部的值 ViewBag.user = user; } ViewBag.SiteName = SiteList; ViewBag.allInfo = allInfo; ViewBag.info = info; return(View()); } } catch { return(Content("查询失败!(ERROR)")); } }
// 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()); }
public ActionResult EnergyDataSelect(string siteName, TBL_ENERGY energy) { try { if (energy.siteId != 0) { //如果有站点号,按照站点号查找 int sumPage = GetSumPage(30); int nowPage = 1; TBL_ENERGY[] energyInfo = GetPagedList(1, 30, u => u.siteId == energy.siteId, u => u.siteId); ViewBag.nowPage = nowPage; ViewBag.sumPage = sumPage; TBL_SITE[] siteInfo = SelectTools.SelectSiteInfo(u => u.siteId == u.siteId, u => u.siteId); if (siteInfo == null || siteInfo.Length == 0) { return(Content("没有此展示!")); } if (Request.Cookies["userId"] != null) { string user = Request.Cookies["userId"].Value;//输出全部的值 ViewBag.user = user; } ViewBag.energyInfo = energyInfo; ViewBag.siteInfo = siteInfo; HttpCookie cookie = Request.Cookies["userId"]; if (cookie.Name != null) { ViewBag.user = cookie.Value; } return(View()); } else if (energy.energyDate != null) { //如果输入了时间,按时间查找 int sumPage = GetSumPage(30); int nowPage = 1; TBL_ENERGY[] energyInfo = GetPagedList(1, 30, u => u.energyDate == energy.energyDate, u => u.siteId); ViewBag.nowPage = nowPage; ViewBag.sumPage = sumPage; TBL_SITE[] siteInfo = SelectTools.SelectSiteInfo(u => u.siteId == u.siteId, u => u.siteId); if (siteInfo == null || siteInfo.Length == 0) { return(Content("没有此展示!")); } if (Request.Cookies["userId"] != null) { string user = Request.Cookies["userId"].Value;//输出全部的值 ViewBag.user = user; } ViewBag.energyInfo = energyInfo; ViewBag.siteInfo = siteInfo; HttpCookie cookie = Request.Cookies["userId"]; if (cookie.Name != null) { ViewBag.user = cookie.Value; } return(View()); } else { //如果没有时间和站点号,则按照名称查找 int sumPage = GetSumPage(30); int nowPage = 1; TBL_SITE[] info = SelectTools.SelectSiteInfo(u => u.siteName == siteName, u => u.siteId); int siteId = info[0].siteId; TBL_ENERGY[] energyInfo = GetPagedList(1, 30, u => u.siteId == siteId, u => u.siteId); ViewBag.nowPage = nowPage; ViewBag.sumPage = sumPage; TBL_SITE[] siteInfo = SelectTools.SelectSiteInfo(u => u.siteId == u.siteId, u => u.siteId); if (siteInfo == null || siteInfo.Length == 0) { return(Content("没有此展示!")); } if (Request.Cookies["userId"] != null) { string user = Request.Cookies["userId"].Value;//输出全部的值 ViewBag.user = user; } ViewBag.energyInfo = energyInfo; ViewBag.siteInfo = siteInfo; HttpCookie cookie = Request.Cookies["userId"]; if (cookie.Name != null) { ViewBag.user = cookie.Value; } return(View()); } } catch { return(Content("查询失败!(ERROR)")); } }
public ActionResult CenterControlSelect(string siteName, TBL_CTRCONTROL ctr) { try { if (ctr.siteId != 0) { int sumPage = GetSumPage(30); int nowPage = 1; TBL_CTRCONTROL[] allInfo = GetPagedList(1, 30, u => u.siteId == u.siteId, u => u.siteId); ViewBag.nowPage = nowPage; ViewBag.sumPage = sumPage; TBL_SITE[] info = SelectTools.SelectSiteInfo(u => u.siteId == ctr.siteId, u => u.siteId); if (info == null || info.Length == 0) { return(Content("没有此展示!")); } TBL_SITE[] sitearray = SelectTools.SelectSiteInfo(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.allInfo = allInfo; ViewBag.info = info; HttpCookie cookie = Request.Cookies["userId"]; if (cookie.Name != null) { ViewBag.user = cookie.Value; } return(View()); } else if (siteName != null) { int sumPage = GetSumPage(30); int nowPage = 1; TBL_CTRCONTROL[] allInfo = GetPagedList(1, 30, u => u.siteId == u.siteId, u => u.siteId); ViewBag.nowPage = nowPage; ViewBag.sumPage = sumPage; TBL_SITE[] info = SelectTools.SelectSiteInfo(u => u.siteName == siteName, u => u.siteId); if (info == null || info.Length == 0) { return(Content("没有此展示!")); } TBL_SITE[] sitearray = SelectTools.SelectSiteInfo(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.allInfo = allInfo; ViewBag.info = info; HttpCookie cookie = Request.Cookies["userId"]; if (cookie.Name != null) { ViewBag.user = cookie.Value; } return(View()); } else { return(Content("没有查询内容!")); } } catch { return(Content("查询失败!(ERROR)")); } }