omega_source/Model/Database/ApiInfo.cs

using System.Linq;
using Mapster;
using Util;
using static System.Runtime.InteropServices.JavaScript.JSType;


namespace Model
{
    /// <summary>
    /// 接口信息 api_info
    /// </summary>
    [SugarTable("api_info", "接口信息")]
    [Tenant("0")]
    public class ApiInfo
    {
        /// <summary>
        /// ID
        /// </summary>
        [SugarColumn(ColumnDescription = "ID", IsPrimaryKey = true, IsIdentity = true, ColumnName = "id")]
        public int id { get; set; }


        /// <summary>
        /// 版本号
        /// </summary>
        [SugarColumn(ColumnDescription = "版本号", ColumnName = "version")]
        public int version { get; set; }


        /// <summary>
        /// 删除标记
        /// </summary>
        [SugarColumn(ColumnDescription = "删除标记", ColumnName = "del_flag")]
        public int delFlag { get; set; }


        /// <summary>
        /// 创建时间
        /// </summary>
        [SugarColumn(ColumnDescription = "创建时间", ColumnName = "create_time")]
        public DateTime? createTime { get; set; }


        /// <summary>
        /// 更新时间
        /// </summary>
        [SugarColumn(ColumnDescription = "更新时间", ColumnName = "update_time")]
        public DateTime? updateTime { get; set; }


        /// <summary>
        /// 创建人
        /// </summary>
        [SugarColumn(ColumnDescription = "创建人", Length = 32, ColumnName = "create_by")]
        public string? createBy { get; set; }


        /// <summary>
        /// 更新人
        /// </summary>
        [SugarColumn(ColumnDescription = "更新人", Length = 32, ColumnName = "update_by")]
        public string? updateBy { get; set; }


        /// <summary>
        /// 服务ID
        /// </summary>
        [SugarColumn(ColumnDescription = "服务ID", ColumnName = "service_id")]
        public int serviceId { get; set; }


        /// <summary>
        /// 接口分组ID
        /// </summary>
        [SugarColumn(ColumnDescription = "接口分组ID", ColumnName = "group_id")]
        public int groupId { get; set; }
        [SugarColumn(IsIgnore = true)]
        public string groupName { get; set; }
        [SugarColumn(IsIgnore = true)]
        public string groupTitle { get; set; }


        /// <summary>
        /// 板块名称
        /// </summary>
        [SugarColumn(ColumnDescription = "板块名称", Length = 50, ColumnName = "tab_name")]
        public string? tabName { get; set; }


        /// <summary>
        /// 接口名称
        /// </summary>
        [SugarColumn(ColumnDescription = "接口名称", Length = 100, ColumnName = "api_name")]
        public string? apiName { get; set; }


        /// <summary>
        /// 控制器文件路径
        /// </summary>
        [SugarColumn(ColumnDescription = "控制器文件路径", Length = 50, ColumnName = "controller_file_path")]
        public string? controllerFilePath { get; set; }
        [SugarColumn(IsIgnore = true)]
        public string? controllerName
        {
            get
            {
                return PublicFunction.transferName(controllerFilePath, 1);
            }
        }


        /// <summary>
        /// 使用场景
        /// </summary>
        [SugarColumn(ColumnDescription = "使用场景", ColumnName = "usage_scenarios")]
        public int usageScenarios { get; set; }


        /// <summary>
        /// 接口类型
        /// </summary>
        [SugarColumn(ColumnDescription = "接口类型", ColumnName = "api_kind")]
        public int apiKind { get; set; }


        /// <summary>
        /// 方法名
        /// </summary>
        [SugarColumn(ColumnDescription = "方法名", Length = 100, ColumnName = "method_name")]
        public string? methodName { get; set; }
        [SugarColumn(IsIgnore = true)]
        public string? methodNameUpper 
        {
            get
            {
                return PublicFunction.transferName(methodName);
            }
        }
        [SugarColumn(IsIgnore = true)]
        public string? methodNameFirstUpper 
        {
            get
            {
                return PublicFunction.transferName(methodName, 1);
            }
        }


        /// <summary>
        /// 接口表述
        /// </summary>
        [SugarColumn(ColumnDescription = "接口表述", Length = 255, ColumnName = "api_detail")]
        public string? apiDetail { get; set; }


        /// <summary>
        /// 接口参数
        /// </summary>
        [SugarColumn(ColumnDescription = "接口参数", ColumnName = "api_param", IsJson = true, ColumnDataType = "json")]
        public List<ApiParamObject> apiParam { get; set; }
        [SugarColumn(IsIgnore = true)]
        public int apiParamCount
        {
            get
            {
                if (apiParam != null)
                {
                    return apiParam.Count(m => m.reqParam);
                }
                else
                {
                    return 0;
                }
            }
        }
        [SugarColumn(IsIgnore = true)]
        public int apiResParamCount
        {
            get
            {
                if (apiParam != null)
                {
                    return apiParam.Count(m => m.resParam);
                }
                else
                {
                    return 0;
                }
            }
        }
        [SugarColumn(IsIgnore = true)]
        public string? apiParamFirstParam
        {
            get
            {
                if (apiParamCount > 0)
                {
                    return apiParam.FirstOrDefault(m => m.reqParam)?.fieldName ?? "";
                }
                else
                {
                    return "";
                }
            }
        }
        [SugarColumn(IsIgnore = true)]
        public string? apiParamFirstParamUpper
        {
            get
            {
                return PublicFunction.transferName(apiParamFirstParam);
            }
        }
        [SugarColumn(IsIgnore = true)]
        public string? apiParamFirstParamFirstUpper
        {
            get
            {
                return PublicFunction.transferName(apiParamFirstParam, 1);
            }
        }
        [SugarColumn(IsIgnore = true)]
        public string? apiParamFirstParamType
        {
            get
            {
                if (apiParamCount > 0)
                {
                    return apiParam.FirstOrDefault(m => m.reqParam)?.fieldType ?? "";
                }
                else
                {
                    return "";
                }
            }
        }
        [SugarColumn(IsIgnore = true)]
        public bool apiParamFirstParamCustomFlag
        {
            get
            {
                if (apiParamCount > 0)
                {
                    return apiParam.FirstOrDefault(m => m.reqParam)?.customFlag ?? true;
                }
                else
                {
                    return true;
                }
            }
        }


        /// <summary>
        /// 关联表ID
        /// </summary>
        [SugarColumn(ColumnDescription = "关联表ID", ColumnName = "link_table_id")]
        public int linkTableId { get; set; }
        [SugarColumn(IsIgnore = true)]
        public string? linkTableTitle { get; set; } 
        [SugarColumn(IsIgnore = true)]
        public string? linkTableName { get; set; } 
        [SugarColumn(IsIgnore = true)]
        public string? linkTableNameUpper
        {
            get
            {
                return PublicFunction.transferName(linkTableName);
            }
        }
        [SugarColumn(IsIgnore = true)]
        public string? linkTableNameFirstUpper
        {
            get
            {
                return PublicFunction.transferName(linkTableName, 1);
            }
        }



        /// <summary>
        /// 分页
        /// </summary>
        [SugarColumn(ColumnDescription = "分页", ColumnName = "page_flag")]
        public bool pageFlag { get; set; }


    }

    public class ApiParamObject
    {
        public int id { get; set; }


        /// <summary>
        /// 字段名称
        /// </summary>
        public string fieldTitle { get; set; }


        /// <summary>
        /// 字段名
        /// </summary>
        public string fieldName { get; set; }
        public string fieldNameUpper
        {
            get
            {
                return PublicFunction.transferName(fieldName);
            }
        }
        public string fieldNameFirstUpper
        {
            get
            {
                return PublicFunction.transferName(fieldName, 1);
            }
        }


        /// <summary>
        /// 字段类型
        /// </summary>
        public string fieldType { get; set; }


        /// <summary>
        /// 请求参数
        /// </summary>
        public bool reqParam { get; set; }


        /// <summary>
        /// 返回字段
        /// </summary>
        public bool resParam { get; set; }


        /// <summary>
        /// 自定义
        /// </summary>
        public bool customFlag { get; set; }


        /// <summary>
        /// 返回类型
        /// </summary>
        public string resType { get; set; }


        /// <summary>
        /// 验证属性
        /// </summary>
        public string[] checkAttribute { get; set; }
        public string checkAttributeString
        {
            get
            {
                if (checkAttribute != null)
                {
                    return string.Join(",", checkAttribute);
                }
                else
                {
                    return "";
                }
            }   
        }


        /// <summary>
        /// 排序方式
        /// </summary>
        public string sortMode { get; set; }


        /// <summary>
        /// 字段说明
        /// </summary>
        public string fieldDetail { get; set; }


        /// <summary>
        /// 关联表ID
        /// </summary>
        public int linkTableId { get; set; }
        public string? linkTableTitle { get; set; } 
        public string? linkTableName { get; set; } 
        public string? linkTableNameUpper
        {
            get
            {
                return PublicFunction.transferName(linkTableName);
            }
        }
        public string? linkTableNameFirstUpper
        {
            get
            {
                return PublicFunction.transferName(linkTableName, 1);
            }
        }

        /// <summary>
        /// 关联表主键字段
        /// </summary>
        public string? linkTablePrimaryKeyName { get; set; } 


        /// <summary>
        /// 关联参数
        /// </summary>
        public List<ApiParamObject> linkParam { get; set; }


        /// <summary>
        /// 关联参数数量
        /// </summary>
        public int linkParamCount
        { 
            get 
            {
                if (linkParam != null)
                {
                    return linkParam.Count;
                }
                else
                {
                    return 0;
                }
            }
        }
    }
}