public void FP70201() { string userSN = session["userSN"].ToString(); //string userSN = "U00004"; using (DBMA1DataContext dbma1 = new DBMA1DataContext()) { decimal rewardAmount = Convert.ToInt32(dbma1.A031s.First().regPresentV); //更新账户表 F000 F000 f000 = dbma1.F000s.Where(c => c.userSN == userSN).First(); f000.balance += rewardAmount; f000.lastOperate = DateTime.Now; //添加奖励表 F004 string F004Max33SN = C101.FC10102("F004", 7, "UB"); F004 f004 = new F004(); f004.rewardSN = F004Max33SN; f004.userSN = userSN; f004.rewardAmount = rewardAmount; f004.rewardDate = DateTime.Now; f004.rewardType = "注册赠送"; dbma1.F004s.InsertOnSubmit(f004); //添加收支明细表 F003 string F003Max33SN = C101.FC10102("F003", 8, "UA"); F003 f003 = new F003(); f003.revenueExpenditureSN = F003Max33SN; f003.generetorUserSN = userSN; f003.generateDate = DateTime.Now; f003.type = "注册赠送"; f003.revenue = rewardAmount; f003.balance = f000.balance; f003.referSN = F004Max33SN; dbma1.F003s.InsertOnSubmit(f003); dbma1.SubmitChanges(); } }
public void FP90110(string billNo, decimal amount, string ifSuc, string ipsBillNo, string bankBillNo, string userSN) { using (DBMA1DataContext dbma1 = new DBMA1DataContext()) { //获得vip奖励比率 //decimal rewardRate = 1; decimal rewardRate = C201.FC20152(dbma1, userSN); //充值记录表 F005 F005 f005 = dbma1.F005s.Where(c => c.rechargeSN == billNo).First(); f005.ifSuccess = ifSuc == "Y" ? true : false; f005.ipsBillNo = ipsBillNo; f005.bankBillNo = bankBillNo; if (ifSuc == "Y") { //充值写入余额表 F000 F000 f000 = dbma1.F000s.Where(c => c.userSN == userSN).First(); f000.balance += amount; //充值写入流水明细表 F003 F003 f003_1 = new F003(); f003_1.revenueExpenditureSN = C101.FC10102("F003", 8, "UA"); f003_1.generetorUserSN = userSN; f003_1.generateDate = DateTime.Now; f003_1.type = "账户充值"; f003_1.revenue = amount; f003_1.balance = f000.balance; f003_1.referSN = f005.rechargeSN; dbma1.F003s.InsertOnSubmit(f003_1); if (rewardRate > 0) { //奖励表 F004 F004 f004 = new F004(); f004.rewardSN = C101.FC10102("F004", 7, "UB"); f004.userSN = userSN; f004.rewardAmount = amount * rewardRate; f004.rewardDate = DateTime.Now; f004.referSN = billNo; f004.rewardType = "充值奖励"; dbma1.F004s.InsertOnSubmit(f004); //奖励写入余额表 F000 f000.balance += Convert.ToDecimal(f004.rewardAmount); //奖励写入流水明细表 F003 F003 f003_2 = new F003(); f003_2.revenueExpenditureSN = C101.FC10102("F003", 8, "UA"); f003_2.generetorUserSN = userSN; f003_2.generateDate = DateTime.Now; f003_2.type = "充值奖励"; f003_2.revenue = f004.rewardAmount; f003_2.balance = f000.balance; f003_2.referSN = f004.rewardSN; dbma1.F003s.InsertOnSubmit(f003_2); } } dbma1.SubmitChanges(); } }