/// <summary>
/// 获取回款记录明细
/// </summary>
/// <param name="subscribeId">申购Id</param>
/// <returns></returns>
protected List <SubscribeInfo> GetSubscribeDetailList(Guid subscribeId)
{
List <SubscribeInfo> list = null;
string sqlText = @"select CycDate,Amount,InterestAmout,ISNULL(InvestCommission,0) AS Commission,ISNULL(TuandaiRedPacket,0) AS TuandaiRedPacket,ISNULL(PublisherRedPacket,0)AS PublisherRedPacket,Periods,0 as OverDueAmount,0 RealAmount,0 AdvanceAmount,NULL IsRefundAdvance,1 Status,'待回款' AS [Desc]
from SubscribeDetail with(nolock)
where SubscribeId=@SubscribeID
order by Periods";
var para = new Dapper.DynamicParameters();
para.Add("@SubscribeID", subscribeId);
list = PublicConn.QueryBySql <SubscribeInfo>(sqlText, ref para);
sqlText = @"select Adddate CycDate,RealAmount Amount,RealInterestAmout InterestAmout,isnull(InvestCommission, 0) as Commission,isnull(TuandaiRedPacket, 0) TuandaiRedPacket,isnull(PublisherRedPacket, 0) PublisherRedPacket,Periods ,0 OverDueAmount,0 RealAmount,0 AdvanceAmount,NULL IsRefundAdvance,2 as Status ,'已回款' as [Desc] from SubscribeDetailHistory_h1 with(nolock) where SubscribeId=@SubscribeID order by Periods";
var hlist = TuanDai.DB.TuanDaiDB.Query <SubscribeInfo>(TdConfig.ApplicationName,
TdConfig.DBSubDetailHisRead, sqlText, ref para);
if (hlist != null && hlist.Count > 0)
{
foreach (var info in hlist)
{
info.IsBorrow = true;
sqlText = string.Empty;
sqlText = @"select b.Adddate OverDueDate,b.IsBorrow from OverDueRecord B with(nolock) where B.SubscribeId=@SubscribeID and B.periods=@periods and isnull(b.IsHide,0)=0";
SubscribeInfo s = TuanDai.DB.TuanDaiDB.QueryFirstOrDefault <SubscribeInfo>(TdConfig.ApplicationName,
TdConfig.DBRead, sqlText, ref para);
if (s != null)
{
info.IsBorrow = s.IsBorrow;
info.OverDueDate = s.OverDueDate;
}
}
list.AddRange(hlist);
}
if (list != null && list.Count > 0)
{
list = list.OrderBy(o => o.Periods).ToList();
}
return(list);
}
public string GetShowAmountDesc(SubscribeInfo item)
{
string strResult = "";
if (item.Amount > 0)
{
strResult += "+本金";
}
if (item.InterestAmout > 0)
{
strResult += "+利息";
}
if (item.TuandaiRedPacket > 0 || item.PublisherRedPacket > 0)
{
strResult += "+奖励";
}
if (strResult.Length > 0)
{
strResult = strResult.Substring(1);
}
return(strResult);
}
protected string GetShowAmount(SubscribeInfo item)
{
string strResult = "";
if (item.Amount > 0)
{
strResult += "+ ￥" + ToolStatus.ConvertLowerMoney(item.Amount);
}
if (item.InterestAmout > 0)
{
strResult += "+ ￥" + ToolStatus.ConvertLowerMoney(item.InterestAmout);
}
if (item.TuandaiRedPacket > 0 || item.PublisherRedPacket > 0)
{
strResult += "+ ￥" + ToolStatus.ConvertLowerMoney(item.TuandaiRedPacket + item.PublisherRedPacket);
}
if (strResult.Length > 0)
{
strResult = strResult.Substring(2);
}
return(strResult);
}
