DECLARE @fileId INT
DECLARE @fileSId INT
DECLARE @perSId INT
DECLARE @repPerSId INT
DECLARE @fileOrde INT
DECLARE @execType nvarchar(10)
DECLARE @perStatus nvarchar(10)
DECLARE @signIdea nvarchar(50)
DECLARE nextcorder CURSOR FOR
--定义游标，获取当前数据表中，所有离职、休假人员未签批的文件信息，设置成‘等待’状态的除外
SELECT T_OAfileList.F_fileId, T_OAfileList.F_fileSid, T_OAfileList.F_toPerSid, T_OAfileList.F_tacheorder,
VI_OAfileExecType.F_type AS F_perStatus, VI_OAfileExecType.F_execType, VI_OAfileExecType.F_repPerSid AS F_repPerSId
FROM T_OAfileList INNER JOIN
VI_OAfileExecType ON
VI_OAfileExecType.F_perSid = T_OAfileList.F_toPerSid
WHERE (T_OAfileList.F_tacheStatus = '到达') AND VI_OAfileExecType.F_type IN ('休假', '离职')
AND VI_OAfileExecType.F_execType <> 'wait'
OPEN nextcorder
FETCH NEXT FROM nextcorder
INTO @fileId, @fileSId, @perSId, @fileOrde, @perStatus, @execType, @repPerSId
WHILE @@FETCH_STATUS = 0
BEGIN
--存在离休假的设置
SET @signIdea = CASE @perStatus WHEN '休假' THEN '休假中……' WHEN '离职' THEN '已离职' END
IF @execType = 'signByOther'
BEGIN
UPDATE T_OAFileList SET F_tacheStatus = '已阅', F_signDate = GETDATE(), F_signIdea = @signIdea + ' 由代签人签批'
WHERE F_fileSId = @fileSId
INSERT INTO T_OAFileList (F_fileId, F_toPerSid, F_tacheOrder, F_tacheType, F_tacheStatus, F_arriveDate)
SELECT F_fileId, @repPerSId, F_tacheOrder, F_tacheType, '到达', GETDATE()
FROM T_OAfileList
WHERE F_fileSId = @fileSId
END
ELSE
BEGIN
IF @execType = 'autoSign'
BEGIN
UPDATE T_OAFileList SET F_tacheStatus = '已阅', F_signDate = GETDATE(), F_signIdea = @signIdea +' 自动签批'
WHERE F_fileSId = @fileSId
END
END
FETCH NEXT FROM nextcorder
INTO @fileId, @fileSId, @perSId, @fileOrde, @perStatus, @execType, @repPerSId
END
CLOSE nextcorder
DEALLOCATE nextCorder
写的比较乱的，请大家帮忙看看
