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