protected void btn_ServerClick(object sender, EventArgs e)
{
int id = 0;
gnum(ref id, "id");
MemberInfo info = new MemberInfo();
info.username = pform("username");
info.password = md5(pform("pwd"));
if (pform("sex") == "1")
info.sex = true;
else
info.sex = false;
info.truename = pform("truename");
info.email = pform("email");
info.telphone = pform("telphone");
info.mobile = pform("mobile");
info.qq = pform("qq");
info.birth = pform("birth");
info.address = pform("address");
info.nickname = pform("nickname");
MemberDal mb = new MemberDal();
mb.edit(info, id);
showMessage("修改成功");
}
public bool edit(MemberInfo info,int id)
{
int sex;
if (info.sex)
sex = 1;
else
sex = 0;
MemberInfo oldinfo = this.view(id);
if (string.IsNullOrEmpty(info.nickname))
info.nickname = oldinfo.nickname;
return this.DataSetEdit("member", id.ToString(),
"username",info.username,
"password",info.password,
"sex",sex,
"email",info.email,
"telphone", info.telphone,
"mobile",info.mobile,
"qq",info.qq,
"birth",info.birth,
"address",info.address,
"truename",info.truename,
"nickname",info.nickname
);
}
protected void Page_Load(object sender, EventArgs e)
{
int id = 0;
gnum(ref id,"id");
if (!IsPostBack)
{
MemberDal mb = new MemberDal();
MemberInfo info = new MemberInfo();
info = mb.view(id);
username.Value = info.username;
truename.Value = info.truename;
birth.Value = info.birth;
if (info.sex)
sex1.Checked = true;
else
sex2.Checked = true;
email.Value = info.email;
telphone.Value = info.telphone;
mobile.Value = info.mobile;
qq.Value = info.qq;
address.Value = info.address;
nickname.Value = info.nickname;
}
}
public int register(MemberInfo info)
{
//this.DataSetExecuteAddText("member",
// "username", info.username,
// "password", md5(info.password),
// "sex",info.sex,
// "email",info.email,
// "telphone",info.telphone,
// "mobile",info.mobile,
// "qq",info.qq,
// "birth",info.birth,
// "ip",info.ip,
// "address",info.address,
// "truename",info.truename
// );
//return 0;
return this.add("member",
"username", 2, info.username.Length, info.username,
"password", 2, 32, md5(info.password),
"sex", 5, 1, info.sex,
"email", 2, info.email.Length, info.email,
"telphone", 2, info.telphone.Length, info.telphone,
"mobile", 2, info.mobile.Length, info.mobile,
"qq", 2, info.qq.Length, info.qq,
"birth", 2, info.birth.Length, info.birth,
"ip", 2, info.ip.Length, info.ip,
"address", 2, info.address.Length, info.address,
"truename", 2, info.truename.Length, info.truename
);
}
public Userinfo()
{
if (ISPOST)
{
MemberInfo info = new MemberInfo();
info.username = minfo.username;
info.password = minfo.password;
if (pform("sex") == "1")
info.sex = true;
else
info.sex = false;
info.truename = pform("truename");
info.email = pform("email");
info.telphone = pform("telphone");
info.mobile = pform("mobile");
info.qq = "123123";//pform("qq");
info.birth = pform("birth");
info.ip = HttpContext.Current.Request.ServerVariables["REMOTE_ADDR"];
info.address = pform("address");
MemberDal pb = new MemberDal();
pb.edit(info, minfo.id);
showMessage("Ð޸ijɹ¦");
}
}
/// <summary>
/// ×¢²á
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public bool register(MemberInfo info)
{
MemberDal bal = new MemberDal();
if (bal.isreg(info.username))
{
bal.register(info);
login(info.username,info.password);
return true;
}
else
return false;
}
public Register()
{
WebConf conf = new WebConf();
if (conf.getVal("userreg") == "1")
{
showMessage("注册功能已经关闭");
}
if (ISPOST)
{
MemberInfo info = new MemberInfo();
info.username = pform("username");
if (info.username == "")
{
showMessage("用户名不能为空","javascript:history.back();");
return;
}
info.password = pform("pwd");
if (info.password != pform("repwd"))
{
showMessage("两次输入的密码不同", "javascript:history.back();");
return;
}
if (pform("sex") == "1")
info.sex = true;
else
info.sex = false;
info.truename = pform("truename");
info.email = pform("email");
if (info.email == "")
{
showMessage("email不能为空", "javascript:history.back();");
return;
}
info.telphone = pform("telphone");
info.mobile = pform("mobile");
info.qq = pform("qq");
info.birth = pform("birth");
info.ip = "ip";
info.address = pform("address");
PassportBll pb = new PassportBll();
if (pb.register(info))
{
string url = HttpContext.Current.Request.UrlReferrer.ToString();
die("<script type=\"text/javascript\">alert('注册成功');location.href='" + url + "'</script>");
}
else
die("<script type=\"text/javascript\">alert('注册失败');history.back();</script>");
}
}
public MemberAdmin()
{
PassportBll p = new PassportBll();
minfo = p.get();
string backurl = System.Web.HttpContext.Current.Request.Url.AbsolutePath;
if (HttpContext.Current.Request.QueryString != null)
{
backurl += "?"+HttpContext.Current.Request.QueryString.ToString();
backurl = HttpContext.Current.Server.UrlEncode(backurl);
}
if (string.IsNullOrEmpty(minfo.username))
System.Web.HttpContext.Current.Response.Redirect("/login.aspx?backurl="+backurl);
}
public bool login(MemberInfo info)
{
DataSet ds = DataSetExecuteText("select * from " + label_table + "member where username=@username and password=@password",
"@username",info.username,
"@password",md5(info.password)
);
DataSetExecuteText("update " + label_table + "member set lastlogin=@lastlogin where username=@username",
"@lastlogin",DateTime.Now.ToString(),
"@username",info.username);
if (ds.Tables[0].Rows.Count > 0)
return true;
else
return false;
}
/// <summary>
/// 怫
/// </summary>
/// <param name="username"></param>
/// <param name="password"></param>
/// <returns></returns>
public bool login(string username, string password)
{
MemberInfo info = new MemberInfo();
info.username = username;
info.password = password;
MemberDal bal = new MemberDal();
if (bal.login(info))
{
MemberInfo info1 = bal.view(username);
if (info1.nickname != "" && info.username != null)
setCookie("nickname", Server.UrlEncode(info1.nickname));
else
setCookie("nickname", username);
setCookie("username", username);
setCookie("password", md5(password));
return true;
}
else
return false;
}
/// <summary>
/// Óû§ÐÅÏ¢
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public MemberInfo view(int id)
{
DataSet ds = DataSetFind("member", "id", id.ToString());
MemberInfo info = new MemberInfo();
if (ds.Tables.Count > 0)
{
DataRow dr = ds.Tables[0].Rows[0];
info.id = int.Parse(dr["id"].ToString());
info.username = dr["username"].ToString();
info.password = dr["password"].ToString();
info.truename = dr["truename"].ToString();
info.sex = bool.Parse(dr["sex"].ToString());
info.telphone = dr["telphone"].ToString();
info.mobile = dr["mobile"].ToString();
info.birth = dr["birth"].ToString();
info.address = dr["address"].ToString();
info.qq = dr["qq"].ToString();
info.email = dr["email"].ToString();
info.nickname = dr["nickname"].ToString();
}
return info;
}
public List<MemberInfo> get_list(int page, int pagesize)
{
List<MemberInfo> list = new List<MemberInfo>();
DataSet ds = DataSetPageFind("member", page, pagesize);
if (ds.Tables.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
MemberInfo info = new MemberInfo();
info.id = int.Parse(dr["id"].ToString());
info.username = dr["username"].ToString();
info.truename = dr["truename"].ToString();
info.telphone = dr["telphone"].ToString();
list.Add(info);
}
}
return list;
}
