classesjiekou.cs

采用多层开发模式,接口.静太工厂,sadfdsafsd

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using LiuJinfuTest.DBUtility;
using LiuJinfuTest.Model;
using LiuJinfuTest.IDAL;

namespace LiuJinfuTest.SQLServerDAL
{
    public class ClassesJieKou : IClasses
    {
        private const string SQL_SELECT_CATEGORIES = "SELECT CategoryId, Name, Descn FROM Category";

        public IList<ClassInfo> GetClasses()
        {
            IList<ClassInfo> categories = new List<ClassInfo>();

            //Execute a query to read the categories
            using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SQL_SELECT_CATEGORIES, null))
            {
                while (rdr.Read())
                {
                    ClassInfo cat = new ClassInfo(rdr.GetString(0), rdr.GetString(1), rdr.GetString(2));
                    categories.Add(cat);
                }
            }
            return categories;
        }

    }
}