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;
}
