public bool isLogin(tb_login login) { if (ld.isLogin(login)==0) { return false; } else { return true; } }
public List<tb_login> selLogin() { tb_login login=null; string sel = "select ID,Name,LoginDate,Lock from tb_login"; List<ArrayList> list = sqlDal.sqlDr(sel, null, null); List<tb_login> loginList = new List<tb_login>(); foreach (ArrayList obj in list) { login = new tb_login(); login.Id = (int)obj[0]; login.Name = obj[1].ToString(); login.LoginDate = (DateTime)obj[2]; login._lock1 = (int)obj[3]; loginList.Add(login); } return loginList; }
protected void btnReg_Click(object sender, EventArgs e) { tb_login login = new tb_login(); if (txtUser.Text.Trim() != "") { if (lb.isUserName(txtUser.Text.Trim())) { login.Name = txtUser.Text; login.Pass = txtPsw1.Text; if (rdoMan.Checked) { login.Sex = "男"; } else { login.Sex = "女"; } login.PassSolution = txtSolu.Text; login.PassQuestion = txtQues.Text; login.Zname = txtTureName.Text; login.Idcard = txtPersonNum.Text; login.Email = txtMail.Text; if (lb.addLogin(login) > 0) { Session["UserName"] = login.Name; Response.Write("<script>alert('注册成功!');location='index.aspx'</script>"); } else { Response.Write("<script>alert('注册失败!')</script>"); } } else { Response.Write("<script>alert('用户名已存在!');location='Registe.aspx'</script>"); } } else { Response.Write("<script>alert('用户名不能为空!');location='Registe.aspx'</script>"); } }
protected void btnLogin_Click(object sender, ImageClickEventArgs e) { if (txtUser.Text.Trim() != "" && txtPsw.Text.Trim()!="") { tb_login login = new tb_login(); login.Name = txtUser.Text.Trim(); login.Pass = txtPsw.Text.Trim(); if (lb.isLogin(login)) { Session["UserName"] = login.Name; Response.Redirect("Manage/manageIndex.aspx"); } else { Response.Write("<script>alert('登陆失败!');location='manageLogin.aspx'</script>"); } } else { Response.Write("<script>alert('用户名或密码不能为空!');location='manageLogin.aspx'</script>"); } }
protected void btnLogin_Click(object sender, ImageClickEventArgs e) { tb_login login=new tb_login(); login.Name=txtUser.Text; login.Pass=txtPsw.Text; if (txtCheckNum.Text==Session["ValidateCode"].ToString()) { if (lb.isLogin(login)) { Session["UserName"] = login.Name; Response.AddHeader("Refresh", "0"); } else { Response.Write("<script>alert('用户名或密码错误!')</script>"); Response.AddHeader("Refresh", "0"); } } else { Response.Write("<script>alert('验证码错误!')</script>"); Response.AddHeader("Refresh", "0"); } }
public int addLogin(tb_login login) { return ld.addLogin(login); }
public int isLogin(tb_login login) { return (int)sqlDal.sqlOneDr("select count(*) from tb_login where convert(varchar,Name)=@Name and convert(varchar,Pass)=@Pass and Lock=0", new string[] { "@Name", "@Pass" }, new string[] { login.Name, login.Pass }); }
public int addLogin(tb_login login) { return sqlDal.sqlUpdate("insert into tb_login(Name,Pass,Zname,Sex,Email,IDcard,PassQuestion,PassSolution) values(@Name,@Pass,@Zname,@Sex,@Email,@IDcard,@PassQuestion,@PassSolution)", new string[]{"@Name","@Pass","@Zname","@Sex","@Email","@IDcard","@PassQuestion","@PassSolution"}, new string[]{login.Name,login.Pass,login.Zname,login.Sex,login.Email,login.Idcard,login.PassQuestion,login.PassSolution}); }