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