public void FP10209(string crSN)
{
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
//有效性检查（1、未审核）
var data1 = dbma1.P500s.Where(c => c.creditRightSN == crSN && c.auditStatus != null).FirstOrDefault();
if (data1 != null)
{
return;
}
P101 p101 = (from c in dbma1.P101s
where c.creditRightSN == crSN &&
c.senderCancelReserveDate == null
select c).FirstOrDefault();
if (p101 == null)
{
return;
}
p101.senderCancelReserveDate = DateTime.Now;
dbma1.SubmitChanges();
}
}
/// <summary>
/// 确认预约财务顾问
/// </summary>
public void FP10301(string consultantUserSN, string crSN, decimal quotePricePercent)
{
string investorUserSN = session["userSN"].ToString();
//string investorUserSN = "U00002";
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
//检查有效性（1、没有被投资。）
var data1 = dbma1.P102s.Where(c => c.creditRightSN == crSN).FirstOrDefault();
if (data1 != null)
{
return;
}
//获取reserveSN
string crReserveSN = string.Empty;
var linqData1 = (from c in dbma1.P203s
where c.creditRightSN == crSN &&
c.senderCancelReserveDate == null &&
c.receiverRefuseReserveDate == null
select c).FirstOrDefault();
if (linqData1 == null)
{
var linqData2 = (from c in dbma1.P100s
where c.creditRightSN == crSN &&
c.senderCancelReserveDate == null &&
c.receiverRefuseReserveDate == null
select c).FirstOrDefault();
if (linqData2 == null)
{
return;
}
crReserveSN = linqData2.reserveSN;
}
else
{
crReserveSN = linqData1.reserveSN;
}
string max33SN = C101.FC10102("P101", 7, "B");
P101 p101 = new P101();
p101.reserveSN = max33SN;
p101.creditRightReserveSN = crReserveSN;
p101.senderUserSN = investorUserSN;
p101.receiverUserSN = consultantUserSN;
p101.creditRightSN = crSN;
p101.costPercent = quotePricePercent;
p101.sendTime = DateTime.Now;
dbma1.P101s.InsertOnSubmit(p101);
dbma1.SubmitChanges();
U003 u003 = dbma1.U003s.Where(c => c.userSN == consultantUserSN).First();
//如有邮箱提醒
if (u003.billGenerate_email == true)
{
SendByEmail(dbma1, consultantUserSN, investorUserSN);
}
//如有短信提醒
if (u003.billGenerate_shortMessage == true)
{
SendBySM(dbma1, consultantUserSN, investorUserSN);
}
dbma1.SubmitChanges();
}
}
