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