网上购物商城网站源代码，ajax .net asp asp.net c# SQl2005 最新基础技术构建的，三层架构分类写的.

set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[CheckCustomer] @strCustomerName varchar(50) AS SELECT customerName,customerPass,customerTrueName,customerAddress,customerPostCode,customerPhone,customerEmail,customerRegDate,customerQuestion,customerAnswer FROM tb_Customer WHERE customerName = @strCustomerName set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[CustomerLogin] @strCustomerName varchar(50), @strPWD char(30) AS SELECT customerName,customerPass FROM tb_Customer WHERE customerName = @strCustomerName AND customerPass = @strPWD set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[DeleteCustomer] @strCustomerName varchar(50) AS DELETE FROM tb_Customer WHERE customerName = @strCustomerName RETURN et ANSI_NULLS ON set QUOTED_IDENTIFIER ON go --根据商品ID删除商品 ALTER PROCEDURE [dbo].[DeleteGoods] @intGoodsID int --商品ID AS DELETE FROM tb_Goods WHERE goodsID = @intGoodsID RETURN set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[DeleteGoodsType] @intGoodsTypeID int AS DELETE FROM tb_GoodsType WHERE goodsTypeID = @intGoodsTypeID RETURN set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[DeleteOrder] @intOrderID int AS BEGIN TRANSACTION DELETE FROM tb_Order WHERE orderID = @intOrderID DELETE FROM tb_OrderDetail WHERE orderID = @intOrderID COMMIT TRANSACTION RETURN set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[DeleteOrderDetail] @intOrderID int, @intgoodsID int AS DELETE FROM tb_OrderDetail WHERE orderID = @intOrderID AND goodsID = @intgoodsID RETURN set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[GetAllCustomers] AS SELECT * FROM tb_Customer RETURN set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[GetAllGoods] AS SELECT A.goodsID,A.goodsName,A.goodsTypeID,A.goodsDescript,A.goodsUnitPrice,A.goodsImageName,A.goodsDate,B.goodsTypeName FROM tb_Goods AS A INNER JOIN tb_GoodsType AS B ON A.goodsTypeID = B.goodsTypeID set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[GetAllGoodsType] AS SELECT goodsTypeID,goodsTypeName FROM tb_GoodsType RETURN set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[GetAllOrder] AS SELECT * FROM tb_Order ORDER BY orderDate DESC RETURN set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[GetCustomerByName] @strCustomerName varchar(50) AS SELECT customerName,customerPass,customerTrueName,customerAddress,customerPostCode,customerPhone,customerEmail,customerRegDate,customerQuestion,customerAnswer FROM tb_Customer WHERE customerName like '%' + @strCustomerName + '%' set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[GetGoodsByID] @intGoodsID int AS SELECT goodsID,goodsName,goodsTypeID,goodsDescript,goodsUnitPrice,goodsImageName,goodsDate FROM tb_Goods WHERE goodsID = @intGoodsID set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go --按商品名称或者类型ID进行查询，不输入条件时获取全部 ALTER PROCEDURE [dbo].[GetGoodsByNameAndType] @strGoodsName nvarchar(50), --商品名称 @intGoodsType int --商品种类ID AS SELECT A.goodsID,A.goodsName,A.goodsTypeID,A.goodsDescript,A.goodsUnitPrice,A.goodsImageName,A.goodsDate,B.goodsTypeName FROM tb_Goods AS A INNER JOIN tb_GoodsType AS B ON A.goodsTypeID = B.goodsTypeID WHERE (A.goodsName like '%' + @strGoodsName + '%') AND (a.goodsTypeID = @intGoodsType OR @intGoodsType = -1) set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[GetGoodsListByOrderID] @intOrderID int AS /* SET NOCOUNT ON */ SELECT * FROM tb_Goods where goodsID IN (SELECT goodsID FROM tb_OrderDetail where orderID =@intOrderID) RETURN set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[GetGoodsTypeByID] @intGoodsTypeID int AS SELECT goodsTypeID,goodsTypeName FROM tb_GoodsType WHERE goodsTypeID = @intGoodsTypeID set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[GetOrderByCustomer] @strCustomerID nvarchar(20) AS /* SET NOCOUNT ON */ SELECT * FROM tb_order where customerName = @strCustomerID RETURN set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[GetOrderByID] @intOrderID int AS /* SET NOCOUNT ON */ SELECT * FROM tb_Order WHERE orderID = @intOrderID RETURN set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[GetPopGoods] AS SELECT TOP 5 * FROM tb_Goods ORDER BY sellCount DESC RETURN set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[InsertCustomer] @strCustomerName nvarchar(20), @strCustomerPass varchar(50), @strCustomerTrueName nvarchar(10), @strCustomerAddress nvarchar(100), @strCustomerPostCode char(6), @strCustomerPhone varchar(20), @strCustomerEmail varchar(50), @strCustomerQuestion nvarchar(100), @strCustomerAnswer nvarchar(100) AS INSERT INTO tb_Customer(customerName,customerPass,customerTrueName,customerAddress,customerPostCode,customerPhone,customerEmail,customerQuestion,customerAnswer) VALUES(@strCustomerName,@strCustomerPass,@strCustomerTrueName,@strCustomerAddress,@strCustomerPostCode,@strCustomerPhone,@strCustomerEmail,@strcustomerQuestion,@strcustomerAnswer) RETURN set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go --新增一种商品 ALTER PROCEDURE [dbo].[InsertGoods] @strGoodsName nvarchar(50), --商品名称 @intGoodsTypeID int, --商品类型的ID @strGoodsDescript nvarchar(max), --商品描述 @moneyGoodsUnitPrice money, --商品单价 @strGoodsImage nvarchar(50) --商品图片的文件名 AS INSERT INTO tb_Goods(goodsName,goodsTypeID,goodsDescript,goodsUnitPrice,goodsImageName) VALUES(@strGoodsName,@intGoodsTypeID,@strGoodsDescript,@moneyGoodsUnitPrice,@strGoodsImage) RETURN set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[InsertGoodsType] @strGoodsTypeName nvarchar(50) AS INSERT INTO tb_GoodsType (goodsTypeName) VALUES(@strGoodsTypeName) RETURN set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[InsertOrder] @strCustomerID nvarchar(20), @totalMoney money, @identity int output AS INSERT INTO tb_Order(customerName,totalMoney,orderDate,orderState) VALUES(@strCustomerID,@totalMoney,getdate(),'0') SELECT @identity = IDENT_CURRENT('tb_Order') RETURN set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[InsertOrderDetail] @intOrderID int, @intGoodsID int AS INSERT INTO tb_OrderDetail (orderID,goodsID) VALUES(@intOrderID,@intGoodsID) RETURN set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[ManagerLogin] @strManagerName nvarchar(20), @strManagerPwd varchar(50) AS SELECT managerName,managerPWD FROM tb_Manage WHERE managerName = @strManagerName AND managerPWD = @strManagerPWD RETURN set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[UpdateCustomer] @strCustomerName nvarchar(20), @strCustomerPass varchar(50), @strCustomerTrueName nvarchar(50), @strCustomerAddress nvarchar(100), @strCustomerPostCode char(6), @strCustomerPhone varchar(20), @strCustomerEmail varchar(50), @strCustomerQuestion nvarchar(100), @strCustomerAnswer nvarchar(100) AS UPDATE tb_Customer set customerPass = @strCustomerPass, customerTrueName = @strCustomerTrueName, customerAddress = @strCustomerAddress, customerPostCode = @strCustomerPostCode, customerPhone = @strCustomerPhone, customerEmail = @strCustomerEmail, c