public ActionResult UpdAccount(int id, decimal fee)
{
UserInfo userInfo = AdminUsers.GetUserById(id);
if (userInfo == null)
{
return(AjaxResult("success", "用户不存在"));
}
var result = Users.UpdateUserAccount(id, fee);
if (result)
{
MD_Change achange = new MD_Change()
{
Account = userInfo.Mobile,
Accounted = userInfo.TotalMoney,
Changemoney = fee,
Remark = fee > 1?"上分":"下分"
};
var s = NewUser.AddAChange(achange);
AddAdminOperateLog("修改用户账余", "修改用户账余,用户ID为:" + id);
return(AjaxResult("success", "修改用户账余成功"));
}
else
{
return(AjaxResult("error", "用户账余修改失败"));
}
}
/// <summary>
/// 添加用户账变记录
/// </summary>
/// <param name="chag"></param>
/// <returns></returns>
public string AddAChange(MD_Change chag)
{
DbParameter[] parms =
{
GenerateInParam("@account", SqlDbType.VarChar, 15, chag.Account),
GenerateInParam("@changemoney", SqlDbType.Decimal, 10, chag.Changemoney),
GenerateInParam("@remark", SqlDbType.VarChar, 100, chag.Remark)
};
string commandText = string.Format(@"
begin try
INSERT INTO owzx_accountchange([uid],[changemoney],[remark])
VALUES ((select uid from owzx_users where rtrim(mobile)=@account),@changemoney,@remark)
select '添加成功' state
end try
begin catch
select ERROR_MESSAGE() state
end catch
");
return(RDBSHelper.ExecuteScalar(CommandType.Text, commandText, parms).ToString());
}
/// <summary>
/// 更新账变信息
/// </summary>
/// <param name="msg"></param>
/// <returns></returns>
public static string UpdateAChange(MD_Change chag)
{
return(OWZX.Data.NewUser.UpdateAChange(chag));
}
/// <summary>
/// 添加用户账变记录
/// </summary>
/// <param name="chag"></param>
/// <returns></returns>
public static string AddAChange(MD_Change chag)
{
return(OWZX.Data.NewUser.AddAChange(chag));
}
/// <summary>
/// 添加用户账变记录
/// </summary>
/// <param name="chag"></param>
/// <returns></returns>
public static string AddAChange(MD_Change chag)
{
return(OWZX.Core.BSPData.RDBS.AddAChange(chag));
}
/// <summary>
/// 更新账变信息
/// </summary>
/// <param name="msg"></param>
/// <returns></returns>
public static string UpdateAChange(MD_Change chag)
{
return(OWZX.Core.BSPData.RDBS.UpdateAChange(chag));
}
/// <summary>
/// 更新账变信息
/// </summary>
/// <param name="msg"></param>
/// <returns></returns>
public string UpdateAChange(MD_Change chag)
{
return("");
}
