-- ===============================================
-- CONFIG ASP.NET Commerce STARTER KIT DATABASE
-- Create Database Script
--
-- Version: 1.2 - 01/02 (swarren)
--
-- ===============================================
CREATE DATABASE [Commerce]
GO
USE [Commerce]
GO
exec sp_dboption N'Commerce', N'autoclose', N'false'
GO
exec sp_dboption N'Commerce', N'bulkcopy', N'true'
GO
exec sp_dboption N'Commerce', N'trunc. log', N'true'
GO
exec sp_dboption N'Commerce', N'torn page detection', N'false'
GO
exec sp_dboption N'Commerce', N'read only', N'false'
GO
exec sp_dboption N'Commerce', N'dbo use', N'false'
GO
exec sp_dboption N'Commerce', N'single', N'false'
GO
exec sp_dboption N'Commerce', N'autoshrink', N'true'
GO
exec sp_dboption N'Commerce', N'ANSI null default', N'false'
GO
exec sp_dboption N'Commerce', N'recursive triggers', N'false'
GO
exec sp_dboption N'Commerce', N'ANSI nulls', N'false'
GO
exec sp_dboption N'Commerce', N'concat null yields null', N'false'
GO
exec sp_dboption N'Commerce', N'cursor close on commit', N'false'
GO
exec sp_dboption N'Commerce', N'default to local cursor', N'false'
GO
exec sp_dboption N'Commerce', N'quoted identifier', N'false'
GO
exec sp_dboption N'Commerce', N'ANSI warnings', N'false'
GO
exec sp_dboption N'Commerce', N'auto create statistics', N'true'
GO
exec sp_dboption N'Commerce', N'auto update statistics', N'true'
GO
--
-- end config
--
-- =======================================================
-- MAKE TABLES AND SPROCS FOR IBUYSPY Commerce DB
-- =======================================================
-- point to proper DB
use [Commerce]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_Products_Categories]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[CMRC_Products] DROP CONSTRAINT FK_Products_Categories
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_Orders_Customers]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[CMRC_Orders] DROP CONSTRAINT FK_Orders_Customers
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_OrderDetails_Orders]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[CMRC_OrderDetails] DROP CONSTRAINT FK_OrderDetails_Orders
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_Reviews_Products]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[CMRC_Reviews] DROP CONSTRAINT FK_Reviews_Products
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_ShoppingCart_Products]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[CMRC_ShoppingCart] DROP CONSTRAINT FK_ShoppingCart_Products
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CMRC_CustomerAdd]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[CMRC_CustomerAdd]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CMRC_CustomerAlsoBought]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[CMRC_CustomerAlsoBought]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CMRC_CustomerDetail]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[CMRC_CustomerDetail]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CMRC_CustomerLogin]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[CMRC_CustomerLogin]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CMRC_OrdersAdd]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[CMRC_OrdersAdd]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CMRC_OrdersDetail]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[CMRC_OrdersDetail]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CMRC_OrdersList]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[CMRC_OrdersList]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CMRC_ProductCategoryList]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[CMRC_ProductCategoryList]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CMRC_ProductDetail]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[CMRC_ProductDetail]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CMRC_ProductsByCategory]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[CMRC_ProductsByCategory]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CMRC_ProductsMostPopular]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[CMRC_ProductsMostPopular]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CMRC_ProductSearch]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[CMRC_ProductSearch]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CMRC_ReviewsAdd]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[CMRC_ReviewsAdd]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CMRC_ReviewsList]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[CMRC_ReviewsList]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CMRC_ShoppingCartAddItem]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[CMRC_ShoppingCartAddItem]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CMRC_ShoppingCartEmpty]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[CMRC_ShoppingCartEmpty]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CMRC_ShoppingCartItemCount]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[CMRC_ShoppingCartItemCount]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CMRC_ShoppingCartList]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[CMRC_ShoppingCartList]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CMRC_ShoppingCartMigrate]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[CMRC_ShoppingCartMigrate]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CMRC_ShoppingCartRemoveAbandoned]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[CMRC_ShoppingCartRemoveAbandoned]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CMRC_ShoppingCartRemoveItem]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[CMRC_ShoppingCartRemoveItem]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CMRC_ShoppingCartTotal]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[CMRC_ShoppingCartTotal]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CMRC_ShoppingCartUpdate]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[CMRC_ShoppingCartUpdate]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CMRC_Categories]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[CMRC_Categories]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CMRC_Customers]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[CMRC_Customers]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CMRC_OrderDetails]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[CMRC_OrderDetails]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CMRC_Orders]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[CMRC_Orders]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CMR
电子商务核心代码（asp.net）
需积分: 10 56 浏览量
2007-03-22
15:16:27
上传
评论
收藏 290KB RAR 举报
电子商务核心代码（asp.net） （193个子文件） 
_Header.ascx 2KB _Menu.ascx 2KB _ReviewList.ascx 2KB _PopularItems.ascx 1KB _AlsoBought.ascx 1KB InstantOrder.asmx 94B ShoppingCart.aspx 7KB ReviewAdd.aspx 7KB Register.aspx 7KB Login.aspx 5KB ProductDetails.aspx 5KB OrderDetail.aspx 5KB CheckOut.aspx 5KB OrderList.aspx 4KB SearchResults.aspx 4KB ProductsList.aspx 4KB Default.aspx 4KB ErrorPage.aspx 3KB AddToCart.aspx 107B Web.Config 3KB ShoppingCartDb.cs 14KB ProductsDB.cs 13KB OrdersDB.cs 9KB CustomersDB.cs 8KB ReviewsDB.cs 5KB ShoppingCart.aspx.cs 4KB InstantOrder.cs 3KB ReviewAdd.aspx.cs 2KB Login.aspx.cs 2KB Register.aspx.cs 2KB CheckOut.aspx.cs 2KB OrderDetail.aspx.cs 2KB ProductDetails.aspx.cs 1KB OrderList.aspx.cs 935B _AlsoBought.ascx.cs 909B SearchResults.aspx.cs 855B _Menu.ascx.cs 851B _PopularItems.ascx.cs 845B AddToCart.aspx.cs 827B _ReviewList.ascx.cs 813B Security.cs 793B ProductsList.aspx.cs 755B Default.aspx.cs 661B _Header.ascx.cs 415B ErrorPage.aspx.cs 410B abstractLogin.cs 381B ASPNETCommerce.css 7KB style.css 1KB Thumbs.db 47KB Thumbs.db 7KB Thumbs.db 4KB
erd.GIF 17KB ERD-big.GIF 11KB designerverbs.gif 9KB Products.GIF 4KB Reviews.GIF 4KB Customers.GIF 3KB ShoppingCart.GIF 3KB Orders.GIF 3KB OrderDetails.GIF 3KB Categories.GIF 3KB image.gif 2KB code-behind.gif 2KB image.gif 2KB update_cart.gif 1KB logo.gif 1KB most_secretive_place.gif 1KB review_this_product.gif 1KB final_checkout.gif 1KB sign_in_now.gif 1KB add_to_cart.gif 1KB modernliving.gif 1KB register.gif 1KB submit.gif 1KB target.gif 1KB services.gif 1022B help_bkgrd.gif 997B modernliving_bkgrd.gif 986B account.gif 972B cart.gif 955B sign_in.gif 954B grid_background.gif 870B reviewrating3.gif 826B reviewrating2.gif 822B reviewrating4.gif 815B reviewrating1.gif 804B reviewrating5.gif 553B search.gif 416B sitebkgrd.gif 349B sitebkgrd.gif 349B sitebkgrdnogray.GIF 297B arrowbutton.gif 176B 1x1.gif 43B 1x1.gif 43B 1x1.gif 43B Components_ShoppingCartDb_cs.htm 23KB Components_ProductsDB_cs.htm 18KB ReviewAdd_aspx.htm 18KB ShoppingCart_aspx.htm 17KB Register_aspx.htm 15KB共 193 条
- 1
- 2
资源评论
octopus1
- 粉丝: 198
- 资源: 38
