在linq中填充时间跨度 [英] populating time span in linq

问题描述

我得到了这个选择

I got this select

var qDuration = from rowU in DataAccess.metadata.um_User
                                join rowLC in DataAccess.metadata.um_CallLog
                                on rowU.userID equals rowLC.userID
                                group rowLC by new { userID = rowLC.userID } into groupN
                                select new
                                {
                                    userID = groupN.Key.userID,
                                    noOfCalls = groupN.Count(),

                                    totDurationSec = (from row in groupN
                                                      select row.Duration.Seconds).Sum(),
                                    totDurationMin = (from row in groupN
                                                      select row.Duration.Minutes).Sum(),
                                    totDurationHours = (from row in groupN
                                                      select row.Duration.Hours).Sum(),
                                    
                                };

现在我想用我在这个选项中所做的总和填充我的时间范围

now I wanna populate my time span with sums I did in this select

var qTime = new TimeSpan(1, 0, 0);
             string Dislay = qTime.ToString()

推荐答案

如果您已将小时，分钟和秒分开，请致电：

If you have separated the hours, minutes and seconds, just call:

<pre lang="cs">var qTime = new TimeSpan(HOURS, MINUTES, SECONDS);
                string Dislay = qTime.ToString()

这篇关于在linq中填充时间跨度的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！