protected void LoadData()
{
Guid userid = WebUserAuth.UserId.Value;
if (userid != Guid.Empty && TransterId != Guid.Empty)
{
int count = 0;
SubscribeBLL bll = new SubscribeBLL();
mTransferRecord = bll.GetTransferRecord(TransterId, 1, 8, out count);
double divide = count / 8;
double floor = System.Math.Floor(divide);
if (count % GlobalUtils.PageSize != 0)
{
floor++;
}
pageCount = Convert.ToInt32(floor);//总页数
DateTime EndTransferDate = DateTime.Parse(mTransferRecord.AddDate.ToString("yyyy-MM-dd") + " 23:59:59");
if (DateTime.Now > EndTransferDate)
{
this.LastSecond = 0;
}
else
{
this.LastSecond = Convert.ToInt32((EndTransferDate - DateTime.Now).TotalSeconds);
}
}
}
/// <summary>
/// 标详情页，获取回款汇总信息
/// </summary>
public void GetRepayedMsg(Guid projId)
{
List <SubscribeTotalInfo> repaylist = new SubscribeBLL().GetRepaymentInfo(projId);
if (repaylist == null)
{
repaylist = new List <SubscribeTotalInfo>();
}
foreach (SubscribeTotalInfo item in repaylist)
{
switch (item.status)
{
case 1:
repayedAmount = SafeConvert.ToDecimal(item.Amount) + SafeConvert.ToDecimal(item.InterestAmount);
break;
case 2:
overdueAmount = SafeConvert.ToDecimal(item.Amount) + SafeConvert.ToDecimal(item.InterestAmount);
break;
case 3:
duerepayAmount = SafeConvert.ToDecimal(item.Amount) + SafeConvert.ToDecimal(item.InterestAmount);
break;
}
}
//PrintJson("1", string.Format("{0}|{1}|{2}", ToolStatus.ConvertDetailWanMoney(repayedAmount),
// ToolStatus.ConvertDetailWanMoney(overdueAmount), ToolStatus.ConvertDetailWanMoney(duerepayAmount)));
}
public MessageBLL(EmpContext context = null)
: base(context)
{
userBLL = new UserBLL(this.db);
subscribeBLL = new SubscribeBLL(this.db);
buildingBLL = new BuildingBLL(this.db);
organizationBLL = new OrganizationBLL(this.db);
messageRecordBLL = new MessageRecordBLL(this.db);
userBLL = new UserBLL(this.db);
subscribeBLL = new SubscribeBLL(this.db);
}
private void LoadList()
{
try
{
SubscribeBLL subscribeBLL = new SubscribeBLL();
DataTable dt = subscribeBLL.GetAll();
rptrList.DataSource = dt;
rptrList.DataBind();
}
catch (Exception)
{
//throw;
}
}
//获取转让详情数据
public void GetZQZRTransferRecord()
{
int pageSize = 8;
int pageIndex = Tool.SafeConvert.ToInt32(Context.Request.Form["pageIndex"], 1);
Guid transferId = WEBRequest.GetFormGuid("transferId");
Guid userid = WebUserAuth.UserId.HasValue ? WebUserAuth.UserId.Value : Guid.Empty;
if (userid == Guid.Empty)
{
PrintJson("0", "您还未登录!");
return;
}
SubscribeBLL bll = new SubscribeBLL();
int recordCount = 0;
int index = 1;
TransferRecord mTransferRecord = bll.GetTransferRecord(transferId, pageIndex, pageSize, out recordCount);
StringBuilder sb = new StringBuilder();
sb.Append("{\"result\":\"1\",\"list\":[");
foreach (var temp in mTransferRecord.listTranster)
{
sb.Append("{\"NickName\":\"" + BusinessDll.StringHandler.MaskStartPre(temp.UserName, 1) + "\",\"Amount\":\"" + ToolStatus.ConvertLowerMoney(temp.Amount) +
"\",\"TotalShares\":\"" + temp.TotalShares +
"\",\"ContractNo\":\"" + temp.ContractNo
);
if (index == mTransferRecord.listTranster.Count())
{
sb.Append("\"}]}");
}
else
{
sb.Append("\"},");
}
index++;
}
this.Context.Response.Write(sb.ToString());
this.Context.Response.End();
}
private void GenerateCode()
{
try
{
QuaintLibraryManager lib = new QuaintLibraryManager();
ModelCode = CodePrefix.Email + "-" + lib.GetSixDigitNumber(1);
SubscribeBLL subscribeBLL = new SubscribeBLL();
DataTable dt = subscribeBLL.GetAll();
if (dt != null)
{
if (dt.Rows.Count > 0)
{
string[] lastCode = dt.Rows[dt.Rows.Count - 1]["EmailCode"].ToString().Split('-');
int lastCodeNumber = Convert.ToInt32(lastCode[1]);
ModelCode = CodePrefix.Email + "-" + lib.GetSixDigitNumber(lastCodeNumber + 1);
}
}
}
catch (Exception)
{
//Alert(AlertType.Error, "Failed to load.");
}
}
protected void btnSubscribe_Click(object sender, EventArgs e)
{
try
{
QuaintLibraryManager lib = new QuaintLibraryManager();
string email = Convert.ToString(txtEmail.Text);
SubscribeBLL subscribeBLL = new SubscribeBLL();
Subscribes subscribe = new Subscribes();
subscribe.EmailCode = this.ModelCode;
subscribe.Email = email;
if (subscribeBLL.Save(subscribe))
{
ClearFields();
GenerateCode();
}
}
catch (Exception)
{
throw;
}
}
//加载转让信息
public void InitApplicationTransfer()
{
//TuanDB.JunTeEntities dbRead = TuanDB.JunTeEntities.Read();
Guid subscribeId = Guid.Empty;
Guid.TryParse(Context.Request["id"], out subscribeId);
Guid userId = WebUserAuth.UserId.Value;
//TuanDB.Subscribe subscribeEntity = dbRead.Subscribe.FirstOrDefault(p => p.Id == subscribeId && p.SubscribeUserId == userId);
var subscribeEntity = new SubscribeBLL().GetSubscribeById(subscribeId);
if (subscribeEntity == null)
{
PrintJson("0", "数据异常");
return;
}
ProjectBLL bll = new ProjectBLL();
ProjectDetailInfo projectEntity = bll.GetProjectDetailInfo(subscribeEntity.ProjectId.Value);
//Project projectEntity = dbRead.Project.FirstOrDefault(p => p.Id == subscribeEntity.ProjectId);
if (projectEntity == null)
{
PrintJson("0", "数据异常");
return;
}
InitApplicationtransferInfo initApplicationtransferEntity = new InitApplicationtransferInfo();
initApplicationtransferEntity.Title = projectEntity.Title;
initApplicationtransferEntity.TypeName = ToolStatus.ConvertProjectType(projectEntity.Type ?? 0);
initApplicationtransferEntity.InterestRate = projectEntity.InterestRate ?? 0;
initApplicationtransferEntity.RepaymentTypeName = ToolStatus.ConvertRepaymentType(projectEntity.RepaymentType ?? 0);
initApplicationtransferEntity.Deadline = projectEntity.Deadline ?? 0;
initApplicationtransferEntity.LowerUnit = projectEntity.LowerUnit ?? 0;
initApplicationtransferEntity.SubscribeShares = subscribeEntity.SubscribeShares ?? 0;
initApplicationtransferEntity.Amount = "0";
initApplicationtransferEntity.InterestAmount = "0";
//var subscribeDetailList = dbRead.SubscribeDetail.Where(p => p.SubscribeId == subscribeId);
var subscribeDetailList = new SubscribeDetailBLL().GetSubscribeDetailListBySubscribeId(subscribeId);
if (subscribeDetailList.Count() > 0)
{
initApplicationtransferEntity.Amount = ToolStatus.ConvertLowerMoney(subscribeDetailList.Sum(p => p.Amount));
initApplicationtransferEntity.InterestAmount = ToolStatus.ConvertLowerMoney(subscribeDetailList.Sum(p => p.InterestAmout.Value));
}
initApplicationtransferEntity.RefundedMonths = subscribeEntity.RefundedMonths ?? 0;
initApplicationtransferEntity.TotalRefundMonths = subscribeEntity.TotalRefundMonths ?? 0;
initApplicationtransferEntity.PreCycDate = subscribeEntity.PreCycDate.HasValue ? subscribeEntity.PreCycDate.Value.ToString("yyyy-MM-dd") : "";
string sql = string.Empty;
if (projectEntity.RepaymentType == 1)//到期还本息
{
sql = "SELECT dateDiff(day,@BeginDate,getdate())-1";
}
else
{
sql = "SELECT dateDiff(day,dbo.f_GetRepaymentAdvance_Date(@BeginDate,@Month),getdate())";
}
var para = new Dapper.DynamicParameters();
para.Add("@BeginDate", subscribeEntity.AddDate);
para.Add("@Month", subscribeEntity.RefundedMonths);
initApplicationtransferEntity.Days = PublicConn.QuerySingle <int>(sql, ref para);
//using (SqlConnection connection = new SqlConnection(TuanDai.Config.BaseConfig.ConnectionString))
//{
// connection.Open();
// int day = connection.Query<int>(sql, new { BeginDate = subscribeEntity.AddDate, Month = subscribeEntity.RefundedMonths }).First();
// connection.Close();
// connection.Dispose();
// initApplicationtransferEntity.Days = day;
//}
initApplicationtransferEntity.result = 1;
PrintJson(initApplicationtransferEntity);
}
protected bool GetData()
{
UserBLL userbll = new UserBLL();
//获取项目信息
model = bll.GetProjectDetailInfo(projectId.Value);
if (model == null)
{
Response.Redirect(GlobalUtils.WebURL + "/Member/my_account.aspx");
return(false);
}
borrowerUserInfo = userbll.GetUserBasicInfoModelById(model.UserId.Value);
borrowerUserInfoExt = userbll.GetUserBasicInfoExtInfo(model.UserId.Value);
this.GetBorrowerData();
InterestRateNum1 = ToolStatus.DeleteZero(model.InterestRate.Value).Split('.')[0];
InterestRateNum2 = ToolStatus.DeleteZero(model.InterestRate.Value).Contains(".") ? ToolStatus.DeleteZero(model.InterestRate.Value).Split('.')[1] : string.Empty;
if (model.Status != 3 && model.Status != 6)
{
RemainMoney = (int.Parse(ToolStatus.diff(model.TotalShares ?? 0, model.CastedShares ?? 0)) * decimal.Parse(ToolStatus.DeleteZero(model.LowerUnit.Value))).ToString("N2");
}
else
{
RemainMoney = "0";
}
finishProcess = CommUtils.GetProjectProcess(model);
SubscribeUserCount = CommUtils.GetSubscribeUserCount(this.projectId.Value);
//计算预期收益
PreInterestRate = CommUtils.CalcInvestInterest(model, 10000);
EbaoMultiple = int.Parse(Math.Ceiling(model.InterestRate.Value / decimal.Parse("2.5")).ToString());
EbaoInterest = CommUtils.GetEbaoMultipleInterest(model, 10000);
preSubscribeList = CommUtils.GetPreSubscribeDetail(model, 10000);
List <SubscribeTotalInfo> repaylist = new SubscribeBLL().GetRepaymentInfo(this.projectId.Value);
if (repaylist != null && repaylist.Count > 0)
{
foreach (SubscribeTotalInfo item in repaylist)
{
switch (item.status)
{
case 1:
repayedAmount = SafeConvert.ToDecimal(item.Amount) + SafeConvert.ToDecimal(item.InterestAmount);
break;
case 2:
overdueAmount = SafeConvert.ToDecimal(item.Amount) + SafeConvert.ToDecimal(item.InterestAmount);
break;
case 3:
duerepayAmount = SafeConvert.ToDecimal(item.Amount) + SafeConvert.ToDecimal(item.InterestAmount);
break;
}
}
}
string jzsql = "select isnull(AvgNetAssets,0) from VipMonthlyNetAssets with(nolock) where UserId=@UserId and ReportDate=@ReportDate";
var dyParamJZ = new Dapper.DynamicParameters();
dyParamJZ.Add("@UserId", model.UserId.Value);
dyParamJZ.Add("@ReportDate", DateTime.Now.AddMonths(-1).ToString("yyyy-MM-01"));
this.monthJZ = TuanDai.DB.TuanDaiDB.QueryFirstOrDefault <decimal>(TdConfig.ApplicationName, TdConfig.DBReportWrite, jzsql, ref dyParamJZ);
regulaSet = new WebSettingBLL().GetWebSettingInfo("293A1C07-1D90-4D22-ADD4-39E6735DAC06");
InterestModel = TuanDai.PortalSystem.Redis.ProjectRedis.GetProjectInterestMode(model.Type.Value, model.RepaymentType.Value);
// 截标时间为NULL时候取审核时间 +4 天
if (model.TenderDate == null)
{
WebSettingInfo set = new WebSettingBLL().GetWebSettingInfo("3F902315-6986-44FF-9F00-9D420C07FCDA");
if (model.AddDate >= Convert.ToDateTime(set.Param4Value))
{
model.TenderDate = Convert.ToDateTime(model.AuditDate == null ? model.AddDate : model.AuditDate).AddDays(2);
}
else
{
model.TenderDate = Convert.ToDateTime(model.AuditDate == null ? model.AddDate : model.AuditDate).AddDays(4);
}
}
if (model.AuditDate == null)
{
model.TenderStartDate = model.AddDate;
}
else
{
model.TenderStartDate = model.AuditDate;
}
return(true);
}
