public PageModel <Finance_WithDraw> GetFinance_WithDrawListInfo(QueryModel.Finance_WithDrawQuery fQuery) { int num = 0; IQueryable <Finance_WithDraw> fp = context.Finance_WithDraw.AsQueryable <Finance_WithDraw>(); 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.Withdraw_Time >= 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.Withdraw_Time <= dt select d; } } if (fQuery.userid != 0) {//用户编号 fp = from d in fp where d.Withdraw_UserId.Equals(fQuery.userid) select d; } if (fQuery.usertype != 0) {//用户类型 fp = from d in fp where d.Withdraw_UserType.Equals(fQuery.usertype) select d; } if (fQuery.moneytype != 0) {//支付币种 fp = from d in fp where d.Withdraw_MoneyType.Equals(fQuery.moneytype) select d; } fp = fp.GetPage(out num, fQuery.PageNo, fQuery.PageSize, (IQueryable <Finance_WithDraw> d) => from o in d orderby o.Withdraw_Time descending select o); return(new PageModel <Finance_WithDraw>() { Models = fp, Total = num }); }
public PageModel <Finance_WithDraw> GetFinance_WithDrawList_Statistics(QueryModel.Finance_WithDrawQuery fQuery) { int num = 0; IQueryable <Finance_WithDraw> fp = context.Finance_WithDraw.AsQueryable <Finance_WithDraw>(); 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.Withdraw_Time >= 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.Withdraw_Time <= dt select d; } } if (fQuery.moneytype != 0) {//支付币种 fp = from d in fp where d.Withdraw_MoneyType.Equals(fQuery.moneytype) select d; } var qq = from p in fp.ToList() group p by p.Withdraw_Time.ToString("yyyy-MM-dd") into g select new Finance_WithDraw() { Withdraw_Time = DateTime.Parse(g.Key), Withdraw_MoneyType = g.Max(p => p.Withdraw_MoneyType), Withdraw_Money = g.Sum(p => p.Withdraw_Money) }; fp = qq.AsQueryable(); fp = fp.GetPage(out num, fQuery.PageNo, fQuery.PageSize, (IQueryable <Finance_WithDraw> d) => from o in d orderby o.Withdraw_Time descending select o); return(new PageModel <Finance_WithDraw>() { Models = fp, Total = num }); }