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