DAL/MenuDAL.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using Model;
namespace DAL
{
   public  class MenuDAL
    {
       public static List<MenuMOD> selectOneList(int parentID)
       {
           SQLHelper sqh = new SQLHelper();
           SqlParameter[] para = new SqlParameter[] { new SqlParameter("@parentID", SqlDbType.Int) };
           para[0].Value = parentID;
           List<MenuMOD > muList = new List<MenuMOD>();

           SqlDataReader dr = null;
           try
           {
               dr = sqh.SqlExecuteReader(para, "Pro_getOneMenu");
               while (dr.Read())
               {
                   MenuMOD mumod = new MenuMOD();
                   mumod.MenuID = int.Parse(dr["menuID"].ToString());
                  mumod .Title = dr["title"].ToString();
                  mumod.LinkUrl = dr["linkUrl"].ToString();
                  muList .Add(mumod);
               }
              
               return muList;
           }
           catch (Exception ex)
           {
               throw ex;
           }
           finally
           {
               dr.Close(); 
               sqh.connClose();  
           }
       }
       public static List<MenuMOD> selectTwoList(int parentID)
       {
           SQLHelper sqh = new SQLHelper();
           SqlParameter[] para = new SqlParameter[] { new SqlParameter("@parentID", SqlDbType.Int) };
           para[0].Value = parentID;
           List<MenuMOD> muList = new List<MenuMOD>();

           SqlDataReader dr = null;
           try
           {
               dr = sqh.SqlExecuteReader(para, "Pro_getOneMenu");
               while (dr.Read())
               {
                   MenuMOD mumod = new MenuMOD();
                   mumod.MenuID = int.Parse(dr["menuID"].ToString());
                   mumod.Title = dr["title"].ToString();
                   mumod.LinkUrl = dr["linkUrl"].ToString();