/// <summary>
/// 获取众销入账信息
/// </summary>
/// <param name="search">查询类</param>
/// <returns>结果</returns>
public Jinher.AMP.BTP.Deploy.CustomDTO.ShareOrderMoneyResultDTO GetShareOrderMoneyInfo(Jinher.AMP.BTP.Deploy.CustomDTO.ShareOrderMoneySearchDTO search)
{
base.Do(false);
return(this.GetShareOrderMoneyInfoExt(search));
}
/// <summary>
/// 获取众销入账信息
/// </summary>
/// <param name="search">查询类</param>
/// <returns>结果</returns>
public Jinher.AMP.BTP.Deploy.CustomDTO.ShareOrderMoneyResultDTO GetShareOrderMoneyInfoExt(Jinher.AMP.BTP.Deploy.CustomDTO.ShareOrderMoneySearchDTO search)
{
Jinher.AMP.BTP.Deploy.CustomDTO.ShareOrderMoneyResultDTO result = new ShareOrderMoneyResultDTO();
if (search == null || search.UseId == Guid.Empty || search.AppId == Guid.Empty || search.PageIndex < 1 || search.PageSize < 1)
{
return(result);
}
//售中待收益
var orderStates = new List <int>()
{
1, 2, 8, 9, 10, 12, 13, 14
};
//售后待收益
var orderAfterStates = new List <int>()
{
3, 5, 10, 12, 13
};
//已收益
if (search.SearchType == 1)
{
var query = from orderShare in OrderShare.ObjectSet()
join order in CommodityOrder.ObjectSet()
on orderShare.OrderId equals order.Id
join dataS in CommodityOrderService.ObjectSet()
on orderShare.OrderId equals dataS.Id
into tempS
from orderService in tempS.DefaultIfEmpty()
where
orderShare.PayeeId == search.UseId && orderShare.PayeeType == search.PayeeType && orderShare.Commission > 0 &&
order.EsAppId == search.AppId && order.State == 3 && orderService.State == 15
select new ShareOrderMoneyDTO
{
SortTime = orderService.EndTime.Value,
Money = orderShare.Commission,
State = 0,
SrcType = order.SrcType
};
result.Count = query.Count();
result.ShareOrderMoneyList = query.OrderByDescending(n => n.SortTime).Skip((search.PageIndex - 1) * search.PageSize).Take(search.PageSize).ToList();
}
//待收益
else if (search.SearchType == 2)
{
var query = from orderShare in OrderShare.ObjectSet()
join order in CommodityOrder.ObjectSet()
on orderShare.OrderId equals order.Id
join dataS in CommodityOrderService.ObjectSet()
on orderShare.OrderId equals dataS.Id
into tempS
from orderService in tempS.DefaultIfEmpty()
where
orderShare.PayeeId == search.UseId && orderShare.PayeeType == search.PayeeType && orderShare.Commission > 0 &&
order.EsAppId == search.AppId && (orderStates.Contains(order.State) ||
order.State == 3 && orderService.State != null &&
orderAfterStates.Contains(orderService.State))
select new ShareOrderMoneyDTO
{
SortTime = order.PaymentTime.Value,
Money = orderShare.Commission,
State = 1,
SrcType = order.SrcType
};
result.Count = query.Count();
result.ShareOrderMoneyList =
query.OrderByDescending(n => n.SortTime)
.Skip((search.PageIndex - 1) * search.PageSize)
.Take(search.PageSize)
.ToList();
}
else
{
}
return(result);
}
/// <summary>
/// 获取众销入账信息
/// </summary>
/// <param name="search">查询类</param>
/// <returns>结果</returns>
public Jinher.AMP.BTP.Deploy.CustomDTO.ShareOrderMoneyResultDTO GetShareOrderMoneyInfo(Jinher.AMP.BTP.Deploy.CustomDTO.ShareOrderMoneySearchDTO search)
{
//定义返回值
Jinher.AMP.BTP.Deploy.CustomDTO.ShareOrderMoneyResultDTO result;
try
{
//调用代理方法
result = base.Channel.GetShareOrderMoneyInfo(search);
}
catch
{
//抛异常
throw;
}
finally
{
//关链接
ChannelClose();
} //返回结果
return(result);
}
