新增文章

文章标题分类内容

SELECT 
      a.value('(Operation)[1]','varchar(500)') AS Operation 
     ,a.value('(OperationName)[1]','varchar(500)') AS OperationName 
     ,a.value('(PermissionItemId)[1]','varchar(500)') AS PermissionItemId

FROM T_Meta_ObjectType  CROSS APPLY FKernelXml.nodes('/FormMetadata/BusinessInfo/BusinessInfo/Elements/Form/FormOperations/FormOperation') as node(a)

where  FID = 'aGsf_231017' 
---------------------------------------------------------------------------------------------------
-- 结果

Operation	OperationName	PermissionItemId
Print	打印	8dfa91ae26774d7ea46b29e29ecb3044
CaiJi	采集	652ed65efe8b46
Del	删除行	24f64c0dbfa945f78a6be123197a63f5
HeBing	合并	a2e569438ad94d4f8705f3c7633d8269

<FormOperation>
              <Id>CaiJi</Id>
              <Operation>CaiJi</Operation>
              <BeforeOpAlterInfo />
              <AfterOpAlterInfo />
              <AfterOpFailedInfo action="setnull" />
              <OperationId>45</OperationId>
              <OperationName>采集</OperationName>
              <Parmeter>
                <OperationParameter>
                  <Id>6dcfe231-d762-4e3b-8c9f-11cc9d9f0ebd</Id>
                  <ExpressValue>IsShowMes:0;IsForbidWFService:0</ExpressValue>
                </OperationParameter>
              </Parmeter>
              <PermissionItemId>652ed65efe8b46</PermissionItemId>
              <LoadKeys>[]</LoadKeys>
            </FormOperation>
			  
            <FormOperation>
              <Id>Del</Id>
              <Operation>Del</Operation>
              <BeforeOpAlterInfo />
              <AfterOpAlterInfo />
              <AfterOpFailedInfo action="setnull" />
              <OperationId>45</OperationId>
              <OperationName>删除行</OperationName>
              <Parmeter>
                <OperationParameter>
                  <Id>7fbbad2a-c281-4a41-8d29-05b378efffd7</Id>
                  <ExpressValue>IsShowMes:0;IsForbidWFService:0</ExpressValue>
                </OperationParameter>
              </Parmeter>
              <PermissionItemId>24f64c0dbfa945f78a6be123197a63f5</PermissionItemId>
              <LoadKeys>[]</LoadKeys>
            </FormOperation>