submit.aspx.cs

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

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

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

public partial class submit : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            Label1.Text = DateTime.Now.ToString("yyyyMMddhhmmssfff");
        }
    }
    protected void btnAdd_Click(object sender, EventArgs e)
    {
        if (Session["mid"] == null)
        {
            MessageBox.Show(this, "请先登录！");
            return;
        }

        //声明购物车类，并赋值
        ShopCart car = (ShopCart)Session["car"];

        //设置添加sql
        StringBuilder strSql = new StringBuilder();
        strSql.Append(@"insert into Orders ( ddbh,mid,ddbz,dgsj ) ");
        strSql.Append(@" values (@ddbh,@mid,@ddbz,@dgsj)");

        //设置参数
        SqlParameter[] parameters = new SqlParameter[] {
            new SqlParameter("@ddbh", SqlDbType.VarChar,20),
            new SqlParameter("@mid", SqlDbType.Int,4),
            new SqlParameter("@ddbz", SqlDbType.VarChar,500),
            new SqlParameter("@dgsj", SqlDbType.DateTime,8)        };

        parameters[0].Value = Label1.Text;
        parameters[1].Value = int.Parse(Session["mid"].ToString());
        parameters[2].Value = txt_ddbz.Text;
        parameters[3].Value = DateTime.Now;
        
        //提交到数据库
        SqlHelper.ExecuteNonQuery(strSql.ToString(),CommandType.Text,parameters);

        //遍历购物车
        ICollection orders = car.Orders;

        foreach (ProductItem pd in orders)
        {
            //设置添加sql
            string Sql = String.Format(@"insert into orders_detail(ddbh,mbh,sl)