网上购物车简单代码5

记得忘记 · 发表于 2009-1-6 23:18:16

</html>

Global.asax
<%@ Application Language="C#" %>

<script runat="server">

void Application_Start(object sender, EventArgs e)
{
      // 在应用程序启动时运行的代码

}

void Application_End(object sender, EventArgs e)
{
      //  在应用程序关闭时运行的代码

}

void Application_Error(object sender, EventArgs e)
{
      // 在出现未处理的错误时运行的代码

}

void Session_Start(object sender, EventArgs e)
{
      // 在新会话启动时运行的代码
      Hashtable ht = new Hashtable(1000);
      Session["shopping"] = ht;
      Session.Timeout = 60;
}

void Session_End(object sender, EventArgs e)
{
      //Session.Clear();//清空所有的键值对,但session对象存在。
      Session.Abandon(); //对session对象进行销毁。
      // 在会话结束时运行的代码。
      // 注意: 只有在 Web.config 文件中的 sessionstate 模式设置为
      // InProc 时，才会引发 Session_End 事件。如果会话模式设置为 StateServer
      // 或 SQLServer，则不会引发该事件。


}

</script>
shouyin.aspx
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="shouyin.aspx.cs" Inherits="shouyin" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>收银台</title>
</head>
<body>
<form id="form1" runat="server">
<div>
      <%
         Hashtable ht = (Hashtable)Session["shopping"];
         if (ht == null)
         {
            throw new Exception("程序有问题，请联系管理员");
         }
         else {
            if (ht.Count == 0)
            {
                  Response.Redirect("Default.aspx");
            }
            else {
                  Application.Lock();
                  string strconn = ConfigurationManager.ConnectionStrings["sql"].ConnectionString;
                  SqlConnection conn = new SqlConnection(strconn);
                  conn.Open();
                  SqlCommand command = conn.CreateCommand();
                  string fu_type = "现金";
                  string so_type = "送货上门";
                  int userid = 1;
                  command.CommandText = "exec ordercreate '"+DateTime.Now.ToLocalTime().ToString()+"','"+fu_type+"','"+so_type+"',"+userid;
                  int o_id=(int)command.ExecuteScalar();
               %>
               <table><tr><td>编号</td><td>商品名</td><td>商品单价</td><td>购物数量</td><td>总价</td></tr>
               <%
                  ICollection ic= ht.Keys;
                  double alltotal = 0;
                  foreach (int key in ic)
                  {
                        购物商品 s=(购物商品)ht[key];
                        double stotal = s.getTotalPrice();
                        alltotal += stotal;
                        command.CommandText = "exec gouwuproc "+o_id+","+s.Id+",'"+s.Name+"',"+s.Price+","+s.Snum;
                        command.ExecuteNonQuery();
                        %>
                        <tr><td><%=s.Id %></td><td><%=s.Name %></td><td><%=s.Price %></td><td><%=s.Snum %></td><td><%=stotal %></td></tr>
                        <%
                  }
               %>
               <tr><td colspan="5" align="right">总计:<%=alltotal %></td></tr>
               </table>
               <%
                  //ht.Clear();
                  //Session["shopping"] = ht;
                  conn.Close();
                  Application.UnLock();
            }
         }
      %>
</div>
</form>
</body>
</html>
shouyin.aspx.cs
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;

public partial class shouyin : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}
}
Web.Config
<?xml version="1.0"?>

<configuration>
   <appSettings>
<add key="pagecount" value="6"/>
  </appSettings>
  <connectionStrings>
<add connectionString="server=.;database=shopping;integrated security=true" name="sql"/>
  </connectionStrings>
<system.web>

<compilation debug="true"/>


</system.web>
</configuration>
数据库.txt
create database shopping

use shopping
create table userinfo(id int not null primary key identity(1,1),
name varchar(50) not null,pwd varchar(50) not null)
insert into userinfo values('song','123')

create table kucun(id int not null primary key identity(1,1),
name varchar(50),price decimal(9,2),amount bigint,imgurl varchar(50))

insert into kucun values('袜子',100.02,1000,'image/1.gif')
insert into kucun values('衣服',100.02,1000,'image/2.gif')
insert into kucun values('帽子',100.02,1000,'image/3.gif')
insert into kucun values('眼镜',100.02,1000,'image/4.gif')
insert into kucun values('领带1',100.02,1000,'image/5.gif')
insert into kucun values('领带2',100.02,1000,'image/5.gif')
insert into kucun values('领带3',100.02,1000,'image/5.gif')
insert into kucun values('领带4',100.02,1000,'image/5.gif')
insert into kucun values('领带5',100.02,1000,'image/5.gif')
insert into kucun values('领带6',100.02,1000,'image/5.gif')
insert into kucun values('领带7',100.02,1000,'image/5.gif')
insert into kucun values('领带9',100.02,1000,'image/5.gif')
insert into kucun values('领带9',10,10890,'image/9.gif')

select * from kucun

create table order1
(id int not null primary key identity(1,1),dt varchar(200),
fu_type varchar(50),so_type varchar(50),b_id int not null
foreign key references userinfo(id))

create table order_detail
(id int not null primary key identity(1,1),
o_id int not null foreign key references order1(id),
name varchar(50) not null,price decimal(9,2) not null,amount int not null)

select * from kucun

userinfofenye 2,3
create proc propro
(@page int,@count int) --page为显示几页，@count为一页显示多少数据
as
declare @start int
set @start=(@page-1)*@count+1
declare @end int
set @end=@start+@count-1 --获取从第一行到显示网页的最后一行数据行
create table  #temp(bian int identity(1,1),id int,name varchar(50),price decimal(9,2),amount int ,imgurl varchar(50))
insert into #temp exec('select top '+@end+' * from kucun')
select id,name,price,amount,imgurl from #temp where bian>=@start and bian<=@end

select * from order1

select * from order_detail

select * from userinfo

insert into order1 values('2008-11-27 10:29:30',
'现金','送货上门',1)

select * from order1
select max(id) from order1
select top 1 id from order1 order by id desc

declare @num int
set @num=(select ident_current('order1'))
select @num
1.一个表只有一个标识列
2. ident_current('表名') 返回最近插入的标识列的数据

insert into order_detail
values(ident_current('order1'),'袜子',30.5,10)
select * from order_detail

select * from kucun
select convert(varchar(50),getdate())
declare @temp varchar(50)
set @temp=convert(varchar(50),getdate())
--select @temp
exec ordercreate @temp,'现金','送货上门',1

exec gouwuproc 4,1,'袜子',100.02,200

alter proc ordercreate
(@dt varchar(50),@fu_type varchar(50),@so_type varchar(50),
@b_id int)
as
insert into order1 values(@dt,@fu_type,@so_type,@b_id)
select convert(int,ident_current('order1'))

alter proc gouwuproc
(@o_id int,@sid int,@sname varchar(50),@price decimal(9,2),
@amount int)
as
insert into order_detail
values(@o_id,@sname,@price,@amount)
update kucun set amount=amount-@amount where id=@sid

select * from order1
select * from order_detail
select * from kucun

		自动登录	找回密码
密码			马上注册

网上购物车简单代码5

相关帖子