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