public ActionResult loginValidate() { string username = Request["username"]; string password = Request["password"]; string isRemeber = Request["remember"]; if (username != null) { bll_mem = new BLL.member(); model_mem = new member(); model_mem = bll_mem.GetMemberByName(username); if (password == model_mem.userPwd) { if (isRemeber != null)//记住密码 { if (isRemeber == "true") { HttpCookie Username = new HttpCookie("username", username); HttpCookie Password = new HttpCookie("password", password); Response.Cookies.Add(Username); Response.Cookies.Add(Password); } } return(RedirectToAction("index", "mainForm")); } } return(null); }
public ActionResult HelloModelTest(Model.member model) { string name = model.userName; string text = model.userPwd; return(View()); }
//增加会员 public bool Addmember(Model.member model) { StringBuilder strSql = new StringBuilder(); strSql.Append(" insert into member("); strSql.Append(" Member_id,Name,Password,Level)"); strSql.Append(" values ("); strSql.Append(" @Member_id,@Name,@Password,@Level)"); SqlParameter[] parameters = { new SqlParameter("@Member_id", SqlDbType.VarChar, 20), new SqlParameter("@Name", SqlDbType.VarChar, 20), new SqlParameter("@Password", SqlDbType.VarChar, 20), new SqlParameter("@Level", SqlDbType.VarChar, 20) }; parameters[0].Value = model.Member_id; parameters[1].Value = model.Name; parameters[2].Value = model.Password; parameters[3].Value = model.Level; int rows = SqlDbHelper.ExecuteNonQuery(strSql.ToString(), CommandType.Text, parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 演示后台获取界面的值 /// </summary> /// <returns></returns> public ActionResult login() { HttpCookie Username = HttpContext.Request.Cookies["username"]; HttpCookie Password = HttpContext.Request.Cookies["password"]; if (Username != null && Password != null)//判断是否处于登录状态 { bll_mem = new BLL.member(); model_mem = new member(); model_mem = bll_mem.GetMemberByName(Username.Value); if (Password.Value == model_mem.userPwd) { return(RedirectToAction("index", "mainForm")); } } return(View()); }
//根据会员号,查询某个会员信息 public Model.member GetOnemember(string Member_id) { StringBuilder strSql = new StringBuilder(); strSql.Append(" select top 1 Member_id,Name,Password,Level"); strSql.Append(" from member where Member_id=@Member_id"); SqlParameter[] parameters = { new SqlParameter("@Member_id", SqlDbType.VarChar, 20) }; parameters[0].Value = Member_id; Model.member model = new Model.member(); DataTable dt = SqlDbHelper.ExecuteDataTable(strSql.ToString(), CommandType.Text, parameters); if (dt.Rows.Count > 0) { if (dt.Rows[0]["Member_id"] != null && dt.Rows[0]["Member_id"].ToString() != "") { model.Member_id = dt.Rows[0]["Member_id"].ToString(); } if (dt.Rows[0]["Name"] != null && dt.Rows[0]["Name"].ToString() != "") { model.Name = dt.Rows[0]["Name"].ToString(); } if (dt.Rows[0]["Password"] != null && dt.Rows[0]["Password"].ToString() != "") { model.Password = dt.Rows[0]["Password"].ToString(); } if (dt.Rows[0]["Level"] != null && dt.Rows[0]["Level"].ToString() != "") { model.Level = dt.Rows[0]["Level"].ToString(); } return(model); } else { return(null); } }
//更改会员信息(更改密码,更改等级) public bool Updatemember_passwd(Model.member model) { StringBuilder strSql = new StringBuilder(); strSql.Append(" update [member] set"); strSql.Append(" Name=@Name,"); strSql.Append(" Password=@Password,"); strSql.Append(" Level=@Level"); strSql.Append(" where Member_id=@Member_id"); SqlParameter[] parameters = { new SqlParameter("@Name", SqlDbType.VarChar, 20), new SqlParameter("@Password", SqlDbType.VarChar, 20), new SqlParameter("@Level", SqlDbType.VarChar, 20), new SqlParameter("@Member_id", SqlDbType.VarChar, 20) }; parameters[0].Value = model.Name; parameters[1].Value = model.Password; parameters[2].Value = model.Level; parameters[3].Value = model.Member_id; int rows = SqlDbHelper.ExecuteNonQuery(strSql.ToString(), CommandType.Text, parameters); if (rows == 1) { return(true); } else { return(false); } }
/// <summary> /// 用于向 member EntitySet 添加新对象的方法,已弃用。请考虑改用关联的 ObjectSet<T> 属性的 .Add 方法。 /// </summary> public void AddTomember(member member) { base.AddObject("member", member); }