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(); } }