//添加组织
public void Add(GroupModel entity, string account)
{
//DataContextFactory.GetDataContext().Group.Add(entity);
using (var db = new HXContext())
{
//1、生成组织，2、创建该组织的管理员角色，3、修改用户的组织,4、添加该用户为该组织的管理员角色
//生成id
entity.Id = EncryptData.CreateUUID();
db.Group.Add(entity);
RoleModel rm = new RoleModel()
{
IsAdmin = 1, RoleName = "admin", Token = entity.Id
};
db.Role.Add(rm);
UserModel um = new UserRepository().Find(account);//.GetUserInfo(gvm.UserName);
um.Token = entity.Id;
db.Entry <UserModel>(um).State = System.Data.Entity.EntityState.Modified;
UserRoleModel urm = new UserRoleModel();
urm.Role = rm;
//urm.User = um;
urm.UserId = um.Id;
db.UserRole.Add(urm);
db.SaveChanges();
}
}
public void Remove(DevicePanelTypeModel entity)
{
using (var db = new HXContext())
{
//删除相关的数据
var dp = db.DevicePanel.Where(a => a.TypeId == entity.Id).ToList();
foreach (var item in dp)
{
var ddd = db.DeviceDataDefine.Where(a => a.PanelId == item.Id).ToList();
db.DeviceDataDefine.RemoveRange(ddd);
var di = db.DeviceImage.Where(a => a.PanelId == item.Id).ToList();
db.DeviceImage.RemoveRange(di);
var dv = db.DeviceVideo.Where(a => a.PanelId == item.Id).ToList();
db.DeviceVideo.RemoveRange(dv);
var dbd = db.DeviceBaseData.Where(a => a.PanelId == item.Id).ToList();
db.DeviceBaseData.RemoveRange(dbd);
var dm = db.DeviceMap.Where(a => a.PanelId == item.Id).ToList();
db.DeviceMap.RemoveRange(dm);
var dcd = db.DeviceControlData.Where(a => a.PanelId == item.Id).ToList();
db.DeviceControlData.RemoveRange(dcd);
}
db.DevicePanel.RemoveRange(dp);
db.Entry <DevicePanelTypeModel>(entity).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
}
}
public void Remove(string sn)
{
using (var db = new HXContext())
{
//先删除关联的设备信息
var dbd = db.DeviceBaseData.Where(a => a.DeviceSn == sn).ToList();
foreach (var item in dbd)
{
db.DeviceBaseData.Remove(item);
}
var ddp = db.DevicePanel.Where(a => a.DeviceSn == sn).ToList();
db.DevicePanel.RemoveRange(ddp);
var ddd = db.DeviceDataDefine.Where(a => a.DeviceSn == sn).ToList();
db.DeviceDataDefine.RemoveRange(ddd);
var dcd = db.DeviceControlData.Where(a => a.DeviceSn == sn).ToList();
db.DeviceControlData.RemoveRange(dcd);
var dv = db.DeviceVideo.Where(a => a.DeviceSn == sn).ToList();
db.DeviceVideo.RemoveRange(dv);
var di = db.DeviceImage.Where(a => a.DeviceSn == sn).ToList();
db.DeviceImage.RemoveRange(di);
var dm = db.DeviceMap.Where(a => a.DeviceSn == sn).ToList();
db.DeviceMap.RemoveRange(dm);
var dh = db.DeviceHisData.Where(a => a.DeviceSn == sn).ToList();
db.DeviceHisData.RemoveRange(dh);
var da = db.DeviceAlarm.Where(a => a.DeviceSn == sn).ToList();
db.DeviceAlarm.RemoveRange(da);
var don = db.DeviceOnline.Where(a => a.DeviceSn == sn).ToList();
db.DeviceOnline.RemoveRange(don);
var d = db.Device.Where(a => a.DeviceSn == sn).ToList();
db.Device.RemoveRange(d);
db.SaveChanges();
}
}
public ProjectAffiliateModel FindBy(int projectId, string name)
{
using (var db = new HXContext())
{
var affiliates = db.ProjectAffiliate.Where(a => a.ProjectId == projectId && a.AffiliateName == name).FirstOrDefault();
return(affiliates);
}
}
public ProjectAffiliateModel Find(int id)
{
using (var db = new HXContext())
{
var affiliate = db.ProjectAffiliate.Where(a => a.Id == id).Single();
return(affiliate);
}
}
public UserRoleModel FindUserRole(UserRoleModel entity)
{
using (var db = new HXContext())
{
var userRole = db.UserRole.Where(a => a.UserId == entity.UserId && a.RoleId == entity.RoleId).FirstOrDefault();
return(userRole);
}
}
public void Add(UserRoleModel entity)
{
using (var db = new HXContext())
{
db.UserRole.Add(entity);
db.SaveChanges();
}
}
public void Remove(DeviceOnlineModel entity)
{
using (var db = new HXContext())
{
db.Entry <DeviceOnlineModel>(entity).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
}
}
public IEnumerable <UserModel> FindBy(string query, int pageSize, int pageCount)
{
using (var db = new HXContext())
{
IEnumerable <UserModel> users = db.User.Where(a => a.Token == query).Skip((pageCount - 1) * pageSize).Take(pageSize).ToList();
return(users);
}
}
public List <SysMenuModel> FindMenu(string token)
{
using (var db = new HXContext())
{
var m = db.SysMenu.Where(a => a.Token == token).ToList();
return(m);
}
}
public SysMenuModel FindByName(string name, string token)
{
using (var db = new HXContext())
{
var m = db.SysMenu.FirstOrDefault(a => a.Name == name && a.Token == token);
return(m);
}
}
public void Add(SysMenuModel entity)
{
using (var db = new HXContext())
{
db.SysMenu.Add(entity);
db.SaveChanges();
}
}
public DevicePanelTypeModel Find(int panelId)
{
using (var db = new HXContext())
{
var dpm = db.DevicePanelType.Where(a => a.Id == panelId).FirstOrDefault();
return(dpm);
}
}
public IEnumerable <DevicePanelTypeModel> Find()
{
using (var db = new HXContext())
{
var dpt = db.DevicePanelType.ToList();
return(dpt);
}
}
public IEnumerable <DevicePanelTypeModel> Find(string token)
{
using (var db = new HXContext())
{
var dpt = db.DevicePanelType.Where(a => a.Token == token).ToList();
return(dpt);
}
}
public UserModel FindByUserAndToken(string account, string token)
{
using (var db = new HXContext())
{
var entity = db.User.Include("userrole").Include("userrole.role").Include("userrole.role.roleproject").Where(a => a.Account == account && a.Token == token).Single();
return(entity);
}
}
//public UserModel Find(string user,string token)
//{
// using (var db= new HXContext())
// {
// var entity = db.User.Include("userrole")
// }
//}
public IEnumerable <UserModel> FindBy(string query)
{
using (var db = new HXContext())
{
IEnumerable <UserModel> users = db.User.Where(a => a.Account == query).ToList();
return(users);
}
}
public void Add(DeviceBaseDataModel entity)
{
using (var db = new HXContext())
{
db.DeviceBaseData.Add(entity);
db.SaveChanges();
}
}
public void Add(DeviceOnlineModel entity)
{
using (var db = new HXContext())
{
db.DeviceOnline.Add(entity);
db.SaveChanges();
}
}
public DeviceBaseDataModel Find(int id)
{
using (var db = new HXContext())
{
var d = db.DeviceBaseData.Where(a => a.Id == id).FirstOrDefault();
return(d);
}
}
public List <DeviceOnlineModel> FindAllDeviceOnline(string token)
{
using (var db = new HXContext())
{
var list = db.DeviceOnline.Include("Device").Include("Device.DeviceType").Where(a => a.Token == token).ToList();
return(list);
}
}
public void Add(RoleProjectModel entity)
{
using (var db = new HXContext())
{
db.RoleProject.Add(entity);
db.SaveChanges();
}
}
public void Save(UserRoleModel entity)
{
using (var db = new HXContext())
{
db.Entry <UserRoleModel>(entity).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
public IEnumerable <RoleProjectModel> FindBy(int roleId)
{
using (var db = new HXContext())
{
var roleMenus = db.RoleProject.Where(a => a.RoleId == roleId).ToList();
return(roleMenus);
}
}
public void Add(ProjectAffiliateModel entity)
{
using (var db = new HXContext())
{
db.ProjectAffiliate.Add(entity);
db.SaveChanges();
}
}
public void Remove(RoleProjectModel entity)
{
using (var db = new HXContext())
{
db.Entry <RoleProjectModel>(entity).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
}
}
public List <ProjectAffiliateModel> FindBy(int projectId)
{
using (var db = new HXContext())
{
var affiliates = db.ProjectAffiliate.Where(a => a.ProjectId == projectId).ToList();
return(affiliates);
}
}
public UserModel Find(int id)
{
using (var db = new HXContext())
{
var user = db.User.Where(a => a.Id == id).Single();
return(user);
}
}
public void Save(ProjectAffiliateModel entity)
{
using (var db = new HXContext())
{
db.Entry(entity).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
public UserModel Find(string user)
{
using (var db = new HXContext())
{
var entity = db.User.Include("userrole").Include("userrole.role").Include("userrole.role.roleproject").Where(a => a.Account == user).SingleOrDefault();
return(entity);
}
}
