一步一步搭建，功能最全的权限管理系统（一）

/// 

/// 仓储接口定义
/// 
public interface IRepository
{

}

/// 

/// 定义泛型仓储接口
/// 
/// 实体类型
/// 主键类型
public interface IRepository : IRepository where T : class, new()
{
    /// 

    /// 新增
    /// 
    /// 实体
    /// 新增sql
    /// 
    int Inse服务器托管网rt(T entity, string innserSql);

    /// 

    /// 修改
    /// 
    /// 实体
    /// 更新sql
    /// 
    int Update(T entity, string updateSql);

    /// 

    /// 删除
    /// 
    /// 删除sql
    /// 
    int Delete(string key,string deleteSql);

    /// 

    /// 根据主键获取模型
    /// 
    /// 主键
    /// 查询sql
    /// 
    T GetByKey(string key, string selectSql);

    /// 

    /// 获取所有数据
    /// 
    /// 查询sql
    /// 
    List GetAll(string selectAllSql);

    /// 

    /// 根据唯一主键验证数据是否存在
    /// 
    /// 主键
    /// 查询sql
    /// 返回true存在，false不存在
    bool IsExist(string id, string selectSql);

    /// 

    /// dapper通用分页方法
    /// 
    /// 泛型集合实体类
    /// 分页模型
    /// 
    PageResultModel GetPageList(PageResultModel pageResultModel);

}

/// 

/// 仓储基类
/// 
/// 实体类型
/// 主键类型
public abstract class Repository : IRepository where T : class, new()
{
    /// 

    /// 删除
    /// 
    /// 删除sql
    /// 
    public int Delete(string key, string deleteSql)
    {
        using var connection = DataBaseConnectConfig.GetSqlConnection();
        return connection.Execute(deleteSql, new { Key = key });
    }

    /// 

    /// 根据主键获取模型
    /// 
    /// 主键
    /// 查询sql
    /// 
    public T GetByKey(string id, string selectSql)
    {
        using var connection = DataBaseConnectConfig.GetSqlConnection();
        return connection.QueryFirstOrDefault(selectSql, new { Key = id });
    }

    /// 

    /// 获取所有数据
    /// 
    /// 查询sql
    /// 
    public List GetAll(string selectAllSql)
    {
        using var connection = DataBaseConnectConfig.GetSqlConnection();
        return connection.Query(selectAllSql).ToList();
    }

    /// 

    /// 新增
    /// 
    /// 新增实体
    /// 新增sql
    /// 
    public int Insert(T entity, string innserSql)
    {
        using var connection = DataBaseConnectConfig.GetSqlConnection();
        return connection.Execute(innserSql, entity);
    }

    /// 

    /// 根据唯一主键验证数据是否存在
    /// 
    /// 主键
    /// 查询sql
    /// 返回true存在，false不存在
    public bool IsExist(string id, string selectSql)
    {
        using var connection = DataBaseConnectConfig.GetSqlConnection();
        var count = connection.QueryFirstint>(selectSql, new { Key = id });
        if (count > 0)
            return true;
        else
            return false;
    }

    /// 

    /// 更新
    /// 
    /// 更新实体
    /// 更新sql
    /// 
    public int Update(T entity, string updateSql)
    {
        using var connection = DataBaseConnectConfig.GetSqlConnection();
        return connection.Execute(updateSql, entity);
    }

    /// 

    /// 分页方法
    /// 
    /// 泛型集合实体类
    /// 分页模型
    /// 
    public PageResultModel GetPageList(PageResultModel pageResultModel)
    {
        PageResultModel resultModel = new();
        using var connection = DataBaseConnectConfig.GetSqlConnection();
        int skip = 1;
        var orderBy = string.Empty;
        if (pageResultModel.pageIndex > 0)
        {
            skip = (pageResultModel.pageIndex - 1) * pageResultModel.pageSize + 1;
        }
        if (!string.IsNullOrEmpty(pageResultModel.orderByField))
        {
            orderBy = string.Format(" ORDER BY {0} {1} ", pageResultModel.orderByField, pageResultModel.sortType);
        }
        StringBuilder sb = new StringBuilder();
        sb.AppendFormat("SELECT COUNT(1) FROM {0} where 1=1 {1};", pageResultModel.tableName, pageResultModel.selectWhere);
        sb.AppendFormat(@"SELECT  *
                            FROM(SELECT ROW_NUMBER() OVER( {3}) AS RowNum,{0}
                                      FROM  {1}
                                      where 1=1 {2}
                                    ) AS result
                            WHERE  RowNum >= {4}   AND RowNum ", pageResultModel.tableField, pageResultModel.tableName, pageResultModel.selectWhere, orderBy, skip, pageResultModel.pageIndex * pageResultModel.pageSize);
        using var reader = connection.QueryMultiple(sb.ToString());
        resultModel.total = reader.ReadFirstint>();
        resultModel.data = reader.Read().ToList();
        return resultModel;
    }

}

export const generator = (
  routeMap: any[],
  parentId: string | number,
  routeItem?: any | [],
) => {
  return routeMap
    //.filter(item => item.menuKey === parentId)
    .map(item => {

      const { title, requireAuth, menuKey } = item || {};
      const currentRouter: RouteRecordRaw = {
        // 如果路由设置了 path，则作为默认 path，否则 路由地址 动态拼接生成如 /dashboard/workplace
        path: item.path,
        // 路由名称，建议唯一
        //name: `${item.id}`,
        // meta: 页面标题, 菜单图标, 页面权限(供指令权限用，可去掉)
        meta: {
          title,
          requireAuth,
          menuKey
        },
        name: item.name,
        children: [],
        // 该路由对应页面的 组件 (动态加载 @/views/ 下面的路径文件)
        component: item.component && defineRouteComponentKeys.includes(item.component)
          ? defineRouteComponents[item.component]
          : () => url.value,

      };

      // 为了防止出现后端返回结果不规范，处理有可能出现拼接出两个 反斜杠
      if (!currentRouter.path.startsWith('http')) {
        currentRouter.path = currentRouter.path.replace('//', '/');
      }

      // 重定向
      item.redirect && (currentRouter.redirect = item.redirect);
      if (item.children != null) {
        // 子菜单，递归处理
        currentRouter.children = generator(item.children, item.menuKey, currentRouter);
      }
      if (currentRouter.children === undefined || currentRouter.children.length 0) {
        currentRouter.children;
      }
      return currentRouter;
    })
    .filter(item => item);
};