public string FP90102(decimal rechargeAmount, string cardType, string bankId)
{
string userSN = session["userSN"].ToString();
using (DBMA1DataContext dbma1 = new DBMA1DataContext())
{
F005 f005 = new F005();
f005.rechargeSN = C101.FC10102("F005", 7, "UC");
f005.userSN = userSN;
f005.rechargeAmount = rechargeAmount;
f005.rechargeDate = DateTime.Now;
f005.cardType = cardType;
f005.bankId = bankId;
dbma1.F005s.InsertOnSubmit(f005);
dbma1.SubmitChanges();
return(string.Format("{0}%{1}", f005.rechargeSN, userSN));
}
}
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();
}
}