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