54 lines
1.8 KiB
C#
54 lines
1.8 KiB
C#
using System;
|
|
using System.Collections.Generic;
|
|
using Erp.SqlQueryManager.Domain.Shared;
|
|
using Volo.Abp.Application.Dtos;
|
|
|
|
namespace Erp.SqlQueryManager.Application.Contracts;
|
|
|
|
public class SqlFunctionDto : FullAuditedEntityDto<Guid>
|
|
{
|
|
public string FunctionName { get; set; }
|
|
public string SchemaName { get; set; }
|
|
public string DisplayName { get; set; }
|
|
public string Description { get; set; }
|
|
public SqlFunctionType FunctionType { get; set; }
|
|
public string FunctionBody { get; set; }
|
|
public string ReturnType { get; set; }
|
|
public string DataSourceCode { get; set; }
|
|
public SqlQueryStatus Status { get; set; }
|
|
public string Category { get; set; }
|
|
public bool IsDeployed { get; set; }
|
|
public DateTime? LastDeployedAt { get; set; }
|
|
public string Parameters { get; set; }
|
|
public bool IsCustom { get; set; } // true = stored in database, false = native SQL Server object
|
|
}
|
|
|
|
public class CreateSqlFunctionDto
|
|
{
|
|
public string FunctionName { get; set; }
|
|
public string SchemaName { get; set; }
|
|
public string DisplayName { get; set; }
|
|
public string Description { get; set; }
|
|
public SqlFunctionType FunctionType { get; set; }
|
|
public string FunctionBody { get; set; }
|
|
public string ReturnType { get; set; }
|
|
public string DataSourceCode { get; set; }
|
|
public string Category { get; set; }
|
|
public string Parameters { get; set; }
|
|
}
|
|
|
|
public class UpdateSqlFunctionDto
|
|
{
|
|
public string DisplayName { get; set; }
|
|
public string Description { get; set; }
|
|
public string FunctionBody { get; set; }
|
|
public string ReturnType { get; set; }
|
|
public string Category { get; set; }
|
|
public string Parameters { get; set; }
|
|
}
|
|
|
|
public class DeployFunctionDto
|
|
{
|
|
public Guid Id { get; set; }
|
|
public bool DropIfExists { get; set; }
|
|
}
|