[MSSQL]任务发送

ALTER Procedure [dbo].[TaskSend](
	 @SendUserID     int
	,@TaskCode       varchar(11)
)
AS
declare @temp nvarchar(15),
		@Progress varchar(200),
		@FlowLevel int, 
		@TaskLine int,
		@UserID int,
		@FlowCode varchar(15)


--更新制单人层级信息
update TaskLine set Result='Y',Ref='已送签' where TaskCode=@TaskCode and TaskLine=1 and TranType='W'
--取得下一层级
select @FlowLevel=min(FlowLevel) from TaskLine where TaskCode=@TaskCode and TranType<>'W'
 


Declare CurSend CURSOR
local static FOR 
--select rtrim(U.[name]) as [name],U.[id]
--from TaskLine L left join users U on FL.UserID=U.[id]
--WHERE FL.FlowLevel=@FlowLevel and FL.FlowCode=@FlowCode and FL.TranType='A'

select rtrim(U.[name]) as [name],U.[id]
from TaskLine TL left join users U on TL.UserID=U.[id]
WHERE TL.FlowLevel=@FlowLevel and TL.T