class1.cs

.net三层结构的源码

using System;
using System.Data;
using System.Collections.Generic;
using System.Text;
using Model;
using DAL;
using IDal;
namespace BLL
{
    public class RoomOperation
    {
        public static List<Room> GetRooms()
        {
            IDAL dal = DBFactory.GetDB();
            DataSet ds = dal.SelectSQL("select id,name from room");
            List<Room> rooms = new List<Room>();
            foreach (DataRow row in ds.Tables[0].Rows)
            {
                Room r = new Room();
                r.RoomID = (int)row["id"];
                r.RoomName = row["name"].ToString();
                rooms.Add(r);
            }

            return rooms;
        }
    }
}