//取出用户昵称
public SoundMember selectMemById(string id)
{
SoundMember m = new SoundMember();
string cmdText = "select userId from member where id=@id";
SqlParameter[] paras = new SqlParameter[] {
new SqlParameter("@id",id)
};
DataTable dt = new DataTable();
dt = sqlhelper.ExecuteQuery(cmdText, paras, CommandType.Text);
m.UserId = dt.Rows[0]["userId"].ToString();
return m;
}
//添加用户
public bool addMember(SoundMember add)
{
bool flag = false;
string cmdText = "Pr_AddMember";
SqlParameter[] paras = new SqlParameter[] {
new SqlParameter("@Name", add.Name),
new SqlParameter("@Pw", add.Pw),
new SqlParameter("@UserId",add.UserId)
};
int res = (sqlhelper.ExecuteNonQuery(cmdText, paras, CommandType.StoredProcedure));
if (res > 0)
{
flag = true;
}
return flag;
}
public bool upMember(SoundMember up)
{
return mdao.upMember(up);
}
public bool addMember(SoundMember add)
{
return mdao.addMember(add);
}
protected void BRegister_Click(object sender, EventArgs e)
{
//定义变量
string tbname = null;
string tbpwd = null;
string tbpwds = null;
string tbvd = null;
string tbuserid = null;
string Validate_code = null;
string Error;
//赋值
tbname = TBName.Text.Trim();
tbpwd = TPWD.Text.Trim();
tbpwds = TPWDS.Text.Trim();
tbuserid = TBUserId.Text.Trim();
tbvd = TVitorD.Text.Trim();
//验证
bool bname = new SoundMemberManager().IsExists(tbname);
if (bname)
{
Error = "用户已存在，请换个名字";
TVitorD.Text = "";
showMessage.Js(this, Error, -1);
return;
}
if (tbpwd != tbpwds)
{
Error = "密码与确认密码不一致";
TVitorD.Text = "";
showMessage.Js(this, Error, -1);
return;
}
if (Session["Validate_code"] == null)
{
//Error = "验证码出错";
//kf_cms.Common.ContextHelper.Js(this, Error, -1);
Response.Redirect("register.aspx");
}
Validate_code = Session["Validate_code"].ToString();
if (Validate_code != tbvd)
{
Error = "验证码有误";
TVitorD.Text = "";
showMessage.Js(this, Error, -1);
return;
}
//注册
SoundMember m = new SoundMember();
m.Name = tbname;
m.Pw = tbpwd;
m.UserId = tbuserid;
bool b = new SoundMemberManager().addMember(m);
if (b)
{
string savePath = Server.MapPath("~/music/");
string saveName = savePath + tbname;
Directory.CreateDirectory(saveName);
showMessage.JsHistory(this, "注册成功！！", -1);
}
}
//取出用户信息
public SoundMember selectMemByName(string name)
{
SoundMember m = new SoundMember();
string cmdText = "select createTime,name,pw,userId,id from member where name=@name";
SqlParameter[] paras = new SqlParameter[] {
new SqlParameter("@name",name)
};
DataTable dt = new DataTable();
dt = sqlhelper.ExecuteQuery(cmdText, paras, CommandType.Text);
m.Id = dt.Rows[0]["id"].ToString();
m.Name = dt.Rows[0]["name"].ToString();
m.Pw = dt.Rows[0]["pw"].ToString();
m.UserId = dt.Rows[0]["userId"].ToString();
m.CreateTime = dt.Rows[0]["createTime"].ToString();
return m;
}
