/// <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);
}
}
