//取出用户昵称 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; }