public string FM020304(string purchaserUserSN)
{
using (DBBS1DataContext dbbs1 = new DBBS1DataContext())
{
var purchaserData = (from c in dbbs1.VP801001s
where c.userSN == purchaserUserSN
select new
{
c.userSN,
c.name,
c.birthday,
c.gender,
c.registeredResidence,
idCard = c.idCard.Substring(0, 6) + "*",
phone = c.phone.Substring(0, 3) + "****" + c.phone.Substring(7, 4),
c.email,
c.maritalStatusType,
c.procreateStatus,
c.currentAddressProvince,
c.currentAddressCity,
c.currentAddressDetails,
c.assetsProvince,
c.minPurchasePrice,
c.maxPurchasePrice,
c.assetsType
}).First();
return(C101.FC10107(purchaserData));
}
}
public string FM060103(string userSN)
{
using (DBBS1DataContext dbbs1 = new DBBS1DataContext())
{
VA028 a028 = dbbs1.VA028s.First();
int needPayDays = Convert.ToInt32(a028.needPayDays);
decimal overdueRateDaily = Convert.ToDecimal(a028.overdueRateDaily);
var dataList = (from c in dbbs1.VF001s
where c.payerUserSN == userSN &&
!dbbs1.VF002s.Where(o => o.billSN == c.billSN).Any()
select new
{
c.billSN,
c.businessSN,
c.billType,
c.MoneyAmount,
c.generateDate,
needPayDate = c.generateDate.AddDays(needPayDays),
lateFee = c.generateDate.AddDays(needPayDays) > DateTime.Now ? 0 : c.MoneyAmount * overdueRateDaily * ((DateTime.Now - c.generateDate.AddDays(needPayDays)).Days - 1)
}).ToList();
return(C101.FC10107(dataList));
}
}
public string FM020603(string userSN)
{
using (DBBS1DataContext dbbs1 = new DBBS1DataContext())
{
var sellerData = (from c in dbbs1.VP801001s
where c.userSN == userSN
select new
{
c.userSN,
c.name,
c.birthday,
c.gender,
c.registeredResidence,
idCard = c.idCard.Substring(0, 6) + "*",
phone = c.phone,
c.email,
c.maritalStatusType,
c.procreateStatus,
c.currentAddressProvince,
c.currentAddressCity,
c.currentAddressDetails
}).First();
return(C101.FC10107(sellerData));
}
}
//合计充值和消费
private string SumRevenueAndExpenditure(DBBS1DataContext dbbs1)
{
decimal revenueTotal = Convert.ToDecimal(dbbs1.VF003s.Sum(c => c.revenue));
decimal expenditure = Convert.ToDecimal(dbbs1.VF003s.Sum(c => c.expenditure));
return(string.Format("\"revenueTotal\":\"{0}\",\"expenditure\":\"{1}\"", revenueTotal, expenditure));
}
public string FM020207(string userSN)
{
using (DBBS1DataContext dbbs1 = new DBBS1DataContext())
{
return(dbbs1.VP801021s.Where(c => c.userSN == userSN).First().creditRightInvestNote);
}
}
public string FM020406(string userSN)
{
using (DBBS1DataContext dbbs1 = new DBBS1DataContext())
{
return(dbbs1.VP801021s.Where(c => c.userSN == userSN).First().consultantNote);
}
}
public string FM020308(string userSN)
{
using (DBBS1DataContext dbbs1 = new DBBS1DataContext())
{
return(dbbs1.VP801021s.Where(c => c.userSN == userSN).First().assetsPurchaseNote);
}
}
public string FM0603INIT(int pageSize)
{
using (DBBS1DataContext dbbs1 = new DBBS1DataContext())
{
var dataList = dbbs1.VF007s.Take(pageSize).ToList();
return(C101.FC10107(dataList));
}
}
public string FM020110(string userSN)
{
using (DBBS1DataContext dbbs1 = new DBBS1DataContext())
{
var data = dbbs1.VP801021s.Where(c => c.userSN == userSN).First();
return(data.creditRightFinancingNote == null ? "" : data.creditRightFinancingNote.Trim());
}
}
public string FM020109(string userSN)
{
using (DBBS1DataContext dbbs1 = new DBBS1DataContext())
{
var dataList = dbbs1.VP203091s.Where(c => c.financierUserSN == userSN).ToList();
return(C101.FC10107(dataList));
}
}
public string FM020202(string userSN)
{
using (DBBS1DataContext dbbs1 = new DBBS1DataContext())
{
var dataList = dbbs1.VP102031s.Where(c => c.investorUserSN == userSN).ToList();
return(C101.FC10107(dataList));
}
}
public string FM020405(string userSN)
{
using (DBBS1DataContext dbbs1 = new DBBS1DataContext())
{
var dataList = dbbs1.VP504051s.Where(c => c.consultantUserSN == userSN).ToList();
return(C101.FC10107(dataList));
}
}
public string FM020501(int pageSize)
{
using (DBBS1DataContext dbbs1 = new DBBS1DataContext())
{
var dataList = dbbs1.VP801031s.Take(pageSize).ToList();
return(C101.FC10107(dataList));
}
}
public string FM020604(string userSN)
{
using (DBBS1DataContext dbbs1 = new DBBS1DataContext())
{
var vp401001List = (from c in dbbs1.VP401001s
where c.publisherUserSN == userSN
select c).ToList();
return(C101.FC10107(vp401001List));
}
}
public string FM020307(string userSN)
{
using (DBBS1DataContext dbbs1 = new DBBS1DataContext())
{
var dataList = (from c in dbbs1.VP404001s
where c.purchaserUserSN == userSN
select c).ToList();
return(C101.FC10107(dataList));
}
}
public string FM020201(string userSN)
{
using (DBBS1DataContext dbbs1 = new DBBS1DataContext())
{
var data = (from c in dbbs1.VP801001s
where c.userSN == userSN
select c).First();
return(C101.FC10107(data));
}
}
/// <summary>
/// 获取资产类型 A008
/// </summary>
public static string FC20108(DBBS1DataContext dbbs1)
{
var linqData = (from c in dbbs1.A008s
select new
{
ID = c.assetsTypeSN,
Name = c.value.Trim()
}).ToList();
return(C101.FC10107(linqData));
}
public string FM020503(string filterStr, int pageFrom, int pageSize)
{
using (DBBS1DataContext dbbs1 = new DBBS1DataContext())
{
var dataList = (from c in dbbs1.VP801031s
where c.work_num.Contains(filterStr)
select c).Skip(pageFrom).Take(pageSize).ToList();
return(C101.FC10107(dataList));
}
}
//获取申请状态列表
private string GetApplyStatusList(DBBS1DataContext dbbs1, IEnumerable <B400> dataList)
{
//服务状态
List <short> applyStatusList = new List <short>();
foreach (var b300 in dataList)
{
VP801021 vp801021 = dbbs1.VP801021s.Where(c => c.userSN == b300.userSN).First();
applyStatusList.Add(vp801021.consultantApplyStatus);
}
return(C101.FC10107(applyStatusList));
}
public string FM020401(string userSN)
{
using (DBBS1DataContext dbbs1 = new DBBS1DataContext())
{
//基本信息
var consultantBasicData = (from c in dbbs1.VP801001s
where c.userSN == userSN
select new
{
c.userSN,
c.name,
c.birthday,
c.gender,
c.registeredResidence,
idCard = c.idCard.Substring(0, 6),
c.phone,
c.email,
c.maritalStatusType,
c.procreateStatus,
c.currentAddressProvince,
c.currentAddressCity,
c.currentAddressDetails,
c.graduateSchool,
c.degreeType,
c.degreeCard,
c.workEnterprise,
c.industryType,
c.enterpriseType,
c.hiredate,
c.workTel,
c.post,
c.enterpriseSwitchboard,
c.enterpriseWebsite,
c.colleageName,
c.colleagePhone,
colleageIdCard = c.colleageIdCard.Substring(0, 6),
c.serviceProvince,
c.serviceCity,
c.investigate,
c.assetsEvaluate,
c.badLoanCollect,
c.creditRightGuarantee,
c.consultantDetails
}).First();
return(C101.FC10107(consultantBasicData));
}
}
public string FM020101(string userSN)
{
using (DBBS1DataContext dbbs1 = new DBBS1DataContext())
{
//案例情况
var caseStatus = dbbs1.P102s.Where(c => c.financierUserSN == userSN);
int caseAmount = caseStatus.Count();
decimal?caseMoneyAmount = caseAmount == 0 ? 0 : caseStatus.Sum(c => c.investMoneyAmount);
//债务情况
var debtStatus = dbbs1.P102s.Where(c => c.financierUserSN == userSN && c.closeCaseDate == null);
int debtAmount = debtStatus.Count();
decimal?debtMoneyAmount = debtAmount == 0 ? 0 : debtStatus.Sum(c => c.investMoneyAmount);
//当前逾期情况
var currentOverdueStatus = from c in dbbs1.P102s
where c.financierUserSN == userSN &&
c.closeCaseDate == null &&
c.investDate.Date < DateTime.Now.Date
select c;
int currentOverdueAmount = currentOverdueStatus.Count();
decimal?currentOverdueMoneyAmount = currentOverdueAmount == 0 ? 0 : currentOverdueStatus.Sum(c => c.investMoneyAmount);
//历史逾期数量
var historyOverdueStatus = from c in dbbs1.P102s
from p in dbbs1.P103s
where c.investSN == p.investSN &&
c.financierUserSN == userSN &&
c.investDate.Date < p.repayDate.Date
select c;
int historyOverdueAmount = historyOverdueStatus.Count();
//注册时间
DateTime regDatetime = dbbs1.VU000s.Where(c => c.userSN == userSN).First().registerDate;
string regDatetimeStr = C101.FC10107(regDatetime);
//基本信息
var financierBasicData = (from c in dbbs1.VP801001s
where c.userSN == userSN
select c).First();
string financierBasicDataStr = C101.FC10107(financierBasicData);
string res = string.Format("{{\"financierBasicData\":{0},\"caseAmount\":{1},\"caseMoneyAmount\":{2},\"debtAmount\":{3},\"debtMoneyAmount\":{4},\"currentOverdueAmount\":{5},\"currentOverdueMoneyAmount\":{6},\"historyOverdueAmount\":{7},\"regDatetime\":{8}}}", financierBasicDataStr, caseAmount, caseMoneyAmount, debtAmount, debtMoneyAmount, currentOverdueAmount, currentOverdueMoneyAmount, historyOverdueAmount, regDatetimeStr);
return(res);
}
}
public string FM020411(int pageFrom, int pageSize, string sortStr)
{
using (DBBC1DataContext dbbc1 = new DBBC1DataContext())
{
var dataList = Sort(dbbc1, sortStr).Skip(pageFrom).Take(pageSize).ToList();
using (DBBS1DataContext dbbs1 = new DBBS1DataContext())
{
//服务状态
string serverStatusListStr = GetServerStatusList(dataList);
//申请状态
string applyStatusListStr = GetApplyStatusList(dbbs1, dataList);
return(string.Format("{{\"dataList\":{0},\"serverStatusList\":{1},\"applyStatusList\":{2}}}", C101.FC10107(dataList), serverStatusListStr, applyStatusListStr));
}
}
}
public string FM060401(string sortStr, int pageFrom, int pageSize)
{
using (DBBS1DataContext dbbs1 = new DBBS1DataContext())
{
var linqDataList = (from c in Sort(dbbs1, sortStr)
select new
{
userSN = c.generetorUserSN,
c.revenueExpenditureSN,
c.generateDate,
c.type,
c.revenue,
c.expenditure,
}
).Skip(pageFrom).Take(pageSize).ToList();
return(string.Format("{{\"data\":{0},{1}}}", C101.FC10107(linqDataList), SumRevenueAndExpenditure(dbbs1)));
}
}
public string FM0604INIT(int pageSize)
{
using (DBBS1DataContext dbbs1 = new DBBS1DataContext())
{
var linqDataList = (from c in dbbs1.VF003s
select new
{
userSN = c.generetorUserSN,
c.revenueExpenditureSN,
c.generateDate,
c.type,
c.revenue,
c.expenditure,
}
).Take(pageSize).ToList();
var s = string.Format("{{\"data\":{0},{1}}}", C101.FC10107(linqDataList), SumRevenueAndExpenditure(dbbs1));
return(s);
}
}
public string FM0204INIT(int pageSize)
{
using (DBBC1DataContext dbbc1 = new DBBC1DataContext())
{
//数据
var dataList = dbbc1.B400s.Take(pageSize).ToList();
using (DBBS1DataContext dbbs1 = new DBBS1DataContext())
{
//服务状态
string serverStatusListStr = GetServerStatusList(dataList);
//申请状态
string applyStatusListStr = GetApplyStatusList(dbbs1, dataList);
return(string.Format("{{\"dataList\":{0},\"serverStatusList\":{1},\"applyStatusList\":{2}}}", C101.FC10107(dataList), serverStatusListStr, applyStatusListStr));
}
}
}
//删选
private IEnumerable <VF003> Sort(DBBS1DataContext dbbs1, string sortStr)
{
string sqlWhereStr = "";
string[] sortStrSplit = sortStr.Split(',');
for (int i = 1; i < (sortStrSplit.Length - 1); i++)
{
string[] sortStrSplitSplit = sortStrSplit[i].Split('#');
if (sortStrSplitSplit[0] == "1")
{
if (sqlWhereStr == "")
{
sqlWhereStr = string.Format("where CONVERT(varchar(100), generateDate, 111) like N'%{0}%'", sortStrSplitSplit[1]);
}
else
{
sqlWhereStr = string.Format(" and CONVERT(varchar(100), generateDate, 111) like N'%{0}%'", sortStrSplitSplit[1]);
}
continue;
}
if (sortStrSplitSplit[0] == "2")
{
if (sqlWhereStr == "")
{
sqlWhereStr = string.Format("where type like N'%{0}%'", sortStrSplitSplit[1]);
}
else
{
sqlWhereStr = string.Format(" and type like N'%{0}%'", sortStrSplitSplit[1]);
}
continue;
}
}
string sqlStr = string.Format("select * from VF003 {0}", sqlWhereStr);
IEnumerable <VF003> crDataList = dbbs1.ExecuteQuery <VF003>(sqlStr);
return(crDataList);
}
public string FM0203INIT(int pageSize)
{
using (DBBC1DataContext dbbc1 = new DBBC1DataContext())
{
//数据
var dataList = dbbc1.B300s.Take(pageSize).ToList();
using (DBBS1DataContext dbbs1 = new DBBS1DataContext())
{
//uip
string pawnStr = C102.FC20108(dbbs1);
//服务状态
string serverStatusListStr = GetServerStatusList(dataList);
return(string.Format("{{\"dataList\":{0},\"serverStatusList\":{1},\"pawn\":{2}}}", C101.FC10107(dataList), serverStatusListStr, pawnStr));
}
}
}
