CodeSmith 4.0 Samples\DatabaseSchema\businessobject.cst,输入表名后生成一个用来操作表的类,但是这个类中用到了一个SqlService sql = new SqlService();,放到vs中提示找不到类型或命名空间名称“SqlService”(是否缺少 using 指令或程序集引用?),不知道怎么解决。求助。
代码如下:
1![](/Images/OutliningIndicators/ContractedBlock.gif)
title#region title
2![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
3
/// This object represents the properties and methods of a title.
4
/// </summary>
5
public class title
6![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
7
protected string _id;
8
protected string _title = String.Empty;
9
protected string _type = String.Empty;
10
protected string _pub_id = String.Empty;
11
protected decimal _price;
12
protected decimal _advance;
13
protected int _royalty;
14
protected int _ytd_sales;
15
protected string _notes = String.Empty;
16
protected DateTime _pubdate;
17
18
public title()
19![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
20
}
21
22
public title(string id)
23![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
24
SqlService sql = new SqlService();
25
sql.AddParameter("@title_id", SqlDbType.__UNKNOWN__tid, id);
26
SqlDataReader reader = sql.ExecuteSqlReader("SELECT * FROM titles WHERE title_id = '" + id.ToString() + "'");
27
28
if (reader.Read())
29![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
30
this.LoadFromReader(reader);
31
reader.Close();
32
}
33
else
34![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
35
if (!reader.IsClosed) reader.Close();
36
throw new ApplicationException("title does not exist.");
37
}
38
}
39
40
public title(SqlDataReader reader)
41![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
42
this.LoadFromReader(reader);
43
}
44
45
protected void LoadFromReader(SqlDataReader reader)
46![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
47
if (reader != null && !reader.IsClosed)
48![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
49
_id = reader.GetString(0);
50
if (!reader.IsDBNull(1)) _title = reader.GetString(1);
51
if (!reader.IsDBNull(2)) _type = reader.GetString(2);
52
if (!reader.IsDBNull(3)) _pub_id = reader.GetString(3);
53
if (!reader.IsDBNull(4)) _price = reader.GetDecimal(4);
54
if (!reader.IsDBNull(5)) _advance = reader.GetDecimal(5);
55
if (!reader.IsDBNull(6)) _royalty = reader.GetInt32(6);
56
if (!reader.IsDBNull(7)) _ytd_sales = reader.GetInt32(7);
57
if (!reader.IsDBNull(8)) _notes = reader.GetString(8);
58
if (!reader.IsDBNull(9)) _pubdate = reader.GetDateTime(9);
59
}
60
}
61
62![](/Images/OutliningIndicators/ContractedSubBlock.gif)
Public Properties#region Public Properties
63
public string Id
64![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
65![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
get
{return _id;}
66
}
67
68
public string title
69![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
70![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
get
{return _title;}
71![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
set
{_title = value;}
72
}
73![](/Images/OutliningIndicators/InBlock.gif)
74
public string type
75![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
76![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
get
{return _type;}
77![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
set
{_type = value;}
78
}
79![](/Images/OutliningIndicators/InBlock.gif)
80
public string pub_id
81![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
82![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
get
{return _pub_id;}
83![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
set
{_pub_id = value;}
84
}
85![](/Images/OutliningIndicators/InBlock.gif)
86
public decimal price
87![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
88![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
get
{return _price;}
89![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
set
{_price = value;}
90
}
91![](/Images/OutliningIndicators/InBlock.gif)
92
public decimal advance
93![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
94![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
get
{return _advance;}
95![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
set
{_advance = value;}
96
}
97![](/Images/OutliningIndicators/InBlock.gif)
98
public int royalty
99![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
100![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
get
{return _royalty;}
101![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
set
{_royalty = value;}
102
}
103![](/Images/OutliningIndicators/InBlock.gif)
104
public int ytd_sales
105![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
106![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
get
{return _ytd_sales;}
107![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
set
{_ytd_sales = value;}
108
}
109![](/Images/OutliningIndicators/InBlock.gif)
110
public string notes
111![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
112![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
get
{return _notes;}
113![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
set
{_notes = value;}
114
}
115![](/Images/OutliningIndicators/InBlock.gif)
116
public DateTime pubdate
117![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
118![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
get
{return _pubdate;}
119![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
set
{_pubdate = value;}
120
}
121
#endregion
122
123
public static title Gettitle(string id)
124![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
125
return new title(id);
126
}
127
}
128
#endregion
129![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/ContractedBlock.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
2
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
3
![](/Images/OutliningIndicators/InBlock.gif)
4
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
5
![](/Images/OutliningIndicators/InBlock.gif)
6
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
7
![](/Images/OutliningIndicators/InBlock.gif)
8
![](/Images/OutliningIndicators/InBlock.gif)
9
![](/Images/OutliningIndicators/InBlock.gif)
10
![](/Images/OutliningIndicators/InBlock.gif)
11
![](/Images/OutliningIndicators/InBlock.gif)
12
![](/Images/OutliningIndicators/InBlock.gif)
13
![](/Images/OutliningIndicators/InBlock.gif)
14
![](/Images/OutliningIndicators/InBlock.gif)
15
![](/Images/OutliningIndicators/InBlock.gif)
16
![](/Images/OutliningIndicators/InBlock.gif)
17
![](/Images/OutliningIndicators/InBlock.gif)
18
![](/Images/OutliningIndicators/InBlock.gif)
19
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
20
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
21
![](/Images/OutliningIndicators/InBlock.gif)
22
![](/Images/OutliningIndicators/InBlock.gif)
23
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
24
![](/Images/OutliningIndicators/InBlock.gif)
25
![](/Images/OutliningIndicators/InBlock.gif)
26
![](/Images/OutliningIndicators/InBlock.gif)
27
![](/Images/OutliningIndicators/InBlock.gif)
28
![](/Images/OutliningIndicators/InBlock.gif)
29
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
30
![](/Images/OutliningIndicators/InBlock.gif)
31
![](/Images/OutliningIndicators/InBlock.gif)
32
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
33
![](/Images/OutliningIndicators/InBlock.gif)
34
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
35
![](/Images/OutliningIndicators/InBlock.gif)
36
![](/Images/OutliningIndicators/InBlock.gif)
37
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
38
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
39
![](/Images/OutliningIndicators/InBlock.gif)
40
![](/Images/OutliningIndicators/InBlock.gif)
41
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
42
![](/Images/OutliningIndicators/InBlock.gif)
43
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
44
![](/Images/OutliningIndicators/InBlock.gif)
45
![](/Images/OutliningIndicators/InBlock.gif)
46
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
47
![](/Images/OutliningIndicators/InBlock.gif)
48
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
49
![](/Images/OutliningIndicators/InBlock.gif)
50
![](/Images/OutliningIndicators/InBlock.gif)
51
![](/Images/OutliningIndicators/InBlock.gif)
52
![](/Images/OutliningIndicators/InBlock.gif)
53
![](/Images/OutliningIndicators/InBlock.gif)
54
![](/Images/OutliningIndicators/InBlock.gif)
55
![](/Images/OutliningIndicators/InBlock.gif)
56
![](/Images/OutliningIndicators/InBlock.gif)
57
![](/Images/OutliningIndicators/InBlock.gif)
58
![](/Images/OutliningIndicators/InBlock.gif)
59
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
60
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
61
![](/Images/OutliningIndicators/InBlock.gif)
62
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
63
![](/Images/OutliningIndicators/InBlock.gif)
64
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
65
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
66
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
67
![](/Images/OutliningIndicators/InBlock.gif)
68
![](/Images/OutliningIndicators/InBlock.gif)
69
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
70
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
71
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
72
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
73
![](/Images/OutliningIndicators/InBlock.gif)
74
![](/Images/OutliningIndicators/InBlock.gif)
75
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
76
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
77
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
78
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
79
![](/Images/OutliningIndicators/InBlock.gif)
80
![](/Images/OutliningIndicators/InBlock.gif)
81
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
82
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
83
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
84
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
85
![](/Images/OutliningIndicators/InBlock.gif)
86
![](/Images/OutliningIndicators/InBlock.gif)
87
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
88
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
89
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
90
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
91
![](/Images/OutliningIndicators/InBlock.gif)
92
![](/Images/OutliningIndicators/InBlock.gif)
93
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
94
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
95
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
96
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
97
![](/Images/OutliningIndicators/InBlock.gif)
98
![](/Images/OutliningIndicators/InBlock.gif)
99
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
100
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
101
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
102
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
103
![](/Images/OutliningIndicators/InBlock.gif)
104
![](/Images/OutliningIndicators/InBlock.gif)
105
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
106
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
107
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
108
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
109
![](/Images/OutliningIndicators/InBlock.gif)
110
![](/Images/OutliningIndicators/InBlock.gif)
111
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
112
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
113
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
114
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
115
![](/Images/OutliningIndicators/InBlock.gif)
116
![](/Images/OutliningIndicators/InBlock.gif)
117
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
118
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
119
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
120
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
121
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
122
![](/Images/OutliningIndicators/InBlock.gif)
123
![](/Images/OutliningIndicators/InBlock.gif)
124
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
125
![](/Images/OutliningIndicators/InBlock.gif)
126
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
127
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
128
![](/Images/OutliningIndicators/ExpandedBlockEnd.gif)
129
![](/Images/OutliningIndicators/None.gif)