阅读背景:

【笔记】DataTable或IList使用GroupBy方法的lamda表达式

来源:互联网 

DataTable GroupBy的用法

            var result = dt.AsEnumerable().
                GroupBy(g => new
                {
                    StaffID = g.Field<string>("StaffID"),
                    StaffName = g.Field<string>("StaffName"),
                    ActivityDate = g.Field<string>("ActivityDate")
                }).
                Select(n => new DailyRouteDisplayItem
                {
                    ActivityDate = n.Key.ActivityDate,
                    StaffID = n.Key.StaffID,
                    StaffName = n.Key.StaffName,
                    RouteList = n.Select(x => new RouteDisplayItem
                    {
                        StaffID = x["StaffID"].ToString(),
                        StaffName = x["StaffName"].ToString(),
                        ActivityID = x["ActivityID"].ToString(),
                        ActivityDate = x["ActivityDate"].ToString(),
                        CheckinType = x["CheckinType"].ToString(),
                        CheckinTime = x["CheckinTime"].ToString(),
                        CheckinLat = ConvertObject.ToDecimal(x["CheckinLat"]),
                        CheckinLng = ConvertObject.ToDecimal(x["CheckinLng"]),
                        CheckoutType = x["CheckoutType"].ToString(),
                        CheckoutTime = x["CheckoutTime"].ToString(),
                        CheckoutLat = ConvertObject.ToDecimal(x["CheckoutLat"]),
                        CheckoutLng = ConvertObject.ToDecimal(x["CheckoutLng"])
                    }).ToList()
                }).ToList();
            var resu



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: