public PageModel <Finance_Refund> GetFinance_RefundList_Statistics(QueryModel.Finance_RefundQuery fQuery)
{
int num = 0;
IQueryable <Finance_Refund> fp = context.Finance_Refund.AsQueryable <Finance_Refund>();
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.Refund_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.Refund_Time <= dt
select d;
}
}
if (fQuery.moneytype != 0)
{//支付币种
fp =
from d in fp
where d.Refund_MoneyType.Equals(fQuery.moneytype)
select d;
}
var qq = from p in fp.ToList()
group p by p.Refund_Time.ToString("yyyy-MM-dd") into g
select new Finance_Refund()
{
Refund_Time = DateTime.Parse(g.Key),
Refund_MoneyType = g.Max(p => p.Refund_MoneyType),
Refund_Money = g.Sum(p => p.Refund_Money)
};
fp = qq.AsQueryable();
fp = fp.GetPage(out num, fQuery.PageNo, fQuery.PageSize, (IQueryable <Finance_Refund> d) =>
from o in d
orderby o.Refund_Time descending
select o);
return(new PageModel <Finance_Refund>()
{
Models = fp,
Total = num
});
}
public PageModel <Finance_Refund> GetFinance_RefundListInfo(QueryModel.Finance_RefundQuery fQuery)
{
int num = 0;
//IQueryable<Finance_Refund> fp = from a in context.Finance_Refund where a.Refund_Status != 1 && a.Refund_Status != 2 select a; old vesion
IQueryable <Finance_Refund> fp = from a in context.Finance_Refund select a;
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.Refund_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.Refund_Time <= dt
select d;
}
}
if (fQuery.orderNum != 0)
{//订单号
fp =
from d in fp
where d.Refund_OrderNum.Equals(fQuery.orderNum)
select d;
}
if (fQuery.userid != 0)
{//供应商用户编号
fp =
from d in fp
where d.Refund_UserId.Equals(fQuery.userid)
select d;
}
if (fQuery.usertype != 0)
{//供应商用户类型
fp =
from d in fp
where d.Refund_UserType.Equals(fQuery.usertype)
select d;
}
if (!string.IsNullOrWhiteSpace(fQuery.musername))
{//采购商用户名称
fp =
from d in fp
where d.Refund_ToUserName.Equals(fQuery.musername)
select d;
}
if (fQuery.muserid != 0)
{//采购商用户编号
fp =
from d in fp
where d.Refund_ToUserId.Equals(fQuery.muserid)
select d;
}
if (fQuery.musertype != 0)
{//采购商用户类型
fp =
from d in fp
where d.Refund_ToUserType.Equals(fQuery.musertype)
select d;
}
if (fQuery.moneytype != 0)
{//支付币种
fp =
from d in fp
where d.Refund_MoneyType.Equals(fQuery.moneytype)
select d;
}
fp = fp.GetPage(out num, fQuery.PageNo, fQuery.PageSize, (IQueryable <Finance_Refund> d) =>
from o in d
orderby o.Refund_Time
select o);
return(new PageModel <Finance_Refund>()
{
Models = fp,
Total = num
});
}
