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"); } }