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