ADO.Net 精简的三层架构（初学者） IT_xiao小巫

1. Address),  
2.                     new SqlParameter("@TelNum", customer.TelNum),  
3.                     new SqlParameter("@CustLevel", customer.CustLevel));  
4.         }  
5.   
6.   
7.         /// <summary>  
8.         /// 查询所有数据  
9.         /// </summary>  
10.         /// <returns></returns>  
11.         public Customer[] GetAll()  
12.         {  
13.             DataTable table = SqlHelper.ExecuteDataTable("select * from T_Customer");  
14.             Customer[] customers = new Customer[table.Rows.Count];  
15.             for (int i = 0; i < table.Rows.Count; i++)  
16.             {  
17.                 DataRow row = table.Rows[i];  
18.                 customers[i] = ToCustomer(row);  
19.             }  
20.             return customers;  
21.         }  
22.   
23.     }  
24. }  

 

 

 

/DAL/SqlHelper.cs

[csharp]  view plain copy

1. using System;  
2. using System.Collections.Generic;  
3. using System.Linq;  
4. using System.Text;  
5. using System.Configuration;  
6. using System.Data.SqlClient;  
7. using System.Data;  
8.   
9. namespace ADOTest5.DAL  
10. {  
11.     static class SqlHelper  
12.     {  
13.         public static readonly string connstr = ConfigurationManager.ConnectionStrings["myconnstr"].ConnectionString;  
14.   
15.         public static int ExecuteNonQuery(string sql,  
16.             params SqlParameter[] parameters)  
17.         {  
18.             using (SqlConnection conn = new SqlConnection(connstr))  
19.             {  
20.                 conn.Open();  
21.                 using (SqlCommand cmd = conn.CreateCommand())  
22.                 {  
23.                     cmd.CommandText = sql;  
24.                     cmd.Parameters.AddRange(parameters);  
25.                     return cmd.ExecuteNonQuery();  
26.                 }  
27.             }  
28.         }  
29.   
30.         public static object ExecuteScalar(string sql,  
31.             params SqlParameter[] parameters)  
32.         {  
33.             using (SqlConnection conn = new SqlConnection(connstr))  
34.             {  
35.                 conn.Open();  
36.                 using (SqlCommand cmd = conn.CreateCommand())  
37.                 {  
38.                     cmd.CommandText = sql;  
39.                     cmd.Parameters.AddRange(parameters);  
40.                     return cmd.ExecuteScalar();  
41.                 }  
42.             }  
43.         }  
44.   
45.   
46.         public static DataTable ExecuteDataTable(string sql,  
47.             params SqlParameter[] parameters)  
48.         {  
49.             using (SqlConnection conn = new SqlConnection(connstr))  
50.             {  
51.                 conn.Open();  
52.                 using (SqlCommand cmd = conn.CreateCommand())  
53.                 {  
54.                     cmd.CommandText = sql;  
55.                     cmd.Parameters.AddRange(parameters);  
56.                     DataSet ds = new DataSet();  
57.                     SqlDataAdapter adapter = new SqlDataAdapter(cmd);  
58.                     adapter.Fill(ds);  
59.                     return ds.Tables[0];  
60.                 }  
61.             }  
62.         }  
63.   
64.         public static object FromDbValue(object value)  
65.         {  
66.             if (value == DBNull.Value)  
67.             {  
68.                 return null;  
69.             }  
70.             else  
71.             {  
72.                 return value;  
73.             }  
74.         }  
75.   
76.         public static object ToDbValue(object value)  
77.         {  
78.             if (value == null)  
79.             {  
80.                 return DBNull.Value;  
81.             }  
82.             else  
83.             {  
84.                 return value;  
85.             }  
86.         }  
87.     }  
88. }  

 

 

 

版权声明：本文为博主原创文章，未经博主允许不得转载。