classes.cs

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

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

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

        public static DataSet getClasses()
        {
            //Execute a query to read the categories
            DataSet ds = SqlHelper.ExecuteDataSet(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SQL_SELECT_CATEGORIES, null);
            
            return ds;
        }

        public static IList<ClassInfo> getClassesFanxing()
        {
            //泛型机制

            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;
        }
    }
}