public void Delete(DBContainer db, string id) { SysModule entity = db.SysModules.SingleOrDefault(a => a.Id == id); if (entity != null) { //删除SysRight表数据 var sr = db.SysRights.AsQueryable().Where(a => a.ModuleId == id); foreach (var o in sr) { //删除SysRightOperate表数据 var sro = db.SysRightOperates.AsQueryable().Where(a => a.RightId == o.Id); foreach (var o2 in sro) { db.SysRightOperates.DeleteObject(o2); } db.SysRights.DeleteObject(o); } //删除SysModuleOperate数据 var smo = db.SysModuleOperates.AsQueryable().Where(a => a.ModuleId == id); foreach (var o3 in smo) { db.SysModuleOperates.DeleteObject(o3); } db.SysModules.DeleteObject(entity); } }
public SysModuleOperate GetById(string id) { using (DBContainer db = new DBContainer()) { return db.SysModuleOperates.SingleOrDefault(a => a.Id == id); } }
public SysSample GetById(string id) { using (DBContainer db = new DBContainer()) { return db.SysSamples.SingleOrDefault(a => a.ID == id); } }
/// <summary> /// 根据ID获取一个实体 /// </summary> /// <param name="id"></param> /// <returns></returns> public SysException GetById(string id) { using (DBContainer db = new DBContainer()) { return db.SysException.SingleOrDefault(a => a.Id == id); } }
public List<SysException> GetList(ref GridPager pager, string queryStr) { DBContainer db = new DBContainer(); List<SysException> query = null; IQueryable<SysException> list = exceptionRepository.GetList(db); if (!string.IsNullOrWhiteSpace(queryStr)) { list = list.Where(a => a.Message.Contains(queryStr)); pager.totalRows = list.Count(); } else { pager.totalRows = list.Count(); } if (pager.order == "desc") { query = list.OrderByDescending(c => c.CreateTime).Skip((pager.page - 1) * pager.rows).Take(pager.rows).ToList(); } else { query = list.OrderBy(c => c.CreateTime).Skip((pager.page - 1) * pager.rows).Take(pager.rows).ToList(); } return query; }
public int UpdateRight(SysRightOperateModel model) { //转换 SysRightOperate rightOperate = new SysRightOperate(); rightOperate.Id = model.Id; rightOperate.RightId = model.RightId; rightOperate.KeyCode = model.KeyCode; rightOperate.IsValid = model.IsValid; //判断rightOperate是否存在,如果存在就更新rightOperate,否则就添加一条 using (DBContainer db = new DBContainer()) { SysRightOperate right = db.SysRightOperates.Where(a => a.Id == rightOperate.Id).FirstOrDefault(); if (right != null) { right.IsValid = rightOperate.IsValid; } else { db.SysRightOperates.AddObject(rightOperate); } if (db.SaveChanges() > 0) { //更新角色--模块的有效标志RightFlag var sysRight = (from r in db.SysRights where r.Id == rightOperate.RightId select r).First(); db.P_Sys_UpdateSysRightRightFlag(sysRight.ModuleId, sysRight.RoleId); return 1; } } return 0; }
/// <summary> /// 创建一个实体 /// </summary> /// <param name="db">数据库上下文</param> /// <param name="entity">实体</param> public int Create(SysSample entity) { using (DBContainer db = new DBContainer()) { db.SysSample.Add(entity); return db.SaveChanges(); } }
public int Create(SysRole entity) { using (DBContainer db = new DBContainer()) { db.SysRoles.AddObject(entity); return db.SaveChanges(); } }
/// <summary> /// 创建一个对象 /// </summary> /// <param name="db">数据库</param> /// <param name="entity">实体</param> public int Create(SysException entity) { using (DBContainer db = new DBContainer()) { db.SysException.Add(entity); return db.SaveChanges(); } }
public SysUser Login(string username, string pwd) { using (DBContainer db = new DBContainer()) { SysUser user = db.SysUsers.SingleOrDefault(a => a.UserName == username && a.Password == pwd); return user; } }
/// <summary> /// 修改一个实体 /// </summary> /// <param name="db">数据库上下文</param> /// <param name="entity">实体</param> public int Edit(SysSample entity) { using (DBContainer db = new DBContainer()) { db.SysSample.Attach(entity); db.Entry(entity).State = System.Data.EntityState.Modified; return db.SaveChanges(); } }
public int Edit(SysRole entity) { using (DBContainer db = new DBContainer()) { db.SysRoles.Attach(entity); db.ObjectStateManager.ChangeObjectState(entity, EntityState.Modified); return db.SaveChanges(); } }
//按选择的角色及模块加载模块的权限项 public List<P_Sys_GetRightByRoleAndModule_Result> GetRightByRoleAndModule(string roleId, string moduleId) { List<P_Sys_GetRightByRoleAndModule_Result> result = null; using (DBContainer db = new DBContainer()) { result = db.P_Sys_GetRightByRoleAndModule(roleId, moduleId).ToList(); } return result; }
public void Delete(DBContainer db, string[] deleteCollection) { IQueryable<SysUser> collection = from f in db.SysUsers where deleteCollection.Contains(f.Id) select f; foreach (var deleteItem in collection) { db.SysUsers.DeleteObject(deleteItem); } }
public bool IsExist(string id) { using (DBContainer db = new DBContainer()) { SysRole entity = GetById(id); if (entity != null) return true; return false; } }
public IQueryable<SysUser> GetRefSysUser(DBContainer db, string id) { if (!string.IsNullOrEmpty(id)) { return from m in db.SysRoles from f in m.SysUsers where m.Id == id select f; } return null; }
public int Delete(string id) { using (DBContainer db = new DBContainer()) { SysRole entity = db.SysRoles.SingleOrDefault(a => a.Id == id); if (entity != null) { db.SysRoles.DeleteObject(entity); } return db.SaveChanges(); } }
/// <summary> /// 取角色模块的操作权限,用于权限控制 /// </summary> /// <param name="accountid">acount Id</param> /// <param name="controller">url</param> /// <returns></returns> public List<PermModel> GetPermission(string accountid, string controller) { using (DBContainer db = new DBContainer()) { List<PermModel> rights = (from r in db.P_Sys_GetRightOperate(accountid, controller) select new PermModel { KeyCode = r.KeyCode, IsValid = r.IsValid }).ToList(); return rights; } }
public List<SysModule> GetMenuByPersonId(string moduleId) { using (DBContainer db = new DBContainer()) { var menus = ( from m in db.SysModule where m.ParentId == moduleId where m.Id != "0" select m ).Distinct().OrderBy(a => a.Sort).ToList(); return menus; } }
/// <summary> /// 加入异常日志 /// </summary> /// <param name="ex">异常</param> public static void WriteException(Exception ex) { try { using (DBContainer db = new DBContainer()) { SysException model = new SysException() { Id = ResultHelper.NewId, HelpLink = ex.HelpLink, Message = ex.Message, Source = ex.Source, StackTrace = ex.StackTrace, TargetSite = ex.TargetSite.ToString(), Data = ex.Data.ToString(), CreateTime = ResultHelper.NowTime }; db.SysExceptions.AddObject(model); db.SaveChanges(); } } catch (Exception ep) { try { //异常失败写入txt string path = @"~/exceptionLog.txt"; string txtPath = System.Web.HttpContext.Current.Server.MapPath(path);//获取绝对路径 using (StreamWriter sw = new StreamWriter(txtPath, true, Encoding.Default)) { sw.WriteLine((ex.Message + "|" + ex.StackTrace + "|" + ep.Message + "|" + DateTime.Now.ToString()).ToString()); sw.Dispose(); sw.Close(); } return; } catch { return; } } }
public List<SysModule> GetMenuByPersonId(string personId, string moduleId) { using (DBContainer db = new DBContainer()) { var menus = ( from m in db.SysModules join rl in db.SysRights on m.Id equals rl.ModuleId join r in (from r in db.SysRoles from u in r.SysUsers where u.Id == personId select r) on rl.RoleId equals r.Id where rl.Rightflag == true where m.ParentId == moduleId where m.Id != "0" select m ).Distinct().OrderBy(a => a.Sort).ToList(); return menus; } }
/// <summary> /// 获取集合 /// </summary> /// <param name="db">数据库</param> /// <returns>集合</returns> public IQueryable<SysException> GetList(DBContainer db) { IQueryable<SysException> list = db.SysException.AsQueryable(); return list; }
/// <summary> /// 获取集合 /// </summary> /// <param name="db">数据库</param> /// <returns>集合</returns> public IQueryable<SysLog> GetList(DBContainer db) { IQueryable<SysLog> list = db.SysLogs.AsQueryable(); return list; }
public void UpdateSysRoleSysUser(string roleId,string[] userIds) { using(DBContainer db = new DBContainer()) { db.P_Sys_DeleteSysRoleSysUserByRoleId(roleId); foreach (string userid in userIds) { if (!string.IsNullOrWhiteSpace(userid)) { db.P_Sys_UpdateSysRoleSysUser(roleId, userid); } } db.SaveChanges(); } }
public IQueryable<SysModuleOperate> GetList(DBContainer db) { IQueryable<SysModuleOperate> list = db.SysModuleOperates.AsQueryable(); return list; }
public IQueryable<P_Sys_GetUserByRoleId_Result> GetUserByRoleId(DBContainer db, string roleId) { return db.P_Sys_GetUserByRoleId(roleId).AsQueryable(); }
public IQueryable<SysUser> GetList(DBContainer db) { IQueryable<SysUser> list = db.SysUsers.AsQueryable(); return list; }
public IQueryable<SysRole> GetList(DBContainer db) { IQueryable<SysRole> list = db.SysRoles.AsQueryable(); return list; }
public IQueryable<P_Sys_GetRoleByUserId_Result> GetRoleByUserId(DBContainer db, string userId) { return db.P_Sys_GetRoleByUserId(userId).AsQueryable(); }
public BaseBLL() { dbContainer = new DBContainer(); }