SqlSugar数据查询去重

最新推荐文章于 2024-05-27 22:17:08 发布

古得猫腻

最新推荐文章于 2024-05-27 22:17:08 发布

阅读量1.3k

点赞数 2

分类专栏： SqlSugar 文章标签： sql mysql 数据库

本文链接：https://blog.csdn.net/weixin_44031194/article/details/129158785

版权

SqlSugar 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

SqlSugarHelper.StartSqlSugar(db =>
            {
                
                // db.Queryable<Order_Detail>().Take(1).PartitionBy(od => od.Carrier).ToList(); // 分组获取每组第一条
                // db.Queryable<Order_Detail>().OrderBy(od => od.Carrier, OrderByType.Desc).Take(1).PartitionBy(od => od.Carrier).ToList();

                int Count = 0;
                int Count = 0;
                P.StoreDeliveryLogInfo = db.Queryable<Client_Info,Order_Detail,Basics_ShopInfo>((ci,od,bci) => new object[] {
                    JoinType.Left,ci.ID == od.Client && ci.Valid == 1,
                    JoinType.Left,ci.Shop == bci.ID && ci.Valid == 1,
                })
                .Where((ci, od) => od.Valid == 1 && od.PlatForm == R.PlatForm)
                .WhereIF(R.Shop > 0, (ci, od, bci) => ci.Shop == R.Shop)
                .WhereIF(!String.IsNullOrEmpty(R.StartTime), (ci, od, bci) => od.CreateTime >= SqlFunc.ToDate(R.StartTime))
                .WhereIF(!String.IsNullOrEmpty(R.EndTime), (ci, od, bci) => od.CreateTime <= SqlFunc.ToDate(R.EndTime))
                .Select((ci, od, bci) => new OperationModel.ReturnSubsidiary.Report.StoreDeliveryLogInfo() { 
                    ID = ci.ID,
                    Shop = ci.Shop,
                    ShopName = bci.Name,
                    Client = ci.ID,
                    ClientName = ci.Name,
                    OrderId = od.ID,
                    CreateTime = MySqlFunc.ToDateTime(od.CreateTime, 120)
                })
                .Take(1).PartitionBy(ci => ci.ID) // 根据客户ID去重重复
                .ToPageList(R.Page, R.PageCount, ref Count);
                P.Count = Count;
            });