优化查询

username@email.com

2022-09-21 6131316db2e61c717a6fbd1db774b41b60c933e9

 zhengcaioa/Services/AdmPieceCheckService.cs

@@ -199,7 +199,11 @@

            //if (searchEntity.totalrows == 0)
                searchEntity.totalrows = query.Count();
            data.Heji1 = Math.Round(query.Sum(x => x.Gongzi) ?? 0, 2);
            data.Heji2 = Math.Round(query.Sum(x => x.Shuliang ?? 0), 2);
            var lianlist = query.Skip((searchEntity.page - 1) * searchEntity.rows).Take(searchEntity.rows).ToList();
            data.DangyeHeji1 = Math.Round(lianlist.Sum(x => x.Gongzi) ?? 0, 2);
            data.DangyeHeji2 = Math.Round(lianlist.Sum(x => x.Shuliang ?? 0), 2);
            data.LoadData(searchEntity, lianlist);
            return data;
        }