public void FP50310(string serverSN)
{
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
P500 p500 = dbma1.P500s.Where(c => c.serverSN == serverSN).First();
p500.consultantDeleteCreditRightDate = DateTime.Now;
dbma1.SubmitChanges();
}
}
public void FP50303(string serverSN)
{
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
//有效性检查(1、未审核。2、未取消顾问预约。3、未取消债权预约)
var data1 = dbma1.P500s.Where(c => c.serverSN == serverSN && c.auditStatus != null).FirstOrDefault();
var consultantReserveSN = dbma1.P500s.Where(c => c.serverSN == serverSN).First().reserveSN;
var data2 = dbma1.P101s.Where(c => c.reserveSN == consultantReserveSN && c.senderCancelReserveDate != null).FirstOrDefault();
var crReserveSN = dbma1.P101s.Where(c => c.reserveSN == consultantReserveSN).First().creditRightReserveSN;
var data3 = dbma1.P203s.Where(c => c.reserveSN == crReserveSN && (c.senderCancelReserveDate != null || c.receiverRefuseReserveDate != null)).FirstOrDefault();
var data4 = dbma1.P100s.Where(c => c.reserveSN == crReserveSN && (c.senderCancelReserveDate != null || c.receiverRefuseReserveDate != null)).FirstOrDefault();
if (data1 != null || data2 != null || data3 != null || data4 != null)
{
return;
}
P500 p500 = dbma1.P500s.Where(c => c.serverSN == serverSN).First();
p500.auditStatus = true;
p500.serverDate = DateTime.Now;
dbma1.SubmitChanges();
}
}
public void FP50202(string reserveSN)
{
string consultantUserSN = session["userSN"].ToString();
//string consultantUserSN = "U00003";
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
//有效性检查（1、未被接受。2、顾问预约未被取消或者拒绝。3、债权预约未被取消或者拒绝。）
var data1 = dbma1.P500s.Where(c => c.reserveSN == reserveSN).FirstOrDefault();
var data2 = dbma1.P101s.Where(c => c.reserveSN == reserveSN && (c.senderCancelReserveDate != null || c.receiverRefuseReserveDate != null)).FirstOrDefault();
var crReserveSN = dbma1.P101s.Where(c => c.reserveSN == reserveSN).First().creditRightReserveSN;
var data3 = dbma1.P203s.Where(c => c.reserveSN == crReserveSN && (c.senderCancelReserveDate != null || c.receiverRefuseReserveDate != null)).FirstOrDefault();
var data4 = dbma1.P100s.Where(c => c.reserveSN == crReserveSN && (c.senderCancelReserveDate != null || c.receiverRefuseReserveDate != null)).FirstOrDefault();
if (data1 != null || data2 != null || data3 != null || data4 != null)
{
return;
}
var linqData = dbma1.P101s.Where(c => c.reserveSN == reserveSN).First();
string investorUserSN = linqData.senderUserSN;
string crSN = linqData.creditRightSN;
string max33SN = C101.FC10102("P500", 6, "K");
P500 p500 = new P500();
p500.serverSN = max33SN;
p500.reserveSN = reserveSN;
p500.consultantUserSN = consultantUserSN;
p500.investorUserSN = investorUserSN;
p500.creditRightSN = crSN;
p500.acceptReserveDate = DateTime.Now;
dbma1.P500s.InsertOnSubmit(p500);
dbma1.SubmitChanges();
}
}
