c# - Linq 和 ASP.NET MVC : Order data from latest to previous

Question

 internal static IQueryable<TimeReviewDataModel> GetGridDetails(DiscoLlamaEntities context, string actor)   
    {

        return (from t in context.TimeCaptures
                join jc in context.JobCards on t.JobCardID equals jc.ID into jcSub
                from jc in jcSub.DefaultIfEmpty()
                join cu in context.Companies on jc.CustomerID equals cu.ID into cuSub
                from tg in cuSub.DefaultIfEmpty()
                where (t.CreatedBy == actor)
                orderby t.Date descending
                select new TimeReviewDataModel
                {
                    ID = t.ID,
                    CustomerName = tg.Name,
                    Date = t.Date,
                    StartTime = t.StartTime,
                    EndTime = t.EndTime,
                    Description = t.Description,
                    Category = t.Category,
                    JobCardID = t.JobCardID,
                    VsoTask = t.VsoTaskID,
                    IsBillable = (bool)t.Billable
                })
                .OrderBy(e=>e.Date);
    }

您好，我正在尝试在网格中对我的数据进行排序。在顶部，我想要今天在网格下降时输入的数据，我想要之前添加的条目。目前它混合了条目。我想使用 Date 属性进行排序。

我正在使用 Linq 和 EntityFramework。

我的网格:

Answer 1

尝试以下操作:

return (from t in context.TimeCaptures
            join jc in context.JobCards on t.JobCardID equals jc.ID into jcSub
            from jc in jcSub.DefaultIfEmpty()
            join cu in context.Companies on jc.CustomerID equals cu.ID into cuSub
            from tg in cuSub.DefaultIfEmpty()
            where (t.CreatedBy == actor)
            //orderby t.Date descending
            select new TimeReviewDataModel
            {
                ID = t.ID,
                CustomerName = tg.Name,
                Date = t.Date,
                StartTime = t.StartTime,
                EndTime = t.EndTime,
                Description = t.Description,
                Category = t.Category,
                JobCardID = t.JobCardID,
                VsoTask = t.VsoTaskID,
                IsBillable = (bool)t.Billable
            })
            .OrderByDescending(e=>e.Date).ThenByDescending(e=>eStartTime);

因此，您在这里订购的是最终数据集，而不是中间数据集。