USE [SRO_Accountdb]
GO
/****** Object: StoredProcedure [dbo].[_BUY_WEB_MALL_ITEM] Script Date: 12/02/2015 04:46:26 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
;
ALTER PROCEDURE [dbo].[_BUY_WEB_MALL_ITEM]
@JID INT,
@package_id INT
AS
DECLARE @CodeName VARCHAR(128)
DECLARE @price INT
DECLARE @idx INT
DECLARE @refitemid INT
DECLARE @itemname VARCHAR(MAX)
DECLARE @quantity INT
IF (NOT EXISTS(SELECT *
FROM WEB_PACKAGE_ITEM
WHERE package_id = @package_id AND service = 1))
BEGIN
RETURN -1;
END
IF (NOT EXISTS(SELECT *
FROM WEB_PACKAGE_ITEM_DETAIL
WHERE package_id = @package_id))
BEGIN
RETURN -2;
END
IF (NOT EXISTS(SELECT *
FROM TB_User
WHERE JID = @JID))
BEGIN
RETURN -3;
END
SELECT
@CodeName = item_code,
@quantity = item_quantity
FROM WEB_PACKAGE_ITEM_DETAIL
WHERE package_id = @package_id
IF (NOT EXISTS(SELECT *
FROM SRO_SHARDDB.dbo._RefObjCommon
WHERE CodeName128 = @CodeName AND Service = 1))
BEGIN
RETURN -4;
END
SELECT @price = silk_price
FROM WEB_PACKAGE_ITEM
WHERE package_id = @package_id
SELECT
@refitemid = ID,
@itemname = NameStrID128
FROM SRO_SHARDDB.dbo._RefObjCommon
WHERE CodeName128 = @CodeName
INSERT INTO WEB_ITEM_GIVE_LIST VALUES
(@JID, 64, NULL, NULL, @CodeName, NULL, @itemname, 1, @price, 0, 0, 0, 0, 'WEB_MALL', 0, GETDATE(), NULL, NULL,
NULL)
SET @idx = @@IDENTITY
INSERT INTO SRO_SHARDDB.dbo._BuyCashItemList_By_Web
VALUES (@idx, @JID, 1, @itemname, 1, @refitemid, @quantity, GETDATE(), NULL, NULL, NULL, NULL, NULL, NULL)