public void SingleSettingGroupUpdate(TBL_AMMETER info)
{
try
{
HttpCookie cookie = Request.Cookies["userId"];
if (cookie.Name != null)
{
ViewBag.user = cookie.Value;
}
if (UpdateTools.UpdateAmmeterInfo(u => u.ammeterId == info.ammeterId, info) == true)
{
Response.Write("<script language='javascript'>alert('更新成功！');</script>");
Response.Redirect("/SingleControl/SingleSettingGroup");
}
else
{
Response.Write("<script language='javascript'>alert('更新失败！');</script>");
Response.Redirect("/SingleControl/SingleSettingGroup");
}
}
catch
{
Response.Write("<script language='javascript'>alert('更新出错！');</script>");
Response.Redirect("/SingleControl/SingleSettingGroup");
}
}
/// <summary>
/// 修改TBL_AMMETER表的数据
/// </summary>
/// <param name="whereLambda"> (u=>u.ammeterId == info.ammeterId, info) == true </param>
/// 判断有无ammeterId
/// <param name="info"> info是需要修改的信息 </param>
/// <notice></notice>
public static Boolean UpdateAmmeterInfo(Expression <Func <TBL_AMMETER, bool> > whereLambda, TBL_AMMETER info)
{
try
{
using (LampNetEntities db = new LampNetEntities())
{
DbQuery <TBL_AMMETER> dataObject = db.TBL_AMMETER.Where(whereLambda) as DbQuery <TBL_AMMETER>;
TBL_AMMETER oldInfo = dataObject.FirstOrDefault();
oldInfo.siteId = info.siteId;
oldInfo.ammeterName = info.ammeterName;
oldInfo.ammeterGroup = info.ammeterGroup;
oldInfo.ammeterModel = info.ammeterModel;
oldInfo.ammeterRefpower = info.ammeterRefpower;
oldInfo.ammeterOldload = info.ammeterOldload;
oldInfo.ammeterNewload = info.ammeterNewload;
oldInfo.ammeterRate = info.ammeterRate;
oldInfo.ammeterAlarm = info.ammeterAlarm;
oldInfo.ammeterStatus = info.ammeterStatus;
oldInfo.ammeterSwistatus = info.ammeterSwistatus;
oldInfo.ammeterLife = info.ammeterLife;
oldInfo.ammeterAcctime = info.ammeterAcctime;
oldInfo.ammeterNote = info.ammeterNote;
db.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}
public ActionResult SingleSettingInspectionSelect(TBL_AMMETER info)
{
try
{
if (info.ammeterId != 0)
{
TBL_SIGCONTROL[] array = SelectTools.SelectSigcontrolInfo(u => u.ammeterId == info.ammeterId, u => u.ammeterId);
TBL_AMMETER[] ammeter = SelectTools.SelectAmmeterInfo(u => u.ammeterId == u.ammeterId, u => u.ammeterId);
if (array == null || array.Length == 0)
{
return(Content("没有此展示！"));
}
TBL_SIGCONTROL[] allInfo = SelectTools.SelectSigcontrolInfo(u => u.ammeterId == u.ammeterId, u => u.ammeterId);
ViewBag.allInfo = allInfo;
ViewBag.ammeter = ammeter;
ViewBag.array = array;
HttpCookie cookie = Request.Cookies["userId"];
if (cookie.Name != null)
{
ViewBag.user = cookie.Value;
}
return(View());
}
else
{
TBL_AMMETER[] amt = SelectTools.SelectAmmeterInfo(u => u.ammeterName == info.ammeterName, u => u.ammeterId);
int id = amt[0].ammeterId;
TBL_SIGCONTROL[] array = SelectTools.SelectSigcontrolInfo(u => u.ammeterId == id, u => u.ammeterId);
TBL_AMMETER[] ammeter = SelectTools.SelectAmmeterInfo(u => u.ammeterId == u.ammeterId, u => u.ammeterId);
if (array == null || array.Length == 0)
{
return(Content("没有此展示！"));
}
TBL_SIGCONTROL[] allInfo = SelectTools.SelectSigcontrolInfo(u => u.ammeterId == u.ammeterId, u => u.ammeterId);
ViewBag.allInfo = allInfo;
ViewBag.ammeter = ammeter;
ViewBag.array = array;
HttpCookie cookie = Request.Cookies["userId"];
if (cookie.Name != null)
{
ViewBag.user = cookie.Value;
}
return(View());
}
}
catch
{
return(Content("查询失败！（ERROR）"));
}
}
/// <summary>
/// 往电表信息表中插入数据
/// </summary>
/// <param name="info">前端页面输入的信息</param>
/// <returns></returns>
public static Boolean InsertAmmeterInfo(TBL_AMMETER info)
{
try
{
using (LampNetEntities db = new LampNetEntities())
{
db.TBL_AMMETER.Add(info);
db.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}
/// <summary>
/// 查找电表信息表中符合条件的信息
/// </summary>
/// <param name="whereLambda">u => u.ammeterId == info.ammeterId, u => u.ammeterId</param>
/// <returns>电表信息数组</returns>
public static TBL_AMMETER[] SelectAmmeterInfo <TKey>(Expression <Func <TBL_AMMETER, bool> > whereLambda, Expression <Func <TBL_AMMETER, TKey> > orderBy)
{
try
{
using (LampNetEntities db = new LampNetEntities())
{
DbQuery <TBL_AMMETER> dataObject = db.TBL_AMMETER.Where(whereLambda).OrderBy(orderBy) as DbQuery <TBL_AMMETER>;
TBL_AMMETER[] infoList = dataObject.ToArray();
return(infoList);
}
}
catch
{
TBL_AMMETER[] nullInfo = new TBL_AMMETER[0];
return(nullInfo);
}
}
public void AmmeterUpdate(TBL_AMMETER info)
{
try
{
if (UpdateTools.UpdateAmmeterInfo(u => u.ammeterId == info.ammeterId, info) == true)
{
Response.Write("<script>alert('更新成功！');</script>");
Response.Redirect("/AmmeterManagement/Index");
}
else
{
Response.Write("<script>alert('不存在更新内容！');</script>");
Response.Redirect("/AmmeterManagement/Index");
}
}
catch
{
Response.Write("<script>alert('更新失败！');</script>");
Response.Redirect("/AmmeterManagement/Index");
}
}
public ActionResult AmmeterSelect(TBL_AMMETER ammeter)
{
try
{
if (ammeter.ammeterId != 0)
{
int sumPage = GetSumPage(30);
int nowPage = 1;
TBL_AMMETER[] allInfo = GetPagedList(1, 30, u => u.ammeterId == u.ammeterId, u => u.ammeterId);
ViewBag.nowPage = nowPage;
ViewBag.sumPage = sumPage;
TBL_AMMETER[] info = SelectTools.SelectAmmeterInfo(u => u.ammeterId == ammeter.ammeterId, u => u.ammeterId);
if (info == null || info.Length == 0)
{
return(Content("没有此展示！"));
}
ArrayList SiteList = new ArrayList();
foreach (var item in info)
{
//依次获得站点名
int siteId = Convert.ToInt32(item.siteId);
TBL_SITE[] siteName = SelectTools.SelectSiteInfo(u => u.siteId == siteId, u => u.siteId);
if (siteName != null && siteName.Length != 0)
{
SiteList.Add(siteName[0].siteName);
}
else
{
SiteList.Add("【出错数据】");
}
}
if (Request.Cookies["userId"] != null)
{
string user = Request.Cookies["userId"].Value;//输出全部的值
ViewBag.user = user;
}
ViewBag.SiteName = SiteList;
ViewBag.allInfo = allInfo;
ViewBag.info = info;
return(View());
}
else
{
int sumPage = GetSumPage(30);
int nowPage = 1;
TBL_AMMETER[] allInfo = GetPagedList(1, 30, u => u.ammeterId == u.ammeterId, u => u.ammeterId);
ViewBag.nowPage = nowPage;
ViewBag.sumPage = sumPage;
TBL_AMMETER[] info = SelectTools.SelectAmmeterInfo(u => u.ammeterName == ammeter.ammeterName, u => u.ammeterId);
if (info == null || info.Length == 0)
{
return(Content("没有此展示！"));
}
ArrayList SiteList = new ArrayList();
foreach (var item in info)
{
//依次获得站点名
int siteId = Convert.ToInt32(item.siteId);
TBL_SITE[] siteName = SelectTools.SelectSiteInfo(u => u.siteId == siteId, u => u.siteId);
if (siteName != null && siteName.Length != 0)
{
SiteList.Add(siteName[0].siteName);
}
else
{
SiteList.Add("【出错数据】");
}
}
if (Request.Cookies["userId"] != null)
{
string user = Request.Cookies["userId"].Value;//输出全部的值
ViewBag.user = user;
}
ViewBag.SiteName = SiteList;
ViewBag.allInfo = allInfo;
ViewBag.info = info;
return(View());
}
}
catch
{
return(Content("查询失败！（ERROR）"));
}
}
