public PageModel <Finance_Payment> GetFinance_PaymentListInfo(QueryModel.Finance_PaymentQuery fQuery) { int num = 0; IQueryable <Finance_Payment> fp = context.Finance_Payment.AsQueryable <Finance_Payment>(); if (!string.IsNullOrWhiteSpace(fQuery.starttime)) {//开始时间 DateTime dt; if (DateTime.TryParse(fQuery.starttime, out dt)) { dt = DateTime.Parse(fQuery.starttime); fp = from d in fp where d.PayMent_PayTime >= dt select d; } } if (!string.IsNullOrWhiteSpace(fQuery.endtime)) {//结束时间 DateTime dt; if (DateTime.TryParse(fQuery.endtime, out dt)) { dt = DateTime.Parse(fQuery.endtime); fp = from d in fp where d.PayMent_PayTime <= dt select d; } } if (fQuery.userid != 0) {//用户编号 fp = from d in fp where d.PayMent_UserId.Equals(fQuery.userid) select d; } if (fQuery.usertype != 0) {//用户类型 fp = from d in fp where d.PayMent_UserType.Equals(fQuery.usertype) select d; } if (fQuery.moneytype != 0) {//支付币种 fp = from d in fp where d.PayMent_MoneyType.Equals(fQuery.moneytype) select d; } fp = fp.GetPage(out num, fQuery.PageNo, fQuery.PageSize, (IQueryable <Finance_Payment> d) => from o in d orderby o.PayMent_PayTime descending select o); return(new PageModel <Finance_Payment>() { Models = fp, Total = num }); }
/// <summary> /// 平台支付信息统计 [chenqi 2016-03-29 17:06] /// </summary> /// <param name="fQuery"></param> /// <returns></returns> public PageModel <Finance_Payment> GetFinance_PaymentList_Statistics(QueryModel.Finance_PaymentQuery fQuery) { int num = 0; IQueryable <Finance_Payment> fp = context.Finance_Payment.AsQueryable <Finance_Payment>(); if (!string.IsNullOrWhiteSpace(fQuery.starttime)) {//开始时间 DateTime dt; if (DateTime.TryParse(fQuery.starttime, out dt)) { dt = DateTime.Parse(fQuery.starttime); fp = from d in fp where d.PayMent_PayTime >= dt select d; } } if (!string.IsNullOrWhiteSpace(fQuery.endtime)) {//结束时间 DateTime dt; if (DateTime.TryParse(fQuery.endtime, out dt)) { dt = DateTime.Parse(fQuery.endtime); fp = from d in fp where d.PayMent_PayTime <= dt select d; } } if (fQuery.moneytype != 0) {//支付币种 fp = from d in fp where d.PayMent_MoneyType.Equals(fQuery.moneytype) select d; } var qq = from p in fp.ToList() group p by p.PayMent_PayTime.ToString("yyyy-MM-dd") into g select new Finance_Payment() { PayMent_PayTime = DateTime.Parse(g.Key), PayMent_MoneyType = g.Max(p => p.PayMent_MoneyType), PayMent_PayMoney = g.Sum(p => p.PayMent_PayMoney), PayMent_SXMoney = g.Sum(p => p.PayMent_SXMoney), PayMent_YFMoney = g.Sum(p => p.PayMent_YFMoney), PayMent_BXMoney = g.Sum(p => p.PayMent_BXMoney), PayMent_JYMoney = g.Sum(p => p.PayMent_JYMoney) }; fp = qq.AsQueryable(); fp = fp.GetPage(out num, fQuery.PageNo, fQuery.PageSize, (IQueryable <Finance_Payment> d) => from o in d orderby o.PayMent_PayTime descending select o); return(new PageModel <Finance_Payment>() { Models = fp, Total = num }); }