数据库连接

username@email.com

2022-01-21 b18a7c8e54b51a5caa400e55cb8cc428c0301a0c

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using CY.Model;
using CY.IBaseDAL;
using System.Data;
 
namespace CY.IDAL
{
    /// <summary>
    /// 权限菜单表-数据库操作接口
    /// </summary>
    public interface ISys_Permissions_MenuDAL : ICommonDAL, IPaging<Sys_Permissions_Menu>, IGetAllModel<Sys_Permissions_Menu>
    {
        IEnumerable<Sys_Permissions_Menu> GetMenuByParentId(int parentId);
 
        /// <summary>
        /// 根据上级编号查询全部菜单
        /// </summary>
        /// <param name="ParentId">编号</param>
        /// <returns></returns>
        IEnumerable<Sys_Permissions_Menu> SelectListByParentId(int? ParentId);
 
        /// <summary>
        /// 查询全部菜单
        /// </summary>
        /// <returns></returns>
        DataTable SelectList();
 
        /// <summary>
        /// 根据编号查询单个信息
        /// </summary>
        /// <param name="Keyid">编号</param>
        /// <returns></returns>
        Sys_Permissions_Menu SelectModelByKeyId(int? KeyId);
 
        /// <summary>
        /// 根据上级编号查询单个信息
        /// </summary>
        /// <param name="ParentId">上级编号</param>
        /// <returns></returns>
        Sys_Permissions_Menu SelectModelByParentId(int? ParentId);
 
        /// <summary>
        /// 查询全部启用的菜单
        /// </summary>
        /// <returns></returns>
        DataTable SelectAllUsedList();
 
        /// <summary>
        /// 根据编号查询此菜单的一二三级
        /// </summary>
        /// <param name="MenuId">编号</param>
        /// <returns></returns>
        Sys_Permissions_Menu GetAllKeyidByMenuId(int? MenuId);
    }
}