login.aspx.cs

网上书店 含用户注册

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class login : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void denglutm_Click(object sender, EventArgs e)
    {
        string sql_user = string.Format("select count(*) from tbluser where userName='"+tbuser.Text+"' and userPwd='"+tbpwd.Text+"'");
        int usercount = int.Parse(Class1.SelOne(sql_user));
        if (TextBox1.Text.ToLower() != Request.Cookies["CheckCode"].Value.ToString().ToLower())
        {
            Response.Write("<script language='javascript'>alert('验证码错误!');</script>");
        }
        else
        {
            if (usercount == 0)
            {
                if (tbuser.Text == null || tbpwd.Text == null)
                {
                    Response.Write("<script language='javascript'>alert('用户名或密码不能为空!');</script>");
                }
                else
                {
                   Response.Write("<script language='javascript'>alert('用户名或密码错误!!!!!');</script>");
                }
            }
            else
            {
                Session["userlogin"] = tbuser.Text;
                string userinfo = Session["userlogin"].ToString();
                DataTable dt = Class1.ExecSel("select * from tbluser where userName='" + userinfo + "'");
                int id = Convert.ToInt32(dt.Rows[0][0]);
                string info = "select * from tbluser where userID=" + id;
                DataTable datatable = Class1.ExecSel(info);
                if (Convert.ToInt32(datatable.Rows[0][8].ToString()) == 0)
                {
                    Response.Redirect("UserMain.aspx");
                }
                else
                {
                    Response.Write("<script language='javascript'>alert('没有该用户!!!!!');</script>");
                    //Response.Redirect("admin_login.aspx");
                }
            }
        }
    }
}