酬金结算(备忘)

begin tran trans

declare @customerid bigint

declare @summoney money

declare @accountid bigint

declare @submituserid bigint

declare Cur cursor  for

select customerid,sum(money) from Gratuity  where issettled = 0 group by customerid

open Cur

Fetch next From Cur Into @customerid,@summoney

While @@fetch_status=0    

Begin

set @accountid = (select accountid from dbo.Account where CustomerID = @customerid)

set @submituserid = (select UserId from  dbo.Customers where CustomerID = @customerid)

insert into RemitAccount(AccountID,SubmitUserId,SubmitTime,Moeny,BankOrderNo,Bank,Remark,State)

values(@accountid,@submituserid,getdate(),@summoney,'无','新系统酬金','新系统自运作以来的所有酬金结算[2010-10-25至2010-11-14]',1)

    Fetch Next From Cur Into @customerid,@summoney

End  

Close Cur  

Deallocate Cur

update Gratuity set  issettled = 1 

commit tran trans