实物点卡生成系统（包含数据库脚本和存储过程）由网狐提供

不废话， 用了就知道 ，亲自试验通过 部分代码如下： IF EXISTS (SELECT TreasureCode FROM Treasure WHERE TreasureCode=@cardcode And TreasurePass=@cardpass) BEGIN IF (Select IsPost From Treasure WHERE TreasureCode=@cardcode)=1 Begin Select [ErrorDescribe]= '对不起,此卡号已经被充值!' RETURN End Set @Price=(Select Price From Treasure WHERE TreasureCode=@cardcode) Set @IsCrad=(Select IsCard From Treasure WHERE TreasureCode=@cardcode) Update Treasure Set IsPost=1 Where TreasureCode=@cardcode Update QPTreasureDB.dbo.GameScoreinfo Set Score=Score+@Price Where UserID=@userid --update QPGameUserDB.dbo.AccountsInfo set UserRight=0 Where UserID=@userid INSERT INTO [PostLog]([PostCode],[PassWord],[UserID],[price],[PostDate],[IsCrad]) VALUES (@cardcode,@cardpass,@UserID,@price,{fn NOW()},@IsCrad) Select [ErrorDescribe]= '成功信息:充值成功!' END Else Begin Select [ErrorDescribe]= '您输入的卡号和密码不正确!'