初识三层架构(5)

37              DataRow row =dt.Rows[0];
38              Person person = new Person();
39              person.Id = (int)row["Id"];
40              person.Name = (string)row["Name"];
41              person.Age =Convert.ToInt32( row["Age"]);
42              return person;
43          }
44          else
45          {
46              throw new Exception("未知数据错误！");
47          }
48        }
49         public static IEnumerable<Person> GetAllPerson()
50         {
51             DataTable dt = SQLHelper.ExecuteDataTable("select * from T_Person");
52             List<Person> list = new List<Person>();
53             foreach (DataRow row in dt.Rows)
54             {
55                 Person person = new Person();
56                 person.Id = (int)row["Id"];
57                 person.Name = (string)row["Name"];
58                 person.Age = Convert.ToInt32(row["Age"]);
59                 list.Add(person);
60             }
61             return list;
62         }
63     }
64 }

  BLL
 1 using 三层架构.Model;
 2 using 三层架构.DAL;
 3 using System;
 4 using System.Collections;
 5 using System.Collections.Generic;
 6
 7 namespace 三层架构.BLL