USE [TestDB]

USE [TestDB]

GO

/****** Object:  Table [dbo].[CUSTORDERS]    Script Date: 11/04/2011 13:37:48 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[CUSTORDERS](

 [ID] [char](36) NOT NULL,

 [ORDERNO] [nvarchar](50) NULL,

 [ORDERDATE] [date] NULL,

 [CUSTOMER] [nvarchar](255) NULL,

 [ADDRESS] [nvarchar](255) NULL,

 [TELNO] [nvarchar](50) NULL,

 [INVOICENO] [nvarchar](50) NULL,

PRIMARY KEY CLUSTERED

(

 [ID] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

INSERT [dbo].[CUSTORDERS] ([ID], [ORDERNO], [ORDERDATE], [CUSTOMER], [ADDRESS], [TELNO], [INVOICENO]) VALUES (N'1085EFB0-7B1C-4B6F-86D6-EAE9EFCEAFDD', N'HD00005_20110905', CAST(0xB4340B00 AS Date), N'Lý Nhã Kỳ', N'227 Nguyễn Tri Phương, Q10, TP.HCM', N'0916171819', N'5')

INSERT [dbo].[CUSTORDERS] ([ID], [ORDERNO], [ORDERDATE], [CUSTOMER], [ADDRESS], [TELNO], [INVOICENO]) VALUES (N'2B0016D8-193E-4A9B-8AB6-B3BB307B6CF2', N'HD00004_20110905', CAST(0xB4340B00 AS Date), N'Ôn Bích Hà', N'59C Nguyễn Đình Chiểu Q3, TP.HCM', N'0906070809', N'3')

INSERT [dbo].[CUSTORDERS] ([ID], [ORDERNO], [ORDERDATE], [CUSTOMER], [ADDRESS], [TELNO], [INVOICENO]) VALUES (N'572DE3D5-6019-430F-A44C-A6C8653F2056', N'HD00001_20110905', CAST(0xB4340B00 AS Date), N'Trương Mạn Ngọc', N'139 Pasteur, Q3, TP.HCM', N'0909090909', N'1')

INSERT [dbo].[CUSTORDERS] ([ID], [ORDERNO], [ORDERDATE], [CUSTOMER], [ADDRESS], [TELNO], [INVOICENO]) VALUES (N'62CCA0FC-D86E-4F98-9DBC-BEB55B0201ED', N'HD00010_20110905', CAST(0xB4340B00 AS Date), N'Lưu Diệt Phi', N'8888 Trần ưng Đạo, Q1, TP.HCM', N'0937363534', N'4')

INSERT [dbo].[CUSTORDERS] ([ID], [ORDERNO], [ORDERDATE], [CUSTOMER], [ADDRESS], [TELNO], [INVOICENO]) VALUES (N'A4E11A81-F9BD-4DA5-84B0-1326C0C6EABD', N'HD00008_20110905', CAST(0xB4340B00 AS Date), N'Phạm Băng Băng', N'9999 Nguyễn Thị Minh Khai TP.HCM', N'0986212121', N'8')

INSERT [dbo].[CUSTORDERS] ([ID], [ORDERNO], [ORDERDATE], [CUSTOMER], [ADDRESS], [TELNO], [INVOICENO]) VALUES (N'A518CE9D-A63B-4030-B721-5C398CC29980', N'HD00002_20110905', CAST(0xB4340B00 AS Date), N'Dương Tử Quỳnh', N'987 Hai Bà Trưng, Q3, TP.HCM', N'0985428842', N'2')

INSERT [dbo].[CUSTORDERS] ([ID], [ORDERNO], [ORDERDATE], [CUSTOMER], [ADDRESS], [TELNO], [INVOICENO]) VALUES (N'C06F8224-7C9C-484E-96D4-8BB31FA9C031', N'HD00006_20110905', CAST(0xB4340B00 AS Date), N'Lý Gia Hân', N'97 Nam Kỳ Khởi Nghĩa, Q3, TP.HCM', N'0981828388', N'6')

INSERT [dbo].[CUSTORDERS] ([ID], [ORDERNO], [ORDERDATE], [CUSTOMER], [ADDRESS], [TELNO], [INVOICENO]) VALUES (N'F5EEF73A-E89C-4159-8F2F-5DD093D97331', N'HD00007_20110905', CAST(0xB4340B00 AS Date), N'Trương Huệ Muội', N'10 Lý Tự Trọng, Q1, TP.HCM', N'0937373737', N'7')

INSERT [dbo].[CUSTORDERS] ([ID], [ORDERNO], [ORDERDATE], [CUSTOMER], [ADDRESS], [TELNO], [INVOICENO]) VALUES (N'F69768C5-154B-49DD-AC22-B3217D599B4D', N'HD00003_20110905', CAST(0xB4340B00 AS Date), N'Trác Y Đình', N'279 Nguyễn Văn Cừ, Q5, TP.HCM', N'0972737475', N'3')

INSERT [dbo].[CUSTORDERS] ([ID], [ORDERNO], [ORDERDATE], [CUSTOMER], [ADDRESS], [TELNO], [INVOICENO]) VALUES (N'FDB7F4D8-B198-49DC-A02D-0A484C2AB7D0', N'HD00009_20110905', CAST(0xB4340B00 AS Date), N'Phạm Vỹ Kỳ', N'7777 Nguyễn Đình Chiểu, Q3, TP.HCM', N'0909979899', N'9')

/****** Object:  Table [dbo].[CUSTORDERDETAILS]    Script Date: 11/04/2011 13:37:48 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[CUSTORDERDETAILS](

 [ORDERID] [char](36) NOT NULL,

 [PRODUCTID] [char](36) NOT NULL,

 [UNITPRICE] [float] NULL,

 [QUANTITY] [int] NULL,

 [DISCOUNTPER] [float] NULL,

 [VAT] [float] NULL,

 CONSTRAINT [PK_CUSTORDERDETAILS] PRIMARY KEY CLUSTERED

(

 [ORDERID] ASC,

 [PRODUCTID] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

INSERT [dbo].[CUSTORDERDETAILS] ([ORDERID], [PRODUCTID], [UNITPRICE], [QUANTITY], [DISCOUNTPER], [VAT]) VALUES (N'A4E11A81-F9BD-4DA5-84B0-1326C0C6EABD', N'7A34B04D-332B-43CB-8252-8EB207FB5079', 5000000, 50, 10, 10)

INSERT [dbo].[CUSTORDERDETAILS] ([ORDERID], [PRODUCTID], [UNITPRICE], [QUANTITY], [DISCOUNTPER], [VAT]) VALUES (N'A4E11A81-F9BD-4DA5-84B0-1326C0C6EABD', N'7EF602D1-C938-4FEE-9058-5C8EEED295F8', 7000000, 30, 10, 10)

INSERT [dbo].[CUSTORDERDETAILS] ([ORDERID], [PRODUCTID], [UNITPRICE], [QUANTITY], [DISCOUNTPER], [VAT]) VALUES (N'A4E11A81-F9BD-4DA5-84B0-1326C0C6EABD', N'965ADA27-581E-4AB6-BD5E-866A2674F8C5', 3000000, 40, 10, 10)

INSERT [dbo].[CUSTORDERDETAILS] ([ORDERID], [PRODUCTID], [UNITPRICE], [QUANTITY], [DISCOUNTPER], [VAT]) VALUES (N'A4E11A81-F9BD-4DA5-84B0-1326C0C6EABD', N'9E5F8B55-F038-4C8E-88F8-C9BAF4D6DA66', 2000000, 70, 10, 10)

INSERT [dbo].[CUSTORDERDETAILS] ([ORDERID], [PRODUCTID], [UNITPRICE], [QUANTITY], [DISCOUNTPER], [VAT]) VALUES (N'A4E11A81-F9BD-4DA5-84B0-1326C0C6EABD', N'B1384A78-03B8-4FBD-8060-BE5176CDCCC3', 5000000, 60, 10, 10)

INSERT [dbo].[CUSTORDERDETAILS] ([ORDERID], [PRODUCTID], [UNITPRICE], [QUANTITY], [DISCOUNTPER], [VAT]) VALUES (N'A518CE9D-A63B-4030-B721-5C398CC29980', N'7A34B04D-332B-43CB-8252-8EB207FB5079', 1000000, 20, 10, 10)

INSERT [dbo].[CUSTORDERDETAILS] ([ORDERID], [PRODUCTID], [UNITPRICE], [QUANTITY], [DISCOUNTPER], [VAT]) VALUES (N'A518CE9D-A63B-4030-B721-5C398CC29980', N'7EF602D1-C938-4FEE-9058-5C8EEED295F8', 4000000, 40, 10, 10)

INSERT [dbo].[CUSTORDERDETAILS] ([ORDERID], [PRODUCTID], [UNITPRICE], [QUANTITY], [DISCOUNTPER], [VAT]) VALUES (N'A518CE9D-A63B-4030-B721-5C398CC29980', N'965ADA27-581E-4AB6-BD5E-866A2674F8C5', 7000000, 30, 10, 10)

INSERT [dbo].[CUSTORDERDETAILS] ([ORDERID], [PRODUCTID], [UNITPRICE], [QUANTITY], [DISCOUNTPER], [VAT]) VALUES (N'A518CE9D-A63B-4030-B721-5C398CC29980', N'9E5F8B55-F038-4C8E-88F8-C9BAF4D6DA66', 5000000, 20, 10, 10)

INSERT [dbo].[CUSTORDERDETAILS] ([ORDERID], [PRODUCTID], [UNITPRICE], [QUANTITY], [DISCOUNTPER], [VAT]) VALUES (N'A518CE9D-A63B-4030-B721-5C398CC29980', N'B1384A78-03B8-4FBD-8060-BE5176CDCCC3', 7000000, 10, 10, 10)

INSERT [dbo].[CUSTORDERDETAILS] ([ORDERID], [PRODUCTID], [UNITPRICE], [QUANTITY], [DISCOUNTPER], [VAT]) VALUES (N'FDB7F4D8-B198-49DC-A02D-0A484C2AB7D0', N'7A34B04D-332B-43CB-8252-8EB207FB5079', 7000000, 30, 10, 10)

INSERT [dbo].[CUSTORDERDETAILS] ([ORDERID], [PRODUCTID], [UNITPRICE], [QUANTITY], [DISCOUNTPER], [VAT]) VALUES (N'FDB7F4D8-B198-49DC-A02D-0A484C2AB7D0', N'7EF602D1-C938-4FEE-9058-5C8EEED295F8', 3000000, 10, 10, 10)

INSERT [dbo].[CUSTORDERDETAILS] ([ORDERID], [PRODUCTID], [UNITPRICE], [QUANTITY], [DISCOUNTPER], [VAT]) VALUES (N'FDB7F4D8-B198-49DC-A02D-0A484C2AB7D0', N'965ADA27-581E-4AB6-BD5E-866A2674F8C5', 4000000, 20, 10, 10)

INSERT [dbo].[CUSTORDERDETAILS] ([ORDERID], [PRODUCTID], [UNITPRICE], [QUANTITY], [DISCOUNTPER], [VAT]) VALUES (N'FDB7F4D8-B198-49DC-A02D-0A484C2AB7D0', N'9E5F8B55-F038-4C8E-88F8-C9BAF4D6DA66', 5000000, 20, 10, 10)

INSERT [dbo].[CUSTORDERDETAILS] ([ORDERID], [PRODUCTID], [UNITPRICE], [QUANTITY], [DISCOUNTPER], [VAT]) VALUES (N'FDB7F4D8-B198-49DC-A02D-0A484C2AB7D0', N'B1384A78-03B8-4FBD-8060-BE5176CDCCC3', 2000000, 10, 10, 10)

/****** Object:  Table [dbo].[PRODUCTS]    Script Date: 11/04/2011 13:37:48 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[PRODUCTS](

 [PRODUCTID] [char](36) NOT NULL,

 [PRODUCTCODE] [nvarchar](50) NULL,

 [PRODUCTNAME] [nvarchar](255) NULL,

 [PRODUCTLINE] [nvarchar](50) NULL,

PRIMARY KEY CLUSTERED

(

 [PRODUCTID] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

INSERT [dbo].[PRODUCTS] ([PRODUCTID], [PRODUCTCODE], [PRODUCTNAME], [PRODUCTLINE]) VALUES (N'427F75DE-1A53-4708-9BD5-8681F691CBF0', N'P0007', N'Máy xoay sinh tố', N'Đời đầu')

INSERT [dbo].[PRODUCTS] ([PRODUCTID], [PRODUCTCODE], [PRODUCTNAME], [PRODUCTLINE]) VALUES (N'646FFFDF-DE66-494E-BFB7-82BD280621EC', N'P0006', N'Máy lạnh Hitachi', N'Đời đầu')

INSERT [dbo].[PRODUCTS] ([PRODUCTID], [PRODUCTCODE], [PRODUCTNAME], [PRODUCTLINE]) VALUES (N'7A34B04D-332B-43CB-8252-8EB207FB5079', N'P0003', N'Máy hút bụi Toshiba', N'Đời đầu')

INSERT [dbo].[PRODUCTS] ([PRODUCTID], [PRODUCTCODE], [PRODUCTNAME], [PRODUCTLINE]) VALUES (N'7EF602D1-C938-4FEE-9058-5C8EEED295F8', N'P0004', N'Máy nước nóng Alaska', N'Đời đầu')

INSERT [dbo].[PRODUCTS] ([PRODUCTID], [PRODUCTCODE], [PRODUCTNAME], [PRODUCTLINE]) VALUES (N'965ADA27-581E-4AB6-BD5E-866A2674F8C5', N'P0005', N'Máy xén cỏ Electrolux', N'Đời đầu')

INSERT [dbo].[PRODUCTS] ([PRODUCTID], [PRODUCTCODE], [PRODUCTNAME], [PRODUCTLINE]) VALUES (N'9E5F8B55-F038-4C8E-88F8-C9BAF4D6DA66', N'P0001', N'Máy giặt Electrolux', N'Đời đầu 1')

INSERT [dbo].[PRODUCTS] ([PRODUCTID], [PRODUCTCODE], [PRODUCTNAME], [PRODUCTLINE]) VALUES (N'A270518D-6631-4516-B479-7E2BA717A32C', N'P0010SDF', N'Máy tập tạ', N'Đời sau')

INSERT [dbo].[PRODUCTS] ([PRODUCTID], [PRODUCTCODE], [PRODUCTNAME], [PRODUCTLINE]) VALUES (N'B1384A78-03B8-4FBD-8060-BE5176CDCCC3', N'P0002', N'Máy rửa chén Alaska', N'Đời nhì')

INSERT [dbo].[PRODUCTS] ([PRODUCTID], [PRODUCTCODE], [PRODUCTNAME], [PRODUCTLINE]) VALUES (N'E2D6EB6B-7855-4EB4-BAFA-5C0F20103020', N'P0010', N'Máy tập tạ', N'Đời sau')

/****** Object:  StoredProcedure [dbo].[PRODUCT_UPDATE]    Script Date: 11/04/2011 13:37:44 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROCEDURE [dbo].[PRODUCT_UPDATE]

 -- Add the parameters for the stored procedure here

 @PROID CHAR(36),

 @PROCODE NVARCHAR(50),

 @PRONAME NVARCHAR(50),

 @PROLINE NVARCHAR(50)

AS

BEGIN

 -- SET NOCOUNT ON added to prevent extra result sets from

 -- interfering with SELECT statements.

 SET NOCOUNT ON;

 begin try

 IF @PROCODE=NULL OR @PROCODE=''

  RETURN -1;

  ELSE

   BEGIN

   UPDATE PRODUCTS SET PRODUCTCODE=@PROCODE, PRODUCTNAME=@PRONAME, PRODUCTLINE=@PROLINE WHERE PRODUCTID=@PROID;

   RETURN 1;

  END

 end try

 begin catch

 return -1;

 end catch;

END

GO

/****** Object:  StoredProcedure [dbo].[PRODUCT_DEL]    Script Date: 11/04/2011 13:37:44 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROCEDURE [dbo].[PRODUCT_DEL]

 -- Add the parameters for the stored procedure here

 @PROID CHAR(36)

AS

BEGIN

 -- SET NOCOUNT ON added to prevent extra result sets from

 -- interfering with SELECT statements.

 SET NOCOUNT ON;

 begin try

   BEGIN

   DELETE PRODUCTS WHERE PRODUCTID=@PROID;

   RETURN 1;

  END

 end try

 begin catch

 return -1;

 end catch;

END

GO

/****** Object:  StoredProcedure [dbo].[PRODUCT_ADD]    Script Date: 11/04/2011 13:37:44 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROCEDURE [dbo].[PRODUCT_ADD]

 -- Add the parameters for the stored procedure here

 @PROID CHAR(36) OUTPUT,

 @PROCODE NVARCHAR(50),

 @PRONAME NVARCHAR(50),

 @PROLINE NVARCHAR(50)

AS

BEGIN

 -- SET NOCOUNT ON added to prevent extra result sets from

 -- interfering with SELECT statements.

 SET NOCOUNT ON;

 begin try

 IF @PROCODE=NULL OR @PROCODE=''

  RETURN -1;

  ELSE

   BEGIN

   SET @PROID = NEWID();

   INSERT INTO PRODUCTS( PRODUCTID, PRODUCTCODE, PRODUCTNAME, PRODUCTLINE) VALUES (@PROID,@PROCODE,@PRONAME,@PROLINE);

   RETURN 1;

  END

 end try

 begin catch

 return -1;

 end catch;

END

GO

Bạn đang đọc truyện trên: truyentop.pro

Tags: