public PageModel <Finance_Transfer> GetFinance_TransferListInfo(QueryModel.Finance_TransferQuery fQuery) { int num = 0; IQueryable <Finance_Transfer> fp = context.Finance_Transfer.AsQueryable <Finance_Transfer>(); 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.Trans_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.Trans_Time <= dt select d; } } if (fQuery.userid != 0) {//用户编号 fp = from d in fp where d.Trans_UserId.Equals(fQuery.userid) || d.Trans_ToUserId.Equals(fQuery.userid) select d; } if (fQuery.usertype != 0) {//用户类型 fp = from d in fp where d.Trans_UserType.Equals(fQuery.usertype) || d.Trans_ToUserType.Equals(fQuery.usertype) select d; } if (fQuery.moneytype != 0) {//支付币种 fp = from d in fp where d.Trans_MoneyType.Equals(fQuery.moneytype) select d; } fp = fp.GetPage(out num, fQuery.PageNo, fQuery.PageSize, (IQueryable <Finance_Transfer> d) => from o in d orderby o.Trans_Time descending select o); return(new PageModel <Finance_Transfer>() { Models = fp, Total = num }); }
public PageModel <Finance_Transfer> GetFinance_TransferList_Statistics(QueryModel.Finance_TransferQuery fQuery) { int num = 0; IQueryable <Finance_Transfer> fp = context.Finance_Transfer.AsQueryable <Finance_Transfer>(); 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.Trans_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.Trans_Time <= dt select d; } } if (fQuery.moneytype != 0) {//支付币种 fp = from d in fp where d.Trans_MoneyType.Equals(fQuery.moneytype) select d; } var qq = from p in fp.ToList() group p by p.Trans_Time.ToString("yyyy-MM-dd") into g select new Finance_Transfer() { Trans_Time = DateTime.Parse(g.Key), Trans_MoneyType = g.Max(p => p.Trans_MoneyType), Trans_Money = g.Sum(p => p.Trans_Money), Trans_SXMoney = g.Sum(p => p.Trans_SXMoney) }; fp = qq.AsQueryable(); fp = fp.GetPage(out num, fQuery.PageNo, fQuery.PageSize, (IQueryable <Finance_Transfer> d) => from o in d orderby o.Trans_Time descending select o); return(new PageModel <Finance_Transfer>() { Models = fp, Total = num }); }