protected void Page_Load(object sender, EventArgs e)
{
SubscribeId = WEBRequest.GetGuid("SubscribeId", "");
projectTitle = WEBRequest.GetQueryString("Title");
projectId = WEBRequest.GetGuid("projectid", "");
CurrTab = WEBRequest.GetQueryString("tab");
if (!IsPostBack)
{
subscribeInfo = WXGetSubscribeInfo(SubscribeId);
Status = WXConverter.GetSubscribeStatusString(99, subscribeInfo.Status, subscribeInfo.IsBorrow);
BindList();
}
}
/// <summary>
/// 投资
/// </summary>
/// <param name="SubscribeId"></param>
/// <returns></returns>
public WXSubscribeInfo1 WXGetSubscribeInfo(Guid SubscribeId)
{
WXSubscribeInfo1 model = new WXSubscribeInfo1();
string cmdText = @"SELECT s.Id AS SubscribeId,s.TranDate as AddDate,s.TenderMode,s.Status,o.IsBorrow,s.Amount,s.InterestAmount,s.ReceiveAmount,s.ReceiveInterest,
ISNULL(s.TuandaiRedPacket,0) as TuandaiRedPacket, isnull(PublisherRedPacket,0) as PublisherRedPacket, s.ContractNo
FROM Subscribe s with(nolock)
LEFT JOIN OverDueRecord o with(nolock) ON s.Id=o.SubscribeId AND o.IsBorrow=0 and isnull(o.IsHide,0)=0
WHERE s.Id=@Id";
var paras = new { Id = SubscribeId };
DynamicParameters dyParams = new DynamicParameters();
dyParams.Add("@Id", SubscribeId);
model = PublicConn.QuerySingle <WXSubscribeInfo1>(cmdText, ref dyParams);
return(model);
}