这是我的存储过程

IF(@mode='DELETE')
        BEGIN
            UPDATE ProjectCostingTypes SET [IsDeleted] = 1, [ModifiedBy] = 1, [ModifiedOn] = GETDATE() 
            WHERE [ProjectCostingTypeId] =@Id 
            SELECT IsDeleted,ProjectCostingTypeId
            FROM ProjectCostingTypes WHERE ProjectCostingTypeId=@Id
        END

下面是我的存储库

public async Task<string> DeleteMultipleProjectCostingTypeByID(List<int> Ids)
        {
            try
            {
                using (var connection = _context.CreateConnection())
                {
                    foreach (int id in Ids)
                    {
                        var parameters = new DynamicParameters();
                        parameters.Add(APIConstants.PARAM_NAME_ID, id);
                        parameters.Add(APIConstants.PARAM_NAME_MODE, APIConstants.PARAM_VALUE_DELETE);
                        parameters.Add(APIConstants.PARAM_NAME_MASTER, APIConstants.PROJECT_COSTING_TYPE);

                        var data = await connection.QuerySingleOrDefaultAsync<ProjectCostingTypes>(APIConstants.DELETE_PROJECT_COSTING_TYPES, parameters, commandType: CommandType.StoredProcedure);

                        // var data = await connection.QueryAsync(APIConstants.DELETE_PROJECT_COSTING_TYPES, parameters, commandType: CommandType.StoredProcedure);
                    }
                    return "Deleted data successfully";
                }
            }
            catch (Exception ex)
            {
                return ex.Message;
            }

        }