Project.Dal/UserMenuDal.cs

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

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

using System;
using System.Text;
using System.Collections.Generic;
using System.Data;
using System.Data.Common;
using System.Data.SqlClient;
using Project.Model;
using System.Data;
using Project.Common;


///========================================================================
/// Project: 权限系统	
/// Copyright: Copyright (c) 2007
/// Company: 
///========================================================================

namespace Project.Dal
{

	/// <summary>
	///Title: UserMenu类
	///Description: UserMenu表SQLServer数据库操作实现代码
	///@author xu
	///@version 1.0.0.0
	///@date 2012-9-21
	///@modify 
	///@date 
	/// </summary>
	public class UserMenuDal
	{		
		#region 数据库基本操作方法

        /// <summary>
        /// 获取顶级菜单列表
        /// </summary>
        /// <returns>顶级菜单列表</returns>
        public List<UserMenu> GetTopList()
        {
            List<UserMenu> list = new List<UserMenu>();
            string sql = "select * from UserMenu where ParentId=0 order by MenuOrder asc ";

            using (SqlDataReader dr = SQLHelper.ExecuteReader(SQLHelper.ConnectionString, CommandType.Text, sql, null))
            {
                while (dr.Read())
                {
                    UserMenu model = new UserMenu();
                    model.MenuId = dr.GetInt32(0);
                    model.MenuName = dr["MenuName"].ToString();
                    list.Add(model);
                }
            }
            return list;
        }

		/// <summary>
		/// 在dbo.UserMenu中新增一条记录,支持数据库事务
		/// </summary>
		/// <param name="model">包含被插入数据的实体对象</param>