32this.linkman=linkman;
33}
34privateintcustId;
35publicintCustId
36{
37get{returncustId;}
38set{custId=value;}
39}
40
41privatestringcustName;
42publicstringCustName
43{
44get{returncustName;}
45set{custName=value;}
46}
47
48privatestringaddress;
49publicstringAddress
50{
51get{returnaddress;}
52set{address=value;}
53}
54
55privatestringlinkman;
56publicstringLinkman
57{
58get{returnlinkman;}
59set{linkman=value;}
60}
61}
62}
63
四、数据访问层
类:SqlHelper(不多写)
类:Customer
1usingSystem;
2usingSystem.Data.SqlClient;
3usingSystem.Data;
4usingSystem.Text;
5usingSystem.Collections.Generic;
6usingcom.Model;
7
8namespacecom.DataAccess
9{
10/**////
11///对客户表的所有数据访问操作
12/// 13publicclassCustomer
14{
15
16//静态常量,参数名,T-SQL串
17privateconststringSQL_SELECT_CUSTOMER_BY_ID=
18"SELECTCustId,CustName,Address,LinkmanFROMCUSTOMERSWHERECustID=@CustId";
19privateconststringSQL_SELECT_CUSTOMER_BY_NAME=
20"SELECTCustId,CustName,Address,LinkmanFROMCUSTOMERSWHERECustName=@CustName";
21privateconststringSQL_SELECT_CUSTOMER_BY_ALL=
22"SELECTCustId,CustName,Address,LinkmanFROMCUSTOMERS";
23privateconststringSQL_UPDATE_CUSTOMER_BY_ID=
24"UPDATECUSTOMERSSETCustName=@CustName,Address=@Address,Linkman=@LinkmanWHERECustId=@CustId";