20251022 业绩查询增加当页合计和总的合计 完成

username@email.com

2025-10-23 a5354b47d90532af412abbe25d8d9c671d0dd023

 CY_ECommercePlatform/CY.SQLDAL/EC/EC_OrderDAL.cs

@@ -1589,6 +1589,22 @@

            fromSouce += " )as t   ";





            var ssss = _dataBase.SelectModel<Model.OA_DeliverPlan>("  sum(t.Contractmoney) as Contractmoney,sum(t.SumPrice) as SumPrice,sum(t.PayedMoney) as PayedMoney ", fromSouce);
            if (ssss.Count > 0)
            {
                var aaaaa = ssss.First();
                pagination.heji1 = aaaaa.Contractmoney ?? 0;
                pagination.heji2 = aaaaa.SumPrice ?? 0;
                pagination.heji3 = aaaaa.UnorderMoney ?? 0;
                pagination.heji4 = aaaaa.PayedMoney ?? 0;
                pagination.heji5 = aaaaa.UnPayedMoney;
            }


            var result = _dataBase.SelectModelPage<Model.OA_DeliverPlan>(pagination, selectTarget, fromSouce, " CreateTime DESC ");//执行查询
            return null == result ? null : result;//返回结果
        }