/// <summary> /// 显示借款人、抵押物信息 /// </summary> /// <param name="loaner"></param> /// <param name="riskId"></param> private void ShowLoanerInfo(li_loaners loaner, int riskId) { if (loaner == null) { return; } //借款人信息 sp_loaner_name.InnerText = loaner?.dt_users.real_name; sp_loaner_gender.InnerText = loaner?.dt_users.sex; sp_loaner_job.InnerText = loaner?.job; sp_loaner_working_at.InnerText = loaner?.working_at; sp_loaner_tel.InnerText = loaner?.dt_users.telphone; sp_loaner_id_card_number.InnerText = loaner?.dt_users.id_card_number; //企业信息 if (loaner?.li_loaner_companies != null) { sp_company_name.InnerText = loaner.li_loaner_companies.name; sp_company_business_scope.InnerText = loaner.li_loaner_companies.business_scope; sp_company_business_status.InnerText = loaner.li_loaner_companies.business_status; sp_company_registered_capital.InnerText = loaner.li_loaner_companies.registered_capital; sp_company_setup_time.InnerText = loaner.li_loaner_companies.setup_time.ToString("yyyy年MM月dd日"); } if (loaner != null) { rptList.DataSource = Loan.LoadMortgageList(loaner.id, riskId, false); rptList.DataBind(); } }
/// <summary> /// 显示借款人、抵押物信息 /// </summary> /// <param name="loaner_id"></param> private void ShowLoanerInfo(li_loaners loaner) { if (loaner == null) { return; } //借款人信息 sp_loaner_name.InnerText = loaner.dt_users.real_name; sp_loaner_gender.InnerText = loaner.dt_users.sex; sp_loaner_job.InnerText = loaner.job; sp_loaner_working_at.InnerText = loaner.working_at; sp_loaner_tel.InnerText = loaner.dt_users.telphone; sp_loaner_id_card_number.InnerText = loaner.dt_users.id_card_number; //企业信息 if (rbl_project_type.SelectedValue == ((int)Agp2pEnums.LoanTypeEnum.Company).ToString() && loaner.li_loaner_companies != null) { sp_company_name.InnerText = loaner.li_loaner_companies.name; sp_company_business_scope.InnerText = loaner.li_loaner_companies.business_scope; sp_company_business_status.InnerText = loaner.li_loaner_companies.business_status; sp_company_registered_capital.InnerText = loaner.li_loaner_companies.registered_capital; sp_company_setup_time.InnerText = loaner.li_loaner_companies.setup_time.ToString("yyyy年MM月dd日"); } var allMortgages = Loan.LoadMortgageList(Utils.StrToInt(ddlLoaner.SelectedValue, 0), this.risk_id); rptList.DataSource = allMortgages.ToList().Where(m => m != null && m.enable); rptList.DataBind(); }
public static string ApplyLoaner(short age, string nativePlace, string job, string workingCompany, string educationalBackground, int maritalStatus, string income) { var context = new Agp2pDataContext(); var userInfo = GetUserInfoByLinq(context); HttpContext.Current.Response.TrySkipIisCustomErrors = true; if (userInfo == null) { HttpContext.Current.Response.StatusCode = (int)HttpStatusCode.Unauthorized; return("请先登录"); } try { var loaner = context.li_loaners.FirstOrDefault(l => l.dt_users.id == userInfo.id); if (loaner != null) { loaner.age = age; loaner.native_place = nativePlace; loaner.job = job; loaner.working_at = ""; loaner.working_company = workingCompany; loaner.educational_background = educationalBackground; loaner.marital_status = (byte)maritalStatus; loaner.income = income; loaner.status = (int)Agp2pEnums.LoanerStatusEnum.Pending; loaner.last_update_time = DateTime.Now; } else { loaner = new li_loaners() { user_id = userInfo.id, age = age, native_place = nativePlace, job = job, working_at = "", working_company = workingCompany, educational_background = educationalBackground, marital_status = (byte)maritalStatus, income = income, status = (int)Agp2pEnums.LoanerStatusEnum.Pending, last_update_time = DateTime.Now }; context.li_loaners.InsertOnSubmit(loaner); } context.SubmitChanges(); } catch (Exception ex) { throw ex; } return("ok"); }
private bool DoAdd() { // 查找用户 var users = context.dt_users.Where(u => u.real_name == txtName.Text || u.user_name == txtName.Text).Take(2); if (!users.Any()) { JscriptMsg("不存在该用户", "", "Error"); return(false); } if (users.Count() > 1) { JscriptMsg("此姓名匹配了多个用户,请输入会员账号(手机号)来匹配", "", "Error"); return(false); } var model = new li_loaners { dt_users = users.First(), //name = txtName.Text.Trim(), //tel = txtTel.Text.Trim(), age = Convert.ToInt16(txtAge.Text.Trim()), //gender = Convert.ToByte(rblGender.SelectedValue), //cencus = txtCencus.Text.Trim(), native_place = txtCencus.Text.Trim(), job = txtJob.Text.Trim(), working_at = txtWorkingAt.Text.Trim(), working_company = txtWorkingUnit.Text.Trim(), //id_card_number = txtIdCardNumber.Text.Trim(), //email = txtEmail.Text.Trim(), educational_background = txtEducationalBackground.Text.Trim(), marital_status = Convert.ToByte(rblMaritalStatus.SelectedValue), income = txtIncome.Text.Trim(), last_update_time = DateTime.Now, lawsuit = txtLawsuit.Text.Trim(), quota = Utils.StrToInt(txtQuota.Text.Trim(), 0), status = Utils.StrToInt(rblStatus.SelectedValue, 0) }; context.li_loaners.InsertOnSubmit(model); LoadAlbum(model, Agp2pEnums.AlbumTypeEnum.IdCard); try { context.SubmitChanges(); AddAdminLog(DTEnums.ActionEnum.Add.ToString(), "添加借贷人:" + model.dt_users.real_name); //记录日志 return(true); } catch (Exception) { return(false); } }
private void UpdateLoanerCompanyInfo(li_loaners loaner) { var company = loaner.li_loaner_companies; if (chkBindCompany.Checked) { if (company == null) { company = new li_loaner_companies { name = txtCompanyName.Text, business_lawsuit = txtBusinessLawsuit.Text, business_scope = txtBusinessScope.Text, business_status = txtBusinessStatus.Text, registered_capital = txtRegisteredCapital.Text, setup_time = Convert.ToDateTime(txtSetupTime.Text), remark = txtCompanyRemark.Text, manager = txtManager.Text, business_belong = txtBusinessBelong.Text, address = txtCaddress.Text, business_license_no = txtBusinessLicenseNo.Text, organization_no = txtOrganizationNo.Text }; loaner.li_loaner_companies = company; context.li_loaner_companies.InsertOnSubmit(company); } else { company.name = txtCompanyName.Text; company.business_lawsuit = txtBusinessLawsuit.Text; company.business_scope = txtBusinessScope.Text; company.business_status = txtBusinessStatus.Text; company.registered_capital = txtRegisteredCapital.Text; company.setup_time = Convert.ToDateTime(txtSetupTime.Text); company.remark = txtCompanyRemark.Text; company.manager = txtManager.Text; company.business_belong = txtBusinessBelong.Text; company.address = txtCaddress.Text; company.business_license_no = txtBusinessLicenseNo.Text; company.organization_no = txtOrganizationNo.Text; } } else if (company != null) { /*if (company.li_loaners.Count == 1) * context.li_loaner_companies.DeleteOnSubmit(company);*/ loaner.li_loaner_companies = null; } }
private void LoadAlbum(li_loaners model, Agp2pEnums.AlbumTypeEnum type) { string[] albumArr = Request.Form.GetValues("hid_photo_name"); string[] remarkArr = Request.Form.GetValues("hid_photo_remark"); context.li_albums.DeleteAllOnSubmit(context.li_albums.Where(a => a.loaner == model.id && a.type == (int)type)); if (albumArr != null) { var preAdd = albumArr.Zip(remarkArr, (album, remark) => { var albumSplit = album.Split('|'); return(new li_albums { original_path = albumSplit[1], thumb_path = albumSplit[2], remark = remark, add_time = DateTime.Now, li_loaners = model, type = (byte)type }); }); context.li_albums.InsertAllOnSubmit(preAdd); } }
/// <summary> /// 重写虚方法,此方法将在Init事件前执行 /// </summary> protected override void ShowPage() { Init += Project_Init; //加入IInit事件 project_id = DTRequest.GetQueryInt("project_id"); page = Math.Max(1, DTRequest.GetQueryInt("page")); buyClaimId = DTRequest.GetQueryInt("buyClaimId"); if (project_id <= 0) { return; } projectModel = context.li_projects.FirstOrDefault(p => p.id == project_id); if (projectModel == null) { //HttpContext.Current.Response.Redirect(linkurl("error", "?msg=" + Utils.UrlEncode("出错啦,您要浏览的页面不存在或已删除啦!"))); HttpContext.Current.Response.Redirect(linkurl("404")); return; } li_claims preBuyClaim = null; if (buyClaimId != 0) { preBuyClaim = context.li_claims.SingleOrDefault(c => c.id == buyClaimId); if (preBuyClaim == null) { HttpContext.Current.Response.Redirect(linkurl("error", "?msg=" + Utils.UrlEncode("出错啦,您要浏览的页面不存在或已删除啦!"))); return; } } Investable = new Investable { NeedTransferClaim = preBuyClaim, Project = projectModel }; // 浏览次数 + 1 projectModel.click += 1; context.SubmitChanges(); var pr = GetProjectInvestmentProgress(projectModel); //剩余金额 investmentBalance = pr.GetInvestmentBalance(); //风控信息 risk = projectModel.li_risks; //借款人 loaner = risk.li_loaners; //借款人企业 loaner_company = risk.li_loaners?.li_loaner_companies; //抵押物 mortgages = projectModel.li_risks.li_risk_mortgage.Select(rm => rm.li_mortgages).ToList(); invsetorCount = projectModel.GetInvestedUserCount(); projectSum = projectModel.financing_amount; projectDescription = projectModel.title; //还款计划 repayment_tasks = projectModel.li_repayment_tasks .Where(task => task.only_repay_to == null) .OrderBy(rt => rt.should_repay_time) .ToList(); if (Investable.NeedTransferClaim != null) { var ratio = Investable.NeedTransferClaim.principal / projectModel.financing_amount; repayment_tasks = repayment_tasks.Select(src => new li_repayment_tasks { repay_principal = Math.Round(src.repay_principal * ratio, 2), repay_interest = Investable.NeedTransferClaim.Parent.GetProfitingSectionDays(src, (claimBeforeProfitingDays, claimProfitingDays, claimInvalidDays) => Math.Round(src.repay_interest * ratio * claimInvalidDays / (claimBeforeProfitingDays + claimProfitingDays + claimInvalidDays), 2)), should_repay_time = src.should_repay_time, term = src.term }).ToList(); } }
void Page_Init(object sender, EventArgs e) { var user = GetUserInfoByLinq(); if (user == null) { step = LoanApplyStep.Unlogin; } else { user_id = user.id; user_name = user.user_name; //查看是否已为借款人 Agp2pDataContext context = new Agp2pDataContext(); loaner = context.li_loaners.SingleOrDefault(l => l.user_id == user.id); if (loaner == null) { step = LoanApplyStep.UnApplyAsLoaner; loaner_name = user.real_name; loaner_mobile = user.mobile; } else { //借款人信息 loaner_id = loaner.id; loaner_age = loaner.age.ToString(); loaner_educational_background = loaner.educational_background; loaner_income = loaner.income; loaner_job = loaner.job; loaner_marital_status = loaner.marital_status.ToString(); loaner_mobile = loaner.dt_users.mobile; loaner_name = loaner.dt_users.real_name; loaner_native_place = loaner.native_place; loaner_working_at = loaner.working_at; loaner_working_company = loaner.working_company; if (loaner.status != (int)Agp2pEnums.LoanerStatusEnum.Normal) { step = LoanApplyStep.ApplyAsLoanerAuditting; return; } //查看是否有在审批中的借款申请 project = context.li_projects.FirstOrDefault(p => p.li_risks.li_loaners.dt_users.id == user.id && p.status <= (int)Agp2pEnums.ProjectStatusEnum.FinancingApplicationChecking); if (project != null) { step = LoanApplyStep.ProjectAuditting; //显示正在审批步骤 project_category_id = project.category_id; project_amount = (int)project.financing_amount; project_loan_usage = project.li_risks.loan_usage; project_source_of_repayment = project.li_risks.source_of_repayment; project_loaner_content = project.li_risks.loaner_content; quota_use = loaner.quota - (int)project.financing_amount; } else { //查询已审核通过的借款 var projectAll = context.li_projects.Where(p => p.li_risks.li_loaners.dt_users.id == user.id && (int)Agp2pEnums.ProjectStatusEnum.FinancingApplicationSuccess <= p.status && p.status != (int)Agp2pEnums.ProjectStatusEnum.FinancingFail); //查询可用额度 if (projectAll.Any()) { step = LoanApplyStep.ProjectApplyCompleted; quota_use = loaner.quota - (int)projectAll.Sum(p => p.financing_amount); } else { step = LoanApplyStep.UnApplyProject; quota_use = loaner.quota; } } } } }
private void UpdateLoanerInfo(int userId, DateTime lastUpdateTime) { var loanerInfo = context.li_loaners.SingleOrDefault(l => l.user_id == userId); if (chkIsLoaner.Checked) { if (loanerInfo == null) { loanerInfo = new li_loaners { age = Convert.ToInt16(txtAge.Text), user_id = userId, educational_background = txtEducationalBackground.Text, income = txtIncome.Text, job = txtJob.Text, last_update_time = lastUpdateTime, working_at = txtWorkingAt.Text, marital_status = Convert.ToByte(rblMaritalStatus.SelectedValue), native_place = txtCencus.Text, working_company = txtWorkingUnit.Text }; context.li_loaners.InsertOnSubmit(loanerInfo); if (chkBindCompany.Checked) { var loanerCompany = new li_loaner_companies { name = txtCompanyName.Text, business_lawsuit = txtBusinessLawsuit.Text, business_scope = txtBusinessScope.Text, business_status = txtBusinessStatus.Text, registered_capital = txtRegisteredCapital.Text, setup_time = Convert.ToDateTime(txtSetupTime.Text), remark = txtCompanyRemark.Text, manager = txtManager.Text, business_belong = txtBusinessBelong.Text, address = txtCaddress.Text, business_license_no = txtBusinessLicenseNo.Text, organization_no = txtOrganizationNo.Text }; loanerInfo.li_loaner_companies = loanerCompany; context.li_loaner_companies.InsertOnSubmit(loanerCompany); } } else { loanerInfo.age = Convert.ToInt16(txtAge.Text); loanerInfo.user_id = userId; loanerInfo.educational_background = txtEducationalBackground.Text; loanerInfo.income = txtIncome.Text; loanerInfo.job = txtJob.Text; loanerInfo.last_update_time = lastUpdateTime; loanerInfo.working_at = txtWorkingAt.Text; loanerInfo.marital_status = Convert.ToByte(rblMaritalStatus.SelectedValue); loanerInfo.native_place = txtCencus.Text; loanerInfo.working_company = txtWorkingUnit.Text; UpdateLoanerCompanyInfo(loanerInfo); } } else if (loanerInfo != null) { var c = loanerInfo.li_loaner_companies; if (c != null) { context.li_loaner_companies.DeleteOnSubmit(c); } context.li_loaners.DeleteOnSubmit(loanerInfo); } }