"GetSingleModuleDefinition" 存储过程

描述:

This 存储过程 returns a single module type definition from the database. The input parameter is ModuleDefID, the primary key for the record. The return values include the type's friendly name as well as paths for the desktop and mobile versions of the module.

This 存储过程 is used by the edit page for module type definitions.

定义:

    
    CREATE PROCEDURE GetSingleModuleDefinition
    (
        @ModuleDefID int
    )
    AS

    SELECT
        FriendlyName,
        DesktopSrc,
        MobileSrc

    FROM
        ModuleDefinitions

    WHERE
        ModuleDefID = @ModuleDefID

使用的数据库中的表:

ModuleDefinitions: Each record in the ModuleDefinitions table defines a different type of modules that may be used in the selected portal. Individual modules reference this definition via the ModuleDefID, the primary key for this table. All modules must define a Desktop module version; optionally they may also define a Mobile version.