一步一步搭建，功能最全的权限管理系统之动态路由菜单（一）

/// <summary>
///仓储接口定义/// </summary>
public interfaceIRepository

{



}/// <summary>
///定义泛型仓储接口/// </summary>
/// <typeparam name="T">实体类型</typeparam>
/// <typeparam name="object">主键类型</typeparam>
public interface IRepository<T> : IRepository where T : class, new()

{/// <summary>
    ///新增/// </summary>
    /// <param name="entity">实体</param>
    /// <param name="innserSql">新增sql</param>
    /// <returns></returns>
    int Insert(T entity, stringinnserSql);/// <summary>
    ///修改/// </summary>
    /// <param name="entity">实体</param>
    /// <param name="updateSql">更新sql</param>
    /// <returns></returns>
    int Update(T entity, stringupdateSql);/// <summary>
    ///删除/// </summary>
    /// <param name="deleteSql">删除sql</param>
    /// <returns></returns>
    int Delete(string key,stringdeleteSql);/// <summary>
    ///根据主键获取模型/// </summary>
    /// <param name="key">主键</param>
    /// <param name="selectSql">查询sql</param>
    /// <returns></returns>
    T GetByKey(string key, stringselectSql);/// <summary>
    ///获取所有数据/// </summary>
    /// <param name="selectAllSql">查询sql</param>
    /// <returns></returns>
    List<T> GetAll(stringselectAllSql);/// <summary>
    ///根据唯一主键验证数据是否存在/// </summary>
    /// <param name="id">主键</param>
    /// <param name="selectSql">查询sql</param>
    /// <returns>返回true存在，false不存在</returns>
    bool IsExist(string id, stringselectSql);/// <summary>
    ///dapper通用分页方法/// </summary>
    /// <typeparam name="T">泛型集合实体类</typeparam>
    /// <param name="pageResultModel">分页模型</param>
    /// <returns></returns>
    PageResultModel<T> GetPageList<T>(PageResultModel pageResultModel);



}

/// <summary>
///仓储基类/// </summary>
/// <typeparam name="T">实体类型</typeparam>
/// <typeparam name="TPrimaryKey">主键类型</typeparam>
public abstract class Repository<T> : IRepository<T> where T : class, new()

{/// <summary>
    ///删除/// </summary>
    /// <param name="deleteSql">删除sql</param>
    /// <returns></returns>
    public int Delete(string key, stringdeleteSql)

    {using var connection =DataBaseConnectConfig.GetSqlConnection();return connection.Execute(deleteSql, new { Key =key });

    }/// <summary>
    ///根据主键获取模型/// </summary>
    /// <param name="id">主键</param>
    /// <param name="selectSql">查询sql</param>
    /// <returns></returns>
    public T GetByKey(string id, stringselectSql)

    {using var connection =DataBaseConnectConfig.GetSqlConnection();return connection.QueryFirstOrDefault<T>(selectSql, new { Key =id });

    }/// <summary>
    ///获取所有数据/// </summary>
    /// <param name="selectAllSql">查询sql</param>
    /// <returns></returns>
    public List<T> GetAll(stringselectAllSql)

    {using var connection =DataBaseConnectConfig.GetSqlConnection();return connection.Query<T>(selectAllSql).ToList();

    }/// <summary>
    ///新增/// </summary>
    /// <param name="entity">新增实体</param>
    /// <param name="innserSql">新增sql</param>
    /// <returns></returns>
    public int Insert(T entity, stringinnserSql)

    {using var connection =DataBaseConnectConfig.GetSqlConnection();returnconnection.Execute(innserSql, entity);

    }/// <summary>
    ///根据唯一主键验证数据是否存在/// </summary>
    /// <param name="id">主键</param>
    /// <param name="selectSql">查询sql</param>
    /// <returns>返回true存在，false不存在</returns>
    public bool IsExist(string id, stringselectSql)

    {using var connection =DataBaseConnectConfig.GetSqlConnection();var count = connection.QueryFirst<int>(selectSql, new { Key =id });if (count > 0)return true;else
            return false;

    }/// <summary>
    ///更新/// </summary>
    /// <param name="entity">更新实体</param>
    /// <param name="updateSql">更新sql</param>
    /// <returns></returns>
    public int Update(T entity, stringupdateSql)

    {using var connection =DataBaseConnectConfig.GetSqlConnection();returnconnection.Execute(updateSql, entity);

    }/// <summary>
    ///分页方法/// </summary>
    /// <typeparam name="T">泛型集合实体类</typeparam>
    /// <param name="pageResultModel">分页模型</param>
    /// <returns></returns>
    public PageResultModel<T> GetPageList<T>(PageResultModel pageResultModel)

    {

        PageResultModel<T> 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= newStringBuilder();

        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 <= {5}", pageResultModel.tableField, pageResultModel.tableName, pageResultModel.selectWhere, orderBy, skip, pageResultModel.pageIndex *pageResultModel.pageSize);using var reader =connection.QueryMultiple(sb.ToString());

        resultModel.total= reader.ReadFirst<int>();

        resultModel.data= reader.Read<T>().ToList();returnresultModel;

    }



}

export const generator =(

  routeMap: any[],

  parentId:string |number,

  routeItem?: any |[],

)=>{returnrouteMap//.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;

      }returncurrentRouter;

    })

    .filter(item=>item);

};