public void DeleteBorrow(BorrowEntity borrowEntity)
{
if (borrowEntity is null)
{
throw new ArgumentNullException(nameof(borrowEntity));
}
m_Context.Borrows.Remove(borrowEntity);
}
public void AddBorrow(BorrowEntity borrowEntity)
{
if (borrowEntity is null)
{
throw new ArgumentNullException(nameof(borrowEntity));
}
m_Context.Borrows.Add(borrowEntity);
}
/// <summary>
/// 投资合同
/// </summary>
/// <returns></returns>
public ActionResult InvestmentContract(int targetId)
{
ContractLogic _logic = new ContractLogic();
M_Contract_management model = _logic.GetContractListForApp(targetId).FirstOrDefault();
StringBuilder sb = new StringBuilder(model.contract_money);
sb = sb.Replace("#loan_number#", model.loan_number.ToString());
//手机号*号处理
if (!string.IsNullOrEmpty(model.borrower_username) && model.borrower_username.Length == 11)
{
model.borrower_username = model.borrower_username.Substring(0, 3) + "****" + model.borrower_username.Substring(7);
}
sb = sb.Replace("#borrower_username#", model.borrower_username);
//姓名 名字*号处理
if (!string.IsNullOrEmpty(model.borrower_name))
{
model.borrower_name = model.borrower_name.Substring(0, 1) + "**";
}
sb = sb.Replace("#borrower_name#", model.borrower_name);
sb = sb.Replace("#borrower_id_card#", model.borrower_id_card);
sb = sb.Replace("#lender_username#", model.lender_username);
sb = sb.Replace("#lender_name#", model.lender_name);
sb = sb.Replace("#lender_id_card#", model.lender_id_card);
sb = sb.Replace("#surety_company_name#", model.surety_company_name);
sb = sb.Replace("#guarantor_agent_usernqme#", model.guarantor_agent_usernqme);
sb = sb.Replace("#contract_amount#", RMB.GetDecimal(model.contract_amount, 2, true).ToString());
BorrowLogic _borrowLogic = new BorrowLogic();
BorrowEntity borrowEntity = _borrowLogic.SelectBorrowDetail(targetId);
sb = sb.Replace("#annual_interest_rate#", decimal.Parse(borrowEntity.annual_interest_rate.ToString()).ToString("0.00"));
DateTime date1 = DateTime.Parse(borrowEntity.release_date.ToString());
DateTime date2 = DateTime.Parse(borrowEntity.repayment_date.ToString());
sb = sb.Replace("#release_date#", date1.ToString("yyyy-MM-dd"));
sb = sb.Replace("#repayment_date#", date2.ToString("yyyy-MM-dd"));
sb = sb.Replace("#days#", Utils.DateDiff("Day", date1, date2).ToString());
model.contract_money = sb.ToString();
//ViewBag.loan_number = model.loan_number;
//ViewBag.borrower_username = model.borrower_username;
//ViewBag.borrower_name = model.borrower_name;
//ViewBag.guarantee_legal_representative = model.guarantee_legal_representative;
//ViewBag.surety_company_name = model.surety_company_name;
//ViewBag.StartTime = model.Start_Time;
//ViewBag.EndTime = model.End_Time;
//ViewBag.DurationDays = model.DurationTime;
return(View(model));
}
public async Task Borrow()
{
if (Book.IsValid() && State.IsValid() && State.Quantity > 0)
{
BorrowEntity borrow = new BorrowEntity()
{
UserId = CurrentSession.Id,
BookCopyId = State.Id,
BorrowingDate = DateTime.Now,
ExpectedDeliveryDate = EndDate,
DeliveryDate = null,
ExtraCharges = Supplement,
};
m_Repository.AddBorrow(borrow);
await m_Repository.SaveAsync();
State.Quantity--;
GoBack();
}
}
/// <summary>
/// 封装标基本信息结果集
/// </summary>
/// <param name="dt"></param>
/// <returns></returns>
protected static List <BorrowEntity> InitEntity(DataTable dt)
{
var entityList = new List <BorrowEntity>();
try
{
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
for (int n = 0; n < rowsCount; n++)
{
var entity = new BorrowEntity();
var row = dt.Rows[n];
if (ContainsColumn(dt.Columns, "targetid", row))
{
entity.targetId = ConvertHelper.ParseValue(dt.Rows[n]["targetid"].ToString(), 0);
}
if (ContainsColumn(dt.Columns, "borrowing_title", row))
{
entity.borrowing_title = dt.Rows[n]["borrowing_title"].ToString();
}
if (ContainsColumn(dt.Columns, "borrower_registerid", row))
{
entity.borrower_registerid = ConvertHelper.ParseValue(dt.Rows[n]["borrower_registerid"].ToString(), 0);
}
if (ContainsColumn(dt.Columns, "username", row))
{
entity.userName = dt.Rows[n]["username"].ToString().Substring(0, 4) + "*****";
}
if (ContainsColumn(dt.Columns, "tender_state", row))
{
entity.tender_state = ConvertHelper.ParseValue(dt.Rows[n]["tender_state"].ToString(), 0);
}
if (ContainsColumn(dt.Columns, "project_type_id", row))
{
entity.project_type_id = ConvertHelper.ParseValue(dt.Rows[n]["project_type_id"].ToString(), 0);
}
if (ContainsColumn(dt.Columns, "borrowing_balance", row))
{
entity.borrowing_balance = ConvertHelper.ParseValue(dt.Rows[n]["borrowing_balance"].ToString(), 0M);
}
if (ContainsColumn(dt.Columns, "annual_interest_rate", row))
{
entity.annual_interest_rate = ConvertHelper.ParseValue(dt.Rows[n]["annual_interest_rate"].ToString(), 0M);
}
if (ContainsColumn(dt.Columns, "life_of_loan", row))
{
entity.life_of_loan = ConvertHelper.ParseValue(dt.Rows[n]["life_of_loan"].ToString(), 0);
}
if (ContainsColumn(dt.Columns, "payment_options", row))
{
entity.payment_options = ConvertHelper.ParseValue(dt.Rows[n]["payment_options"], 0);
}
if (ContainsColumn(dt.Columns, "fundraising_amount", row))
{
entity.fundraising_amount = ConvertHelper.ParseValue(dt.Rows[n]["fundraising_amount"], 0M);
}
if (ContainsColumn(dt.Columns, "month_payment_date", row))
{
entity.month_payment_date = ConvertHelper.ParseValue(dt.Rows[n]["month_payment_date"], 0);
}
if (ContainsColumn(dt.Columns, "H_Repayment_Amt", row))
{
entity.H_Repayment_Amt = ConvertHelper.ParseValue(dt.Rows[n]["H_Repayment_Amt"], 0M);
}
if (ContainsColumn(dt.Columns, "invest_num", row))
{
entity.investCount = ConvertHelper.ParseValue(dt.Rows[n]["invest_num"], 0);
}
if (ContainsColumn(dt.Columns, "repayment_date", row))
{
entity.repayment_date = ConvertHelper.ParseValue(dt.Rows[n]["repayment_date"], DateTime.Now);
}
if (ContainsColumn(dt.Columns, "month_payment_date", row))
{
entity.month_payment_date = ConvertHelper.ParseValue(dt.Rows[n]["month_payment_date"], 0);
}
if (ContainsColumn(dt.Columns, "CreatedOn", row))
{
entity.CreatedOn = ConvertHelper.ParseValue(dt.Rows[n]["CreatedOn"], DateTime.Now);
}
if (ContainsColumn(dt.Columns, "start_time", row))
{
entity.start_time = ConvertHelper.ParseValue(dt.Rows[n]["start_time"], DateTime.Now);
}
if (ContainsColumn(dt.Columns, "end_time", row))
{
entity.end_time = ConvertHelper.ParseValue(dt.Rows[n]["end_time"], DateTime.Now);
}
if (ContainsColumn(dt.Columns, "release_date", row))
{
entity.release_date = ConvertHelper.ParseValue(dt.Rows[n]["release_date"], DateTime.Now);
}
if (ContainsColumn(dt.Columns, "unit_day", row))
{
entity.unit_day = ConvertHelper.ParseValue(dt.Rows[n]["unit_day"].ToString(), 0);
}
if (ContainsColumn(dt.Columns, "minimum", row))
{
entity.minimum = ConvertHelper.ParseValue(dt.Rows[n]["minimum"].ToString(), 0M);
}
if (ContainsColumn(dt.Columns, "maxmum", row))
{
entity.maxmum = ConvertHelper.ParseValue(dt.Rows[n]["maxmum"].ToString(), 0M);
//if (entity.maxmum == 0M) entity.maxmum = 50000;
}
if (ContainsColumn(dt.Columns, "sys_time", row))
{
entity.sys_time = ConvertHelper.ParseValue(dt.Rows[n]["sys_time"], DateTime.Now);
}
//FLAG: 当 标的为开标上线时，通过判定 标的剩余值来更新标状态为满标状态。
if (entity.tender_state == 2)
{
if (entity.borrowing_balance - entity.fundraising_amount <= 0)
{
entity.tender_state = 3;
entity.borrowing_balance = entity.fundraising_amount;//避免APP端出现 投资负数的问题
}
}
else if (entity.tender_state > 2)
{
entity.borrowing_balance = entity.fundraising_amount;//避免APP端出现 状态为已放款，但是可投金额不为0的问题
}
entityList.Add(entity);
}
}
else
{
return(null);
}
}
catch (Exception ex)
{
LoggerHelper.Error(" public List<BorrowEntity> InitEntity(DataTable dt) throw exception:", ex);
}
return(entityList);
}
