// 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());
}
