C# 两个linq查询语句结果集合并

最新推荐文章于 2023-06-01 08:37:11 发布

太阳的后裔

最新推荐文章于 2023-06-01 08:37:11 发布

阅读量1.4k

点赞数

分类专栏： C# 文章标签： linq c#

本文链接：https://blog.csdn.net/weixin_43942765/article/details/126517139

版权

C# 专栏收录该内容

69 篇文章 0 订阅

订阅专栏

C# 两个linq查询语句结果集合并

List<IntellManuSchool_TaskUserStatisticsV> onetasklstpro = new List<IntellManuSchool_TaskUserStatisticsV>();
foreach (var dpinfo in departmentlist)
{
    List<IntellManuSchool_TaskUserStatisticsV> ondepttask = tasklists.Where(t => t.DepartmentId == dpinfo.Id).OrderByDescending(t => t.BeginTime).ToList();
    if (ondepttask.Count > 0)
    {
        int deptrowspan = ondepttask.Count;
        var taskg = from t in ondepttask
                    select t.TaskId;
        List<int> taskidgroup = taskg.Distinct().ToList();
        foreach (int tid in taskidgroup)
        {
            List<IntellManuSchool_TaskUserStatisticsV> onetasklst = ondepttask.Where(t => t.TaskId == tid).OrderByDescending(t => t.BeginTime).ToList();
            foreach (var ut in onetasklst) {
                int sc = videorecordlist.Count(x => x.TaskId == ut.TaskId && x.UserId == ut.UserId && x.Finish == 1);
                ut.StudySectionCount = sc;
                //list.Add(new entity{id=1,name="小强"})此类语句小编也经常用到索性也记录此次之内好了
                onetasklstpro.Add(new IntellManuSchool_TaskUserStatisticsV { TaskName = ut.TaskName, DepartmentName=ut.DepartmentName,TaskStatus=ut.TaskStatus,BeginTime=ut.BeginTime,EndTime=ut.EndTime,SectionCount=ut.SectionCount,TaskId=ut.TaskId,UserId=ut.UserId,StudySectionCount= ut.StudySectionCount, DepartmentId=ut.DepartmentId });
            }
        }
    }
}
//两个linq要求不同的条件搜索所以要进行拆分，再合并
var view =
        from p in onetasklstpro
        where p.DepartmentId!=0//先对已经分配部门的结果进行排序
        orderby (p.DepartmentId)
        group p by new
        {
            p.TaskName,
            p.TaskId,
            p.DepartmentName,
            p.BeginTime,
            p.EndTime,
            p.TaskStatus,
            p.DepartmentId
        }
        into g
        select new
        {
            g.Key,
            jindu = StringFormat.ExecPercent((decimal)g.Sum(p => p.StudySectionCount), (decimal)g.Sum(p => p.SectionCount))
        };
var view2 =
        from p in onetasklstpro
        where p.DepartmentId == 0//最后将没有分配部门的数据补在最后
        orderby (p.DepartmentId)
        group p by new
        {
            p.TaskName,
            p.TaskId,
            p.DepartmentName,
            p.BeginTime,
            p.EndTime,
            p.TaskStatus,
            p.DepartmentId
        }
        into g
        select new
        {
            g.Key,
            jindu = StringFormat.ExecPercent((decimal)g.Sum(p => p.StudySectionCount), (decimal)g.Sum(p => p.SectionCount))
        };
var view3 = view.Union(view2);//Union将两个查询结果集合并
results = JsonHelper.ToJson(view3, "yyyy-MM-dd");
context.Response.Write(results);