/// <summary> /// 根据用户名获取用户实体 /// </summary> /// <param name="userName"></param> public static MODEL.User GetModel(string userName) { MODEL.User user = null; string sql = @"select * from userInfo join uType on userInfo.uType = uType.id where loginId=@userName"; using (SqlDataReader sda = DBHelper.ExecuteReader(sql, System.Data.CommandType.Text, new SqlParameter("@userName", userName))) { if (sda.HasRows) { if (sda.Read()) { user = new MODEL.User(); user.Id = sda.GetInt32(0); user.LoginId = sda.GetString(1); user.PassWord = sda.GetString(2); user.Guid = sda.GetString(3); user.Telephone = sda.GetString(4); user.Email = sda.GetString(5); user.RegTime = sda.GetDateTime(6); MODEL.UType uType = new MODEL.UType(); uType.Id = sda.GetInt32(7); uType.Name = sda.GetString(9); user.UType = uType; } return user; } else return null; } }
protected void Page_Load(object sender, EventArgs e) { string url = Request.QueryString["url"] ?? "Index.aspx"; string urlName = Request.QueryString["urlName"] ?? "首页"; if (IsPostBack) { MODEL.User user = new MODEL.User(); user.LoginId = Request.Form["txtName"].ToString(); user.PassWord = Request.Form["txtPwd"].ToString(); user.Guid = System.Guid.NewGuid().ToString(); user.Telephone = Request.Form["txtTel"].ToString(); user.Email = Request.Form["txtEmail"].ToString(); user.RegTime = DateTime.Now; MODEL.UType uType = new MODEL.UType(1); user.UType = uType; if (BLL.UserManager.AddUser(user)) { if (!String.IsNullOrEmpty(url)) { Response.Redirect("ShowMsg.aspx?uid=" + HttpUtility.UrlEncode(user.LoginId) + "&info" + HttpUtility.UrlEncode("注册成功")); } else { Response.Redirect("ShowMsg.aspx?url=" + HttpUtility.UrlEncode(url) + "&urlName=" + HttpUtility.UrlEncode(urlName) + "&uerName=" + HttpUtility.UrlEncode(user.LoginId) + "&info=" + HttpUtility.UrlEncode("注册成功")); } } } }
/// <summary> /// 根据用户名获取用户实体 /// </summary> /// <param name="userName"></param> public static MODEL.User GetModel(string userName) { MODEL.User user = null; string sql = @"select * from userInfo join uType on userInfo.uType = uType.id where loginId=@userName"; using (SqlDataReader sda = DBHelper.ExecuteReader(sql, System.Data.CommandType.Text, new SqlParameter("@userName", userName))) { if (sda.HasRows) { if (sda.Read()) { user = new MODEL.User(); user.Id = sda.GetInt32(0); user.LoginId = sda.GetString(1); user.PassWord = sda.GetString(2); user.Guid = sda.GetString(3); user.Telephone = sda.GetString(4); user.Email = sda.GetString(5); user.RegTime = sda.GetDateTime(6); MODEL.UType uType = new MODEL.UType(); uType.Id = sda.GetInt32(7); uType.Name = sda.GetString(9); user.UType = uType; } return(user); } else { return(null); } } }