public string FP40101(int pageSize)
{
//判断是否登录
if (session["userSN"] == null)
{
return("notLogin");
}
string userSN = session["userSN"].ToString();
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
//判断是否有权限
var data = dbma1.U001s.Where(c => c.userSN == userSN).First();
bool ifBillOverdue = C201.FC20153(dbma1, userSN);
if (data.assetsPruchaseStatus != true || ifBillOverdue == true)
{
return("{\"status\":\"false\"}");
}
string userName = dbma1.U000s.Where(c => c.userSN == userSN).First().name;
string CancelReason = C201.FC20137(dbma1);
var vp401001List = (from c in dbma1.VP401001s
orderby c.publishDate descending
select c).Take(pageSize).ToList();
string vp401001ListStr = C101.FC10107(vp401001List);
return(string.Format("{{\"status\":\"true\",\"userName\":\"{0}\",\"CancelReason\":{1},\"dataList\":{2},\"maxDatetime\":\"{3}\",\"userSN\":\"{4}\"}}", userName, CancelReason, vp401001ListStr, DateTime.Now, userSN));
}
}
public string FP50307(string serverSN)
{
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
string investorUserSN = dbma1.P500s.Where(c => c.serverSN == serverSN).First().investorUserSN;
return(C201.FC20144(investorUserSN));
}
}
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));
}
}
/// <summary>
/// 债权融资页面初始化
/// </summary>
public string FP20101(int pageSize)
{
//判断是否登录
if (session["userSN"] == null)
{
return("notLogin");
}
string userSN = session["userSN"].ToString();
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
//判断是否有权限并且是否有逾期账单
var data1 = dbma1.U001s.Where(c => c.userSN == userSN).First();
bool ifBillOverdue = C201.FC20153(dbma1, userSN);
if (data1.creditRightFinancingStatus != true || ifBillOverdue == true)
{
return("{\"status\":\"false\"}");
}
//获取uip数据
string provinceData = C201.FC20121(dbma1).Replace("[", "").Replace("]", "");
string guaranteeType = C201.FC20117(dbma1).Replace("[", "").Replace("]", "");
string assetsType = C201.FC20151(dbma1).Replace("[", "").Replace("]", "");
string creditStatusType = C201.FC20105(dbma1).Replace("[", "").Replace("]", "");
string industryType = C201.FC20113(dbma1).Replace("[", "").Replace("]", "");
string repaymentType = C201.FC20114(dbma1).Replace("[", "").Replace("]", "");
string capitalPurposeType = C201.FC20115(dbma1).Replace("[", "").Replace("]", "");
string repaymentSourceType = C201.FC20116(dbma1).Replace("[", "").Replace("]", "");
string assetsSourceType = C201.FC20109(dbma1).Replace("[", "").Replace("]", "");
string useStatusType = C201.FC20110(dbma1).Replace("[", "").Replace("]", "");
string morgageType = C201.FC20112(dbma1).Replace("[", "").Replace("]", "");
string financierCancelReserveReasonType = C201.FC20130(dbma1).Replace("[", "").Replace("]", "");
string financierRefuseReserveReasonType = C201.FC20131(dbma1).Replace("[", "").Replace("]", "");
string financingParams = C201.FC20124(dbma1);
//string res = string.Format("{{\"SltConfigData\":[{0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10}],{11}}}", provinceData, guaranteeType, assetsType, creditStatusType, industryType, repaymentType, capitalPurposeType, repaymentSourceType, assetsSourceType, useStatusType, morgageType, financingParams);
//获取已发布的债权
string crListStr = GetCrFirst(dbma1, userSN, pageSize);
string userName = dbma1.U000s.Where(c => c.userSN == userSN).First().name;
string res = string.Format("{{\"status\":\"true\",\"uipData\":{{\"SltConfigData\":[{0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10},{11},{12}],{13}}},\"crData\":{14},\"maxDatetime\":\"{15}\",\"userName\":\"{16}\",\"userSN\":\"{17}\"}}", provinceData, guaranteeType, assetsType, creditStatusType, industryType, repaymentType, capitalPurposeType, repaymentSourceType, assetsSourceType, useStatusType, morgageType, financierCancelReserveReasonType, financierRefuseReserveReasonType, financingParams, crListStr, DateTime.Now, userName, userSN);
return(res);
}
}
//0：成功。1：密码错误。2：余额不足
public string FP30103(string assetsData, string pwd)
{
string userSN = session["userSN"].ToString();
//string userSN = "U00003";
P300 assetsDataObj = C101.FC10108(assetsData, typeof(P300)) as P300;
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
//密码是否正确
if (C201.FC20146(dbma1, userSN, pwd) == false)
{
return("{\"resStatus\":\"1\"}");
}
//余额是否充足
decimal publishAssetsFee = Convert.ToDecimal(dbma1.A027s.First().publishAssetsCost);
//扣款
if (C201.FC20147(dbma1, userSN, publishAssetsFee, "资产发布", null) == false)
{
return("{\"resStatus\":\"2\"}");
}
//加入资产表 P300
string max33SN = C101.FC10102("P300", 6, "G");
assetsDataObj.assetsSN = max33SN;
assetsDataObj.publisherUserSN = userSN;
assetsDataObj.publishDate = DateTime.Now;
dbma1.P300s.InsertOnSubmit(assetsDataObj);
//加入成长值表 F006
F006 f006 = new F006();
f006.groupUpSN = C101.FC10102("F006", 7, "UD");
f006.userSN = userSN;
f006.businessSN = max33SN;
f006.businessType = "资产发布";
f006.transactionMoneyAmount = publishAssetsFee;
f006.groupUpValue = publishAssetsFee;
f006.acquireDate = DateTime.Now;
dbma1.F006s.InsertOnSubmit(f006);
dbma1.SubmitChanges();
string assetsDataStr = C101.FC10107(dbma1.VP301001s.Where(c => c.assetsSN == max33SN).First() as VP301001);
return(string.Format("{{\"resStatus\":\"{0}\",\"assetsData\":{1}}}", "0", assetsDataStr));
}
}
//申请
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");
}
}
public string FP30201(int pageSize)
{
string userSN = session["userSN"].ToString();
//string userSN = "U00003";
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
string assetsType = C201.FC20108(dbma1);
var dataList = (from c in dbma1.VP402011s
where c.receiverUserSN == userSN
orderby c.reserveDate descending
select c).Take(pageSize).ToList();
string dataListStr = C101.FC10107(dataList);
return(string.Format("{{\"SltConfigData\":{0},\"data\":{1},\"maxDatetime\":\"{2}\"}}", assetsType, dataListStr, DateTime.Now));
}
}
/// <summary>
/// 页面初始化
/// </summary>
public string FP10101(int pageSize)
{
//判断是否登录
if (session["userSN"] == null)
{
return("notLogin");
}
string userSN = session["userSN"].ToString();
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
//判断是否有权限并且是否有逾期账单
var data1 = dbma1.U001s.Where(c => c.userSN == userSN).First();
bool ifBillOverdue = C201.FC20153(dbma1, userSN);
if (data1.creditRightInvestStatus != true || ifBillOverdue == true)
{
return("{\"status\":\"false\"}");
}
//获取uip
string provinceData = C201.FC20121(dbma1).Replace("[", "").Replace("]", "");
string guaranteeType = C201.FC20117(dbma1).Replace("[", "").Replace("]", "");
string repaymentType = C201.FC20114(dbma1).Replace("[", "").Replace("]", "");
string capitalPurposeType = C201.FC20115(dbma1).Replace("[", "").Replace("]", "");
string repaymentSourceType = C201.FC20116(dbma1).Replace("[", "").Replace("]", "");
string investorCancelReserveReasonType = C201.FC20132(dbma1).Replace("[", "").Replace("]", "");
string investorRefuseReserveReasonType = C201.FC20133(dbma1).Replace("[", "").Replace("]", "");
//获取债权信息
var crDataList = dbma1.VP101001s.OrderByDescending(c => c.publishDate).Take(pageSize).ToList();
string crDataListStr = C101.FC10107(crDataList);
string userName = dbma1.U000s.Where(c => c.userSN == userSN).First().name;
string res = string.Format("{{\"status\":\"true\",\"uipData\":{{\"SltConfigData\":[{0},{1},{2},{3},{4},{5},{6}]}},\"crDate\":{7},\"maxDatetime\":\"{8}\",\"userName\":\"{9}\",\"userSN\":\"{10}\"}}", provinceData, guaranteeType, repaymentType, capitalPurposeType, repaymentSourceType, investorCancelReserveReasonType, investorRefuseReserveReasonType, crDataListStr, DateTime.Now, userName, userSN);
return(res);
}
}
public string FP50201(int pageSize)
{
//判断是否登录
if (session["userSN"] == null)
{
return("notLogin");
}
string userSN = session["userSN"].ToString();
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
//判断是否有权限
var data = dbma1.U001s.Where(c => c.userSN == userSN).First();
bool ifBillOverdue = C201.FC20153(dbma1, userSN);
if (data.consultantStatus != true || ifBillOverdue == true)
{
return("{\"status\":\"false\"}");
}
//用户名
string name = dbma1.U000s.Where(c => c.userSN == userSN).First().name;
//select信息
string assetsType = C201.FC20108(dbma1).Replace("[", "").Replace("]", "");
string consultantRefuseReserveReasonType = C201.FC20135(dbma1).Replace("[", "").Replace("]", "");
string consultantAuditNotPassReasonType = C201.FC20136(dbma1).Replace("[", "").Replace("]", "");
//预约中债权
var crDataList = (from c in dbma1.VP502001s
where c.consultantUserSN == userSN
orderby c.sendTime descending
select c).Take(pageSize).ToList();
string crDataListStr = C101.FC10107(crDataList);
return(string.Format("{{\"status\":\"true\",\"name\":\"{0}\",\"SltConfigData\":[{1},{2},{3}],\"crDataList\":{4},\"maxDatetime\":\"{5}\",\"userSN\":\"{6}\"}}", name, assetsType, consultantRefuseReserveReasonType, consultantAuditNotPassReasonType, crDataListStr, DateTime.Now, userSN));
}
}
/// <summary>
/// 初始化
/// </summary>
public string FP30101(int pageSize)
{
//判断是否登录
if (session["userSN"] == null)
{
return("notLogin");
}
string userSN = session["userSN"].ToString();
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
//判断是否有权限
var data = dbma1.U001s.Where(c => c.userSN == userSN).First();
bool ifBillOverdue = C201.FC20153(dbma1, userSN);
if (data.assetsSellingStatus != true || ifBillOverdue == true)
{
return("{\"status\":\"false\"}");
}
string userName = dbma1.U000s.Where(c => c.userSN == userSN).First().name;
string provinceData = C201.FC20121(dbma1).Replace("[", "").Replace("]", "");
string assetsType = C201.FC20108(dbma1).Replace("[", "").Replace("]", "");
string assetsSourceType = C201.FC20109(dbma1).Replace("[", "").Replace("]", "");
string useStatusType = C201.FC20110(dbma1).Replace("[", "").Replace("]", "");
string RejectReason = C201.FC20138(dbma1);
var vp401001List = (from c in dbma1.VP401001s
where c.publisherUserSN == userSN
orderby c.publishDate descending
select c).Take(pageSize).ToList();
string vp401001ListStr = C101.FC10107(vp401001List);
return(string.Format("{{\"status\":\"true\",\"userName\":\"{0}\",\"SltConfigData\":[{1},{2},{3},{4}],\"assetsDataList\":{5},\"maxDatetime\":\"{6}\",\"RejectReason\":{7},\"userSN\":\"{8}\"}}", userName, provinceData, assetsType, assetsSourceType, useStatusType, vp401001ListStr, DateTime.Now, RejectReason, userSN));
}
}
public void FP90110(string billNo, decimal amount, string ifSuc, string ipsBillNo, string bankBillNo, string userSN)
{
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
//获得vip奖励比率
//decimal rewardRate = 1;
decimal rewardRate = C201.FC20152(dbma1, userSN);
//充值记录表 F005
F005 f005 = dbma1.F005s.Where(c => c.rechargeSN == billNo).First();
f005.ifSuccess = ifSuc == "Y" ? true : false;
f005.ipsBillNo = ipsBillNo;
f005.bankBillNo = bankBillNo;
if (ifSuc == "Y")
{
//充值写入余额表 F000
F000 f000 = dbma1.F000s.Where(c => c.userSN == userSN).First();
f000.balance += amount;
//充值写入流水明细表 F003
F003 f003_1 = new F003();
f003_1.revenueExpenditureSN = C101.FC10102("F003", 8, "UA");
f003_1.generetorUserSN = userSN;
f003_1.generateDate = DateTime.Now;
f003_1.type = "账户充值";
f003_1.revenue = amount;
f003_1.balance = f000.balance;
f003_1.referSN = f005.rechargeSN;
dbma1.F003s.InsertOnSubmit(f003_1);
if (rewardRate > 0)
{
//奖励表 F004
F004 f004 = new F004();
f004.rewardSN = C101.FC10102("F004", 7, "UB");
f004.userSN = userSN;
f004.rewardAmount = amount * rewardRate;
f004.rewardDate = DateTime.Now;
f004.referSN = billNo;
f004.rewardType = "充值奖励";
dbma1.F004s.InsertOnSubmit(f004);
//奖励写入余额表 F000
f000.balance += Convert.ToDecimal(f004.rewardAmount);
//奖励写入流水明细表 F003
F003 f003_2 = new F003();
f003_2.revenueExpenditureSN = C101.FC10102("F003", 8, "UA");
f003_2.generetorUserSN = userSN;
f003_2.generateDate = DateTime.Now;
f003_2.type = "充值奖励";
f003_2.revenue = f004.rewardAmount;
f003_2.balance = f000.balance;
f003_2.referSN = f004.rewardSN;
dbma1.F003s.InsertOnSubmit(f003_2);
}
}
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);
}
}
//0：成功。1：密码错误。2：余额不足。 3：资产已被取消。4：资产已被预约
public string FP40201(string assetsSN, string pwd)
{
string userSN = session["userSN"].ToString();
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
//有效性检查（1、已被取消。2、已被预约）
var data1 = dbma1.P300s.Where(c => c.assetsSN == assetsSN && c.cancelDate != null).FirstOrDefault();
var data2 = dbma1.P400s.Where(c => c.assetsSN == assetsSN && c.senderCancelReserveDate == null && c.receiverRefuseReserveDate == null).FirstOrDefault();
if (data1 != null)
{
return("3");
}
if (data2 != null)
{
return("4");
}
//密码是否正确
if (C201.FC20146(dbma1, userSN, pwd) == false)
{
return("1");
}
//余额是否充足
decimal assetsReserveFee = Convert.ToDecimal(dbma1.A026s.First().assetsReserveCost);
//扣款
if (C201.FC20147(dbma1, userSN, assetsReserveFee, "资产预约", null) == false)
{
return("2");
}
//加入资产预约表 P400
string sellerUserSN = dbma1.P300s.Where(c => c.assetsSN == assetsSN).First().publisherUserSN;
string max33SN = C101.FC10102("P400", 7, "H");
P400 p400 = new P400();
p400.reserveSN = max33SN;
p400.senderUserSN = userSN;
p400.receiverUserSN = sellerUserSN;
p400.assetsSN = assetsSN;
p400.reserveDate = DateTime.Now;
dbma1.P400s.InsertOnSubmit(p400);
//加入成长值表 F006
F006 f006 = new F006();
f006.groupUpSN = C101.FC10102("F006", 7, "UD");
f006.userSN = userSN;
f006.businessSN = max33SN;
f006.businessType = "资产预约";
f006.transactionMoneyAmount = assetsReserveFee;
f006.groupUpValue = assetsReserveFee;
f006.acquireDate = DateTime.Now;
dbma1.F006s.InsertOnSubmit(f006);
dbma1.SubmitChanges();
U003 u003 = dbma1.U003s.Where(c => c.userSN == sellerUserSN).First();
//如有邮箱提醒
if (u003.billGenerate_email == true)
{
ReserveSendByEmail(dbma1, sellerUserSN, assetsSN);
}
//如有短信提醒
if (u003.billGenerate_shortMessage == true)
{
ReserveSendBySM(dbma1, sellerUserSN, assetsSN);
}
dbma1.SubmitChanges();
return("0");
}
}
