// GET: ProtectDataDevice
public ActionResult Index()
{
int sumPage = GetSumPage(30);
int nowPage = 1;
TBL_DEVICEPROTECT[] ProtectDeviceInfo = GetPagedList(1, 30, u => u.userId == u.userId, u => u.userId);
ViewBag.ProtectDeviceInfo = ProtectDeviceInfo;
ViewBag.nowPage = nowPage;
ViewBag.sumPage = sumPage;
TBL_SITE[] siteInfo = SelectTools.SelectSiteInfo(u => u.siteId == u.siteId, u => u.siteId);
TBL_AMMETER[] ammeterInfo = SelectTools.SelectAmmeterInfo(u => u.ammeterId == u.ammeterId, u => u.ammeterId);
TBL_USER[] userInfo = SelectTools.SelectUserInfo(u => u.userId == u.userId, u => u.userId);
ViewBag.userInfo = userInfo;
ViewBag.siteInfo = siteInfo;
ViewBag.ammeterInfo = ammeterInfo;
HttpCookie cookie = Request.Cookies["userId"];
if (cookie.Name != null)
{
ViewBag.user = cookie.Value;
}
return(View());
}
// GET: Feedback
public ActionResult Index()
{
int sumPage = GetSumPage(10);
int nowPage = 1;
TBL_FEEDBACK[] feedbackInfo = GetPagedList(1, 10, u => u.userId == u.userId, u => u.userId);
if (feedbackInfo == null || feedbackInfo.Count() == 0)
{
Response.Write("<script>alert('无查询信息！');</script>");
}
ViewBag.feedbackInfo = feedbackInfo;
ViewBag.nowPage = nowPage;
ViewBag.sumPage = sumPage;
TBL_USER[] userInfo = SelectTools.SelectUserInfo(u => u.userId == u.userId, u => u.userId);
if (Request.Cookies["userId"] != null)
{
string user = Request.Cookies["userId"].Value;//输出全部的值
ViewBag.user = user;
}
ViewBag.userInfo = userInfo;
HttpCookie cookie = Request.Cookies["userId"];
if (cookie.Name != null)
{
ViewBag.user = cookie.Value;
}
return(View());
}
public ActionResult FeedbackInput(int userId)
{
if (userId == 0)
{
return(View("Index"));
}
else
{
TBL_FEEDBACK[] feedbackInfo = SelectTools.SelectFeedbackInfo(u => u.userId == userId, u => u.userId);
if (feedbackInfo == null || feedbackInfo.Count() == 0)
{
Response.Write("<script>alert('无查询信息！');</script>");
}
ViewBag.feedbackInfo = feedbackInfo;
if (Request.Cookies["userId"] != null)
{
string user = Request.Cookies["userId"].Value;//输出全部的值
ViewBag.user = user;
}
TBL_USER[] userInfo = SelectTools.SelectUserInfo(u => u.userId == u.userId, u => u.userId);
ViewBag.userInfo = userInfo;
HttpCookie cookie = Request.Cookies["userId"];
if (cookie.Name != null)
{
ViewBag.user = cookie.Value;
}
return(View());
}
}
public ActionResult UserSelect(TBL_USER user)
{
try
{
if (user.userId != 0)
{
int sumPage = GetSumPage(30);
int nowPage = 1;
TBL_USER[] allInfo = GetPagedList(1, 30, u => u.userId == u.userId, u => u.userId);
ViewBag.nowPage = nowPage;
ViewBag.sumPage = sumPage;
TBL_USER[] info = SelectTools.SelectUserInfo(u => u.userId == user.userId, u => u.userId);
if (info == null || info.Length == 0)
{
return(Content("没有此展示！"));
}
ViewBag.allInfo = allInfo;
ViewBag.info = info;
HttpCookie cookie = Request.Cookies["userId"];
if (cookie.Name != null)
{
ViewBag.user = cookie.Value;
}
return(View());
}
else
{
int sumPage = GetSumPage(30);
int nowPage = 1;
TBL_USER[] allInfo = GetPagedList(1, 30, u => u.userId == u.userId, u => u.userId);
ViewBag.nowPage = nowPage;
ViewBag.sumPage = sumPage;
TBL_USER[] info = SelectTools.SelectUserInfo(u => u.userName == user.userName, u => u.userId);
if (info == null || info.Length == 0)
{
return(Content("没有此展示！"));
}
ViewBag.allInfo = allInfo;
ViewBag.info = info;
HttpCookie cookie = Request.Cookies["userId"];
if (cookie.Name != null)
{
ViewBag.user = cookie.Value;
}
return(View());
}
}
catch
{
return(Content("查询失败！（ERROR）"));
}
}
// GET: UserManagement
public ActionResult Index()
{
int sumPage = GetSumPage(30);
int nowPage = 1;
TBL_USER[] allInfo = GetPagedList(1, 30, u => u.userId == u.userId, u => u.userId);
ViewBag.nowPage = nowPage;
ViewBag.sumPage = sumPage;
TBL_USER[] array = SelectTools.SelectUserInfo(u => u.userId == u.userId, u => u.userId);
ViewBag.array = array;
HttpCookie cookie = Request.Cookies["userId"];
if (cookie.Name != null)
{
ViewBag.user = cookie.Value;
}
return(View());
}
public ActionResult ProtectDataUserSelect(TBL_USERPROTECT table)
{
try
{
if (table.userId != 0)
{
//如果有站点号，按照站点号查找
int sumPage = GetSumPage(30);
int nowPage = 1;
TBL_USERPROTECT[] ProtectUserInfo = GetPagedList(1, 30, u => u.userId == table.userId, u => u.userId);
ViewBag.nowPage = nowPage;
ViewBag.sumPage = sumPage;
TBL_USER[] userInfo = SelectTools.SelectUserInfo(u => u.userId == u.userId, u => u.userId);
if (userInfo == null || userInfo.Length == 0)
{
return(Content("没有此展示！"));
}
ViewBag.ProtectUserInfo = ProtectUserInfo;
ViewBag.userInfo = userInfo;
HttpCookie cookie = Request.Cookies["userId"];
if (cookie.Name != null)
{
ViewBag.user = cookie.Value;
}
return(View());
}
else if (table.userprotectKind != -1)
{
//如果输入了时间，按时间查找
int sumPage = GetSumPage(30);
int nowPage = 1;
TBL_USERPROTECT[] ProtectUserInfo = GetPagedList(1, 30, u => u.userprotectKind == table.userprotectKind, u => u.userId);
ViewBag.nowPage = nowPage;
ViewBag.sumPage = sumPage;
TBL_USER[] userInfo = SelectTools.SelectUserInfo(u => u.userId == u.userId, u => u.userId);
if (userInfo == null || userInfo.Length == 0)
{
return(Content("没有此展示！"));
}
ViewBag.ProtectUserInfo = ProtectUserInfo;
ViewBag.userInfo = userInfo;
HttpCookie cookie = Request.Cookies["userId"];
if (cookie.Name != null)
{
ViewBag.user = cookie.Value;
}
return(View());
}
else if (table.userprotectModule != -1)
{
//如果没有时间和站点号，则按照名称查找
int sumPage = GetSumPage(30);
int nowPage = 1;
TBL_USERPROTECT[] ProtectUserInfo = GetPagedList(1, 30, u => u.userprotectModule == table.userprotectModule, u => u.userId);
ViewBag.nowPage = nowPage;
ViewBag.sumPage = sumPage;
TBL_USER[] userInfo = SelectTools.SelectUserInfo(u => u.userId == u.userId, u => u.userId);
if (userInfo == null || userInfo.Length == 0)
{
return(Content("没有此展示！"));
}
ViewBag.ProtectUserInfo = ProtectUserInfo;
ViewBag.userInfo = userInfo;
HttpCookie cookie = Request.Cookies["userId"];
if (cookie.Name != null)
{
ViewBag.user = cookie.Value;
}
return(View());
}
else
{
return(Content("查询信息为空！"));
}
}
catch
{
return(Content("查询失败！（ERROR）"));
}
}
public ActionResult ProtectDataDeviceSelect(TBL_DEVICEPROTECT table)
{
try
{
if (table.userId != 0)
{
//按照用户号查找
int sumPage = GetSumPage(30);
int nowPage = 1;
TBL_DEVICEPROTECT[] ProtectDeviceInfo = GetPagedList(1, 30, u => u.userId == table.userId, u => u.userId);
ViewBag.nowPage = nowPage;
ViewBag.sumPage = sumPage;
TBL_SITE[] siteInfo = SelectTools.SelectSiteInfo(u => u.siteId == u.siteId, u => u.siteId);
TBL_AMMETER[] ammeterInfo = SelectTools.SelectAmmeterInfo(u => u.ammeterId == u.ammeterId, u => u.ammeterId);
TBL_USER[] userInfo = SelectTools.SelectUserInfo(u => u.userId == u.userId, u => u.userId);
ViewBag.userInfo = userInfo;
ViewBag.siteInfo = siteInfo;
ViewBag.ammeterInfo = ammeterInfo;
ViewBag.ProtectDeviceInfo = ProtectDeviceInfo;
HttpCookie cookie = Request.Cookies["userId"];
if (cookie.Name != null)
{
ViewBag.user = cookie.Value;
}
return(View());
}
else if (table.siteId != -1)
{
//按站点查找
int sumPage = GetSumPage(30);
int nowPage = 1;
TBL_DEVICEPROTECT[] ProtectDeviceInfo = GetPagedList(1, 30, u => u.siteId == table.siteId, u => u.siteId);
ViewBag.nowPage = nowPage;
ViewBag.sumPage = sumPage;
TBL_SITE[] siteInfo = SelectTools.SelectSiteInfo(u => u.siteId == u.siteId, u => u.siteId);
TBL_AMMETER[] ammeterInfo = SelectTools.SelectAmmeterInfo(u => u.ammeterId == u.ammeterId, u => u.ammeterId);
TBL_USER[] userInfo = SelectTools.SelectUserInfo(u => u.userId == u.userId, u => u.userId);
ViewBag.userInfo = userInfo;
ViewBag.siteInfo = siteInfo;
ViewBag.ammeterInfo = ammeterInfo;
ViewBag.ProtectDeviceInfo = ProtectDeviceInfo;
HttpCookie cookie = Request.Cookies["userId"];
if (cookie.Name != null)
{
ViewBag.user = cookie.Value;
}
return(View());
}
else if (table.ammeterId != -1)
{
//按照电表查找
int sumPage = GetSumPage(30);
int nowPage = 1;
TBL_DEVICEPROTECT[] ProtectDeviceInfo = GetPagedList(1, 30, u => u.ammeterId == table.ammeterId, u => u.ammeterId);
ViewBag.nowPage = nowPage;
ViewBag.sumPage = sumPage;
TBL_SITE[] siteInfo = SelectTools.SelectSiteInfo(u => u.siteId == u.siteId, u => u.siteId);
TBL_AMMETER[] ammeterInfo = SelectTools.SelectAmmeterInfo(u => u.ammeterId == u.ammeterId, u => u.ammeterId);
TBL_USER[] userInfo = SelectTools.SelectUserInfo(u => u.userId == u.userId, u => u.userId);
ViewBag.userInfo = userInfo;
ViewBag.siteInfo = siteInfo;
ViewBag.ammeterInfo = ammeterInfo;
ViewBag.ProtectDeviceInfo = ProtectDeviceInfo;
HttpCookie cookie = Request.Cookies["userId"];
if (cookie.Name != null)
{
ViewBag.user = cookie.Value;
}
return(View());
}
else if (table.deviceprotectKind != -1)
{
//按照电表查找
int sumPage = GetSumPage(30);
int nowPage = 1;
TBL_DEVICEPROTECT[] ProtectDeviceInfo = GetPagedList(1, 30, u => u.deviceprotectKind == table.deviceprotectKind, u => u.userId);
ViewBag.nowPage = nowPage;
ViewBag.sumPage = sumPage;
TBL_SITE[] siteInfo = SelectTools.SelectSiteInfo(u => u.siteId == u.siteId, u => u.siteId);
TBL_AMMETER[] ammeterInfo = SelectTools.SelectAmmeterInfo(u => u.ammeterId == u.ammeterId, u => u.ammeterId);
TBL_USER[] userInfo = SelectTools.SelectUserInfo(u => u.userId == u.userId, u => u.userId);
ViewBag.userInfo = userInfo;
ViewBag.siteInfo = siteInfo;
ViewBag.ammeterInfo = ammeterInfo;
ViewBag.ProtectDeviceInfo = ProtectDeviceInfo;
HttpCookie cookie = Request.Cookies["userId"];
if (cookie.Name != null)
{
ViewBag.user = cookie.Value;
}
return(View());
}
else if (table.deviceprotectModule != -1)
{
//按照电表查找
int sumPage = GetSumPage(30);
int nowPage = 1;
TBL_DEVICEPROTECT[] ProtectDeviceInfo = GetPagedList(1, 30, u => u.deviceprotectModule == table.deviceprotectModule, u => u.userId);
ViewBag.nowPage = nowPage;
ViewBag.sumPage = sumPage;
TBL_SITE[] siteInfo = SelectTools.SelectSiteInfo(u => u.siteId == u.siteId, u => u.siteId);
TBL_AMMETER[] ammeterInfo = SelectTools.SelectAmmeterInfo(u => u.ammeterId == u.ammeterId, u => u.ammeterId);
TBL_USER[] userInfo = SelectTools.SelectUserInfo(u => u.userId == u.userId, u => u.userId);
ViewBag.userInfo = userInfo;
ViewBag.siteInfo = siteInfo;
ViewBag.ammeterInfo = ammeterInfo;
ViewBag.ProtectDeviceInfo = ProtectDeviceInfo;
HttpCookie cookie = Request.Cookies["userId"];
if (cookie.Name != null)
{
ViewBag.user = cookie.Value;
}
return(View());
}
else
{
return(Content("查询信息为空！"));
}
}
catch
{
return(Content("查询失败！（ERROR）"));
}
}
public ActionResult FeedbackSelect(TBL_USER user)
{
try
{
if (user.userId != 0)
{
int sumPage = GetSumPage(10);
int nowPage = 1;
TBL_FEEDBACK[] info = GetPagedList(1, 10, u => u.userId == user.userId, u => u.userId);
ViewBag.nowPage = nowPage;
ViewBag.sumPage = sumPage;
TBL_USER[] allUserInfo = SelectTools.SelectUserInfo(u => u.userId == u.userId, u => u.userId);
TBL_FEEDBACK[] allInfo = GetPagedList(1, 10, u => u.userId == u.userId, u => u.userId);
if (info == null || info.Length == 0)
{
return(Content("没有此展示！"));
}
if (Request.Cookies["userId"] != null)
{
string userName = Request.Cookies["userId"].Value;//输出全部的值
ViewBag.user = userName;
}
ViewBag.allInfo = allInfo;
ViewBag.allUserInfo = allUserInfo;
ViewBag.info = info;
HttpCookie cookie = Request.Cookies["userId"];
if (cookie.Name != null)
{
ViewBag.user = cookie.Value;
}
return(View());
}
else
{
int sumPage = GetSumPage(10);
int nowPage = 1;
TBL_USER[] userId = SelectTools.SelectUserInfo(u => u.userName == user.userName, u => u.userId);
int id = userId[0].userId;
TBL_FEEDBACK[] info = GetPagedList(1, 10, u => u.userId == id, u => u.userId);
TBL_FEEDBACK[] allInfo = GetPagedList(1, 10, u => u.userId == u.userId, u => u.userId);
ViewBag.nowPage = nowPage;
ViewBag.sumPage = sumPage;
TBL_USER[] allUserInfo = SelectTools.SelectUserInfo(u => u.userId == u.userId, u => u.userId);
if (info == null || info.Length == 0)
{
return(Content("没有此展示！"));
}
if (Request.Cookies["userId"] != null)
{
string userName = Request.Cookies["userId"].Value;//输出全部的值
ViewBag.user = userName;
}
ViewBag.allInfo = allInfo;
ViewBag.allUserInfo = allUserInfo;
ViewBag.info = info;
HttpCookie cookie = Request.Cookies["userId"];
if (cookie.Name != null)
{
ViewBag.user = cookie.Value;
}
return(View());
}
}
catch
{
return(Content("查询失败！（ERROR）"));
}
}
