/// <summary>
/// 根据无级子级找顶级父级留言id
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public int GetParentMessageIdByChildId(int id)
{
var raw = WebExtension.GetDbContext <DataContext>().Database.SqlQuery <int>("exec sp_getParentMessageIdByChildId " + id);
if (raw.Any())
{
return(raw.FirstOrDefault());
}
return(0);
}
/// <summary>
/// 通过存储过程获得自己以及自己所有的子元素集合
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public DbRawSqlQuery <LeaveMessage> GetSelfAndAllChildrenMessagesByParentId(int id) => WebExtension.GetDbContext <DataContext>().Database.SqlQuery <LeaveMessage>("exec sp_getChildrenLeaveMsgByParentId " + id);
/// <summary>
/// 通过存储过程获得自己以及自己所有的子元素集合
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public DbRawSqlQuery <Comment> GetSelfAndAllChildrenCommentsByParentId(int id)
{
return(WebExtension.GetDbContext <DataContext>().Database.SqlQuery <Comment>("exec sp_getChildrenCommentByParentId " + id));
}
/// <summary>
/// 根据无级子级找顶级父级评论id
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public List <int> GetParentIdById(int id)
{
return(WebExtension.GetDbContext <DataContext>().Database.SqlQuery <int>("exec sp_getParentMenuIdByChildId " + id).ToList());
}
/// <summary>
/// 通过存储过程获得自己以及自己所有的子元素集合
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public DbRawSqlQuery <MenuOutputDto> GetSelfAndChildrenByParentId(int id)
{
return(WebExtension.GetDbContext <DataContext>().Database.SqlQuery <MenuOutputDto>("exec sp_getChildrenMenuByParentId " + id));
}
/// <summary>
/// 通过存储过程获得自己以及自己所有的子元素集合
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public DbRawSqlQuery <Menu> GetChildrenMenusByParentId(int id)
{
return(WebExtension.GetDbContext <DataContext>().Database.SqlQuery <Menu>("exec sp_getChildrenMenusByParentId " + id));
}
