sql 解释XML数据列中的表格

m0_70930886 2024-01-30 09:29:13

把上方XML中的表格列同时查询出来。xml列的代码如下,可以解决的朋友给个信息,我去发下悬赏贴(直接发有字数限制。)

<XTextDocument xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" EditorVersionString="1.2015.3.25">
  <Attributes />
  <XElements>
    <Element xsi:type="XTextBody">
      <Attributes />
      <Expressions />
      <ScriptItems />
      <XElements>
        <Element xsi:type="XInputField" StyleIndex="5">
          <Attributes />
          <ID>field10</ID>
          <EnableValueValidate>true</EnableValueValidate>
          <ValueBinding />
          <Expressions />
          <ScriptItems />
          <XElements>
            <Element xsi:type="XTextTable" NumOfRows="3" NumOfColumns="13">
              <Attributes />
              <ID>table2</ID>
              <Expressions />
              <ScriptItems />
              <XElements>
                <Element xsi:type="XTextTableRow">
                  <Attributes />
                  <Expressions />
                  <ScriptItems />
                  <XElements>
                    <Element xsi:type="XTextTableCell" StyleIndex="3">
                      <Attributes />
                      <ContentReadonly>True</ContentReadonly>
                      <Expressions />
                      <ScriptItems />
                      <XElements>
                        <Element xsi:type="XString" StyleIndex="6" WhiteSpaceLength="7">
                          <Text />
                        </Element>
                        <Element xsi:type="XString" StyleIndex="7">
                          <Text>观察</Text>
                        </Element>
                        <Element xsi:type="XParagraphFlag" StyleIndex="7" />
                        <Element xsi:type="XString" StyleIndex="7">
                          <Text>      项目</Text>
                        </Element>
                        <Element xsi:type="XString" StyleIndex="6" WhiteSpaceLength="2">
                          <Text />
                        </Element>
                        <Element xsi:type="XParagraphFlag" StyleIndex="7" />
                        <Element xsi:type="XString" StyleIndex="6">
                          <Text>日期</Text>
                        </Element>
                        <Element xsi:type="XParagraphFlag" StyleIndex="7" />
                      </XElements>
                      <RuntimeMoveFocusHotKey>Tab</RuntimeMoveFocusHotKey>
                      <SlantSplitLineStyle>TopLeftOneLine</SlantSplitLineStyle>
                    </Element>
                    <Element xsi:type="XTextTableCell" StyleIndex="3">
                      <Attributes />
                      <ContentReadonly>True</ContentReadonly>
                      <Expressions />
                      <ScriptItems />
                      <XElements>
                        <Element xsi:type="XParagraphFlag" StyleIndex="7" />
                        <Element xsi:type="XString" StyleIndex="7">
                          <Text>动作增加或减少</Text>
                        </Element>
                        <Element xsi:type="XParagraphFlag" StyleIndex="7" />
                        <Element xsi:type="XParagraphFlag" StyleIndex="7" />
                      </XElements>
                      <RuntimeMoveFocusHotKey>Tab</RuntimeMoveFocusHotKey>
                    </Element>
                    <Element xsi:type="XTextTableCell" StyleIndex="3">
                      <Attributes />
                      <Expressions />
                      <ScriptItems />
                      <XElements>
                        <Element xsi:type="XString" StyleIndex="7">
                          <Text>与周围环境的联系</Text>
                        </Element>
                        <Element xsi:type="XParagraphFlag" StyleIndex="7" />
                      </XElements>
                      <RuntimeMoveFocusHotKey>Tab</RuntimeMoveFocusHotKey>
                    </Element>
                    <Element xsi:type="XTextTableCell" StyleIndex="3">
                      <Attributes />
                      <Expressions />
                      <ScriptItems />
                      <XElements>
                        <Element xsi:type="XString" StyleIndex="7">
                          <Text>与他人的交往</Text>
                        </Element>
                        <Element xsi:type="XParagraphFlag" StyleIndex="7" />
                        <Element xsi:type="XParagraphFlag" StyleIndex="7" />
                      </XElements>
                      <RuntimeMoveFocusHotKey>Tab</RuntimeMoveFocusHotKey>
                    </Element>
                    <Element xsi:type="XTextTableCell" StyleIndex="3">
                      <Attributes />
                      <Expressions />
                      <ScriptItems />
                      <XElements>
                        <Element xsi:type="XString" StyleIndex="7">
                          <Text>古怪动作或离奇行为</Text>
                        </Element>
                        <Element xsi:type="XParagraphFlag" StyleIndex="7" />
                        <Element xsi:type="XParagraphFlag" StyleIndex="7" />
                      </XElements>
                      <RuntimeMoveFocusHotKey>Tab</RuntimeMoveFocusHotKey>
                    </Element>
                    <Element xsi:type="XTextTableCell" StyleIndex="3">
                      <Attributes />
                      <Expressions />
                      <ScriptItems />
                      <XElements>
                        <Element xsi:type="XString" StyleIndex="7">
                          <Text>违拗被动服从</Text>
                        </Element>
                        <Element xsi:type="XParagraphFlag" StyleIndex="7" />
                      </XElements>
                      <RuntimeMoveFocusHotKey>Tab</RuntimeMoveFocusHotKey>
                    </Element>
                    <Element xsi:type="XTextTableCell" StyleIndex="3">
                      <Attributes />
                      <Expressions />
                      <ScriptItems />
                      <XElements>
                        <Element xsi:type="XString" StyleIndex="7">
                          <Text>冲动攻击行为</Text>
                        </Element>
                        <Element xsi:type="XParagraphFlag" StyleIndex="7" />
                        <Element xsi:type="XParagraphFlag" StyleIndex="7" />
                      </XElements>
                      <RuntimeMoveFocusHotKey>Tab</RuntimeMoveFocusHotKey>
                    </Element>
                    <Element xsi:type="XTextTableCell" StyleIndex="3">
                      <Attributes />
                      <Expressions />
                      <ScriptItems />
                      <XElements>
                        <Element xsi:type="XString" StyleIndex="7">
                          <Text>木僵</Text>
                        </Element>
                        <Element xsi:type="XParagraphFlag" StyleIndex="7" />
                      </XElements>
                      <RuntimeMoveFocusHotKey>Tab</RuntimeMoveFocusHotKey>
                    </Element>
                    <Element xsi:type="XTextTableCell" StyleIndex="3">
                      <Attributes />
                      <Expressions />
                      <ScriptItems />
                      <XElements>
                        <Element xsi:type="XString" StyleIndex="6">
                          <Text>坐立不安不停走动</Text>
                        </Element>
                        <Element xsi:type="XParagraphFlag" StyleIndex="7" />
                      </XElements>
                      <RuntimeMoveFocusHotKey>Tab</RuntimeMoveFocusHotKey>
                    </Element>
                    <Element xsi:type="XTextTableCell" StyleIndex="3">
                      <Attributes />
                      <Expressions />
                      <ScriptItems />
                      <XElements>
                        <Element xsi:type="XString" StyleIndex="7">
                          <Text>自伤自杀行为</Text>
                        </Element>
                        <Element xsi:type="XParagraphFlag" StyleIndex="7" />
                      </XElements>
                      <RuntimeMoveFocusHotKey>Tab</RuntimeMoveFocusHotKey>
                    </Element>
                    <Element xsi:type="XTextTableCell" StyleIndex="3">
                      <Attributes />
                      <Expressions />
                      <ScriptItems />
                      <XElements>
                        <Element xsi:type="XString" StyleIndex="6">
                          <Text> 治疗</Text>
                        </Element>
                        <Element xsi:type="XParagraphFlag" StyleIndex="7" />
                      </XElements>
                      <RuntimeMoveFocusHotKey>Tab</RuntimeMoveFocusHotKey>
                    </Element>
                    <Element xsi:type="XTextTableCell" StyleIndex="3">
                      <Attributes />
                      <Expressions />
                      <ScriptItems />
                      <XElements>
                        <Element xsi:type="XString" StyleIndex="6">
                          <Text>  治疗</Text>
                        </Element>
                        <Element xsi:type="XLineBreak" />
                        <Element xsi:type="XString" WhiteSpaceLength="2">
                          <Text />
                        </Element>
                        <Element xsi:type="XString" StyleIndex="6">
                          <Text>情况</Text>
                        </Element>
                        <Element xsi:type="XString" StyleIndex="7" WhiteSpaceLength="2">
                          <Text />
                        </Element>
                        <Element xsi:type="XParagraphFlag" StyleIndex="7" />
                      </XElements>
                      <RuntimeMoveFocusHotKey>Tab</RuntimeMoveFocusHotKey>
                    </Element>
                    <Element xsi:type="XTextTableCell" StyleIndex="3">
                      <Attributes />
                      <ContentReadonly>True</ContentReadonly>
                      <Expressions />
                      <ScriptItems />
                      <XElements>
                        <Element xsi:type="XString" StyleIndex="7">
                          <Text> 执行</Text>
                        </Element>
                        <Element xsi:type="XString" StyleIndex="6">
                          <Text>人</Text>
                        </Element>
                        <Element xsi:type="XParagraphFlag" StyleIndex="7" />
                      </XElements>
                      <RuntimeMoveFocusHotKey>Tab</RuntimeMoveFocusHotKey>
                    </Element>
                  </XElements>
                  <SpecifyHeight>295</SpecifyHeight>
                  <HeaderStyle>true</HeaderStyle>
                </Element>
                <Element xsi:type="XTextTableRow">
                  <Attributes />
                  <ID />
                  <Expressions />
                  <ScriptItems />
                  <EventTemplateName />
                  <XElements>
                    <Element xsi:type="XTextTableCell" StyleIndex="3">
                      <Attributes />
                      <ID>01</ID>
                      <Expressions />
                      <ScriptItems />
                      <XElements>
                        <Element xsi:type="XString" StyleIndex="9">
                          <Text>2024-01-29</Text>
                        </Element>
                        <Element xsi:type="XParagraphFlag" StyleIndex="8" />
                      </XElements>
                      <RuntimeMoveFocusHotKey>Tab</RuntimeMoveFocusHotKey>
                      <Title>A</Title>
                    </Element>
                    <Element xsi:type="XTextTableCell" StyleIndex="3">
                      <Attributes />
                      <ID>02</ID>
                      <Expressions />
                      <ScriptItems />
                      <XElements>
                        <Element xsi:type="XString" StyleIndex="9">
                          <Text>-</Text>
                        </Element>
                        <Element xsi:type="XParagraphFlag" StyleIndex="8" />
                      </XElements>
                      <MoveFocusHotKey>Enter</MoveFocusHotKey>
                      <RuntimeMoveFocusHotKey>Enter</RuntimeMoveFocusHotKey>
                    </Element>
                    <Element xsi:type="XTextTableCell" StyleIndex="3">
                      <Attributes />
                      <ID>03</ID>
                      <Expressions />
                      <ScriptItems />
                      <XElements>
                        <Element xsi:type="XString" StyleIndex="9">
                          <Text>+</Text>
                        </Element>
                        <Element xsi:type="XParagraphFlag" StyleIndex="8" />
                      </XElements>
                      <RuntimeMoveFocusHotKey>Tab</RuntimeMoveFocusHotKey>
                    </Element>
                    <Element xsi:type="XTextTableCell" StyleIndex="3">
                      <Attributes />
                      <ID>04</ID>
                      <Expressions />
                      <ScriptItems />
                      <XElements>
                        <Element xsi:type="XString" StyleIndex="9">
                          <Text>-</Text>
                        </Element>
                        <Element xsi:type="XParagraphFlag" StyleIndex="8" />
                      </XElements>
                      <RuntimeMoveFocusHotKey>Tab</RuntimeMoveFocusHotKey>
                    </Element>
                    <Element xsi:type="XTextTableCell" StyleIndex="3">
                      <Attributes />
                      <ID>05</ID>
                      <Expressions />
                      <ScriptItems />
                      <XElements>
                        <Element xsi:type="XString" StyleIndex="9">
                          <Text>-</Text>
                        </Element>
                        <Element xsi:type="XParagraphFlag" StyleIndex="8" />
                      </XElements>
                      <RuntimeMoveFocusHotKey>Tab</RuntimeMoveFocusHotKey>
                    </Element>
                    <Element xsi:type="XTextTableCell" StyleIndex="3">
                      <Attributes />
                      <ID>06</ID>
                      <Expressions />
                      <ScriptItems />
                      <XElements>
                        <Element xsi:type="XString" StyleIndex="9">
                          <Text>-</Text>
                        </Element>
                        <Element xsi:type="XParagraphFlag" StyleIndex="8" />
                      </XElements>
                      <RuntimeMoveFocusHotKey>Tab</RuntimeMoveFocusHotKey>
                    </Element>
                    <Element xsi:type="XTextTableCell" StyleIndex="3">
                      <Attributes />
                      <ID>07</ID>
                      <Expressions />
                      <ScriptItems />
                      <XElements>
                        <Element xsi:type="XString" StyleIndex="9">
                          <Text>+</Text>
                        </Element>
                        <Element xsi:type="XParagraphFlag" StyleIndex="8" />
                      </XElements>
                      <RuntimeMoveFocusHotKey>Tab</RuntimeMoveFocusHotKey>
                    </Element>
                    <Element xsi:type="XTextTableCell" StyleIndex="3">
                      <Attributes />
                      <ID>08</ID>
                      <Expressions />
                      <ScriptItems />
                      <XElements>
                        <Element xsi:type="XString" StyleIndex="9">
                          <Text>-</Text>
                        </Element>
                        <Element xsi:type="XParagraphFlag" StyleIndex="8" />
                      </XElements>
                      <RuntimeMoveFocusHotKey>Tab</RuntimeMoveFocusHotKey>
                    </Element>
                    <Element xsi:type="XTextTableCell" StyleIndex="3">
                      <Attributes />
                      <ID>09</ID>
                      <Expressions />
                      <ScriptItems />
                      <XElements>
                        <Element xsi:type="XString" StyleIndex="9">
                          <Text>-</Text>
                        </Element>
                        <Element xsi:type="XParagraphFlag" StyleIndex="8" />
                      </XElements>
                      <RuntimeMoveFocusHotKey>Tab</RuntimeMoveFocusHotKey>
                    </Element>
                    <Element xsi:type="XTextTableCell" StyleIndex="3">
                      <Attributes />
                      <ID>10</ID>
                      <Expressions />
                      <ScriptItems />
                      <XElements>
                        <Element xsi:type="XString" StyleIndex="9">
                          <Text>+</Text>
                        </Element>
                        <Element xsi:type="XParagraphFlag" StyleIndex="8" />
                      </XElements>
                      <RuntimeMoveFocusHotKey>Tab</RuntimeMoveFocusHotKey>
                    </Element>
                    <Element xsi:type="XTextTableCell" StyleIndex="3">
                      <Attributes />
                      <ID>11</ID>
                      <Expressions />
                      <ScriptItems />
                      <XElements>
                        <Element xsi:type="XString" StyleIndex="9">
                          <Text>1、2</Text>
                        </Element>
                        <Element xsi:type="XParagraphFlag" StyleIndex="8" />
                      </XElements>
                      <RuntimeMoveFocusHotKey>Tab</RuntimeMoveFocusHotKey>
                    </Element>
                    <Element xsi:type="XTextTableCell" StyleIndex="3">
                      <Attributes />
                      <ID>12</ID>
                      <Expressions />
                      <ScriptItems />
                      <XElements>
                        <Element xsi:type="XString" StyleIndex="9">
                          <Text>0</Text>
                        </Element>
                        <Element xsi:type="XParagraphFlag" StyleIndex="8" />
                      </XElements>
                      <RuntimeMoveFocusHotKey>Tab</RuntimeMoveFocusHotKey>
                    </Element>
                    <Element xsi:type="XTextTableCell" StyleIndex="3">
                      <Attributes />
                      <ID>13</ID>
                      <Expressions />
                      <ScriptItems />
                      <XElements>
                        <Element xsi:type="XString" StyleIndex="9">
                          <Text>测试记录</Text>
                        </Element>
                        <Element xsi:type="XParagraphFlag" StyleIndex="8" />
                      </XElements>
                      <RuntimeMoveFocusHotKey>Tab</RuntimeMoveFocusHotKey>
                    </Element>
                  </XElements>
                  <SpecifyHeight>125</SpecifyHeight>
                  <CloneType>Complete</CloneType>
                </Element>
                <Element xsi:type="XTextTableRow">
                  <Attributes />
                  <ID />
                  <Expressions />
                  <ScriptItems />
                  <EventTemplateName />
                  <XElements>
                    <Element xsi:type="XTextTableCell" StyleIndex="3">
                      <Attributes />
                      <ID>01</ID>
                      <Expressions />
                      <ScriptItems />
                      <XElements>
                        <Element xsi:type="XString" StyleIndex="9">
                          <Text>2024-01-29</Text>
                        </Element>
                        <Element xsi:type="XParagraphFlag" StyleIndex="8" />
                      </XElements>
                      <RuntimeMoveFocusHotKey>Tab</RuntimeMoveFocusHotKey>
                      <Title>A</Title>
                    </Element>
                    <Element xsi:type="XTextTableCell" StyleIndex="3">
                      <Attributes />
                      <ID>02</ID>
                      <Expressions />
                      <ScriptItems />
                      <XElements>
                        <Element xsi:type="XString" StyleIndex="8">
                          <Text>+</Text>
                        </Element>
                        <Element xsi:type="XParagraphFlag" StyleIndex="8" />
                      </XElements>
                      <MoveFocusHotKey>Enter</MoveFocusHotKey>
                      <RuntimeMoveFocusHotKey>Enter</RuntimeMoveFocusHotKey>
                    </Element>
                    <Element xsi:type="XTextTableCell" StyleIndex="3">
                      <Attributes />
                      <ID>03</ID>
                      <Expressions />
                      <ScriptItems />
                      <XElements>
                        <Element xsi:type="XString" StyleIndex="8">
                          <Text>-</Text>
                        </Element>
                        <Element xsi:type="XParagraphFlag" StyleIndex="8" />
                      </XElements>
                      <RuntimeMoveFocusHotKey>Tab</RuntimeMoveFocusHotKey>
                    </Element>
                    <Element xsi:type="XTextTableCell" StyleIndex="3">
                      <Attributes />
                      <ID>04</ID>
                      <Expressions />
                      <ScriptItems />
                      <XElements>
                        <Element xsi:type="XString" StyleIndex="9">
                          <Text>-</Text>
                        </Element>
                        <Element xsi:type="XParagraphFlag" StyleIndex="8" />
                      </XElements>
                      <RuntimeMoveFocusHotKey>Tab</RuntimeMoveFocusHotKey>
                    </Element>
                    <Element xsi:type="XTextTableCell" StyleIndex="3">
                      <Attributes />
                      <ID>05</ID>
                      <Expressions />
                      <ScriptItems />
                      <XElements>
                        <Element xsi:type="XString" StyleIndex="8">
                          <Text>+</Text>
                        </Element>
                        <Element xsi:type="XParagraphFlag" StyleIndex="8" />
                      </XElements>
                      <RuntimeMoveFocusHotKey>Tab</RuntimeMoveFocusHotKey>
                    </Element>
                    <Element xsi:type="XTextTableCell" StyleIndex="3">
                      <Attributes />
                      <ID>06</ID>
                      <Expressions />
                      <ScriptItems />
                      <XElements>
                        <Element xsi:type="XString" StyleIndex="9">
                          <Text>-</Text>
                        </Element>
                        <Element xsi:type="XParagraphFlag" StyleIndex="8" />
                      </XElements>
                      <RuntimeMoveFocusHotKey>Tab</RuntimeMoveFocusHotKey>
                    </Element>
                    <Element xsi:type="XTextTableCell" StyleIndex="3">
                      <Attributes />
                      <ID>07</ID>
                      <Expressions />
                      <ScriptItems />
                      <XElements>
                        <Element xsi:type="XString" StyleIndex="9">
                          <Text>+</Text>
                        </Element>
                        <Element xsi:type="XParagraphFlag" StyleIndex="8" />
                      </XElements>
                      <RuntimeMoveFocusHotKey>Tab</RuntimeMoveFocusHotKey>
                    </Element>
                    <Element xsi:type="XTextTableCell" StyleIndex="3">
                      <Attributes />
                      <ID>08</ID>
                      <Expressions />
                      <ScriptItems />
                      <XElements>
                        <Element xsi:type="XString" StyleIndex="9">
                          <Text>-</Text>
                        </Element>
                        <Element xsi:type="XParagraphFlag" StyleIndex="8" />
                      </XElements>
                      <RuntimeMoveFocusHotKey>Tab</RuntimeMoveFocusHotKey>
                    </Element>
                    <Element xsi:type="XTextTableCell" StyleIndex="3">
                      <Attributes />
                      <ID>09</ID>
                      <Expressions />
                      <ScriptItems />
                      <XElements>
                        <Element xsi:type="XString" StyleIndex="9">
                          <Text>-</Text>
                        </Element>
                        <Element xsi:type="XParagraphFlag" StyleIndex="8" />
                      </XElements>
                      <RuntimeMoveFocusHotKey>Tab</RuntimeMoveFocusHotKey>
                    </Element>
                    <Element xsi:type="XTextTableCell" StyleIndex="3">
                      <Attributes />
                      <ID>10</ID>
                      <Expressions />
                      <ScriptItems />
                      <XElements>
                        <Element xsi:type="XString" StyleIndex="9">
                          <Text>+</Text>
                        </Element>
                        <Element xsi:type="XParagraphFlag" StyleIndex="8" />
                      </XElements>
                      <RuntimeMoveFocusHotKey>Tab</RuntimeMoveFocusHotKey>
                    </Element>
                    <Element xsi:type="XTextTableCell" StyleIndex="3">
                      <Attributes />
                      <ID>11</ID>
                      <Expressions />
                      <ScriptItems />
                      <XElements>
                        <Element xsi:type="XString" StyleIndex="9">
                          <Text>1、2</Text>
                        </Element>
                        <Element xsi:type="XParagraphFlag" StyleIndex="8" />
                      </XElements>
                      <RuntimeMoveFocusHotKey>Tab</RuntimeMoveFocusHotKey>
                    </Element>
                    <Element xsi:type="XTextTableCell" StyleIndex="3">
                      <Attributes />
                      <ID>12</ID>
                      <Expressions />
                      <ScriptItems />
                      <XElements>
                        <Element xsi:type="XString" StyleIndex="9">
                          <Text>0</Text>
                        </Element>
                        <Element xsi:type="XParagraphFlag" StyleIndex="8" />
                      </XElements>
                      <RuntimeMoveFocusHotKey>Tab</RuntimeMoveFocusHotKey>
                    </Element>
                    <Element xsi:type="XTextTableCell" StyleIndex="3">
                      <Attributes />
                      <ID>13</ID>
                      <Expressions />
                      <ScriptItems />
                      <XElements>
                        <Element xsi:type="XString" StyleIndex="9">
                          <Text>测试记录</Text>
                        </Element>
                        <Element xsi:type="XParagraphFlag" StyleIndex="8" />
                      </XElements>
                      <RuntimeMoveFocusHotKey>Tab</RuntimeMoveFocusHotKey>
                    </Element>
                  </XElements>
                  <SpecifyHeight>125</SpecifyHeight>
                  <CloneType>Complete</CloneType>
                </Element>
              </XElements>
              <Deleteable>false</Deleteable>
              <CompressOwnerLineSpacing>true</CompressOwnerLineSpacing>
              <AllowUserToResizeColumns>false</AllowUserToResizeColumns>
              <Columns>
                <Element xsi:type="XTextTableColumn">
                  <Attributes />
                  <Width>270.896179</Width>
                </Element>
                <Element xsi:type="XTextTableColumn">
                  <Attributes />
                  <Width>153.200287</Width>
                </Element>
                <Element xsi:type="XTextTableColumn">
                  <Attributes />
                  <Width>169.439728</Width>
                </Element>
                <Element xsi:type="XTextTableColumn">
                  <Attributes />
                  <Width>159.2927</Width>
                </Element>
                <Element xsi:type="XTextTableColumn">
                  <Attributes />
                  <Width>183.425446</Width>
                </Element>
                <Element xsi:type="XTextTableColumn">
                  <Attributes />
                  <Width>140.175385</Width>
                </Element>
                <Element xsi:type="XTextTableColumn">
                  <Attributes />
                  <Width>127.326569</Width>
                </Element>
                <Element xsi:type="XTextTableColumn">
                  <Attributes />
                  <Width>110.082489</Width>
                </Element>
                <Element xsi:type="XTextTableColumn">
                  <Attributes />
                  <Width>156.741119</Width>
                </Element>
                <Element xsi:type="XTextTableColumn">
                  <Attributes />
                  <Width>136.945709</Width>
                </Element>
                <Element xsi:type="XTextTableColumn">
                  <Attributes />
                  <Width>198.7714</Width>
                </Element>
                <Element xsi:type="XTextTableColumn">
                  <Attributes />
                  <Width>200.796844</Width>
                </Element>
                <Element xsi:type="XTextTableColumn">
                  <Attributes />
                  <Width>214.906281</Width>
                </Element>
              </Columns>
            </Element>
          </XElements>
          <Deleteable>false</Deleteable>
          <BorderElementColor />
          <RuntimeBackgroundTextColor />
          <EventExpressions />
          <Name>11</Name>
          <InnerValue>       观察
      项目  
日期 
动作增加或减少
 与周围环境的联系 与他人的交往
 古怪动作或离奇行为
 违拗被动服从 冲动攻击行为
 木僵 坐立不安不停走动 自伤自杀行为  治疗   治疗
  情况    执行人 
2024-01-29 - + - - - + - - + 1、2 0 测试记录 
2024-01-29 + - - + - + - - + 1、2 0 测试记录 </InnerValue>
          <BackgroundText>11</BackgroundText>
          <EnableHighlight>Disabled</EnableHighlight>
          <FieldSettings />
        </Element>
        <Element xsi:type="XParagraphFlag" StyleIndex="5" />
      </XElements>
    </Element>
    <Element xsi:type="XTextHeader">
      <Attributes />
      <Expressions />
      <ScriptItems />
      <XElements>
        <Element xsi:type="XInputField" StyleIndex="2">
          <Attributes>
            <Attribute>
              <Name>内置</Name>
              <Value>1</Value>
            </Attribute>
            <Attribute>
              <Name>禁止导航</Name>
              <Value>1</Value>
            </Attribute>
            <Attribute>
              <Name>Innerable</Name>
              <Value>1</Value>
            </Attribute>
            <Attribute>
              <Name>Updatable</Name>
              <Value>0</Value>
            </Attribute>
          </Attributes>
          <ID>2</ID>
          <EnableValueValidate>true</EnableValueValidate>
          <ValueBinding>
            <DataSource>医院基本信息</DataSource>
            <BindingPath>医院名称</BindingPath>
          </ValueBinding>
          <Expressions />
          <ScriptItems />
          <XElements>
            <Element xsi:type="XString" StyleIndex="2">
              <Text>南雄康宁医院</Text>
            </Element>
          </XElements>
          <Deleteable>false</Deleteable>
          <BorderElementColor />
          <RuntimeBackgroundTextColor />
          <EventExpressions />
          <UserEditable>false</UserEditable>
          <Name>医院名称</Name>
          <InnerValue>XXX医院</InnerValue>
          <BackgroundText>医院名称</BackgroundText>
          <EnableHighlight>Disabled</EnableHighlight>
          <FieldSettings />
        </Element>
        <Element xsi:type="XParagraphFlag" StyleIndex="1" />
        <Element xsi:type="XString" StyleIndex="2">
          <Text>行为观察与治疗记录单</Text>
        </Element>
        <Element xsi:type="XParagraphFlag" StyleIndex="1" />
        <Element xsi:type="XString" StyleIndex="4">
          <Text>科室</Text>
        </Element>
        <Element xsi:type="XString">
          <Text>:</Text>
        </Element>
        <Element xsi:type="XInputField" StyleIndex="0">
          <Attributes>
            <Attribute>
              <Name>内置</Name>
              <Value>1</Value>
            </Attribute>
            <Attribute>
              <Name>禁止导航</Name>
              <Value>1</Value>
            </Attribute>
            <Attribute>
              <Name>Innerable</Name>
              <Value>1</Value>
            </Attribute>
            <Attribute>
              <Name>Updatable</Name>
              <Value>0</Value>
            </Attribute>
          </Attributes>
          <ID>50</ID>
          <EnableValueValidate>true</EnableValueValidate>
          <ValueBinding>
            <DataSource>病历书写信息</DataSource>
            <BindingPath>科室</BindingPath>
          </ValueBinding>
          <Expressions />
          <ScriptItems />
          <XElements>
            <Element xsi:type="XString" StyleIndex="0">
              <Text>住院二区</Text>
            </Element>
          </XElements>
          <Deleteable>false</Deleteable>
          <BorderElementColor />
          <RuntimeBackgroundTextColor />
          <EventExpressions />
          <UserEditable>false</UserEditable>
          <Name>科室</Name>
          <InnerValue>住院二区</InnerValue>
          <BackgroundText>科室</BackgroundText>
          <EnableHighlight>Disabled</EnableHighlight>
          <FieldSettings />
        </Element>
        <Element xsi:type="XString" WhiteSpaceLength="1">
          <Text />
        </Element>
        <Element xsi:type="XString" StyleIndex="4">
          <Text>床号</Text>
        </Element>
        <Element xsi:type="XString">
          <Text>:</Text>
        </Element>
        <Element xsi:type="XInputField" StyleIndex="0">
          <Attributes>
            <Attribute>
              <Name>内置</Name>
              <Value>1</Value>
            </Attribute>
            <Attribute>
              <Name>禁止导航</Name>
              <Value>1</Value>
            </Attribute>
            <Attribute>
              <Name>Innerable</Name>
              <Value>1</Value>
            </Attribute>
            <Attribute>
              <Name>Updatable</Name>
              <Value>0</Value>
            </Attribute>
          </Attributes>
          <ID>51</ID>
          <EnableValueValidate>true</EnableValueValidate>
          <ValueBinding>
            <DataSource>病历书写信息</DataSource>
            <BindingPath>床号</BindingPath>
          </ValueBinding>
          <Expressions />
          <ScriptItems />
          <XElements>
            <Element xsi:type="XString" StyleIndex="0">
              <Text>001</Text>
            </Element>
          </XElements>
          <Deleteable>false</Deleteable>
          <BorderElementColor />
          <RuntimeBackgroundTextColor />
          <EventExpressions />
          <UserEditable>false</UserEditable>
          <Name>床号</Name>
          <InnerValue>001</InnerValue>
          <BackgroundText>床号</BackgroundText>
          <EnableHighlight>Disabled</EnableHighlight>
          <FieldSettings />
        </Element>
        <Element xsi:type="XString" WhiteSpaceLength="1">
          <Text />
        </Element>
        <Element xsi:type="XString" StyleIndex="4">
          <Text>姓名</Text>
        </Element>
        <Element xsi:type="XString">
          <Text>:</Text>
        </Element>
        <Element xsi:type="XInputField" StyleIndex="0">
          <Attributes>
            <Attribute>
              <Name>内置</Name>
              <Value>1</Value>
            </Attribute>
            <Attribute>
              <Name>禁止导航</Name>
              <Value>1</Value>
            </Attribute>
            <Attribute>
              <Name>Innerable</Name>
              <Value>1</Value>
            </Attribute>
            <Attribute>
              <Name>Updatable</Name>
              <Value>0</Value>
            </Attribute>
          </Attributes>
          <ID>7</ID>
          <EnableValueValidate>true</EnableValueValidate>
          <ValueBinding>
            <DataSource>病人基本信息</DataSource>
            <BindingPath>病人姓名</BindingPath>
          </ValueBinding>
          <Expressions />
          <ScriptItems />
          <XElements>
            <Element xsi:type="XString" StyleIndex="0">
              <Text>袁远生</Text>
            </Element>
          </XElements>
          <Deleteable>false</Deleteable>
          <BorderElementColor />
          <RuntimeBackgroundTextColor />
          <EventExpressions />
          <UserEditable>false</UserEditable>
          <Name>病人姓名</Name>
          <InnerValue>袁远生</InnerValue>
          <BackgroundText>病人姓名</BackgroundText>
          <EnableHighlight>Disabled</EnableHighlight>
          <FieldSettings />
        </Element>
        <Element xsi:type="XString" WhiteSpaceLength="1">
          <Text />
        </Element>
        <Element xsi:type="XString" StyleIndex="4">
          <Text>性别</Text>
        </Element>
        <Element xsi:type="XString">
          <Text>:</Text>
        </Element>
        <Element xsi:type="XInputField" StyleIndex="0">
          <Attributes>
            <Attribute>
              <Name>内置</Name>
              <Value>1</Value>
            </Attribute>
            <Attribute>
              <Name>禁止导航</Name>
              <Value>1</Value>
            </Attribute>
            <Attribute>
              <Name>Innerable</Name>
              <Value>1</Value>
            </Attribute>
            <Attribute>
              <Name>Updatable</Name>
              <Value>0</Value>
            </Attribute>
          </Attributes>
          <ID>8</ID>
          <EnableValueValidate>true</EnableValueValidate>
          <ValueBinding>
            <DataSource>病人基本信息</DataSource>
            <BindingPath>性别</BindingPath>
          </ValueBinding>
          <Expressions />
          <ScriptItems />
          <XElements>
            <Element xsi:type="XString" StyleIndex="0">
              <Text>男性</Text>
            </Element>
          </XElements>
          <Deleteable>false</Deleteable>
          <BorderElementColor />
          <RuntimeBackgroundTextColor />
          <EventExpressions />
          <UserEditable>false</UserEditable>
          <Name>性别</Name>
          <InnerValue>男性</InnerValue>
          <BackgroundText>性别</BackgroundText>
          <EnableHighlight>Disabled</EnableHighlight>
          <FieldSettings />
        </Element>
        <Element xsi:type="XString" WhiteSpaceLength="1">
          <Text />
        </Element>
        <Element xsi:type="XString" StyleIndex="4">
          <Text>年龄</Text>
        </Element>
        <Element xsi:type="XString">
          <Text>:</Text>
        </Element>
        <Element xsi:type="XInputField" StyleIndex="0">
          <Attributes>
            <Attribute>
              <Name>内置</Name>
              <Value>1</Value>
            </Attribute>
            <Attribute>
              <Name>禁止导航</Name>
              <Value>1</Value>
            </Attribute>
            <Attribute>
              <Name>Innerable</Name>
              <Value>1</Value>
            </Attribute>
            <Attribute>
              <Name>Updatable</Name>
              <Value>0</Value>
            </Attribute>
          </Attributes>
          <ID>9</ID>
          <EnableValueValidate>true</EnableValueValidate>
          <ValueBinding>
            <DataSource>病人基本信息</DataSource>
            <BindingPath>年龄</BindingPath>
          </ValueBinding>
          <Expressions />
          <ScriptItems />
          <XElements>
            <Element xsi:type="XString" StyleIndex="0">
              <Text>35岁</Text>
            </Element>
          </XElements>
          <Deleteable>false</Deleteable>
          <BorderElementColor />
          <RuntimeBackgroundTextColor />
          <EventExpressions />
          <UserEditable>false</UserEditable>
          <Name>年龄</Name>
          <InnerValue>35岁</InnerValue>
          <BackgroundText>年龄</BackgroundText>
          <EnableHighlight>Disabled</EnableHighlight>
          <FieldSettings />
        </Element>
        <Element xsi:type="XString" WhiteSpaceLength="1">
          <Text />
        </Element>
        <Element xsi:type="XString" StyleIndex="4">
          <Text>住院号</Text>
        </Element>
        <Element xsi:type="XString">
          <Text>:</Text>
        </Element>
        <Element xsi:type="XInputField" StyleIndex="0">
          <Attributes>
            <Attribute>
              <Name>内置</Name>
              <Value>1</Value>
            </Attribute>
            <Attribute>
              <Name>禁止导航</Name>
              <Value>1</Value>
            </Attribute>
            <Attribute>
              <Name>Innerable</Name>
              <Value>1</Value>
            </Attribute>
            <Attribute>
              <Name>Updatable</Name>
              <Value>0</Value>
            </Attribute>
          </Attributes>
          <ID>5</ID>
          <EnableValueValidate>true</EnableValueValidate>
          <ValueBinding>
            <DataSource>病人基本信息</DataSource>
            <BindingPath>病历号</BindingPath>
          </ValueBinding>
          <Expressions />
          <ScriptItems />
          <XElements>
            <Element xsi:type="XString" StyleIndex="0">
              <Text>0000202</Text>
            </Element>
          </XElements>
          <Deleteable>false</Deleteable>
          <BorderElementColor />
          <RuntimeBackgroundTextColor />
          <EventExpressions />
          <UserEditable>false</UserEditable>
          <Name>病历号</Name>
          <InnerValue>0000202</InnerValue>
          <BackgroundText>病历号</BackgroundText>
          <EnableHighlight>Disabled</EnableHighlight>
          <FieldSettings />
        </Element>
        <Element xsi:type="XString" WhiteSpaceLength="1">
          <Text />
        </Element>
        <Element xsi:type="XString" StyleIndex="4">
          <Text>入院日期</Text>
        </Element>
        <Element xsi:type="XString">
          <Text>:</Text>
        </Element>
        <Element xsi:type="XInputField" StyleIndex="0">
          <Attributes>
            <Attribute>
              <Name>内置</Name>
              <Value>1</Value>
            </Attribute>
            <Attribute>
              <Name>禁止导航</Name>
              <Value>1</Value>
            </Attribute>
            <Attribute>
              <Name>Innerable</Name>
              <Value>1</Value>
            </Attribute>
            <Attribute>
              <Name>Updatable</Name>
              <Value>0</Value>
            </Attribute>
          </Attributes>
          <ID>28</ID>
          <EnableValueValidate>true</EnableValueValidate>
          <ValueBinding>
            <DataSource>病人基本信息</DataSource>
            <BindingPath>入院日期时间</BindingPath>
          </ValueBinding>
          <VisibleExpression />
          <ValueExpression />
          <Expressions />
          <ScriptItems />
          <XElements>
            <Element xsi:type="XString" StyleIndex="0">
              <Text>2023年08月21日</Text>
            </Element>
          </XElements>
          <Deleteable>false</Deleteable>
          <BorderElementColor />
          <RuntimeBackgroundTextColor />
          <EventExpressions />
          <UserEditable>false</UserEditable>
          <Name>入院日期时间</Name>
          <DisplayFormat>
            <Style>DateTime</Style>
            <Format>yyyy年MM月dd日</Format>
          </DisplayFormat>
          <InnerValue>2023年08月21日</InnerValue>
          <BackgroundText>入院日期时间</BackgroundText>
          <EnableHighlight>Disabled</EnableHighlight>
          <FieldSettings />
        </Element>
        <Element xsi:type="XString" WhiteSpaceLength="2">
          <Text />
        </Element>
        <Element xsi:type="XParagraphFlag" />
      </XElements>
    </Element>
    <Element xsi:type="XTextFooter">
      <Attributes />
      <Expressions />
      <ScriptItems />
      <XElements>
        <Element xsi:type="XString" StyleIndex="5">
          <Text>注:观察项目为有、无(+、-);治疗为药物治疗、心理治疗、康复治疗(1、2、3);</Text>
        </Element>
        <Element xsi:type="XLineBreak" />
        <Element xsi:type="XString" StyleIndex="5">
          <Text>治疗情况为加重、同前、好转、显效(+,0,1,2)。</Text>
        </Element>
        <Element xsi:type="XParagraphFlag" StyleIndex="5" />
        <Element xsi:type="XPageInfo" StyleIndex="0">
          <Attributes />
          <ScriptItems />
          <Width>100</Width>
          <AutoHeight>true</AutoHeight>
          <Height>52.27864</Height>
          <FormatString />
          <SpecifyPageIndexTextList />
        </Element>
        <Element xsi:type="XString">
          <Text>/</Text>
        </Element>
        <Element xsi:type="XPageInfo" StyleIndex="0">
          <Attributes />
          <ScriptItems />
          <Width>100</Width>
          <AutoHeight>true</AutoHeight>
          <Height>52.27864</Height>
          <ValueType>NumOfPages</ValueType>
          <FormatString />
          <SpecifyPageIndexTextList />
        </Element>
        <Element xsi:type="XParagraphFlag" StyleIndex="1" />
      </XElements>
    </Element>
  </XElements>
  <FileName>C:\Users\Administrator.DESKTOP-VUAH91B\Desktop\行为观察与治疗记录单.xml</FileName>
  <FileFormat>XML</FileFormat>
  <RepeatedImages />
  <GlobalJavaScriptReferences />
  <Info>
    <LicenseText>深圳科技有限公司:编辑器</LicenseText>
    <CreationTime>1980-01-01T00:00:00</CreationTime>
    <LastModifiedTime>2022-04-22T22:15:35.9327818+08:00</LastModifiedTime>
    <LastPrintTime>1980-01-01T00:00:00</LastPrintTime>
    <Operator>DCSoft.Writer Version:1.2015.3.25</Operator>
    <NumOfPage>1</NumOfPage>
  </Info>
  <BodyText>       观察
      项目  
日期 
动作增加或减少
 与周围环境的联系 与他人的交往
 古怪动作或离奇行为
 违拗被动服从 冲动攻击行为
 木僵 坐立不安不停走动 自伤自杀行为  治疗   治疗
  情况    执行人 
2024-01-29 - + - - - + - - + 1、2 0 测试记录 
2024-01-29 + - - + - + - - + 1、2 0 测试记录 </BodyText>
  <Comments />
  <LocalConfig />
  <PageSettings>
    <PageIndexsForHideHeaderFooter />
    <PrinterName />
    <PaperSource />
    <HeaderDistance>77</HeaderDistance>
    <FooterDistance>35</FooterDistance>
    <LeftMargin>38</LeftMargin>
    <TopMargin>18</TopMargin>
    <RightMargin>38</RightMargin>
    <BottomMargin>18</BottomMargin>
  </PageSettings>
  <Parameters>
    <Parameter Name="医院基本信息" />
    <Parameter Name="病人基本信息" />
    <Parameter Name="病历书写信息" />
  </Parameters>
  <ContentStyles>
    <Default xsi:type="DocumentContentStyle">
      <FontName>宋体</FontName>
      <FontSize>11</FontSize>
    </Default>
    <Styles>
      <Style Index="0">
        <FontName>宋体</FontName>
        <FontSize>10</FontSize>
      </Style>
      <Style Index="1">
        <FontName>宋体</FontName>
        <FontSize>10</FontSize>
        <Align>Center</Align>
      </Style>
      <Style Index="2">
        <FontName>宋体</FontName>
        <FontSize>14.25</FontSize>
        <Bold>true</Bold>
        <Align>Center</Align>
      </Style>
      <Style Index="3">
        <FontName>宋体</FontName>
        <FontSize>10</FontSize>
        <VerticalAlign>Middle</VerticalAlign>
        <BorderWidth>1</BorderWidth>
        <BorderLeft>true</BorderLeft>
        <BorderBottom>true</BorderBottom>
        <BorderTop>true</BorderTop>
        <BorderRight>true</BorderRight>
        <PaddingLeft>15</PaddingLeft>
        <PaddingTop>10</PaddingTop>
        <PaddingRight>15</PaddingRight>
        <PaddingBottom>10</PaddingBottom>
      </Style>
      <Style Index="4">
        <FontName>宋体</FontName>
        <FontSize>10</FontSize>
        <Bold>true</Bold>
      </Style>
      <Style Index="5">
        <FontName>宋体</FontName>
        <FontSize>12</FontSize>
      </Style>
      <Style Index="6">
        <FontName>新宋体</FontName>
        <FontSize>9.75</FontSize>
        <Bold>true</Bold>
        <Align>Center</Align>
      </Style>
      <Style Index="7">
        <FontName>新宋体</FontName>
        <FontSize>9.75</FontSize>
        <Bold>true</Bold>
      </Style>
      <Style Index="8">
        <FontName>新宋体</FontName>
        <FontSize>9.75</FontSize>
        <Align>Center</Align>
      </Style>
      <Style Index="9">
        <FontName>新宋体</FontName>
        <FontSize>9.75</FontSize>
        <Align>Center</Align>
        <CreatorIndex>0</CreatorIndex>
      </Style>
    </Styles>
  </ContentStyles>
  <UserHistories>
    <History>
      <ID>22</ID>
      <Name>管理员</Name>
      <SavedTime>2024-01-30T08:45:12.2357749+08:00</SavedTime>
      <PermissionLevel>5</PermissionLevel>
    </History>
  </UserHistories>
</XTextDocument>

 

...全文
64 回复 打赏 收藏 转发到动态 举报
写回复
用AI写文章
回复
切换为时间正序
请发表友善的回复…
发表回复

25

社区成员

发帖
与我相关
我的任务
社区描述
专注数据相关领域,分享MySQL,数据分析,Python,Linux,大数据相关技术内容。
数据库sql数据库开发 个人社区 广东省·广州市
社区管理员
  • SQL数据库开发
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧