DELIMITER //
use protocoldb//
drop procedure if exists sp_protocol_Update//
create procedure sp_protocol_Update
(
in p_ProtocolNodeUID varchar(64),
in p_VersionUID varchar(64),
in p_ParentProtocolNodeUID varchar(64),
in p_IsDefaultSelected TINYINT(1),
in p_SequenceOrder INT(11),
in p_NodeType CHAR(50),
in p_NodeKey varchar(64),
in p_NodeLabel varchar(200),
in p_ExamedBodyPart varchar(200),
in p_ScanTypeSupported CHAR(50),
in p_PatientPosition CHAR(50),
in p_PrivateProtocolFilePath varchar(1024),
in p_Description varchar(1024),
in p_LeftRightFlag CHAR(50),
in p_AgeGroup CHAR(50),
in p_FileVersionNumber varchar(64),
in p_ExampleFigurePath varchar(1024),
in p_PatientTypeID varchar(64),
in p_ProcedureID varchar(64),
in p_PSASID varchar(64),
in p_ProtocolID varchar(64),
in p_IsFavourite TINYINT(1),
in p_IsTimed TINYINT(1),
in p_IsFactoryPredefine TINYINT(1),
in p_IsNeedInjection TINYINT(1),
in p_IsLicensed TINYINT(1),
in p_IsCardicScan TINYINT(1),
in p_IsPediatric TINYINT(1),
in p_CreateDate DATETIME,
in p_CreateBy varchar(64),
in p_UpdateDate DATETIME,
in p_UpdateBy varchar(64)
)
begin
update protocolnode set
VersionUID = p_VersionUID,
ParentProtocolNodeUID = p_ParentProtocolNodeUID,
IsDefaultSelected = p_IsDefaultSelected,
SequenceOrder = p_SequenceOrder,
NodeType = p_NodeType,
NodeKey = p_NodeKey,
NodeLabel = p_NodeLabel,
ExamedBodyPart = p_ExamedBodyPart,
ScanTypeSupported = p_ScanTypeSupported,
PatientPosition = p_PatientPosition,
PrivateProtocolFilePath = p_PrivateProtocolFilePath,
Description = p_Description,
LeftRightFlag = p_LeftRightFlag,
AgeGroup = p_AgeGroup,
FileVersionNumber = p_FileVersionNumber,
ExampleFigurePath = p_ExampleFigurePath,
PatientTypeID = p_PatientTypeID,
ProcedureID = p_ProcedureID,
PSASID = p_PSASID,
ProtocolID = p_ProtocolID,
IsFavourite = p_IsFavourite,
IsTimed = p_IsTimed,
IsFactoryPredefine = p_IsFactoryPredefine,
IsNeedInjection = p_IsNeedInjection,
IsLicensed = p_IsLicensed,
IsCardicScan = p_IsCardicScan,
IsPediatric = p_IsPediatric,
CreateDate = p_CreateDate,
CreateBy = p_CreateBy,
UpdateDate = p_UpdateDate,
UpdateBy = p_UpdateBy
where ProtocolNodeUID = p_ProtocolNodeUID;
end
//
DELIMITER ;
use protocoldb//
drop procedure if exists sp_protocol_Update//
create procedure sp_protocol_Update
(
in p_ProtocolNodeUID varchar(64),
in p_VersionUID varchar(64),
in p_ParentProtocolNodeUID varchar(64),
in p_IsDefaultSelected TINYINT(1),
in p_SequenceOrder INT(11),
in p_NodeType CHAR(50),
in p_NodeKey varchar(64),
in p_NodeLabel varchar(200),
in p_ExamedBodyPart varchar(200),
in p_ScanTypeSupported CHAR(50),
in p_PatientPosition CHAR(50),
in p_PrivateProtocolFilePath varchar(1024),
in p_Description varchar(1024),
in p_LeftRightFlag CHAR(50),
in p_AgeGroup CHAR(50),
in p_FileVersionNumber varchar(64),
in p_ExampleFigurePath varchar(1024),
in p_PatientTypeID varchar(64),
in p_ProcedureID varchar(64),
in p_PSASID varchar(64),
in p_ProtocolID varchar(64),
in p_IsFavourite TINYINT(1),
in p_IsTimed TINYINT(1),
in p_IsFactoryPredefine TINYINT(1),
in p_IsNeedInjection TINYINT(1),
in p_IsLicensed TINYINT(1),
in p_IsCardicScan TINYINT(1),
in p_IsPediatric TINYINT(1),
in p_CreateDate DATETIME,
in p_CreateBy varchar(64),
in p_UpdateDate DATETIME,
in p_UpdateBy varchar(64)
)
begin
update protocolnode set
VersionUID = p_VersionUID,
ParentProtocolNodeUID = p_ParentProtocolNodeUID,
IsDefaultSelected = p_IsDefaultSelected,
SequenceOrder = p_SequenceOrder,
NodeType = p_NodeType,
NodeKey = p_NodeKey,
NodeLabel = p_NodeLabel,
ExamedBodyPart = p_ExamedBodyPart,
ScanTypeSupported = p_ScanTypeSupported,
PatientPosition = p_PatientPosition,
PrivateProtocolFilePath = p_PrivateProtocolFilePath,
Description = p_Description,
LeftRightFlag = p_LeftRightFlag,
AgeGroup = p_AgeGroup,
FileVersionNumber = p_FileVersionNumber,
ExampleFigurePath = p_ExampleFigurePath,
PatientTypeID = p_PatientTypeID,
ProcedureID = p_ProcedureID,
PSASID = p_PSASID,
ProtocolID = p_ProtocolID,
IsFavourite = p_IsFavourite,
IsTimed = p_IsTimed,
IsFactoryPredefine = p_IsFactoryPredefine,
IsNeedInjection = p_IsNeedInjection,
IsLicensed = p_IsLicensed,
IsCardicScan = p_IsCardicScan,
IsPediatric = p_IsPediatric,
CreateDate = p_CreateDate,
CreateBy = p_CreateBy,
UpdateDate = p_UpdateDate,
UpdateBy = p_UpdateBy
where ProtocolNodeUID = p_ProtocolNodeUID;
end
//
DELIMITER ;