获取用户Id或Name

Bingosoft.Security.SecurityContext.User.IsAuthenticated

//SQL脚本

<command key="ZJForum.BbsPosts.insert">

    <![CDATA[   

INSERT INTO dbo.Forum_Posts

        ( PostsID ,

          ThemeID ,

          Title ,

          Content ,

          PublishUserID ,

          PublishUserName ,

          PublishDeptID ,

          PublishDeptName ,

          PublishTime

        )

VALUES  ( #PostsID# , -- PostsID - nvarchar(50)

          #ThemeID# , -- ThemeID - nvarchar(50)

          #Title# , -- Title - nvarchar(500)

          #Content# , -- Content - nvarchar(max)

          #Env:User.Id#, -- PublishUserID - nvarchar(50)

         (SELECT Name FROM dbo.SEC_User WHERE Id = #Env:User.Id# ) , -- PublishUserName - nvarchar(50)

          #Env:User.DeptId#  , -- PublishDeptID - nvarchar(50)

         (select top 1 Name FROM dbo.SEC_Organization WHERE Id =#Env:User.DeptId# ) , -- PublishDeptName - nvarchar(50)

          GETDATE() -- PublishTime - datetime

        )

    ]]>

  </command>