修改添加存储过程

create PROCEDURE [dbo].[up_AccountItemEdit]

@AccountGuid uniqueidentifier,

@AccountCategory varchar(50),

@AccountName varchar(50),

@AccountFSCode varchar(50),

@DICGuid uniqueidentifier,

@IsObsoleted bit

AS

IF(EXISTS(SELECT 1 FROM T_AccountItem trm WHERE trm.AccountGuid=@AccountGuid))

BEGIN UPDATE T_AccountItem SET AccountCategory=@AccountCategory, AccountName=@AccountName, AccountFSCode=@AccountFSCode, DICGuid=@DICGuid, IsObsoleted=@IsObsoleted WHERE AccountGuid=@AccountGuid END

ELSE

BEGIN INSERT INTO T_AccountItem ( AccountGuid, AccountCategory, AccountName, AccountFSCode, DICGuid, IsObsoleted ) VALUES ( @AccountGuid, @AccountCategory, @AccountName, @AccountFSCode, @DICGuid, @IsObsoleted ) END