public void SiteUpdate(TBL_SITE info)
{
try
{
HttpCookie cookie = Request.Cookies["userId"];
if (cookie.Name != null)
{
ViewBag.user = cookie.Value;
}
if (UpdateTools.UpdateSiteInfo(u => u.siteId == info.siteId, info) == true)
{
Response.Write("<script>alert('更新成功！');</script>");
Response.Redirect("/SiteManagement/Index");
}
else
{
Response.Write("<script>alert('不存在更新内容！');</script>");
Response.Redirect("/SiteManagement/Index");
}
}
catch
{
Response.Write("<script>alert('更新失败！');</script>");
Response.Redirect("/SiteManagement/Index");
}
}
/// <summary>
/// 修改TBL_SITE表的数据
/// </summary>
/// <param name="whereLambda"> (u=>u.siteId == info.siteId, info) == true </param>
/// 判断有无siteId
/// <param name="info"> info是需要修改的信息 </param>
/// <notice></notice>
public static Boolean UpdateSiteInfo(Expression <Func <TBL_SITE, bool> > whereLambda, TBL_SITE info)
{
try
{
using (LampNetEntities db = new LampNetEntities())
{
DbQuery <TBL_SITE> dataObject = db.TBL_SITE.Where(whereLambda) as DbQuery <TBL_SITE>;
TBL_SITE oldInfo = dataObject.FirstOrDefault();
oldInfo.siteName = info.siteName;
oldInfo.siteGroup = info.siteGroup;
oldInfo.siteModel = info.siteModel;
oldInfo.siteStatus = info.siteStatus;
oldInfo.siteSwistatus = info.siteSwistatus;
oldInfo.siteIp = info.siteIp;
oldInfo.siteContime = info.siteContime;
oldInfo.siteInssite = info.siteInssite;
oldInfo.sitePurtime = info.sitePurtime;
oldInfo.siteLife = info.siteLife;
oldInfo.siteAcctime = info.siteAcctime;
oldInfo.siteNote = info.siteNote;
db.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}
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 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）"));
}
}
/// <summary>
/// 往站点信息表中插入数据
/// </summary>
/// <param name="info">前端页面输入的信息</param>
/// <returns></returns>
public static Boolean InsertSiteInfo(TBL_SITE info)
{
try
{
using (LampNetEntities db = new LampNetEntities())
{
db.TBL_SITE.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_SITE[] SelectSiteInfo <TKey>(Expression <Func <TBL_SITE, bool> > whereLambda, Expression <Func <TBL_SITE, TKey> > orderBy)
{
try
{
using (LampNetEntities db = new LampNetEntities())
{
DbQuery <TBL_SITE> dataObject = db.TBL_SITE.Where(whereLambda).OrderBy(orderBy) as DbQuery <TBL_SITE>;
TBL_SITE[] infoList = dataObject.ToArray();
return(infoList);
}
}
catch
{
TBL_SITE[] nullInfo = new TBL_SITE[0];
return(nullInfo);
}
}
