在下面的XML字符串中...我需要生成所有标题的列表，以快速概览XML字符串中的各种数据元素。为此，我想从所有“标签”元素中找到所有“标题”属性的值。关于如何完成此操作的任何建议？
这是我正在使用的C＃代码的示例...
XmlDocument xDoc = new XmlDocument();
string captionField = string.Empty;
xDoc.Load(xmlFilePath);
foreach (XmlNode node in xDoc.DocumentElement.ChildNodes)
{
// first node is the url ... have to go to nexted loc node
foreach (XmlNode locNode in node)
{
// thereare a couple child nodes here so only take data from node named loc
if (locNode.Name == "Label")
{
foreach (XmlNode item in node.ChildNodes)
{
captionField = locNode.Attributes["Caption"].Value;
if(!String.IsNullOrEmpty(captionField))
WriteToFile(logiReportName + " - " + captionField, fileName, reportName);
}
}
}
}
xml数据：
<?xml version="1.0" encoding="utf-8"?>
<Report ID="GenericMissedOpportunity" SavedBy="" SavedAt="10/29/2015 3:47:23 PM" EngineVersion="12.0.036-SP3" SecurityReportRightID="Accounting">
<StyleSheet Theme="Clarity" />
<ReportHeader>
<Label Caption="Generic Missed Opportunity" Class="ThemeHeaderLarger" />
<LineBreak />
<Label Caption="This report shows transactions where a brand was used but a generic was available." />
<Spaces Size="10" />
<LineBreak />
<LineBreak />
<Division ID="divFilters">
<InputDate ID="idBeginDateRange" SaveInCookie="True" ShowDateRange="True" Caption="Begin Date" CalendarLinkType="Image" EndDateRangeID="idEndDateRange" EndDateRangeCaption="End Date" InputSize="7px" DefaultValue="@Cookie.idBeginDateRange~" EndDateDefaultValue="@Cookie.idEndDateRange~" />
<Spaces Size="10" />
<InputCheckboxList OptionCaptionColumn="AltName" ID="parmLocation" OptionValueColumn="IRXLocationId" Caption="Choose a Store " CaptionClass="ThemeAlignLeft" DefaultValue="@Cookie.parmLocation~" CheckboxListDropdown="True" MultiSelect="True" SaveInCookie="True" Tooltip="@Request.parmLocation~" IdeDisplayStatus="Collapsed">
<DataLayer Type="SQL" ID="dlLocation" ConnectionID="IntellectRX-DataWarehouse" Source="SELECT A.IRXLocationId, A.Name, A.AltName
FROM Dimension.Location A
WHERE A.AltName IS NOT NULL
 AND (CAST(A.ClientID AS VARCHAR(64)) = @SingleQuote.Session.ClientId~)
ORDER BY A.AltName" />
</InputCheckboxList>
<Spaces Size="10" />
<Button Caption="Create Report" ID="btnSubmit" IdeDisplayStatus="Collapsed">
<Action Type="RefreshElement" ID="arDivReportBody" ElementID="DivOuter" EnterKeyDefault="True">
<LinkParams parmShowDataTable="True" />
<WaitPage />
</Action>
</Button>
<Spaces Size="10" />
</Division>
<LineBreak />
<HR />
</ReportHeader>
<Body>
<Division ID="DivOuter">
<Division ID="divReportBody" Condition=""@Request.parmShowDataTable~" == "True"" HtmlDiv="True">
<Label Caption="Export CSV">
<Action Type="CSV" IdeDisplayStatus="Collapsed">
<Target Type="CSV" ExportFilename="GenericMissedOpportunity.csv" Report="GenericMissedOpportunity" />
<LinkParams parmShowDataTable="True" />
</Action>
</Label>
<DataTable SortArrows="True" ID="DataTable1" AjaxPaging="True" DraggableColumns="True" Layout="Auto" Width="100" WidthScale="%" KeepScrollPosition="True" RememberSort="True" ResizableColumns="True">
<DataLayer Type="SQL" ID="dlGenericMissedOpportunity" ConnectionID="IntellectRX-DataWarehouse" Source="select A.RxID, B.ItemId, B.ItemName, E.RXNumber, D.AltName, B.LabelTypeID, B.GCN, A.DawCodePostEditStatusTypeID, A.DateFilled, b.NDC, a.DawCodeID, C.PostEditStatusText,
 Generic = (select top 1 G.ItemName FROM [IntellectRX-DataWarehouse].Dimension.Item G WHERE B.GCN = G.GCN AND G.LabelTypeID = 1 and A.IRXLocationId = G.IRXLocationId )
 FROM [IntellectRX-DataWarehouse].Fact.RxTransaction A with (nolock)
 JOIN [IntellectRX-DataWarehouse].Dimension.Item B with (nolock) on A.DispensedItemID = B.ItemID AND a.IRXLocationId = B.IRXLocationId
 JOIN [IntellectRX-DataWarehouse].Dimension.Rx E with (nolock) on A.RxID = E.RxID AND A.IRXLocationId = E.IRXLocationId
 JOIN [IntellectRX-DataWarehouse].Dimension.Location D with (nolock) on A.IRXLocationId = D.IRXLocationId
 JOIN [IntellectRX-DataWarehouse].Dimension.PostEditStatusType C with (nolock) on A.DawCodePostEditStatusTypeID = C.PostEditStatusTypeID
 
 where B.LabelTypeID = 2 AND
 A.DawCodePostEditStatusTypeID > 0
 AND (CAST(A.ClientID AS VARCHAR(64)) = @SingleQuote.Session.ClientId~)
 AND (Cast(b.IRXLocationId As VARCHAR(64)) IN (@SingleQuote.Request.parmLocation~))
 AND A.DateFilled between @StartDate and @EndDate
 AND (select top 1 G.ItemName FROM [IntellectRX-DataWarehouse].Dimension.Item G WHERE B.GCN = G.GCN AND G.LabelTypeID = 1 and A.IRXLocationId = G.IRXLocationId) is not null
 ORDER BY D.AltName, DateFilled DESC" IdeDisplayStatus="Collapsed">
<SqlParameters>
<SqlParameter ID="StartDate" Value="@Request.idBeginDateRange~" SqlParamType="dt-133" />
<SqlParameter ID="EndDate" Value="@Request.idEndDateRange~" SqlParamType="dt-133" />
</SqlParameters>
</DataLayer>
<DataTableColumn ID="colStore" Header="Store" IdeDisplayStatus="Collapsed">
<Label ID="lblStore" Caption="@Data.AltName~" />
<DataColumnSort DataColumn="AltName" DataType="Text" />
</DataTableColumn>
<DataTableColumn ID="colRXNumber" Header="RX Number" IdeDisplayStatus="Collapsed">
<Label ID="lblRXnumber" Caption="@Data.RXNumber~" />
<DataColumnSort DataColumn="RXNumber" DataType="Text" />
</DataTableColumn>
<DataTableColumn ID="colDateFilled" Header="DateFilled" IdeDisplayStatus="Collapsed">
<Label ID="lblDateFilled" Caption="@Data.DateFilled~" Format="Short Date" />
<DataColumnSort DataColumn="DateFilled" DataType="Date" />
</DataTableColumn>
<DataTableColumn ID="colNDC" Header="NDC" IdeDisplayStatus="Collapsed">
<Label ID="lblNDC" Caption="@Data.NDC~" Format="00000-0000-00" />
<DataColumnSort DataColumn="NDC" />
</DataTableColumn>
<DataTableColumn ID="colGCN" Header="GCN" IdeDisplayStatus="Collapsed">
<Label ID="lblGCN" Caption="@Data.GCN~" />
<DataColumnSort DataColumn="GCN" />
</DataTableColumn>
<DataTableColumn ID="colPostEditStatusText" Header="Post Edit Status" IdeDisplayStatus="Collapsed">
<Label ID="lblPostEditStatusText" Caption="@Data.PostEditStatusText~" />
<DataColumnSort DataColumn="PostEditStatusText" />
</DataTableColumn>
<DataTableColumn ID="colDawCodeID" Header="DAW" IdeDisplayStatus="Collapsed">
<Label ID="lblDawCodeID" Caption="@Data.DawCodeID~" />
<DataColumnSort DataColumn="DawCodeID" DataType="Number" />
</DataTableColumn>
<DataTableColumn ID="colItemName" Header="Brand" IdeDisplayStatus="Collapsed">
<Label ID="lblItemName" Caption="@Data.ItemName~" />
<DataColumnSort DataColumn="ItemName" />
</DataTableColumn>
<DataTableColumn ID="colGeneric" Header="Generic" IdeDisplayStatus="Collapsed">
<Label ID="lblGeneric" Caption="@Data.Generic~" />
<DataColumnSort DataColumn="Generic" />
</DataTableColumn>
<InteractivePaging PageRowCount="250" ShowPageNumber="Numbered" Location="Top" HideShowPrevNextCaptions="True" CaptionType="Text" HideWhenOnePage="True" />
</DataTable>
</Division>
</Division>
</Body>
<ReportFooter />
<ideTestParams idBeginDateRange="" idEndDateRange="" parmLocation="" parmShowDataTable="" />
</Report>
为了简单起见，我建议您使用Linq to XML。
使用Linq To XML，您可以在导入System.Linq.Xml名称空间之后编写类似以下代码的简单代码：
var xDoc = XDocument.Load(xmlFilePath);
var captionValues = xDoc.Descendants("Label").Select(p => (string) p.Attribute("Caption")).ToList();
在captionValues变量中，您将Caption在Labelelement中的attribute上定义的所有值。使用此值集合，您可以执行所需的操作，例如将其写入文件。
本文收集自互联网，转载请注明来源。
如有侵权，请联系 [email protected] 删除。
我来说两句