roledal.cs

一个简单的网上书店

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using BLL;
using BLL.interfaces;
using Model;

namespace DAL
{
   public class RoleDal
    {
       public List<UserRoles> sel()
       {
           string sqlStr = "select * from userroles";
           List<UserRoles> list = new List<UserRoles>();
           using(SqlDataReader read=DBHelp.Sel(sqlStr))
           {
                while(read.Read())
                {
                    UserRoles role = new UserRoles();
                    role.Id=int.Parse(read["id"].ToString());
                    role.Name = read["name"].ToString();
                    list.Add(role);
                }
                return list;
           }
       }
    }
}