public SysUser GetById(int id) { using (OriginEntities db = new OriginEntities()) { return(db.SysUser.SingleOrDefault(a => a.Id == id)); } }
public SysRole GetById(string id) { using (OriginEntities db = new OriginEntities()) { return(db.SysRole.SingleOrDefault(a => a.Id == id)); } }
public SysModule GetById(string id) { using (OriginEntities db = new OriginEntities()) { return db.SysModule.SingleOrDefault(a => a.ModuleId == id); } }
public int Create(SysRole entity) { using (OriginEntities db = new OriginEntities()){ db.SysRole.Add(entity); return(db.SaveChanges()); } }
public SysUser Login(string username, string pwd) { using (OriginEntities db = new OriginEntities()) { SysUser user = db.SysUser.SingleOrDefault(a => a.UserName == username && a.Password == pwd); return(user); } }
public int Edit(SysRole entity) { using (OriginEntities db = new OriginEntities()) { db.SysRole.Attach(entity); return(db.SaveChanges()); } }
public int Edit(SysModule entity) { using (OriginEntities db = new OriginEntities()) { db.SysModule.Add(entity); return db.SaveChanges(); } }
public int Edit(SysUser entity) { using (OriginEntities db = new OriginEntities()) { db.Set <SysUser>().Attach(entity); db.Entry <SysUser>(entity).State = EntityState.Modified; return(db.SaveChanges()); } }
public int Delete(int id) { using (OriginEntities db = new OriginEntities()) { SysUser entity = db.SysUser.SingleOrDefault(a => a.Id == id); db.Set <SysUser>().Remove(entity); return(db.SaveChanges()); } }
public bool IsExist(string id) { using (OriginEntities db = new OriginEntities()) { SysModule entity = GetById(id); if (entity != null) return true; return false; } }
public List <P_Sys_GetRightByRoleAndModule_Result> GetRightByRoleAndModule(string roleId, string moduleId) { List <P_Sys_GetRightByRoleAndModule_Result> results = null; using (OriginEntities db = new OriginEntities()) { results = db.P_Sys_GetRightByRoleAndModule(roleId, moduleId).ToList(); } return(results); }
public int Delete(string id) { using (OriginEntities db = new OriginEntities()){ SysRole entity = db.SysRole.SingleOrDefault(a => a.Id == id); if (entity != null) { db.SysRole.Remove(entity); } return(db.SaveChanges()); } }
/// <summary> /// 删除对象集合 /// </summary> /// <param name="db">数据库</param> /// <param name="deleteCollection">集合</param> public void Delete(OriginEntities db, string[] deleteCollection) { IQueryable <SysLog> collection = from f in db.SysLog where deleteCollection.Contains(f.Id.ToString()) select f; foreach (var deleteItem in collection) { db.SysLog.Remove(deleteItem); } db.SaveChanges(); }
public bool IsExist(string id) { using (OriginEntities db = new OriginEntities()) { SysRole entity = db.SysRole.SingleOrDefault(a => a.Id == id); if (entity != null) { return(true); } return(false); } }
public bool IsExist(int id) { using (OriginEntities db = new OriginEntities()) { SysUser user = GetById(id); if (user != null) { return(true); } return(false); } }
public bool IsExist(string id) { using (OriginEntities db = new OriginEntities()) { SysModuleOperate entity = new SysModuleOperate(); if (entity != null) { return(true); } return(false); } }
public void Delete(OriginEntities db, string[] deleteCollection) { IQueryable <SysUser> collection = from u in db.SysUser where deleteCollection.Contains(u.Id.ToString()) select u; foreach (var item in collection) { db.SysUser.Remove(item); } db.SaveChanges(); }
/// <summary> /// 取角色模块的操作权限,用于权限控制 /// </summary> /// <param name="accountid">acount Id</param> /// <param name="controller">url</param> /// <returns></returns> public List <PermModel> GetPermission(int accountid, string controller) { using (OriginEntities db = new OriginEntities()) { List <PermModel> rights = (from r in db.P_Sys_GetRightOperate(accountid, controller) select new PermModel { KeyCode = r.KeyCode, IsValid = r.IsValid }).ToList(); return(rights); } }
/// <summary> /// 获取模块资源,按钮除外 /// </summary> /// <param name="keyList"></param> /// <returns></returns> public static IList <SysModule> GetModuleListOutBtn(IList <int?> keyList) { OriginEntities model = new OriginEntities(); IList <SysModule> modules = new List <SysModule>(); keyList.Each(c => { var module = model.SysModule.FirstOrDefault(m => m.IsDel == 0 && m.ModuleId == c.ToString() && m.ModuleLevel != 3); if (module != null) { modules.Add(module); } }); return(modules.OrderBy(c => c.Sort).ToList()); }
public List <SysLog> GetList(ref GridPager pager, string queryStr) { OriginEntities db = new OriginEntities(); List <SysLog> query = null; IQueryable <SysLog> list = logDAL.GetList(db); if (!string.IsNullOrWhiteSpace(queryStr)) { list = list.Where(a => a.Message.Contains(queryStr) || a.Module.Contains(queryStr)); pager.totalRows = list.Count(); } else { pager.totalRows = list.Count(); } query = LinqHelper.SortingAndPaging(list, pager.sort, pager.order, pager.page, pager.rows).ToList(); return(query); }
public List <SysException> GetList(ref GridPager pager, string queryStr) { OriginEntities db = new OriginEntities(); List <SysException> query = null; IQueryable <SysException> list = exceptionDAL.GetList(db); if (!string.IsNullOrWhiteSpace(queryStr)) { list = list.Where(a => a.Message.Contains(queryStr)); pager.totalRows = list.Count(); } else { pager.totalRows = list.Count(); } query = LinqHelper.DataSorting(list, pager.sort, pager.order).ToList(); return(query); }
/// <summary> /// 获取资源模块 /// </summary> /// <param name="keyList">资源模块主键</param> /// <returns></returns> public static IList <SysModule> GetModuleList(IList <int> keyList) { OriginEntities model = new OriginEntities(); IList <SysModule> modules = new List <SysModule>(); //foreach (var item in keyList) //{ // var module = model.SysModule.FirstOrDefault(m => m.IsDel == 0 && m.ModuleId == item.GetInt().t); //} keyList.Each(c => { var module = model.SysModule.FirstOrDefault(m => m.IsDel == 0 && m.ModuleId == c.ToString()); if (module != null) { modules.Add(module); } }); return(modules.OrderBy(c => c.Sort).ToList()); }
/// <summary> /// 加入异常日志 /// </summary> /// <param name="ex">异常</param> public static void WriteException(Exception ex) { try { using (OriginEntities db = new OriginEntities()) { 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.SysException.Add(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 void Delete(OriginEntities db, string id) { SysModule entity = db.SysModule.SingleOrDefault(a => a.ModuleId == id); if (entity != null) { //删除SysRight表数据 var sr = db.SysRight.AsQueryable().Where(a => a.ModuleId == id); foreach (var o in sr) { var sro = db.SysRightOperate.AsQueryable().Where(a => a.RightId == o.Id); foreach (var o2 in sro) { db.SysRightOperate.Remove(o2); } } var smo = db.SysModuleOperate.AsQueryable().Where(a => a.ModuleId == id); foreach (var o3 in smo) { db.SysModuleOperate.Remove(o3); } db.SysModule.Remove(entity); } }
public List<SysModule> GetMenuByPersonId(int personId, string moduleId) { using (OriginEntities db = new OriginEntities()) { //得到角色 var roles = from r in db.SysRoleSysUser from u in db.SysUser where u.Id == personId select r; var menus = (from m in db.SysModule from ri in db.SysRight where ri.ModuleId == m.ModuleId where roles.Any(r => r.SysRoleId == ri.RoleId) where ri.Rightflag == true where m.ParentId == moduleId where m.ModuleId != "0" where m.IsDisplay==true select m) .Distinct().OrderBy(a => a.Sort); return menus.ToList(); } }
public int UpdateRight(SysRightOperate model) { using (OriginEntities db = new OriginEntities()) { SysRightOperate right = db.SysRightOperate.Where(a => a.Id == model.Id).FirstOrDefault(); if (right != null) { right.IsValid = model.IsValid; } else { db.SysRightOperate.Add(model); } if (db.SaveChanges() > 0) { var sysRight = (from r in db.SysRight where r.Id == model.RightId select r).First(); db.P_Sys_UpdateSysRightRightFlag(sysRight.ModuleId, sysRight.RoleId); return(1); } return(0); } }
public IQueryable <SysUser> GetList(OriginEntities db) { IQueryable <SysUser> list = db.SysUser.AsQueryable(); return(list); }
public IQueryable<SysModule> GetList(OriginEntities db) { return db.SysModule.AsQueryable(); }
public IQueryable <SysModule> GetList(OriginEntities db) { return(SysModuleDAL.GetList(db)); }
public IQueryable<SysModule> GetModuleBySystem(OriginEntities db, string parentId) { return db.SysModule.Where(a => a.ParentId == parentId).AsQueryable(); }