asp.net 电子商务开发实战 系统 源码

--1 部门表 --2011-06-24 ---插入DEPARTMENT(部门表)- INSERT INTO Department(Name, Description) VALUES ('Anniversary Balloons', 'These sweet balloons are the perfect gift for someone you love.') GO INSERT INTO Department(Name, Description ) VALUES ('Balloons for Children', 'The colorful and funny balloons will make any child smile!') GO --2 分类表 --2011-06-28 ---插入CATEGORY(分类表) --插入数据 TRUNCATE TABLE Category GO /*可以连接表的编码:例如,当你把自增表的记录删除了以后,再次增加记录时,它的编码会连续起来*/ -- Truncate是SQL中的一个删除数据表内容的语句， --用法是：TRUNCATE TABLE name 参数 name(是要截断的表的名称或要删除其全部行的表的名称。) --Truncate table 表名 速度快,而且效率高,因为: 　 --　TRUNCATE TABLE 在功能上与不带 WHERE 子句的 DELETE 语句相同：二者均删除表中的全部行。 --但 TRUNCATE TABLE 比 DELETE 速度快，且使用的系统和事务日志资源少。 　 --DELETE 语句每次删除一行，并在事务日志中为所删除的每行记录一项。 --TRUNCATE TABLE 通过释放存储表数据所用的数据页来删除数据，并且只在事务日志中记录页的释放。 SET IDENTITY_INSERT Category ON GO --SET IDENTITY_INSERT(允许将显式值插入表的标识列中。)语法: --SET IDENTITY_INSERT [ database.[ owner.] ] { table } { ON | OFF } --参数 database 是表所有者的名称。 INSERT INTO Category (CategoryID, DepartmentID, Name, Description ) VALUES (1, 1, 'Love & Romance', 'Here''s our collection of balloons with romantic messages.') INSERT INTO Category (CategoryID, DepartmentID, Name, Description ) VALUES (2, 1, 'Birthdays', 'Tell someone "Happy Birthday" with one of these wonderful balloons!') INSERT INTO Category (CategoryID, DepartmentID, Name, Description ) VALUES (3, 1, 'Weddings', 'Going to a wedding? Here''s a collection of balloons for that special event!') INSERT INTO Category (CategoryID, DepartmentID, Name, Description ) VALUES (4, 2, 'Message Balloons', 'Why write on paper, when you can deliver your message on a balloon?') INSERT INTO Category (CategoryID, DepartmentID, Name, Description ) VALUES (5, 2, 'Cartoons', 'Buy a balloon with your child''s favorite cartoon character!') INSERT INTO Category (CategoryID, DepartmentID, Name, Description ) VALUES (6, 2, 'Miscellaneous', 'Various baloons that your kid will most certainly love!') GO --table 如果插入值大于表的当前标识值，则 SQL Server 自动将新插入值作为当前标识值使用。 --它的设置是在执行或运行时设置，而不是在分析时设置。 SET IDENTITY_INSERT Category OFF GO --3 商品表 --2011-06-28 ---插入PRODUCT(商品表) TRUNCATE TABLE Product GO SET IDENTITY_INSERT Product ON GO INSERT INTO Product(ProductID, Name, Description, Price, Thumbnail, Image, PromoFront, PromoDept ) VALUES (1, 'I Love You (Simon Elvin)', 'An adorable romantic balloon by Simon Elvin. You''ll fall in love with the cute bear bearing a bouquet of roses, a heart with I Love You, and a card.', 121.9900, 't0326801.jpg', '0326801.jpg', 0, 1) GO INSERT INTO Product(ProductID, Name, Description, Price, Thumbnail, Image, PromoFront, PromoDept ) VALUES (2, 'Elvis Hunka Burning Love', 'A heart shaped balloon with the great Elvis on it and the words "You''re My Hunka Hunka Burnin'' Love!". Also a copy of the Kings Signature.', 12.9900, 't16110p.jpg', '16110p.jpg', 0, 0) GO INSERT INTO Product(ProductID, Name, Description, Price, Thumbnail, Image, PromoFront, PromoDept ) VALUES (3, 'Funny Love', 'A red heart-shaped balloon with "I love you" written on a white heart surrounded by cute little hearts and flowers.', 12.9900, 't16162p.jpg', '16162p.jpg', 0, 0) GO INSERT INTO Product(ProductID, Name, Description, Price, Thumbnail, Image, PromoFront, PromoDept ) VALUES (4, 'Today, Tomorrow & Forever', 'White heart-shaped balloon with the words "Today, Tomorrow and Forever" surrounded with red hearts of varying shapes. "I Love You" appears at the bottom in a red heart.', 12.9900, 't16363p.jpg', '16363p.jpg', 0, 1) GO INSERT INTO Product(ProductID, Name, Description, Price, Thumbnail, Image, PromoFront, PromoDept ) VALUES (5, 'Smiley Heart Red Balloon', 'Red heart-shaped balloon with a smiley face. Perfect for saying I Love You!', 12.9900, 't16744p.jpg', '16744p.jpg', 0, 0) GO INSERT INTO Product(ProductID, Name, Description, Price, Thumbnail, Image, PromoFront, PromoDept ) VALUES (6, 'Love 24 Karat', 'A red heart-shaped balloon with "I Love You" in script writing. Gold heart outlines adorn the background.', 12.9900, 't16756p.jpg', '16756p.jpg', 0, 0) GO INSERT INTO Product(ProductID, Name, Description, Price, Thumbnail, Image, PromoFront, PromoDept ) VALUES (7, 'Smiley Kiss Red Balloon', 'Red heart-shaped balloon with a smiley face and three kisses. A perfect gift for Valentine''s Day!', 12.9900, 't16864p.jpg', '16864p.jpg', 0, 1) GO INSERT INTO Product(ProductID, Name, Description, Price, Thumbnail, Image, PromoFront, PromoDept ) VALUES (8, 'Love You Hearts', 'A balloon with a simple message of love. What can be more romantic?', 12.9900, 't16967p.jpg', '16967p.jpg', 0, 0) GO INSERT INTO Product(ProductID, Name, Description, Price, Thumbnail, Image, PromoFront, PromoDept ) VALUES (9, 'Love Me Tender', 'A heart-shaped balloon with a picture of the King himself-Elvis Presley. This must-have for any Elvis fan has "Love Me Tender" written on it with a copy of Elvis''s signature.', 12.9900, 't16973p.jpg', '16973p.jpg', 0, 0) GO INSERT INTO Product(ProductID, Name, Description, Price, Thumbnail, Image, PromoFront, PromoDept ) VALUES (10, 'I Can''t Get Enough of You Baby', 'When you just can''t get enough of someone, this Austin Powers style balloon says it all.', 12.9900, 't16974p.jpg', '16974p.jpg', 0, 1) GO INSERT INTO Product(ProductID, Name, Description, Price, Thumbnail, Image, PromoFront, PromoDept ) VALUES (11, 'Picture Perfect Love Swing', 'A red heart-shaped balloon with a cute picture of two children kissing on a swing.', 12.9900, 't16980p.jpg', '16980p.jpg', 0, 0) GO INSERT INTO Product(ProductID, Name, Description, Price, Thumbnail, Image, PromoFront, PromoDept ) VALUES (12, 'I Love You Roses', 'A white heart-shaped balloon has "I Love You" written on it and is beautifully decorated with two flowers, a small red heart in the middle, and miniature hearts all around.', 12.9900, 't214006p.jpg', '214006p.jpg', 0, 0) GO INSERT INTO Product(ProductID, Name, Description, Price, Thumbnail, Image, PromoFront, PromoDept ) VALUES (13, 'I Love You Script', 'A romantic red heart-shaped balloon with "I Love You" in white. What more can you say?', 12.9900, 't214041p.jpg', '214041p.jpg', 0, 0) GO INSERT INTO Product(ProductID, Name, Description, Price, Thumbnail, Image, PromoFront, PromoDept ) VALUES (14, 'Love Rose', 'A white heart-shaped balloon with a rose and the words "I Love You." Romantic and irresistible.', 12.9900, 't214168p.jpg', '214168p.jpg', 0, 1) GO INSERT INTO Product(ProductID, Name, Description, Price, Thumbnail, Image, PromoFront, PromoDept ) VALUES (15, 'You''re So Special', 'Tell someone how special he or she is with this lovely heart-shaped balloon with a cute bear holding a flower.', 12.9900, 't215302p.jpg', '215302p.jpg', 0, 0) GO INSERT INTO Product(ProductID, Name, Description, Price, Thumbnail, Image, PromoFront, PromoDept ) VALUES (16, 'I Love You Red Flourishes', 'A simple but romantic red heart-shaped balloon with "I Love You" in large script writing.', 12.9900, 't22849b.jpg', '22849b.jpg', 0, 0) GO INSERT INTO Product(ProductID, Name, Description, Price, Thumbnail, Image, PromoFront, PromoDept ) VALUES (17, 'I Love You Script', 'A simple, romantic red heart-shaped balloon with "I Love You" in small script writing.', 12.9900, 't45093.jpg', '45093.jpg', 0, 0) GO INSERT INTO Product(ProductID, Name, Description, Price, Thumbnail, Image, PromoFront, PromoDept ) VALUES (18, 'Love Cascade Hearts', 'A romantic red heart-shaped balloon with hearts and I "Love You."', 12.9900, 't68841b.jpg', '68