/// <summary>
/// 修改TBL_CTRCONTROL表的数据
/// </summary>
/// <param name="whereLambda"> (u=>u.siteId == info.siteId, info) == true </param>
/// 判断有无siteId
/// <param name="info"> info是需要修改的信息 </param>
/// <notice></notice>
public static Boolean UpdateCtrcontrolInfo(Expression <Func <TBL_CTRCONTROL, bool> > whereLambda, TBL_CTRCONTROL info)
{
try
{
using (LampNetEntities db = new LampNetEntities())
{
DbQuery <TBL_CTRCONTROL> dataObject = db.TBL_CTRCONTROL.Where(whereLambda) as DbQuery <TBL_CTRCONTROL>;
TBL_CTRCONTROL oldInfo = dataObject.FirstOrDefault();
oldInfo.ctrcontrolTimweek = info.ctrcontrolTimweek;
oldInfo.ctrcontrolLigweek = info.ctrcontrolLigweek;
oldInfo.ctrcontrolTimopetime = info.ctrcontrolTimopetime;
oldInfo.ctrcontrolTimclotime = info.ctrcontrolTimclotime;
oldInfo.ctrcontrolOpeligvalue = info.ctrcontrolOpeligvalue;
oldInfo.ctrcontrolCloligvalue = info.ctrcontrolCloligvalue;
oldInfo.ctrcontrolLigvalsource = info.ctrcontrolLigvalsource;
oldInfo.ctrcontrolSystime = info.ctrcontrolSystime;
oldInfo.ctrcontrolSysweek = info.ctrcontrolSysweek;
db.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}
/// <summary>
/// 往集控信息表中插入数据
/// </summary>
/// <param name="info">前端页面输入的信息</param>
/// <returns></returns>
public static Boolean InsertCtrcontrolInfo(TBL_CTRCONTROL info)
{
try
{
using (LampNetEntities db = new LampNetEntities())
{
db.TBL_CTRCONTROL.Add(info);
db.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}
/// <summary>
/// 查找集控信息表中符合条件的信息
/// </summary>
/// <param name="whereLambda">u => u.siteId == info.siteId, u => u.siteId</param>
/// <returns>集控信息数组</returns>
public static TBL_CTRCONTROL[] SelectCtrcontrolInfo <TKey>(Expression <Func <TBL_CTRCONTROL, bool> > whereLambda, Expression <Func <TBL_CTRCONTROL, TKey> > orderBy)
{
try
{
using (LampNetEntities db = new LampNetEntities())
{
DbQuery <TBL_CTRCONTROL> dataObject = db.TBL_CTRCONTROL.Where(whereLambda).OrderBy(orderBy) as DbQuery <TBL_CTRCONTROL>;
TBL_CTRCONTROL[] infoList = dataObject.ToArray();
return(infoList);
}
}
catch
{
TBL_CTRCONTROL[] nullInfo = new TBL_CTRCONTROL[0];
return(nullInfo);
}
}
public void CenterSettingLightUpdate(TBL_CTRCONTROL ctr)
{
try
{
if (UpdateTools.UpdateCtrcontrolInfo(u => u.siteId == ctr.siteId, ctr) == true)
{
Response.Write("<script language='javascript'>alert('更新成功！');</script>");
Response.Redirect("/CenterControl/CenterSettingLight");
}
else
{
Response.Write("<script language='javascript'>alert('更新失败！');</script>");
Response.Redirect("/CenterControl/CenterSettingLight");
}
}
catch
{
Response.Write("<script language='javascript'>alert('更新出错！');</script>");
Response.Redirect("/CenterControl/CenterSettingLight");
}
}
public void CenterSettingSetTimeUpdate(string opehour, string opeminute, string opesecond, string clohour, string clominute, string closecond, TBL_CTRCONTROL ctr)
{
try
{
string opetime = opehour + ':' + opeminute + ':' + opesecond;
string clotime = clohour + ':' + clominute + ':' + closecond;
if (UpdateTools.UpdateCtrcontrolInfo(u => u.siteId == ctr.siteId, ctr) == true)
{
Response.Write("<script language='javascript'>alert('更新成功！');</script>");
Response.Redirect("/CenterControl/CenterSettingSetTime");
}
else
{
Response.Write("<script language='javascript'>alert('更新失败！');</script>");
Response.Redirect("/CenterControl/CenterSettingSetTime");
}
}
catch
{
Response.Write("<script language='javascript'>alert('更新出错！');</script>");
Response.Redirect("/CenterControl/CenterSettingSetTime");
}
}
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）"));
}
}
