/// <summary> /// 记录用户信息 /// </summary> /// <param name="urInfoModel">用户信息</param> /// <returns>结果:0 失败 1 成功</returns> public int InserUserInfo(UserInfoModel urInfoModel) { int resultInt = 0; #region - sql qy - string insertQy = @"INSERT INTO `movehouse`.`userinfo` (`ID`, `UserName`, `Pwd`, `Mail`, `Mobile`, `RegisterLogin`, `LastLogin`, `avg1`, `avg2`) VALUES (@ID, @UserName, @Pwd, @Mail, @Mobile, @RegisterLogin, @LastLogin, @avg1, @avg2);"; #endregion #region - paras - MySqlParameter[] paras = { new MySqlParameter("@ID",urInfoModel.ID), new MySqlParameter("@UserName",urInfoModel.UserName), new MySqlParameter("@Pwd",urInfoModel.Pwd), new MySqlParameter("@Mail",urInfoModel.Mail), new MySqlParameter("@Mobile",urInfoModel.Mobile), new MySqlParameter("@RegisterLogin",urInfoModel.RegisterLogin), new MySqlParameter("@LastLogin",urInfoModel.LastLogin), new MySqlParameter("@avg1",string.Empty), new MySqlParameter("@avg2",string.Empty) }; #endregion #region - Excute - try { resultInt = Convert.ToInt32(DbHelperMySql.ExecuteNonQuery(DbHelperMySql.connectionStringManager, System.Data.CommandType.Text, insertQy, paras)); } catch (Exception ex) { //记录错误信息 throw; } #endregion return resultInt; }
public ContentResult LoginForm(string userName,string pwd) { UserInfoModel urInfoModel = new UserInfoModel(); // urInfoModel.ID = Guid.NewGuid().ToString(); urInfoModel.UserName = userName.Trim().ToLower(); urInfoModel.Pwd = pwd.Trim().ToLower(); int resultInt= urInfoBll.LoginUserInfo(urInfoModel,LoginType.用户名); if (resultInt > 0) { Session["LoginUser"] = urInfoModel; } return Content(resultInt.ToString()); }
/// <summary> /// 登录 /// </summary> /// <param name="urInfoModel"></param> /// <param name="loginType"></param> /// <returns></returns> public int LoginUserInfo(UserInfoModel urInfoModel,LoginType loginType) { UserInfoModel urInfoModelTmp = new UserInfoModel(); int resultInt = 0; #region - sql qy - string selectQy = @"SELECT `ID`, `UserName`, `Pwd`, `Mail`, `Mobile`, `RegisterLogin`, `LastLogin`, `avg1`, `avg2` FROM `movehouse`.`userinfo` AS urInfo"; StringBuilder sbWhere = new StringBuilder(); sbWhere.Append(" where "); // sbWhere.Append(" urInfo.`Pwd`=@Pwd "); switch (loginType) { case LoginType.用户名: sbWhere.Append(" urInfo.`UserName`=@UserName"); break; case LoginType.邮箱: sbWhere.Append(" urInfo.`Mail`=@Mail"); break; case LoginType.手机: sbWhere.Append(" urInfo.`Mobile`=@Mobile"); break; default: break; } selectQy = selectQy + sbWhere.ToString(); #endregion #region - paras - MySqlParameter[] paras = { new MySqlParameter("@UserName",urInfoModel.UserName) // new MySqlParameter("@Pwd", urInfoModel.Pwd.ToLower()), }; #endregion #region - Excute - //记录查询 DataTable dataTable = DbHelperMySql.GetDataSet(DbHelperMySql.connectionStringManager, selectQy, paras).Tables[0]; if (dataTable != null) { urInfoModelTmp = new UserInfoModel(); foreach (DataRow row in dataTable.Rows) { urInfoModelTmp=TransUserInfoModel(row); } } #endregion if (string.Equals(urInfoModelTmp.Pwd,urInfoModel.Pwd)) { resultInt = 1; } return resultInt; }
/// <summary> /// 转换至UserInfoModel /// </summary> /// <param name="row"></param> /// <returns></returns> public UserInfoModel TransUserInfoModel(DataRow row) { UserInfoModel urInfoModel = new UserInfoModel(); urInfoModel.ID = row["ID"] != null ? row["UserName"].ToString() : string.Empty; urInfoModel.UserName = row["UserName"] != null ? row["UserName"].ToString() : string.Empty; urInfoModel.Pwd = row["Pwd"] != null ? row["Pwd"].ToString() : string.Empty; urInfoModel.Mail = row["Mail"] != null ? row["Mail"].ToString() : string.Empty; urInfoModel.Mobile = row["Mobile"] != null ? row["Mobile"].ToString() : string.Empty; urInfoModel.RegisterLogin = row["RegisterLogin"] != null ? Convert.ToDateTime(row["RegisterLogin"]) : DateTime.MinValue; urInfoModel.LastLogin = row["LastLogin"] != null ? Convert.ToDateTime(row["LastLogin"]) : DateTime.MinValue; return urInfoModel; }
//} /// <summary> /// 登录用户 /// </summary> /// <param name="urInfoModel"></param> /// <returns></returns> public int LoginUserInfo(UserInfoModel urInfoModel,LoginType loginType) { urInfoModel.Pwd = Md5Helper.MD5(urInfoModel.Pwd.Trim().ToLower()); return urInfoDal.LoginUserInfo(urInfoModel, loginType); }
/// <summary> /// 注册用户 /// </summary> /// <param name="urInfoModel">用户信息</param> /// <returns>结果0 失败 1 成功</returns> public int InserUserInfo(UserInfoModel urInfoModel) { urInfoModel.Pwd = Md5Helper.MD5(urInfoModel.Pwd.Trim().ToLower()); return urInfoDal.InserUserInfo(urInfoModel); }
public ContentResult RegisterForm(string userName,string pwd,string mail,string mobile) { int resultInt = 0; #region - check paras- if (string.IsNullOrEmpty(userName) || string.IsNullOrEmpty(pwd) || string.IsNullOrEmpty(mail) || string.IsNullOrEmpty(mobile)) { return Content("参数错误"); ; } #endregion #region - ecute - UserInfoModel urInfoModel = new UserInfoModel(); urInfoModel.ID = Guid.NewGuid().ToString(); urInfoModel.UserName = userName.Trim().ToLower(); urInfoModel.Mail = mail.Trim().ToLower(); urInfoModel.Pwd = pwd.Trim().ToLower(); urInfoModel.Mobile = mobile.Trim().ToLower(); urInfoModel.RegisterLogin = DateTime.Now; urInfoModel.LastLogin = DateTime.Now; resultInt= urInfoBll.InserUserInfo(urInfoModel); #endregion return Content((resultInt>0).ToString()); }