public async Task <ActionResult> Delete(string id)
{
string name, error, loginName;
if (CookieHelper.HasCookie(out name, out error) == false)
{
return(RedirectToAction("", "LoginUI"));
}
else
{
new RoleHelper().GetRoles(name, out role, out department1Code, out loginName);
ViewData["VisitorRole"] = role;
ViewData["username"] = loginName;
}
if (string.IsNullOrEmpty(id))
{
return(RedirectToAction("Index", "LoginUI"));
}
long pwdID = 0;
if (long.TryParse(id, out pwdID) == false)
{
return(Content("入参错误", "text/html"));
}
using (mlrmsEntities db = new mlrmsEntities())
{
sysadmin matchOne = db.sysadmin.Where(m => m.AdminID == pwdID).ToList().First();
db.sysadmin.Attach(matchOne);
db.Entry(matchOne).State = System.Data.Entity.EntityState.Deleted;
await db.SaveChangesAsync();
return(RedirectToAction("", "administrator"));
}
}
public ActionResult Reset(string id)
{
try
{
using (mlrmsEntities db = new mlrmsEntities())
{
int ID = int.Parse(id);
var usr = db.sysadmin.Where(m => m.AdminID == ID).First();
usr.AdminPwd = EncryptHelper.GetEncrypt("123456");
db.sysadmin.Attach(usr);
db.Entry(usr).State = System.Data.Entity.EntityState.Modified;
int result = db.SaveChanges();
if (result > 0)
{
return(Content("True", "text/html"));
}
else
{
return(Content("False", "text/html"));
}
}
}
catch (Exception ex)
{
LogHelper.Error("密码重置出错:" + ex.Message);
return(Content("False", "text/html"));
}
}
public async Task <ActionResult> Delete(string id, string serialCode, string port)
{
string name, error, loginName;
if (CookieHelper.HasCookie(out name, out error) == false)
{
return(RedirectToAction("", "LoginUI"));
}
else
{
new RoleHelper().GetRoles(name, out role, out department1Code, out loginName);
ViewData["VisitorRole"] = role;
ViewData["username"] = loginName;
}
if (string.IsNullOrEmpty(id))
{
return(RedirectToAction("Index", "Device"));
}
int slaveID = int.Parse(id);
int servicePort = int.Parse(port);
using (mlrmsEntities db = new mlrmsEntities())
{
device matchOne = db.device.Where(m => m.slaveid == slaveID && m.servicecode == serialCode && m.port == servicePort).ToList().First();
db.device.Attach(matchOne);
db.Entry(matchOne).State = System.Data.Entity.EntityState.Deleted;
await db.SaveChangesAsync();
//通知客户端已经移除；
MvcApplication.Client.Refresh(slaveID, false);
}
return(RedirectToAction("Index", "Device"));
}
public ActionResult Index()
{
string name, error, loginName;
if (CookieHelper.HasCookie(out name, out error) == false)
{
return(RedirectToAction("", "LoginUI"));
}
else
{
new RoleHelper().GetRoles(name, out role, out department1Code, out loginName);
ViewData["VisitorRole"] = role;
ViewData["username"] = loginName;
}
using (mlrmsEntities db = new mlrmsEntities())
{
var userList = db.sysadmin.Where(m => m.AdminCode == name);
if (userList == null || userList.Count() <= 0)
{
return(Content("Not Found", "text/html"));
}
sysadmin item = userList.First();
Manager manager = new Manager();
manager.UserCode = item.AdminCode;
manager.UserName = item.AdminName;
manager.AdminId = item.AdminID;
return(View(manager));
}
}
public List <ElectricParas> GetAllAttendanceInfos(string beginTime1, string endTime1, string searchkey, string slaveCode)
{
DateTime dtStart = DateTime.Parse(beginTime1);
DateTime dtEnd = DateTime.Parse(endTime1);
int slaveID = int.Parse(slaveCode);
List <ElectricParas> attendances = new List <ElectricParas>();
try
{
using (mlrmsEntities db = new mlrmsEntities())
{
IQueryable <ElectricParas> dynamicAttendance = null;
if (slaveCode != "0")
{
dynamicAttendance = (from dev in db.device
join itm in db.eletricmeterstatistics
on dev.slaveid equals itm.slaveid
where dev.type == 4
where (dev.slaveid == slaveID)
where (itm.time >= dtStart && itm.time <= dtEnd)
//where (dev.name.ToLower().Contains(searchkey.ToLower()))
select new ElectricParas
{
electricAmount = itm.eletricamount,
slaveID = itm.slaveid,
name = dev.name,
time = itm.time,
}).OrderByDescending(m => m.time);
}
else
{
dynamicAttendance = (from dev in db.device
join itm in db.eletricmeterstatistics
on dev.slaveid equals itm.slaveid
where dev.type == 4
where (itm.time >= dtStart && itm.time <= dtEnd)
//where (dev.name.ToLower().Contains(searchkey.ToLower()))
select new ElectricParas
{
electricAmount = itm.eletricamount,
slaveID = itm.slaveid,
name = dev.name,
time = itm.time,
}).OrderByDescending(m => m.time);
}
attendances = dynamicAttendance.ToList();
if (attendances == null || attendances.Count == 0)
{
return(null);
}
}
}
catch (Exception ex)
{
LogHelper.Error("获取用电量信息失败", ex);
}
return(attendances);
}
// GET: SerialPort
public ActionResult Index(string searchkey, string index)
{
string name, error;
if (CookieHelper.HasCookie(out name, out error) == false)
{
return(RedirectToAction("", "LoginUI"));
}
else
{
new RoleHelper().GetRoles(name, out role, out department1Code, out LoginName);
ViewData["VisitorRole"] = role;
ViewData["username"] = LoginName;
}
if (string.IsNullOrEmpty(index))
{
index = "1";
}
if (searchkey == string.Empty)
{
return(RedirectToAction("", "Device"));
}
if (searchkey == null)
{
searchkey = string.Empty;
}
DeviceQueryCondition condition = new DeviceQueryCondition();
condition.searchkey = searchkey;
ViewData["requestData"] = condition;
List <serialservice> totalList = null;
try
{
using (mlrmsEntities db = new mlrmsEntities())
{
int totalCount = db.serialservice.Count();
if (totalCount == 0)
{
return(View());
}
PageModel page = new PageModel()
{
SearchKeyWord = searchkey, SearchType = 0, CurrentIndex = Int32.Parse(index), TotalCount = totalCount
};
totalList = db.serialservice.Where(p => p.name.ToLower().Contains(searchkey.ToLower()) || p.code.ToString().Contains(searchkey.ToLower())).OrderBy(m => m.name).Skip((page.CurrentIndex - 1) * page.PageSize).Take(page.PageSize).ToList();
ViewData["pagemodel"] = page;
return(View(totalList));
}
}
catch (Exception ex)
{
LogHelper.Error("设备列表加载失败", ex);
return(View());
}
}
public async Task <ActionResult> Index(Manager info)
{
string name, error, loginName;
if (CookieHelper.HasCookie(out name, out error) == false)
{
return(RedirectToAction("", "LoginUI"));
}
else
{
new RoleHelper().GetRoles(name, out role, out department1Code, out loginName);
ViewData["VisitorRole"] = role;
ViewData["username"] = loginName;
}
try
{
if (ModelState.IsValid)
{
using (mlrmsEntities db = new mlrmsEntities())
{
var userList = db.sysadmin.Where(m => m.AdminID == info.AdminId);
if (userList == null || userList.Count() <= 0)
{
return(Content("Not Found", "text/html"));
}
sysadmin item = userList.First();
string pwd = EncryptHelper.GetEncrypt(info.Passwd);
if (pwd != item.AdminPwd) //如果密码验证不通过
{
ModelState.AddModelError("Passwd", "密码错误");
return(View());
}
item.AdminPwd = EncryptHelper.GetEncrypt(info.NewPwd);
db.sysadmin.Attach(item);
db.Entry(item).State = System.Data.Entity.EntityState.Modified;
await db.SaveChangesAsync();
ViewData["status"] = "true";
return(RedirectToAction("Logout", "LoginUI"));
}
}
}
catch
{
ViewData["status"] = "false";
}
Manager manager = new Manager();
manager.UserName = info.UserName;
//系统登出
return(View(manager));
}
public ActionResult Operate(string id)
{
string name, error, loginName;
DeviceInfo info = null;
if (CookieHelper.HasCookie(out name, out error) == false)
{
return(RedirectToAction("", "LoginUI"));
}
else
{
new RoleHelper().GetRoles(name, out role, out department1Code, out loginName);
ViewData["VisitorRole"] = role;
ViewData["username"] = loginName;
}
try
{
string[] ss = id.Split('#');
int slaveID = int.Parse(ss[0]);
string serialCode = ss[1];
int serialPort = int.Parse(ss[2]);
using (mlrmsEntities db = new mlrmsEntities())
{
info = (from dev in db.device
where dev.slaveid == slaveID && dev.port == serialPort && dev.servicecode == serialCode
select new DeviceInfo
{
slaveID = dev.slaveid,
note = dev.note,
devName = dev.name,
type = dev.type,
subType = (int)dev.subtype,
}).First();
}
if (info != null)
{
info.subTypeName = EnumParser.SubTypeParser(info.subType);
}
EngineData data = HashGetEngineData.GetData(slaveID);
info.runStatus = data.State;
info.SetMode = data.Mode.ToString();
info.SetTemp = data.Temp.ToString();
}
catch (Exception ex)
{
LogHelper.Error("打开配置页面失败", ex);
}
return(View(info));
}
public ActionResult Index(sysadmin user)
{
if (string.IsNullOrEmpty(user.AdminCode))
{
return(Content("false:用户名不能为空", "text/html"));
}
if (string.IsNullOrEmpty(user.AdminPwd))
{
return(Content("false:密码不能为空", "text/html"));
}
if (user.AdminCode.Length > 30)
{
return(Content("false:用户名长度不能超过30", "text/html"));
}
if (user.AdminPwd.Length > 32)
{
return(Content("false:密码长度不能超过32", "text/html"));
}
string encryptStr = EncryptHelper.GetEncrypt(user.AdminPwd);
try
{
using (mlrmsEntities db = new mlrmsEntities())
{
if (db.sysadmin.Where(m => (m.AdminCode == user.AdminCode) && (m.AdminPwd == encryptStr)).Count() > 0)
{
System.Text.Encoding enc = System.Text.Encoding.GetEncoding("gb2312");
string encodeStr = HttpUtility.UrlEncode(user.AdminCode, enc);
System.Web.HttpCookie authCookie = new System.Web.HttpCookie("bemlogin", encodeStr);
authCookie.Expires = DateTime.Now.AddMinutes(30);
System.Web.HttpContext.Current.Response.Cookies.Add(authCookie);
//return RedirectToAction("Index", "Device");
return(Content("true:登录成功", "text/html"));
}
else
{
return(Content("false:用户名或密码错误", "text/html"));
}
}
}
catch (Exception ex)
{
LogHelper.Error("系统登录失败", ex);
return(Content("false:数据库连接失败，请检查配置", "text/html"));
}
}
public async Task <ActionResult> Create(NewAdmin info)
{
string name, error, loginName;
if (CookieHelper.HasCookie(out name, out error) == false)
{
return(RedirectToAction("", "LoginUI"));
}
else
{
new RoleHelper().GetRoles(name, out role, out department1Code, out loginName);
ViewData["VisitorRole"] = role;
ViewData["username"] = loginName;
}
try
{
using (mlrmsEntities db = new mlrmsEntities())
{
var userList = db.sysadmin.Where(m => m.AdminCode == info.UserCode);
if (userList.Count() > 0)
{
ModelState.AddModelError("UserCode", "该管理员已存在");
return(View(info));
}
sysadmin item = new sysadmin();
item.AdminName = info.UserName;
item.CreateDate = DateTime.Now;
item.AdminCode = info.UserCode;
item.AdminType = 1;
item.AdminPwd = EncryptHelper.GetEncrypt("123456");
db.sysadmin.Add(item);
int result = await db.SaveChangesAsync();
return(RedirectToAction("", "administrator"));
}
}
catch (Exception ex)
{
LogHelper.Error("创建管理员失败", ex);
ViewData["status"] = "false";
}
return(View(info));
}
public ActionResult Index()
{
string name, error, loginName;
if (CookieHelper.HasCookie(out name, out error) == false)
{
return(RedirectToAction("", "LoginUI"));
}
else
{
new RoleHelper().GetRoles(name, out role, out department1Code, out loginName);
ViewData["VisitorRole"] = role;
ViewData["username"] = loginName;
}
try
{
using (mlrmsEntities db = new mlrmsEntities())
{
//读取非超级管理员
var userList = from adm in db.sysadmin
where adm.AdminType != 0
select new SysAdminEx
{
AdminID = adm.AdminID,
AdminCode = adm.AdminCode,
AdminName = adm.AdminName,
AdminPwd = adm.AdminPwd,
AdminType = adm.AdminType,
CreateDate = adm.CreateDate
};
if (userList.Count() <= 0)
{
return(View());
}
return(View(userList.ToList()));
}
}
catch (Exception ex)
{
LogHelper.Error("数据库读取失败", ex);
return(Content("数据库读取失败"));
}
}
public async Task <ActionResult> Delete(string id)
{
string name, error, loginName;
if (CookieHelper.HasCookie(out name, out error) == false)
{
return(RedirectToAction("", "LoginUI"));
}
else
{
new RoleHelper().GetRoles(name, out role, out department1Code, out loginName);
ViewData["VisitorRole"] = role;
ViewData["username"] = loginName;
}
if (string.IsNullOrEmpty(id))
{
return(RedirectToAction("Index", "serialport"));
}
try
{
using (mlrmsEntities db = new mlrmsEntities())
{
if (db.device.Where(m => m.servicecode == id).Count() > 0)
{
return(Content("1", "text/html"));
}
else
{
serialservice matchOne = db.serialservice.Where(m => m.code == id).ToList().First();
db.serialservice.Attach(matchOne);
db.Entry(matchOne).State = System.Data.Entity.EntityState.Deleted;
await db.SaveChangesAsync();
return(Content("0", "text/html"));
}
}
}
catch (Exception ex)
{
LogHelper.Error("串口服务器删除异常", ex);
return(Content("2", "text/html"));
}
}
public async Task <ActionResult> Create(serialservice info)
{
string name, error, loginName;
if (CookieHelper.HasCookie(out name, out error) == false)
{
return(RedirectToAction("", "LoginUI"));
}
else
{
new RoleHelper().GetRoles(name, out role, out department1Code, out loginName);
ViewData["VisitorRole"] = role;
ViewData["username"] = loginName;
}
if (ModelState.IsValid)
{
using (mlrmsEntities db = new mlrmsEntities())
{
if (db.serialservice.Where(m => m.code == info.code || m.name == info.name).Count() > 0)
{
ModelState.AddModelError("Title", "相同设备编号或设备名称的串口服务器已存在，请更换后重新添加");
return(View(info));
}
try
{
db.serialservice.Add(info);
await db.SaveChangesAsync();
//MvcApplication.Client.Refresh(dev.slaveid, true);
return(RedirectToAction("Index", "serialport"));
}
catch
{
ModelState.AddModelError("Title", "数据保存失败");
return(View(info));
}
}
}
return(View(info));
}
public ActionResult CheckData(string userName, string userPwd)
{
if (string.IsNullOrEmpty(userName))
{
ModelState.AddModelError("UserName", "用户名不能为空");
return(View("Index"));
}
if (string.IsNullOrEmpty(userPwd))
{
ModelState.AddModelError("Passwd", "密码不能为空");
return(View("Index"));
}
if (userName.Length > 30)
{
ModelState.AddModelError("UserName", "用户名长度不能超过30");
return(View("Index"));
}
if (userPwd.Length > 32)
{
ModelState.AddModelError("Passwd", "密码长度不能超过32");
return(View("Index"));
}
string encryptStr = EncryptHelper.GetEncrypt(userPwd);
using (mlrmsEntities db = new mlrmsEntities())
{
if (db.sysadmin.Where(m => (m.AdminName == userName) && (m.AdminPwd == encryptStr)).Count() > 0)
{
return(Content("True", "text/html"));
}
else
{
ModelState.AddModelError("Title", "用户名或密码错误");
return(View("Index"));
}
}
}
public List <HeatPumpParas> GetAllAttendanceInfos(string beginTime1, string endTime1, string searchkey, string slaveCode)
{
DateTime dtStart = DateTime.Parse(beginTime1);
DateTime dtEnd = DateTime.Parse(endTime1);
int slaveID = int.Parse(slaveCode);
List <HeatPumpParas> attendances = new List <HeatPumpParas>();
try
{
using (mlrmsEntities db = new mlrmsEntities())
{
IQueryable <HeatPumpParas> dynamicAttendance = null;
if (slaveCode != "0")
{
dynamicAttendance = (from heatPump in db.device
join dev in db.heatmeterstatistics
on heatPump.slaveid equals dev.slaveid into h
from c in h.DefaultIfEmpty()
where (heatPump.servicecode == c.servicecode && heatPump.port == c.port)
where heatPump.type == 2
where c.slaveid == slaveID
where (c.time >= dtStart && c.time <= dtEnd)
where (heatPump.name.ToLower().Contains(searchkey.ToLower()))
select new HeatPumpParas
{
coldEnergy = c.coldenergy,
warmEnergy = c.warmenergy,
slaveID = heatPump.slaveid,
name = heatPump.name,
type = heatPump.type,
time = c.time,
subType = heatPump.subtype
}).OrderByDescending(m => m.time);
}
else
{
dynamicAttendance = (from heatPump in db.device
join dev in db.heatmeterstatistics
on heatPump.slaveid equals dev.slaveid into h
from c in h.DefaultIfEmpty()
where (heatPump.servicecode == c.servicecode && heatPump.port == c.port)
where heatPump.type == 2
where (c.time >= dtStart && c.time <= dtEnd)
where (heatPump.name.ToLower().Contains(searchkey.ToLower()))
select new HeatPumpParas
{
coldEnergy = c.coldenergy,
warmEnergy = c.warmenergy,
slaveID = heatPump.slaveid,
name = heatPump.name,
type = heatPump.type,
time = c.time,
subType = heatPump.subtype
}).OrderByDescending(m => m.time);
}
attendances = dynamicAttendance.ToList();
if (attendances == null || attendances.Count == 0)
{
return(null);
}
foreach (var item in attendances)
{
item.typeName = EnumParser.TypeParser(item.type);
item.subTypeName = item.subType.HasValue ? EnumParser.SubTypeParser(item.subType.Value) : string.Empty;
}
}
}
catch (Exception ex)
{
LogHelper.Error("获取热泵记录失败", ex);
}
return(attendances);
}
public ActionResult Index(string searchkey, string index, int?searchType)
{
string name, error;
if (CookieHelper.HasCookie(out name, out error) == false)
{
return(RedirectToAction("", "LoginUI"));
}
else
{
new RoleHelper().GetRoles(name, out role, out department1Code, out LoginName);
ViewData["VisitorRole"] = role;
ViewData["username"] = LoginName;
}
if (string.IsNullOrEmpty(index))
{
index = "1";
}
if (searchkey == string.Empty)
{
return(RedirectToAction("", "Device"));
}
if (searchkey == null)
{
searchkey = string.Empty;
}
if (searchType == null)
{
searchType = (int)QueryDeviceSubType.ALL;
}
DeviceQueryCondition condition = new DeviceQueryCondition();
condition.searchkey = searchkey;
if (string.IsNullOrEmpty(searchkey))
{
searchType = (int)QueryDeviceSubType.ALL; //当searchkey为空时，默认加载全部
}
condition.queryType = (QueryDeviceSubType)searchType;
ViewData["requestData"] = condition;
List <device> totalList = null;
try
{
using (mlrmsEntities db = new mlrmsEntities())
{
int totalCount = db.device.Count();
if (totalCount == 0)
{
return(View());
}
PageModel page = new PageModel()
{
SearchKeyWord = searchkey, SearchType = searchType, CurrentIndex = Int32.Parse(index), TotalCount = totalCount
};
totalList = db.device.Where(p => p.name.ToLower().Contains(searchkey.ToLower()) || p.slaveid.ToString().Contains(searchkey.ToLower())).OrderBy(m => m.type).Skip((page.CurrentIndex - 1) * page.PageSize).Take(page.PageSize).ToList();
pageList = new List <DeviceInfo>();
foreach (var item in totalList)
{
DeviceInfo info = new DeviceInfo();
info.slaveID = item.slaveid;
info.note = item.note;
info.devName = item.name;
info.serviceCode = item.servicecode;
info.serviceName = item.servicename;
info.port = item.port;
info.runStatus = 1;
info.type = item.type;
info.typeName = EnumParser.TypeParser(item.type);
info.subType = item.subtype.HasValue ?item.subtype.Value : -1;
info.subTypeName = EnumParser.SubTypeParser(info.subType);
pageList.Add(info);
}
ViewData["pagemodel"] = page;
return(View(pageList));
}
}
catch (Exception ex)
{
LogHelper.Error("设备列表加载失败", ex);
return(View());
}
}
public async Task <ActionResult> Create(DeviceInfo info, string dptName1List, string subList, string serialList)
{
string name, error, loginName;
if (CookieHelper.HasCookie(out name, out error) == false)
{
return(RedirectToAction("", "LoginUI"));
}
else
{
new RoleHelper().GetRoles(name, out role, out department1Code, out loginName);
ViewData["VisitorRole"] = role;
ViewData["username"] = loginName;
}
info.type = int.Parse(dptName1List);
if (info.type == (int)DeviceType.MainEngine || info.type == (int)DeviceType.WaterPump)
{
info.subType = int.Parse(subList);
}
List <DeviceEnumType> list = new List <DeviceEnumType>();
list.Add(new DeviceEnumType()
{
code = "1", name = "热泵主机"
});
list.Add(new DeviceEnumType()
{
code = "3", name = "水表"
});
list.Add(new DeviceEnumType()
{
code = "4", name = "电表"
});
list.Add(new DeviceEnumType()
{
code = "2", name = "热能表"
});
SelectList dptSelectlist1 = new SelectList(list, "code", "name", dptName1List);
ViewData["dptName1List"] = dptSelectlist1;
List <DeviceEnumType> list2 = new List <DeviceEnumType>();
list2.Add(new DeviceEnumType()
{
code = "5", name = "25P"
});
list2.Add(new DeviceEnumType()
{
code = "6", name = "50P"
});
SelectList dptSelectlist2 = new SelectList(list2, "code", "name", subList);
ViewData["subList"] = dptSelectlist2;
SelectList serialListx = null;
serialservice seviceItem = null;
using (mlrmsEntities db = new mlrmsEntities())
{
var slist = db.serialservice.ToList();
serialListx = new SelectList(slist, "code", "name", serialList);
ViewData["serialList"] = serialListx;
if (slist != null || slist.Count > 0)
{
seviceItem = slist.Where(m => m.code == serialList).First();
}
}
if (info.port > seviceItem.portcount)
{
ModelState.AddModelError("Title", "配置的端口号不能大于该串口服务器的串口数，请重新配置");
return(View(info));
}
info.serviceCode = seviceItem.code;
info.serviceName = seviceItem.name;
if (ModelState.IsValid)
{
using (mlrmsEntities db = new mlrmsEntities())
{
if (db.device.Where(m => m.port == info.port && m.servicecode == info.serviceCode).Count() > 0)
{
ModelState.AddModelError("Title", "串口服务器的端口已配置，请更换端口号重新添加");
return(View(info));
}
if (db.device.Where(m => m.slaveid == info.slaveID && m.port == info.port && m.servicecode == info.serviceCode).Count() > 0)
{
ModelState.AddModelError("Title", "相同设备地址的设备已存在，请更换设备地址后重新添加");
return(View(info));
}
device dev = new device();
dev.note = info.note;
dev.slaveid = info.slaveID;
dev.servicecode = info.serviceCode;
dev.servicename = info.serviceName;
dev.port = info.port;
dev.type = int.Parse(dptName1List);
dev.subtype = info.subType == 0 ? null : (int?)int.Parse(subList);
dev.name = info.devName;
dev.note = info.note;
db.device.Add(dev);
try
{
await db.SaveChangesAsync();
MvcApplication.Client.Refresh(dev.slaveid, true);
return(RedirectToAction("Index", "Device"));
}
catch
{
ModelState.AddModelError("Title", "数据保存失败");
return(View(info));
}
}
}
return(View(info));
}
public ActionResult Create()
{
string name, error, loginName;
if (CookieHelper.HasCookie(out name, out error) == false)
{
return(RedirectToAction("", "LoginUI"));
}
else
{
new RoleHelper().GetRoles(name, out role, out department1Code, out loginName);
ViewData["VisitorRole"] = role;
ViewData["username"] = loginName;
}
List <DeviceEnumType> list = new List <DeviceEnumType>();
list.Add(new DeviceEnumType()
{
code = "1", name = "热泵"
});
list.Add(new DeviceEnumType()
{
code = "3", name = "水表"
});
list.Add(new DeviceEnumType()
{
code = "4", name = "电表"
});
list.Add(new DeviceEnumType()
{
code = "5", name = "水泵"
});
SelectList dptSelectlist1 = new SelectList(list, "code", "name");
ViewData["dptName1List"] = dptSelectlist1;
SelectList serialList = null;
List <DeviceEnumType> list2 = new List <DeviceEnumType>();
list2.Add(new DeviceEnumType()
{
code = "5", name = "25P"
});
list2.Add(new DeviceEnumType()
{
code = "6", name = "50P"
});
SelectList dptSelectlist2 = new SelectList(list2, "code", "name");
ViewData["subList"] = dptSelectlist2;
using (mlrmsEntities db = new mlrmsEntities())
{
var slist = db.serialservice.Select(m => new { code = m.code, name = m.name }).ToList();
string code = slist.First().code;
serialList = new SelectList(slist, "code", "name", code);
ViewData["serialList"] = serialList;
}
return(View());
}
public List <WaterPumpParas> GetAllAttendanceInfos(string beginTime1, string endTime1, string searchkey, string slaveCode)
{
DateTime dtStart = DateTime.Parse(beginTime1);
DateTime dtEnd = DateTime.Parse(endTime1);
int slaveID = int.Parse(slaveCode);
List <WaterPumpParas> attendances = new List <WaterPumpParas>();
try
{
using (mlrmsEntities db = new mlrmsEntities())
{
IQueryable <WaterPumpParas> dynamicAttendance = null;
if (slaveCode != "0")
{
dynamicAttendance = (from heatPump in db.devices
join bd in db.hmbindings
on heatPump.slaveid equals bd.bindingid
join dev in db.heatmeterstatistics
on bd.hmid equals dev.slaveid
where heatPump.type == 5
where (heatPump.slaveid == slaveID)
where (dev.time >= dtStart && dev.time <= dtEnd)
where (heatPump.name.ToLower().Contains(searchkey.ToLower()))
select new WaterPumpParas
{
coldEnergy = dev.coldenergy,
warmEnergy = dev.warmenergy,
slaveID = heatPump.slaveid,
name = heatPump.name,
time = dev.time,
}).OrderByDescending(m => m.time);
}
else
{
dynamicAttendance = (from heatPump in db.devices
join bd in db.hmbindings
on heatPump.slaveid equals bd.bindingid
join dev in db.heatmeterstatistics
on bd.hmid equals dev.slaveid
where heatPump.type == 5
where (dev.time >= dtStart && dev.time <= dtEnd)
where (heatPump.name.ToLower().Contains(searchkey.ToLower()))
select new WaterPumpParas
{
coldEnergy = dev.coldenergy,
warmEnergy = dev.warmenergy,
slaveID = heatPump.slaveid,
name = heatPump.name,
time = dev.time,
}).OrderByDescending(m => m.time);
}
attendances = dynamicAttendance.ToList();
if (attendances == null || attendances.Count == 0)
{
return(null);
}
}
}
catch (Exception ex)
{
LogHelper.Error("获取水泵能耗记录失败", ex);
}
return(attendances);
}
// GET: AttendanceAccount
public ActionResult Index(string beginTime1, string endTime1, string searchkey, string dptName1List, string index)
{
string name, error, loginName;
if (CookieHelper.HasCookie(out name, out error) == false)
{
return(RedirectToAction("", "LoginUI"));
}
else
{
new RoleHelper().GetRoles(name, out role, out department1Code, out loginName);
ViewData["VisitorRole"] = role;
ViewData["username"] = loginName;
}
DateTime dt = DateTime.Now;
if (string.IsNullOrEmpty(beginTime1) && string.IsNullOrEmpty(endTime1))
{
beginTime1 = dt.ToString("yyyy/MM/01 00:00");
endTime1 = dt.ToString("yyyy/MM/dd 23:59");
}
if (string.IsNullOrEmpty(searchkey))
{
searchkey = string.Empty;
}
if (string.IsNullOrEmpty(index))
{
index = "1";
}
if (string.IsNullOrEmpty(dptName1List))
{
dptName1List = "0";
}
AttendanceQueryCondition requestData = new AttendanceQueryCondition(); //回传给界面显示用
requestData.timeStart1 = beginTime1;
requestData.timeEnd1 = endTime1;
requestData.searchKey = searchkey;
requestData.department1 = dptName1List;
ViewData["requestData"] = requestData;
List <WaterMeterParas> attendanceResults = new List <WaterMeterParas>();
try
{
SelectList dptSelectlist1 = null;
using (mlrmsEntities db = new mlrmsEntities())
{
var dptList = db.device.Where(m => m.type == 3).Select(m => new { slaveid = m.slaveid, devname = m.name }).ToList();
dptList.Insert(0, new { slaveid = 0, devname = "全部" });
int waterCode = int.Parse(dptName1List);
dptSelectlist1 = new SelectList(dptList, "slaveid", "devname", waterCode);
ViewData["dptName1List"] = dptSelectlist1;
}
if (DateTime.Parse(beginTime1) > DateTime.Parse(endTime1))
{
ViewData["timeValid"] = true;
return(View());
}
attendanceResults = GetPageAttendanceInfos(Convert.ToInt32(index), beginTime1, endTime1, searchkey, dptName1List);
}
catch (Exception ex)
{
//记录日志
LogHelper.Error("水表记录读取异常", ex);
}
if (attendanceResults == null || attendanceResults.Count == 0)
{
return(View());
}
PageModelV2 page = null;
page = new PageModelV2()
{
SearchKeyWord = searchkey, DptName = dptName1List, BeginTime = beginTime1, EndTime = endTime1, CurrentIndex = Int32.Parse(index), TotalCount = totalCount
};
ViewData["pagemodel"] = page;
return(View(attendanceResults));
}
public List <WaterMeterParas> GetPageAttendanceInfos(int index, string beginTime1, string endTime1, string searchkey, string slaveCode)
{
DateTime dtStart = DateTime.Parse(beginTime1);
DateTime dtEnd = DateTime.Parse(endTime1);
int slaveID = int.Parse(slaveCode);
List <WaterMeterParas> attendances = new List <WaterMeterParas>();
try
{
using (mlrmsEntities db = new mlrmsEntities())
{
IQueryable <WaterMeterParas> dynamicAttendance = null;
if (slaveCode != "0")
{
if (index == 1)
{
totalCount = (from dev in db.device
join water in db.watermeterstatistics
on dev.slaveid equals water.slaveid
where dev.type == 3
where (dev.slaveid == slaveID)
where (water.time >= dtStart && water.time <= dtEnd)
//where (dev.name.ToLower().Contains(searchkey.ToLower()))
select dev).Count();
}
dynamicAttendance = (from dev in db.device
join water in db.watermeterstatistics
on dev.slaveid equals water.slaveid
where dev.type == 3
where (dev.slaveid == slaveID)
where (water.time >= dtStart && water.time <= dtEnd)
//where (dev.name.ToLower().Contains(searchkey.ToLower()))
select new WaterMeterParas
{
waterPara = water.wateramount,
slaveID = water.slaveid,
name = dev.name,
time = water.time,
}).OrderByDescending(m => m.time).Skip((index - 1) * page_size).Take(page_size);
}
else
{
if (index == 1)
{
totalCount = (from dev in db.device
join water in db.watermeterstatistics
on dev.slaveid equals water.slaveid
where dev.type == 3
where (water.time >= dtStart && water.time <= dtEnd)
where (dev.name.ToLower().Contains(searchkey.ToLower()))
select dev).Count();
}
dynamicAttendance = (from dev in db.device
join water in db.watermeterstatistics
on dev.slaveid equals water.slaveid
where dev.type == 3
where (water.time >= dtStart && water.time <= dtEnd)
where (dev.name.ToLower().Contains(searchkey.ToLower()))
select new WaterMeterParas
{
waterPara = water.wateramount,
slaveID = water.slaveid,
name = dev.name,
time = water.time,
}).OrderByDescending(m => m.time).Skip((index - 1) * page_size).Take(page_size);
}
attendances = dynamicAttendance.ToList();
if (attendances == null || attendances.Count == 0)
{
return(null);
}
}
}
catch (Exception ex)
{
LogHelper.Error("获取用水量信息失败", ex);
}
return(attendances);
}
