法甲

asp.net 实现购物车详细代码

2019-09-13 19:06:50来源:励志吧0次阅读

<%@ Page language="c#" Codebehind="shoppingcart.aspx.cs" AutoEventWireup="false" Inherits="myshop.shoppingcart" %><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" ><HTML> <HEAD>

<title>shoppingcart

</title>

<meta http-equiv="Content-Type" content="text/html;

charset=gb2312"> <LINK href="mycss.css" type="text/css" rel="stylesheet">

<meta name="vs_defaultClientScript" content="JavaScript">

<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5"> </HEAD>

<body> <center>

<form id="Form1" runat="server"> <table width="500" border="0" cellspacing="0" cellpadding="0"> <tr> <td>

<asp:DataGrid id="ShoppingCartDlt" runat="server" Width="500" BackColor="white" BorderColor="black" ShowFooter="false" CellPadding="3" CellSpacing="0" Font-Name="Verdana" Font-Size="8pt" HeaderStyle-BackColor="#cecfd6" AutoGenerateColumns="false" MaintainState="true"> <Columns>

<asp:TemplateColumn HeaderText="删除">

<ItemTemplate> <center>

<asp:CheckBox id="chkProductID" runat="server" /> </center>

</ItemTemplate> </asp:TemplateColumn>

<asp:BoundColumn DataField="ProdID" HeaderText="ID" />

<asp:BoundColumn DataField="ProName" HeaderText="商品名称" />

<asp:BoundColumn DataField="UnitPrice" HeaderText="单价" />

<asp:TemplateColumn HeaderText="数量">

<ItemTemplate>

<asp:TextBox id="CountTb" runat="server" Text='<%#DataBinder.Eval( Container.DataItem,"ProdCount" )%>'> </asp:TextBox>

</ItemTemplate> </asp:TemplateColumn>

<asp:BoundColumn DataField="TotalPrice" HeaderText="小计( 元 )" /> </Columns> </asp:DataGrid></td> </tr> </table> <br> <table width="500" border="0" cellspacing="0" cellpadding="0"> <tr> <td>

<asp:Button id="update" runat="server" Text="更新我的购物车" CssClass="button2" /></td> <td>

<asp:Button id="CheckOut" runat="server" Text="结算" CssClass="button5" />

<input type="button" name="close2" value="继续购物" onClick="window.close( );

return false;

" class="button2"></td> <td align="right"><br>

<asp:Label id="label" runat="server" Width="100px" Visible="True" ForeColor="#FF8080" Height="18px"></asp:Label></td> </tr> </table>

</form> </center>

</body></HTML>=======================================================================================以上为HTML页面部分==========================================================================================

using System;

using System.Collections;

using System.ComponentModel;

using System.Web.SessionState;

using System.Web;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Data;

using System.Data.OleDb;

using System.Configuration;

namespace myshop

{

/// <summary> /// shoppingcart 的摘要说明. /// </summary> public class shoppingcart : System.Web.UI.Page

{

protected System.Web.UI.WebControls.DataGrid ShoppingCartDlt;

protected System.Web.UI.WebControls.Button update;

protected System.Web.UI.WebControls.Button CheckOut;

protected System.Web.UI.HtmlControls.HtmlForm Form1;

protected System.Web.UI.WebControls.Label label;

protected System.Web.UI.WebControls.CheckBox chkProductID;

protected System.Web.UI.WebControls.TextBox txtCount;

protected System.Web.UI.WebControls.TextBox CountTb;

string AddProID;

private void Page_Load( object sender, System.EventArgs e )

{

try

{

if ( Session["logon"]!="yes"||Session["username"]==null )

{

Response.Redirect( "error.htm" ) ;

}

}

catch

{

Response.Redirect( "error.htm" ) ;

}

/////////////查看用户是否已经登陆.

if( !IsPostBack )

{

if( Request.Params["mode"]=="view" ) //检测是否为直接查看购物车.

{

ViewShoppingCart( );

Caculator( );

}

if( Request.Params["productID"]!=null||Request.Params["productID"]!="" )

{

AddProID=Request["productID"];

UpdateShoppingCart( );

Caculator( );

}

}

// 在此处放置用户代码以初始化页面

}

public void CreateCartTable( ) //创建购物车

{

DataSet ds = new DataSet( );

DataTable newDT=new DataTable( "CartTable" );

ds.Tables.Add( newDT );

DataColumn newDC;

newDC=new DataColumn( "ProdID",System.Type.GetType( "System.Int32" ) );

ds.Tables["CartTable"].Columns.Add( newDC );

newDC=new DataColumn( "ProdCount",System.Type.GetType( "System.Int32" ) );

newDC.DefaultValue=1;

ds.Tables["CartTable"].Columns.Add( newDC );

newDC=new DataColumn( "ProName",System.Type.GetType( "System.String" ) );

ds.Tables["CartTable"].Columns.Add( newDC );

newDC=new DataColumn( "UnitPrice",System.Type.GetType( "System.Double" ) );

ds.Tables["CartTable"].Columns.Add( newDC );

newDC=new DataColumn( "TotalPrice",System.Type.GetType( "System.Double" ) );

ds.Tables["CartTable"].Columns.Add( newDC );

newDC=new DataColumn( "IsDeleted",System.Type.GetType( "System.Int32" ) );

newDC.DefaultValue=0;

// public void WriteShoppingCart( ) 中 newDR[5]="0";

行,已被注销, ds.Tables["CartTable"].Columns.Add( newDC );

Session["myCartTable"]=newDT;

ShoppingCartDlt.DataSource=ds.Tables["CartTable"].DefaultView;

ShoppingCartDlt.DataBind( );

}

public void UpdateShoppingCart( )

{

if( Session["myCartTable"]==null )//Session["myCartTable"]==null

{

CreateCartTable( );

//调用函数CreateCartTable( )新建一个DataTable WriteShoppingCart( );

}

else

{

//如果购物蓝中已有商品,则需要对购物信息表DataTable进行更新,并将其棒定到ShoppingCartDlt WriteShoppingCart( );

}

}

public void ViewShoppingCart( ) //查看购物车

{

if( Session["myCartTable"]!=null )

{

DataTable viewTable=new DataTable( "nowCartTable" );

viewTable=( DataTable )Session["myCartTable"];

ShoppingCartDlt.DataSource = viewTable.DefaultView;

//购物车棒定到ShoppingCartDlt ShoppingCartDlt.DataBind( );

}

}

public void WriteShoppingCart( )

{

if( Request.Params["mode"]!="view" ) //检查是否是直接查看购物车,如果直接查看,就不再写MYCARTTABLE

{

DataTable nowTable=new DataTable( "nowCartTable" );

nowTable=( DataTable )Session["myCartTable"];

int pn=nowTable.Rows.Count;

int i=0;

bool hasone=false;

int nowProdID;

while( i<pn && !hasone )

{

nowProdID=Int32.Parse( nowTable.Rows[i][0].ToString( ) );

if( nowProdID==Int32.Parse( AddProID ) ) //判断购物信息表中,是否存有当前放入商品. if( nowProdID==Int32.Parse( AddProID ) )

{

hasone=true;

}

else

{

i++;

}

}

if( hasone )

{

//如果已有该商品,则 hasone=true,更改该数据行 DataRow oldDR;

oldDR=nowTable.Rows[i];

oldDR["ProdCount"]=Int32.Parse( oldDR["ProdCount"].ToString( ) )+1;

oldDR["TotalPrice"]=Int32.Parse( oldDR["ProdCount"].ToString( ) )*Double.Parse( oldDR["UnitPrice"].ToString( ) );

}

else

{

//如果没有该商品,在表中新加如一行. DataRow newDR;

double unitp;

String strcon="provider=Microsoft.jet.OLEDB.4.0;

data Source="+Server.MapPath( ConfigurationSettings.AppSettings["MDBpath2"] )+";

";

OleDbConnection myConnection = new OleDbConnection( strcon );

string strSQL= "select * from pro where product_id="+AddProID+"";

OleDbDataAdapter myCommand = new OleDbDataAdapter( strSQL, myConnection );

DataSet ds = new DataSet( );

myCommand.Fill( ds, "AddP" );

newDR=nowTable.NewRow( );

newDR[0]=AddProID;

newDR[2]=ds.Tables["Addp"].Rows[0]["product_name"].ToString( );

unitp=Double.Parse( ds.Tables["AddP"].Rows[0]["product_memprice"].ToString( ) );

//会员价 newDR[3]=unitp;

newDR[4]=unitp;

//第一次读库,所以总价格和单价是一样的. //newDR[5]="0";

nowTable.Rows.Add( newDR );

myConnection.Close( );

}

ShoppingCartDlt.DataSource = nowTable.DefaultView;

//将更新后的 DataTable棒定到ShoppingCartDlt ShoppingCartDlt.DataBind( );

Session["myCartTable"] = nowTable;

//重新保存更新过的DataTable

}

}

public void Caculator( )

{

if( Session["myCartTable"]!=null ) //购物车是否为空

{

int h;

Double TotalPri;

TotalPri=0;

DataTable nowTable3=new DataTable( "nowCartTable3" );

nowTable3=( DataTable )Session["myCartTable"];

if( nowTable3.Rows.Count>0 ) //返回购物车中是否有货物

{

for( h=0;

h<=nowTable3.Rows.Count-1;

h++ )

{

TotalPri=TotalPri+Int32.Parse( nowTable3.Rows[h][4].ToString( ) );

//Double.Parse( ( string )TotalText.Text );

}

label.Text="总计: "+TotalPri.ToString( )+" 元" ;

}

}

}

public void Update( )

{

int i;

int j;

int k;

ArrayList deleteItem = new ArrayList( 10 );

DataGridItem _item ;

j=0;

int deleteid;

k=0;

DataTable nowTable2=new DataTable( "nowCartTable2" );

nowTable2=( DataTable )Session["myCartTable"];

for( i=0;

i<=this.ShoppingCartDlt.Items.Count-1;

i++ )

{

_item = this.ShoppingCartDlt.Items[i];

TextBox CountText=( TextBox )this.ShoppingCartDlt.Items[i].Cells[4].FindControl( "CountTb" );

//Controls[1];

//_item.FindControl( "CountTb" );

CheckBox ProductIDCheck =( CheckBox ) _item.FindControl( "chkProductID" );

nowTable2.Rows[i][1] = Int32.Parse( CountText.Text.ToString( ) );

nowTable2.Rows[i][4] = Int32.Parse( nowTable2.Rows[i][1].ToString( ) ) * Double.Parse( nowTable2.Rows[i][3].ToString( ) );

if( ProductIDCheck.Checked )

{

nowTable2.Rows[i][5] = 1;

//添加删除标记1 j=j+1;

}

}

string strExpr="IsDeleted>0";

//http://msdn.microsoft.com/library/chs/default.asp?url=/library/CHS/cpref/html/frlrfSystemDataDataTableClassSelectTopic.asp DataRow[] foundRows = nowTable2.Select( strExpr );

for( int m = 0;

m < foundRows.Length;

m ++ )

{

//Console.WriteLine( foundRows[i][0] );

foundRows[m].Delete( );

}

ShoppingCartDlt.DataSource = nowTable2.DefaultView;

ShoppingCartDlt.DataBind( );

Session["myCartTable"] = nowTable2;

Caculator( );

}

#region Web 窗体设计器生成的代码 override protected void OnInit( EventArgs e )

{

// // CODEGEN: 该调用是 asp.NET Web 窗体设计器所必需的. // InitializeComponent( );

base.OnInit( e );

}

/// <summary> /// 设计器支持所需的方法 - 不要使用代码编辑器修改 /// 此方法的内容. /// </summary> private void InitializeComponent( )

{

this.update.Click += new System.EventHandler( this.update_Click );

this.CheckOut.Click += new System.EventHandler( this.CheckOut_Click );

this.Load += new System.EventHandler( this.Page_Load );

}

#endregion

private void update_Click( object sender, System.EventArgs e )

{

Update( );

}

private void CheckOut_Click( object sender, System.EventArgs e )

{

Update( );

Response.Redirect( "checkout.aspx" );

}

}

}

查看本文来源

三个月宝宝咳嗽
儿童止咳药
宝宝腹胀的解决方法
心梗前期都有哪些症状
分享到: