CY_ZZJY.BO/Sys/SYS_MENU_BLL.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using CY_ZZJY.IService.Sys;
using CY_ZZJY.Model.Sys;
using CY_ZZJY.EasyUI;
using System.Data;

namespace CY_ZZJY.BO.Sys
{
    /// <summary>
    /// 系统菜单
    /// </summary>
    public class SYS_MENU_BLL : SYS_MENU_IService
    {
        /// <summary>
        /// 获取系统菜单
        /// </summary>
        /// <param name="menuId">菜单ID</param>
        /// <returns>菜单列表</returns>
        public Mdl_SYS_MENU GetMenu(string menuId)
        {
            string sql = string.Format("SELECT * FROM SYS_MENU WHERE ID='{0}' ", menuId);
            return this.GetModel(SQLDbHelper.Query(sql));
        }
        /// <summary>
        /// 获取系统菜单
        /// </summary>
        /// <param name="parentId">父节点ID</param>
        /// <returns>菜单列表</returns>
        public List<Mdl_SYS_MENU> ListSystemMenusByParentId(string parentId)
        {
            string sql = "SELECT * FROM SYS_MENU WHERE 1=1 AND IS_ENABLED='Y' ";
            sql += string.Format(" AND PARENT_ID='{0}' ", parentId);
            sql += " ORDER BY SROT ASC ";
            return this.GetModelList(SQLDbHelper.Query(sql));
        }
        /// <summary>
        /// 获取系统菜单
        /// </summary>
        /// <param name="ids">ids</param>
        /// <returns>菜单列表</returns>
        public List<Mdl_SYS_MENU> ListSystemMenusByIds(string ids)
        {
            string sql = string.Format("SELECT * FROM SYS_MENU WHERE 1=1  AND IS_ENABLED='Y' AND ID IN ({0}) ORDER BY SROT ASC  ", ids);
            return this.GetModelList(SQLDbHelper.Query(sql));
        }
        /// <summary>
        /// 根据参数获取数据集合
        /// </summary>
        /// <param name="pageIndex"></param>
        /// <param name="pageSize"></param>
        /// <returns></returns>
        public EasyUIGridResult Query(int pageIndex, int pageSize)
        {
            #region 业务sql语句
            string sql = "SELECT * FROM SYS_MENU WHERE 1=1 ";
            #endregion
            EasyUIGridResult result = new EasyUIGridResult();