SenBiTeSolution.DAL/t_Modules.cs

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

using System.Data;
using SenBiTeSolution.DBUtility;

namespace SenBiTeSolution.DAL
{
    public  class t_Modules
    {
        public t_Modules()
        { }

        /// <summary>
        /// 得到父级模块集合
        /// </summary>
        /// <returns></returns>
        public DataSet GetParentModules()
        {
            string strSql = "select * from t_Modules where parentId='0'";
            return DbHelperOleDb.Query(strSql);
        }

        //根据父级模块编号得到子级模块集合
        public DataSet GetChildModules(string parentId)
        {
            string strSql = "select * from t_Modules where parentId <>'0' and parentId='" + parentId + "'";
            return DbHelperOleDb.Query(strSql);
        }

    }
}