public string FP8010100()
{
//判断是否登录
if (session["userSN"] == null)
{
return("notLogin");
}
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
//获取uip
string provinceData = C201.FC20121(dbma1).Replace("[", "").Replace("]", "");
string kinRelationType = C201.FC20103(dbma1).Replace("[", "").Replace("]", "");
string maritalStatusType = C201.FC20100(dbma1).Replace("[", "").Replace("]", "");
string enterpriseType = C201.FC20104(dbma1).Replace("[", "").Replace("]", "");
string investMainType = 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 healthyStatusType = C201.FC20101(dbma1).Replace("[", "").Replace("]", "");
//string creditStatusType = C201.FC20105(dbma1).Replace("[", "").Replace("]", "");
string industryType = C201.FC20113(dbma1).Replace("[", "").Replace("]", "");
A023 a023 = dbma1.A023s.First();
A024 a024 = dbma1.A024s.First();
A026 a026 = dbma1.A026s.First();
var PawnRate = new { Min = a023.minMorgageRate, Max = a023.maxMorgageRate };
var InvestAmt = new { Min = a023.minInvestMoneyAmount, Max = a023.maxInvestMoneyAmount };
var DayRate = new { Min = a023.minDailyRate, Max = a023.maxDailyRate };
var InvestLimit = new { Min = a023.minInvestDays, Max = a023.maxInvestDays };
var BayAmt = new { Min = a026.minPurchasePrice, Max = a026.maxPurchasePrice };
var TAsset = new { Min = a024.minTotalAssets, Max = a024.maxTotalAssets };
var TLiability = new { Min = a024.maxTotalLiability, Max = a024.maxTotalLiability };
var CAsset = new { Min = a024.minNetAssets, Max = a024.maxNetAssets };
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 TLiabilityStr = C101.FC10107(TLiability);
string CAssetStr = C101.FC10107(CAsset);
//获取用户信息-债权投资
string userSN = session["userSN"].ToString();
//string userSN = "U00001";
string userData = GetUserData(dbma1, userSN);
return(string.Format("{{\"uip\":{{\"SltConfigData\":[{0},{1},{2},{3},{4},{5},{6},{7},{8},{9}],\"PawnRate\":{10},\"InvestAmt\":{11},\"DayRate\":{12},\"InvestLimit\":{13},\"BayAmt\":{14},\"TAsset\":{15},\"TLiability\":{16},\"CAsset\":{17}}},\"userData\":{18},\"userSN\":\"{19}\"}}", provinceData, kinRelationType, maritalStatusType, enterpriseType, investMainType, guaranteeType, assetsType, degreeType, healthyStatusType, industryType, PawnRateStr, InvestAmtStr, DayRateStr, InvestLimitStr, BayAmtStr, TAssetStr, TLiabilityStr, CAssetStr, userData, userSN));
}
}
public string FP10109()
{
string userSN = session["userSN"].ToString();
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
//发布费用
A023 a023 = dbma1.A023s.First();
decimal?reserveFee = a023.financingReserveCost;
//账户余额
F000 f000 = dbma1.F000s.Where(c => c.userSN == userSN).First();
decimal balance = f000.balance;
return(string.Format("{{\"reserveFee\":\"{0}\",\"balance\":\"{1}\"}}", reserveFee, balance));
}
}
/// <summary>
/// 投资服务申请
/// </summary>
public string FP802010106(string investSvrData, string pwd)
{
string userSN = session["userSN"].ToString();
//string userSN = "U00004";
U002 investSvrObj = C101.FC10108(investSvrData, typeof(U002)) as U002;
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
//密码是否正确
if (C201.FC20146(dbma1, userSN, pwd) == false)
{
return("0");
}
//扣款
A023 a023 = dbma1.A023s.First();
if (C201.FC20147(dbma1, userSN, Convert.ToDecimal(a023.openServerCost), "投资申请", null) == false)
{
return("2");
}
//更新用户信息基本表 U002
InvestSvrUpdateU002(dbma1, investSvrObj, userSN);
//更新服务表 U001
InvestSvrUpdateU001(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(a023.openServerCost);
f006.groupUpValue = a023.openServerCost;
f006.acquireDate = DateTime.Now;
dbma1.F006s.InsertOnSubmit(f006);
dbma1.SubmitChanges();
return("1");
}
}
/// <summary>
/// 获取选择顾问列表
/// </summary>
public string FP10210(string crSN, string sortStr)
{
string investorUserSN = session["userSN"].ToString();
string orderStr = string.Empty;
string[] sortStrSplit = sortStr.Split(',');
for (int i = 1; i < (sortStrSplit.Length - 1); i++)
{
string[] sortStrSplitSplit = sortStrSplit[i].Split('#');
if ((i != 1))
{
orderStr += ",";
}
orderStr += sortStrSplitSplit[0] == "1" ? " successCaseAmount" : " caseAmount";
orderStr += sortStrSplitSplit[1] == "A" ? "" : " desc";
}
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
List <SelectConsultantList> consultantList = null;
string sqlStr = string.Format("select VP509011.consultantUserSN,VP509011.serviceProvince,VP509011.serviceCity,VP509011.caseAmount,VP509011.successCaseAmount,A.qualificationSN from VP509011 left join (select consultantUserSN,qualificationSN from P104 where investorUserSN = '{0}' and creditRightSN = '{1}') as A on VP509011.consultantUserSN = A.consultantUserSN", investorUserSN, crSN);
if (orderStr == string.Empty)
{
consultantList = dbma1.ExecuteQuery <SelectConsultantList>(sqlStr).ToList();
}
else
{
sqlStr = string.Format("{0} order by {1}", sqlStr, orderStr);
consultantList = dbma1.ExecuteQuery <SelectConsultantList>(sqlStr).ToList();
}
//发布费用
A023 a023 = dbma1.A023s.First();
decimal?fee = a023.consultantReserveCost;
//账户余额
F000 f000 = dbma1.F000s.Where(c => c.userSN == investorUserSN).First();
decimal balance = f000.balance;
return(string.Format("{{\"balance\":\"{0}\",\"fee\":\"{1}\",\"consultantDataList\":{2}}}", balance, fee, C101.FC10107(consultantList)));
}
}
/// <summary>
/// 投资方债权预约
/// </summary>
public string FP10107(string pwd, string crSN, string financierUserSN)
{
string investorSN = session["userSN"].ToString();
//string investorSN = "U00002";
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
//预约失效
if (dbma1.VP101001s.Where(c => c.creditRightSN == crSN).FirstOrDefault() == null)
{
return("false");
}
//验证交易密码是否正确
string transPwd = dbma1.U003s.Where(c => c.userSN == investorSN).First().transactPwd;
if (C101.FC10104(pwd, transPwd) == false)
{
return("false");
}
//从余额中扣除服务费 F000
A023 a023 = dbma1.A023s.First();
decimal reserveFee = Convert.ToDecimal(a023.financingReserveCost);
F000 f000 = dbma1.F000s.Where(c => c.userSN == investorSN).First();
if (f000.balance < reserveFee)
{
return("false");
}
f000.balance -= reserveFee;
//加入收支明细表中 F003
string F003max33SN = C101.FC10102("F003", 8, "UA");
F003 f003 = new F003();
f003.revenueExpenditureSN = F003max33SN;
f003.generetorUserSN = investorSN;
f003.generateDate = DateTime.Now;
f003.type = "债权预约";
f003.expenditure = reserveFee;
f003.balance = f000.balance;
dbma1.F003s.InsertOnSubmit(f003);
//预约
string max33SN = C101.FC10102("P100", 7, "A");
P100 p100 = new P100();
p100.reserveSN = max33SN;
p100.senderUserSN = investorSN;
p100.receiverUserSN = financierUserSN;
p100.creditRightSN = crSN;
p100.sendDate = DateTime.Now;
dbma1.P100s.InsertOnSubmit(p100);
//加入成长值表 F006
string F006Max33SN = C101.FC10102("F006", 7, "UD");
F006 f006 = new F006();
f006.groupUpSN = F006Max33SN;
f006.userSN = investorSN;
f006.businessSN = max33SN;
f006.businessType = "债权预约";
f006.transactionMoneyAmount = reserveFee;
f006.groupUpValue = reserveFee;
f006.acquireDate = DateTime.Now;
dbma1.F006s.InsertOnSubmit(f006);
dbma1.SubmitChanges();
U003 u003 = dbma1.U003s.Where(c => c.userSN == financierUserSN).First();
//如有邮箱提醒
if (u003.billGenerate_email == true)
{
SendByEmail(dbma1, financierUserSN, crSN);
}
//如有短信提醒
if (u003.billGenerate_shortMessage == true)
{
SendBySM(dbma1, financierUserSN, crSN);
}
dbma1.SubmitChanges();
return("true");
}
}
/// <summary>
/// 获得顾问隐藏的信息
/// 0:操作失败 不返回失败原因;1:操作成功;2;操作失败 失败原因余额不足
/// </summary>
public string FP10213(string pwd, string consultantUserSN, string crSN)
{
string investorUserSN = session["userSN"].ToString();
//string investorUserSN = "U00002";
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
//检查有效性（1、没有被投资。2、债权已经被取消或者拒绝）
var data1 = dbma1.P102s.Where(c => c.creditRightSN == crSN).FirstOrDefault();
var data2 = (from c in dbma1.P203s
where c.creditRightSN == crSN &&
c.senderCancelReserveDate == null &&
c.receiverRefuseReserveDate == null
select c).FirstOrDefault();
var data3 = (from c in dbma1.P100s
where c.creditRightSN == crSN &&
c.senderCancelReserveDate == null &&
c.receiverRefuseReserveDate == null
select c).FirstOrDefault();
if (data1 != null || (data2 == null && data3 == null))
{
return("0");
}
///验证交易密码是否正确
string transPwd = dbma1.U003s.Where(c => c.userSN == investorUserSN).First().transactPwd;
if (C101.FC10104(pwd, transPwd) == false)
{
return("0");
}
//从余额中扣除服务费 F000
A023 a023 = dbma1.A023s.First();
decimal fee = Convert.ToDecimal(a023.consultantReserveCost);
F000 f000 = dbma1.F000s.Where(c => c.userSN == investorUserSN).First();
if (f000.balance < fee)
{
return("2");
}
f000.balance -= fee;
//加入收支明细表中 F003
string F003max33SN = C101.FC10102("F003", 8, "UA");
F003 f003 = new F003();
f003.revenueExpenditureSN = F003max33SN;
f003.generetorUserSN = investorUserSN;
f003.generateDate = DateTime.Now;
f003.type = "顾问预约";
f003.expenditure = fee;
f003.balance = f000.balance;
dbma1.F003s.InsertOnSubmit(f003);
//获取隐藏信息
var consultantBasicData = (from c in dbma1.VP801001s
where c.userSN == consultantUserSN
select new
{
c.name,
idCard = c.idCard.Substring(0, 6),
c.phone,
c.email,
c.currentAddressProvince,
c.currentAddressCity,
c.currentAddressDetails
}).First();
string consultantBasicDataStr = C101.FC10107(consultantBasicData);
//添加一条投资方查看顾问信息资格表记录，P104
string max33SN = AddRecord(dbma1, investorUserSN, consultantUserSN, crSN);
//加入成长值表 F006
string F006Max33SN = C101.FC10102("F006", 7, "UD");
F006 f006 = new F006();
f006.groupUpSN = F006Max33SN;
f006.userSN = investorUserSN;
f006.businessSN = max33SN;
f006.businessType = "顾问预约";
f006.transactionMoneyAmount = fee;
f006.groupUpValue = fee;
f006.acquireDate = DateTime.Now;
dbma1.F006s.InsertOnSubmit(f006);
dbma1.SubmitChanges();
return(string.Format("{{\"status\":\"{0}\",\"consultantHideData\":{1}}}", 1, consultantBasicDataStr));
}
}
