/// <summary>
/// 删除拒绝预约 （融资方取消）
/// </summary>
public void FP10217(string crSN)
{
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
P203 p203 = (from c in dbma1.P203s
where c.creditRightSN == crSN &&
c.senderCancelReserveDate != null &&
c.receiverDeleteReserveDate == null
select c).FirstOrDefault();
if (p203 == null)
{
return;
}
p203.receiverDeleteReserveDate = DateTime.Now;
//P101 p101 = (from c in dbma1.P101s
// where c.creditRightReserveSN == p203.reserveSN
// && c.senderCancelReserveDate == null
// select c).FirstOrDefault();
//if (p101 != null)
//{
// p101.senderCancelReserveDate = DateTime.Now;
//}
dbma1.SubmitChanges();
}
}
/// <summary>
/// 拒绝预约
/// </summary>
public void FP10216(string crSN, string refuseReasonTypeSN)
{
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
//检查有效性（1、没有被投资。）
var data1 = dbma1.P102s.Where(c => c.creditRightSN == crSN).FirstOrDefault();
if (data1 != null)
{
return;
}
P203 p203 = (from c in dbma1.P203s
where c.creditRightSN == crSN &&
c.senderCancelReserveDate == null &&
c.receiverRefuseReserveDate == null
select c).FirstOrDefault();
if (p203 == null)
{
return;
}
p203.receiverRefuseReserveDate = DateTime.Now;
p203.receiverRefuseReserveReasonTypeSN = refuseReasonTypeSN;
//P101 p101 = (from c in dbma1.P101s
// where c.creditRightReserveSN == p203.reserveSN
// && c.senderCancelReserveDate == null
// select c).FirstOrDefault();
//if (p101 != null)
//{
// p101.senderCancelReserveDate = DateTime.Now;
//}
dbma1.SubmitChanges();
}
}
/// <summary>
/// 删除预约（投资方拒绝）
/// </summary>
public void FP20210(string crSN)
{
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
P203 p203 = (from c in dbma1.P203s
where c.creditRightSN == crSN &&
c.receiverRefuseReserveDate != null &&
c.senderDeleteReserveDate == null
select c).FirstOrDefault();
if (p203 == null)
{
return;
}
p203.senderDeleteReserveDate = DateTime.Now;
dbma1.SubmitChanges();
}
}
/// <summary>
/// 融资取消预约
/// </summary>
public void FP20208(string crSN, string cancelReasonTypeSN)
{
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
//检查有效性（1、没有被投资。2、没有被取消）
var data1 = dbma1.P102s.Where(c => c.creditRightSN == crSN).FirstOrDefault();
if (data1 != null)
{
return;
}
P203 p203 = (from c in dbma1.P203s
where c.creditRightSN == crSN &&
c.senderCancelReserveDate == null &&
c.receiverRefuseReserveDate == null
select c).First();
p203.senderCancelReserveDate = DateTime.Now;
p203.senderCancelReserveReasonTypeSN = cancelReasonTypeSN;
dbma1.SubmitChanges();
}
}
/// <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");
}
}
