/// <summary>
/// 用户注册
/// </summary>
/// <param name="username"></param>
/// <param name="pwd"></param>
/// <returns></returns>
public RegisterResult Register(string username, string pwd, string userType)
{
try
{
TUserManager userManager = new TUserManager();
TUser user = new TUser();
DataTable dt = GetUserInfo(username).Tables[0];
if (dt.Rows.Count > 0)
{
//用户已存在
return(RegisterResult.Err_Exist_user);
}
else
{
//用户不存在，可以注册
var dateTimeNow = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
user.UserID = QueryPrimaryID();
user.UserName = username;
user.UserPassword = pwd;
user.UserRole = userType;
user.UpdateDate = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
int executeResult = userManager.Insert(user);
if (executeResult < 1)
{
return(RegisterResult.Fail);
}
return(RegisterResult.Successful);
}
}
catch (Exception ex)
{
LogHelper.Log.Error("注册失败..." + ex.Message);
return(RegisterResult.Fail);
}
}
private void CheckSysAdminExist()
{
TUserManager userManager = new TUserManager();
var count = userManager.GetRowCountByWhere($"where UserName='******' and UserRole='管理员'");
if (count <= 0)
{
//系统管理员不存在
userHelper.Register("admin", "admin123", "管理员");
}
}
public string GetUserID(string username)
{
TUserManager userManager = new TUserManager();
var dt = userManager.GetDataSetByFieldsAndWhere("UserID", $"where UserName='******'").Tables[0];
if (dt.Rows.Count > 0)
{
return(dt.Rows[0][0].ToString());
}
return("");
}
private long QueryPrimaryID()
{
long id = -1;
TUserManager userManager = new TUserManager();
var dt = userManager.GetDataSetByWhere("order by UserID DESC limit 1").Tables[0];
if (dt.Rows.Count < 1)
{
return(id);
}
if (long.TryParse(dt.Rows[0]["UserID"].ToString(), out id))
{
return(id + 1);
}
return(id);
}
protected override void Dispose(bool disposing)
{
if (disposing)
{
if (_userManager != null)
{
_userManager.Dispose();
_userManager = null;
}
if (_signInManager != null)
{
_signInManager.Dispose();
_signInManager = null;
}
}
base.Dispose(disposing);
}
/// <summary>
/// 登录
/// </summary>
/// <param name="username">用户名/手机号/邮箱</param>
/// <param name="password">密码</param>
/// <returns></returns>
public LoginResult Login(string username, string password)
{
try
{
DataTable dt = GetUserInfo(username).Tables[0];
if (dt.Rows.Count < 1)
{
//用户不存在
LogHelper.Log.Info($"用户名{username}不存在，验证失败！");
return(LoginResult.Err_Username);
}
else
{
//用户存在
//验证登录密码
TUserManager userManager = new TUserManager();
var dtRes = userManager.GetDataSetByWhere($"where UserName='******' and UserPassword='******'").Tables[0];
if (dtRes.Rows.Count < 1)
{
//密码验证失败
LogHelper.Log.Info($"用户{username}密码验证失败！");
return(LoginResult.Err_Password);
}
else
{
//通过验证
LogHelper.Log.Info(username + " 登录进入 " + DateTime.Now);
return(LoginResult.Successful);
}
}
}
catch (Exception ex)
{
LogHelper.Log.Error("用户登录异常..." + ex.Message);
return(LoginResult.Fail);
}
}
public AccountController(TUserManager userManager, AppSignInManager signInManager)
{
UserManager = userManager;
SignInManager = signInManager;
}
/// <summary>
/// 查询用户信息
/// </summary>
/// <param name="userName"></param>
/// <returns></returns>
public DataSet GetUserInfo(string username)
{
TUserManager userManager = new TUserManager();
return(userManager.GetDataSetByFieldsAndWhere("UserRole,UserPassword,UserID", $"where UserName='******'"));
}
public int DeleteUser(string username)
{
TUserManager userManager = new TUserManager();
return(userManager.DeleteByWhere($"where UserName='******'"));
}
public int ModifyUserPassword(string oldUserName, string newUserName, string pwd)
{
TUserManager userManager = new TUserManager();
return(userManager.UpdateFields($"UserPassword = '******',UserName = '******'", $"where UserName='******'"));
}
/// <summary>
/// 查询所有用户信息
/// </summary>
/// <param name="userName"></param>
/// <returns></returns>
public DataSet GetAllUserInfo()
{
TUserManager userManager = new TUserManager();
return(userManager.GetAllDataSet());
}
