基于属性的XML组 [英] XML Group By Based on Attributes

查看：60 发布时间：2019/6/16 3:20:07 xmlandnetfx

本文介绍了基于属性的XML组的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

嗨

从下面的XML结构我想基于TimeFrame属性进行分组，然后添加SuccessCount属性的值并有一个值。请找到

from the below XML structure I want to group by based on the TimeFrame Attribute , then later add the values of SuccessCount attribute and have one value . Please find the

XML结构如下

the XML structure is as below

< Users>

< User ID ="" 10""的LoginName = QUOT;" 222"" SuccessCount = QUOT;" 3英寸;" FailureCount = QUOT;" 2英寸;" LastAccessedTimeStamp ="" 1/1/2011 12:55:00 AM"" TimeFrame ="" 2011-01-01 00：00：00.000"" />

< User ID ="" 5""的LoginName = QUOT;"管理员"" SuccessCount = QUOT;" 7英寸;" FailureCount = QUOT;" 2英寸;" LastAccessedTimeStamp ="" 1/1/2011 12:49:00 AM"" TimeFrame =""" 2011-01-01 00：00：00.000"" />

< User ID ="" 9""的LoginName = QUOT;" 2222"" SuccessCount = QUOT;" 2英寸;" FailureCount = QUOT;" 8英寸;" LastAccessedTimeStamp ="" 1/1/2011 12:57:40 AM"" TimeFrame =""" 2011-01-01 00：00：00.000"" />

< User ID ="" 7""的LoginName = QUOT;" MSR2"" SuccessCount = QUOT;" 1 QUOT;" FailureCount = QUOT;" 3英寸;" LastAccessedTimeStamp ="" 1/1/2011 12:23:20 AM"" TimeFrame =""" 2011-01-01 00：00：00.000"" />

< User ID ="" 6""的LoginName = QUOT;" MSR1"" SuccessCount = QUOT;" 5英寸;" FailureCount = QUOT;" 3英寸;" LastAccessedTimeStamp ="" 1/1/2011 12:59:00 AM"" TimeFrame =""" 2011-01-01 00：01：00.000"" />

< User ID ="" 10""的LoginName = QUOT;" 222"" SuccessCount = QUOT;" 3英寸;" FailureCount = QUOT;" 2英寸;" LastAccessedTimeStamp ="" 1/1/2011 12:55:00 AM"" TimeFrame =""" 2011-01-01 00：01：00.000"" />

< User ID ="" 5""的LoginName = QUOT;"管理员"" SuccessCount = QUOT;" 7英寸;" FailureCount = QUOT;" 2英寸;" LastAccessedTimeStamp ="" 1/1/2011 12:49:00 AM"" TimeFrame ="" 2011-01-01 00：01：00.000"" />

< User ID ="" 9""的LoginName = QUOT;" 2222"" SuccessCount = QUOT;" 2英寸;" FailureCount = QUOT;" 8英寸;" LastAccessedTimeStamp ="" 1/1/2011 12:57:40 AM"" TimeFrame ="" 2011-01-01 00：01：00.000"" />

< User ID ="" 7""的LoginName = QUOT;" MSR2"" SuccessCount = QUOT;" 1 QUOT;" FailureCount = QUOT;" 3英寸;" LastAccessedTimeStamp ="" 1/1/2011 12:23:20 AM"" TimeFrame =""" 2011-01-01 00：01：00.000"" />

< User ID ="" 6""的LoginName = QUOT;" MSR1"" SuccessCount = QUOT;" 5英寸;" FailureCount = QUOT;" 3英寸;" LastAccessedTimeStamp ="" 1/1/2011 12:59:00 AM"" TimeFrame =""" 2011-01-01 00：01：00.000"" />

< / Users>

推荐答案

以下是使用LINQ to XML的分组示例（可在.NET 3.5及更高版本中使用）：

Here is a grouping example using LINQ to XML (available in .NET 3.5 and later):

            string xml = @"<Users>
  <User ID=""10"" LoginName=""222"" SuccessCount=""3"" FailureCount=""2"" LastAccessedTimeStamp=""1/1/2011 12:55:00 AM""  TimeFrame=""2011-01-01 00:00:00.000""/>
  <User ID=""5"" LoginName=""admin"" SuccessCount=""7"" FailureCount=""2"" LastAccessedTimeStamp=""1/1/2011 12:49:00 AM"" TimeFrame=""2011-01-01 00:00:00.000""/>
  <User ID=""9"" LoginName=""2222"" SuccessCount=""2"" FailureCount=""8"" LastAccessedTimeStamp=""1/1/2011 12:57:40 AM"" TimeFrame=""2011-01-01 00:00:00.000""/>
  <User ID=""7"" LoginName=""msr2"" SuccessCount=""1"" FailureCount=""3"" LastAccessedTimeStamp=""1/1/2011 12:23:20 AM"" TimeFrame=""2011-01-01 00:00:00.000""/>
  <User ID=""6"" LoginName=""msr1"" SuccessCount=""5"" FailureCount=""3"" LastAccessedTimeStamp=""1/1/2011 12:59:00 AM"" TimeFrame=""2011-01-01 00:01:00.000""/>
  <User ID=""10"" LoginName=""222"" SuccessCount=""3"" FailureCount=""2"" LastAccessedTimeStamp=""1/1/2011 12:55:00 AM"" TimeFrame=""2011-01-01 00:01:00.000""/>
  <User ID=""5"" LoginName=""admin"" SuccessCount=""7"" FailureCount=""2"" LastAccessedTimeStamp=""1/1/2011 12:49:00 AM"" TimeFrame=""2011-01-01 00:01:00.000"" />
  <User ID=""9"" LoginName=""2222"" SuccessCount=""2"" FailureCount=""8"" LastAccessedTimeStamp=""1/1/2011 12:57:40 AM"" TimeFrame=""2011-01-01 00:01:00.000"" />
  <User ID=""7"" LoginName=""msr2"" SuccessCount=""1"" FailureCount=""3"" LastAccessedTimeStamp=""1/1/2011 12:23:20 AM"" TimeFrame=""2011-01-01 00:01:00.000""/>
  <User ID=""6"" LoginName=""msr1"" SuccessCount=""5"" FailureCount=""3"" LastAccessedTimeStamp=""1/1/2011 12:59:00 AM"" TimeFrame=""2011-01-01 00:01:00.000""/>
</Users>";
            XDocument doc = XDocument.Parse(xml);

            var groups = from user in doc.Root.Elements("User")
                         group user by DateTimeOffset.Parse(user.Attribute("TimeFrame").Value.Replace(' ', 'T')) into g
                         select new
                         {
                             timeFrame = g.Key,
                             successCount = g.Attributes("SuccessCount").Sum(s => (int)s)
                         };

            foreach (var group in groups)
            {
                Console.WriteLine("TimeFrame: {0}; Count: {1}", group.timeFrame, group.successCount);
            }

这篇关于基于属性的XML组的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！

查看全文

基于属性的XML组 [英] XML Group By Based on Attributes

问题描述

推荐答案

相关文章

其他开发语言最新文章

热门教程

热门工具

登录关闭

基于属性的XML组 [英] XML Group By Based on Attributes

问题描述

推荐答案

相关文章

其他开发语言最新文章

热门教程

热门工具

登录 关闭

登录关闭