//更新用户信息基本表 U002
private void ConcultantSvrUpdateU002(DBMA1DataContext dbma1, U002 consultantSvrObj, string userSN)
{
U002 u002 = dbma1.U002s.Where(c => c.userSN == userSN).First();
u002.maritalStatusTypeSN = consultantSvrObj.maritalStatusTypeSN;
u002.procreateStatus = consultantSvrObj.procreateStatus;
u002.currentAddressProvinceSN = consultantSvrObj.currentAddressProvinceSN;
u002.currentAddressCitySN = consultantSvrObj.currentAddressCitySN;
u002.currentAddressDetails = consultantSvrObj.currentAddressDetails;
u002.workEnterprise = consultantSvrObj.workEnterprise;
u002.enterpriseTypeSN = consultantSvrObj.enterpriseTypeSN;
u002.industryTypeSN = consultantSvrObj.industryTypeSN;
u002.workTel = consultantSvrObj.workTel;
u002.hiredate = consultantSvrObj.hiredate;
u002.post = consultantSvrObj.post;
u002.graduateSchool = consultantSvrObj.graduateSchool;
u002.degreeTypeSN = consultantSvrObj.degreeTypeSN;
u002.serviceProvinceSN = consultantSvrObj.serviceProvinceSN;
u002.serviceCitySN = consultantSvrObj.serviceCitySN == "" ? null : consultantSvrObj.serviceCitySN;
u002.investigate = consultantSvrObj.investigate;
u002.assetsEvaluate = consultantSvrObj.assetsEvaluate;
u002.creditRightGuarantee = consultantSvrObj.creditRightGuarantee;
u002.badLoanCollect = consultantSvrObj.badLoanCollect;
u002.consultantDetails = consultantSvrObj.consultantDetails;
}
//更新用户信息基本表 U002
private void FinancingSvrUpdateU002(DBMA1DataContext dbma1, U002 financingSvrObj, string userSN)
{
U002 u002 = dbma1.U002s.Where(c => c.userSN == userSN).First();
u002.maritalStatusTypeSN = financingSvrObj.maritalStatusTypeSN;
u002.procreateStatus = financingSvrObj.procreateStatus;
u002.currentAddressProvinceSN = financingSvrObj.currentAddressProvinceSN;
u002.currentAddressCitySN = financingSvrObj.currentAddressCitySN;
u002.currentAddressDetails = financingSvrObj.currentAddressDetails;
u002.workEnterprise = financingSvrObj.workEnterprise;
u002.enterpriseTypeSN = financingSvrObj.enterpriseTypeSN;
u002.workTel = financingSvrObj.workTel;
u002.hiredate = financingSvrObj.hiredate;
u002.post = financingSvrObj.post;
u002.healthyStatusTypeSN = financingSvrObj.healthyStatusTypeSN;
u002.ifBasicLivingAllowance = financingSvrObj.ifBasicLivingAllowance;
u002.graduateSchool = financingSvrObj.graduateSchool;
u002.degreeTypeSN = financingSvrObj.degreeTypeSN;
u002.monthlyTotalIncome = financingSvrObj.monthlyTotalIncome;
u002.monthlyTotalExpenditure = financingSvrObj.monthlyTotalExpenditure;
u002.monthlyNetIncome = financingSvrObj.monthlyNetIncome;
u002.totalAssets = financingSvrObj.totalAssets;
u002.totalDebt = financingSvrObj.totalDebt;
u002.ifCourtImplementation = financingSvrObj.ifCourtImplementation;
u002.creditStatus = financingSvrObj.creditStatus;
}
//P8010503 工作信息
public void FP8010503(string workEnterprise, string enterpriseTypeSN, string industryTypeSN, DateTime?hiredate, string workTel, string post, string enterpriseSwitchboard, string enterpriseWebsite, string colleageName, string colleagePhone, string colleageIdCard)
{
string userSN = session["userSN"].ToString();
//string userSN = "U00001";
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
U002 u002 = dbma1.U002s.Where(c => c.userSN == userSN).First();
u002.workEnterprise = workEnterprise;
u002.enterpriseTypeSN = enterpriseTypeSN;
u002.industryTypeSN = industryTypeSN;
u002.hiredate = hiredate;
u002.workTel = workTel;
u002.post = post;
u002.enterpriseSwitchboard = enterpriseSwitchboard;
u002.enterpriseWebsite = enterpriseWebsite;
u002.colleageName = colleageName;
u002.colleagePhone = colleagePhone;
u002.colleageIdCard = colleageIdCard;
dbma1.SubmitChanges();
}
}
//P8010202 个人信息
public void FP8010202(string maritalStatusTypeSN, bool procreateStatus, string healthyStatusTypeSN, bool ifBasicLivingAllowance, string currentAddressProvinceSN, string currentAddressCitySN, string currentAddressDetails, string graduateSchool, string degreeTypeSN, string degreeCard, string friendName, string friendPhone)
{
string userSN = session["userSN"].ToString();
//string userSN = "U00001";
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
U002 u002 = dbma1.U002s.Where(c => c.userSN == userSN).First();
u002.maritalStatusTypeSN = maritalStatusTypeSN;
u002.procreateStatus = procreateStatus;
u002.healthyStatusTypeSN = healthyStatusTypeSN;
u002.ifBasicLivingAllowance = ifBasicLivingAllowance;
u002.currentAddressProvinceSN = currentAddressProvinceSN;
u002.currentAddressCitySN = currentAddressCitySN;
u002.currentAddressDetails = currentAddressDetails;
u002.graduateSchool = graduateSchool;
u002.degreeTypeSN = degreeTypeSN;
u002.degreeCard = degreeCard;
u002.friendName = friendName;
u002.friendPhone = friendPhone;
dbma1.SubmitChanges();
}
}
//更新用户信息基本表 U002
private void InvestSvrUpdateU002(DBMA1DataContext dbma1, U002 investSvrObj, string userSN)
{
U002 u002 = dbma1.U002s.Where(c => c.userSN == userSN).First();
u002.maritalStatusTypeSN = investSvrObj.maritalStatusTypeSN;
u002.procreateStatus = investSvrObj.procreateStatus;
u002.currentAddressProvinceSN = investSvrObj.currentAddressProvinceSN;
u002.currentAddressCitySN = investSvrObj.currentAddressCitySN;
u002.currentAddressDetails = investSvrObj.currentAddressDetails;
u002.workEnterprise = investSvrObj.workEnterprise;
u002.enterpriseTypeSN = investSvrObj.enterpriseTypeSN;
u002.workTel = investSvrObj.workTel;
u002.hiredate = investSvrObj.hiredate;
u002.post = investSvrObj.post;
u002.investMainTypeSN = investSvrObj.investMainTypeSN;
u002.financingMain = investSvrObj.financingMain;
u002.maxMortgageRate = investSvrObj.maxMortgageRate;
u002.guaranteeTypeSN = investSvrObj.guaranteeTypeSN;
u002.investProvinceSN = investSvrObj.investProvinceSN;
u002.investCitySN = investSvrObj.investCitySN;
u002.minInvestMoneyAmount = investSvrObj.minInvestMoneyAmount;
u002.minInterestRate = investSvrObj.minInterestRate;
u002.minInvestDays = investSvrObj.minInvestDays;
u002.maxInvestDays = investSvrObj.maxInvestDays;
u002.collateralDemand = investSvrObj.collateralDemand;
}
//更新用户信息基本表 U002
private void SellSvrUpdateU002(DBMA1DataContext dbma1, U002 svrObj, string userSN)
{
U002 u002 = dbma1.U002s.Where(c => c.userSN == userSN).First();
u002.maritalStatusTypeSN = svrObj.maritalStatusTypeSN;
u002.procreateStatus = svrObj.procreateStatus;
u002.currentAddressProvinceSN = svrObj.currentAddressProvinceSN;
u002.currentAddressCitySN = svrObj.currentAddressCitySN;
u002.currentAddressDetails = svrObj.currentAddressDetails;
}
//更新用户信息基本表 U002
private void PurchaseSvrUpdateU002(DBMA1DataContext dbma1, U002 PurchaseSvrObj, string userSN)
{
U002 u002 = dbma1.U002s.Where(c => c.userSN == userSN).First();
u002.maritalStatusTypeSN = PurchaseSvrObj.maritalStatusTypeSN;
u002.procreateStatus = PurchaseSvrObj.procreateStatus;
u002.currentAddressProvinceSN = PurchaseSvrObj.currentAddressProvinceSN;
u002.currentAddressCitySN = PurchaseSvrObj.currentAddressCitySN;
u002.currentAddressDetails = PurchaseSvrObj.currentAddressDetails;
u002.assetsProvince = PurchaseSvrObj.assetsProvince;
u002.minPurchasePrice = PurchaseSvrObj.minPurchasePrice;
u002.maxPurchasePrice = PurchaseSvrObj.maxPurchasePrice;
u002.assetsType = PurchaseSvrObj.assetsType;
}
//插入用户信息表
private void InsertIntoU002(DBMA1DataContext dbma1, string max33SN, string name, DateTime birthday, bool gender, string registeredResidence, string idCard, string phoneNum)
{
U002 u002 = new U002();
u002.userSN = max33SN;
u002.name = name;
u002.birthday = birthday;
u002.gender = gender;
u002.registeredResidence = registeredResidence;
u002.idCard = idCard;
u002.phone = phoneNum;
dbma1.U002s.InsertOnSubmit(u002);
}
//申请
public string FP8010506(string u002Str, string pwd)
{
string userSN = session["userSN"].ToString();
//string userSN = "U00004";
U002 consultantSvrObj = C101.FC10108(u002Str, typeof(U002)) as U002;
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
//密码是否正确
if (C201.FC20146(dbma1, userSN, pwd) == false)
{
return("0");
}
//扣款
A025 a025 = dbma1.A025s.First();
if (C201.FC20147(dbma1, userSN, Convert.ToDecimal(a025.openServerCost), "顾问申请", null) == false)
{
return("0");
}
//更新用户信息基本表 U002
ConcultantSvrUpdateU002(dbma1, consultantSvrObj, userSN);
//更新服务表 U001
ConcultantSvrUpdateU001(dbma1, userSN);
//更新顾问申请备案表 U006
ConsultantSvrApplyRecUpdateU006(dbma1, consultantSvrObj, userSN);
//加入成长值表 F006
string F006Max33SN = C101.FC10102("F006", 7, "UD");
F006 f006 = new F006();
f006.groupUpSN = F006Max33SN;
f006.userSN = userSN;
f006.businessSN = userSN;
f006.businessType = "顾问申请";
f006.transactionMoneyAmount = Convert.ToDecimal(a025.openServerCost);
f006.groupUpValue = a025.openServerCost;
f006.acquireDate = DateTime.Now;
dbma1.F006s.InsertOnSubmit(f006);
dbma1.SubmitChanges();
return("1");
}
}
//申请 P802010304
public string FP802010304(string SellingSvrData, string pwd)
{
string userSN = session["userSN"].ToString();
U002 svrObj = C101.FC10108(SellingSvrData, typeof(U002)) as U002;
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
//密码是否正确
if (C201.FC20146(dbma1, userSN, pwd) == false)
{
return("0");
}
//扣款
A027 a027 = dbma1.A027s.First();
if (C201.FC20147(dbma1, userSN, Convert.ToDecimal(a027.openServerCost), "出售申请", null) == false)
{
return("0");
}
//更新用户信息基本表 U002
SellSvrUpdateU002(dbma1, svrObj, userSN);
//更新服务表 U001
SellSvrUpdateU001(dbma1, userSN);
//加入成长值表 F006
string F006Max33SN = C101.FC10102("F006", 7, "UD");
F006 f006 = new F006();
f006.groupUpSN = F006Max33SN;
f006.userSN = userSN;
f006.businessSN = userSN;
f006.businessType = "出售申请";
f006.transactionMoneyAmount = Convert.ToDecimal(a027.openServerCost);
f006.groupUpValue = a027.openServerCost;
f006.acquireDate = DateTime.Now;
dbma1.F006s.InsertOnSubmit(f006);
dbma1.SubmitChanges();
return("1");
}
}
//P8010403 购买意向
public void FP8010403(string assetsProvince, decimal minPurchasePrice, decimal maxPurchasePrice, string assetsType)
{
string userSN = session["userSN"].ToString();
//string userSN = "U00001";
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
U002 u002 = dbma1.U002s.Where(c => c.userSN == userSN).First();
u002.assetsProvince = assetsProvince;
u002.minPurchasePrice = minPurchasePrice;
u002.maxPurchasePrice = maxPurchasePrice;
u002.assetsType = assetsType;
dbma1.SubmitChanges();
}
}
//P8010402 个人信息
public void FP8010402(string maritalStatusTypeSN, bool procreateStatus, string currentAddressProvinceSN, string currentAddressCitySN, string currentAddressDetails)
{
string userSN = session["userSN"].ToString();
//string userSN = "U00001";
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
U002 u002 = dbma1.U002s.Where(c => c.userSN == userSN).First();
u002.maritalStatusTypeSN = maritalStatusTypeSN;
u002.procreateStatus = procreateStatus;
u002.currentAddressProvinceSN = currentAddressProvinceSN;
u002.currentAddressCitySN = currentAddressCitySN;
u002.currentAddressDetails = currentAddressDetails;
dbma1.SubmitChanges();
}
}
//P8010502 个人信息
public void FP8010502(string maritalStatusTypeSN, bool procreateStatus, string currentAddressProvinceSN, string currentAddressCitySN, string currentAddressDetails, string graduateSchool, string degreeTypeSN, string degreeCard)
{
string userSN = session["userSN"].ToString();
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
U002 u002 = dbma1.U002s.Where(c => c.userSN == userSN).First();
u002.maritalStatusTypeSN = maritalStatusTypeSN;
u002.procreateStatus = procreateStatus;
u002.currentAddressProvinceSN = currentAddressProvinceSN;
u002.currentAddressCitySN = currentAddressCitySN;
u002.currentAddressDetails = currentAddressDetails;
u002.graduateSchool = graduateSchool;
u002.degreeTypeSN = degreeTypeSN;
u002.degreeCard = degreeCard;
dbma1.SubmitChanges();
}
}
//P8010205 财务信息
public void FP8010205(decimal monthlyTotalIncome, decimal monthlyTotalExpenditure, decimal monthlyNetIncome, decimal totalAssets, decimal totalDebt, bool ifCourtImplementation, bool creditStatus)
{
string userSN = session["userSN"].ToString();
//string userSN = "U00001";
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
U002 u002 = dbma1.U002s.Where(c => c.userSN == userSN).First();
u002.monthlyTotalIncome = monthlyTotalIncome;
u002.monthlyTotalExpenditure = monthlyTotalExpenditure;
u002.monthlyNetIncome = monthlyNetIncome;
u002.totalAssets = totalAssets;
u002.totalDebt = totalDebt;
u002.ifCourtImplementation = ifCourtImplementation;
u002.creditStatus = creditStatus;
dbma1.SubmitChanges();
}
}
//P8010504 顾问介绍
public void FP8010504(string serviceProvinceSN, string serviceCitySN, bool investigate, bool assetsEvaluate, bool creditRightGuarantee, bool badLoanCollect, string consultantDetails)
{
string userSN = session["userSN"].ToString();
//string userSN = "U00001";
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
U002 u002 = dbma1.U002s.Where(c => c.userSN == userSN).First();
u002.serviceProvinceSN = serviceProvinceSN;
u002.serviceCitySN = serviceCitySN;
u002.investigate = investigate;
u002.assetsEvaluate = assetsEvaluate;
u002.creditRightGuarantee = creditRightGuarantee;
u002.badLoanCollect = badLoanCollect;
u002.consultantDetails = consultantDetails;
dbma1.SubmitChanges();
}
}
//1:绑定成功;0:操作失败 不返回结果:2:原手机的验证码错误;3:新手机的验证码错误
public int FP80308(string oldPhone, string oldIC, string newPhone, string newIC)
{
string userSN = session["userSN"].ToString();
//string userSN = "U00001";
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
//新手机是否被注册
if (IfPhoneHasBeenReg(dbma1, newPhone) == true)
{
return(0);
}
//原手机验证码是否正确
if (IfIdentifyingCodeCorrect(dbma1, oldPhone, oldIC, "原手机验证") == false)
{
return(2);
}
//新手机验证码是否正确
if (IfIdentifyingCodeCorrect(dbma1, newPhone, newIC, "新手机验证") == false)
{
return(3);
}
//修改U000手机
U000 u000 = dbma1.U000s.Where(c => c.userSN == userSN).First();
u000.phone = newPhone;
//修改U002手机
U002 u002 = dbma1.U002s.Where(c => c.userSN == userSN).First();
u002.phone = newPhone;
dbma1.SubmitChanges();
return(1);
}
}
//更新顾问申请备案表 U006
private void ConsultantSvrApplyRecUpdateU006(DBMA1DataContext dbma1, U002 consultantSvrObj, string userSN)
{
U006 u006 = new U006();
U002 u002 = dbma1.U002s.Where(c => c.userSN == userSN).First();
u006.recordSN = C101.FC10102("U006", 6, "UE");
u006.userSN = userSN;
u006.name = u002.name;
u006.birthday = u002.birthday;
u006.gender = u002.gender;
u006.registeredResidence = u002.registeredResidence.Trim();
u006.idCard = u002.idCard;
u006.phone = u002.phone;
u006.email = consultantSvrObj.email;
u006.maritalStatusType = dbma1.A000s.Where(c => c.maritalStatusTypeSN == consultantSvrObj.maritalStatusTypeSN).First().value;
u006.procreateStatus = consultantSvrObj.procreateStatus;
u006.currentAddressProvince = dbma1.A021s.Where(c => c.provinceSN == consultantSvrObj.currentAddressProvinceSN).First().name;
u006.currentAddressCity = dbma1.A022s.Where(c => c.citySN == consultantSvrObj.currentAddressCitySN).First().name;
u006.currentAddressDetails = consultantSvrObj.currentAddressDetails;
u006.workEnterprise = consultantSvrObj.workEnterprise;
u006.enterpriseType = dbma1.A004s.Where(c => c.enterpriseTypeSN == consultantSvrObj.enterpriseTypeSN).First().value;
u006.industryType = dbma1.A013s.Where(c => c.industryTypeSN == consultantSvrObj.industryTypeSN).First().value;
u006.workTel = consultantSvrObj.workTel;
u006.hiredate = consultantSvrObj.hiredate;
u006.post = consultantSvrObj.post;
u006.graduateSchool = consultantSvrObj.graduateSchool;
u006.degreeType = dbma1.A002s.Where(c => c.degreeTypeSN == consultantSvrObj.degreeTypeSN).First().value;
u006.serviceProvince = dbma1.A021s.Where(c => c.provinceSN == consultantSvrObj.serviceProvinceSN).First().name;
u006.serviceCity = consultantSvrObj.serviceCitySN == "" ? null : dbma1.A022s.Where(c => c.citySN == consultantSvrObj.serviceCitySN).First().name;
u006.investigate = consultantSvrObj.investigate;
u006.assetsEvaluate = consultantSvrObj.assetsEvaluate;
u006.creditRightGuarantee = consultantSvrObj.creditRightGuarantee;
u006.badLoanCollect = consultantSvrObj.badLoanCollect;
u006.consultantDetails = consultantSvrObj.consultantDetails;
u006.applyDate = DateTime.Now;
dbma1.U006s.InsertOnSubmit(u006);
}
//P8010203 家庭信息
public void FP8010203(string spouseName, string spousePhone, string spouseIdCard, string spouseEnterprise, string kinName, string kinRelationshipTypeSN, string kinPhone, string kinIdCard, string kinEnterprise)
{
string userSN = session["userSN"].ToString();
//string userSN = "U00001";
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
U002 u002 = dbma1.U002s.Where(c => c.userSN == userSN).First();
u002.spouseName = spouseName;
u002.spousePhone = spousePhone;
u002.spouseIdCard = spouseIdCard;
u002.spouseEnterprise = spouseEnterprise;
u002.kinName = kinName;
u002.kinRelationshipTypeSN = kinRelationshipTypeSN;
u002.kinPhone = kinPhone;
u002.kinIdCard = kinIdCard;
u002.kinEnterprise = kinEnterprise;
dbma1.SubmitChanges();
}
}
//P8010103 投资意向
public void FP8010103(string investMainTypeSN, bool financingMain, decimal maxMortgageRate, string guaranteeTypeSN, string investProvinceSN, string investCitySN, decimal minInvestMoneyAmount, decimal minInterestRate, short minInvestDays, short maxInvestDays, string collateralDemand)
{
string userSN = session["userSN"].ToString();
//string userSN = "U00001";
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
U002 u002 = dbma1.U002s.Where(c => c.userSN == userSN).First();
u002.investMainTypeSN = investMainTypeSN;
u002.financingMain = financingMain;
u002.maxMortgageRate = maxMortgageRate;
u002.guaranteeTypeSN = guaranteeTypeSN;
u002.investProvinceSN = investProvinceSN;
u002.investCitySN = investCitySN;
u002.minInvestMoneyAmount = minInvestMoneyAmount;
u002.minInterestRate = minInterestRate;
u002.minInvestDays = minInvestDays;
u002.maxInvestDays = maxInvestDays;
u002.collateralDemand = collateralDemand;
dbma1.SubmitChanges();
}
}
//1:修改成功;0:操作失败 不返回结果:2:原邮箱不正确
public int FP80311(string oldEmail, string newEamil)
{
string userSN = session["userSN"].ToString();
//string userSN = "U00001";
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
U002 u002 = dbma1.U002s.Where(c => c.userSN == userSN).First();
//验证原邮箱是否正确
if (oldEmail != "")
{
string email = u002.email.Trim();
if (email == null)
{
if (oldEmail != "")
{
return(2);
}
}
else if (email != oldEmail.Trim())
{
return(2);
}
}
//修改绑定邮箱
u002.email = newEamil;
u002.ifChangeEmail = true;
dbma1.SubmitChanges();
return(1);
}
}
/// <summary>
/// 投资
/// </summary>
public void FP10204(string financierUserSN, string crSN, decimal investMoneyAmount, DateTime investDate, DateTime dealineDate, string repaymentTypeSN, decimal dailyRate)
{
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
//检查有效性（1、未被投资。2、债权未取消或者拒绝.）
var data1 = dbma1.P102s.Where(c => c.creditRightSN == crSN).FirstOrDefault();
if (data1 != null)
{
return;
}
string reserveSN;
var reserveCrP203 = (from c in dbma1.P203s
where c.creditRightSN == crSN &&
c.senderCancelReserveDate == null &&
c.receiverRefuseReserveDate == null
select c).FirstOrDefault();
if (reserveCrP203 == null)
{
var reserveCrP100 = (from c in dbma1.P100s
where c.creditRightSN == crSN &&
c.senderCancelReserveDate == null &&
c.receiverRefuseReserveDate == null
select c).FirstOrDefault();
//债权已被取消或者拒绝
if (reserveCrP100 == null)
{
return;
}
reserveSN = reserveCrP100.reserveSN;
}
else
{
reserveSN = reserveCrP203.reserveSN;
}
string investorUserSN = session["userSN"].ToString();
string max33 = C101.FC10102("P102", 6, "C");
P102 p102 = new P102();
p102.investSN = max33;
p102.reserveSN = reserveSN;
p102.investorUserSN = investorUserSN;
p102.financierUserSN = financierUserSN;
p102.creditRightSN = crSN;
p102.investMoneyAmount = investMoneyAmount;
p102.investDate = investDate;
p102.deadlineDate = dealineDate;
p102.repaymentTypeSN = repaymentTypeSN;
p102.dailyRate = dailyRate;
p102.verifyInvestDate = DateTime.Now;
dbma1.P102s.InsertOnSubmit(p102);
//产生账单
A024 a024 = dbma1.A024s.First();
decimal feeRate = Convert.ToDecimal(a024.serviceRateDaily);
decimal minRate = Convert.ToDecimal(a024.minServiceRateTotel);
decimal maxRate = Convert.ToDecimal(a024.maxServiceRateTotel);
int loanDays = (dealineDate - investDate).Days;
int loanMonth = loanDays / 30 + (loanDays % 30 == 0 ? 0 : 1);
decimal serverRate = Convert.ToDecimal(feeRate * Convert.ToDecimal(loanMonth));
serverRate = serverRate < minRate ? minRate : serverRate;
serverRate = serverRate > maxRate ? maxRate : serverRate;
string F001max33SN = C101.FC10102("F001", 6, "L");
F001 f001 = new F001();
f001.billSN = F001max33SN;
f001.payerUserSN = financierUserSN;
f001.businessSN = crSN;
f001.billType = "债权融资";
f001.MoneyAmount = serverRate * investMoneyAmount * 10000;
f001.generateDate = DateTime.Now;
dbma1.F001s.InsertOnSubmit(f001);
//融资方历史信息
U002 u002 = dbma1.U002s.Where(c => c.userSN == financierUserSN).First();
P105 p105 = new P105();
string max33SN = C101.FC10102("P105", 7, "CB");
//案例情况
var caseStatus = dbma1.P102s.Where(c => c.financierUserSN == financierUserSN);
short caseAmount = Convert.ToInt16(caseStatus.Count());
decimal caseMoneyAmount = caseAmount == 0 ? 0 : caseStatus.Sum(c => c.investMoneyAmount);
//当前债务情况
var debtStatus = dbma1.P102s.Where(c => c.financierUserSN == financierUserSN && c.closeCaseDate == null);
short debtAmount = Convert.ToInt16(debtStatus.Count());
decimal debtMoneyAmount = debtAmount == 0 ? 0 : debtStatus.Sum(c => c.investMoneyAmount);
//当前逾期情况
var currentOverdueStatus = from c in dbma1.P102s
where c.financierUserSN == financierUserSN &&
c.closeCaseDate == null &&
DateTime.Now > c.deadlineDate
select c;
short currentOverdueAmount = Convert.ToInt16(currentOverdueStatus.Count());
decimal currentOverdueMoneyAmount = currentOverdueAmount == 0 ? 0 : currentOverdueStatus.Sum(c => c.investMoneyAmount);
//历史逾期数量
var historyOverdueStatus = from c in dbma1.P102s
from p in c.P103s
where c.financierUserSN == financierUserSN &&
c.deadlineDate < p.repayDate &&
c.investSN == p.investSN
select c;
short historyOverdueAmount = Convert.ToInt16(historyOverdueStatus.Count());
p105.financierHistoryInfoSN = max33SN;
p105.creditRightSN = crSN;
p105.investSN = max33;
p105.historyDate = DateTime.Now;
p105.userSN = u002.userSN;
p105.name = u002.name;
p105.birthday = u002.birthday;
p105.gender = u002.gender;
p105.registeredResidence = u002.registeredResidence;
p105.idCard = u002.idCard;
p105.phone = u002.phone;
p105.email = u002.email;
p105.maritalStatusTypeSN = u002.maritalStatusTypeSN;
p105.procreateStatus = u002.procreateStatus;
p105.healthyStatusTypeSN = u002.healthyStatusTypeSN;
p105.ifBasicLivingAllowance = u002.ifBasicLivingAllowance;
p105.currentAddressProvinceSN = u002.currentAddressProvinceSN;
p105.currentAddressCitySN = u002.currentAddressCitySN;
p105.currentAddressDetails = u002.currentAddressDetails;
p105.graduateSchool = u002.graduateSchool;
p105.degreeTypeSN = u002.degreeTypeSN;
p105.degreeCard = u002.degreeCard;
p105.friendName = u002.friendName;
p105.friendPhone = u002.friendPhone;
p105.spouseName = u002.spouseName;
p105.spousePhone = u002.spousePhone;
p105.spouseIdCard = u002.spouseIdCard;
p105.spouseEnterprise = u002.spouseEnterprise;
p105.kinName = u002.kinName;
p105.kinRelationshipTypeSN = u002.kinRelationshipTypeSN;
p105.kinPhone = u002.kinPhone;
p105.kinIdCard = u002.kinIdCard;
p105.kinEnterprise = u002.kinEnterprise;
p105.workEnterprise = u002.workEnterprise;
p105.enterpriseTypeSN = u002.enterpriseTypeSN;
p105.hiredate = u002.hiredate;
p105.workTel = u002.workTel;
p105.post = u002.post;
p105.enterpriseSwitchboard = u002.enterpriseSwitchboard;
p105.enterpriseWebsite = u002.enterpriseWebsite;
p105.colleageName = u002.colleageName;
p105.colleagePhone = u002.colleagePhone;
p105.monthlyTotalIncome = u002.monthlyTotalIncome;
p105.monthlyTotalExpenditure = u002.monthlyTotalExpenditure;
p105.monthlyNetIncome = u002.monthlyNetIncome;
p105.totalAssets = u002.totalAssets;
p105.totalDebt = u002.totalDebt;
p105.ifCourtImplementation = u002.ifCourtImplementation;
p105.creditStatus = u002.creditStatus;
p105.caseAmount = caseAmount;
p105.caseMoneyAmount = caseMoneyAmount;
p105.currentDebtAmount = debtAmount;
p105.debtMoneyAmount = debtMoneyAmount;
p105.currentOverdue = currentOverdueAmount;
p105.overdueMoneyAmount = currentOverdueMoneyAmount;
p105.historyOverdueAmount = historyOverdueAmount;
dbma1.P105s.InsertOnSubmit(p105);
dbma1.SubmitChanges();
U003 u003 = dbma1.U003s.Where(c => c.userSN == financierUserSN).First();
//如有邮箱提醒
if (u003.billGenerate_email == true)
{
SendBillEmail(dbma1, financierUserSN, crSN, f001.billSN, Convert.ToDecimal(f001.MoneyAmount));
}
//如有短信提醒
if (u003.billGenerate_shortMessage == true)
{
SendBillSM(dbma1, financierUserSN, crSN, f001.billSN, Convert.ToDecimal(f001.MoneyAmount));
}
dbma1.SubmitChanges();
}
}
/// <summary>
/// 获取uip
/// </summary>
public string FP80200()
{
if (session["userSN"] == null)
{
return("notLogin");
}
string userSN = session["userSN"].ToString();
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
string provinceData = C201.FC20121(dbma1).Replace("[", "").Replace("]", "");
string marital = C201.FC20100(dbma1).Replace("[", "").Replace("]", "");
string enterpriseType = C201.FC20104(dbma1).Replace("[", "").Replace("]", "");
string investMain = C201.FC20106(dbma1).Replace("[", "").Replace("]", "");
string guaranteeType = C201.FC20117(dbma1).Replace("[", "").Replace("]", "");
string assetsType = C201.FC20108(dbma1).Replace("[", "").Replace("]", "");
string degreeType = C201.FC20102(dbma1).Replace("[", "").Replace("]", "");
string healthStatus = C201.FC20101(dbma1).Replace("[", "").Replace("]", "");
//string creditStatusType = C201.FC20105(dbma1).Replace("[", "").Replace("]", "");
string industryType = C201.FC20113(dbma1).Replace("[", "").Replace("]", "");
string cityData = C201.FC20148(dbma1);
U002 u002 = dbma1.U002s.Where(c => c.userSN == userSN).First();
//当前成长值
decimal currentGroupValue = Convert.ToInt32(dbma1.F006s.Where(c => c.userSN == userSN).Sum(c => c.groupUpValue));
var userInfo = new { No = u002.userSN, Name = u002.name, Sex = u002.gender, BirthDay = u002.birthday, CardID = u002.idCard.Substring(0, 6) + "*", Mobile = u002.phone, CardAddress = u002.registeredResidence, MyGrow = currentGroupValue };
string userInfoStr = C101.FC10107(userInfo);
var investParams = dbma1.A023s.First();
var financingParams = dbma1.A024s.First();
var consultantParams = dbma1.A025s.First();
var purchaseParams = dbma1.A026s.First();
var sellParams = dbma1.A027s.First();
var PawnRate = new { Min = investParams.minMorgageRate, Max = investParams.maxMorgageRate };
var InvestAmt = new { Min = investParams.minInvestMoneyAmount, Max = investParams.maxInvestMoneyAmount };
var DayRate = new { Min = investParams.minDailyRate, Max = investParams.maxDailyRate };
var InvestLimit = new { Min = investParams.minInvestDays, Max = investParams.maxInvestDays };
var BayAmt = new { Min = purchaseParams.minPurchasePrice, Max = purchaseParams.maxPurchasePrice };
//var MTIn = new {Min = null,Max = null};
//var MTOut = new {Min = null,Max = null};
//var MCIn = new { Min = null, MAx = null };
var TAsset = new { Min = financingParams.minTotalAssets, Max = financingParams.maxTotalAssets };
var TBorrow = new { Min = financingParams.minTotalLiability, Max = financingParams.maxTotalLiability };
var CAsset = new { Min = financingParams.minTotalAssets, Max = financingParams.maxTotalAssets };
string PawnRateStr = C101.FC10107(PawnRate);
string InvestAmtStr = C101.FC10107(InvestAmt);
string DayRateStr = C101.FC10107(DayRate);
string InvestLimitStr = C101.FC10107(InvestLimit);
string BayAmtStr = C101.FC10107(BayAmt);
string TAssetStr = C101.FC10107(TAsset);
string TBorrowStr = C101.FC10107(TBorrow);
string CAssetStr = C101.FC10107(CAsset);
U001 u001 = dbma1.U001s.Where(c => c.userSN == userSN).First();
string investApplyStatus = u001.creditRightInvestApplyStauts == 2 ? "1" : "0";
string financingApplyStatus = u001.creditRightFinancingApplyStatus == 2 ? "1" : "0";
string sellApplyStatus = u001.assetsSellingApplyStatus == 2 ? "1" : "0";
string purchaseApplyStatus = u001.assetsPurchaseApplyStatus == 2 ? "1" : "0";
string consultantApplyStatus = u001.consultantApplyStatus == 2 ? "1" : "0";
if (u001.consultantApplyStatus == 0)
{
consultantApplyStatus = "0";
}
else if (u001.consultantApplyStatus == 1)
{
consultantApplyStatus = "2";
}
else if (u001.consultantApplyStatus == 2)
{
consultantApplyStatus = "1";
}
else if (u001.consultantApplyStatus == 3)
{
consultantApplyStatus = "0";
}
string CreditInvestStr = "\"\"";
string CreditBorrowStr = "\"\"";
string AssetsSalesStr = "\"\"";
string AssetsBuyStr = "\"\"";
string AdviserServerStr = "\"\"";
//投资
if (investApplyStatus == "1")
{
var userLinq = dbma1.P102s.Where(c => c.investorUserSN == userSN);
//债权总额
decimal crMoneyAmount = (from c in dbma1.P102s
where c.investorUserSN == userSN
//&& c.closeCaseDate == null
select new
{
c.investMoneyAmount
}).ToList().Sum(r => r.investMoneyAmount);
//债权数量
int crAmount = (from c in dbma1.P102s
where c.investorUserSN == userSN
//&& c.closeCaseDate == null
select c).Count();
//投资收益
decimal investEarnings = (from c in userLinq
from o in c.P103s
where c.closeCaseDate != null
select new
{
earnings = (o.repayDate - c.investDate).Days * c.dailyRate * c.investMoneyAmount
}).ToList().Sum(c => c.earnings);
var CreditInvest = new { TotalPrice = crMoneyAmount, TotalNum = crAmount, TotalIncome = investEarnings };
CreditInvestStr = C101.FC10107(CreditInvest);
}
//融资
if (financingApplyStatus == "1")
{
//正在融资
int financingAmount = (from c in dbma1.P200s
where c.publisherUserSN == userSN &&
c.cancelDate == null &&
!dbma1.P102s.Any(o => o.creditRightSN == c.creditRightSN)
select c).Count();
//正在还款
int repayingAmount = (from c in dbma1.P102s
where c.financierUserSN == userSN &&
c.closeCaseDate == null
select c).Count();
//即将逾期
//即将逾期天数
int aboutToOverdueDays = 30;
int aboutToOverdueAmount = (from c in dbma1.P102s
where c.financierUserSN == userSN &&
c.closeCaseDate == null &&
DateTime.Now.AddDays(aboutToOverdueDays) > c.deadlineDate &&
DateTime.Now <= c.deadlineDate
select c).Count();
var CreditBorrow = new { Borrowing = financingAmount, Paying = repayingAmount, Overdue = aboutToOverdueAmount };
CreditBorrowStr = C101.FC10107(CreditBorrow);
}
//资产出售
if (sellApplyStatus == "1")
{
//已发布
int publishAssetsAmount = (from c in dbma1.VP401001s
where c.publisherUserSN == userSN
select c).Count();
//预约中
//int reservingAssetsAmount = (from c in dbma1.P400s
// where c.receiverUserSN == userSN
// && c.senderCancelReserveDate == null
// && c.receiverRefuseReserveDate == null
// && !c.P401s.Any()
// select c).Count();
int reservingAssetsAmount = (from c in dbma1.VP402011s
where c.receiverUserSN == userSN
select c).Count();
//已成交
//int purchasedAssetsAmount = dbma1.P401s.Where(c => c.sellerUserSN == userSN).Count();
int purchasedAssetsAmount = (from c in dbma1.VP404001s
where c.sellerUserSN == userSN &&
c.sellerDeleteDate == null
select c).Count();
var AssetsSales = new { Publish = publishAssetsAmount, Booking = reservingAssetsAmount, Close = purchasedAssetsAmount };
AssetsSalesStr = C101.FC10107(AssetsSales);
}
//资产购买
if (purchaseApplyStatus == "1")
{
//预约中
//int reservingAssetsAmount = (from c in dbma1.P400s
// where c.senderUserSN == userSN
// && c.senderCancelReserveDate == null
// && c.receiverRefuseReserveDate == null
// && !c.P401s.Any()
// select c).Count();
int reservingAssetsAmount = (from c in dbma1.VP402011s
where c.senderUserSN == userSN
select c).Count();
//已成交
//int purchasedAssetsAmount = dbma1.P401s.Where(c => c.purchaserUserSN == userSN).Count();
int purchasedAssetsAmount = (from c in dbma1.VP404001s
where c.purchaserUserSN == userSN &&
c.purchaserDeleteDate == null
select c).Count();
var AssetsBuy = new { Booking = reservingAssetsAmount, Close = purchasedAssetsAmount };
AssetsBuyStr = C101.FC10107(AssetsBuy);
}
//财务管理
if (consultantApplyStatus == "1")
{
//预约中
int reserveAmount = (from c in dbma1.VP502001s
where c.consultantUserSN == userSN
select c).Count();
//服务中
int servicingAmount = (from c in dbma1.VP503001s
where c.consultantUserSN == userSN
select c).Count();
//已结案
int servicedAmount = (from c in dbma1.VP504021s
where c.consultantUserSN == userSN
select c).Count();
////已成交
//int investAmount = (from c in dbma1.P500s.Where(c => c.consultantUserSN == userSN && c.auditStatus != null)
// join o in dbma1.P101s on c.reserveSN equals o.reserveSN
// join p in dbma1.P102s on o.creditRightReserveSN equals p.reserveSN
// select c).Count();
var AdviserServer = new { Booking = reserveAmount, Serving = servicingAmount, Close = servicedAmount };
AdviserServerStr = C101.FC10107(AdviserServer);
}
//财务管理
decimal balanceV = dbma1.F000s.Where(c => c.userSN == userSN).First().balance;
decimal usedV = Convert.ToDecimal
(
(from c in dbma1.F003s
where c.generetorUserSN == userSN &&
c.expenditure != null
select c.expenditure).Sum()
);
int needPayBillAmount = (from c in dbma1.F001s
where c.payerUserSN == userSN &&
!dbma1.F002s.Any(o => o.billSN == c.billSN)
select c).Count();
var cwData = new { RemainVB = balanceV, UsedVB = usedV, Payable = needPayBillAmount };
string FinaceStr = C101.FC10107(cwData);
//成长值
string GrowUpInfoStr = GrowUp(dbma1, userSN, currentGroupValue);
//安全管理
int temp = 0;
if (dbma1.U000s.Where(c => c.userSN == userSN).First().ifChangePwd == true)
{
temp++;
}
if (dbma1.U003s.Where(c => c.userSN == userSN).First().ifChangeTransactPwd == true)
{
temp++;
}
if (u002.ifChangeEmail == true)
{
temp++;
}
string level = string.Empty;
if (temp == 0 || temp == 1)
{
level = "低";
}
else if (temp == 2)
{
level = "中";
}
else
{
level = "高";
}
var SafeManage = new { Leval = level, Mobile = u002.phone, Email = u002.email == null ? "" : u002.email };
string SafeManageStr = C101.FC10107(SafeManage);
//服务费
var SvrFee = new { Invest = investParams.openServerCost, Borrow = financingParams.openServerCost, AssetSale = sellParams.openServerCost, AssetBuy = purchaseParams.openServerCost, Adviser = consultantParams.openServerCost };
string SvrFeeStr = C101.FC10107(SvrFee);
//账单逾期及停止服务
A028 a028 = dbma1.A028s.First();
var SvrStopTip = new { Day = a028.serverStopDays, Rate = a028.serverStopRate };
var OverdueTip = new { Day = Convert.ToInt32(a028.needPayDays), Rate = a028.overdueRateDaily };
string SvrStopTipStr = C101.FC10107(SvrStopTip);
string OverdueTipStr = C101.FC10107(OverdueTip);
//注册奖励V币数
decimal SentScore = Convert.ToInt32(dbma1.A031s.First().regPresentV);
//账单情况
string billStatus;
//无未付账单
if (needPayBillAmount == 0)
{
billStatus = "0";
}
else
{
var linq = (from c in dbma1.F001s
where c.payerUserSN == userSN &&
!dbma1.F002s.Any(o => o.billSN == c.billSN) &&
(DateTime.Now - c.generateDate).Days >= OverdueTip.Day
select c).FirstOrDefault();
//付款未超过规定时间
if (linq == null)
{
billStatus = "1";
}
//付款超过规定时间
else
{
billStatus = "2";
}
}
//是否已经领取V币
string ifGetV = (from c in dbma1.F004s
where c.userSN == userSN &&
c.rewardType.Trim() == "注册赠送"
select c).FirstOrDefault() == null ? "1" : "0";
string res;
res = string.Format("{{\"SltConfigData\":[{0},{1},{2},{3},{4},{5},{6},{7},{8}],\"PawnRate\":{9},\"InvestAmt\":{10},\"DayRate\":{11},\"InvestLimit\":{12},\"BayAmt\":{13},\"TAsset\":{14},\"TBorrow\":{15},\"CAsset\":{16},\"CreditInvest\":{17},\"CreditBorrow\":{18},\"AssetsSales\":{19},\"AssetsBuy\":{20},\"AdviserServer\":{21},\"Finace\":{22},\"GrowUpInfo\":{23},\"SafeManage\":{24},\"SvrFee\":{25},\"SvrStopTip\":{26},\"OverdueTip\":{27},\"SentScore\":\"{28}\",\"investApplyStatus\":\"{29}\",\"financingApplyStatus\":\"{30}\",\"sellApplyStatus\":\"{31}\",\"purchaseApplyStatus\":\"{32}\",\"consultantApplyStatus\":\"{33}\",\"investStatus\":\"{34}\",\"financingStatus\":\"{35}\",\"sellStatus\":\"{36}\",\"purchaseStatus\":\"{37}\",\"consultantStatus\":\"{38}\",\"ifGetV\":\"{39}\",\"UserInfo\":{40},\"billStatus\":\"{41}\",\"cityData\":{42}}}", provinceData, marital, enterpriseType, investMain, guaranteeType, assetsType, degreeType, healthStatus, industryType, PawnRateStr, InvestAmtStr, DayRateStr, InvestLimitStr, BayAmtStr, TAssetStr, TBorrowStr, CAssetStr, CreditInvestStr, CreditBorrowStr, AssetsSalesStr, AssetsBuyStr, AdviserServerStr, FinaceStr, GrowUpInfoStr, SafeManageStr, SvrFeeStr, SvrStopTipStr, OverdueTipStr, SentScore, investApplyStatus, financingApplyStatus, sellApplyStatus, purchaseApplyStatus, consultantApplyStatus, u001.creditRightInvestStatus, u001.creditRightFinancingStatus, u001.assetsSellingStatus, u001.assetsPruchaseStatus, u001.consultantStatus, ifGetV, userInfoStr, billStatus, cityData);
return(res);
}
}
