/// <summary> /// 智享发起记录 /// </summary> public void GetMyBorrowRecord() { string statusStr = Tool.SafeConvert.ToString(Context.Request.Form["status"]); int status = 1; if (statusStr == "Finished") { status = 2; } int pageindex = Tool.SafeConvert.ToInt32(Context.Request.Form["pageIndex"], 1); if (pageindex < 1) { pageindex = 1; } int total = 0; JsonDemo1 jd = new JsonDemo1(); var list = new ZXWXSelectBLL().GetZXWxBorrowList(userid, pageindex, pagesize, status, out total); totalItemCount = total; jd.borrowList = list; jd.pageCount = GetPageCount(total, pagesize); PrintJson("1", JsonConvert.SerializeObject(jd)); }
/// <summary> /// 获得智享计划回款还款 按月汇总列表 /// </summary> public void GetZxReturnAndPayMonths() { var startDate = int.Parse(WEBRequest.GetString("startDate")); DateTime sTime; DateTime eTime; if (startDate == 1) { sTime = DateTime.Parse(DateTime.Now.AddDays(1).ToShortDateString()); eTime = new DateTime(DateTime.Now.AddMonths(3).Year, DateTime.Now.AddMonths(3).Month, 1).AddMilliseconds(-1); } else { sTime = new DateTime(DateTime.Now.AddMonths(3 * (startDate - 1)).Year, DateTime.Now.AddMonths(3 * (startDate - 1)).Month, 1); eTime = new DateTime(DateTime.Now.AddMonths(3 * (startDate)).Year, DateTime.Now.AddMonths(3 * (startDate)).Month, 1).AddMilliseconds(-1); } MyReturnAndPayList myList = new MyReturnAndPayList(); List <MyReturnAndPayInfo> list = new List <MyReturnAndPayInfo>(); List <ZXWxDueAmountMonth> zxList = new ZXWXSelectBLL().GetZxWxDueAmountMonths(userid, sTime, eTime, 1); if (zxList != null && zxList.Count > 0) { foreach (var item in zxList) { MyReturnAndPayInfo info = new MyReturnAndPayInfo(); info.myDate = item.cycDate; info.myMonth = item.cycDate; info.payMoney = item.dueOutTotalAmount; info.returnMoney = item.dueInTotalAmount; list.Add(info); } } myList.list = list; string resultStr = JsonHelper.ToJson(myList); PrintJson(resultStr); }
/// <summary> /// 智享 获取某一天的回款 还款项目列表 (点击天数) /// </summary> public void GetZxReturnAndPayByDay() { string dt = Context.Request.Form["Date"]; if (dt.Contains("-")) { dt = DateTime.Parse(Context.Request.Form["Date"]).ToString("yyyyMMdd"); } List <ReturnAndPayProjectDetail> list = new List <ReturnAndPayProjectDetail>(); List <ZXWxReturnAndPayProjectDetail> returnAndPayProjectDetails = new ZXWXSelectBLL().GetReturnAndPayProjectDetails(userid, dt); if (returnAndPayProjectDetails != null && returnAndPayProjectDetails.Count > 0) { list = JsonConvert.DeserializeObject <List <ReturnAndPayProjectDetail> >( JsonConvert.SerializeObject(returnAndPayProjectDetails)); } string resultStr = JsonHelper.ToJson(list); PrintJson(resultStr); }
/// <summary> /// 智享 获得回款还款明细 按天汇总列表 (页面上点击月份事件) /// </summary> public void GetZxReturnAndPayDetail() { int year = Tool.SafeConvert.ToInt32(Context.Request.Form["year"], 2016); int month = Tool.SafeConvert.ToInt32(Context.Request.Form["month"], 8); DateTime startTime; DateTime endTime; if (year == DateTime.Now.Year && month == DateTime.Now.Month) { startTime = DateTime.Parse(DateTime.Now.AddDays(1).ToShortDateString()); endTime = new DateTime(startTime.AddMonths(1).Year, startTime.AddMonths(1).Month, 1);; } else { startTime = new DateTime(year, month, 1); endTime = startTime.AddMonths(1); } List <MyReturnAndPayInfo> list = new List <MyReturnAndPayInfo>(); List <ZXWxDueAmountMonth> zxList = new ZXWXSelectBLL().GetZxWxDueAmountMonths(userid, startTime, endTime, 2); if (zxList != null && zxList.Count > 0) { foreach (var item in zxList) { MyReturnAndPayInfo info = new MyReturnAndPayInfo(); info.myDate = item.cycDate; info.myMonth = item.cycDate; info.payMoney = item.dueOutTotalAmount; info.returnMoney = item.dueInTotalAmount; list.Add(info); } } string resultStr = JsonHelper.ToJson(list); PrintJson(resultStr); }
protected void InitFormData() { pageModel = new PageMoneyModel(); //GetUserAddInterest(); UserBLL bll = new UserBLL(); userModel = bll.GetUserBasicInfoModelById(userId); if (userModel != null && !string.IsNullOrWhiteSpace(userModel.HeadImage)) { headImage = userModel.HeadImage; } GetAccountInfo(userId); GetDQLCFundData(userId); string read = Tool.CookieHelper.GetCookie("ReadUserPrizeFlag"); if (!string.IsNullOrEmpty(read)) { isShowPrizeBoxIco = !(read == "ReadPass"); } else { isShowPrizeBoxIco = bll.GetUnReceiveCount(userId) > 0; } //获取用户收益 //GetProfitStatistics(userId); UserVipModel = GetNewVipUserInfo(); //待收本息加上复投宝的 Tuple <decimal, decimal> ftbDueIn = GetFTBDueInAmountInterest(userId); accountModel.DueInPAndI = accountModel.DueInPAndI + ftbDueIn.Item1 + ftbDueIn.Item2; decimal weWaitInvestAmount = GetWePlanWaitInvestment(userId); accountModel.FreezeAcount = accountModel.FreezeAcount + weWaitInvestAmount; //冻结资金加上We待投 if (accountModel != null) { pageModel.P2PSumAmount = (accountModel.AviMoney) + (accountModel.DueInPAndI) + (accountModel.BorrowerOut) + (accountModel.DueConfirmWithdrawDeposit) + (accountModel.RewardMoney) + (accountModel.FreezeAcount); } if (!GlobalUtils.IsOpenSubscribeApi) { pageModel.P2PSumAmount += dqAccountModel.TotalAmount; } decimal p2pZxDueIn = new ZXWXSelectBLL().GetDueDaiShow(userId, "37"); //p2p智享待收 decimal dqZxDueInFromZx = new ZXWXSelectBLL().GetDueDaiShow(userId, "38"); //定期智享待收从智享数据库取 decimal?dqZxDueInFromDq = 0; //定期智享待收从定期数据库取 string sql = "select isnull(DueINAmount,0)+isnull(DueInInterest,0) from dbo.FundAccountInfo_zx with(nolock) where UserId=@UserId"; var para = new Dapper.DynamicParameters(); para.Add("@UserId", userId); dqZxDueInFromDq = TuanDaiDB.QueryFirstOrDefault <decimal?>(TdConfig.ApplicationName, "/BD/dqread", sql, ref para); pageModel.P2PAviAmount = accountModel.AviMoney; pageModel.P2PDueIn = accountModel.DueInPAndI - p2pZxDueIn; pageModel.DQDueIn = dqAccountModel.DueInPAndI - (dqZxDueInFromDq ?? 0); pageModel.DQAviAmount = dqAccountModel.AviMoney; pageModel.DQSumAmount = dqAccountModel.TotalAmount; GetPersonalNotice(); zxDueInMoney = p2pZxDueIn + dqZxDueInFromZx; }