/// <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);
}
}
}
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("注册成功"));
}
}
}
}
