.NET資料庫程式設計求索之路--5.使用ADO.NET實作（三層架構篇-使用List傳遞資料）（2）

5.使用ADO.NET實作（三層架構篇-使用List傳遞資料）（2）

5.3 業務邏輯層HomeShop.BLL

OrderBiz.cs

 1 using System;

 2 using System.Collections.Generic;

 3 using System.Linq;

 4 using System.Text;

 5 //新添命名空間

 6 using HomeShop.Model;

 7 using HomeShop.DAL;

 8 

 9 namespace HomeShop.BLL

10 {

11     public class OrderBiz

12     {

13         private OrderDAO dao;

14 

15         public OrderBiz()

16         {

17             dao = new OrderDAO();

18         }

19 

20         public OrderBiz(string connectionString)

21         {

22             dao = new OrderDAO(connectionString);

23         }

24 

25         public int Add(Order order)

26         {

27             return dao.Add(order);

28         }

29 

30         public int Update(Order order)

31         {

32             return dao.Update(order);

33         }

34 

35         public int Delete(int orderID)

36         {            

37             Order order = this.GetSingle(orderID);

38             return dao.Delete(order);

39         }

40 

41         public List<Order> GetList()

42         {

43             return dao.GetList(null,null);

44         }

45 

46         public List<Order> GetList(string customerName)

47         {

48             return GetList().FindAll(

49                 delegate(Order order)

50                 {

51                     return (order.CustomerName.IndexOf(customerName) >= 0);

52                 });

53         }

54 

55         public Order GetSingle(int orderID)

56         {

57             return GetList().Find(

58                 delegate(Order order)

59                 {

60                     return (order.OrderID == orderID);

61                 }

62                 );

63         }

64 

65     }

66 }

OrderStateBiz.cs

11     public class OrderStateBiz

13         private OrderStateDAO dao;

15         public OrderStateBiz()

17             dao = new OrderStateDAO();

20         public OrderStateBiz(string connectionString)

22             dao = new OrderStateDAO(connectionString);

25         public List<OrderState> GetList()

27             return dao.GetList(null, null);

29     }

30 }