[Đồ Án] Website bán hàng thương mại điện tử Digital World

Link demo : http://digitalword.somee.com

Đồ án website bán hàng thương mại điện tử Digital World được viết bằng công nghệ ADO.NET và LINQ
+ VS 2012
+ Giao diện Metro UI
+ SQL Server 2008/2012
+Security + Routing

Download [Đồ Án] Website bán hàng thương mại điện tử Digital World

USE [DigitalWorld] GO /****** Object: StoredProcedure [dbo].[sp_Categories_Delete] Script Date: 11/10/2012 4:01:41 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE proc [dbo].[sp_Categories_Delete] ( @CatID nvarchar(9) ) as if not exists (select * from Categories where CategoryID = @CatID) raiserror('Mã Chủng Loại đã tồn tại',16,1) else delete from Categories where CategoryID = @CatID GO /****** Object: StoredProcedure [dbo].[sp_Categories_Insert] Script Date: 11/10/2012 4:01:41 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE proc [dbo].[sp_Categories_Insert] ( @CatID nvarchar(9), @CatName nvarchar(15), @Desc nvarchar(1000), @Pagesite nvarchar(150) ) as if exists (select * from Categories where CategoryID = @CatID) raiserror('Mã Chủng Loại đã tồn tại',16,1) else insert categories(categoryid,CategoryName,Descriptions,Pagesite) values(@CatID,@CatName,@Desc,@Pagesite) GO /****** Object: StoredProcedure [dbo].[sp_Categories_Update] Script Date: 11/10/2012 4:01:41 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE proc [dbo].[sp_Categories_Update] ( @CatID nvarchar(9), @CatName nvarchar(15), @Desc nvarchar(1000), @Pagesite nvarchar(150), @Status bit ) as if not exists (select * from Categories where CategoryID = @CatID) raiserror('Mã Chủng Loại đã tồn tại',16,1) else update Categories set CategoryName = @CatName, Descriptions=@Desc, Pagesite=@Pagesite, status = @Status where CategoryID=@CatID GO /****** Object: StoredProcedure [dbo].[sp_CategoryByStatus] Script Date: 11/10/2012 4:01:41 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO create proc [dbo].[sp_CategoryByStatus] as select * from categories where status = 1 GO /****** Object: StoredProcedure [dbo].[sp_Customers_BasicInsert] Script Date: 11/10/2012 4:01:41 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[sp_Customers_BasicInsert] ( @customername nvarchar(50), @username nvarchar(50), @password ntext, @signupdate datetime, @status bit ) as insert customers(customername,username,password,signupdate,status) values (@customername,@username,@password,@signupdate,@status) GO /****** Object: StoredProcedure [dbo].[sp_Customers_Delete] Script Date: 11/10/2012 4:01:41 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO create proc [dbo].[sp_Customers_Delete] ( @CusID int ) as if not exists (select *from Customers where CustomerID = @CusID) Raiserror('Mã Khách Hàng không tồn tại',16,1) else delete Customers where CustomerID = @CusID GO /****** Object: StoredProcedure [dbo].[sp_Customers_Insert] Script Date: 11/10/2012 4:01:41 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE proc [dbo].[sp_Customers_Insert] ( @CustomerName nvarchar(40), @UserName varchar(15), @Password nvarchar(MAX), @Address nvarchar(40), @SignUpDate datetime, @City nvarchar(15), @Country nvarchar(15), @Phone nvarchar(24), @Email nvarchar(40) ) as insert Customers(CustomerName, username, Password, Address, SignUpDate, City, Country, Phone, Email) values (@CustomerName, @UserName, @Password, @Address,@SignUpDate, @City, @Country, @Phone, @Email) GO /****** Object: StoredProcedure [dbo].[sp_Customers_Update] Script Date: 11/10/2012 4:01:41 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE proc [dbo].[sp_Customers_Update] ( @CusID int, @CustomerName nvarchar(40), @UserName varchar(15), @Password nvarchar(MAX), @Address nvarchar(40), @SignUpDate datetime, @City nvarchar(15), @PostalCode nvarchar(10), @Country nvarchar(15), @Phone nvarchar(24), @Email nvarchar(40), @Status bit ) as if not exists (select *from Customers where CustomerID = @CusID) Raiserror('Mã Khách Hàng không tồn tại',16,1) else update Customers set CustomerName = @CustomerName, UserName = @UserName, Password = @Password, Address = @Address, SignUpDate = @SignUpDate, City = @City, PostalCode = @PostalCode, Country = @Country, Phone = @Phone, Email = @Email, Status = @Status where CustomerID = @CusID GO /****** Object: StoredProcedure [dbo].[sp_Employees_Delete] Script Date: 11/10/2012 4:01:41 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO create proc [dbo].[sp_Employees_Delete] ( @EmpID int ) as if not exists(select * from Employees where EmployeeID=@EmpID) raiserror('Nhân viên không tồn tại',16,1) else delete from Employees where EmployeeID=@EmpID GO /****** Object: StoredProcedure [dbo].[sp_Employees_Insert] Script Date: 11/10/2012 4:01:41 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE proc [dbo].[sp_Employees_Insert] ( @LName nvarchar(20), @FName nvarchar(10), @AName nvarchar(15), @Pas nvarchar(MAX), @PositionID int, @BirthDate datetime, @HireDate datetime, @IdenCard nvarchar(9), @Address nvarchar(60), @City nvarchar(15), @PostalCode nvarchar(10), @Country nvarchar(15), @HomePhone nvarchar(24), @PhotoPath nvarchar(255) ) as insert Employees(LastName,FirstName,AdminName,Password,PositionID,BirthDate,HireDate,IdentityCard,Address,City,PostalCode,Country,HomePhone,PhotoPath) values (@LName,@FName,@AName,@Pas,@PositionID,@BirthDate,@HireDate,@IdenCard,@Address,@City,@PostalCode,@Country,@HomePhone,@PhotoPath) GO /****** Object: StoredProcedure [dbo].[sp_Employees_Update] Script Date: 11/10/2012 4:01:41 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE proc [dbo].[sp_Employees_Update] ( @EmpID int, @LName nvarchar(20), @FName nvarchar(10), @AName nvarchar(15), @Pas nvarchar(MAX), @PositionID int, @BirthDate datetime, @HireDate datetime, @IdenCard nvarchar(9), @Address nvarchar(60), @City nvarchar(15), @PostalCode nvarchar(10), @Country nvarchar(15), @HomePhone nvarchar(24), @PhotoPath nvarchar(255), @Status bit ) as if not exists(select * from Employees where EmployeeID=@EmpID) raiserror('Nhân viên không tồn tại',16,1) else update Employees set LastName = @LName, FirstName = @FName, AdminName = @AName, [Password] = @Pas, PositionID = @PositionID, BirthDate = @BirthDate, HireDate = @HireDate, IdentityCard = @IdenCard, [Address] = @Address, City = @City, PostalCode = @PostalCode, Country = @Country, HomePhone = @HomePhone, PhotoPath = @PhotoPath, Status = @Status where EmployeeID=@EmpID GO /****** Object: StoredProcedure [dbo].[sp_ExportBills_Insert] Script Date: 11/10/2012 4:01:41 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE proc [dbo].[sp_ExportBills_Insert] ( @PaymentID nchar(10), @OrderID int, @CustomerID int, @ExportBillDate datetime ) as insert ExportBills (PaymentID,OrderID,CustomerID,ExportBillDate) values(@PaymentID,@OrderID,@CustomerID,@ExportBillDate) GO /****** Object: StoredProcedure [dbo].[sp_ExportBills_Update] Script Date: 11/10/2012 4:01:41 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE proc [dbo].[sp_ExportBills_Update] ( @ExportBillID int, @PaymentID nchar(10), @OrderID int, @CustomerID int, @ExportBillDate datetime ) as update ExportBills set PaymentID = @PaymentID,OrderID = @OrderID,CustomerID = @CustomerID,ExportBillDate =@ExportBillDate where ExportBillID = @ExportBillID GO /****** Object: StoredProcedure [dbo].[sp_ImportBills_Insert] Script Date: 11/10/2012 4:01:41 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO create proc [dbo].[sp_ImportBills_Insert] ( @SupplierID int, @PaymentID nchar(10), @EmployeeID int, @ProductID int, @ImportBillDate datetime, @UnitPrice money, @Quantity int ) as insert importbills(supplierid,paymentid,employeeid,productid,importbilldate,unitprice,quantity) values(@SupplierID,@PaymentID,@EmployeeID,@ProductID,@ImportBillDate,@UnitPrice,@Quantity) GO /****** Object: StoredProcedure [dbo].[sp_ImportBills_Update] Script Date: 11/10/2012 4:01:41 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO create proc [dbo].[sp_ImportBills_Update] ( @ImportBillID int, @SupplierID int, @PaymentID nchar(10), @EmployeeID int, @ProductID int, @ImportBillDate datetime, @UnitPrice money, @Quantity int ) as update importbills set supplierid=@SupplierID,paymentid=@PaymentID,employeeid=@EmployeeID,productid=@ProductID,importbilldate=@ImportBillDate,unitprice=@UnitPrice,quantity=@Quantity where importbillid=@ImportBillID GO /****** Object: StoredProcedure [dbo].[sp_Order_Update_Basic] Script Date: 11/10/2012 4:01:41 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO create proc [dbo].[sp_Order_Update_Basic] ( @OrderID int, @EmpID int, @RequiredDate datetime, @Freight money, @ShipName nvarchar(50), @ShipAddress nvarchar(50), @ShipCity nvarchar(50), @Shippostalcode nvarchar(50), @ShipCountry nvarchar(50), @Hide bit ) as if not exists(select * from Orders where OrderID=@OrderID) raiserror('Đơn đặt hàng không tồn tại',16,1) else update Orders set EmployeeID=@EmpID, RequiredDate=@RequiredDate, freight=@Freight, shipname=@ShipName, shipaddress=@ShipAddress, shipcity=@ShipCity, shippostalcode=@Shippostalcode, shipcountry=@ShipCountry, hide=@Hide where OrderID=@OrderID GO /****** Object: StoredProcedure [dbo].[sp_Order_UpdateEmpID] Script Date: 11/10/2012 4:01:41 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO create proc [dbo].[sp_Order_UpdateEmpID] ( @OrderID int, @EmpID int, @RequiredDate datetime, @TotalAmount money ) as if not exists(select * from Orders where OrderID=@OrderID) raiserror('Đơn đặt hàng không tồn tại',16,1) else update Orders set EmployeeID=@EmpID,RequiredDate=@RequiredDate,Totalamount=@TotalAmount where OrderID=@OrderID GO /****** Object: StoredProcedure [dbo].[sp_OrderDetails_Insert] Script Date: 11/10/2012 4:01:41 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO create proc [dbo].[sp_OrderDetails_Insert] ( @ProductID int, @OrderID int, @UnitPrice money,--UnitPricefProduct + VAT @Quantity int, @Discount float ) as insert orderdetails values (@ProductID,@OrderID,@UnitPrice,@Quantity,@Discount) GO /****** Object: StoredProcedure [dbo].[sp_Orders_Insert] Script Date: 11/10/2012 4:01:41 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO create proc [dbo].[sp_Orders_Insert] ( @CusID int, @EmpID int, @OrderDate datetime, @RequiredDate datetime, @VAT int, @Freight money, @ShipName nvarchar(40), @ShipAddress nvarchar(60), @ShipCity nvarchar(15), @ShipPostalCode nvarchar(10), @ShipCountry nvarchar(15) ) as insert Orders(CustomerID,EmployeeID,OrderDate,RequiredDate,VAT,Freight,ShipName, ShipAddress,ShipCity,ShipPostalCode,ShipCountry) values(@CusID,@EmpID,@OrderDate,@RequiredDate,@VAT,@Freight,@ShipName, @ShipAddress,@ShipCity,@ShipPostalCode,@ShipCountry) GO /****** Object: StoredProcedure [dbo].[sp_Orders_InsertByCus] Script Date: 11/10/2012 4:01:41 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO create proc [dbo].[sp_Orders_InsertByCus] ( @CusID int, @OrderDate datetime, @RequiredDate datetime, @VAT int, @Freight money, @ShipName nvarchar(40), @ShipAddress nvarchar(60), @ShipCity nvarchar(15), @ShipPostalCode nvarchar(10), @ShipCountry nvarchar(15) ) as insert Orders(CustomerID,OrderDate,RequiredDate,VAT,Freight,ShipName, ShipAddress,ShipCity,ShipPostalCode,ShipCountry) values(@CusID,@OrderDate,@RequiredDate,@VAT,@Freight,@ShipName, @ShipAddress,@ShipCity,@ShipPostalCode,@ShipCountry) GO /****** Object: StoredProcedure [dbo].[sp_OrderUpdateTotalAmount] Script Date: 11/10/2012 4:01:41 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO create proc [dbo].[sp_OrderUpdateTotalAmount] ( @OrderID int, @TotalAmount money ) as update orders set totalamount = @TotalAmount where orderid=@OrderID GO /****** Object: StoredProcedure [dbo].[sp_Origins_Delete] Script Date: 11/10/2012 4:01:41 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO create proc [dbo].[sp_Origins_Delete] ( @OriginID nchar(10) ) as if not exists (select * from Origins where OriginID = @OriginID) Raiserror('Nơi xuất xứ không tồn tại',16,1) else delete Origins where OriginID = @OriginID GO /****** Object: StoredProcedure [dbo].[sp_Origins_Insert] Script Date: 11/10/2012 4:01:41 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO create proc [dbo].[sp_Origins_Insert] ( @OriginID nchar(10), @CountryName nvarchar(50) ) as if exists (select *from Origins where OriginID = @OriginID) Raiserror('Mã xuất xứ đã tồn tại',16,1) else insert Origins (OriginID,CountryName) values(@OriginID,@CountryName) GO /****** Object: StoredProcedure [dbo].[sp_Origins_Update] Script Date: 11/10/2012 4:01:41 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO create proc [dbo].[sp_Origins_Update] ( @OriginID nchar(10), @CountryName nvarchar(50), @Status bit ) as if not exists (select * from Origins where OriginID = @OriginID) Raiserror('Nơi xuất xứ không tồn tại',16,1) else update Origins set CountryName = @CountryName,Status = @Status where OriginID = @OriginID GO /****** Object: StoredProcedure [dbo].[sp_Payments_Delete] Script Date: 11/10/2012 4:01:41 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO create proc [dbo].[sp_Payments_Delete] ( @PaymentID nchar(10) ) as if not exists ( select * from Payments where PaymentID = @PaymentID) Raiserror('Hình thức thanh toán không tồn tại',16,1) else delete Payments where PaymentID = @PaymentID GO /****** Object: StoredProcedure [dbo].[sp_Payments_Insert] Script Date: 11/10/2012 4:01:41 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO create proc [dbo].[sp_Payments_Insert] ( @PaymentID nchar(10), @PaymentName nvarchar(50) ) as if exists (select * from Payments where PaymentID = @PaymentID) Raiserror('Hình thức thanh toán đã tồn tại',16,1) else insert Payments (PaymentID,PaymentName) values(@PaymentID,@PaymentName) GO /****** Object: StoredProcedure [dbo].[sp_Payments_Update] Script Date: 11/10/2012 4:01:41 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO create proc [dbo].[sp_Payments_Update] ( @PaymentID nchar(10), @PaymentName nvarchar(50), @Status bit ) as if not exists (select * from Payments where PaymentID = @PaymentID) Raiserror('Hình thức thanh toán không tồn tại',16,1) else update Payments set PaymentName = @PaymentName,Status = @Status where PaymentID = @PaymentID GO /****** Object: StoredProcedure [dbo].[sp_Positions_Delete] Script Date: 11/10/2012 4:01:41 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO create proc [dbo].[sp_Positions_Delete] ( @PositionID int ) as if not exists (select * from Positions where PositionID = @PositionID) raiserror('Cấp bậc không tồn tại',16,1) else delete from Positions where PositionID = @PositionID GO /****** Object: StoredProcedure [dbo].[sp_Positions_Insert] Script Date: 11/10/2012 4:01:41 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO create proc [dbo].[sp_Positions_Insert] ( @PositionName nvarchar(100), @Description nvarchar(255) ) as insert positions(positionname,description) values(@PositionName,@Description) GO /****** Object: StoredProcedure [dbo].[sp_Positions_Update] Script Date: 11/10/2012 4:01:41 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO create proc [dbo].[sp_Positions_Update] ( @PositionID int, @PositionName nvarchar(100), @Description nvarchar(255), @Status bit ) as if not exists (select * from Positions where PositionID=@PositionID) raiserror('Cấp bậc không tồn tại',16,1) else update Positions set PositionName = @PositionName,description= @Description,status=@Status where PositionID=@PositionID GO /****** Object: StoredProcedure [dbo].[sp_Product_SelectBasic] Script Date: 11/10/2012 4:01:41 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE proc [dbo].[sp_Product_SelectBasic] as select productid,productname,supplierid, categoryid,originid,unitprice,unitprice_sell, unitsinstock,unitsonorder,dateupdated,description from products order by productid desc GO /****** Object: StoredProcedure [dbo].[sp_Products_InsertBasicInformation] Script Date: 11/10/2012 4:01:41 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE proc [dbo].[sp_Products_InsertBasicInformation] ( @ProductName nvarchar(40) ,--tên sản phẩm @SupplierID int ,--mã nhà cung cấp @CategoryID nvarchar(9) ,--mã chủng loại @OriginID nchar(10),--mã xuất xứ @Description ntext ,--mô tả tính năng nổi bật sản phẩm @PhotoPath ntext ,--hình về sản phẩm @DateUpdated datetime ,--ngày nhập hàng @UnitPrice money ,--đơn giá gốc @UnitPrice_Sell money, --đơn giá bán @UnitsInStock int ,--sản phẩm trong kho @UnitsOnOrder int, --sản phẩm đã đặt hàng @Discount float ) as insert Products(ProductName, SupplierID, CategoryID,OriginID, Description, photopath, DateUpdated, UnitPrice, UnitPrice_Sell, UnitsInStock, UnitsOnOrder,discount) values (@ProductName, @SupplierID, @CategoryID,@OriginID, @Description, @PhotoPath, @DateUpdated, @UnitPrice, @UnitPrice_Sell, @UnitsInStock, @UnitsOnOrder,@Discount) GO /****** Object: StoredProcedure [dbo].[sp_Products_Update_Laptop_Tablet] Script Date: 11/10/2012 4:01:41 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE proc [dbo].[sp_Products_Update_Laptop_Tablet] ( @ProID int, @ManufacturerName nvarchar(30),--tên hãng sản xuất cpu @TechnologyCPU nvarchar(30),--công nghệ cpu @TypeCPU nvarchar(30),--loại cpu @SpeedCPU nvarchar(30),--tốc độ cpu @OtherInfoCPU ntext,--thông tin khác về cpu @StorageRAM nvarchar(10),--dung lượng ram @BusSpeed nvarchar(10),--tốc độ bus @DiskSpace nvarchar(10),--dung lượng ổ đĩa @RotationalSpeed nvarchar(10),--tốc độ quay @TouchScreen nvarchar(20),--màn hình cảm ứng @SizeMH int,--kích thước MH(inch) @GraphicsChipset nvarchar(30),--chipset đồ họa @GraphicsSpace nvarchar(20),--bộ nhớ đồ họa @OtherInfoGraphics nvarchar(30),--thông tin khác về card @OpticalDiscs nvarchar(20),--loại đĩa quang @Interface nvarchar(20),--cổng giao tiếp @ExtendedFeatures nvarchar(30),--tính năng mở rộng @WiFiStandard nvarchar(20),--chuẩn Wifi @WirelessConnection nvarchar(20),--kết nối không dây khác @WebCam nvarchar(20),--WebCame @BatteryInformation nvarchar(20),--Thông tin pin @UseTime nvarchar(20),--Thời gian sử dụng @OS nvarchar(20),--Hệ điều hành kèm theo máy @OtherInfoOS nvarchar(30)--Thông tin khác về hệ điều hành ) as if not exists (select *from Products where ProductID = @ProID) Raiserror('Mã Sãn Phẩm không tồn tại',16,1) else update Products set ManufacturerName = @ManufacturerName, TechnologyCPU = @TechnologyCPU, TypeCPU = @TypeCPU, SpeedCPU = @SpeedCPU, OtherInfoCPU = @OtherInfoCPU, StorageRAM = @StorageRAM , BusSpeed = @BusSpeed, DiskSpace = @DiskSpace, RotationalSpeed = @RotationalSpeed, TouchScreen = @TouchScreen, SizeMH = @SizeMH, GraphicsChipset = @GraphicsChipset, GraphicsSpace = @GraphicsSpace, OtherInfoGraphics = @OtherInfoGraphics, OpticalDiscs = @OpticalDiscs, Interface = @Interface, ExtendedFeatures = @ExtendedFeatures, WiFiStandard = @WiFiStandard, WirelessConnection = @WirelessConnection, WebCam = @WebCam, BatteryInformation = @BatteryInformation, UseTime = @UseTime, OS =@OS, OtherInfoOS = @OtherInfoOS where ProductID = @ProID GO /****** Object: StoredProcedure [dbo].[sp_Products_Update_Phone] Script Date: 11/10/2012 4:01:41 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE proc [dbo].[sp_Products_Update_Phone] ( @ProID int, @Camera nvarchar(30) ,--máy ảnh @Movie nvarchar(30) ,--xem phim @Music nvarchar(30) ,--nghe nhạc @FMRadio nvarchar(20) ,--nghe radio @Record nvarchar(30) ,--ghi âm @OtherApplication nvarchar(200) ,--ứng dụng khác @Ringtones nvarchar(40) ,--nhạc chuông @HeadPhone nvarchar(15) ,--tai nghe @Memory nvarchar(10) ,--bộ nhớ trong @SDCardSupport nvarchar(20) ,--hổ trợ thẻ nhớ @Contacts nvarchar(20) ,--danh bạ @MobileNetwork nvarchar(50) ,--mạng di động @GPRS nvarchar(50) ,--cài GPRS @Network3G nvarchar(40) ,--mạng 3G @GPS nvarchar(10) ,--GPS @Bluetooth nvarchar(20) ,--Bluetooth @USB nvarchar(10) , @TypeScreen nvarchar(50) ,--loại Màn hình hiển thị @Resolution nvarchar(20) ,--Độ phân giải @SizePhone nvarchar(10) ,--kích thước @OS nvarchar(20) ,--Hệ điều hành kèm theo máy @KeyboardQwerty nvarchar(10) ,--Bàn phím ảo @Weight nvarchar(10) ,--Trọng lượng @Language nvarchar(10) ,--Ngôn ngữ @BatteryInformation nvarchar(20) ,--Thông tin pin @UseTime nvarchar(20) ,--Thời gian sử dụng @TalkTime nvarchar(10) ,--Thời gian đàm thoại @WaitTime nvarchar(10) ,--Thời gian chờ @OtherInfoPhone ntext --Thông tin khác về phone ) as if not exists (select *from Products where ProductID = @ProID) Raiserror('Mã Sản Phẩm không tồn tại',16,1) else update Products set Camera = @Camera, Movie = @Movie, Music = @Music, FMRadio =@FMRadio, Record = @Record, OtherApplication = @OtherApplication, Ringtones = @Ringtones, HeadPhone = @HeadPhone, Memory = @Memory, SDCardSupport = @SDCardSupport, Contacts = @Contacts, MobileNetwork = @MobileNetwork, GPRS = @GPRS, Network3G = @Network3G, GPS = @GPS, Bluetooth = @Bluetooth, USB = @USB, TypeScreen = @TypeScreen, Resolution = @Resolution, SizePhone = @SizePhone, OS = @OS, KeyboardQwerty = @KeyboardQwerty, Weight = @Weight, Language = @Language, BatteryInformation = @BatteryInformation, UseTime = @UseTime, TalkTime = @TalkTime, WaitTime = @WaitTime, OtherInfoPhone = @OtherInfoPhone where ProductID = @ProID GO /****** Object: StoredProcedure [dbo].[sp_Products_UpdateBasicInformation] Script Date: 11/10/2012 4:01:41 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE proc [dbo].[sp_Products_UpdateBasicInformation] ( @ProductID int ,--mã sản phẩm @ProductName nvarchar(40) ,--tên sản phẩm @SupplierID int ,--mã nhà cung cấp @CategoryID nvarchar(9) ,--mã chủng loại @OriginID nchar(10),--mã xuất xứ @Description ntext ,--mô tả tính năng nổi bật sản phẩm @PhotoPath ntext ,--hình về sản phẩm @DateUpdated datetime ,--ngày nhập hàng @UnitPrice money ,--đơn giá gốc @UnitPrice_Sell money, --đơn giá bán @UnitsInStock int ,--sản phẩm trong kho @UnitsOnOrder int, --sản phẩm đã đặt hàng @Discontinued bit, -- default 0, bán/ngừng @Discount float ) as if not exists(select *from Products where productid = @ProductID) Raiserror('Mã Sản Phẩm không tồn tại',16,1) else update Products set ProductName = @ProductName , SupplierID = @SupplierID , CategoryID = @CategoryID , OriginID = @OriginID, Description = @Description , photopath = @PhotoPath , DateUpdated = @DateUpdated, UnitPrice = @UnitPrice, UnitPrice_Sell = @UnitPrice_Sell, unitsinstock=@UnitsInStock, UnitsOnOrder = @UnitsOnOrder, Discontinued = @Discontinued, discount = @Discount where productid = @ProductID GO /****** Object: StoredProcedure [dbo].[sp_SelectOneOrder] Script Date: 11/10/2012 4:01:41 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO create proc [dbo].[sp_SelectOneOrder] as select MAX(orderid) as MAX from Orders GO /****** Object: StoredProcedure [dbo].[sp_SupplierByCatID] Script Date: 11/10/2012 4:01:41 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE proc [dbo].[sp_SupplierByCatID] ( @CatID nvarchar(50) ) as select CateID,SupID,companyname,pagesite from Sup_Categories sc inner join suppliers s on sc.SupID=s.supplierid inner join categories c on sc.CateID=c.categoryid where c.categoryname=@CatID GO /****** Object: StoredProcedure [dbo].[sp_Suppliers_Delete] Script Date: 11/10/2012 4:01:41 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO create proc [dbo].[sp_Suppliers_Delete] ( @SupID int ) as if not exists (select *from Suppliers where SupplierID = @SupID) Raiserror('Mã Nhà Cung Cấp không tồn tại',16,1) else delete Suppliers where SupplierID = @SupID GO /****** Object: StoredProcedure [dbo].[sp_Suppliers_Insert] Script Date: 11/10/2012 4:01:41 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE proc [dbo].[sp_Suppliers_Insert] ( @CompanyName nvarchar(50), @ContactName nvarchar(40), @ContactTitle nvarchar(40), @Address nvarchar(100), @City nvarchar(15), @PostalCode nvarchar(10), @Country nvarchar(15), @Phone nvarchar(24), @HomePage nvarchar(150) ) as insert Suppliers(CompanyName,ContactName,ContactTitle,Address,City,PostalCode,Country,Phone,HomePage) values (@CompanyName, @ContactName, @ContactTitle, @Address, @City, @PostalCode, @Country, @Phone, @HomePage) GO /****** Object: StoredProcedure [dbo].[sp_Suppliers_Update] Script Date: 11/10/2012 4:01:41 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE proc [dbo].[sp_Suppliers_Update] ( @SupID int, @CompanyName nvarchar(50), @ContactName nvarchar(40), @ContactTitle nvarchar(40), @Address nvarchar(100), @City nvarchar(15), @PostalCode nvarchar(10), @Country nvarchar(15), @Phone nvarchar(24), @HomePage nvarchar(150), @Status bit ) as if not exists (select *from Suppliers where SupplierID = @SupID) Raiserror('Mã Nhà Cung Cấp không tồn tại',16,1) else update Suppliers set CompanyName = @CompanyName, ContactName = @ContactName, ContactTitle = @ContactTitle, [Address] = @Address, City = @City, PostalCode = @PostalCode, Country = @Country, Phone = @Phone, HomePage = @HomePage, Status = @Status where SupplierID = @SupID GO /****** Object: Table [dbo].[categories] Script Date: 11/10/2012 4:01:41 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[categories]( [categoryid] [nvarchar](9) NOT NULL, [categoryname] [nvarchar](50) NOT NULL, [descriptions] [nvarchar](1000) NULL, [pagesite] [nvarchar](150) NULL, [status] [bit] NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[City_Freight] Script Date: 11/10/2012 4:01:41 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[City_Freight]( [CityID] [char](10) NULL, [CityName] [nvarchar](50) NULL, [Freight] [money] NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[customers] Script Date: 11/10/2012 4:01:41 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[customers]( [customerid] [int] IDENTITY(1,1) NOT NULL, [customername] [nvarchar](50) NOT NULL, [username] [nvarchar](50) NOT NULL, [password] [nvarchar](max) NOT NULL, [address] [nvarchar](100) NULL, [signupdate] [datetime] NOT NULL, [city] [nvarchar](50) NULL, [postalcode] [nvarchar](50) NULL, [country] [nvarchar](50) NULL, [phone] [nvarchar](50) NULL, [email] [nvarchar](50) NULL, [status] [bit] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[employees] Script Date: 11/10/2012 4:01:41 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[employees]( [employeeid] [int] IDENTITY(1,1) NOT NULL, [positionid] [int] NOT NULL, [lastname] [nvarchar](50) NOT NULL, [firstname] [nvarchar](50) NOT NULL, [adminname] [nvarchar](50) NOT NULL, [password] [nvarchar](max) NOT NULL, [birthdate] [datetime] NULL, [hiredate] [datetime] NULL, [identitycard] [nvarchar](50) NULL, [address] [nvarchar](100) NULL, [city] [nvarchar](50) NULL, [postalcode] [nvarchar](50) NULL, [country] [nvarchar](50) NULL, [homephone] [nvarchar](50) NULL, [photopath] [nvarchar](255) NULL, [status] [bit] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[exportbills] Script Date: 11/10/2012 4:01:41 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[exportbills]( [exportbillid] [int] IDENTITY(1,1) NOT NULL, [paymentid] [nchar](10) NOT NULL, [orderid] [int] NOT NULL, [customerid] [int] NOT NULL, [exportbilldate] [datetime] NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[importbills] Script Date: 11/10/2012 4:01:41 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[importbills]( [importbillid] [int] IDENTITY(1,1) NOT NULL, [supplierid] [int] NOT NULL, [paymentid] [nchar](10) NOT NULL, [employeeid] [int] NOT NULL, [productid] [int] NOT NULL, [importbilldate] [datetime] NULL, [unitprice] [money] NULL, [quantity] [int] NULL, [totalamount] AS ([unitprice]*[quantity]) ) ON [PRIMARY] GO /****** Object: Table [dbo].[orderdetails] Script Date: 11/10/2012 4:01:41 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[orderdetails]( [STT] [int] IDENTITY(1,1) NOT NULL, [productid] [int] NOT NULL, [orderid] [int] NOT NULL, [unitprice] [money] NULL, [quantity] [int] NULL, [discount] [float] NULL, [amount] AS ([unitprice]*[quantity]), PRIMARY KEY CLUSTERED ( [STT] 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 /****** Object: Table [dbo].[orders] Script Date: 11/10/2012 4:01:41 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[orders]( [orderid] [int] IDENTITY(1,1) NOT NULL, [employeeid] [int] NULL, [customerid] [int] NULL, [orderdate] [datetime] NULL, [requireddate] [datetime] NULL, [vat] [int] NULL, [freight] [money] NULL, [shipname] [nvarchar](50) NULL, [shipaddress] [nvarchar](60) NULL, [shipcity] [nvarchar](50) NULL, [shippostalcode] [nvarchar](50) NULL, [shipcountry] [nvarchar](50) NULL, [totalamount] [money] NULL, [hide] [bit] NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[origins] Script Date: 11/10/2012 4:01:41 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[origins]( [originid] [nchar](10) NOT NULL, [countryname] [nvarchar](50) NULL, [status] [bit] NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[payments] Script Date: 11/10/2012 4:01:41 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[payments]( [paymentid] [nchar](10) NOT NULL, [paymentname] [nvarchar](50) NULL, [status] [bit] NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[positions] Script Date: 11/10/2012 4:01:41 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[positions]( [positionid] [int] IDENTITY(1,1) NOT NULL, [positionname] [nvarchar](100) NOT NULL, [description] [nvarchar](255) NULL, [status] [bit] NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[products] Script Date: 11/10/2012 4:01:41 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[products]( [productid] [int] IDENTITY(1,1) NOT NULL, [categoryid] [nvarchar](9) NOT NULL, [originid] [nchar](10) NOT NULL, [supplierid] [int] NOT NULL, [productname] [nvarchar](50) NOT NULL, [description] [ntext] NULL, [photopath] [ntext] NULL, [dateupdated] [datetime] NULL, [unitprice] [money] NULL, [unitprice_sell] [money] NULL, [unitsinstock] [int] NULL, [unitsonorder] [int] NULL, [discount] [float] NULL, [manufacturername] [nvarchar](50) NULL, [technologycpu] [nvarchar](50) NULL, [typecpu] [nvarchar](50) NULL, [speedcpu] [nvarchar](50) NULL, [otherinfocpu] [ntext] NULL, [storageram] [nvarchar](50) NULL, [busspeed] [nvarchar](50) NULL, [diskspace] [nvarchar](50) NULL, [rotationalspeed] [nvarchar](50) NULL, [touchscreen] [nvarchar](50) NULL, [sizemh] [int] NULL, [graphicschipset] [nvarchar](50) NULL, [graphicsspace] [nvarchar](50) NULL, [otherinfographics] [nvarchar](50) NULL, [opticaldiscs] [nvarchar](50) NULL, [interface] [nvarchar](50) NULL, [extendedfeatures] [nvarchar](50) NULL, [wifistandard] [nvarchar](50) NULL, [wirelessconnection] [nvarchar](50) NULL, [webcam] [nvarchar](50) NULL, [batteryinformation] [nvarchar](50) NULL, [usetime] [nvarchar](50) NULL, [os] [nvarchar](50) NULL, [otherinfoos] [nvarchar](50) NULL, [camera] [nvarchar](50) NULL, [movie] [nvarchar](50) NULL, [music] [nvarchar](50) NULL, [fmradio] [nvarchar](50) NULL, [record] [nvarchar](50) NULL, [otherapplication] [nvarchar](200) NULL, [ringtones] [nvarchar](50) NULL, [headphone] [nvarchar](50) NULL, [memory] [nvarchar](50) NULL, [sdcardsupport] [nvarchar](50) NULL, [contacts] [nvarchar](50) NULL, [mobilenetwork] [nvarchar](50) NULL, [gprs] [nvarchar](50) NULL, [network3g] [nvarchar](50) NULL, [gps] [nvarchar](50) NULL, [bluetooth] [nvarchar](50) NULL, [usb] [nvarchar](50) NULL, [typescreen] [nvarchar](50) NULL, [resolution] [nvarchar](50) NULL, [sizephone] [nvarchar](50) NULL, [keyboardqwerty] [nvarchar](50) NULL, [weight] [nvarchar](50) NULL, [language] [nvarchar](50) NULL, [talktime] [nvarchar](50) NULL, [waittime] [nvarchar](50) NULL, [otherinfophone] [ntext] NULL, [discontinued] [bit] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[Sup_Categories] Script Date: 11/10/2012 4:01:41 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Sup_Categories]( [CateID] [nvarchar](9) NOT NULL, [SupID] [int] NOT NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[suppliers] Script Date: 11/10/2012 4:01:41 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[suppliers]( [supplierid] [int] IDENTITY(1,1) NOT NULL, [companyname] [nvarchar](50) NOT NULL, [contactname] [nvarchar](50) NOT NULL, [contacttitle] [nvarchar](50) NULL, [address] [nvarchar](100) NOT NULL, [city] [nvarchar](50) NULL, [postalcode] [nvarchar](50) NULL, [country] [nvarchar](50) NULL, [phone] [nvarchar](50) NULL, [homepage] [nvarchar](150) NULL, [status] [bit] NULL ) ON [PRIMARY] GO /****** Object: View [dbo].[v_Product_SelectBasic] Script Date: 11/10/2012 4:01:41 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO create view [dbo].[v_Product_SelectBasic] as select productid,productname,supplierid,categoryid,originid,unitprice,unitprice_sell, unitsinstock,unitsonorder,dateupdated,description from products GO INSERT [dbo].[categories] ([categoryid], [categoryname], [descriptions], [pagesite], [status]) VALUES (N'LT', N'Laptop', N'Các loại sản phẩm máy tính xách tay', N'May-tinh-xach-tay.aspx', 1) INSERT [dbo].[categories] ([categoryid], [categoryname], [descriptions], [pagesite], [status]) VALUES (N'TL', N'Tablet', N'Các loại sản phẩm máy tính bảng', N'Tablet.aspx', 1) INSERT [dbo].[categories] ([categoryid], [categoryname], [descriptions], [pagesite], [status]) VALUES (N'MP', N'MobilePhone', N'Các loại điện thoại di động', N'MobilePhone.aspx', 1) INSERT [dbo].[categories] ([categoryid], [categoryname], [descriptions], [pagesite], [status]) VALUES (N'CM', N'Camera', N'Các loại sản phẩm máy ảnh', N'camera.aspx', 0) INSERT [dbo].[categories] ([categoryid], [categoryname], [descriptions], [pagesite], [status]) VALUES (N'PK', N'phụ kiện', N'các loại phụ kiện', N'phu-kien.aspx', 0) INSERT [dbo].[City_Freight] ([CityID], [CityName], [Freight]) VALUES (N'HCM ', N'Hồ Chí Minh', 20000.0000) INSERT [dbo].[City_Freight] ([CityID], [CityName], [Freight]) VALUES (N'HN ', N'Hà Nội', 30000.0000) INSERT [dbo].[City_Freight] ([CityID], [CityName], [Freight]) VALUES (N'NT ', N'Nha Trang', 15000.0000) INSERT [dbo].[City_Freight] ([CityID], [CityName], [Freight]) VALUES (N'DN ', N'Đà Nẵng', 23000.0000) INSERT [dbo].[City_Freight] ([CityID], [CityName], [Freight]) VALUES (N'HUE ', N'Huế', 27000.0000) SET IDENTITY_INSERT [dbo].[customers] ON INSERT [dbo].[customers] ([customerid], [customername], [username], [password], [address], [signupdate], [city], [postalcode], [country], [phone], [email], [status]) VALUES (1, N'Nguyễn Tấn Beo', N'tanbeo', N'<? ??%5MU ?!Y ?n8??!s???>?L ~z????? >;??a;1?\?6!M??JB?z/???k?\D?', N'35 Lê Đại Hành', CAST(0x0000A0F700000000 AS DateTime), N'Tp.Hồ Chí Minh', N'70000', N'Việt Nam', N'38393173', N'tanbeo@yahoo.com', 1) INSERT [dbo].[customers] ([customerid], [customername], [username], [password], [address], [signupdate], [city], [postalcode], [country], [phone], [email], [status]) VALUES (2, N'Nguyễn Tấn Bo', N'tanbo', N'<? ??%5MU ?!Y ?n8??!s???>?L ~z????? >;??a;1?\?6!M??JB?z/???k?\D?', N'56 Trần Quốc Toản', CAST(0x0000A0F700000000 AS DateTime), N'Tp.Hồ Chí Minh', N'70000', N'Việt Nam', N'38393173', N'tanbo@yahoo.com', 1) INSERT [dbo].[customers] ([customerid], [customername], [username], [password], [address], [signupdate], [city], [postalcode], [country], [phone], [email], [status]) VALUES (4, N'tienloc', N'tienlocdkny', N'tienlocdkny', N'181J/2A binh thoi', CAST(0x0000A10300000000 AS DateTime), N'ho chinh minh', NULL, N'vietnam', N'0903915877', N'mrdream.dkny@yahoo.com', 1) INSERT [dbo].[customers] ([customerid], [customername], [username], [password], [address], [signupdate], [city], [postalcode], [country], [phone], [email], [status]) VALUES (5, N'tienloc1', N'tienloc1', N'? ?3???? ??W??1 ?? zv?????y ??1?tMW1 k??w?q ?? ????E? C?? ??#?y', N'dia chi 1', CAST(0x0000A10300000000 AS DateTime), N'thanh pho 1', NULL, N'quoc gia 1', N'so dien thoai', N'email1@yahoo.com', 1) INSERT [dbo].[customers] ([customerid], [customername], [username], [password], [address], [signupdate], [city], [postalcode], [country], [phone], [email], [status]) VALUES (1004, N'nguyen van teo', N'teo123', N'u??;\[q??@t?([???_?????%????? z ]?M+ %|?C2?<?? + S???: ?j??@ p', N'100 cmt8', CAST(0x0000A10500000000 AS DateTime), N'tphcm', NULL, N'vietnam', N'8393173', N'lan@xom.dao', 1) SET IDENTITY_INSERT [dbo].[customers] OFF SET IDENTITY_INSERT [dbo].[employees] ON INSERT [dbo].[employees] ([employeeid], [positionid], [lastname], [firstname], [adminname], [password], [birthdate], [hiredate], [identitycard], [address], [city], [postalcode], [country], [homephone], [photopath], [status]) VALUES (1, 1, N'Nguyễn Tấn', N'Tài', N'nttai0011992', N'<? ??%5MU ?!Y ?n8??!s???>?L ~z????? >;??a;1?\?6!M??JB?z/???k?\D?', CAST(0x0000843800000000 AS DateTime), CAST(0x0000A0F200000000 AS DateTime), N'024700943', N'411/15 Lê Đại Hành P.11 Q.11', N'Tp.Hồ Chí Minh', N'70000', N'Việt Nam', N'0839625301', NULL, 1) INSERT [dbo].[employees] ([employeeid], [positionid], [lastname], [firstname], [adminname], [password], [birthdate], [hiredate], [identitycard], [address], [city], [postalcode], [country], [homephone], [photopath], [status]) VALUES (2, 1, N'Hồ Tiến', N'Lộc', N'htloc0021992', N'<? ??%5MU ?!Y ?n8??!s???>?L ~z????? >;??a;1?\?6!M??JB?z/???k?\D?', CAST(0x0000847C00000000 AS DateTime), CAST(0x0000A0F200000000 AS DateTime), N'024700943', N'411/15 Lê Đại Hành P.11 Q.11', N'Tp.Hồ Chí Minh', N'70000', N'Việt Nam', N'0838393173', NULL, 1) SET IDENTITY_INSERT [dbo].[employees] OFF SET IDENTITY_INSERT [dbo].[orderdetails] ON INSERT [dbo].[orderdetails] ([STT], [productid], [orderid], [unitprice], [quantity], [discount]) VALUES (2, 18, 9, NULL, NULL, NULL) INSERT [dbo].[orderdetails] ([STT], [productid], [orderid], [unitprice], [quantity], [discount]) VALUES (3, 19, 9, NULL, NULL, NULL) INSERT [dbo].[orderdetails] ([STT], [productid], [orderid], [unitprice], [quantity], [discount]) VALUES (5, 41, 10, 13000000.0000, 1, 0) INSERT [dbo].[orderdetails] ([STT], [productid], [orderid], [unitprice], [quantity], [discount]) VALUES (10, 41, 10, 13000000.0000, 1, 0) INSERT [dbo].[orderdetails] ([STT], [productid], [orderid], [unitprice], [quantity], [discount]) VALUES (12, 41, 10, 13000000.0000, 1, 0) INSERT [dbo].[orderdetails] ([STT], [productid], [orderid], [unitprice], [quantity], [discount]) VALUES (15, 41, 10, 13000000.0000, 1, 0) INSERT [dbo].[orderdetails] ([STT], [productid], [orderid], [unitprice], [quantity], [discount]) VALUES (16, 39, 10, 15000000.0000, 1, 0) INSERT [dbo].[orderdetails] ([STT], [productid], [orderid], [unitprice], [quantity], [discount]) VALUES (17, 39, 11, 15000000.0000, 1, 0) INSERT [dbo].[orderdetails] ([STT], [productid], [orderid], [unitprice], [quantity], [discount]) VALUES (18, 34, 11, 23000000.0000, 4, 0) INSERT [dbo].[orderdetails] ([STT], [productid], [orderid], [unitprice], [quantity], [discount]) VALUES (1015, 39, 1013, 15000000.0000, 1, 0) INSERT [dbo].[orderdetails] ([STT], [productid], [orderid], [unitprice], [quantity], [discount]) VALUES (1016, 43, 1014, 12000000.0000, 10, 0) INSERT [dbo].[orderdetails] ([STT], [productid], [orderid], [unitprice], [quantity], [discount]) VALUES (1017, 39, 1015, 15000000.0000, 3, 0) INSERT [dbo].[orderdetails] ([STT], [productid], [orderid], [unitprice], [quantity], [discount]) VALUES (1018, 39, 1015, 15000000.0000, 3, 0) INSERT [dbo].[orderdetails] ([STT], [productid], [orderid], [unitprice], [quantity], [discount]) VALUES (1019, 39, 1015, 15000000.0000, 3, 0) INSERT [dbo].[orderdetails] ([STT], [productid], [orderid], [unitprice], [quantity], [discount]) VALUES (1020, 28, 1016, 20100000.0000, 1, 0) INSERT [dbo].[orderdetails] ([STT], [productid], [orderid], [unitprice], [quantity], [discount]) VALUES (1021, 26, 1017, 20400000.0000, 5, 0) SET IDENTITY_INSERT [dbo].[orderdetails] OFF SET IDENTITY_INSERT [dbo].[orders] ON INSERT [dbo].[orders] ([orderid], [employeeid], [customerid], [orderdate], [requireddate], [vat], [freight], [shipname], [shipaddress], [shipcity], [shippostalcode], [shipcountry], [totalamount], [hide]) VALUES (1, 1, 1, CAST(0x0000A0F800000000 AS DateTime), CAST(0x0000A0FB00000000 AS DateTime), 10, 20000.0000, N'hồ tiến lộc', N'181J/2A bình thời, Q.11', N'Hồ Chí Minh', N'11000464', N'Việt nam', NULL, 1) INSERT [dbo].[orders] ([orderid], [employeeid], [customerid], [orderdate], [requireddate], [vat], [freight], [shipname], [shipaddress], [shipcity], [shippostalcode], [shipcountry], [totalamount], [hide]) VALUES (2, 1, 1, CAST(0x0000A0F800000000 AS DateTime), CAST(0x0000A0FB00000000 AS DateTime), 10, 20000.0000, N'hồ tiến lộc', N'181J/2A', N'HCM', N'11', N'Việt Nam', NULL, 0) INSERT [dbo].[orders] ([orderid], [employeeid], [customerid], [orderdate], [requireddate], [vat], [freight], [shipname], [shipaddress], [shipcity], [shippostalcode], [shipcountry], [totalamount], [hide]) VALUES (3, 1, 1, CAST(0x0000A0F800000000 AS DateTime), CAST(0x0000A0FB00000000 AS DateTime), 10, 20000.0000, N'hồ tiến lộc', N'181J/2A bình thời, Q.11', N'Hồ Chí Minh', N'11000464', N'Việt nam', NULL, 0) INSERT [dbo].[orders] ([orderid], [employeeid], [customerid], [orderdate], [requireddate], [vat], [freight], [shipname], [shipaddress], [shipcity], [shippostalcode], [shipcountry], [totalamount], [hide]) VALUES (4, 1, 1, CAST(0x0000A0F800000000 AS DateTime), CAST(0x0000A0FB00000000 AS DateTime), 10, 30000.0000, N'hồ tiến lộc', N'181J/2A bình thời, Q.11', N'Hồ Chí Minh', N'11000464', N'Việt nam', NULL, 0) INSERT [dbo].[orders] ([orderid], [employeeid], [customerid], [orderdate], [requireddate], [vat], [freight], [shipname], [shipaddress], [shipcity], [shippostalcode], [shipcountry], [totalamount], [hide]) VALUES (5, NULL, 4, CAST(0x0000A10400000000 AS DateTime), CAST(0x0000845E00000000 AS DateTime), 10, 10000.0000, N'a', N'a', N'a', N'a', N'a', NULL, 0) INSERT [dbo].[orders] ([orderid], [employeeid], [customerid], [orderdate], [requireddate], [vat], [freight], [shipname], [shipaddress], [shipcity], [shippostalcode], [shipcountry], [totalamount], [hide]) VALUES (6, NULL, 4, CAST(0x0000A10400000000 AS DateTime), CAST(0x0000845E00000000 AS DateTime), 10, 10000.0000, N'ho tien loc', N'ho tien loc', N'thanh pho', N'ma buu chi', N'quoc gia ', NULL, 0) INSERT [dbo].[orders] ([orderid], [employeeid], [customerid], [orderdate], [requireddate], [vat], [freight], [shipname], [shipaddress], [shipcity], [shippostalcode], [shipcountry], [totalamount], [hide]) VALUES (7, NULL, 4, CAST(0x0000A10400000000 AS DateTime), CAST(0x0000845E00000000 AS DateTime), 10, 10000.0000, N'tien loc', N'tien loc', N'thanh pho', N'ma buu chi', N'quoc gia', NULL, 0) INSERT [dbo].[orders] ([orderid], [employeeid], [customerid], [orderdate], [requireddate], [vat], [freight], [shipname], [shipaddress], [shipcity], [shippostalcode], [shipcountry], [totalamount], [hide]) VALUES (8, NULL, 4, CAST(0x0000A10400000000 AS DateTime), CAST(0x0000A0E700000000 AS DateTime), 10, 10000.0000, N'o', N'o', N'Thành phố', N'Mã bưu chí', N'Quốc gia', NULL, 0) INSERT [dbo].[orders] ([orderid], [employeeid], [customerid], [orderdate], [requireddate], [vat], [freight], [shipname], [shipaddress], [shipcity], [shippostalcode], [shipcountry], [totalamount], [hide]) VALUES (9, NULL, 4, CAST(0x0000A10500000000 AS DateTime), CAST(0x0000A10A00000000 AS DateTime), 10, 10000.0000, N'nguyen van a', N'nguyen van a', N'tphcm', N'70000', N'vietnam', NULL, 0) INSERT [dbo].[orders] ([orderid], [employeeid], [customerid], [orderdate], [requireddate], [vat], [freight], [shipname], [shipaddress], [shipcity], [shippostalcode], [shipcountry], [totalamount], [hide]) VALUES (10, NULL, 4, CAST(0x0000A10500000000 AS DateTime), CAST(0x0000A0E700000000 AS DateTime), 10, 10000.0000, N'loc', N'loc', N'thanh pho', N'7000', N'viet nam', NULL, 0) INSERT [dbo].[orders] ([orderid], [employeeid], [customerid], [orderdate], [requireddate], [vat], [freight], [shipname], [shipaddress], [shipcity], [shippostalcode], [shipcountry], [totalamount], [hide]) VALUES (11, NULL, 4, CAST(0x0000A10500000000 AS DateTime), CAST(0x0000A0E700000000 AS DateTime), 10, 10000.0000, N'loc', N'loc', N'loc', N'loc', N'loc', NULL, 0) INSERT [dbo].[orders] ([orderid], [employeeid], [customerid], [orderdate], [requireddate], [vat], [freight], [shipname], [shipaddress], [shipcity], [shippostalcode], [shipcountry], [totalamount], [hide]) VALUES (1011, NULL, 4, CAST(0x0000A10500000000 AS DateTime), CAST(0x0000A10A00000000 AS DateTime), 10, 10000.0000, N'nguyen tan teo', N'nguyen tan teo', N'tphcm', N'7000', N'vietnam', NULL, 0) INSERT [dbo].[orders] ([orderid], [employeeid], [customerid], [orderdate], [requireddate], [vat], [freight], [shipname], [shipaddress], [shipcity], [shippostalcode], [shipcountry], [totalamount], [hide]) VALUES (1012, NULL, 4, CAST(0x0000A10500000000 AS DateTime), CAST(0x0000A10C00000000 AS DateTime), 10, 10000.0000, N'nguyen van a', N'nguyen van a', N'tphcm', N'7000', N'vietnam', NULL, 0) INSERT [dbo].[orders] ([orderid], [employeeid], [customerid], [orderdate], [requireddate], [vat], [freight], [shipname], [shipaddress], [shipcity], [shippostalcode], [shipcountry], [totalamount], [hide]) VALUES (1013, NULL, 4, CAST(0x0000A10500000000 AS DateTime), CAST(0x0000A10D00000000 AS DateTime), 10, 10000.0000, N'nguyen tan duy', N'nguyen tan duy', N'tphcm', N'7000', N'vietnam', NULL, 0) INSERT [dbo].[orders] ([orderid], [employeeid], [customerid], [orderdate], [requireddate], [vat], [freight], [shipname], [shipaddress], [shipcity], [shippostalcode], [shipcountry], [totalamount], [hide]) VALUES (1014, NULL, 4, CAST(0x0000A10500000000 AS DateTime), CAST(0x0000A10B00000000 AS DateTime), 10, 10000.0000, N'nguyen van a', N'nguyen van a', N'tphcm', N'7000', N'vietnam', NULL, 0) INSERT [dbo].[orders] ([orderid], [employeeid], [customerid], [orderdate], [requireddate], [vat], [freight], [shipname], [shipaddress], [shipcity], [shippostalcode], [shipcountry], [totalamount], [hide]) VALUES (1015, NULL, 4, CAST(0x0000A10500000000 AS DateTime), CAST(0x0000A10700000000 AS DateTime), 10, 10000.0000, N'nguyen van teo', N'nguyen van teo', N'tphcm', N'7000', N'vietnam', 45010010.0000, 0) INSERT [dbo].[orders] ([orderid], [employeeid], [customerid], [orderdate], [requireddate], [vat], [freight], [shipname], [shipaddress], [shipcity], [shippostalcode], [shipcountry], [totalamount], [hide]) VALUES (1016, NULL, 4, CAST(0x0000A10500000000 AS DateTime), CAST(0x0000A10800000000 AS DateTime), 10, 10000.0000, N'nguyen van b', N'nguyen van b', N'tphcm', N'7000', N'vietnam', 22120000.0000, 0) INSERT [dbo].[orders] ([orderid], [employeeid], [customerid], [orderdate], [requireddate], [vat], [freight], [shipname], [shipaddress], [shipcity], [shippostalcode], [shipcountry], [totalamount], [hide]) VALUES (1017, NULL, 4, CAST(0x0000A10500000000 AS DateTime), CAST(0x0000A11200000000 AS DateTime), 10, 10000.0000, N'nguyen van teo', N'nguyen van teo', N'tphcm', N'7000', N'vietnam', 112210000.0000, 0) SET IDENTITY_INSERT [dbo].[orders] OFF INSERT [dbo].[origins] ([originid], [countryname], [status]) VALUES (N'US ', N'Hoa Kỳ', 1) INSERT [dbo].[origins] ([originid], [countryname], [status]) VALUES (N'VN ', N'Việt Nam', 1) INSERT [dbo].[origins] ([originid], [countryname], [status]) VALUES (N'JP ', N'Nhật Bản', 1) INSERT [dbo].[payments] ([paymentid], [paymentname], [status]) VALUES (N'1 ', N'Thanh toán qua ngân hàng', 1) INSERT [dbo].[payments] ([paymentid], [paymentname], [status]) VALUES (N'2 ', N'Thanh toán bằng tiền mặt', 1) INSERT [dbo].[payments] ([paymentid], [paymentname], [status]) VALUES (N'3 ', N'Thanh toán trả sau', 1) SET IDENTITY_INSERT [dbo].[positions] ON INSERT [dbo].[positions] ([positionid], [positionname], [description], [status]) VALUES (1, N'Tổng điều hành', N'Nhân viên có quyền cao nhất quản trị toàn bộ hệ thống website DigitalWorld', 1) INSERT [dbo].[positions] ([positionid], [positionname], [description], [status]) VALUES (2, N'Quản Lý', N'Nhân viên điều hành website cao cấp ', 1) INSERT [dbo].[positions] ([positionid], [positionname], [description], [status]) VALUES (3, N'Nhân Viên', N'Nhân viên quản lý sản phẩm, đơn đặt hàng, tư vấn khách hàng', 1) INSERT [dbo].[positions] ([positionid], [positionname], [description], [status]) VALUES (5, N'Nhân Viên Thời Vụ', N'nhân viên nhận tạm thời', 1) SET IDENTITY_INSERT [dbo].[positions] OFF SET IDENTITY_INSERT [dbo].[products] ON INSERT [dbo].[products] ([productid], [categoryid], [originid], [supplierid], [productname], [description], [photopath], [dateupdated], [unitprice], [unitprice_sell], [unitsinstock], [unitsonorder], [discount], [manufacturername], [technologycpu], [typecpu], [speedcpu], [otherinfocpu], [storageram], [busspeed], [diskspace], [rotationalspeed], [touchscreen], [sizemh], [graphicschipset], [graphicsspace], [otherinfographics], [opticaldiscs], [interface], [extendedfeatures], [wifistandard], [wirelessconnection], [webcam], [batteryinformation], [usetime], [os], [otherinfoos], [camera], [movie], [music], [fmradio], [record], [otherapplication], [ringtones], [headphone], [memory], [sdcardsupport], [contacts], [mobilenetwork], [gprs], [network3g], [gps], [bluetooth], [usb], [typescreen], [resolution], [sizephone], [keyboardqwerty], [weight], [language], [talktime], [waittime], [otherinfophone], [discontinued]) VALUES (19, N'LT', N'US ', 4, N'Laptop Asus K45VM 7364G75G', N'CPU: Intel Core i7 2630QM, 2.0 GHz Bộ nhớ: DDR3 8GB. Đĩa cứng: 2TB HDD Màn hình: 17.3" HD HD (1920x1080) Đồ họa: AMD Radeon™ HD 6850M, 1GB Đĩa quang: Blu-ray DVD Super Multi Double Player Hệ điều hành:Windows® 7 Home Premium 64Bit. Trọng lượng: 3.55kg ', N'Digital_World_Laptop_ASUS_5_Laptop Asus K45VM 7364G75G.jpg', CAST(0x0000A10100000000 AS DateTime), 1200000.0000, 14495000.0000, 35, 0, 0, N'Intel', N'Core i5', N'2630QM', N'2.10 GHz', N'Bộ nhớ đệm - 3 MB L3 Tốc độ tối đa - Turbo Boost 3.1GHz Cores / Threads - 2C / 4T Intel HD Graphics - Có Tần số đồ họa cơ bản - 650 MHz Tần số đồ họa tối đa - 1.3 GHz', N'4 GB', N'1333 MHz', N'1 TB', N'5400 rpm', N'Không', 14, N'AMD Radeon HD 6850M', N'1 GB', N'Card rời', N'Bluray DVD', N'HDMI,USB3.0,USB2.0', N'Switchable, CoolSense', N'802.11b/g/n', N'Bluetooth', N'1 MP', N'Lithium-ion 6 cell', N'3 giờ', N'Ubuntu', N'Hỗ trợ các dòng win', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1) INSERT [dbo].[products] ([productid], [categoryid], [originid], [supplierid], [productname], [description], [photopath], [dateupdated], [unitprice], [unitprice_sell], [unitsinstock], [unitsonorder], [discount], [manufacturername], [technologycpu], [typecpu], [speedcpu], [otherinfocpu], [storageram], [busspeed], [diskspace], [rotationalspeed], [touchscreen], [sizemh], [graphicschipset], [graphicsspace], [otherinfographics], [opticaldiscs], [interface], [extendedfeatures], [wifistandard], [wirelessconnection], [webcam], [batteryinformation], [usetime], [os], [otherinfoos], [camera], [movie], [music], [fmradio], [record], [otherapplication], [ringtones], [headphone], [memory], [sdcardsupport], [contacts], [mobilenetwork], [gprs], [network3g], [gps], [bluetooth], [usb], [typescreen], [resolution], [sizephone], [keyboardqwerty], [weight], [language], [talktime], [waittime], [otherinfophone], [discontinued]) VALUES (18, N'LT', N'US ', 3, N'Laptop HP Envy 17 2100TX 2638G2TG', N'<div> CPU: Intel Core i7 2630QM, 2.0 GHz</div> <div> Bộ nhớ: DDR3 8GB. Đĩa cứng: 2TB HDD</div> <div> Màn hình: 17.3" HD HD (1920x1080)</div> <div> Đồ họa: AMD Radeon™ HD 6850M, 1GB</div> <div> Đĩa quang: Blu-ray DVD Super Multi Double Player</div> <div> Hệ điều hành:Windows® 7 Home Premium 64Bit. Trọng lượng: 3.55kg</div> ', N'Digital_World_Laptop_HP_1_Laptop HP Envy 17 2100TX 2638G2TG.jpg', CAST(0x0000A0FB00000000 AS DateTime), 40200000.0000, 44599000.0000, 0, 0, 0, N'Intel', N'Core i7', N'3720QM', N'2.60GHz', N'Bộ nhớ đệm - 3 MB L3 Tốc độ tối đa - Turbo Boost 3.1GHz Cores / Threads - 2C / 4T Intel HD Graphics - Có Tần số đồ họa cơ bản - 650 MHz Tần số đồ họa tối đa - 1.3 GHz', N'8 GB', N'1600 MHz', N'2 TB', N'5400 rpm', N'Không', 17, N'AMD Radeon HD 7670M', N'1 GB', N'Card rời', N'Bluray Combo', N'HDMI,USB3.0,USB2.0', N'Optimus', N'802.11b/g/n', N'Bluetooth', N'1 MP', N'Lithium-ion 6 cell', N'3 giờ', N'Windows 7 Home 64bit', N'Hỗ trợ các dòng win', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1) INSERT [dbo].[products] ([productid], [categoryid], [originid], [supplierid], [productname], [description], [photopath], [dateupdated], [unitprice], [unitprice_sell], [unitsinstock], [unitsonorder], [discount], [manufacturername], [technologycpu], [typecpu], [speedcpu], [otherinfocpu], [storageram], [busspeed], [diskspace], [rotationalspeed], [touchscreen], [sizemh], [graphicschipset], [graphicsspace], [otherinfographics], [opticaldiscs], [interface], [extendedfeatures], [wifistandard], [wirelessconnection], [webcam], [batteryinformation], [usetime], [os], [otherinfoos], [camera], [movie], [music], [fmradio], [record], [otherapplication], [ringtones], [headphone], [memory], [sdcardsupport], [contacts], [mobilenetwork], [gprs], [network3g], [gps], [bluetooth], [usb], [typescreen], [resolution], [sizephone], [keyboardqwerty], [weight], [language], [talktime], [waittime], [otherinfophone], [discontinued]) VALUES (20, N'LT', N'US ', 4, N'Laptop Asus K45VM 7334G75G', N'CPU: Intel Core i7 2630QM, 2.0 GHz Bộ nhớ: DDR3 8GB. Đĩa cứng: 2TB HDD Màn hình: 17.3" HD HD (1920x1080) Đồ họa: AMD Radeon™ HD 6850M, 1GB Đĩa quang: Blu-ray DVD Super Multi Double Player Hệ điều hành:Windows® 7 Home Premium 64Bit. Trọng lượng: 3.55kg', N'Digital_World_Laptop_ASUS_5_Laptop Asus K45VM 7334G75G.jpg', CAST(0x0000A10100000000 AS DateTime), 11000000.0000, 13599000.0000, 45, 0, 0, N'Intel', N'Core i5', N'3630QM', N'1.60 GHz', N'Bộ nhớ đệm - 3 MB L3 Tốc độ tối đa - Turbo Boost 3.1GHz Cores / Threads - 2C / 4T Intel HD Graphics - Có Tần số đồ họa cơ bản - 650 MHz Tần số đồ họa tối đa - 1.3 GHz', N'4 GB', N'1333 MHz', N'640 GB', N'5400 rpm', N'Không', 15, N'AMD Radeon HD 6850M', N'1 GB', N'Card rời', N'DVD Super Multi ', N'Thunderbolt,2xUSB3.0', N'Ice Cool, Optimus', N'802.11b/g/n', N'Bluetooth', N'1 MP', N'Lithium-ion 6 cell', N'3 giờ', N'Free Dos', N'Hỗ trợ các dòng win', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1) INSERT [dbo].[products] ([productid], [categoryid], [originid], [supplierid], [productname], [description], [photopath], [dateupdated], [unitprice], [unitprice_sell], [unitsinstock], [unitsonorder], [discount], [manufacturername], [technologycpu], [typecpu], [speedcpu], [otherinfocpu], [storageram], [busspeed], [diskspace], [rotationalspeed], [touchscreen], [sizemh], [graphicschipset], [graphicsspace], [otherinfographics], [opticaldiscs], [interface], [extendedfeatures], [wifistandard], [wirelessconnection], [webcam], [batteryinformation], [usetime], [os], [otherinfoos], [camera], [movie], [music], [fmradio], [record], [otherapplication], [ringtones], [headphone], [memory], [sdcardsupport], [contacts], [mobilenetwork], [gprs], [network3g], [gps], [bluetooth], [usb], [typescreen], [resolution], [sizephone], [keyboardqwerty], [weight], [language], [talktime], [waittime], [otherinfophone], [discontinued]) VALUES (21, N'LT', N'US ', 5, N'Laptop Dell Inspiron 5520 3618G1TG', N'CPU: Intel Core i7 2630QM, 2.0 GHz Bộ nhớ: DDR3 8GB. Đĩa cứng: 2TB HDD Màn hình: 17.3" HD HD (1920x1080) Đồ họa: AMD Radeon™ HD 6850M, 1GB Đĩa quang: Blu-ray DVD Super Multi Double Player Hệ điều hành:Windows® 7 Home Premium 64Bit. Trọng lượng: 3.55kg ', N'Digital_World_Laptop_Dell_11_Laptop Dell Inspiron 5520 3618G1TG.jpg', CAST(0x0000A10100000000 AS DateTime), 13500000.0000, 15000000.0000, 45, 0, 0, N'Intel', N'Core i7', N'3720QM', N'2.60GHz', N' Bộ nhớ đệm - 3 MB L3 Tốc độ tối đa - Turbo Boost 3.1GHz Cores / Threads - 2C / 4T Intel HD Graphics - Có Tần số đồ họa cơ bản - 650 MHz Tần số đồ họa tối đa - 1.3 GHz ', N'8 GB', N'1600 MHz', N'512 GB', N'5400 rpm', N'Không', 13, N'AMD Radeon HD 7670M', N'1 GB', N'Card rời', N'Bluray DVD', N'VGA,USB3.0,HDMI', N'CoolSense', N'802.11b/g/n', N'Bluetooth', N'0.3 MP', N'Lithium-ion 6 cell', N'4 giờ', N'Free Dos', N'Hỗ trợ các dòng win', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1) INSERT [dbo].[products] ([productid], [categoryid], [originid], [supplierid], [productname], [description], [photopath], [dateupdated], [unitprice], [unitprice_sell], [unitsinstock], [unitsonorder], [discount], [manufacturername], [technologycpu], [typecpu], [speedcpu], [otherinfocpu], [storageram], [busspeed], [diskspace], [rotationalspeed], [touchscreen], [sizemh], [graphicschipset], [graphicsspace], [otherinfographics], [opticaldiscs], [interface], [extendedfeatures], [wifistandard], [wirelessconnection], [webcam], [batteryinformation], [usetime], [os], [otherinfoos], [camera], [movie], [music], [fmradio], [record], [otherapplication], [ringtones], [headphone], [memory], [sdcardsupport], [contacts], [mobilenetwork], [gprs], [network3g], [gps], [bluetooth], [usb], [typescreen], [resolution], [sizephone], [keyboardqwerty], [weight], [language], [talktime], [waittime], [otherinfophone], [discontinued]) VALUES (22, N'MP', N'US ', 2, N'ĐTDĐ SAMSUNG Note II N_7100', N'   <div class="pro_nd_more" style="color: rgb(51, 51, 51); font-family: Arial, Helvetica, sans-serif; background-color: rgb(232, 232, 232); "> Nhà sản xuất: SAMSUNG Thời gian bảo hành : 12 tháng</div> <div>  </div> ', N'Digital_World_MobilePhone_SamSung_4_ĐTDĐ SAMSUNG Note II N_7100.jpg', CAST(0x0000A0FB00000000 AS DateTime), 14000000.0000, 15790000.0000, 2, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'thông tin pin', N'thời gian sử dụng', N'hđh', NULL, N'Máy ảnh', N'xem phim', N'nghe nhạc', N'radio', N'ghi âm', N' ứng dụng khác ', N'nhạc chuông', N'tai nghe', N'bộ nhớ tro', N'hộ trợ thẻ nhớ', N'danh bạ', N'mạng di dộng', N'GPS', N'mạng 3g', NULL, N'bluetooth', N'USB', N'màn hình', N'độ phân giải', N'kích thước', N'bàn phímảo', N'trọng lợng', N'ngôn ngữ', N'đàm thoại', N'chờ', N' thôn tin khác a ', 1) INSERT [dbo].[products] ([productid], [categoryid], [originid], [supplierid], [productname], [description], [photopath], [dateupdated], [unitprice], [unitprice_sell], [unitsinstock], [unitsonorder], [discount], [manufacturername], [technologycpu], [typecpu], [speedcpu], [otherinfocpu], [storageram], [busspeed], [diskspace], [rotationalspeed], [touchscreen], [sizemh], [graphicschipset], [graphicsspace], [otherinfographics], [opticaldiscs], [interface], [extendedfeatures], [wifistandard], [wirelessconnection], [webcam], [batteryinformation], [usetime], [os], [otherinfoos], [camera], [movie], [music], [fmradio], [record], [otherapplication], [ringtones], [headphone], [memory], [sdcardsupport], [contacts], [mobilenetwork], [gprs], [network3g], [gps], [bluetooth], [usb], [typescreen], [resolution], [sizephone], [keyboardqwerty], [weight], [language], [talktime], [waittime], [otherinfophone], [discontinued]) VALUES (23, N'LT', N'US ', 1, N'Laptop Apple MacBook Pro MC976 15inch Re', N'CPU: Intel Core i7 2630QM, 2.0 GHz Bộ nhớ: DDR3 8GB. Đĩa cứng: 2TB HDD Màn hình: 17.3" HD HD (1920x1080) Đồ họa: AMD Radeon™ HD 6850M, 1GB Đĩa quang: Blu-ray DVD Super Multi Double Player Hệ điều hành:Windows® 7 Home Premium 64Bit. Trọng lượng: 3.55kg', N'Digital_World_Laptop_Apple_5_Laptop Apple MacBook Pro MC976 15inch Re.jpg', CAST(0x0000A10100000000 AS DateTime), 63000000.0000, 65399000.0000, 35, 0, 0, N'Intel', N'Core i5', N'3630QM', N'2.00 GHz', N'Bộ nhớ đệm - 3 MB L3 Tốc độ tối đa - Turbo Boost 3.1GHz Cores / Threads - 2C / 4T Intel HD Graphics - Có Tần số đồ họa cơ bản - 650 MHz Tần số đồ họa tối đa - 1.3 GHz', N'4 GB', N'1333 MHz', N'500 GB', N'5400 rpm', N'Không', 13, N'AMD Radeon HD 7670M', N'1 GB', N'Card rời', N'Bluray Combo', N'HDMI,USB3.0,VGA', N'CoolSense', N'802.11b/g/n', N'Bluetooth', N'1 MP', N'Lithium-ion 6 cell', N'4 giờ', N'Mac OS X', N'Hỗ trợ các dòng win', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1) INSERT [dbo].[products] ([productid], [categoryid], [originid], [supplierid], [productname], [description], [photopath], [dateupdated], [unitprice], [unitprice_sell], [unitsinstock], [unitsonorder], [discount], [manufacturername], [technologycpu], [typecpu], [speedcpu], [otherinfocpu], [storageram], [busspeed], [diskspace], [rotationalspeed], [touchscreen], [sizemh], [graphicschipset], [graphicsspace], [otherinfographics], [opticaldiscs], [interface], [extendedfeatures], [wifistandard], [wirelessconnection], [webcam], [batteryinformation], [usetime], [os], [otherinfoos], [camera], [movie], [music], [fmradio], [record], [otherapplication], [ringtones], [headphone], [memory], [sdcardsupport], [contacts], [mobilenetwork], [gprs], [network3g], [gps], [bluetooth], [usb], [typescreen], [resolution], [sizephone], [keyboardqwerty], [weight], [language], [talktime], [waittime], [otherinfophone], [discontinued]) VALUES (24, N'LT', N'US ', 1, N'Laptop Apple MacBook Pro MC976 12inch Re', N'CPU: Intel Core i7 2630QM, 2.0 GHz Bộ nhớ: DDR3 8GB. Đĩa cứng: 2TB HDD Màn hình: 17.3" HD HD (1920x1080) Đồ họa: AMD Radeon™ HD 6850M, 1GB Đĩa quang: Blu-ray DVD Super Multi Double Player Hệ điều hành:Windows® 7 Home Premium 64Bit. Trọng lượng: 3.55kg ', N'Digital_World_Laptop_Apple_6_Laptop Apple MacBook Pro MC976 12inch Re.jpg', CAST(0x0000A10100000000 AS DateTime), 40200000.0000, 44599000.0000, 35, 0, 0, N'Intel', N'Core i7', N'3612QM', N'2.10 GHz', N'Bộ nhớ đệm - 3 MB L3 Tốc độ tối đa - Turbo Boost 3.1GHz Cores / Threads - 2C / 4T Intel HD Graphics - Có Tần số đồ họa cơ bản - 650 MHz Tần số đồ họa tối đa - 1.3 GHz', N'4 GB', N'1333 MHz', N'750 GB', N'5400 rpm', N'Không', 15, N'AMD Radeon HD 6750M', N'1 GB', N'Card rời', N'Không', N'Mini VGA,USB3.0,HDMI', N'Switchable, CoolSense', N'802.11b/g/n', N'Bluetooth', N'1 MP', N'Lithium-ion 6 cell', N'5 giờ', N'Mac OS X', N'Hỗ trợ các dòng win', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1) INSERT [dbo].[products] ([productid], [categoryid], [originid], [supplierid], [productname], [description], [photopath], [dateupdated], [unitprice], [unitprice_sell], [unitsinstock], [unitsonorder], [discount], [manufacturername], [technologycpu], [typecpu], [speedcpu], [otherinfocpu], [storageram], [busspeed], [diskspace], [rotationalspeed], [touchscreen], [sizemh], [graphicschipset], [graphicsspace], [otherinfographics], [opticaldiscs], [interface], [extendedfeatures], [wifistandard], [wirelessconnection], [webcam], [batteryinformation], [usetime], [os], [otherinfoos], [camera], [movie], [music], [fmradio], [record], [otherapplication], [ringtones], [headphone], [memory], [sdcardsupport], [contacts], [mobilenetwork], [gprs], [network3g], [gps], [bluetooth], [usb], [typescreen], [resolution], [sizephone], [keyboardqwerty], [weight], [language], [talktime], [waittime], [otherinfophone], [discontinued]) VALUES (25, N'LT', N'US ', 1, N'Laptop Apple MacBook Pro MC976 13inch', N'CPU: Intel Core i7 2630QM, 2.0 GHz Bộ nhớ: DDR3 8GB. Đĩa cứng: 2TB HDD Màn hình: 17.3" HD HD (1920x1080) Đồ họa: AMD Radeon™ HD 6850M, 1GB Đĩa quang: Blu-ray DVD Super Multi Double Player Hệ điều hành:Windows® 7 Home Premium 64Bit. Trọng lượng: 3.55kg', N'Digital_World_Laptop_Apple_7_Laptop Apple MacBook Pro MC976 13inch.jpg', CAST(0x0000A10100000000 AS DateTime), 25100000.0000, 28199000.0000, 20, 0, 0, N'Intel', N'Core i7', N'3630QM', N'2.40 GHz', N'Bộ nhớ đệm - 3 MB L3 Tốc độ tối đa - Turbo Boost 3.1GHz Cores / Threads - 2C / 4T Intel HD Graphics - Có Tần số đồ họa cơ bản - 650 MHz Tần số đồ họa tối đa - 1.3 GHz', N'8 GB', N'1600 MHz', N'1 TB', N'5400 rpm', N'Không', 15, N'AMD Radeon HD 7670M', N'1 GB', N'Card rời', N'DVD Super Multi ', N'VGA,USB3.0,HDMI', N'Switchable', N'802.11b/g/n', N'Bluetooth', N'1 MP', N'Lithium-ion 6 cell', N'5 giờ', N'Mac OS X', N'Hỗ trợ các dòng win', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1) INSERT [dbo].[products] ([productid], [categoryid], [originid], [supplierid], [productname], [description], [photopath], [dateupdated], [unitprice], [unitprice_sell], [unitsinstock], [unitsonorder], [discount], [manufacturername], [technologycpu], [typecpu], [speedcpu], [otherinfocpu], [storageram], [busspeed], [diskspace], [rotationalspeed], [touchscreen], [sizemh], [graphicschipset], [graphicsspace], [otherinfographics], [opticaldiscs], [interface], [extendedfeatures], [wifistandard], [wirelessconnection], [webcam], [batteryinformation], [usetime], [os], [otherinfoos], [camera], [movie], [music], [fmradio], [record], [otherapplication], [ringtones], [headphone], [memory], [sdcardsupport], [contacts], [mobilenetwork], [gprs], [network3g], [gps], [bluetooth], [usb], [typescreen], [resolution], [sizephone], [keyboardqwerty], [weight], [language], [talktime], [waittime], [otherinfophone], [discontinued]) VALUES (26, N'LT', N'US ', 1, N'Laptop Apple MacBook MC973 13inch Re', N'CPU: Intel Core i7 2630QM, 2.0 GHz Bộ nhớ: DDR3 8GB. Đĩa cứng: 2TB HDD Màn hình: 17.3" HD HD (1920x1080) Đồ họa: AMD Radeon™ HD 6850M, 1GB Đĩa quang: Blu-ray DVD Super Multi Double Player Hệ điều hành:Windows® 7 Home Premium 64Bit. Trọng lượng: 3.55kg', N'Digital_World_Laptop_Apple_8_Laptop Apple MacBook MC973 13inch Re.jpg', CAST(0x0000A10100000000 AS DateTime), 20400000.0000, 24199000.0000, 23, 0, 0, N'Intel', N'Core i7', N'3630QM', N'2.60GHz', N'Bộ nhớ đệm - 3 MB L3 Tốc độ tối đa - Turbo Boost 3.1GHz Cores / Threads - 2C / 4T Intel HD Graphics - Có Tần số đồ họa cơ bản - 650 MHz Tần số đồ họa tối đa - 1.3 GHz', N'8 GB', N'1600 MHz', N'2 TB', N'5400 rpm', N'Không', 17, N'NVIDIA GeForce GT 630M', N'2 GB', N'Card rời', N'Bluray DVD', N'HDMI,USB3.0,VGA', N'Ice Cool, Optimus', N'802.11b/g/n', N'Bluetooth', N'1.3 MP', N'Lithium-ion 6 cell', N'5 giờ', N'Mac OS X', N'Hỗ trợ các dòng win', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1) INSERT [dbo].[products] ([productid], [categoryid], [originid], [supplierid], [productname], [description], [photopath], [dateupdated], [unitprice], [unitprice_sell], [unitsinstock], [unitsonorder], [discount], [manufacturername], [technologycpu], [typecpu], [speedcpu], [otherinfocpu], [storageram], [busspeed], [diskspace], [rotationalspeed], [touchscreen], [sizemh], [graphicschipset], [graphicsspace], [otherinfographics], [opticaldiscs], [interface], [extendedfeatures], [wifistandard], [wirelessconnection], [webcam], [batteryinformation], [usetime], [os], [otherinfoos], [camera], [movie], [music], [fmradio], [record], [otherapplication], [ringtones], [headphone], [memory], [sdcardsupport], [contacts], [mobilenetwork], [gprs], [network3g], [gps], [bluetooth], [usb], [typescreen], [resolution], [sizephone], [keyboardqwerty], [weight], [language], [talktime], [waittime], [otherinfophone], [discontinued]) VALUES (27, N'LT', N'US ', 3, N'Laptop Hp Pavilion DV4 3129TX 2434G64GWH', N'CPU: Intel Core i7 2630QM, 2.0 GHz Bộ nhớ: DDR3 8GB. Đĩa cứng: 2TB HDD Màn hình: 17.3" HD HD (1920x1080) Đồ họa: AMD Radeon™ HD 6850M, 1GB Đĩa quang: Blu-ray DVD Super Multi Double Player Hệ điều hành:Windows® 7 Home Premium 64Bit. Trọng lượng: 3.55kg', N'Digital_World_Laptop_HP_9_Laptop Hp Pavilion DV4 3129TX 2434G64GWH.jpg', CAST(0x0000A10100000000 AS DateTime), 20400000.0000, 24199000.0000, 35, 0, 0, N'Intel', N'Core i7', N'3612QM', N'2.60GHz', N'Bộ nhớ đệm - 3 MB L3 Tốc độ tối đa - Turbo Boost 3.1GHz Cores / Threads - 2C / 4T Intel HD Graphics - Có Tần số đồ họa cơ bản - 650 MHz Tần số đồ họa tối đa - 1.3 GHz', N'8 GB', N'1600 MHz', N'2 TB', N'5400 rpm', N'Không', 17, N'NVIDIA GeForce GT 630M', N'2 GB', N'Card rời', N'Bluray Combo', N'VGA,USB3.0,HDMI', N'Switchable, CoolSense', N'802.11b/g/n', N'Bluetooth', N'1.3 MP', N'Lithium-ion 6 cell', N'3 giờ', N'Windows 7 Home 64bit', N'Hỗ trợ các dòng win', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1) INSERT [dbo].[products] ([productid], [categoryid], [originid], [supplierid], [productname], [description], [photopath], [dateupdated], [unitprice], [unitprice_sell], [unitsinstock], [unitsonorder], [discount], [manufacturername], [technologycpu], [typecpu], [speedcpu], [otherinfocpu], [storageram], [busspeed], [diskspace], [rotationalspeed], [touchscreen], [sizemh], [graphicschipset], [graphicsspace], [otherinfographics], [opticaldiscs], [interface], [extendedfeatures], [wifistandard], [wirelessconnection], [webcam], [batteryinformation], [usetime], [os], [otherinfoos], [camera], [movie], [music], [fmradio], [record], [otherapplication], [ringtones], [headphone], [memory], [sdcardsupport], [contacts], [mobilenetwork], [gprs], [network3g], [gps], [bluetooth], [usb], [typescreen], [resolution], [sizephone], [keyboardqwerty], [weight], [language], [talktime], [waittime], [otherinfophone], [discontinued]) VALUES (28, N'LT', N'US ', 1, N'Laptop Hp Pavilion DV4 3122TX 2437G64GWH', N'CPU: Intel Core i7 2630QM, 2.0 GHz Bộ nhớ: DDR3 8GB. Đĩa cứng: 2TB HDD Màn hình: 17.3" HD HD (1920x1080) Đồ họa: AMD Radeon™ HD 6850M, 1GB Đĩa quang: Blu-ray DVD Super Multi Double Player Hệ điều hành:Windows® 7 Home Premium 64Bit. Trọng lượng: 3.55kg', N'Digital_World_Laptop_Apple_10_Laptop Hp Pavilion DV4 3122TX 2437G64GWH.jpg', CAST(0x0000A10100000000 AS DateTime), 20100000.0000, 23099000.0000, 20, 0, 0, N'Intel', N'Core i5', N'3720QM', N'2.40 GHz', N'Bộ nhớ đệm - 3 MB L3 Tốc độ tối đa - Turbo Boost 3.1GHz Cores / Threads - 2C / 4T Intel HD Graphics - Có Tần số đồ họa cơ bản - 650 MHz Tần số đồ họa tối đa - 1.3 GHz', N'4 GB', N'1600 MHz', N'1 TB', N'5400 rpm', N'Không', 14, N'AMD Radeon HD 6750M', N'1 GB', N'Card rời', N'Bluray DVD', N'Thunderbolt,2xUSB3.0', N'Ice Cool, Optimus', N'802.11b/g/n', N'Bluetooth', N'1.3 MP', N'Lithium-ion 6 cell', N'5 giờ', N'Free Dos', N'Hỗ trợ các dòng win', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1) INSERT [dbo].[products] ([productid], [categoryid], [originid], [supplierid], [productname], [description], [photopath], [dateupdated], [unitprice], [unitprice_sell], [unitsinstock], [unitsonorder], [discount], [manufacturername], [technologycpu], [typecpu], [speedcpu], [otherinfocpu], [storageram], [busspeed], [diskspace], [rotationalspeed], [touchscreen], [sizemh], [graphicschipset], [graphicsspace], [otherinfographics], [opticaldiscs], [interface], [extendedfeatures], [wifistandard], [wirelessconnection], [webcam], [batteryinformation], [usetime], [os], [otherinfoos], [camera], [movie], [music], [fmradio], [record], [otherapplication], [ringtones], [headphone], [memory], [sdcardsupport], [contacts], [mobilenetwork], [gprs], [network3g], [gps], [bluetooth], [usb], [typescreen], [resolution], [sizephone], [keyboardqwerty], [weight], [language], [talktime], [waittime], [otherinfophone], [discontinued]) VALUES (29, N'LT', N'US ', 4, N'Laptop Asus UX32VD 3314G50GWP', N'CPU: Intel Core i7 2630QM, 2.0 GHz Bộ nhớ: DDR3 8GB. Đĩa cứng: 2TB HDD Màn hình: 17.3" HD HD (1920x1080) Đồ họa: AMD Radeon™ HD 6850M, 1GB Đĩa quang: Blu-ray DVD Super Multi Double Player Hệ điều hành:Windows® 7 Home Premium 64Bit. Trọng lượng: 3.55kg', N'Digital_World_Laptop_ASUS_11_Laptop Asus UX32VD 3314G50GWP.jpg', CAST(0x0000A10100000000 AS DateTime), 20100000.0000, 23099000.0000, 35, 0, 0, N'Intel', N'Core i7', N'2630QM', N'2.00 GHz', N'Bộ nhớ đệm - 3 MB L3 Tốc độ tối đa - Turbo Boost 3.1GHz Cores / Threads - 2C / 4T Intel HD Graphics - Có Tần số đồ họa cơ bản - 650 MHz Tần số đồ họa tối đa - 1.3 GHz', N'8 GB', N'1600 MHz', N'512 GB', N'5400 rpm', N'Không', 15, N'NVIDIA GeForce GT 650M', N'1 GB', N'Card rời', N'DVD Super Multimedia', N'HDMI,USB3.0,USB2.0', N'Optimus', N'802.11b/g/n', N'Bluetooth', N'1 MP', N'Lithium-ion 6 cell', N'3 giờ', N'Windows 7 Home 64bit', N'Hỗ trợ các dòng win', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1) INSERT [dbo].[products] ([productid], [categoryid], [originid], [supplierid], [productname], [description], [photopath], [dateupdated], [unitprice], [unitprice_sell], [unitsinstock], [unitsonorder], [discount], [manufacturername], [technologycpu], [typecpu], [speedcpu], [otherinfocpu], [storageram], [busspeed], [diskspace], [rotationalspeed], [touchscreen], [sizemh], [graphicschipset], [graphicsspace], [otherinfographics], [opticaldiscs], [interface], [extendedfeatures], [wifistandard], [wirelessconnection], [webcam], [batteryinformation], [usetime], [os], [otherinfoos], [camera], [movie], [music], [fmradio], [record], [otherapplication], [ringtones], [headphone], [memory], [sdcardsupport], [contacts], [mobilenetwork], [gprs], [network3g], [gps], [bluetooth], [usb], [typescreen], [resolution], [sizephone], [keyboardqwerty], [weight], [language], [talktime], [waittime], [otherinfophone], [discontinued]) VALUES (30, N'LT', N'US ', 2, N'Laptop Samsung 535U4X 44354G50', N'CPU: AMD Dual Core A4-4355M, 1.90 GHz Bộ nhớ: DDR3, 4GB (Onboard). Đĩa cứng: 500 GB Màn hình: 14 inch HD (1366 x 768 pixels) Đồ họa: AMD Radeon™ HD 7400G, Share 512 MB Đĩa quang: DVD Super Multi Double Layer Hệ điều hành: Free Dos. Trọng lượng: 1.52 kg ', N'Digital_World_Laptop_SamSung_12_Laptop Samsung 535U4X 44354G50.gif', CAST(0x0000A10100000000 AS DateTime), 10599000.0000, 12999000.0000, 35, 0, 0, N'AMD', N'Dual Core', N'A4-4355M', N'1.90 GHz', N'Bộ nhớ đệm - 1 MB, L2 Cache Tốc độ tối đa - Cores / Threads - 2C / 2T Intel HD Graphics - Tần số đồ họa cơ bản - Tần số đồ họa tối đa -', N'4 GB', N'1333 MHz', N'500 GB', N'5400 rpm', N'Không', 14, N'AMD Radeon™ HD 7400G', N'Share 512 MB', N'Tích hợp', N'DVD Super Multimedia', N'HDMI,USB3.0,USB2.0', N'Optimus', N'802.11b/g/n', N'Bluetooth', N'1 MP', N'Lithium-ion 6 cell', N'3 giờ', N'Free Dos', N'Hỗ trợ các dòng win', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1) INSERT [dbo].[products] ([productid], [categoryid], [originid], [supplierid], [productname], [description], [photopath], [dateupdated], [unitprice], [unitprice_sell], [unitsinstock], [unitsonorder], [discount], [manufacturername], [technologycpu], [typecpu], [speedcpu], [otherinfocpu], [storageram], [busspeed], [diskspace], [rotationalspeed], [touchscreen], [sizemh], [graphicschipset], [graphicsspace], [otherinfographics], [opticaldiscs], [interface], [extendedfeatures], [wifistandard], [wirelessconnection], [webcam], [batteryinformation], [usetime], [os], [otherinfoos], [camera], [movie], [music], [fmradio], [record], [otherapplication], [ringtones], [headphone], [memory], [sdcardsupport], [contacts], [mobilenetwork], [gprs], [network3g], [gps], [bluetooth], [usb], [typescreen], [resolution], [sizephone], [keyboardqwerty], [weight], [language], [talktime], [waittime], [otherinfophone], [discontinued]) VALUES (31, N'LT', N'US ', 3, N'Laptop HP Probook 4430s 2352G50 (LX015PA', N'CPU: Intel Core i7 2630QM, 2.0 GHz Bộ nhớ: DDR3 8GB. Đĩa cứng: 2TB HDD Màn hình: 17.3" HD HD (1920x1080) Đồ họa: AMD Radeon™ HD 6850M, 1GB Đĩa quang: Blu-ray DVD Super Multi Double Player Hệ điều hành:Windows® 7 Home Premium 64Bit. Trọng lượng: 3.55kg', N'Digital_World_Laptop_HP_13_Laptop HP Probook 4430s 2352G50 (LX015PA).jpg', CAST(0x0000A10100000000 AS DateTime), 10899000.0000, 12499000.0000, 35, 0, 0, N'Intel', N'Core i3', N'2350M', N'2.30 Ghz', N'Bộ nhớ đệm - 3 MB L3 Tốc độ tối đa - Turbo Boost 3.1GHz Cores / Threads - 2C / 4T Intel HD Graphics - Có Tần số đồ họa cơ bản - 650 MHz Tần số đồ họa tối đa - 1.3 GHz', N'2 GB', N'1333 MHz', N'500 GB', N'5400 rpm', N'Không', 14, N'Intel HD Graphics Family', N'Share 799 MB', N'Card rời', N'Bluray DVD', N'HDMI,USB3.0,VGA', N'Optimus', N'802.11b/g/n', N'Bluetooth', N'1 MP', N'Lithium-ion 6 cell', N'3 giờ', N'Windows 7 Home 64bit', N'Hỗ trợ các dòng win', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1) INSERT [dbo].[products] ([productid], [categoryid], [originid], [supplierid], [productname], [description], [photopath], [dateupdated], [unitprice], [unitprice_sell], [unitsinstock], [unitsonorder], [discount], [manufacturername], [technologycpu], [typecpu], [speedcpu], [otherinfocpu], [storageram], [busspeed], [diskspace], [rotationalspeed], [touchscreen], [sizemh], [graphicschipset], [graphicsspace], [otherinfographics], [opticaldiscs], [interface], [extendedfeatures], [wifistandard], [wirelessconnection], [webcam], [batteryinformation], [usetime], [os], [otherinfoos], [camera], [movie], [music], [fmradio], [record], [otherapplication], [ringtones], [headphone], [memory], [sdcardsupport], [contacts], [mobilenetwork], [gprs], [network3g], [gps], [bluetooth], [usb], [typescreen], [resolution], [sizephone], [keyboardqwerty], [weight], [language], [talktime], [waittime], [otherinfophone], [discontinued]) VALUES (32, N'LT', N'US ', 2, N'Laptop Samsung 530U3C 53314G', N' CPU: Intel Core i7 2630QM, 2.0 GHz Bộ nhớ: DDR3 8GB. Đĩa cứng: 2TB HDD Màn hình: 17.3" HD HD (1920x1080) Đồ họa: AMD Radeon™ HD 6850M, 1GB Đĩa quang: Blu-ray DVD Super Multi Double Player Hệ điều hành:Windows® 7 Home Premium 64Bit. Trọng lượng: 3.55kg ', N'Digital_World_Laptop_SamSung_16_Laptop Samsung 530U3C 53314G.gif', CAST(0x0000A10100000000 AS DateTime), 15800000.0000, 18999000.0000, 35, 0, 0, N'Intel', N'Core i5', N'3317U', N'1.70 GHz', N'Bộ nhớ đệm - 3 MB L3 Tốc độ tối đa - Turbo Boost 3.1GHz Cores / Threads - 2C / 4T Intel HD Graphics - Có Tần số đồ họa cơ bản - 650 MHz Tần số đồ họa tối đa - 1.3 GHz', N'4 GB', N'1600 MHz', N'500 GB', N'5400 rpm', N'Không', 13, N'NVIDIA GeForce GT 650M', N'1 GB', N'Card rời', N'Bluray DVD', N'HDMI,USB3.0,USB2.0', N'Optimus', N'802.11b/g/n', N'Bluetooth', N'1 MP', N'Lithium-ion 6 cell', N'4 giờ', N'Windows 7 Home 64bit', N'Hỗ trợ các dòng win', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1) INSERT [dbo].[products] ([productid], [categoryid], [originid], [supplierid], [productname], [description], [photopath], [dateupdated], [unitprice], [unitprice_sell], [unitsinstock], [unitsonorder], [discount], [manufacturername], [technologycpu], [typecpu], [speedcpu], [otherinfocpu], [storageram], [busspeed], [diskspace], [rotationalspeed], [touchscreen], [sizemh], [graphicschipset], [graphicsspace], [otherinfographics], [opticaldiscs], [interface], [extendedfeatures], [wifistandard], [wirelessconnection], [webcam], [batteryinformation], [usetime], [os], [otherinfoos], [camera], [movie], [music], [fmradio], [record], [otherapplication], [ringtones], [headphone], [memory], [sdcardsupport], [contacts], [mobilenetwork], [gprs], [network3g], [gps], [bluetooth], [usb], [typescreen], [resolution], [sizephone], [keyboardqwerty], [weight], [language], [talktime], [waittime], [otherinfophone], [discontinued]) VALUES (33, N'LT', N'US ', 2, N'Laptop Samsung 900X3C 73514G256W8P', N'CPU: Intel Core i7 2630QM, 2.0 GHz Bộ nhớ: DDR3 8GB. Đĩa cứng: 2TB HDD Màn hình: 17.3" HD HD (1920x1080) Đồ họa: AMD Radeon™ HD 6850M, 1GB Đĩa quang: Blu-ray DVD Super Multi Double Player Hệ điều hành:Windows® 7 Home Premium 64Bit. Trọng lượng: 3.55kg', N'Digital_World_Laptop_SamSung_15_Laptop Samsung 900X3C 73514G256W8P.gif', CAST(0x0000A10100000000 AS DateTime), 34000000.0000, 37599000.0000, 35, 0, 0, N'Intel', N'Core i7', N'3720QM', N'2.60GHz', N'Bộ nhớ đệm - 3 MB L3 Tốc độ tối đa - Turbo Boost 3.1GHz Cores / Threads - 2C / 4T Intel HD Graphics - Có Tần số đồ họa cơ bản - 650 MHz Tần số đồ họa tối đa - 1.3 GHz', N'4 GB', N'1333 MHz', N'256 GB', N'5400 rpm', N'Không', 13, N'AMD Radeon HD 6850M', N'1 GB', N'Card rời', N'Bluray DVD', N'HDMI,USB3.0,USB2.0', N'Optimus', N'802.11b/g/n', N'Bluetooth', N'1 MP', N'Lithium-ion 6 cell', N'3 giờ', N'Windows 7 Home 64bit', N'Hỗ trợ các dòng win', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1) INSERT [dbo].[products] ([productid], [categoryid], [originid], [supplierid], [productname], [description], [photopath], [dateupdated], [unitprice], [unitprice_sell], [unitsinstock], [unitsonorder], [discount], [manufacturername], [technologycpu], [typecpu], [speedcpu], [otherinfocpu], [storageram], [busspeed], [diskspace], [rotationalspeed], [touchscreen], [sizemh], [graphicschipset], [graphicsspace], [otherinfographics], [opticaldiscs], [interface], [extendedfeatures], [wifistandard], [wirelessconnection], [webcam], [batteryinformation], [usetime], [os], [otherinfoos], [camera], [movie], [music], [fmradio], [record], [otherapplication], [ringtones], [headphone], [memory], [sdcardsupport], [contacts], [mobilenetwork], [gprs], [network3g], [gps], [bluetooth], [usb], [typescreen], [resolution], [sizephone], [keyboardqwerty], [weight], [language], [talktime], [waittime], [otherinfophone], [discontinued]) VALUES (34, N'LT', N'US ', 2, N'Laptop Samsung 540U3C 73518G50W8', N'CPU: Intel Core i7 2630QM, 2.0 GHz Bộ nhớ: DDR3 8GB. Đĩa cứng: 2TB HDD Màn hình: 17.3" HD HD (1920x1080) Đồ họa: AMD Radeon™ HD 6850M, 1GB Đĩa quang: Blu-ray DVD Super Multi Double Player Hệ điều hành:Windows® 7 Home Premium 64Bit. Trọng lượng: 3.55kg', N'Digital_World_Laptop_SamSung_16_Laptop Samsung 540U3C 73518G50W8.gif', CAST(0x0000A10100000000 AS DateTime), 23000000.0000, 26499000.0000, 35, 0, 0, N'Intel', N'Core i7', N'3720QM', N'1.90 GHz', N'Bộ nhớ đệm - 3 MB L3 Tốc độ tối đa - Turbo Boost 3.1GHz Cores / Threads - 2C / 4T Intel HD Graphics - Có Tần số đồ họa cơ bản - 650 MHz Tần số đồ họa tối đa - 1.3 GHz', N'8 GB', N'1600 MHz', N'500 GB', N'5400 rpm', N'Không', 13, N'AMD Radeon HD 7670M', N'1 GB', N'Card rời', N'DVD Super Multi ', N'HDMI,USB3.0,VGA', N'Optimus', N'802.11b/g/n', N'Bluetooth', N'1 MP', N'Lithium-ion 6 cell', N'3 giờ', N'Free Dos', N'Hỗ trợ các dòng win', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1) INSERT [dbo].[products] ([productid], [categoryid], [originid], [supplierid], [productname], [description], [photopath], [dateupdated], [unitprice], [unitprice_sell], [unitsinstock], [unitsonorder], [discount], [manufacturername], [technologycpu], [typecpu], [speedcpu], [otherinfocpu], [storageram], [busspeed], [diskspace], [rotationalspeed], [touchscreen], [sizemh], [graphicschipset], [graphicsspace], [otherinfographics], [opticaldiscs], [interface], [extendedfeatures], [wifistandard], [wirelessconnection], [webcam], [batteryinformation], [usetime], [os], [otherinfoos], [camera], [movie], [music], [fmradio], [record], [otherapplication], [ringtones], [headphone], [memory], [sdcardsupport], [contacts], [mobilenetwork], [gprs], [network3g], [gps], [bluetooth], [usb], [typescreen], [resolution], [sizephone], [keyboardqwerty], [weight], [language], [talktime], [waittime], [otherinfophone], [discontinued]) VALUES (35, N'LT', N'US ', 6, N'Laptop Toshiba Satellite L850 53212G50', N'CPU: Intel Core i7 2630QM, 2.0 GHz Bộ nhớ: DDR3 8GB. Đĩa cứng: 2TB HDD Màn hình: 17.3" HD HD (1920x1080) Đồ họa: AMD Radeon™ HD 6850M, 1GB Đĩa quang: Blu-ray DVD Super Multi Double Player Hệ điều hành:Windows® 7 Home Premium 64Bit. Trọng lượng: 3.55kg', N'Digital_World_Laptop_Toshiba_17_Laptop Toshiba Satellite L850 53212G50.jpg', CAST(0x0000A10100000000 AS DateTime), 10799000.0000, 12799000.0000, 35, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1) INSERT [dbo].[products] ([productid], [categoryid], [originid], [supplierid], [productname], [description], [photopath], [dateupdated], [unitprice], [unitprice_sell], [unitsinstock], [unitsonorder], [discount], [manufacturername], [technologycpu], [typecpu], [speedcpu], [otherinfocpu], [storageram], [busspeed], [diskspace], [rotationalspeed], [touchscreen], [sizemh], [graphicschipset], [graphicsspace], [otherinfographics], [opticaldiscs], [interface], [extendedfeatures], [wifistandard], [wirelessconnection], [webcam], [batteryinformation], [usetime], [os], [otherinfoos], [camera], [movie], [music], [fmradio], [record], [otherapplication], [ringtones], [headphone], [memory], [sdcardsupport], [contacts], [mobilenetwork], [gprs], [network3g], [gps], [bluetooth], [usb], [typescreen], [resolution], [sizephone], [keyboardqwerty], [weight], [language], [talktime], [waittime], [otherinfophone], [discontinued]) VALUES (36, N'LT', N'US ', 6, N'Laptop Toshiba Satellite L840 32372G50G', N'CPU: Intel Core i7 2630QM, 2.0 GHz Bộ nhớ: DDR3 8GB. Đĩa cứng: 2TB HDD Màn hình: 17.3" HD HD (1920x1080) Đồ họa: AMD Radeon™ HD 6850M, 1GB Đĩa quang: Blu-ray DVD Super Multi Double Player Hệ điều hành:Windows® 7 Home Premium 64Bit. Trọng lượng: 3.55kg', N'Digital_World_Laptop_Toshiba_18_Laptop Toshiba Satellite L840 32372G50G.png', CAST(0x0000A10100000000 AS DateTime), 10199000.0000, 12499000.0000, 35, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1) INSERT [dbo].[products] ([productid], [categoryid], [originid], [supplierid], [productname], [description], [photopath], [dateupdated], [unitprice], [unitprice_sell], [unitsinstock], [unitsonorder], [discount], [manufacturername], [technologycpu], [typecpu], [speedcpu], [otherinfocpu], [storageram], [busspeed], [diskspace], [rotationalspeed], [touchscreen], [sizemh], [graphicschipset], [graphicsspace], [otherinfographics], [opticaldiscs], [interface], [extendedfeatures], [wifistandard], [wirelessconnection], [webcam], [batteryinformation], [usetime], [os], [otherinfoos], [camera], [movie], [music], [fmradio], [record], [otherapplication], [ringtones], [headphone], [memory], [sdcardsupport], [contacts], [mobilenetwork], [gprs], [network3g], [gps], [bluetooth], [usb], [typescreen], [resolution], [sizephone], [keyboardqwerty], [weight], [language], [talktime], [waittime], [otherinfophone], [discontinued]) VALUES (37, N'LT', N'US ', 6, N'Laptop Toshiba Satellite L755 2332G50G', N'CPU: Intel Core i7 2630QM, 2.0 GHz Bộ nhớ: DDR3 8GB. Đĩa cứng: 2TB HDD Màn hình: 17.3" HD HD (1920x1080) Đồ họa: AMD Radeon™ HD 6850M, 1GB Đĩa quang: Blu-ray DVD Super Multi Double Player Hệ điều hành:Windows® 7 Home Premium 64Bit. Trọng lượng: 3.55kg', N'Digital_World_Laptop_Toshiba_19_Laptop Toshiba Satellite L755 2332G50G.png', CAST(0x0000A10100000000 AS DateTime), 9199000.0000, 11999000.0000, 35, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1) INSERT [dbo].[products] ([productid], [categoryid], [originid], [supplierid], [productname], [description], [photopath], [dateupdated], [unitprice], [unitprice_sell], [unitsinstock], [unitsonorder], [discount], [manufacturername], [technologycpu], [typecpu], [speedcpu], [otherinfocpu], [storageram], [busspeed], [diskspace], [rotationalspeed], [touchscreen], [sizemh], [graphicschipset], [graphicsspace], [otherinfographics], [opticaldiscs], [interface], [extendedfeatures], [wifistandard], [wirelessconnection], [webcam], [batteryinformation], [usetime], [os], [otherinfoos], [camera], [movie], [music], [fmradio], [record], [otherapplication], [ringtones], [headphone], [memory], [sdcardsupport], [contacts], [mobilenetwork], [gprs], [network3g], [gps], [bluetooth], [usb], [typescreen], [resolution], [sizephone], [keyboardqwerty], [weight], [language], [talktime], [waittime], [otherinfophone], [discontinued]) VALUES (38, N'TL', N'US ', 1, N'Máy tính bảng iPad 3 wifi 4G 64GB', N'Màn hình 9.7 inch Cảm ứng Điện dung Màn hình Retina siêu nét độ phân giải cao hơn Full HD Khả năng quay film full HD và hình ảnh 3D. Được trang bị thêm cổng Thunderbolt Bộ nhớ trong 64GB Hệ điều hành iOS 5.1', N'Digital_World_Tablet_Apple_20_Máy tính bảng iPad 3 wifi 4G 64GB.jpg', CAST(0x0000A10100000000 AS DateTime), 16500000.0000, 19490000.0000, 35, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1) INSERT [dbo].[products] ([productid], [categoryid], [originid], [supplierid], [productname], [description], [photopath], [dateupdated], [unitprice], [unitprice_sell], [unitsinstock], [unitsonorder], [discount], [manufacturername], [technologycpu], [typecpu], [speedcpu], [otherinfocpu], [storageram], [busspeed], [diskspace], [rotationalspeed], [touchscreen], [sizemh], [graphicschipset], [graphicsspace], [otherinfographics], [opticaldiscs], [interface], [extendedfeatures], [wifistandard], [wirelessconnection], [webcam], [batteryinformation], [usetime], [os], [otherinfoos], [camera], [movie], [music], [fmradio], [record], [otherapplication], [ringtones], [headphone], [memory], [sdcardsupport], [contacts], [mobilenetwork], [gprs], [network3g], [gps], [bluetooth], [usb], [typescreen], [resolution], [sizephone], [keyboardqwerty], [weight], [language], [talktime], [waittime], [otherinfophone], [discontinued]) VALUES (39, N'TL', N'US ', 1, N'Máy tính bảng iPad 3 wifi 4G 32GB', N'Màn hình 9.7 inch Cảm ứng Điện dung Màn hình Retina siêu nét độ phân giải cao hơn Full HD Khả năng quay film full HD và hình ảnh 3D. Được trang bị thêm cổng Thunderbolt Bộ nhớ trong 32GB Hệ điều hành iOS 5.1 ', N'Digital_World_Tablet_Apple_21_Máy tính bảng iPad 3 wifi 4G 32GB.jpg', CAST(0x0000A10100000000 AS DateTime), 15000000.0000, 17490000.0000, 35, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1) INSERT [dbo].[products] ([productid], [categoryid], [originid], [supplierid], [productname], [description], [photopath], [dateupdated], [unitprice], [unitprice_sell], [unitsinstock], [unitsonorder], [discount], [manufacturername], [technologycpu], [typecpu], [speedcpu], [otherinfocpu], [storageram], [busspeed], [diskspace], [rotationalspeed], [touchscreen], [sizemh], [graphicschipset], [graphicsspace], [otherinfographics], [opticaldiscs], [interface], [extendedfeatures], [wifistandard], [wirelessconnection], [webcam], [batteryinformation], [usetime], [os], [otherinfoos], [camera], [movie], [music], [fmradio], [record], [otherapplication], [ringtones], [headphone], [memory], [sdcardsupport], [contacts], [mobilenetwork], [gprs], [network3g], [gps], [bluetooth], [usb], [typescreen], [resolution], [sizephone], [keyboardqwerty], [weight], [language], [talktime], [waittime], [otherinfophone], [discontinued]) VALUES (40, N'TL', N'US ', 1, N'Máy tính bảng iPad 2 3G 16GB', N'Màn hình: 9.7 inch. Cảm ứng điện dung đa điểm Hệ điều hành iOS CPU: Dual-core Cortex-A9, 1 GHz Processor - Ram: 512 MB Bộ nhớ trong: 16 GB ', N'Digital_World_Tablet_Apple_22_Máy tính bảng iPad 2 3G 16GB.jpg', CAST(0x0000A10100000000 AS DateTime), 9400000.0000, 12490000.0000, 35, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1) INSERT [dbo].[products] ([productid], [categoryid], [originid], [supplierid], [productname], [description], [photopath], [dateupdated], [unitprice], [unitprice_sell], [unitsinstock], [unitsonorder], [discount], [manufacturername], [technologycpu], [typecpu], [speedcpu], [otherinfocpu], [storageram], [busspeed], [diskspace], [rotationalspeed], [touchscreen], [sizemh], [graphicschipset], [graphicsspace], [otherinfographics], [opticaldiscs], [interface], [extendedfeatures], [wifistandard], [wirelessconnection], [webcam], [batteryinformation], [usetime], [os], [otherinfoos], [camera], [movie], [music], [fmradio], [record], [otherapplication], [ringtones], [headphone], [memory], [sdcardsupport], [contacts], [mobilenetwork], [gprs], [network3g], [gps], [bluetooth], [usb], [typescreen], [resolution], [sizephone], [keyboardqwerty], [weight], [language], [talktime], [waittime], [otherinfophone], [discontinued]) VALUES (41, N'TL', N'US ', 2, N'Máy tính bảng Samsung Galaxy Note 10.1 (', N'Màn hình: 10.1 inch. Cảm ứng Điện dung,đa điểm Hệ điều hành Android 4.0 CPU: Quad-core, 1.4 GHz - Ram: 2 Gb Bộ nhớ trong: 16 GB - Hỗ trợ thẻ nhớ ngoài Micro SD, lên tới 32GB Tính năng đàm thoại: Có ', N'Digital_World_Tablet_SamSung_23_Máy tính bảng Samsung Galaxy Note 10.1 (16GB).jpg', CAST(0x0000A10100000000 AS DateTime), 13000000.0000, 15990000.0000, 35, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1) INSERT [dbo].[products] ([productid], [categoryid], [originid], [supplierid], [productname], [description], [photopath], [dateupdated], [unitprice], [unitprice_sell], [unitsinstock], [unitsonorder], [discount], [manufacturername], [technologycpu], [typecpu], [speedcpu], [otherinfocpu], [storageram], [busspeed], [diskspace], [rotationalspeed], [touchscreen], [sizemh], [graphicschipset], [graphicsspace], [otherinfographics], [opticaldiscs], [interface], [extendedfeatures], [wifistandard], [wirelessconnection], [webcam], [batteryinformation], [usetime], [os], [otherinfoos], [camera], [movie], [music], [fmradio], [record], [otherapplication], [ringtones], [headphone], [memory], [sdcardsupport], [contacts], [mobilenetwork], [gprs], [network3g], [gps], [bluetooth], [usb], [typescreen], [resolution], [sizephone], [keyboardqwerty], [weight], [language], [talktime], [waittime], [otherinfophone], [discontinued]) VALUES (42, N'TL', N'US ', 2, N'Máy tính bảng Samsung Galaxy Tab 2 10.1', N'Màn hình: 10.1 inch. Cảm ứng Điện dung,đa điểm Hệ điều hành Android 4.0 CPU: Dual-core processor, 1 GHz - Ram: 1 Gb Bộ nhớ trong: 16 GB - Hỗ trợ thẻ nhớ ngoài Micro SD Hỗ trợ nghe gọi ', N'Digital_World_Tablet_SamSung_24_Máy tính bảng Samsung Galaxy Tab 2 10.1.jpg', CAST(0x0000A10100000000 AS DateTime), 9000000.0000, 11490000.0000, 35, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1) INSERT [dbo].[products] ([productid], [categoryid], [originid], [supplierid], [productname], [description], [photopath], [dateupdated], [unitprice], [unitprice_sell], [unitsinstock], [unitsonorder], [discount], [manufacturername], [technologycpu], [typecpu], [speedcpu], [otherinfocpu], [storageram], [busspeed], [diskspace], [rotationalspeed], [touchscreen], [sizemh], [graphicschipset], [graphicsspace], [otherinfographics], [opticaldiscs], [interface], [extendedfeatures], [wifistandard], [wirelessconnection], [webcam], [batteryinformation], [usetime], [os], [otherinfoos], [camera], [movie], [music], [fmradio], [record], [otherapplication], [ringtones], [headphone], [memory], [sdcardsupport], [contacts], [mobilenetwork], [gprs], [network3g], [gps], [bluetooth], [usb], [typescreen], [resolution], [sizephone], [keyboardqwerty], [weight], [language], [talktime], [waittime], [otherinfophone], [discontinued]) VALUES (43, N'MP', N'US ', 1, N'Iphone 4S 32Gb Black (Quốc Tế)', N'', N'Digital_World_MobilePhone_Apple_26_Iphone 4S 32Gb Black (Quốc Tế).jpg', CAST(0x0000A10300000000 AS DateTime), 12000000.0000, 13599000.0000, 2, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'Pin chuẩn Li-Ion', N'', N'iOS 5', NULL, N'VGA (0.3 Mpx)', N'H.263, H.264(MPEG4-AVC), MP4, ', N'AAC+, MP3, WAV, WMA, eAAC+', N'radio', N'có', N'', N'MP3', N'3.5 mm', N'16GB', N'không', N'không giới hạn', N'MobiFone, VinaPhone, Viettel, Vietnamobile, Beelin', N'có', N'HSDPA, 14.4 Mbps; HSUPA, 5.8 Mbps', N'A-GPS và G', N'bluetooth', N'USB 2.0', N'LED-backlit IPS TFT 16 triệu màu', N'640 x 960 pixels', N'3.5 inches', N'có', N'140g', N'tiếng anh', N'14 giờ', N'200 giờ', N'', 1) SET IDENTITY_INSERT [dbo].[products] OFF INSERT [dbo].[Sup_Categories] ([CateID], [SupID]) VALUES (N'LT', 1) INSERT [dbo].[Sup_Categories] ([CateID], [SupID]) VALUES (N'LT', 2) INSERT [dbo].[Sup_Categories] ([CateID], [SupID]) VALUES (N'LT', 3) INSERT [dbo].[Sup_Categories] ([CateID], [SupID]) VALUES (N'LT', 4) INSERT [dbo].[Sup_Categories] ([CateID], [SupID]) VALUES (N'LT', 5) INSERT [dbo].[Sup_Categories] ([CateID], [SupID]) VALUES (N'LT', 6) INSERT [dbo].[Sup_Categories] ([CateID], [SupID]) VALUES (N'TL', 1) INSERT [dbo].[Sup_Categories] ([CateID], [SupID]) VALUES (N'TL', 2) INSERT [dbo].[Sup_Categories] ([CateID], [SupID]) VALUES (N'MP', 1) INSERT [dbo].[Sup_Categories] ([CateID], [SupID]) VALUES (N'MP', 2) SET IDENTITY_INSERT [dbo].[suppliers] ON INSERT [dbo].[suppliers] ([supplierid], [companyname], [contactname], [contacttitle], [address], [city], [postalcode], [country], [phone], [homepage], [status]) VALUES (1, N'Apple', N'Nguyễn Văn A', N'Giám đốc', N'135 An Dương Vương P.12 Q.10', N'Tp.Hồ Chí Minh', N'70000', N'Việt Nam', N'38625403', N'http://www.apple.com/', 1) INSERT [dbo].[suppliers] ([supplierid], [companyname], [contactname], [contacttitle], [address], [city], [postalcode], [country], [phone], [homepage], [status]) VALUES (2, N'SamSung', N'Trần Văn B', N'Giám đốc', N'65 Điện Biên Phủ P.5 Q.3', N'Tp.Hồ Chí Minh', N'70000', N'Việt Nam', N'38393173', N'http://www.samsung.com/vn/#latest-home', 1) INSERT [dbo].[suppliers] ([supplierid], [companyname], [contactname], [contacttitle], [address], [city], [postalcode], [country], [phone], [homepage], [status]) VALUES (3, N'HP', N'Hồ Thị C', N'Giám đốc', N'35 Cộng Hoà P.4 Q.Tân Bình', N'Tp.Hồ Chí Minh', N'70000', N'Việt Nam', N'39625301', N'http://www8.hp.com/vn/en/home.html', 1) INSERT [dbo].[suppliers] ([supplierid], [companyname], [contactname], [contacttitle], [address], [city], [postalcode], [country], [phone], [homepage], [status]) VALUES (4, N'ASUS', N'Lý Hồng D', N'Giám đốc', N'110 An Dương Vương P.12 Q.10', N'Tp.Hồ Chí Minh', N'70000', N'Việt Nam', N'39625301', N'http://vn.asus.com/', 1) INSERT [dbo].[suppliers] ([supplierid], [companyname], [contactname], [contacttitle], [address], [city], [postalcode], [country], [phone], [homepage], [status]) VALUES (5, N'Dell', N'Lê Văn E', N'Giám đốc', N'100 Điện Biên Phủ P.5 Q.3', N'Tp.Hồ Chí Minh', N'70000', N'Việt Nam', N'39625301', N'http://www.dell.com/', 1) INSERT [dbo].[suppliers] ([supplierid], [companyname], [contactname], [contacttitle], [address], [city], [postalcode], [country], [phone], [homepage], [status]) VALUES (6, N'Toshiba', N'Dương Thành First', N'Giám đốc', N'135 An Dương Vương P.12 Q.10', N'Tp.Hồ Chí Minh', N'70000', N'Việt Nam', N'38625403', N'http://www.apple.com/', 1) SET IDENTITY_INSERT [dbo].[suppliers] OFF SET ANSI_PADDING ON GO /****** Object: Index [pk_categories] Script Date: 11/10/2012 4:01:42 PM ******/ ALTER TABLE [dbo].[categories] ADD CONSTRAINT [pk_categories] PRIMARY KEY NONCLUSTERED ( [categoryid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [pk_customers] Script Date: 11/10/2012 4:01:42 PM ******/ ALTER TABLE [dbo].[customers] ADD CONSTRAINT [pk_customers] PRIMARY KEY NONCLUSTERED ( [customerid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [pk_employees] Script Date: 11/10/2012 4:01:42 PM ******/ ALTER TABLE [dbo].[employees] ADD CONSTRAINT [pk_employees] PRIMARY KEY NONCLUSTERED ( [employeeid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [pk_exportbills] Script Date: 11/10/2012 4:01:42 PM ******/ ALTER TABLE [dbo].[exportbills] ADD CONSTRAINT [pk_exportbills] PRIMARY KEY NONCLUSTERED ( [exportbillid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [pk_importbills] Script Date: 11/10/2012 4:01:42 PM ******/ ALTER TABLE [dbo].[importbills] ADD CONSTRAINT [pk_importbills] PRIMARY KEY NONCLUSTERED ( [importbillid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [pk_orders] Script Date: 11/10/2012 4:01:42 PM ******/ ALTER TABLE [dbo].[orders] ADD CONSTRAINT [pk_orders] PRIMARY KEY NONCLUSTERED ( [orderid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO SET ANSI_PADDING ON GO /****** Object: Index [pk_origins] Script Date: 11/10/2012 4:01:42 PM ******/ ALTER TABLE [dbo].[origins] ADD CONSTRAINT [pk_origins] PRIMARY KEY NONCLUSTERED ( [originid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO SET ANSI_PADDING ON GO /****** Object: Index [pk_payments] Script Date: 11/10/2012 4:01:42 PM ******/ ALTER TABLE [dbo].[payments] ADD CONSTRAINT [pk_payments] PRIMARY KEY NONCLUSTERED ( [paymentid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [pk_positions] Script Date: 11/10/2012 4:01:42 PM ******/ ALTER TABLE [dbo].[positions] ADD CONSTRAINT [pk_positions] PRIMARY KEY NONCLUSTERED ( [positionid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [pk_products] Script Date: 11/10/2012 4:01:42 PM ******/ ALTER TABLE [dbo].[products] ADD CONSTRAINT [pk_products] PRIMARY KEY NONCLUSTERED ( [productid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [pk_suppliers] Script Date: 11/10/2012 4:01:42 PM ******/ ALTER TABLE [dbo].[suppliers] ADD CONSTRAINT [pk_suppliers] PRIMARY KEY NONCLUSTERED ( [supplierid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO ALTER TABLE [dbo].[categories] ADD CONSTRAINT [DF__categorie__statu__108B795B] DEFAULT ((1)) FOR [status] GO ALTER TABLE [dbo].[customers] ADD CONSTRAINT [DF__customers__statu__1367E606] DEFAULT ((1)) FOR [status] GO ALTER TABLE [dbo].[employees] ADD CONSTRAINT [DF__employees__statu__164452B1] DEFAULT ((1)) FOR [status] GO ALTER TABLE [dbo].[orders] ADD CONSTRAINT [DF_orders_hide] DEFAULT ((0)) FOR [hide] GO ALTER TABLE [dbo].[origins] ADD CONSTRAINT [DF__origins__status__20C1E124] DEFAULT ((1)) FOR [status] GO ALTER TABLE [dbo].[payments] ADD CONSTRAINT [DF_payments_status] DEFAULT ((1)) FOR [status] GO ALTER TABLE [dbo].[positions] ADD CONSTRAINT [DF__positions__statu__25869641] DEFAULT ((1)) FOR [status] GO ALTER TABLE [dbo].[products] ADD CONSTRAINT [DF__products__discon__286302EC] DEFAULT ((1)) FOR [discontinued] GO ALTER TABLE [dbo].[suppliers] ADD CONSTRAINT [DF__suppliers__statu__2B3F6F97] DEFAULT ((1)) FOR [status] GO ALTER TABLE [dbo].[employees] WITH CHECK ADD CONSTRAINT [fk_employee_positions_position] FOREIGN KEY([positionid]) REFERENCES [dbo].[positions] ([positionid]) GO ALTER TABLE [dbo].[employees] CHECK CONSTRAINT [fk_employee_positions_position] GO ALTER TABLE [dbo].[exportbills] WITH CHECK ADD CONSTRAINT [fk_exportbi_associati_customer] FOREIGN KEY([customerid]) REFERENCES [dbo].[customers] ([customerid]) GO ALTER TABLE [dbo].[exportbills] CHECK CONSTRAINT [fk_exportbi_associati_customer] GO ALTER TABLE [dbo].[exportbills] WITH CHECK ADD CONSTRAINT [fk_exportbi_associati_orders] FOREIGN KEY([orderid]) REFERENCES [dbo].[orders] ([orderid]) GO ALTER TABLE [dbo].[exportbills] CHECK CONSTRAINT [fk_exportbi_associati_orders] GO ALTER TABLE [dbo].[exportbills] WITH CHECK ADD CONSTRAINT [fk_exportbi_exportbil_payments] FOREIGN KEY([paymentid]) REFERENCES [dbo].[payments] ([paymentid]) GO ALTER TABLE [dbo].[exportbills] CHECK CONSTRAINT [fk_exportbi_exportbil_payments] GO ALTER TABLE [dbo].[importbills] WITH CHECK ADD CONSTRAINT [fk_importbi_importbil_employee] FOREIGN KEY([employeeid]) REFERENCES [dbo].[employees] ([employeeid]) GO ALTER TABLE [dbo].[importbills] CHECK CONSTRAINT [fk_importbi_importbil_employee] GO ALTER TABLE [dbo].[importbills] WITH CHECK ADD CONSTRAINT [fk_importbi_importbil_payments] FOREIGN KEY([paymentid]) REFERENCES [dbo].[payments] ([paymentid]) GO ALTER TABLE [dbo].[importbills] CHECK CONSTRAINT [fk_importbi_importbil_payments] GO ALTER TABLE [dbo].[importbills] WITH CHECK ADD CONSTRAINT [fk_importbi_importbil_products] FOREIGN KEY([productid]) REFERENCES [dbo].[products] ([productid]) GO ALTER TABLE [dbo].[importbills] CHECK CONSTRAINT [fk_importbi_importbil_products] GO ALTER TABLE [dbo].[importbills] WITH CHECK ADD CONSTRAINT [FK_importbills_suppliers] FOREIGN KEY([supplierid]) REFERENCES [dbo].[suppliers] ([supplierid]) GO ALTER TABLE [dbo].[importbills] CHECK CONSTRAINT [FK_importbills_suppliers] GO ALTER TABLE [dbo].[orderdetails] WITH CHECK ADD FOREIGN KEY([orderid]) REFERENCES [dbo].[orders] ([orderid]) GO ALTER TABLE [dbo].[orderdetails] WITH CHECK ADD FOREIGN KEY([productid]) REFERENCES [dbo].[products] ([productid]) GO ALTER TABLE [dbo].[orders] WITH CHECK ADD CONSTRAINT [fk_orders_associati_customer] FOREIGN KEY([customerid]) REFERENCES [dbo].[customers] ([customerid]) GO ALTER TABLE [dbo].[orders] CHECK CONSTRAINT [fk_orders_associati_customer] GO ALTER TABLE [dbo].[orders] WITH CHECK ADD CONSTRAINT [fk_orders_write_employee] FOREIGN KEY([employeeid]) REFERENCES [dbo].[employees] ([employeeid]) GO ALTER TABLE [dbo].[orders] CHECK CONSTRAINT [fk_orders_write_employee] GO ALTER TABLE [dbo].[products] WITH CHECK ADD CONSTRAINT [fk_products_categorie_categori] FOREIGN KEY([categoryid]) REFERENCES [dbo].[categories] ([categoryid]) GO ALTER TABLE [dbo].[products] CHECK CONSTRAINT [fk_products_categorie_categori] GO ALTER TABLE [dbo].[products] WITH CHECK ADD CONSTRAINT [fk_products_origins_p_origins] FOREIGN KEY([originid]) REFERENCES [dbo].[origins] ([originid]) GO ALTER TABLE [dbo].[products] CHECK CONSTRAINT [fk_products_origins_p_origins] GO ALTER TABLE [dbo].[products] WITH CHECK ADD CONSTRAINT [FK_products_suppliers] FOREIGN KEY([supplierid]) REFERENCES [dbo].[suppliers] ([supplierid]) GO ALTER TABLE [dbo].[products] CHECK CONSTRAINT [FK_products_suppliers] GO ALTER TABLE [dbo].[Sup_Categories] WITH CHECK ADD CONSTRAINT [FK__Sup_Categ__CateI__2DB1C7EE] FOREIGN KEY([CateID]) REFERENCES [dbo].[categories] ([categoryid]) GO ALTER TABLE [dbo].[Sup_Categories] CHECK CONSTRAINT [FK__Sup_Categ__CateI__2DB1C7EE] GO ALTER TABLE [dbo].[Sup_Categories] WITH CHECK ADD CONSTRAINT [FK_Sup_Categories_suppliers] FOREIGN KEY([SupID]) REFERENCES [dbo].[suppliers] ([supplierid]) GO ALTER TABLE [dbo].[Sup_Categories] CHECK CONSTRAINT [FK_Sup_Categories_suppliers] GO

Download mã nguồn
Thời gian: 2014-08-21T06:17:00-07:00
Bài viết:[Đồ Án] Website bán hàng thương mại điện tử Digital World
Rating: 5 trên 22 lượt xem

[Đồ Án] Website bán hàng thương mại điện tử Digital World

No comments:

Post a Comment

Liên kết bạn bè

Followers

Chuyên mục