index.aspx.cs

前台首页：users/index.aspx 后台首页：login.aspx 这是一个有关宠物的电子商务网站 注：后台的“售后服务” 和“数据统计”这两块由于时间原因暂时 没完成。由于技术问

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 buy : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        //随机生成 验证码

        Random rnd = new Random();
        TextBox4.Text = rnd.Next(1000, 8000).ToString();
        //用户统计
        
        TextBox5.Text = Application["currentuser"].ToString();
        TextBox6.Text = Application["alluser"].ToString();
       
    }
    private void ShowMassage(string msg)
    {
        Response.Write("<script>alert('" + msg + "')</script>");
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        SqlConnection sqlcon = new SqlConnection("data source=localhost;uid=sa;pwd=;database=Ebusiness");
        sqlcon.Open();
        SqlCommand objsqlcomm = new SqlCommand();
        objsqlcomm.Connection = sqlcon;
        objsqlcomm.CommandText = "mp_verifyuser";
        objsqlcomm.CommandType = CommandType.StoredProcedure;
        SqlParameter par1 = new SqlParameter("@username", SqlDbType.VarChar, 50);
        par1.Direction = ParameterDirection.Input;
        SqlParameter par2 = new SqlParameter("@password", SqlDbType.VarChar, 50);
        par2.Direction = ParameterDirection.Input;

        objsqlcomm.Parameters.Add(par1);
        objsqlcomm.Parameters.Add(par2);

        par1.Value = TextBox1.Text;
        par2.Value = TextBox2.Text;
        Session["user"] =TextBox1.Text;
        Session["pwd"] = TextBox2.Text;
        SqlDataReader reader = objsqlcomm.ExecuteReader();
        if (reader.Read())
        {
            int i, a,userid;
            i = reader.GetInt32(0);
            a = reader.GetInt32(1);
            userid = reader.GetInt32(2);
            Session["userid"] = userid.ToString();
            if (i == 1 && a == 1)
            {

                ShowMassage("登陆成功...管理员,你好！");
                reader.Close();
                return;

            }
            else
            {
                if (i == 0 && a == 1)
                {

                    ShowMassage("登陆成功...会员,你好！");
                    reader.Close();
                    return;

                }
            }
        }
        else
        {

            ShowMassage("登陆失败..您好！您的身份是游客。");
            return;
        }
        sqlcon.Close();
        objsqlcomm = null;
        sqlcon = null;

    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        Response.Redirect("zhuce.aspx");
    }
    protected void GridView2_SelectedIndexChanged(object sender, EventArgs e)
    {
      
        string v = GridView2.DataKeys[GridView2.SelectedIndex].Value.ToString();
        Session["content"] = v;

        Response.Redirect("content.aspx");
    }

    protected void BuyBtn_Click(object sender, EventArgs e)
    {
        string struser = Convert.ToString(this.Session["user"]);
        if (struser== "")
            ShowMassage("您还没登录！请先登录");
        else
        {
            Session["buy"]+=((Button)sender).CommandArgument.ToString()+",";
            
        }
    }

    protected void Button3_Click(object sender, EventArgs e)
    {
        Response.Redirect("sto.aspx");
    }
    protected void stoBut(object sender, EventArgs e)
    {
        Session["sto"] += ((Button)sender).CommandArgument.ToString() + ",";
    }
    protected void Button4_Click(object sender, EventArgs e)
    {
        Response.Redirect("shoucang.aspx");
    }
}