/// <summary>
/// 扣款
/// </summary>
public static bool FC20147(DBMA1DataContext dbma1, string userSN, decimal amount, string type, string referSN)
{
//从余额中扣除服务费 F000
F000 f000 = dbma1.F000s.Where(c => c.userSN == userSN).First();
if (f000.balance < amount)
{
return(false);
}
f000.balance -= amount;
//加入收支明细表中 F003
string F003max33SN = C101.FC10102("F003", 8, "UA");
F003 f003 = new F003();
f003.revenueExpenditureSN = F003max33SN;
f003.generetorUserSN = userSN;
f003.generateDate = DateTime.Now;
f003.type = type;
f003.expenditure = amount;
f003.balance = f000.balance;
f003.referSN = referSN;
dbma1.F003s.InsertOnSubmit(f003);
return(true);
}
//插入余额表 F000
private void InsertIntoF000(DBMA1DataContext dbma1, string max33SN)
{
F000 f000 = new F000();
f000.userSN = max33SN;
f000.balance = 0;
f000.lastOperate = DateTime.Now;
dbma1.F000s.InsertOnSubmit(f000);
}
public string FP90204()
{
string userSN = session["userSN"].ToString();
//string userSN = "U00001";
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
//账户余额
F000 f000 = dbma1.F000s.Where(c => c.userSN == userSN).First();
return(f000.balance.ToString());
}
}
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 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)));
}
}
public string FP20111()
{
string financierUserSN = session["userSN"].ToString();
//string financierUserSN = "U00001";
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
//发布费用
A024 a024 = dbma1.A024s.First();
decimal?publishFee = a024.financePublishCost;
//账户余额
F000 f000 = dbma1.F000s.Where(c => c.userSN == financierUserSN).First();
decimal balance = f000.balance;
return(string.Format("{{\"publishFee\":\"{0}\",\"balance\":\"{1}\"}}", publishFee, balance));
}
}
/// <summary>
/// 获取推荐投资方列表
/// </summary>
public string FP20107(string sortStr)
{
string userSN = session["userSN"].ToString();
//string userSN = "U00001";
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" ? " minInvestMoneyAmount" : " investCaseAmount";
orderStr += sortStrSplitSplit[1] == "A" ? "" : " desc";
}
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
List <RecommandInvestModel> recommandInvestDataList = null;
if (orderStr == string.Empty)
{
recommandInvestDataList = dbma1.ExecuteQuery <RecommandInvestModel>("select * from VP106011").ToList();
}
else
{
string sqlStr = string.Format(@"select * from VP106011 order by {0}", orderStr);
recommandInvestDataList = dbma1.ExecuteQuery <RecommandInvestModel>(sqlStr).ToList();
}
string recommandInvestDataListStr = C101.FC10107(recommandInvestDataList);
//账户余额
F000 f000 = dbma1.F000s.Where(c => c.userSN == userSN).First();
decimal balance = f000.balance;
return(string.Format("{{\"recommandInvestDataList\":{0},\"balance\":\"{1}\"}}", recommandInvestDataListStr, balance));
}
}
public void FP70201()
{
string userSN = session["userSN"].ToString();
//string userSN = "U00004";
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
decimal rewardAmount = Convert.ToInt32(dbma1.A031s.First().regPresentV);
//更新账户表 F000
F000 f000 = dbma1.F000s.Where(c => c.userSN == userSN).First();
f000.balance += rewardAmount;
f000.lastOperate = DateTime.Now;
//添加奖励表 F004
string F004Max33SN = C101.FC10102("F004", 7, "UB");
F004 f004 = new F004();
f004.rewardSN = F004Max33SN;
f004.userSN = userSN;
f004.rewardAmount = rewardAmount;
f004.rewardDate = DateTime.Now;
f004.rewardType = "注册赠送";
dbma1.F004s.InsertOnSubmit(f004);
//添加收支明细表 F003
string F003Max33SN = C101.FC10102("F003", 8, "UA");
F003 f003 = new F003();
f003.revenueExpenditureSN = F003Max33SN;
f003.generetorUserSN = userSN;
f003.generateDate = DateTime.Now;
f003.type = "注册赠送";
f003.revenue = rewardAmount;
f003.balance = f000.balance;
f003.referSN = F004Max33SN;
dbma1.F003s.InsertOnSubmit(f003);
dbma1.SubmitChanges();
}
}
public static bool FC20154(DBMA1DataContext dbma1, string userSN, decimal amount, string type, string referSN)
{
//从余额中扣除服务费 F000
F000 f000 = dbma1.F000s.Where(c => c.userSN == userSN).First();
if (f000.balance < amount)
{
return(false);
}
f000.balance -= amount;
//加入收支明细表中 F003
string F003max33SN = C101.FC10102("F003", 8, "UA");
F003 f003 = new F003();
f003.revenueExpenditureSN = F003max33SN;
f003.generetorUserSN = userSN;
f003.generateDate = DateTime.Now;
f003.type = type;
f003.expenditure = amount;
f003.balance = f000.balance;
f003.referSN = referSN;
dbma1.F003s.InsertOnSubmit(f003);
//加入成长值表 F006
F006 f006 = new F006();
f006.groupUpSN = C101.FC10102("F006", 7, "UD");
f006.userSN = userSN;
f006.businessSN = referSN;
f006.businessType = type;
f006.transactionMoneyAmount = amount;
f006.groupUpValue = amount;
f006.acquireDate = DateTime.Now;
dbma1.F006s.InsertOnSubmit(f006);
return(true);
}
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>
/// 投资方债权预约
/// </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");
}
}
//“0”：成功； “1”：交易密码错误; "2":姓名错误
public string FM060301(string phone, string name, decimal changeAmount, string changeReasonType, string pwd, string note)
{
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
//查看密码是否正确
int operatorSN = Convert.ToInt32(session["internalUserId"].ToString());
var data = dbma1.internal_users.Where(c => c.internal_user_id == operatorSN && c.pwd == pwd).FirstOrDefault();
if (data == null)
{
return("{\"sucStatus\":\"1\"}");
}
var u000 = dbma1.U000s.Where(c => c.phone == phone).First();
string userSN = u000.userSN;
//姓名是否正确
if (u000.name.Trim() != name)
{
return("{\"sucStatus\":\"2\"}");
}
//更新余额表 F000
F000 f000 = dbma1.F000s.Where(c => c.userSN == userSN).First();
f000.balance += changeAmount;
//添加调账表 F007
F007 f007 = new F007();
f007.changeAccountSN = C101.FC10102("F007", 7, "UF");
f007.userSN = userSN;
f007.phone = phone;
f007.name = name;
f007.changeAmount = changeAmount;
f007.changeReasonType = changeReasonType;
f007.note = note;
f007.changeDate = DateTime.Now;
dbma1.F007s.InsertOnSubmit(f007);
//添加收支明细表 F003
F003 f003 = new F003();
f003.revenueExpenditureSN = C101.FC10102("F003", 8, "UA");
f003.generetorUserSN = userSN;
f003.generateDate = DateTime.Now;
f003.type = changeReasonType;
f003.revenue = changeAmount;
f003.expenditure = 0;
f003.balance = f000.balance;
f003.referSN = f007.changeAccountSN;
dbma1.F003s.InsertOnSubmit(f003);
//添加后台修改记录 B00
B000 b000 = new B000();
b000.bgOperateSN = C101.FC10102("B000", 5, "B");
b000.tableName = "B005";
b000.pkSN = f007.changeAccountSN;
b000.actionTypeSN = "B0G";
b000.operatorSN = operatorSN;
b000.operateDate = DateTime.Now;
dbma1.B000s.InsertOnSubmit(b000);
dbma1.SubmitChanges();
dbma1.SubmitChanges();
return(string.Format("{{\"sucStatus\":\"0\",\"SN\":\"{0}\",\"date\":{1}}}", f007.changeAccountSN, C101.FC10107(DateTime.Now)));
}
}
/// <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));
}
}
public string FP90202(string billSN, string pwd)
{
string userSN = session["userSN"].ToString();
//string userSN = "U00001";
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
//有效性检查（1、已经付款）
var data1 = dbma1.F002s.Where(c => c.billSN == billSN).FirstOrDefault();
if (data1 != null)
{
return("true");
}
//验证交易密码是否正确
string transPwd = dbma1.U003s.Where(c => c.userSN == userSN).First().transactPwd;
if (C101.FC10104(pwd, transPwd) == false)
{
return("false");
}
//从余额中扣除服务费 F000
A028 a028 = dbma1.A028s.First();
int needPayDays = Convert.ToInt32(a028.needPayDays);
decimal overdueRateDaily = Convert.ToDecimal(a028.overdueRateDaily);
F001 f001 = dbma1.F001s.Where(c => c.billSN == billSN).First();
decimal moneyAmount = Convert.ToDecimal(f001.MoneyAmount);
decimal lateFee = Convert.ToDecimal((DateTime.Now - f001.generateDate).Days > needPayDays ? f001.MoneyAmount * overdueRateDaily * ((DateTime.Now - f001.generateDate).Days - needPayDays) : 0);
decimal fee = moneyAmount + lateFee;
F000 f000 = dbma1.F000s.Where(c => c.userSN == userSN).First();
if (f000.balance < fee)
{
return("false");
}
f000.balance -= fee;
//加入收支明细表中 F003
string F003max33SN = C101.FC10102("F003", 8, "UA");
F003 f003 = new F003();
f003.revenueExpenditureSN = F003max33SN;
f003.generetorUserSN = userSN;
f003.generateDate = DateTime.Now;
f003.type = "资产出售账单";
f003.expenditure = fee;
f003.balance = f000.balance;
dbma1.F003s.InsertOnSubmit(f003);
//加入付款表 F001
string F002max33SN = C101.FC10102("F002", 6, "QA");
F002 f002 = new F002();
f002.paySN = F002max33SN;
f002.billSN = billSN;
f002.payMoneyAmount = fee;
f002.payDate = DateTime.Now;
dbma1.F002s.InsertOnSubmit(f002);
//加入成长值表 F006
string F006Max33SN = C101.FC10102("F006", 7, "UD");
F006 f006 = new F006();
f006.groupUpSN = F006Max33SN;
f006.userSN = userSN;
f006.businessSN = F002max33SN;
f006.businessType = "账单付款";
f006.transactionMoneyAmount = fee;
f006.groupUpValue = fee;
f006.acquireDate = DateTime.Now;
dbma1.F006s.InsertOnSubmit(f006);
dbma1.SubmitChanges();
return("true");
}
}
/// <summary>
/// 融资方发出预约
/// </summary>
public string FP20109(string pwd, string investorUserSN, string crSN)
{
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
string financierUserSN = session["userSN"].ToString();
//string financierUserSN = "U00001";
//检查有效性（1、债权没有被取消。2、债权没有被预约）
var data1 = dbma1.P200s.Where(c => c.creditRightSN == crSN && c.cancelDate != null).FirstOrDefault();
var data2 = dbma1.P203s.Where(c => c.creditRightSN == crSN && c.senderCancelReserveDate == null && c.receiverRefuseReserveDate == null).FirstOrDefault();
var data3 = dbma1.P100s.Where(c => c.creditRightSN == crSN && c.senderCancelReserveDate == null && c.receiverRefuseReserveDate == null).FirstOrDefault();
if (data1 != null || data2 != null || data3 != null)
{
return("false");
}
//验证交易密码是否正确
string transPwd = dbma1.U003s.Where(c => c.userSN == financierUserSN).First().transactPwd;
if (C101.FC10104(pwd, transPwd) == false)
{
return("false");
}
//从余额中扣除服务费 F000
A024 a024 = dbma1.A024s.First();
decimal investorRecommendCost = Convert.ToDecimal(a024.investorRecommendCost);
F000 f000 = dbma1.F000s.Where(c => c.userSN == financierUserSN).First();
if (f000.balance < investorRecommendCost)
{
return("false");
}
f000.balance -= investorRecommendCost;
//加入收支明细表中 F003
string F003max33SN = C101.FC10102("F003", 8, "UA");
F003 f003 = new F003();
f003.revenueExpenditureSN = F003max33SN;
f003.generetorUserSN = financierUserSN;
f003.generateDate = DateTime.Now;
f003.type = "投资方推荐";
f003.expenditure = investorRecommendCost;
f003.balance = f000.balance;
dbma1.F003s.InsertOnSubmit(f003);
//债权预约表添加记录 P203
string max33SN = C101.FC10102("P203", 7, "F");
P203 p203 = new P203();
p203.reserveSN = max33SN;
p203.senderUserSN = financierUserSN;
p203.receiverUserSN = investorUserSN;
p203.creditRightSN = crSN;
p203.sendDate = DateTime.Now;
dbma1.P203s.InsertOnSubmit(p203);
//加入成长值表 F006
string F006Max33SN = C101.FC10102("F006", 7, "UD");
F006 f006 = new F006();
f006.groupUpSN = F006Max33SN;
f006.userSN = financierUserSN;
f006.businessSN = max33SN;
f006.businessType = "投资方推荐";
f006.transactionMoneyAmount = investorRecommendCost;
f006.groupUpValue = investorRecommendCost;
f006.acquireDate = DateTime.Now;
dbma1.F006s.InsertOnSubmit(f006);
dbma1.SubmitChanges();
U003 u003 = dbma1.U003s.Where(c => c.userSN == investorUserSN).First();
//如有邮箱提醒
if (u003.billGenerate_email == true)
{
SendByEmail(dbma1, investorUserSN, crSN);
}
//如有短信提醒
if (u003.billGenerate_shortMessage == true)
{
SendBySM(dbma1, investorUserSN, crSN);
}
dbma1.SubmitChanges();
return("true");
}
}
/// <summary>
/// 发布债权
/// </summary>
public string FP20103(string financingData, string pawnData, string enterpriseData, string pwd)
{
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
string userSN = session["userSN"].ToString();
//验证交易密码是否正确
string transPwd = dbma1.U003s.Where(c => c.userSN == userSN).First().transactPwd;
if (C101.FC10104(pwd, transPwd) == false)
{
return("false");
}
//从余额中扣除服务费 F000
A024 a024 = dbma1.A024s.First();
decimal publishFee = Convert.ToDecimal(a024.financePublishCost);
F000 f000 = dbma1.F000s.Where(c => c.userSN == userSN).First();
if (f000.balance < publishFee)
{
return("false");
}
f000.balance -= publishFee;
//加入收支明细表中 F003
string max33SN = C101.FC10102("F003", 8, "UA");
F003 f003 = new F003();
f003.revenueExpenditureSN = max33SN;
f003.generetorUserSN = userSN;
f003.generateDate = DateTime.Now;
f003.type = "债权发布";
f003.expenditure = publishFee;
f003.balance = f000.balance;
dbma1.F003s.InsertOnSubmit(f003);
//债权
P200 p200 = Comm.C101.FC10108(financingData, typeof(P200)) as P200;
p200.creditRightSN = C101.FC10102("P200", 6, "E");
p200.publisherUserSN = userSN;
//p200.publisherUserSN = "U00001";
p200.publishDate = DateTime.Now;
dbma1.P200s.InsertOnSubmit(p200);
//抵押物
if (pawnData != "null")
{
P201 p201 = Comm.C101.FC10108(pawnData, typeof(P201)) as P201;
p201.assetsSN = C101.FC10102("P201", 6, "FA");
p201.creditRightSN = p200.creditRightSN;
dbma1.P201s.InsertOnSubmit(p201);
}
//企业
if (enterpriseData != "null")
{
P202 p202 = Comm.C101.FC10108(enterpriseData, typeof(P202)) as P202;
p202.enterpriseSN = C101.FC10102("P202", 6, "FB");
p202.creditRightSN = p200.creditRightSN;
dbma1.P202s.InsertOnSubmit(p202);
}
//加入成长值表 F006
string F006Max33SN = C101.FC10102("F006", 7, "UD");
F006 f006 = new F006();
f006.groupUpSN = F006Max33SN;
f006.userSN = userSN;
f006.businessSN = p200.creditRightSN;
f006.businessType = "债权发布";
f006.transactionMoneyAmount = publishFee;
f006.groupUpValue = publishFee;
f006.acquireDate = DateTime.Now;
dbma1.F006s.InsertOnSubmit(f006);
dbma1.SubmitChanges();
var creditRight = dbma1.VP201001s.Where(c => c.creditRightSN == p200.creditRightSN).First();
return(C101.FC10107(creditRight));
}
}
