asp.net-N层代码示例
一、数据库Test,
表：
create table Customers
(
CustId int IDENTITY(1,1) primary key,
CustName varchar(20) not null,
Address varchar(50),
Linkman varchar(20)
)
//insert into Cusomers values(''ggg'',''xuzhou'',''zhangsan'');
二、配置文件web.config
<?xml version="1.0"?>
<configuration>
<appSettings/>
<connectionStrings>
<add name="TestConnectionString" connectionString="Data Source=GONGCHL;Initial Catalog=Test;Persist Security Info=True;User ID=sa;Password=123" providerName="System.Data.SqlClient"/>
</connectionStrings>
<system.web>
<compilation debug="true"/>
<authentication mode="Windows"/>
</system.web>
</configuration>
三、业务实体
1using System;
2using System.Collections.Generic;
3using System.Text;
4
5namespace com.Model
6{
7 /**//// <summary>
8 /// 业务实体CustomerInfo
9 /// </summary>
10 [Serializable]
11 public class CustomerInfo
12 {
13
14 /**//// <summary>
15 /// 默认的构造函数
16 /// </summary>
17 public CustomerInfo() {}
18
19 /**//// <summary>
20 /// 有参数的构造函数
21 /// </summary>
22 /// <param name="custId">客户号</param>
23 /// <param name="custName">客户名称</param>
24 /// <param name="address">客户地址</param>
25 /// <param name="linkman">联系人</param>
26 public CustomerInfo(int custId, string custName, string address, string linkman)
27 {
28
29 this.custId = custId;
30 this.custName = custName;
31 this.address = address;
32 this.linkman = linkman;
33 }
34 private int custId;
35 public int CustId
36 {
37 get { return custId; }
38 set { custId = value; }
39 }
40
41 private string custName;
42 public string CustName
43 {
44 get { return custName; }
45 set { custName = value; }
46 }
47
48 private string address;
49 public string Address
50 {
51 get { return address; }
52 set { address = value; }
53 }
54
55 private string linkman;
56 public string Linkman
57 {
58 get { return linkman; }
59 set { linkman = value; }
60 }
61 }
62}
63
四、数据访问层
类：SqlHelper(不多写)
类：Customer
1using System;
2using System.Data.SqlClient;
3using System.Data;
4using System.Text;
5using System.Collections.Generic;
6using com.Model;
7
8namespace com.DataAccess
9{
10 /**//// <summary>
11 /// 对客户表的所有数据访问操作
12 /// </summary>
13 public class Customer
14 {
15
16 //静态常量，参数名，T-SQL串
17 private const string SQL_SELECT_CUSTOMER_BY_ID =
18 "SELECT CustId, CustName, Address, Linkman FROM CUSTOMERS WHERE CustID = @CustId";
19 private const string SQL_SELECT_CUSTOMER_BY_NAME =
20 "SELECT CustId, CustName, Address, Linkman FROM CUSTOMERS WHERE CustName = @CustName";
21 private const string SQL_SELECT_CUSTOMER_BY_ALL =
22 "SELECT CustId, CustName, Address, Linkman FROM CUSTOMERS";
23 private const string SQL_UPDATE_CUSTOMER_BY_ID =
24 "UPDATE CUSTOMERS SET CustName=@CustName, Address=@Address, Linkman = @Linkman WHERE CustId=@CustId ";
25 private const string SQL_DELETE_CUSTOMER_BY_ID =
26 "DELETE CUSTOMERS WHERE CustId=@CustId ";
27 private const string SQL_INSERT_CUSTOMER =
28 "Declare @ID int;INSERT INTO CUSTOMERS VALUES(@CustName, @Address, @Linkman);SELECT @ID = @@IDENTITY; SELECT @ID";
29
30 private const string PARM_CUSTOMERID = "@CustId";
31 private const string PARM_CUSTOMERNAME = "@CustName";
32 private const string PARM_ADDRESS = "@Address";
33 private const string PARM_LINKMAN = "@Linkman";
34
35 /**//// <summary>
36 /// 按客户ID查询
37 /// </summary>
38 /// <param name="custId">客户号</param>
39 /// <returns>客户对象</returns>
40 public CustomerInfo GetCustomerById(int custId)
41 {
42 CustomerInfo customerInfo=null;
43 SqlParameter parm = new SqlParameter(PARM_CUSTOMERID, SqlDbType.Int);
44 parm.Value = custId;
45
46 //按客户号参数执行查询得到一个客户信息
47 using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SQL_SELECT_CUSTOMER_BY_ID, parm))
48 {
49 if (rdr.Read())
50 customerInfo = new CustomerInfo(rdr.GetInt32(0), rdr.GetString(1), rdr.GetString(2), rdr.GetString(3));
51 }
52 return customerInfo;
53 }
54
55 /**//// <summary>
56 /// 按客户名称查询
57 /// </summary>
58 /// <param name="custName">客户名称</param>
59 /// <returns>客户对象</returns>
60 public CustomerInfo GetCustomerByName(string custName)
61 {
62 CustomerInfo customerInfo = null;
63 SqlParameter parm = new SqlParameter(PARM_CUSTOMERNAME, SqlDbType.VarChar,20);
64 parm.Value = custName;
65
66 //按客户号参数执行查询得到一个客户信息
67 using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SQL_SELECT_CUSTOMER_BY_NAME, parm))
68 {
69 if (rdr.Read())
70 customerInfo = new CustomerInfo(rdr.GetInt32(0), rdr.GetString(1), rdr.GetString(2), rdr.GetString(3));
71 }
72 return customerInfo;
73 }
74
75 /**//// <summary>
76 /// 查询所有客户信息
77 /// 结果为IList
78 /// </summary>
79 /// <returns>一个客户集合</returns>
80 public IList<CustomerInfo> GetCusomersByAll()
81 {
82
83 IList<CustomerInfo> customers = new List<CustomerInfo>();
84
85 //Finally execute the query
86 using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SQL_SELECT_CUSTOMER_BY_ALL, null))
87 {
88 while (rdr.Read())
89 {
90 CustomerInfo customerInfo = new CustomerInfo(rdr.GetInt32(0), rdr.GetString(1), rdr.GetString(2), rdr.GetString(3));
91 customers.Add(customerInfo);
92 }
93 }
94
95 return customers;
96 }
97 /**//// <summary>
98 /// 插入一个客户信息
99 /// </summary>
100 /// <param name="customer">客户对象CustomerInfo</param>
101 /// <returns>bool类型,true or false</returns>
102 public bool InsertCustomer(CustomerInfo customerInfo)
103 {
104 SqlParameter[] paras = new SqlParameter[3];
105 paras[0]=new SqlParameter(PARM_CUSTOMERNAME,SqlDbType.VarChar,20);
106 paras[0].Value=customerInfo.CustName;
107 paras[1]=new SqlParameter(PARM_ADDRESS,SqlDbType.VarChar,50);
108 paras[1].Value=customerInfo.Address;
109 paras[2]=new SqlParameter(PARM_LINKMAN,SqlDbType.VarChar,20);
110 paras[2].Value=customerInfo.Linkman;
111
112 using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SQL_INSERT_CUSTOMER, paras))
113 {
114 if (rdr.Read())
115 customerInfo.CustId = rdr.GetInt32(0);
116 else
117 return false;
118 }
119 return true;
120 }
121
122 /**//// <summary>
123 /// 修改一个客户信息
124 /// </summary>
125 /// <param name="customer">客户对象CustomerInfo</param>
126 /// <returns>bool类型,true or false</returns>
127 public bool UpdateCustomerByID(CustomerInfo customerInfo)
128 {
129 SqlParameter[] paras = new SqlParameter[4];
130 paras[0] = new SqlParameter(PARM_CUSTOMERNAME, SqlDbType.VarChar, 20);
131 paras[0].Value = customerInfo.CustName;
132 paras[1] = new SqlParameter(PARM_ADDRESS, SqlDbType.VarChar, 50);
133 paras[1].Value = customerInfo.Address;
134 paras[2] = new SqlParameter(PARM_LINKMAN, SqlDbType.VarChar, 20);
135 paras[2].Value = customerInfo.Linkman;
136 paras[3] = new SqlParameter(PARM_CUSTOMERID, SqlDbType.Int);
137 paras[3].Value = customerInfo.CustId;
138
139 int row = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SQL_UPDATE_CUSTOMER_BY_ID, paras);
140 if (row == 0)
141 return false;
142 return true;
143 }
144
145 /**//// <summary>
146 /// 按ID删除一个客户信息
147 /// </summary>
148 /// <param name="custId">客户号</param>
149 /// <returns>bool类型,true or false</returns>
150 public bool DeleteCustomerByID(int custId)
151 {
152 SqlParameter para = new SqlParameter(PARM_CUSTOMERID, SqlDbType.Int);
153 para.Value = custId;
154
155 int row = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SQL_DELETE_CUSTOMER_BY_ID, para);
156 if (row == 0)
157 return false;
158 return true;
159 }
160
161 }
162}
五、业务逻辑层
1using System;
2using System.Collections.Generic;
3using System.Text;
4using com.DataAccess;
5using com.Model;
6using com.BusinessRule;
7
8namespace com.BusinessLogic
9{
10 public class CustomerLogic
11 {
12 /**//// <summary>
13 /// 插入一个客户信息
14 /// </summary>
15 /// <param name="custId">客户号</param>
16 /// <param name="custName">客户名称</param>
17 /// <param name="address">客户地址</param>
18 /// <param name="linkman">联系人</param>
19 /// <returns>bool类型,true or false</returns>
20 public bool InsertCustomer(int custId,string custName, string address, string linkman)
21 {
22 if (CustomerRule.IsExistCustomerName(custName))
23 return false;
24 Customer customer = new Customer();
25 CustomerInfo customerInfo = new CustomerInfo(custId,custName,address,linkman);
26 return customer.InsertCustomer(customerInfo);
27 }
28
29 /**//// <summary>
30 /// 插入一个客户信息
31 /// </summary>
32 /// <param name="custName">客户名称</param>
33 /// <param name="address">客户地址</param>
34 /// <param name="linkman">联系人</param>
35 /// <returns>bool类型,true or false</returns>
36 public bool InsertCustomer(string custName, string address, string linkman)
37 {
38 if (CustomerRule.IsExistCustomerName(custName))
39 return false;
40 Customer customer = new Customer();
41 CustomerInfo customerInfo = new CustomerInfo(0, custName, address, linkman);
42 return customer.InsertCustomer(customerInfo);
43 }
44
45 /**//// <summary>
46 /// 修改一个客户信息
47 /// </summary>
48 /// <param name="custId">客户号</param>
49 /// <param name="custName">客户名称</param>
50 /// <param name="address">客户地址</param>
51 /// <param name="linkman">联系人</param>
52 /// <returns>bool类型,true or false</returns>
53 public bool UpdateCustomer(int custId,string custName, string address, string linkman)
54 {
55 Customer customer = new Customer();
56 CustomerInfo customerInfo = new CustomerInfo(custId, custName, address, linkman);
57 return customer.UpdateCustomerByID(customerInfo);
58 }
59
60 /**//// <summary>
61 /// 按ID删除一个客户信息
62 /// </summary>
63 /// <param name="custId">客户号</param>
64 /// <returns>bool类型,true or false</returns>
65 public bool DeleteCustomerByID(int custId)
66 {
67 Customer customer = new Customer();
68 return customer.DeleteCustomerByID(custId);
69 }
70
71
72 /**//// <summary>
73 /// 查询所有客户信息
74 /// 结果为IList
75 /// </summary>
76 /// <returns>一个客户集合</returns>
77 public IList<CustomerInfo> GetCustomersByAll()
78 {
79 Customer customer = new Customer();
80 return customer.GetCusomersByAll();
81 }
82 }
83}
84
六、业务规则层
1using System;
2using System.Collections.Generic;
3using System.Text;
4using com.DataAccess;
5using com.Model;
6
7namespace com.BusinessRule
8{
9 /**//// <summary>
10 /// 检查客户信息的合法性
11 /// </summary>
12 public class CustomerRule
13 {
14 /**//// <summary>
15 /// 检查客户的名称是否已经存在
16 /// </summary>
17 /// <remarks>
18 /// e.g.:
19 /// bool exist =CustomerRule.IsExistCustomerName(custName);
20 /// </remarks>
21 /// <param name="custName">客户名称</param>
22 /// <returns>客户存在与否</returns>
23
24 public static bool IsExistCustomerName(string custName)
25 {
26 Customer cust = new Customer();
27 CustomerInfo custInfo = cust.GetCustomerByName(custName);
28 if (custInfo == null)
29 return false;
30 else
31 return true;
32 }
33 }
34}
35
七、业务外观层
1using System;
2using System.Collections.Generic;
3using System.Text;
4using System.Web.UI.WebControls;
5using com.BusinessLogic;
6using com.Model;
7
8namespace com.BusinessFacade
9{
10 /**//// <summary>
11 /// 为界面中Table处理数据
12 /// </summary>
13 public class CustomerTable
14 {
15 public static void SetTableData(Table table)
16 {
17 IList<CustomerInfo> list = new CustomerLogic().GetCustomersByAll();
18
19 AddRowHead(table);
20 foreach (CustomerInfo cust in list)
21 {
22 AddRow(table, cust);
23 }
24 }
25
26 private static void AddRowHead(Table table)
27 {
28 TableCell cell = new TableCell();
29 cell.Text = "Head";
30 TableRow row = new TableRow();
31 row.Cells.Add(cell);
32 table.Rows.Add(row);
33
34 }
35 private static void AddRow(Table table, CustomerInfo cust)
36 {
37 TableRow row = new TableRow();
38 TableCell cell1 = new TableCell();
39 cell1.Text = cust.CustId.ToString();
40 TableCell cell2 = new TableCell();
41 cell2.Text = cust.CustName;
42 TableCell cell3 = new TableCell();
43 cell3.Text = cust.Address;
44 TableCell cell4 = new TableCell();
45 cell4.Text = cust.Linkman;
46 row.Cells.Add(cell1);
47 row.Cells.Add(cell2);
48 row.Cells.Add(cell3);
49 row.Cells.Add(cell4);
50
51 table.Rows.Add(row);
52 }
53 }
54}
55
八、界面层
1<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
2
3<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
4
5<html xmlns="http://www.w3.org/1999/xhtml" >
6<head runat="server">
7 <title>无标题页</title>
8</head>
9<body>
10 <form id="form1" runat="server">
11 <div>
12 </div>
13 <asp:ObjectDataSource ID="ObjectDataSource1" runat="server"
14 InsertMethod="InsertCustomer" SelectMethod="GetCustomersByAll" TypeName="com.BusinessLogic.CustomerLogic" DeleteMethod="DeleteCustomerByID" UpdateMethod="UpdateCustomer">
15 <DeleteParameters>
16 <asp:ControlParameter ControlID="FormView1" PropertyName="SelectedValue" Name="custId" Type="Int32" />
17 </DeleteParameters>
18 <UpdateParameters>
19 <asp:Parameter Name="custId" Type="Int32" />
20 <asp:Parameter Name="custName" Type="String" />
21 <asp:Parameter Name="address" Type="String" />
22 <asp:Parameter Name="linkman" Type="String" />
23 </UpdateParameters>
24 <InsertParameters>
25 <asp:Parameter Name="custName" Type="String" />
26 <asp:Parameter Name="address" Type="String" />
27 <asp:Parameter Name="linkman" Type="String" />
28 </InsertParameters>
29 </asp:ObjectDataSource>
30 <asp:FormView ID="FormView1" runat="server" DataSourceID="ObjectDataSource1" AllowPaging="True" DataKeyNames="custId">
31 <EditItemTemplate>
32 CustName:
33 <asp:TextBox ID="CustNameTextBox" runat="server" Text=''<%# Bind("CustName") %>''></asp:TextBox><br />
34 Address:
35 <asp:TextBox ID="AddressTextBox" runat="server" Text=''<%# Bind("Address") %>''></asp:TextBox><br />
36 Linkman:
37 <asp:TextBox ID="LinkmanTextBox" runat="server" Text=''<%# Bind("Linkman") %>''></asp:TextBox><br />
38 CustId:
39 <asp:TextBox ID="CustIdTextBox" runat="server" BorderStyle="None" Enabled="False"
40 Text=''<%# Bind("CustId") %>''></asp:TextBox><br />
41 <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update"
42 Text="更新"></asp:LinkButton>
43 <asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
44 Text="取消"></asp:LinkButton>
45 </EditItemTemplate>
46 <InsertItemTemplate>
47 CustName:
48 <asp:TextBox ID="CustNameTextBox" runat="server" Text=''<%# Bind("CustName") %>''></asp:TextBox><br />
49 Address:
50 <asp:TextBox ID="AddressTextBox" runat="server" Text=''<%# Bind("Address") %>''></asp:TextBox><br />
51 Linkman:
52 <asp:TextBox ID="LinkmanTextBox" runat="server" Text=''<%# Bind("Linkman") %>''></asp:TextBox><br />
53 CustId:
54 <asp:TextBox ID="CustIdTextBox" runat="server" Text=''0'' Enabled="False"></asp:TextBox><br />
55 <asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert"
56 Text="插入"></asp:LinkButton>
57 <asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
58 Text="取消"></asp:LinkButton>
59 </InsertItemTemplate>
60 <ItemTemplate>
61 CustName:
62 <asp:Label ID="CustNameLabel" runat="server" Text=''<%# Bind("CustName") %>''></asp:Label><br />
63 Address:
64 <asp:Label ID="AddressLabel" runat="server" Text=''<%# Bind("Address") %>''></asp:Label><br />
65 Linkman:
66 <asp:Label ID="LinkmanLabel" runat="server" Text=''<%# Bind("Linkman") %>''></asp:Label><br />
67 CustId:
68 <asp:Label ID="CustIdLabel" runat="server" Enabled="False" Text=''<%# Bind("CustId") %>''></asp:Label><br />
69 <asp:LinkButton ID="EditButton" runat="server" CausesValidation="False" CommandName="Edit"
70 Text="编辑"></asp:LinkButton>
71 <asp:LinkButton ID="DeleteButton" runat="server" CausesValidation="False" CommandName="Delete"
72 Text="删除" ></asp:LinkButton>
73 <asp:LinkButton ID="NewButton" runat="server" CausesValidation="False" CommandName="New"
74 Text="新建"></asp:LinkButton>
75 </ItemTemplate>
76 </asp:FormView>
77 <asp:Table ID="Table1" runat="server">
78 </asp:Table>
79
80 </form>
81</body>
82</html>
文章出处：http://www.diybl.com/course/4_webprogram/asp.net/asp_netshl/200855/113955.html
浙公网安备 33010602011771号