求救.关于毕业设计

高手们帮帮我
完成我的心愿.我要毕业！！
因为要做毕业设计
  我不会翻译这些存储过程..！
  求求你们帮帮我..！！！！！不然我就死定了！！！
简单翻译下就好！！！麻烦
3.2 添加订单
CREATE PROCEDURE [dbo].[AddOrder]
(
    @UserID int,
    @CartIDString     nvarchar(50),
    @OrderDate  datetime,        
    @OrderID    int OUTPUT
)
AS
BEGIN TRAN OrderAdd
INSERT INTO Orders
(
    UserID,
    OrderDate
)
VALUES
(   
    @UserID,
    @OrderDate
)
SELECT
    @OrderID = @@Identity   
INSERT INTO OrderContent
(
    OrderID,
    BookID,
    BookQuantity,
    UnitCost
)

SELECT
    @OrderID,
    ShopCart.BookID,
    BookQuantity,
    Books.BookPrice
FROM
    ShopCart
  INNER JOIN Books ON ShopCart.BookID = Books.BookID
  
WHERE
    CartIDString = @CartIDString
EXEC EmptyShoppingCart @CartIDString
COMMIT TRAN OrderAdd
GO

3.3 编辑用户表
CREATE Procedure [dbo].[AddUser]
(
    @UserAccount   nvarchar(50),
    @UserPwd   nvarchar(50),
    @Email    nvarchar(50),
    @UserID int OUTPUT
)
AS

INSERT INTO Users
(
    UserName,
    Password,
    Email
)

VALUES
(
    @UserAccount,
    @UserPwd,
    @Email
  
)

SELECT
    @UserID = @@Identity
GO

3.4 查询分类图书信息
CREATE PROCEDURE [dbo].[BookByCategory]
(
    @CatID int
)
AS

SELECT
    BookID,
    BookName,
    BookPrice,
    BookImages

FROM
    Books

WHERE
    CatID = @CatID

ORDER BY
    BookName,
    BookMarketPrice
GO


3.5 查询图书详细信息
CREATE PROCEDURE [dbo].[BookDetail]
(
    @BookID    int,
    @BookMarketPrice  money OUTPUT,
    @BookName    nvarchar(50) OUTPUT,
    @BookImages nvarchar(50) OUTPUT,
    @BookPrice     money OUTPUT,
    @BookIntro  nvarchar(4000) OUTPUT
)
AS

SELECT
    @BookID    = BookID,
    @BookMarketPrice  = BookMarketPrice,
    @BookName    = BookName,
    @BookImages = BookImages,
    @BookPrice     = BookPrice,
    @BookIntro  = BookIntro

FROM
    Books

WHERE
    BookID = @BookID
GO

3.6 储存核对用户名
CREATE PROCEDURE [dbo].[CheckUser]
 @UserAccount nvarchar(50)
AS
SET NOCOUNT ON
SELECT * From Users
WHERE @UserAccount=UserName
RETURN
GO

3.7 获取购买图书数量
CREATE PROCEDURE [dbo].[CountShoppingCartItem]
    (
        @CartIDString    nvarchar(50),
        @ItemCount int OUTPUT
    )
    AS

    SELECT
        @ItemCount = COUNT(BookID)
    FROM
        ShopCart
    WHERE
        CartIDString = @CartIDString
GO

3.8 显示购物车信息
CREATE PROCEDURE [dbo].[DisplayShoppingCart]
(
    @CartID nvarchar(50)
)
AS

SELECT
    Books.BookID,
    Books.BookName,
    Books.BookMarketPrice,
    ShopCart.BookQuantity,
    Books.BookPrice,
    Cast((Books.BookPrice * ShopCart.BookQuantity) as money) as ExtendedAmount

FROM
    Books,
    ShopCart

WHERE
    Books.BookID = ShopCart.BookID
  AND
    ShopCart.CartIDString = @CartID

ORDER BY
    Books.BookName,
    Books.BookMarketPrice
GO

3.9 清空购物车
CREATE PROCEDURE [dbo].[EmptyShoppingCart]
(
    @CartIDString nvarchar(50)
)
AS

DELETE FROM ShopCart

WHERE
    CartIDString = @CartIDString

GO

3.10 查询图书分类信息
CREATE PROCEDURE [dbo].[ListBookCategory]
AS
SELECT
    CatID,
    CatName
FROM
    Categories
ORDER BY
    CatName ASC
GO

3.11 订单
CREATE Procedure [dbo].[ListOrders]
(
    @UserID int
)
As

SELECT  
    Orders.OrderID,
    Cast(sum(OrderContent.BookQuantity*OrderContent.unitcost) as money) as OrderTotalCost,
    Orders.OrderDate

FROM   
    Orders
  INNER JOIN OrderContent ON Orders.OrderID = OrderContent.OrderID

GROUP BY   
    UserID,
    Orders.OrderID,
    Orders.OrderDate

HAVING  
    Orders.UserID = @UserID
GO

3.12 判断用户原始密码
CREATE PROCEDURE [dbo].[ModPwd]
    @UserID    int,
    @Password  nvarchar(12)
AS
BEGIN
    SET NOCOUNT ON;
    Update Users
    Set
       Password = @Password
    Where
       UserID = @UserID
END
GO

3.13 修改用户信息
CREATE PROCEDURE [dbo].[ModUserInfo]
    @UserID int,
    @Name   nvarchar(10),
    @Email      nvarchar(50),
    @IDCardNumber      nvarchar(18),
    @TelephoneNumber      nvarchar(12),
    @Address      nvarchar(50),
    @ZoneCode    nvarchar(10),
    @Mobilephone nvarchar(12),
    @Oicq        nvarchar(20),
    @MSN         nvarchar(50)   
AS
BEGIN
    SET NOCOUNT ON;

    Update Users
    SET
    Name = @Name,
    Email  = @Email,
    IDCardNumber = @IDCardNumber,
    TelephoneNumber = @TelephoneNumber,
    Address = @Address,
    ZoneCode = @ZoneCode,
    Mobilephone = @Mobilephone,
    Oicq = @Oicq,
    MSN =@MSN
    WHERE
        UserID = @UserID
END
GO

3.14 查询销量前6的图书信息
CREATE PROCEDURE [dbo].[MostSoldBooks]

AS

SELECT TOP 6
    OrderContent.BookID,
    SUM(OrderContent.BookQuantity) as TotalNum,
    Books.BookName,
    Books.BookImages,
    Books.BookPrice

FROM   
    OrderContent
  INNER JOIN Books ON OrderContent.BookID = Books.BookID
  
GROUP BY
    OrderContent.BookID,
    Books.BookName,
    Books.BookImages,
    Books.BookPrice
   
ORDER BY
    TotalNum DESC
GO

3.15 读取菜单的详细信息
CREATE Procedure [dbo].[OrdersDetail]
(
    @OrderID    int,
    @UserID int,
    @OrderDate  datetime OUTPUT,
    @OrderTotalCost money OUTPUT
)
AS

SELECT
    @OrderDate = OrderDate
   
FROM   
    Orders
   
WHERE   
    OrderID = @OrderID
    AND
    UserID = @UserID

IF @@Rowcount = 1
BEGIN

SELECT  
    @OrderTotalCost = Cast(SUM(OrderContent.BookQuantity * OrderContent.UnitCost) as money)
   
FROM   
    OrderContent
   
WHERE   
    OrderID= @OrderID

SELECT  
    Bookｓ.*,
    OrderContent.UnitCost,
    OrderContent.BookQuantity,
    (OrderContent.BookQuantity * OrderContent.UnitCost) as ExtendedAmount

FROM
    OrderContent
  INNER JOIN Bookｓ ON OrderContent.BookID = Bookｓ.BookID
  
WHERE   
    OrderID = @OrderID

END
GO

3.16 删除购物车上的图书信息
CREATE PROCEDURE [dbo].[RemoveShoppingCartItem]
(
    @CartIDString nvarchar(50),
    @BookID int
)
AS
DELETE FROM ShopCart
WHERE
    CartIDString = @CartIDString
  AND
    BookID = @BookID
GO

3.17查询图书信息
CREATE PROCEDURE [dbo].[SearchBook]
(
    @BookName nvarchar(255)
)
AS

SELECT
    BookID,
    CatID,
    BookName,   
    BookPrice,
    BookImages

FROM
    Books

WHERE
   
    BookName Like '%'+ @BookName +'%'
GO

3.18获取购物车总价格
CREATE PROCEDURE [dbo].[ShoppingCartTotalCost]
(
    @CartIDString    nvarchar(50),
    @TotalCost money OUTPUT
)
AS
SELECT
    @TotalCost = SUM(Books.BookPrice * ShopCart.BookQuantity)
FROM
    ShopCart,
    Books
WHERE
    ShopCart.CartIDString = @CartIDString
  AND
    Books.BookID = ShopCart.BookID
GO

3.19 购物车互换
CREATE Procedure [dbo].[TransplantShoppingCart]
(
    @OldCartIDString nvarchar(50),
    @NewCartIDString      nvarchar(50)
)
AS

UPDATE
    ShopCart
   
SET
    CartIDString = @NewCartIDString
   
WHERE
    CartIDString = @OldCartIDString
GO

3.20 更新购物车
CREATE PROCEDURE [dbo].[UpdateShoppingCart]
    (
        @CartIDString    nvarchar(50),
        @BookID int,
        @BookQuantity  int
    )
    AS
    UPDATE ShopCart
    SET
        BookQuantity = @BookQuantity
    WHERE
        CartIDString = @CartIDString
      AND
        BookID = @BookID
GO

3.21 读取用户信息
CREATE PROCEDURE [dbo].[UserInfo]
(
    @UserID int,
    @UserName   nvarchar(16) OUTPUT,
    @Name   nvarchar(10) OUTPUT,
    @Email      nvarchar(50) OUTPUT,
    @IDCardNumber      nvarchar(18) OUTPUT,
    @TelephoneNumber      nvarchar(12) OUTPUT,
    @Address      nvarchar(50) OUTPUT,
    @ZoneCode    nvarchar(10) OUTPUT,
    @Mobilephone nvarchar(12) OUTPUT,
    @Oicq        nvarchar(20) OUTPUT,
    @MSN         nvarchar(50) OUTPUT   
)
AS

SELECT
    @UserName = UserName,   
    @Name = Name,
    @Email  = Email,
    @IDCardNumber = IDCardNumber,
    @TelephoneNumber = TelephoneNumber,
    @Address = Address,
    @ZoneCode = ZoneCode,
    @Mobilephone = Mobilephone,
    @Oicq = Oicq,
    @MSN =MSN
FROM
    [Users]
WHERE
    UserID = @UserID
GO


3.22 判断用户原始密码
CREATE PROCEDURE [dbo].[UserPwd]
    @UserID int,
    @Password nvarchar(12) output
AS
BEGIN
    SET NOCOUNT ON;

    Select
    *
    From Users
    Where
    @UserID = UserID
    And
    @Password =Password
END

GO

[[it] 本帖最后由 399098041 于 2008-6-10 23:57 编辑 [/it]]