/// <summary> /// 往运行数据表中插入数据 /// </summary> /// <param name="info">系统产生的信息(本系统模拟)</param> /// <returns></returns> public static Boolean InsertRunInfo(TBL_RUN info) { try { using (LampNetEntities db = new LampNetEntities()) { db.TBL_RUN.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_RUN[] SelectRunInfo <TKey>(Expression <Func <TBL_RUN, bool> > whereLambda, Expression <Func <TBL_RUN, TKey> > orderBy) { try { using (LampNetEntities db = new LampNetEntities()) { DbQuery <TBL_RUN> dataObject = db.TBL_RUN.Where(whereLambda).OrderBy(orderBy) as DbQuery <TBL_RUN>; TBL_RUN[] infoList = dataObject.ToArray(); return(infoList); } } catch { TBL_RUN[] nullInfo = new TBL_RUN[0]; return(nullInfo); } }
/// <summary> /// 修改TBL_RUN表的数据 /// </summary> /// <param name="whereLambda"> (u=>u.siteId == info.siteId, info) == true </param> /// 判断有无siteId /// <param name="info"> info是需要修改的信息 </param> /// <notice></notice> public static Boolean UpdateRunInfo(Expression <Func <TBL_RUN, bool> > whereLambda, TBL_RUN info) { try { using (LampNetEntities db = new LampNetEntities()) { DbQuery <TBL_RUN> dataObject = db.TBL_RUN.Where(whereLambda) as DbQuery <TBL_RUN>; TBL_RUN oldInfo = dataObject.FirstOrDefault(); oldInfo.runVolt = info.runVolt; oldInfo.runCurrent = info.runCurrent; oldInfo.runStavalue = info.runStavalue; oldInfo.runFreshtime = info.runFreshtime; db.SaveChanges(); return(true); } } catch { return(false); } }
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)")); } }