public void FP40205(string reserveSN, decimal purcharsePrice) { string userSN = session["userSN"].ToString(); using (DBMA1DataContext dbma1 = new DBMA1DataContext()) { //有效性检查(1、已被取消或者拒绝。2、已被购买) var data1 = dbma1.P400s.Where(c => c.reserveSN == reserveSN && (c.senderCancelReserveDate != null || c.receiverRefuseReserveDate != null)).FirstOrDefault(); var data2 = dbma1.P401s.Where(c => c.reserveSN == reserveSN).FirstOrDefault(); if (data1 != null || data2 != null) { return; } //加入资产购买表 P401 string max33SN = C101.FC10102("P401", 6, "J"); P400 p400 = dbma1.P400s.Where(c => c.reserveSN == reserveSN).First(); P401 p401 = new P401(); p401.purchaseSN = max33SN; p401.reserveSN = reserveSN; p401.purchaserUserSN = userSN; p401.sellerUserSN = p400.receiverUserSN; p401.assetsSN = p400.assetsSN; p401.purchasePrice = purcharsePrice; p401.purchaseDate = DateTime.Now; dbma1.P401s.InsertOnSubmit(p401); //加入账单表 F001 decimal serviceRate = Convert.ToDecimal(dbma1.A027s.First().serviceRate); string F001max33SN = C101.FC10102("F001", 6, "L"); F001 f001 = new F001(); f001.billSN = F001max33SN; f001.payerUserSN = p400.receiverUserSN; f001.businessSN = p400.assetsSN; f001.billType = "资产出售"; f001.MoneyAmount = purcharsePrice * serviceRate * 10000; f001.generateDate = DateTime.Now; dbma1.F001s.InsertOnSubmit(f001); dbma1.SubmitChanges(); U003 u003 = dbma1.U003s.Where(c => c.userSN == p400.receiverUserSN).First(); //如有邮箱提醒 if (u003.billGenerate_email == true) { BillSendByEmail(dbma1, p400.receiverUserSN, p400.assetsSN); } //如有短信提醒 if (u003.billGenerate_shortMessage == true) { BillSendBySM(dbma1, p400.receiverUserSN, p400.assetsSN); } dbma1.SubmitChanges(); } }
public void FP30303(string purchaseSN) { using (DBMA1DataContext dbma1 = new DBMA1DataContext()) { P401 p401 = dbma1.P401s.Where(c => c.purchaseSN == purchaseSN).First(); p401.sellerDeleteDate = DateTime.Now; dbma1.SubmitChanges(); } }