public static User Login(string loginName, string password) { SqlParameter[] parameters = new SqlParameter[2]; parameters[0] = new SqlParameter("@LoginName", SqlDbType.VarChar); parameters[0].Value = loginName; parameters[1] = new SqlParameter("@Password", SqlDbType.VarChar); parameters[1].Value = password; using (var reader = SqlHelper.ExecuteReader(ConnectionHelper.ConnectionString , CommandType.StoredProcedure , "t_Sys_User_Login" , parameters)) { if (reader.Read()) { var user = new User(); user.UserId = reader.GetInt32(0); user.LoginName = reader.GetString(1); user.CustomerCode = reader.IsDBNull(2) ? "" : reader.GetString(2); user.CustomerName = reader.IsDBNull(3) ? "" : reader.GetString(3); return user; } } return null; }
public static Tuple<List<User>,List<UserRoleInfo>> LoadUserList(string loginName = "") { var list = new List<User>(); var roles = new List<UserRoleInfo>(); SqlParameter[] parameters = new SqlParameter[1]; parameters[0] = new SqlParameter("@LoginName", SqlDbType.VarChar); parameters[0].Value = loginName; using (var reader = SqlHelper.ExecuteReader(ConnectionHelper.ConnectionString , CommandType.StoredProcedure , "t_Sys_User_LoadAll" , parameters)) { while (reader.Read()) { var user = new User(); user.UserId = reader.GetInt32(0); user.LoginName = reader.GetString(1); user.CustomerCode = reader.IsDBNull(2) ? "" : reader.GetString(2); user.PasswordPrompt = reader.IsDBNull(3) ? "" : reader.GetString(3); user.IsContractCustomer = reader.IsDBNull(4) ? false : reader.GetBoolean(4); user.Email = reader.IsDBNull(5) ? "" : reader.GetString(5); list.Add(user); } if (reader.NextResult()) { while (reader.Read()) { roles.Add(new UserRoleInfo{ RoleName = reader.GetString(1), UserId = reader.GetInt32(2) }); } } } return new Tuple<List<User>, List<UserRoleInfo>>(list, roles); }
/// <summary> /// 验证用户是否是超级管理 /// </summary> /// <param name="user"></param> /// <returns></returns> public static bool IsSuperAdmin(User user) { if (user == null || user.UserId <=0) { return false; } var permissions = UserManager.Instance.LoadUserPermissions(user.UserId); return IsSuperAdmin(permissions); }
public static User LoadById(int userId) { SqlParameter[] parameters = new SqlParameter[1]; parameters[0] = new SqlParameter("@UserId", SqlDbType.Int); parameters[0].Value = userId; using (var reader = SqlHelper.ExecuteReader(ConnectionHelper.ConnectionString , CommandType.StoredProcedure , "t_sys_User_LoadById" , parameters)) { if (reader.Read()) { var user = new User(); user.UserId = reader.GetInt32(0); user.LoginName = reader.GetString(1); user.CustomerCode = reader.IsDBNull(2) ? "" : reader.GetString(2); user.PasswordPrompt = reader.IsDBNull(3) ? "" : reader.GetString(3); user.IsContractCustomer = reader.IsDBNull(4) ? false : reader.GetBoolean(4); user.Email = reader.IsDBNull(5) ? "" : reader.GetString(5); return user; } } return null; }