/// <summary> /// 修改TBL_ENERGY表的数据 /// </summary> /// <param name="whereLambda"> (u=>u.siteId == info.siteId, info) == true </param> /// 判断有无siteId /// <param name="info"> info是需要修改的信息 </param> /// <notice></notice> public static Boolean UpdateEnergyInfo(Expression <Func <TBL_ENERGY, bool> > whereLambda, TBL_ENERGY info) { try { using (LampNetEntities db = new LampNetEntities()) { DbQuery <TBL_ENERGY> dataObject = db.TBL_ENERGY.Where(whereLambda) as DbQuery <TBL_ENERGY>; TBL_ENERGY oldInfo = dataObject.FirstOrDefault(); oldInfo.energyDate = info.energyDate; oldInfo.energyWorktime = info.energyWorktime; oldInfo.energyStavalue = info.energyStavalue; oldInfo.energyEndvalue = info.energyEndvalue; oldInfo.energyPrepower = info.energyPrepower; oldInfo.energyCurpower = info.energyCurpower; oldInfo.energyPrerate = info.energyPrerate; oldInfo.energyCurrate = info.energyCurrate; db.SaveChanges(); return(true); } } catch { return(false); } }
/// <summary> /// 往能耗数据表中插入数据 /// </summary> /// <param name="info">硬件产生的信息(本系统模拟)</param> /// <returns></returns> public static Boolean InsertEnergyInfo(TBL_ENERGY info) { try { using (LampNetEntities db = new LampNetEntities()) { db.TBL_ENERGY.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_ENERGY[] SelectEnergyInfo <TKey>(Expression <Func <TBL_ENERGY, bool> > whereLambda, Expression <Func <TBL_ENERGY, TKey> > orderBy) { try { using (LampNetEntities db = new LampNetEntities()) { DbQuery <TBL_ENERGY> dataObject = db.TBL_ENERGY.Where(whereLambda).OrderBy(orderBy) as DbQuery <TBL_ENERGY>; TBL_ENERGY[] infoList = dataObject.ToArray(); return(infoList); } } catch { TBL_ENERGY[] nullInfo = new TBL_ENERGY[0]; return(nullInfo); } }
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)")); } }