CREATE PROCEDURE [QuickTeam].[usp_UpdateWorkSheetById]

	@WorkSheetId bigint,

	@ProjectId nvarchar(50),

	--@TeamId nvarchar(50),

	@ProjectName nvarchar(50),

	@SystemName nvarchar(50),

	@Evaluator nvarchar(50),

	@TechnicalLeader nvarchar(50),

	@CustomerLeader nvarchar(50),

	@StartTime datetime,

	@EndTime datetime,

	@Status nvarchar(5)='01' ,

	@ServiceType nvarchar(20),

	@ImplementContent nvarchar(500),

	@OtherInstructions nvarchar(1000),

	@Operator nvarchar(50),

	@DeleteFlag NVARCHAR(2),

	@Operation NVARCHAR(10),

	@BelongTeam  NVARCHAR(50)



	



AS

BEGIN

	declare @length int

	select @length=len([Status]) from [QuickTeam].[WorkSheet] where WorkSheetId=@WorkSheetId

	update QuickTeam.WorkSheet 

	set [WorkSheetCode]=@ProjectName+'_'+CONVERT(varchar(100), @EndTime, 112)+'_'+CONVERT(nvarchar(10),@WorkSheetId)

   ,[ProjectId]=@ProjectId

   ,[ProjectName]=@ProjectName

   ,[SystemName]=@SystemName

   ,[Evaluator]=@Evaluator

   ,[TechnicalLeader]=@TechnicalLeader

   ,[CustomerLeader]=@CustomerLeader

   ,[StartTime]=@StartTime

   ,[EndTime]=@EndTime

   ,[UpdateTime]=getdate()

   ,[Status]=@Status

   ,[ServiceType]=@ServiceType

   ,[ImplementContent]=@ImplementContent

      ,[OtherInstructions]=@OtherInstructions

	,Operation=@Operation

	,DeleteFlag=@DeleteFlag

	,OperateUserName=@Operator

	,BelongTeam=@BelongTeam

	where WorkSheetId=CONVERT(BIGINT,@WorkSheetId)

	

	if(@length=0)

	begin

		INSERT INTO [QuickTeam].[WorkSheetVersion]

			   ([VersionCode]

			   ,[VersionStatus]

			   ,NextOperator

			   ,[WorkSheetId]

			   ,Operator

			   ,UpdateTime

			   )

		 VALUES

			   (N'技术责任人确认版'

			   ,'N'

			   ,'TechnicalLeader'

			   ,@WorkSheetId

			   ,''

			   ,getdate()

			  )

	end

	select  @@ERROR as Result

END