/// <summary>
/// 根据系统类型ID，获取对应的操作功能列表
/// </summary>
/// <param name="typeID">系统类型ID</param>
/// <returns></returns>
public IEnumerable <Menu> GetFunctions(string typeID)
{
string sql = $"SELECT DISTINCT b.* FROM sys_menu as b ";
if (!string.IsNullOrEmpty(typeID))
{
sql = sql + string.Format(" Where SystemTypeId='{0}' ", typeID);
}
return(DapperConnRead.Query <Menu>(sql));
}
/// <summary>
/// 根据角色ID字符串（逗号分开)和系统类型ID，获取对应的操作功能列表
/// </summary>
/// <param name="roleIds">角色ID</param>
/// <param name="typeID">系统类型ID</param>
/// <param name="isMenu">是否是菜单</param>
/// <returns></returns>
public IEnumerable <Menu> GetFunctions(string roleIds, string typeID, bool isMenu = false)
{
string sql = $"SELECT DISTINCT b.* FROM sys_menu as b INNER JOIN Sys_RoleAuthorize as a On b.Id = a.ItemId WHERE ObjectId IN (" + roleIds + ")";
if (roleIds == "")
{
sql = $"SELECT DISTINCT b.* FROM sys_menu as b where 1=1 ";
}
if (isMenu)
{
sql = sql + "and menutype in('M','C')";
}
if (!string.IsNullOrEmpty(typeID))
{
sql = sql + string.Format(" AND SystemTypeId='{0}' ", typeID);
}
return(DapperConnRead.Query <Menu>(sql));
}
public IList <AppOutputDto> SelectApp()
{
const string query = @"select a.*,u.id as Id,u.NickName,u.Account,u.HeadIcon from Sys_APP a,Sys_User u where a.CreatorUserId=u.Id ";
return(DapperConnRead.Query <AppOutputDto, User, AppOutputDto>(query, (app, user) => { app.UserInfo = user; return app; }, null, splitOn: "Id").ToList <AppOutputDto>());
}
/// <summary>
/// 获取app对象
/// </summary>
/// <param name="appid">应用ID</param>
/// <returns></returns>
public APP GetAPP(string appid)
{
string sql = @"SELECT * FROM Sys_APP t WHERE t.AppId = @AppId and EnabledMark=1";
return(DapperConnRead.QueryFirstOrDefault <APP>(sql, new { AppId = appid }));
}