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