create procedure sp_PhoneSave
@PHONE_ID D_PHONE,
@CITY_ID D_CITY,
@PHONE_TYPE_ID D_CLIENT_PARAM,
@CLIENT_ID D_CLIENT,
@PHONE_NUMBER Varchar(15),
@RECORD_STATE D_RECORD_STATE,
@USER_ID D_CLIENT_RELATION,
@RECORD_MODIFY D_RECORD_MODIFY_TIMESTAMP output,
@NEW_PHONE_ID D_PHONE output
as
declare
@OldPhoneId D_PHONE,
@RSNew D_RECORD_STATE,
@RSActive D_RECORD_STATE,
@RSArchive D_RECORD_STATE,
@RetValue smallint
select @RSNew=50
select @RSActive=100
select @RSArchive=150
select @OldPhoneId=PHONE_ID
from PHONE
where PHONE_ID=@PHONE_ID
if @OldPhoneId is not null
begin
update PHONE set
RECORD_STATE=@RSArchive,
USER_ID=@USER_ID,
RECORD_MODIFY=getdate()
end
select @RECORD_MODIFY=getdate()
insert into PHONE
(CITY_ID, PHONE_TYPE_ID, CLIENT_ID, PHONE_NUMBER, RECORD_STATE, USER_ID, RECORD_MODIFY)
values
(@CITY_ID, @PHONE_TYPE_ID, @CLIENT_ID, @PHONE_NUMBER, @RECORD_STATE, @USER_ID, @RECORD_MODIFY)
if @@rowcount!=1
begin
select @NEW_PHONE_ID=0
select @RetValue=-100
end
else
begin
select @NEW_PHONE_ID=@@identity
select @RetValue=0
end
return(@RetValue)
|