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