public async Task <IActionResult> UpdateMealAccountStatus([FromBody] ModifyMealAccountRequestDto request)
{
var result = false;
var accountBiz = new MealAccountBiz();
//若账户不存在，则创建个人充值账户
var accountTypes = await accountBiz.GetAccountTypes(request.HospitalGuid, request.UserGuid);
if (accountTypes is null || accountTypes.Count() <= 0)
{
var models = new List <MealAccountModel>()
{
new MealAccountModel()
{
AccountBalance = 0,
AccountGuid = Guid.NewGuid().ToString("N"),
AccountType = MealAccountTypeEnum.Recharge.ToString(),
CreatedBy = UserID,
HospitalGuid = request.HospitalGuid,
UserGuid = request.UserGuid,
LastUpdatedBy = UserID,
OrgGuid = "",
UserType = MealUserTypeEnum.External.ToString(),
Enable = false
}
};
result = await accountBiz.CreateAccount(models) ? true : false;
}
/// <summary>
/// 更新账户状态（将个人账户和赠款账户同时禁用或启用）
/// </summary>
/// <param name="requestDto"></param>
/// <returns></returns>
public async Task <bool> UpdateAccountStatus(ModifyMealAccountRequestDto requestDto)
{
var parameters = new DynamicParameters();
var sql = @"update t_meal_account
set `enable` = (IF(`enable` = 0, 1, 0))
where hospital_guid = @hospitalGuid and user_guid = @userGuid";
parameters.Add("@hospitalGuid", requestDto.HospitalGuid);
parameters.Add("@userGuid", requestDto.UserGuid);
using (var conn = MySqlHelper.GetConnection())
{
var result = await conn.ExecuteAsync(sql, parameters);
return(result > 0);
}
}
