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
});
}
