memberlevelservice.cs

个人版音像管理系统,可以扩展,内含数据库,支持多数据库使用

using System;
using System.Collections.Generic;
using System.Text;
using DiscSystemModel;
using DiscSystemIDAL;
using System.Data.SqlClient;
using System.Configuration;
using System.Data;

namespace DiscSystemDAL.SqlServer
{
    public class MemberLevelService:IMemberLevelService
    {
        private static string connStr = ConfigurationManager.ConnectionStrings["Sql"].ConnectionString;
        #region IMemberLevelService 成员

        public List<MemberLevel> SelectMemberLevel()
        {
            List<MemberLevel> list = new List<MemberLevel>();
            using (SqlConnection conn = new SqlConnection(connStr))
            {
                string cmdStr = "select * from MemberLevel";
                SqlCommand cmd = new SqlCommand(cmdStr, conn);
                conn.Open();
                using (SqlDataReader dr = cmd.ExecuteReader())
                {
                    while (dr.Read())
                    {
                        MemberLevel ml = new MemberLevel();
                        ml.LevelID = (int)dr["LevelID"];
                        ml.LevelName = (string)dr["LevelName"];
                        ml.DiscCount = (int)dr["DiscCount"];
                        list.Add(ml);
                    }
                }
            }
            return list;
        }

        #endregion
    }
}