/// <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"); } }