// GET: App public ActionResult Index() { TBL_DOCUMENT[] appInfo = SelectTools.SelectDocumentInfo(u => u.documentKind == 0, u => u.documentId); if (appInfo == null || appInfo.Count() == 0) { Response.Write("<script>alert('无App二维码!');</script>"); return(View()); } if (Request.Cookies["userId"] != null) { string user = Request.Cookies["userId"].Value;//输出全部的值 ViewBag.user = user; } string app = appInfo[0].documentUrl.ToString(); ViewBag.app = app; HttpCookie cookie = Request.Cookies["userId"]; if (cookie.Name != null) { ViewBag.user = cookie.Value; } return(View()); }
// GET: Feedback public ActionResult Index() { int sumPage = GetSumPage(10); int nowPage = 1; TBL_FEEDBACK[] feedbackInfo = GetPagedList(1, 10, u => u.userId == u.userId, u => u.userId); if (feedbackInfo == null || feedbackInfo.Count() == 0) { Response.Write("<script>alert('无查询信息!');</script>"); } ViewBag.feedbackInfo = feedbackInfo; ViewBag.nowPage = nowPage; ViewBag.sumPage = sumPage; TBL_USER[] userInfo = SelectTools.SelectUserInfo(u => u.userId == u.userId, u => u.userId); if (Request.Cookies["userId"] != null) { string user = Request.Cookies["userId"].Value;//输出全部的值 ViewBag.user = user; } ViewBag.userInfo = userInfo; HttpCookie cookie = Request.Cookies["userId"]; if (cookie.Name != null) { ViewBag.user = cookie.Value; } return(View()); }
// 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()); }
// 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 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()); }
public ActionResult FeedbackInput(int userId) { if (userId == 0) { return(View("Index")); } else { TBL_FEEDBACK[] feedbackInfo = SelectTools.SelectFeedbackInfo(u => u.userId == userId, u => u.userId); if (feedbackInfo == null || feedbackInfo.Count() == 0) { Response.Write("<script>alert('无查询信息!');</script>"); } ViewBag.feedbackInfo = feedbackInfo; if (Request.Cookies["userId"] != null) { string user = Request.Cookies["userId"].Value;//输出全部的值 ViewBag.user = user; } TBL_USER[] userInfo = SelectTools.SelectUserInfo(u => u.userId == u.userId, u => u.userId); ViewBag.userInfo = userInfo; HttpCookie cookie = Request.Cookies["userId"]; if (cookie.Name != null) { ViewBag.user = cookie.Value; } return(View()); } }
public FileResult DocumentDownload(TBL_DOCUMENT document) { TBL_DOCUMENT[] list = SelectTools.SelectDocumentInfo(u => u.documentId == document.documentId, u => u.documentId); string path = list[0].documentUrl; string filePath = Server.MapPath(path); //路径 return(File(filePath, "text/plain", "document.excel")); //welcome.txt是客户端保存的名字 }
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 SingleSettingInspectionSelect(TBL_AMMETER info) { try { if (info.ammeterId != 0) { TBL_SIGCONTROL[] array = SelectTools.SelectSigcontrolInfo(u => u.ammeterId == info.ammeterId, u => u.ammeterId); TBL_AMMETER[] ammeter = SelectTools.SelectAmmeterInfo(u => u.ammeterId == u.ammeterId, u => u.ammeterId); if (array == null || array.Length == 0) { return(Content("没有此展示!")); } TBL_SIGCONTROL[] allInfo = SelectTools.SelectSigcontrolInfo(u => u.ammeterId == u.ammeterId, u => u.ammeterId); ViewBag.allInfo = allInfo; ViewBag.ammeter = ammeter; ViewBag.array = array; HttpCookie cookie = Request.Cookies["userId"]; if (cookie.Name != null) { ViewBag.user = cookie.Value; } return(View()); } else { TBL_AMMETER[] amt = SelectTools.SelectAmmeterInfo(u => u.ammeterName == info.ammeterName, u => u.ammeterId); int id = amt[0].ammeterId; TBL_SIGCONTROL[] array = SelectTools.SelectSigcontrolInfo(u => u.ammeterId == id, u => u.ammeterId); TBL_AMMETER[] ammeter = SelectTools.SelectAmmeterInfo(u => u.ammeterId == u.ammeterId, u => u.ammeterId); if (array == null || array.Length == 0) { return(Content("没有此展示!")); } TBL_SIGCONTROL[] allInfo = SelectTools.SelectSigcontrolInfo(u => u.ammeterId == u.ammeterId, u => u.ammeterId); ViewBag.allInfo = allInfo; ViewBag.ammeter = ammeter; ViewBag.array = array; 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)")); } }
// GET: Document public ActionResult Index() { TBL_DOCUMENT[] documentInfo = SelectTools.SelectDocumentInfo(u => u.documentKind == 1, u => u.documentId); if (documentInfo == null || documentInfo.Count() == 0) { Response.Write("<script>alert('无查询信息!');</script>"); } if (Request.Cookies["userId"] != null) { string user = Request.Cookies["userId"].Value;//输出全部的值 ViewBag.user = user; } ViewBag.documentInfo = documentInfo; return(View()); }
public ActionResult SettingSelect(TBL_SYSSET set) { TBL_SYSSET[] allInfo = SelectTools.SelectSyssetInfo(u => u.syssetId == u.syssetId, u => u.syssetId); TBL_SYSSET[] info = SelectTools.SelectSyssetInfo(u => u.syssetId == set.syssetId, u => u.syssetId); ViewBag.allInfo = allInfo; ViewBag.info = info; HttpCookie cookie = Request.Cookies["userId"]; if (cookie.Name != null) { ViewBag.user = cookie.Value; } return View(); }
//单灯设置-巡检 public ActionResult SingleSettingInspection() { TBL_SIGCONTROL[] allInfo = SelectTools.SelectSigcontrolInfo(u => u.ammeterId == u.ammeterId, u => u.ammeterId); TBL_AMMETER[] ammeter = SelectTools.SelectAmmeterInfo(u => u.ammeterId == u.ammeterId, u => u.ammeterId); ViewBag.allInfo = allInfo; ViewBag.ammeter = ammeter; 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()); }
//集中设置-时钟设置 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()); }
// GET: ProtectMessage public ActionResult Index() { TBL_DOCUMENT[] protectInfo = SelectTools.SelectDocumentInfo(u => u.documentKind == 2, u => u.documentId); if (protectInfo == null || protectInfo.Count() == 0) { Response.Write("<script>alert('无查询信息!');</script>"); } ViewBag.protectInfo = protectInfo; HttpCookie cookie = Request.Cookies["userId"]; if (cookie.Name != null) { ViewBag.user = cookie.Value; } return(View()); }
// GET: SingleControl //单灯控制 public ActionResult SingleControl() { TBL_SIGCONTROL[] array = SelectTools.SelectSigcontrolInfo(u => u.ammeterId == u.ammeterId, u => u.ammeterId); TBL_AMMETER[] ammeter = SelectTools.SelectAmmeterInfo(u => u.ammeterId == u.ammeterId, u => u.ammeterId); if (array == null || array.Length == 0) { return(Content("没有此展示!")); } ViewBag.ammeter = ammeter; ViewBag.array = array; 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()); }
//单灯设置-分组 public ActionResult SingleSettingGroup() { int sumPage = GetSumPage(30); int nowPage = 1; TBL_SIGCONTROL[] allInfo = GetPagedList(1, 30, u => u.ammeterId == u.ammeterId, u => u.ammeterId); ViewBag.allInfo = allInfo; ViewBag.nowPage = nowPage; ViewBag.sumPage = sumPage; TBL_SIGCONTROL[] array = SelectTools.SelectSigcontrolInfo(u => u.ammeterId == u.ammeterId, u => u.ammeterId); TBL_AMMETER[] AmmeterList = SelectTools.SelectAmmeterInfo(u => u.ammeterId == u.ammeterId, u => u.ammeterId); ViewBag.ammeterlist = AmmeterList; ViewBag.sigarray = array; 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 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)")); } }
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"); } }
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)")); } }
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)")); } }
// 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()); }