/// <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)); }