/// <summary> /// 往运行状态历史表中插入数据 /// </summary> /// <param name="info">系统产生的信息(本系统模拟)</param> /// <returns></returns> public static Boolean InsertRunnoteInfo(TBL_RUNNOTE info) { try { using (LampNetEntities db = new LampNetEntities()) { db.TBL_RUNNOTE.Add(info); db.SaveChanges(); return(true); } } catch { return(false); } }
/// <summary> /// 查找运行状态历史表中符合条件的信息 /// </summary> /// <param name="whereLambda">u => u.siteId == info.siteId, u => u.siteId</param> /// <param name="whereLambda">u => u.ammeterId == info.ammeterId, u => u.ammeterId</param> /// <returns>运行状态数据数组</returns> public static TBL_RUNNOTE[] SelectRunnoteInfo <TKey>(Expression <Func <TBL_RUNNOTE, bool> > whereLambda, Expression <Func <TBL_RUNNOTE, TKey> > orderBy) { try { using (LampNetEntities db = new LampNetEntities()) { DbQuery <TBL_RUNNOTE> dataObject = db.TBL_RUNNOTE.Where(whereLambda).OrderBy(orderBy) as DbQuery <TBL_RUNNOTE>; TBL_RUNNOTE[] infoList = dataObject.ToArray(); return(infoList); } } catch { TBL_RUNNOTE[] nullInfo = new TBL_RUNNOTE[0]; return(nullInfo); } }
/// <summary> /// 修改TBL_RUNNOTE表的数据 /// </summary> /// <param name="whereLambda"> (u=>u.siteId == info.siteId, info) == true </param> /// <param name="whereLambda"> (u=>u.ammeterId == info.ammeterId, info) == true </param> /// 判断有无siteId 或者 有无ammeter /// <param name="info"> info是需要修改的信息 </param> /// <notice></notice> public static Boolean UpdateRunnoteInfo(Expression <Func <TBL_RUNNOTE, bool> > whereLambda, TBL_RUNNOTE info) { try { using (LampNetEntities db = new LampNetEntities()) { DbQuery <TBL_RUNNOTE> dataObject = db.TBL_RUNNOTE.Where(whereLambda) as DbQuery <TBL_RUNNOTE>; TBL_RUNNOTE oldInfo = dataObject.FirstOrDefault(); oldInfo.runnoteAlastatus = info.runnoteAlastatus; oldInfo.runnoteAlatime = info.runnoteAlatime; db.SaveChanges(); return(true); } } catch { return(false); } }