searchpage.aspx.cs

C#编的网上交易站点系统。实现购买

using System;
using System.Data;
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 Default_aspx
{
    void Button1_Click(object sender, EventArgs e)
    {
        string str = "select * from 花卉信息表 where 花名 like " + "'%" + textsearch.Text + "%'";//提供即将模糊查询的SQL语句
        DataSet ds = dal.exedataset(str);//
        dg.DataSource = ds;
        dg.DataBind();
    }


    void Page_Load(object sender, EventArgs e)
    {
        welinfo.Text = "欢迎前来购物,"+Session["username"].ToString();

    }


    void DataGrid1_ItemCommand(object source, DataGridCommandEventArgs e)//点击此按钮后,购物车将出现,并且每点一次,相应花卉的数量就会加一
    {
        if (e.CommandName == "buy")
        {
            string flowerid;
            flowerid = e.Item.Cells[1].Text.Trim();//用flowerid保存当前点击项的花卉编号,Cells[1]表示的是第二个单元格
            string sql = "select *  from 花卉信息表 where 花ID=" + flowerid;
            DataTable dt = new DataTable();//新建一数据表
            dt = (DataTable)Session["cart"];//将购物车的内容送给dt
            int j = dt.Rows.Count;//获得表格的行数
            int i = 0;
            bool exits = false;//将来表示该花卉是否已存在
            int presentid;//将来表示数据表中的当然花卉ID

            while (i < j && !exits)//若花不存在
            {
                presentid = Convert.ToInt32(dt.Rows[i][0].ToString());//获得当前行的花ID
                if (presentid == Convert.ToInt32(flowerid))   //若当前行花ID 等于datagrid点击行的花ID,则说明该花在购物车中已存在                               //判断购物信息表中，是否存有当前放入商品。 
                {
                    exits = true;//花存在
                }
                else
                {
                    i++;//若花不在,测试下一行
                }
            }

            if (exits)//如果已有该商品,要将花卉数量加一
            {
                DataRow olddr;
                olddr = dt.Rows[i];
                olddr["qty"] = Convert.ToInt32(olddr["qty"].ToString()) + 1;
                olddr["total"] = Convert.ToInt32(olddr["qty"].ToString()) * Convert.ToDouble(olddr["价格"].ToString());//花总额的计算
            }

            else//若花不存在,则要在购物车中加一行
            {
                DataRow dr = dal.exedataset(sql).Tables[0].Rows[0];//获得要增加行的相关信息
                DataRow newdr = dt.NewRow();//将dt新增一行
                newdr["花ID"] = dr["花ID"];//给该行一列列赋值
                newdr["qty"] = "1";
                newdr["价格"] = dr["价格"];
                newdr["total"] = Convert.ToInt32(dr["价格"]);
                dt.Rows.Add(newdr);
                Session["cart"] = dt;//更改购物车
            }
            cart.DataSource = (DataTable)Session["cart"];
            cart.DataBind();//更改购物车的显示
        }
    }


    void Button2_Click(object sender, EventArgs e)
    {
        DataTable dt =(DataTable)Session["cart"];
        int i = dt.Rows.Count;

        int j;
        double total = 0;
        for (j = 0; j < i ; j++)
        {
            total = total + Convert.ToDouble(dt.Rows[j]["total"].ToString()) ;
        }

        TextBox5.Text = total.ToString();
        string sql = "select 会员等级ID from  客户信息表 where 用户名='" + Session["username"].ToString() + "'";
        string percent = dal.exedataset(sql).Tables[0].Rows[0]["会员等级ID"].ToString();
        sql = "select 优惠额 from  会员等级信息表 where 会员等级ID='" + percent + "'";
        string final = dal.exedataset(sql).Tables[0].Rows[0]["优惠额"].ToString();
        TextBox6.Text = final;
        double finaltotal = Convert.ToDouble(final);
        finaltotal = finaltotal * total;
        TextBox7.Text = finaltotal.ToString();
    }





    void cart_DeleteCommand(object source, DataGridCommandEventArgs e)
    {
        
            DataTable dt = new DataTable();
            dt = (DataTable)Session["cart"];
            int a = dt.Rows.Count;
            int j = 0;
            while (j < a)
            {
                string f = dt.Rows[j]["花ID"].ToString().Trim();
                string t = e.Item.Cells[0].Text.Trim();
                if (f == t)
                {
                    dt.Rows[j].Delete();
                    break;
                }
                else
                { j++; }
            }
            Session["cart"] = dt;
            cart.DataSource = dt;
            cart.DataBind();
        
    }


    void cart_ItemCommand(object source, DataGridCommandEventArgs e)
    {
        string str;
        DataTable dt = new DataTable();
        dt = (DataTable)Session["cart"];
        TextBox countbox = (TextBox)e.Item.Cells[1].FindControl("qty");
        str = countbox.Text;
        double i;
        i = Convert.ToInt32(str) * Convert.ToInt32(e.Item.Cells[2].Text);
        e.Item.Cells[3].Text = i.ToString();
        int a = dt.Rows.Count;
        int j = 0;
        while (j < a)
        {
            string f = dt.Rows[j]["花ID"].ToString().Trim();
            string t = e.Item.Cells[0].Text.Trim();
            if (f == t)
            {
                dt.Rows[j]["qty"] = str;
                dt.Rows[j]["total"] = i.ToString();
                break;
            }
            else
            { j++; }
        }
        Session["cart"] = dt;

    }

        void Button6_Click(object sender, EventArgs e)
        {
            DataTable dt = new DataTable();
            dt = (DataTable)Session["cart"];
            string name = Session["username"].ToString();
            string t = DateTime.Now.ToString();

            string selmax = "select max(订单ID) from 客户订单表";

            int maxorderid = dal.execscalar(selmax);
            maxorderid++;
            string ordertable = "insert into 客户订单表 values ('" + name + "'," + maxorderid + ",'" + t + "')";
            dal.insert(ordertable);
            int i;
            WebService ws = new WebService();
            for (i = 0; i < dt.Rows.Count; i++)
            {
                DataRow dr;
                dr = dt.Rows[i];
                string detailtable = "insert into 订单明细 values (" + maxorderid + ",'" + dr["花ID"].ToString()+"'," + dr["qty"] + ","+ws.selectlevel()+")";
                dal.insert(detailtable);
            }
            
            double a = ws.totalmoney();
            TextBox3.Text = "交易成功!";
            if (a >= 100 && a < 200 && ws.selectlevel()==1)
            {
                ws.updatelevel("2");
                TextBox3.Text = "\n由于您的消费额已超过100元,\n您现在已经升至二星级会员,\n今后可享受八五折优惠!\n继续努力!继续升级!";
            }
            if (a >= 200 && a < 300 && ws.selectlevel() <2)
            {
                ws.updatelevel("3");
                TextBox3.Text = "\n由于您的消费额已超过200元,\n您现在已经升至三星级会员,\n今后可享受八折优惠!\n继续努力!继续升级!";
            }
            if (a >= 300 && a < 400 && ws.selectlevel()< 3)
            {
                ws.updatelevel("4");
                TextBox3.Text = "\n由于您的消费额已超过300元,\n您现在已经升至四星级会员,\n今后可享受七折优惠!\n继续努力!继续升级!";
            }
            if (a >= 400 && ws.selectlevel() <4)
            {
                ws.updatelevel("5");
                TextBox3.Text = "\n由于您的消费额已超过400元,\n您现在已经升至五星级会员,\n今后可享受六折优惠!";
            }
            string sqlupdate = "update 客户信息表 set 银行卡余额=银行卡余额-" +Convert.ToDouble(TextBox7.Text)+"where 用户名='" +Session["username"].ToString()+"'";
            dal.update(sqlupdate);

        }
        void dg_PageIndexChanged(object source, DataGridPageChangedEventArgs e)
        {
            dg.CurrentPageIndex = e.NewPageIndex;
            DataSet ds = new DataSet();
            string sql = "select * from 花卉信息表 ";
            ds = dal.exedataset(sql);
            dg.DataSource = ds;
            dg.DataBind();

        }



    }