22,207
社区成员
发帖
与我相关
我的任务
分享
INSERT INTO dbo.TPoint( KUserID ,FPointCount ,FPointType ,FPointDesc ,FPointTime)
VALUES(@userid,@fcount,1,'购买商品('+ CONVERT(NVARCHAR(32),@id)+')获得福分',GETDATE())
IF(@@ERROR <> 0)
BEGIN
SELECT 0,'插入福分记录',@orderNo,@id
ROLLBACK TRANSACTION
RETURN
END
UPDATE dbo.TUser SET FUserPoint = FUserPoint + @fcount,FLevelPoint = FLevelPoint + (@fcount *10) WHERE PUserID = @userid
IF(@@ERROR <> 0)
BEGIN
SELECT 0,'修改积分和福分错误',@orderNo,@id
ROLLBACK TRANSACTION
RETURN
END
begin try
begin tran
INSERT INTO dbo.TPoint( KUserID ,FPointCount ,FPointType ,FPointDesc ,FPointTime)
VALUES(@userid,@fcount,1,'购买商品('+ CONVERT(NVARCHAR(32),@id)+')获得福分',GETDATE())
UPDATE dbo.TUser SET FUserPoint = FUserPoint + @fcount,FLevelPoint = FLevelPoint + (@fcount *10) WHERE PUserID = @userid
if @@Rowcount=0 --没有用户时,新增记录
insert into dbo.TUser(PUserID,FUserPoint,FLevelPoint)
values(@userid,@fcount,@fcount*10)
commit tran
end try
BEGIN CATCH
DECLARE @ErrorMessage NVARCHAR(4000),@ErrorSeverity INT,@ErrorState INT;
SELECT @ErrorMessage = ERROR_MESSAGE(),@ErrorSeverity = ERROR_SEVERITY(),@ErrorState = ERROR_STATE();
RAISERROR (@ErrorMessage, @ErrorSeverity,@ErrorState);
ROLLBACK TRAN
END CATCH