StartPage.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
using ClassLibrary2;

public partial class Default4 : System.Web.UI.Page
{
    string str = System.Configuration.ConfigurationManager.AppSettings["str_con"].ToString(); //连接数据库
    SqlConnection con = null;
    SqlCommand cmd = null;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            if (Value.style == 1)
            {
                bind("SELECT * FROM [dbo].[英雄信息表] WHERE 英雄类型='"+Value.Hero_style+"'");
            }
            else
            {
                bind("SELECT * FROM [dbo].[英雄信息表]");
            }
        }
    }
   
    protected void DataList1_ItemCommand1(object source, DataListCommandEventArgs e)
    { 
        if (e.CommandName == "In_car")
        {
            con = new SqlConnection(str);
            string name = DataList1.DataKeys[e.Item.ItemIndex].ToString().Trim();
            string sql_name = "SELECT * FROM [dbo].[购物车信息表] WHERE Commodity_Name = '" + name + "'and yh_id='" + Session["login"] + "'";
            con.Open();
            cmd = new SqlCommand(sql_name, con);
            if (Session["login"] != null)
            {
                if (cmd.ExecuteScalar() == null)
                {
                    string str_cmd = "INSERT INTO [dbo].[购物车信息表](yh_id,Commodity_Name,Num) VALUES('" + Session["login"] + "','" + name + "','1')";
                    cmd = new SqlCommand(str_cmd, con);
                    cmd.ExecuteNonQuery();
                    con.Close();
                    Response.Write("<script> alert('添加成功！')</script>");
                }
                else
                {
                    Response.Write("<script> alert('已添加到购物车！')</script>");
                }
            }
            else
            {
                Response.Write("<script> alert('请先登录！')</script>"); 
            }
           
        }