public bool AddUser(string userName, string pwd, string ChineseName, bool isLock, bool isAdmin, string loginPc, string memo) { using (AuthorizeEntities context = new AuthorizeEntities()) { try { var userAdd = new User(); userAdd.UserID = Guid.NewGuid(); userAdd.UserName = userName; userAdd.Pwd = pwd; userAdd.ChineseName = ChineseName; userAdd.IsLock = isLock; userAdd.IsAdmin = isAdmin; userAdd.LoginPC = loginPc; userAdd.Memo = memo; context.AddToUser(userAdd); context.SaveChanges(); return true; } catch (Exception e) { throw e; } } }
public bool ChangePassword(string userName, string password, string newPassword) { if (String.IsNullOrEmpty(userName)) throw new ArgumentException("Value cannot be null or empty.", "userName"); if (String.IsNullOrEmpty(password)) throw new ArgumentException("Value cannot be null or empty.", "password"); if (String.IsNullOrEmpty(newPassword)) throw new ArgumentException("Value cannot be null or empty.", "newPassword"); using (AuthorizeEntities context = new AuthorizeEntities()) { try { var user = context.User.FirstOrDefault(i => i.UserName == userName); if (user != null && ValidateUser(userName, password)) { user.UserName = userName ?? user.UserName; user.Pwd = newPassword != null ? EncryptPassword(newPassword) : user.Pwd; context.SaveChanges(); } else { return false; } } catch (Exception e) { throw e; } } return true; }
public object GetDetails(int page, int rows) { using (AuthorizeEntities context = new AuthorizeEntities()) { try { var systems = from s in context.Role select new { s.RoleID, s.RoleName, s.Memo, IsLock = s.IsLock ? "启用" : "禁用" }; return systems.ToArray(); } catch (Exception e) { throw e; } } }
public object GetDetails(int page, int rows) { using (AuthorizeEntities context = new AuthorizeEntities()) { try { var citys = from s in context.City select new { s.CityID, s.CityName, s.IsActive }; return citys.ToArray(); } catch (Exception e) { throw e; } } }
public object GetDetails(int page, int rows) { using (AuthorizeEntities context = new AuthorizeEntities()) { try { var systems = from s in context.User select new { s.UserID, s.UserName, IsLock = s.IsLock ? "锁定" : "未锁", IsAdmin = s.IsAdmin ? "是" : "否",s.Memo }; return systems.ToArray(); } catch (Exception e) { throw e; } } }
public bool delete(string systemId) { using (AuthorizeEntities context = new AuthorizeEntities()) { try { Guid guserId = new Guid(systemId);//从子表开始删除 一直到system表 var userid = from userinfo in context.User where userinfo.UserID == guserId select userinfo; var userSystem = from usersys in context.UserSystem where usersys.UserSystemID == guserId select usersys; var sys = from system in context.System where system.SystemID == guserId select system; if (userid.FirstOrDefault() != null) { context.DeleteObject(userSystem.First()); context.SaveChanges(); } if (userid.FirstOrDefault() != null) { context.DeleteObject(userid.First()); context.SaveChanges(); } if (userid.FirstOrDefault() != null) { context.DeleteObject(sys.First().UserSystems); context.SaveChanges(); } } catch (Exception e) { throw e; } return true; } }
public bool Add(string cityname, bool isactive) { using (AuthorizeEntities context = new AuthorizeEntities()) { try { var citys =new City(); citys.CityID=Guid.NewGuid(); citys.CityName = cityname; citys.IsActive = isactive; context.AddToCity(citys); context.SaveChanges(); return true; } catch (Exception e) { throw e; } } }
public string FindRolesForFunction(string functionId) { using (AuthorizeEntities context = new AuthorizeEntities()) { Guid fid = new Guid(functionId); var roles = context.Role.Where(role => (role.RoleSystems.Where(roleSystem => (roleSystem.RoleModules.Where(roleModule => (roleModule.RoleFunctions.Where(roleFunction => roleFunction.Function.FunctionID == fid)).Count() > 0)).Count() > 0)).Count() > 0); var rolenames = roles.Select(i => i.RoleName); string result = ""; foreach (var rolename in rolenames) { result += rolename + ","; } return result; } }
public bool AddRole(string roleName, string memo, bool islock) { using (AuthorizeEntities context = new AuthorizeEntities()) { try { var roleAdd = new Role(); roleAdd.RoleID = Guid.NewGuid(); roleAdd.RoleName = roleName; roleAdd.IsLock = islock; roleAdd.Memo = memo; context.AddToRole(roleAdd); context.SaveChanges(); return true; } catch (Exception e) { throw e; } } }
public string FindUsersForFunction(string functionId) { using (AuthorizeEntities context = new AuthorizeEntities()) { Guid fid = new Guid(functionId); var users = context.User.Where(user => (user.UserSystems.Where(userSystem => (userSystem.UserModules.Where(userModule => (userModule.UserFunctions.Where(userFunction => userFunction.Function.FunctionID == fid)).Count() > 0)).Count() > 0)).Count() > 0); var usernames = users.Select(i => i.UserName); string result = ""; foreach (var username in usernames) { result += username + ","; } return result; } }
public bool ValidateUser(string userName, string password) { if (String.IsNullOrEmpty(userName)) throw new ArgumentException("Value cannot be null or empty.", "userName"); if (String.IsNullOrEmpty(password)) throw new ArgumentException("Value cannot be null or empty.", "password"); using (AuthorizeEntities context = new AuthorizeEntities()) { try { var adduser = new User(); adduser.UserID = Guid.NewGuid(); adduser.UserName = userName; adduser.Pwd = EncryptPassword(password); adduser.IsLock = false; adduser.IsAdmin = false; var user = context.User.FirstOrDefault(i => i.UserName == userName); if (user == null) { context.AddToUser(adduser); context.SaveChanges(); } return user != null && ComparePassword(password, user.Pwd); } catch (Exception e) { throw e; } } }