public void handler(IResponder responder)
{
int uid = SJSRequest.GetInt("Uid", 0);
double balance = SJSRequest.GetFloat("Balancemoney", 0);
string remarks = SJSRequest.GetString("Remarks");
if (uid <= 0)
{
responder.WriteErroredMsg("请求参数错误!");
return;
}
if (balance <= 0)
{
responder.WriteErroredMsg("充值金额不能小于或等于0!");
return;
}
using (DbTransaction trans = DbHelper.BeginTransaction())
{
bool writeError = false;
try
{
User user = UserManager.GetUser(uid, trans);
if (user == null)
{
writeError = true;
trans.Rollback();
responder.WriteErroredMsg("此用户不存在,无法充值!");
return;
}
user.Balance += balance;
int rlt = UserManager.UpdateUserBalance(user.Uid, -balance, trans);
if (rlt <= 0)
{
writeError = true;
trans.Rollback();
responder.WriteErroredMsg("充值失败,数据库数据更新不成功!");
return;
}
Balance balances = new Balance();
balances.Uid = uid;
balances.Balances = balance;
balances.Remarks = remarks;
balances.Btime = DateTime.Now;// DateTime.UtcNow;
balances.Id = BalanceManager.AddBalance(balances, trans);
if (balances.Id <= 0)
{
writeError = true;
trans.Rollback();
responder.WriteErroredMsg(user.Realname + "充值记录失败!");
return;
}
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
if (writeError == false)
{
responder.WriteErroredMsg("充值失败,程序异常!");
}
return;
}
}
responder.WriteSuccessedMsg("充值成功!");
}
public static int AddBalance(Balance balances, System.Data.Common.DbTransaction trans)
{
return DatabaseProvider.GetInstance().AddBalance(balances, trans);
}
/// <summary>
/// 修改方法
/// </summary>
public static int UpdateBalance(Balance balance)
{
return DatabaseProvider.GetInstance().UpdateBalance(balance);
}
/// <summary>
/// 添加方法
/// </summary>
public static int AddBalance(Balance balance)
{
return DatabaseProvider.GetInstance().AddBalance(balance);
}
public static Balance GetBalance(IDataReader reader)
{
Balance model = new Balance();
model.Id = (reader["Id"] is DBNull ? Convert.ToInt32("0") : Convert.ToInt32(reader["Id"]));
model.Uid = (reader["Uid"] is DBNull ? Convert.ToInt32("0") : Convert.ToInt32(reader["Uid"]));
model.Balances = (reader["Balances"] is DBNull ? Convert.ToDouble("0") : Convert.ToDouble(reader["Balances"]));
model.Btime = (reader["Btime"] is DBNull ? Convert.ToDateTime("1900-01-01") : Convert.ToDateTime(reader["Btime"]));
model.Remarks = reader["Remarks"].ToString();
return model;
}