1![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
/**//// <summary>
2![](/Images/OutliningIndicators/InBlock.gif)
3
/// Enterprise Library 2.0 数据访问进一步封装类
4![](/Images/OutliningIndicators/InBlock.gif)
5
/// Copyright (C) 2006-2008 LiTianPing
6![](/Images/OutliningIndicators/InBlock.gif)
7
/// All rights reserved
8![](/Images/OutliningIndicators/InBlock.gif)
9
/// </summary>
10![](/Images/OutliningIndicators/None.gif)
11
public abstract class DbHelperSQL2
12![](/Images/OutliningIndicators/None.gif)
13![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
{
14![](/Images/OutliningIndicators/InBlock.gif)
15
public DbHelperSQL2()
16![](/Images/OutliningIndicators/InBlock.gif)
17![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
18![](/Images/OutliningIndicators/InBlock.gif)
19
}
20![](/Images/OutliningIndicators/InBlock.gif)
21
22![](/Images/OutliningIndicators/InBlock.gif)
23![](/Images/OutliningIndicators/ContractedSubBlock.gif)
公用方法#region 公用方法
24![](/Images/OutliningIndicators/InBlock.gif)
25![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
26![](/Images/OutliningIndicators/InBlock.gif)
27
/// 获取表某个字段的最大值
28![](/Images/OutliningIndicators/InBlock.gif)
29
/// </summary>
30![](/Images/OutliningIndicators/InBlock.gif)
31
/// <param name="FieldName"></param>
32![](/Images/OutliningIndicators/InBlock.gif)
33
/// <param name="TableName"></param>
34![](/Images/OutliningIndicators/InBlock.gif)
35
/// <returns></returns>
36![](/Images/OutliningIndicators/InBlock.gif)
37
public static int GetMaxID(string FieldName,string TableName)
38![](/Images/OutliningIndicators/InBlock.gif)
39![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
40![](/Images/OutliningIndicators/InBlock.gif)
41
string strSql = "select max(" + FieldName + ")+1 from " + TableName;
42![](/Images/OutliningIndicators/InBlock.gif)
43
Database db = DatabaseFactory.CreateDatabase();
44![](/Images/OutliningIndicators/InBlock.gif)
45
DbCommand dbCommand = db.GetSqlStringCommand(strSql);
46![](/Images/OutliningIndicators/InBlock.gif)
47
object obj = db.ExecuteScalar(dbCommand);
48![](/Images/OutliningIndicators/InBlock.gif)
49
if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value)))
50![](/Images/OutliningIndicators/InBlock.gif)
51![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
52![](/Images/OutliningIndicators/InBlock.gif)
53
return 1;
54![](/Images/OutliningIndicators/InBlock.gif)
55
}
56![](/Images/OutliningIndicators/InBlock.gif)
57
else
58![](/Images/OutliningIndicators/InBlock.gif)
59![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
60![](/Images/OutliningIndicators/InBlock.gif)
61
return int.Parse(obj.ToString());
62![](/Images/OutliningIndicators/InBlock.gif)
63
}
64![](/Images/OutliningIndicators/InBlock.gif)
65
}
66![](/Images/OutliningIndicators/InBlock.gif)
67![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
68![](/Images/OutliningIndicators/InBlock.gif)
69
/// 检测一个记录是否存在(SQL语句方式)
70![](/Images/OutliningIndicators/InBlock.gif)
71
/// </summary>
72![](/Images/OutliningIndicators/InBlock.gif)
73
/// <param name="strSql"></param>
74![](/Images/OutliningIndicators/InBlock.gif)
75
/// <returns></returns>
76![](/Images/OutliningIndicators/InBlock.gif)
77
public static bool Exists(string strSql)
78![](/Images/OutliningIndicators/InBlock.gif)
79![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
80![](/Images/OutliningIndicators/InBlock.gif)
81
Database db = DatabaseFactory.CreateDatabase();
82![](/Images/OutliningIndicators/InBlock.gif)
83
DbCommand dbCommand = db.GetSqlStringCommand(strSql);
84![](/Images/OutliningIndicators/InBlock.gif)
85
object obj = db.ExecuteScalar(dbCommand);
86![](/Images/OutliningIndicators/InBlock.gif)
87
int cmdresult;
88![](/Images/OutliningIndicators/InBlock.gif)
89
if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value)))
90![](/Images/OutliningIndicators/InBlock.gif)
91![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
92![](/Images/OutliningIndicators/InBlock.gif)
93
cmdresult = 0;
94![](/Images/OutliningIndicators/InBlock.gif)
95
}
96![](/Images/OutliningIndicators/InBlock.gif)
97
else
98![](/Images/OutliningIndicators/InBlock.gif)
99![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
100![](/Images/OutliningIndicators/InBlock.gif)
101
cmdresult = int.Parse(obj.ToString());
102![](/Images/OutliningIndicators/InBlock.gif)
103
}
104![](/Images/OutliningIndicators/InBlock.gif)
105
if (cmdresult == 0)
106![](/Images/OutliningIndicators/InBlock.gif)
107![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
108![](/Images/OutliningIndicators/InBlock.gif)
109
return false;
110![](/Images/OutliningIndicators/InBlock.gif)
111
}
112![](/Images/OutliningIndicators/InBlock.gif)
113
else
114![](/Images/OutliningIndicators/InBlock.gif)
115![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
116![](/Images/OutliningIndicators/InBlock.gif)
117
return true;
118![](/Images/OutliningIndicators/InBlock.gif)
119
}
120![](/Images/OutliningIndicators/InBlock.gif)
121
}
122![](/Images/OutliningIndicators/InBlock.gif)
123![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
124![](/Images/OutliningIndicators/InBlock.gif)
125
/// 检测一个记录是否存在(SqlParameter语句方式)
126![](/Images/OutliningIndicators/InBlock.gif)
127
/// </summary>
128![](/Images/OutliningIndicators/InBlock.gif)
129
/// <param name="strSql"></param>
130![](/Images/OutliningIndicators/InBlock.gif)
131
/// <param name="cmdParms"></param>
132![](/Images/OutliningIndicators/InBlock.gif)
133
/// <returns></returns>
134![](/Images/OutliningIndicators/InBlock.gif)
135
public static bool Exists(string strSql, params SqlParameter[] cmdParms)
136![](/Images/OutliningIndicators/InBlock.gif)
137![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
138![](/Images/OutliningIndicators/InBlock.gif)
139
Database db = DatabaseFactory.CreateDatabase();
140![](/Images/OutliningIndicators/InBlock.gif)
141
DbCommand dbCommand = db.GetSqlStringCommand(strSql);
142![](/Images/OutliningIndicators/InBlock.gif)
143
BuildDBParameter(db, dbCommand, cmdParms);
144![](/Images/OutliningIndicators/InBlock.gif)
145
object obj = db.ExecuteScalar(dbCommand);
146![](/Images/OutliningIndicators/InBlock.gif)
147
int cmdresult;
148![](/Images/OutliningIndicators/InBlock.gif)
149
if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value)))
150![](/Images/OutliningIndicators/InBlock.gif)
151![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
152![](/Images/OutliningIndicators/InBlock.gif)
153
cmdresult = 0;
154![](/Images/OutliningIndicators/InBlock.gif)
155
}
156![](/Images/OutliningIndicators/InBlock.gif)
157
else
158![](/Images/OutliningIndicators/InBlock.gif)
159![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
160![](/Images/OutliningIndicators/InBlock.gif)
161
cmdresult = int.Parse(obj.ToString());
162![](/Images/OutliningIndicators/InBlock.gif)
163
}
164![](/Images/OutliningIndicators/InBlock.gif)
165
if (cmdresult == 0)
166![](/Images/OutliningIndicators/InBlock.gif)
167![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
168![](/Images/OutliningIndicators/InBlock.gif)
169
return false;
170![](/Images/OutliningIndicators/InBlock.gif)
171
}
172![](/Images/OutliningIndicators/InBlock.gif)
173
else
174![](/Images/OutliningIndicators/InBlock.gif)
175![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
176![](/Images/OutliningIndicators/InBlock.gif)
177
return true;
178![](/Images/OutliningIndicators/InBlock.gif)
179
}
180![](/Images/OutliningIndicators/InBlock.gif)
181
}
182![](/Images/OutliningIndicators/InBlock.gif)
183
184![](/Images/OutliningIndicators/InBlock.gif)
185![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
186![](/Images/OutliningIndicators/InBlock.gif)
187
/// 加载参数
188![](/Images/OutliningIndicators/InBlock.gif)
189
/// </summary>
190![](/Images/OutliningIndicators/InBlock.gif)
191
public static void BuildDBParameter(Database db, DbCommand dbCommand, params SqlParameter[] cmdParms)
192![](/Images/OutliningIndicators/InBlock.gif)
193![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
194![](/Images/OutliningIndicators/InBlock.gif)
195
foreach (SqlParameter sp in cmdParms)
196![](/Images/OutliningIndicators/InBlock.gif)
197![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
198![](/Images/OutliningIndicators/InBlock.gif)
199
db.AddInParameter(dbCommand, sp.ParameterName, sp.DbType,sp.Value);
200![](/Images/OutliningIndicators/InBlock.gif)
201
}
202![](/Images/OutliningIndicators/InBlock.gif)
203
}
204![](/Images/OutliningIndicators/InBlock.gif)
205
#endregion
206![](/Images/OutliningIndicators/InBlock.gif)
207
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/ContractedBlock.gif)
2
![](/Images/OutliningIndicators/InBlock.gif)
3
![](/Images/OutliningIndicators/InBlock.gif)
4
![](/Images/OutliningIndicators/InBlock.gif)
5
![](/Images/OutliningIndicators/InBlock.gif)
6
![](/Images/OutliningIndicators/InBlock.gif)
7
![](/Images/OutliningIndicators/InBlock.gif)
8
![](/Images/OutliningIndicators/InBlock.gif)
9
![](/Images/OutliningIndicators/ExpandedBlockEnd.gif)
10
![](/Images/OutliningIndicators/None.gif)
11
![](/Images/OutliningIndicators/None.gif)
12
![](/Images/OutliningIndicators/None.gif)
13
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/ContractedBlock.gif)
![](/Images/dot.gif)
14
![](/Images/OutliningIndicators/InBlock.gif)
15
![](/Images/OutliningIndicators/InBlock.gif)
16
![](/Images/OutliningIndicators/InBlock.gif)
17
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/dot.gif)
18
![](/Images/OutliningIndicators/InBlock.gif)
19
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
20
![](/Images/OutliningIndicators/InBlock.gif)
21
![](/Images/OutliningIndicators/InBlock.gif)
22
![](/Images/OutliningIndicators/InBlock.gif)
23
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
24
![](/Images/OutliningIndicators/InBlock.gif)
25
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
26
![](/Images/OutliningIndicators/InBlock.gif)
27
![](/Images/OutliningIndicators/InBlock.gif)
28
![](/Images/OutliningIndicators/InBlock.gif)
29
![](/Images/OutliningIndicators/InBlock.gif)
30
![](/Images/OutliningIndicators/InBlock.gif)
31
![](/Images/OutliningIndicators/InBlock.gif)
32
![](/Images/OutliningIndicators/InBlock.gif)
33
![](/Images/OutliningIndicators/InBlock.gif)
34
![](/Images/OutliningIndicators/InBlock.gif)
35
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
36
![](/Images/OutliningIndicators/InBlock.gif)
37
![](/Images/OutliningIndicators/InBlock.gif)
38
![](/Images/OutliningIndicators/InBlock.gif)
39
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/dot.gif)
40
![](/Images/OutliningIndicators/InBlock.gif)
41
![](/Images/OutliningIndicators/InBlock.gif)
42
![](/Images/OutliningIndicators/InBlock.gif)
43
![](/Images/OutliningIndicators/InBlock.gif)
44
![](/Images/OutliningIndicators/InBlock.gif)
45
![](/Images/OutliningIndicators/InBlock.gif)
46
![](/Images/OutliningIndicators/InBlock.gif)
47
![](/Images/OutliningIndicators/InBlock.gif)
48
![](/Images/OutliningIndicators/InBlock.gif)
49
![](/Images/OutliningIndicators/InBlock.gif)
50
![](/Images/OutliningIndicators/InBlock.gif)
51
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/dot.gif)
52
![](/Images/OutliningIndicators/InBlock.gif)
53
![](/Images/OutliningIndicators/InBlock.gif)
54
![](/Images/OutliningIndicators/InBlock.gif)
55
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
56
![](/Images/OutliningIndicators/InBlock.gif)
57
![](/Images/OutliningIndicators/InBlock.gif)
58
![](/Images/OutliningIndicators/InBlock.gif)
59
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/dot.gif)
60
![](/Images/OutliningIndicators/InBlock.gif)
61
![](/Images/OutliningIndicators/InBlock.gif)
62
![](/Images/OutliningIndicators/InBlock.gif)
63
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
64
![](/Images/OutliningIndicators/InBlock.gif)
65
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
66
![](/Images/OutliningIndicators/InBlock.gif)
67
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
68
![](/Images/OutliningIndicators/InBlock.gif)
69
![](/Images/OutliningIndicators/InBlock.gif)
70
![](/Images/OutliningIndicators/InBlock.gif)
71
![](/Images/OutliningIndicators/InBlock.gif)
72
![](/Images/OutliningIndicators/InBlock.gif)
73
![](/Images/OutliningIndicators/InBlock.gif)
74
![](/Images/OutliningIndicators/InBlock.gif)
75
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
76
![](/Images/OutliningIndicators/InBlock.gif)
77
![](/Images/OutliningIndicators/InBlock.gif)
78
![](/Images/OutliningIndicators/InBlock.gif)
79
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/dot.gif)
80
![](/Images/OutliningIndicators/InBlock.gif)
81
![](/Images/OutliningIndicators/InBlock.gif)
82
![](/Images/OutliningIndicators/InBlock.gif)
83
![](/Images/OutliningIndicators/InBlock.gif)
84
![](/Images/OutliningIndicators/InBlock.gif)
85
![](/Images/OutliningIndicators/InBlock.gif)
86
![](/Images/OutliningIndicators/InBlock.gif)
87
![](/Images/OutliningIndicators/InBlock.gif)
88
![](/Images/OutliningIndicators/InBlock.gif)
89
![](/Images/OutliningIndicators/InBlock.gif)
90
![](/Images/OutliningIndicators/InBlock.gif)
91
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/dot.gif)
92
![](/Images/OutliningIndicators/InBlock.gif)
93
![](/Images/OutliningIndicators/InBlock.gif)
94
![](/Images/OutliningIndicators/InBlock.gif)
95
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
96
![](/Images/OutliningIndicators/InBlock.gif)
97
![](/Images/OutliningIndicators/InBlock.gif)
98
![](/Images/OutliningIndicators/InBlock.gif)
99
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/dot.gif)
100
![](/Images/OutliningIndicators/InBlock.gif)
101
![](/Images/OutliningIndicators/InBlock.gif)
102
![](/Images/OutliningIndicators/InBlock.gif)
103
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
104
![](/Images/OutliningIndicators/InBlock.gif)
105
![](/Images/OutliningIndicators/InBlock.gif)
106
![](/Images/OutliningIndicators/InBlock.gif)
107
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/dot.gif)
108
![](/Images/OutliningIndicators/InBlock.gif)
109
![](/Images/OutliningIndicators/InBlock.gif)
110
![](/Images/OutliningIndicators/InBlock.gif)
111
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
112
![](/Images/OutliningIndicators/InBlock.gif)
113
![](/Images/OutliningIndicators/InBlock.gif)
114
![](/Images/OutliningIndicators/InBlock.gif)
115
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/dot.gif)
116
![](/Images/OutliningIndicators/InBlock.gif)
117
![](/Images/OutliningIndicators/InBlock.gif)
118
![](/Images/OutliningIndicators/InBlock.gif)
119
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
120
![](/Images/OutliningIndicators/InBlock.gif)
121
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
122
![](/Images/OutliningIndicators/InBlock.gif)
123
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
124
![](/Images/OutliningIndicators/InBlock.gif)
125
![](/Images/OutliningIndicators/InBlock.gif)
126
![](/Images/OutliningIndicators/InBlock.gif)
127
![](/Images/OutliningIndicators/InBlock.gif)
128
![](/Images/OutliningIndicators/InBlock.gif)
129
![](/Images/OutliningIndicators/InBlock.gif)
130
![](/Images/OutliningIndicators/InBlock.gif)
131
![](/Images/OutliningIndicators/InBlock.gif)
132
![](/Images/OutliningIndicators/InBlock.gif)
133
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
134
![](/Images/OutliningIndicators/InBlock.gif)
135
![](/Images/OutliningIndicators/InBlock.gif)
136
![](/Images/OutliningIndicators/InBlock.gif)
137
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/dot.gif)
138
![](/Images/OutliningIndicators/InBlock.gif)
139
![](/Images/OutliningIndicators/InBlock.gif)
140
![](/Images/OutliningIndicators/InBlock.gif)
141
![](/Images/OutliningIndicators/InBlock.gif)
142
![](/Images/OutliningIndicators/InBlock.gif)
143
![](/Images/OutliningIndicators/InBlock.gif)
144
![](/Images/OutliningIndicators/InBlock.gif)
145
![](/Images/OutliningIndicators/InBlock.gif)
146
![](/Images/OutliningIndicators/InBlock.gif)
147
![](/Images/OutliningIndicators/InBlock.gif)
148
![](/Images/OutliningIndicators/InBlock.gif)
149
![](/Images/OutliningIndicators/InBlock.gif)
150
![](/Images/OutliningIndicators/InBlock.gif)
151
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/dot.gif)
152
![](/Images/OutliningIndicators/InBlock.gif)
153
![](/Images/OutliningIndicators/InBlock.gif)
154
![](/Images/OutliningIndicators/InBlock.gif)
155
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
156
![](/Images/OutliningIndicators/InBlock.gif)
157
![](/Images/OutliningIndicators/InBlock.gif)
158
![](/Images/OutliningIndicators/InBlock.gif)
159
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/dot.gif)
160
![](/Images/OutliningIndicators/InBlock.gif)
161
![](/Images/OutliningIndicators/InBlock.gif)
162
![](/Images/OutliningIndicators/InBlock.gif)
163
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
164
![](/Images/OutliningIndicators/InBlock.gif)
165
![](/Images/OutliningIndicators/InBlock.gif)
166
![](/Images/OutliningIndicators/InBlock.gif)
167
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/dot.gif)
168
![](/Images/OutliningIndicators/InBlock.gif)
169
![](/Images/OutliningIndicators/InBlock.gif)
170
![](/Images/OutliningIndicators/InBlock.gif)
171
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
172
![](/Images/OutliningIndicators/InBlock.gif)
173
![](/Images/OutliningIndicators/InBlock.gif)
174
![](/Images/OutliningIndicators/InBlock.gif)
175
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/dot.gif)
176
![](/Images/OutliningIndicators/InBlock.gif)
177
![](/Images/OutliningIndicators/InBlock.gif)
178
![](/Images/OutliningIndicators/InBlock.gif)
179
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
180
![](/Images/OutliningIndicators/InBlock.gif)
181
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
182
![](/Images/OutliningIndicators/InBlock.gif)
183
![](/Images/OutliningIndicators/InBlock.gif)
184
![](/Images/OutliningIndicators/InBlock.gif)
185
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
186
![](/Images/OutliningIndicators/InBlock.gif)
187
![](/Images/OutliningIndicators/InBlock.gif)
188
![](/Images/OutliningIndicators/InBlock.gif)
189
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
190
![](/Images/OutliningIndicators/InBlock.gif)
191
![](/Images/OutliningIndicators/InBlock.gif)
192
![](/Images/OutliningIndicators/InBlock.gif)
193
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/dot.gif)
194
![](/Images/OutliningIndicators/InBlock.gif)
195
![](/Images/OutliningIndicators/InBlock.gif)
196
![](/Images/OutliningIndicators/InBlock.gif)
197
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/dot.gif)
198
![](/Images/OutliningIndicators/InBlock.gif)
199
![](/Images/OutliningIndicators/InBlock.gif)
200
![](/Images/OutliningIndicators/InBlock.gif)
201
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
202
![](/Images/OutliningIndicators/InBlock.gif)
203
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
204
![](/Images/OutliningIndicators/InBlock.gif)
205
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
206
![](/Images/OutliningIndicators/InBlock.gif)
207
![](/Images/OutliningIndicators/InBlock.gif)
1![](/Images/OutliningIndicators/ContractedBlock.gif)
执行简单SQL语句#region 执行简单SQL语句
2![](/Images/OutliningIndicators/InBlock.gif)
3
4![](/Images/OutliningIndicators/InBlock.gif)
5![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
6![](/Images/OutliningIndicators/InBlock.gif)
7
/// 执行SQL语句,返回影响的记录数
8![](/Images/OutliningIndicators/InBlock.gif)
9
/// </summary>
10![](/Images/OutliningIndicators/InBlock.gif)
11
/// <param name="strSql">SQL语句</param>
12![](/Images/OutliningIndicators/InBlock.gif)
13
/// <returns>影响的记录数</returns>
14![](/Images/OutliningIndicators/InBlock.gif)
15
public static int ExecuteSql(string strSql)
16![](/Images/OutliningIndicators/InBlock.gif)
17![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
18![](/Images/OutliningIndicators/InBlock.gif)
19
Database db = DatabaseFactory.CreateDatabase();
20![](/Images/OutliningIndicators/InBlock.gif)
21
DbCommand dbCommand = db.GetSqlStringCommand(strSql);
22![](/Images/OutliningIndicators/InBlock.gif)
23
return db.ExecuteNonQuery(dbCommand);
24![](/Images/OutliningIndicators/InBlock.gif)
25
}
26![](/Images/OutliningIndicators/InBlock.gif)
27![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
28![](/Images/OutliningIndicators/InBlock.gif)
29
/// 执行SQL语句,返回影响的记录数(对于长时间查询的语句,设置等待时间避免查询超时)
30![](/Images/OutliningIndicators/InBlock.gif)
31
/// </summary>
32![](/Images/OutliningIndicators/InBlock.gif)
33
/// <param name="strSql"></param>
34![](/Images/OutliningIndicators/InBlock.gif)
35
/// <param name="Times"></param>
36![](/Images/OutliningIndicators/InBlock.gif)
37
/// <returns></returns>
38![](/Images/OutliningIndicators/InBlock.gif)
39
public static int ExecuteSqlByTime(string strSql,int Times)
40![](/Images/OutliningIndicators/InBlock.gif)
41![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
42![](/Images/OutliningIndicators/InBlock.gif)
43
Database db = DatabaseFactory.CreateDatabase();
44![](/Images/OutliningIndicators/InBlock.gif)
45
DbCommand dbCommand = db.GetSqlStringCommand(strSql);
46![](/Images/OutliningIndicators/InBlock.gif)
47
dbCommand.CommandTimeout = Times;
48![](/Images/OutliningIndicators/InBlock.gif)
49
return db.ExecuteNonQuery(dbCommand);
50![](/Images/OutliningIndicators/InBlock.gif)
51
}
52![](/Images/OutliningIndicators/InBlock.gif)
53
54![](/Images/OutliningIndicators/InBlock.gif)
55![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
56![](/Images/OutliningIndicators/InBlock.gif)
57
/// 执行多条SQL语句,实现数据库事务。
58![](/Images/OutliningIndicators/InBlock.gif)
59
/// </summary>
60![](/Images/OutliningIndicators/InBlock.gif)
61
/// <param name="SQLStringList">多条SQL语句</param>
62![](/Images/OutliningIndicators/InBlock.gif)
63
public static void ExecuteSqlTran(ArrayList SQLStringList)
64![](/Images/OutliningIndicators/InBlock.gif)
65![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
66![](/Images/OutliningIndicators/InBlock.gif)
67
68![](/Images/OutliningIndicators/InBlock.gif)
69
Database db = DatabaseFactory.CreateDatabase();
70![](/Images/OutliningIndicators/InBlock.gif)
71
using (DbConnection dbconn = db.CreateConnection())
72![](/Images/OutliningIndicators/InBlock.gif)
73![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
74![](/Images/OutliningIndicators/InBlock.gif)
75
dbconn.Open();
76![](/Images/OutliningIndicators/InBlock.gif)
77
DbTransaction dbtran = dbconn.BeginTransaction();
78![](/Images/OutliningIndicators/InBlock.gif)
79
try
80![](/Images/OutliningIndicators/InBlock.gif)
81![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
82![](/Images/OutliningIndicators/InBlock.gif)
83
//执行语句
84![](/Images/OutliningIndicators/InBlock.gif)
85
for (int n = 0; n < SQLStringList.Count; n++)
86![](/Images/OutliningIndicators/InBlock.gif)
87![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
88![](/Images/OutliningIndicators/InBlock.gif)
89
string strsql = SQLStringList[n].ToString();
90![](/Images/OutliningIndicators/InBlock.gif)
91
if (strsql.Trim().Length > 1)
92![](/Images/OutliningIndicators/InBlock.gif)
93![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
94![](/Images/OutliningIndicators/InBlock.gif)
95
DbCommand dbCommand = db.GetSqlStringCommand(strsql);
96![](/Images/OutliningIndicators/InBlock.gif)
97
db.ExecuteNonQuery(dbCommand);
98![](/Images/OutliningIndicators/InBlock.gif)
99
}
100![](/Images/OutliningIndicators/InBlock.gif)
101
}
102![](/Images/OutliningIndicators/InBlock.gif)
103
//执行存储过程
104![](/Images/OutliningIndicators/InBlock.gif)
105
//db.ExecuteNonQuery(CommandType.StoredProcedure, "InserOrders");
106![](/Images/OutliningIndicators/InBlock.gif)
107
//db.ExecuteDataSet(CommandType.StoredProcedure, "UpdateProducts");
108![](/Images/OutliningIndicators/InBlock.gif)
109
dbtran.Commit();
110![](/Images/OutliningIndicators/InBlock.gif)
111
}
112![](/Images/OutliningIndicators/InBlock.gif)
113
catch
114![](/Images/OutliningIndicators/InBlock.gif)
115![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
116![](/Images/OutliningIndicators/InBlock.gif)
117
dbtran.Rollback();
118![](/Images/OutliningIndicators/InBlock.gif)
119
}
120![](/Images/OutliningIndicators/InBlock.gif)
121
finally
122![](/Images/OutliningIndicators/InBlock.gif)
123![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
124![](/Images/OutliningIndicators/InBlock.gif)
125
dbconn.Close();
126![](/Images/OutliningIndicators/InBlock.gif)
127
}
128![](/Images/OutliningIndicators/InBlock.gif)
129
}
130![](/Images/OutliningIndicators/InBlock.gif)
131
}
132![](/Images/OutliningIndicators/InBlock.gif)
133
134![](/Images/OutliningIndicators/InBlock.gif)
135![](/Images/OutliningIndicators/ContractedSubBlock.gif)
执行一个特殊字段带参数的语句#region 执行一个特殊字段带参数的语句
136![](/Images/OutliningIndicators/InBlock.gif)
137![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
138![](/Images/OutliningIndicators/InBlock.gif)
139
/// 执行带一个存储过程参数的的SQL语句。
140![](/Images/OutliningIndicators/InBlock.gif)
141
/// </summary>
142![](/Images/OutliningIndicators/InBlock.gif)
143
/// <param name="strSql">SQL语句</param>
144![](/Images/OutliningIndicators/InBlock.gif)
145
/// <param name="content">参数内容,比如一个字段是格式复杂的文章,有特殊符号,可以通过这个方式添加</param>
146![](/Images/OutliningIndicators/InBlock.gif)
147
/// <returns>影响的记录数</returns>
148![](/Images/OutliningIndicators/InBlock.gif)
149
public static int ExecuteSql(string strSql,string content)
150![](/Images/OutliningIndicators/InBlock.gif)
151![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
152![](/Images/OutliningIndicators/InBlock.gif)
153
Database db = DatabaseFactory.CreateDatabase();
154![](/Images/OutliningIndicators/InBlock.gif)
155
DbCommand dbCommand = db.GetSqlStringCommand(strSql);
156![](/Images/OutliningIndicators/InBlock.gif)
157
db.AddInParameter(dbCommand, "@content", DbType.String, content);
158![](/Images/OutliningIndicators/InBlock.gif)
159
return db.ExecuteNonQuery(dbCommand);
160![](/Images/OutliningIndicators/InBlock.gif)
161
}
162![](/Images/OutliningIndicators/InBlock.gif)
163
164![](/Images/OutliningIndicators/InBlock.gif)
165![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
166![](/Images/OutliningIndicators/InBlock.gif)
167
/// 执行带一个存储过程参数的的SQL语句。
168![](/Images/OutliningIndicators/InBlock.gif)
169
/// </summary>
170![](/Images/OutliningIndicators/InBlock.gif)
171
/// <param name="strSql">SQL语句</param>
172![](/Images/OutliningIndicators/InBlock.gif)
173
/// <param name="content">参数内容,比如一个字段是格式复杂的文章,有特殊符号,可以通过这个方式添加</param>
174![](/Images/OutliningIndicators/InBlock.gif)
175
/// <returns>返回语句里的查询结果</returns>
176![](/Images/OutliningIndicators/InBlock.gif)
177
public static object ExecuteSqlGet(string strSql,string content)
178![](/Images/OutliningIndicators/InBlock.gif)
179![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
180![](/Images/OutliningIndicators/InBlock.gif)
181
Database db = DatabaseFactory.CreateDatabase();
182![](/Images/OutliningIndicators/InBlock.gif)
183
DbCommand dbCommand = db.GetSqlStringCommand(strSql);
184![](/Images/OutliningIndicators/InBlock.gif)
185
db.AddInParameter(dbCommand, "@content", DbType.String, content);
186![](/Images/OutliningIndicators/InBlock.gif)
187
object obj = db.ExecuteNonQuery(dbCommand);
188![](/Images/OutliningIndicators/InBlock.gif)
189
if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value)))
190![](/Images/OutliningIndicators/InBlock.gif)
191![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
192![](/Images/OutliningIndicators/InBlock.gif)
193
return null;
194![](/Images/OutliningIndicators/InBlock.gif)
195
}
196![](/Images/OutliningIndicators/InBlock.gif)
197
else
198![](/Images/OutliningIndicators/InBlock.gif)
199![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
200![](/Images/OutliningIndicators/InBlock.gif)
201
return obj;
202![](/Images/OutliningIndicators/InBlock.gif)
203
}
204![](/Images/OutliningIndicators/InBlock.gif)
205
}
206![](/Images/OutliningIndicators/InBlock.gif)
207
208![](/Images/OutliningIndicators/InBlock.gif)
209![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
210![](/Images/OutliningIndicators/InBlock.gif)
211
/// 向数据库里插入图像格式的字段(和上面情况类似的另一种实例)
212![](/Images/OutliningIndicators/InBlock.gif)
213
/// </summary>
214![](/Images/OutliningIndicators/InBlock.gif)
215
/// <param name="strSql">SQL语句</param>
216![](/Images/OutliningIndicators/InBlock.gif)
217
/// <param name="fs">图像字节,数据库的字段类型为image的情况</param>
218![](/Images/OutliningIndicators/InBlock.gif)
219
/// <returns>影响的记录数</returns>
220![](/Images/OutliningIndicators/InBlock.gif)
221
public static int ExecuteSqlInsertImg(string strSql,byte[] fs)
222![](/Images/OutliningIndicators/InBlock.gif)
223![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
224![](/Images/OutliningIndicators/InBlock.gif)
225
Database db = DatabaseFactory.CreateDatabase();
226![](/Images/OutliningIndicators/InBlock.gif)
227
DbCommand dbCommand = db.GetSqlStringCommand(strSql);
228![](/Images/OutliningIndicators/InBlock.gif)
229
db.AddInParameter(dbCommand, "@fs", DbType.Byte, fs);
230![](/Images/OutliningIndicators/InBlock.gif)
231
return db.ExecuteNonQuery(dbCommand);
232![](/Images/OutliningIndicators/InBlock.gif)
233
}
234![](/Images/OutliningIndicators/InBlock.gif)
235
#endregion
236![](/Images/OutliningIndicators/InBlock.gif)
237![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/ContractedBlock.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
2
![](/Images/OutliningIndicators/InBlock.gif)
3
![](/Images/OutliningIndicators/InBlock.gif)
4
![](/Images/OutliningIndicators/InBlock.gif)
5
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
6
![](/Images/OutliningIndicators/InBlock.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/ExpandedSubBlockEnd.gif)
14
![](/Images/OutliningIndicators/InBlock.gif)
15
![](/Images/OutliningIndicators/InBlock.gif)
16
![](/Images/OutliningIndicators/InBlock.gif)
17
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/dot.gif)
18
![](/Images/OutliningIndicators/InBlock.gif)
19
![](/Images/OutliningIndicators/InBlock.gif)
20
![](/Images/OutliningIndicators/InBlock.gif)
21
![](/Images/OutliningIndicators/InBlock.gif)
22
![](/Images/OutliningIndicators/InBlock.gif)
23
![](/Images/OutliningIndicators/InBlock.gif)
24
![](/Images/OutliningIndicators/InBlock.gif)
25
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
26
![](/Images/OutliningIndicators/InBlock.gif)
27
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
28
![](/Images/OutliningIndicators/InBlock.gif)
29
![](/Images/OutliningIndicators/InBlock.gif)
30
![](/Images/OutliningIndicators/InBlock.gif)
31
![](/Images/OutliningIndicators/InBlock.gif)
32
![](/Images/OutliningIndicators/InBlock.gif)
33
![](/Images/OutliningIndicators/InBlock.gif)
34
![](/Images/OutliningIndicators/InBlock.gif)
35
![](/Images/OutliningIndicators/InBlock.gif)
36
![](/Images/OutliningIndicators/InBlock.gif)
37
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
38
![](/Images/OutliningIndicators/InBlock.gif)
39
![](/Images/OutliningIndicators/InBlock.gif)
40
![](/Images/OutliningIndicators/InBlock.gif)
41
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/dot.gif)
42
![](/Images/OutliningIndicators/InBlock.gif)
43
![](/Images/OutliningIndicators/InBlock.gif)
44
![](/Images/OutliningIndicators/InBlock.gif)
45
![](/Images/OutliningIndicators/InBlock.gif)
46
![](/Images/OutliningIndicators/InBlock.gif)
47
![](/Images/OutliningIndicators/InBlock.gif)
48
![](/Images/OutliningIndicators/InBlock.gif)
49
![](/Images/OutliningIndicators/InBlock.gif)
50
![](/Images/OutliningIndicators/InBlock.gif)
51
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
52
![](/Images/OutliningIndicators/InBlock.gif)
53
![](/Images/OutliningIndicators/InBlock.gif)
54
![](/Images/OutliningIndicators/InBlock.gif)
55
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
56
![](/Images/OutliningIndicators/InBlock.gif)
57
![](/Images/OutliningIndicators/InBlock.gif)
58
![](/Images/OutliningIndicators/InBlock.gif)
59
![](/Images/OutliningIndicators/InBlock.gif)
60
![](/Images/OutliningIndicators/InBlock.gif)
61
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
62
![](/Images/OutliningIndicators/InBlock.gif)
63
![](/Images/OutliningIndicators/InBlock.gif)
64
![](/Images/OutliningIndicators/InBlock.gif)
65
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/dot.gif)
66
![](/Images/OutliningIndicators/InBlock.gif)
67
![](/Images/OutliningIndicators/InBlock.gif)
68
![](/Images/OutliningIndicators/InBlock.gif)
69
![](/Images/OutliningIndicators/InBlock.gif)
70
![](/Images/OutliningIndicators/InBlock.gif)
71
![](/Images/OutliningIndicators/InBlock.gif)
72
![](/Images/OutliningIndicators/InBlock.gif)
73
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/dot.gif)
74
![](/Images/OutliningIndicators/InBlock.gif)
75
![](/Images/OutliningIndicators/InBlock.gif)
76
![](/Images/OutliningIndicators/InBlock.gif)
77
![](/Images/OutliningIndicators/InBlock.gif)
78
![](/Images/OutliningIndicators/InBlock.gif)
79
![](/Images/OutliningIndicators/InBlock.gif)
80
![](/Images/OutliningIndicators/InBlock.gif)
81
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/dot.gif)
82
![](/Images/OutliningIndicators/InBlock.gif)
83
![](/Images/OutliningIndicators/InBlock.gif)
84
![](/Images/OutliningIndicators/InBlock.gif)
85
![](/Images/OutliningIndicators/InBlock.gif)
86
![](/Images/OutliningIndicators/InBlock.gif)
87
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/dot.gif)
88
![](/Images/OutliningIndicators/InBlock.gif)
89
![](/Images/OutliningIndicators/InBlock.gif)
90
![](/Images/OutliningIndicators/InBlock.gif)
91
![](/Images/OutliningIndicators/InBlock.gif)
92
![](/Images/OutliningIndicators/InBlock.gif)
93
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/dot.gif)
94
![](/Images/OutliningIndicators/InBlock.gif)
95
![](/Images/OutliningIndicators/InBlock.gif)
96
![](/Images/OutliningIndicators/InBlock.gif)
97
![](/Images/OutliningIndicators/InBlock.gif)
98
![](/Images/OutliningIndicators/InBlock.gif)
99
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
100
![](/Images/OutliningIndicators/InBlock.gif)
101
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
102
![](/Images/OutliningIndicators/InBlock.gif)
103
![](/Images/OutliningIndicators/InBlock.gif)
104
![](/Images/OutliningIndicators/InBlock.gif)
105
![](/Images/OutliningIndicators/InBlock.gif)
106
![](/Images/OutliningIndicators/InBlock.gif)
107
![](/Images/OutliningIndicators/InBlock.gif)
108
![](/Images/OutliningIndicators/InBlock.gif)
109
![](/Images/OutliningIndicators/InBlock.gif)
110
![](/Images/OutliningIndicators/InBlock.gif)
111
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
112
![](/Images/OutliningIndicators/InBlock.gif)
113
![](/Images/OutliningIndicators/InBlock.gif)
114
![](/Images/OutliningIndicators/InBlock.gif)
115
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/dot.gif)
116
![](/Images/OutliningIndicators/InBlock.gif)
117
![](/Images/OutliningIndicators/InBlock.gif)
118
![](/Images/OutliningIndicators/InBlock.gif)
119
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
120
![](/Images/OutliningIndicators/InBlock.gif)
121
![](/Images/OutliningIndicators/InBlock.gif)
122
![](/Images/OutliningIndicators/InBlock.gif)
123
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/dot.gif)
124
![](/Images/OutliningIndicators/InBlock.gif)
125
![](/Images/OutliningIndicators/InBlock.gif)
126
![](/Images/OutliningIndicators/InBlock.gif)
127
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
128
![](/Images/OutliningIndicators/InBlock.gif)
129
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
130
![](/Images/OutliningIndicators/InBlock.gif)
131
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
132
![](/Images/OutliningIndicators/InBlock.gif)
133
![](/Images/OutliningIndicators/InBlock.gif)
134
![](/Images/OutliningIndicators/InBlock.gif)
135
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
136
![](/Images/OutliningIndicators/InBlock.gif)
137
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
138
![](/Images/OutliningIndicators/InBlock.gif)
139
![](/Images/OutliningIndicators/InBlock.gif)
140
![](/Images/OutliningIndicators/InBlock.gif)
141
![](/Images/OutliningIndicators/InBlock.gif)
142
![](/Images/OutliningIndicators/InBlock.gif)
143
![](/Images/OutliningIndicators/InBlock.gif)
144
![](/Images/OutliningIndicators/InBlock.gif)
145
![](/Images/OutliningIndicators/InBlock.gif)
146
![](/Images/OutliningIndicators/InBlock.gif)
147
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
148
![](/Images/OutliningIndicators/InBlock.gif)
149
![](/Images/OutliningIndicators/InBlock.gif)
150
![](/Images/OutliningIndicators/InBlock.gif)
151
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/dot.gif)
152
![](/Images/OutliningIndicators/InBlock.gif)
153
![](/Images/OutliningIndicators/InBlock.gif)
154
![](/Images/OutliningIndicators/InBlock.gif)
155
![](/Images/OutliningIndicators/InBlock.gif)
156
![](/Images/OutliningIndicators/InBlock.gif)
157
![](/Images/OutliningIndicators/InBlock.gif)
158
![](/Images/OutliningIndicators/InBlock.gif)
159
![](/Images/OutliningIndicators/InBlock.gif)
160
![](/Images/OutliningIndicators/InBlock.gif)
161
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
162
![](/Images/OutliningIndicators/InBlock.gif)
163
![](/Images/OutliningIndicators/InBlock.gif)
164
![](/Images/OutliningIndicators/InBlock.gif)
165
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
166
![](/Images/OutliningIndicators/InBlock.gif)
167
![](/Images/OutliningIndicators/InBlock.gif)
168
![](/Images/OutliningIndicators/InBlock.gif)
169
![](/Images/OutliningIndicators/InBlock.gif)
170
![](/Images/OutliningIndicators/InBlock.gif)
171
![](/Images/OutliningIndicators/InBlock.gif)
172
![](/Images/OutliningIndicators/InBlock.gif)
173
![](/Images/OutliningIndicators/InBlock.gif)
174
![](/Images/OutliningIndicators/InBlock.gif)
175
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
176
![](/Images/OutliningIndicators/InBlock.gif)
177
![](/Images/OutliningIndicators/InBlock.gif)
178
![](/Images/OutliningIndicators/InBlock.gif)
179
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/dot.gif)
180
![](/Images/OutliningIndicators/InBlock.gif)
181
![](/Images/OutliningIndicators/InBlock.gif)
182
![](/Images/OutliningIndicators/InBlock.gif)
183
![](/Images/OutliningIndicators/InBlock.gif)
184
![](/Images/OutliningIndicators/InBlock.gif)
185
![](/Images/OutliningIndicators/InBlock.gif)
186
![](/Images/OutliningIndicators/InBlock.gif)
187
![](/Images/OutliningIndicators/InBlock.gif)
188
![](/Images/OutliningIndicators/InBlock.gif)
189
![](/Images/OutliningIndicators/InBlock.gif)
190
![](/Images/OutliningIndicators/InBlock.gif)
191
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/dot.gif)
192
![](/Images/OutliningIndicators/InBlock.gif)
193
![](/Images/OutliningIndicators/InBlock.gif)
194
![](/Images/OutliningIndicators/InBlock.gif)
195
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
196
![](/Images/OutliningIndicators/InBlock.gif)
197
![](/Images/OutliningIndicators/InBlock.gif)
198
![](/Images/OutliningIndicators/InBlock.gif)
199
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/dot.gif)
200
![](/Images/OutliningIndicators/InBlock.gif)
201
![](/Images/OutliningIndicators/InBlock.gif)
202
![](/Images/OutliningIndicators/InBlock.gif)
203
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
204
![](/Images/OutliningIndicators/InBlock.gif)
205
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
206
![](/Images/OutliningIndicators/InBlock.gif)
207
![](/Images/OutliningIndicators/InBlock.gif)
208
![](/Images/OutliningIndicators/InBlock.gif)
209
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
210
![](/Images/OutliningIndicators/InBlock.gif)
211
![](/Images/OutliningIndicators/InBlock.gif)
212
![](/Images/OutliningIndicators/InBlock.gif)
213
![](/Images/OutliningIndicators/InBlock.gif)
214
![](/Images/OutliningIndicators/InBlock.gif)
215
![](/Images/OutliningIndicators/InBlock.gif)
216
![](/Images/OutliningIndicators/InBlock.gif)
217
![](/Images/OutliningIndicators/InBlock.gif)
218
![](/Images/OutliningIndicators/InBlock.gif)
219
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
220
![](/Images/OutliningIndicators/InBlock.gif)
221
![](/Images/OutliningIndicators/InBlock.gif)
222
![](/Images/OutliningIndicators/InBlock.gif)
223
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/dot.gif)
224
![](/Images/OutliningIndicators/InBlock.gif)
225
![](/Images/OutliningIndicators/InBlock.gif)
226
![](/Images/OutliningIndicators/InBlock.gif)
227
![](/Images/OutliningIndicators/InBlock.gif)
228
![](/Images/OutliningIndicators/InBlock.gif)
229
![](/Images/OutliningIndicators/InBlock.gif)
230
![](/Images/OutliningIndicators/InBlock.gif)
231
![](/Images/OutliningIndicators/InBlock.gif)
232
![](/Images/OutliningIndicators/InBlock.gif)
233
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
234
![](/Images/OutliningIndicators/InBlock.gif)
235
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
236
![](/Images/OutliningIndicators/InBlock.gif)
237
![](/Images/OutliningIndicators/InBlock.gif)
1![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
/**//// <summary>
2![](/Images/OutliningIndicators/InBlock.gif)
3
/// 执行一条计算查询结果语句,返回查询结果(object)。
4![](/Images/OutliningIndicators/InBlock.gif)
5
/// </summary>
6![](/Images/OutliningIndicators/InBlock.gif)
7
/// <param name="strSql">计算查询结果语句</param>
8![](/Images/OutliningIndicators/InBlock.gif)
9
/// <returns>查询结果(object)</returns>
10![](/Images/OutliningIndicators/None.gif)
11
public static object GetSingle(string strSql)
12![](/Images/OutliningIndicators/None.gif)
13![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
{
14![](/Images/OutliningIndicators/InBlock.gif)
15
Database db = DatabaseFactory.CreateDatabase();
16![](/Images/OutliningIndicators/InBlock.gif)
17
DbCommand dbCommand = db.GetSqlStringCommand(strSql);
18![](/Images/OutliningIndicators/InBlock.gif)
19
object obj = db.ExecuteScalar(dbCommand);
20![](/Images/OutliningIndicators/InBlock.gif)
21
if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value)))
22![](/Images/OutliningIndicators/InBlock.gif)
23![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
24![](/Images/OutliningIndicators/InBlock.gif)
25
return null;
26![](/Images/OutliningIndicators/InBlock.gif)
27
}
28![](/Images/OutliningIndicators/InBlock.gif)
29
else
30![](/Images/OutliningIndicators/InBlock.gif)
31![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
32![](/Images/OutliningIndicators/InBlock.gif)
33
return obj;
34![](/Images/OutliningIndicators/InBlock.gif)
35
}
36![](/Images/OutliningIndicators/InBlock.gif)
37
}
38![](/Images/OutliningIndicators/None.gif)
39
40![](/Images/OutliningIndicators/None.gif)
41![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
/**//// <summary>
42![](/Images/OutliningIndicators/InBlock.gif)
43
/// 执行查询语句,返回SqlDataReader ( 注意:使用后一定要对SqlDataReader进行Close )
44![](/Images/OutliningIndicators/InBlock.gif)
45
/// </summary>
46![](/Images/OutliningIndicators/InBlock.gif)
47
/// <param name="strSql">查询语句</param>
48![](/Images/OutliningIndicators/InBlock.gif)
49
/// <returns>SqlDataReader</returns>
50![](/Images/OutliningIndicators/None.gif)
51
public static SqlDataReader ExecuteReader(string strSql)
52![](/Images/OutliningIndicators/None.gif)
53![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
{
54![](/Images/OutliningIndicators/InBlock.gif)
55
Database db = DatabaseFactory.CreateDatabase();
56![](/Images/OutliningIndicators/InBlock.gif)
57
DbCommand dbCommand = db.GetSqlStringCommand(strSql);
58![](/Images/OutliningIndicators/InBlock.gif)
59
SqlDataReader dr = (SqlDataReader)db.ExecuteReader(dbCommand);
60![](/Images/OutliningIndicators/InBlock.gif)
61
return dr;
62![](/Images/OutliningIndicators/InBlock.gif)
63
64![](/Images/OutliningIndicators/InBlock.gif)
65
}
66![](/Images/OutliningIndicators/None.gif)
67
68![](/Images/OutliningIndicators/None.gif)
69![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
/**//// <summary>
70![](/Images/OutliningIndicators/InBlock.gif)
71
/// 执行查询语句,返回DataSet
72![](/Images/OutliningIndicators/InBlock.gif)
73
/// </summary>
74![](/Images/OutliningIndicators/InBlock.gif)
75
/// <param name="strSql">查询语句</param>
76![](/Images/OutliningIndicators/InBlock.gif)
77
/// <returns>DataSet</returns>
78![](/Images/OutliningIndicators/None.gif)
79
public static DataSet Query(string strSql)
80![](/Images/OutliningIndicators/None.gif)
81![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
{
82![](/Images/OutliningIndicators/InBlock.gif)
83
Database db = DatabaseFactory.CreateDatabase();
84![](/Images/OutliningIndicators/InBlock.gif)
85
DbCommand dbCommand = db.GetSqlStringCommand(strSql);
86![](/Images/OutliningIndicators/InBlock.gif)
87
return db.ExecuteDataSet(dbCommand);
88![](/Images/OutliningIndicators/InBlock.gif)
89
90![](/Images/OutliningIndicators/InBlock.gif)
91
}
92![](/Images/OutliningIndicators/None.gif)
93
//(对于长时间查询的语句,设置等待时间避免查询超时)
94![](/Images/OutliningIndicators/None.gif)
95
public static DataSet Query(string strSql,int Times)
96![](/Images/OutliningIndicators/None.gif)
97![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
{
98![](/Images/OutliningIndicators/InBlock.gif)
99
Database db = DatabaseFactory.CreateDatabase();
100![](/Images/OutliningIndicators/InBlock.gif)
101
DbCommand dbCommand = db.GetSqlStringCommand(strSql);
102![](/Images/OutliningIndicators/InBlock.gif)
103
dbCommand.CommandTimeout = Times;
104![](/Images/OutliningIndicators/InBlock.gif)
105
return db.ExecuteDataSet(dbCommand);
106![](/Images/OutliningIndicators/InBlock.gif)
107
}
108![](/Images/OutliningIndicators/None.gif)
109
110![](/Images/OutliningIndicators/None.gif)
111
#endregion
112![](/Images/OutliningIndicators/None.gif)
113
114![](/Images/OutliningIndicators/None.gif)
115![](/Images/OutliningIndicators/ContractedBlock.gif)
执行带参数的SQL语句#region 执行带参数的SQL语句
116![](/Images/OutliningIndicators/InBlock.gif)
117
118![](/Images/OutliningIndicators/InBlock.gif)
119![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
120![](/Images/OutliningIndicators/InBlock.gif)
121
/// 执行SQL语句,返回影响的记录数
122![](/Images/OutliningIndicators/InBlock.gif)
123
/// </summary>
124![](/Images/OutliningIndicators/InBlock.gif)
125
/// <param name="strSql">SQL语句</param>
126![](/Images/OutliningIndicators/InBlock.gif)
127
/// <returns>影响的记录数</returns>
128![](/Images/OutliningIndicators/InBlock.gif)
129
public static int ExecuteSql(string strSql,params SqlParameter[] cmdParms)
130![](/Images/OutliningIndicators/InBlock.gif)
131![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
132![](/Images/OutliningIndicators/InBlock.gif)
133
Database db = DatabaseFactory.CreateDatabase();
134![](/Images/OutliningIndicators/InBlock.gif)
135
DbCommand dbCommand = db.GetSqlStringCommand(strSql);
136![](/Images/OutliningIndicators/InBlock.gif)
137
BuildDBParameter(db, dbCommand, cmdParms);
138![](/Images/OutliningIndicators/InBlock.gif)
139
return db.ExecuteNonQuery(dbCommand);
140![](/Images/OutliningIndicators/InBlock.gif)
141
}
142![](/Images/OutliningIndicators/InBlock.gif)
143
144![](/Images/OutliningIndicators/InBlock.gif)
145
146![](/Images/OutliningIndicators/InBlock.gif)
147![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
148![](/Images/OutliningIndicators/InBlock.gif)
149
/// 执行多条SQL语句,实现数据库事务。
150![](/Images/OutliningIndicators/InBlock.gif)
151
/// </summary>
152![](/Images/OutliningIndicators/InBlock.gif)
153
/// <param name="SQLStringList">SQL语句的哈希表(key为sql语句,value是该语句的SqlParameter[])</param>
154![](/Images/OutliningIndicators/InBlock.gif)
155
public static void ExecuteSqlTran(Hashtable SQLStringList)
156![](/Images/OutliningIndicators/InBlock.gif)
157![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
158![](/Images/OutliningIndicators/InBlock.gif)
159
Database db = DatabaseFactory.CreateDatabase();
160![](/Images/OutliningIndicators/InBlock.gif)
161
using (DbConnection dbconn = db.CreateConnection())
162![](/Images/OutliningIndicators/InBlock.gif)
163![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
164![](/Images/OutliningIndicators/InBlock.gif)
165
dbconn.Open();
166![](/Images/OutliningIndicators/InBlock.gif)
167
DbTransaction dbtran = dbconn.BeginTransaction();
168![](/Images/OutliningIndicators/InBlock.gif)
169
try
170![](/Images/OutliningIndicators/InBlock.gif)
171![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
172![](/Images/OutliningIndicators/InBlock.gif)
173
//执行语句
174![](/Images/OutliningIndicators/InBlock.gif)
175
foreach (DictionaryEntry myDE in SQLStringList)
176![](/Images/OutliningIndicators/InBlock.gif)
177![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
178![](/Images/OutliningIndicators/InBlock.gif)
179
string strsql = myDE.Key.ToString();
180![](/Images/OutliningIndicators/InBlock.gif)
181
SqlParameter[] cmdParms = (SqlParameter[])myDE.Value;
182![](/Images/OutliningIndicators/InBlock.gif)
183
if (strsql.Trim().Length > 1)
184![](/Images/OutliningIndicators/InBlock.gif)
185![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
186![](/Images/OutliningIndicators/InBlock.gif)
187
DbCommand dbCommand = db.GetSqlStringCommand(strsql);
188![](/Images/OutliningIndicators/InBlock.gif)
189
BuildDBParameter(db, dbCommand, cmdParms);
190![](/Images/OutliningIndicators/InBlock.gif)
191
db.ExecuteNonQuery(dbCommand);
192![](/Images/OutliningIndicators/InBlock.gif)
193
}
194![](/Images/OutliningIndicators/InBlock.gif)
195
}
196![](/Images/OutliningIndicators/InBlock.gif)
197
dbtran.Commit();
198![](/Images/OutliningIndicators/InBlock.gif)
199
}
200![](/Images/OutliningIndicators/InBlock.gif)
201
catch
202![](/Images/OutliningIndicators/InBlock.gif)
203![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
204![](/Images/OutliningIndicators/InBlock.gif)
205
dbtran.Rollback();
206![](/Images/OutliningIndicators/InBlock.gif)
207
}
208![](/Images/OutliningIndicators/InBlock.gif)
209
finally
210![](/Images/OutliningIndicators/InBlock.gif)
211![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
212![](/Images/OutliningIndicators/InBlock.gif)
213
dbconn.Close();
214![](/Images/OutliningIndicators/InBlock.gif)
215
}
216![](/Images/OutliningIndicators/InBlock.gif)
217
}
218![](/Images/OutliningIndicators/InBlock.gif)
219
}
220![](/Images/OutliningIndicators/InBlock.gif)
221
222![](/Images/OutliningIndicators/InBlock.gif)
223
224![](/Images/OutliningIndicators/InBlock.gif)
225![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
226![](/Images/OutliningIndicators/InBlock.gif)
227
/// 执行一条计算查询结果语句,返回查询结果(object)。
228![](/Images/OutliningIndicators/InBlock.gif)
229
/// </summary>
230![](/Images/OutliningIndicators/InBlock.gif)
231
/// <param name="strSql">计算查询结果语句</param>
232![](/Images/OutliningIndicators/InBlock.gif)
233
/// <returns>查询结果(object)</returns>
234![](/Images/OutliningIndicators/InBlock.gif)
235
public static object GetSingle(string strSql,params SqlParameter[] cmdParms)
236![](/Images/OutliningIndicators/InBlock.gif)
237![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
238![](/Images/OutliningIndicators/InBlock.gif)
239
Database db = DatabaseFactory.CreateDatabase();
240![](/Images/OutliningIndicators/InBlock.gif)
241
DbCommand dbCommand = db.GetSqlStringCommand(strSql);
242![](/Images/OutliningIndicators/InBlock.gif)
243
BuildDBParameter(db, dbCommand, cmdParms);
244![](/Images/OutliningIndicators/InBlock.gif)
245
object obj = db.ExecuteScalar(dbCommand);
246![](/Images/OutliningIndicators/InBlock.gif)
247
if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value)))
248![](/Images/OutliningIndicators/InBlock.gif)
249![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
250![](/Images/OutliningIndicators/InBlock.gif)
251
return null;
252![](/Images/OutliningIndicators/InBlock.gif)
253
}
254![](/Images/OutliningIndicators/InBlock.gif)
255
else
256![](/Images/OutliningIndicators/InBlock.gif)
257![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
258![](/Images/OutliningIndicators/InBlock.gif)
259
return obj;
260![](/Images/OutliningIndicators/InBlock.gif)
261
}
262![](/Images/OutliningIndicators/InBlock.gif)
263
}
264![](/Images/OutliningIndicators/InBlock.gif)
265
266![](/Images/OutliningIndicators/InBlock.gif)
267![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
268![](/Images/OutliningIndicators/InBlock.gif)
269
/// 执行查询语句,返回SqlDataReader ( 注意:使用后一定要对SqlDataReader进行Close )
270![](/Images/OutliningIndicators/InBlock.gif)
271
/// </summary>
272![](/Images/OutliningIndicators/InBlock.gif)
273
/// <param name="strSql">查询语句</param>
274![](/Images/OutliningIndicators/InBlock.gif)
275
/// <returns>SqlDataReader</returns>
276![](/Images/OutliningIndicators/InBlock.gif)
277
public static SqlDataReader ExecuteReader(string strSql,params SqlParameter[] cmdParms)
278![](/Images/OutliningIndicators/InBlock.gif)
279![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
280![](/Images/OutliningIndicators/InBlock.gif)
281
Database db = DatabaseFactory.CreateDatabase();
282![](/Images/OutliningIndicators/InBlock.gif)
283
DbCommand dbCommand = db.GetSqlStringCommand(strSql);
284![](/Images/OutliningIndicators/InBlock.gif)
285
BuildDBParameter(db, dbCommand, cmdParms);
286![](/Images/OutliningIndicators/InBlock.gif)
287
SqlDataReader dr = (SqlDataReader)db.ExecuteReader(dbCommand);
288![](/Images/OutliningIndicators/InBlock.gif)
289
return dr;
290![](/Images/OutliningIndicators/InBlock.gif)
291
292![](/Images/OutliningIndicators/InBlock.gif)
293
}
294![](/Images/OutliningIndicators/InBlock.gif)
295
296![](/Images/OutliningIndicators/InBlock.gif)
297![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
298![](/Images/OutliningIndicators/InBlock.gif)
299
/// 执行查询语句,返回DataSet
300![](/Images/OutliningIndicators/InBlock.gif)
301
/// </summary>
302![](/Images/OutliningIndicators/InBlock.gif)
303
/// <param name="strSql">查询语句</param>
304![](/Images/OutliningIndicators/InBlock.gif)
305
/// <returns>DataSet</returns>
306![](/Images/OutliningIndicators/InBlock.gif)
307
public static DataSet Query(string strSql,params SqlParameter[] cmdParms)
308![](/Images/OutliningIndicators/InBlock.gif)
309![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
310![](/Images/OutliningIndicators/InBlock.gif)
311
Database db = DatabaseFactory.CreateDatabase();
312![](/Images/OutliningIndicators/InBlock.gif)
313
DbCommand dbCommand = db.GetSqlStringCommand(strSql);
314![](/Images/OutliningIndicators/InBlock.gif)
315
BuildDBParameter(db, dbCommand, cmdParms);
316![](/Images/OutliningIndicators/InBlock.gif)
317
return db.ExecuteDataSet(dbCommand);
318![](/Images/OutliningIndicators/InBlock.gif)
319
}
320![](/Images/OutliningIndicators/InBlock.gif)
321
322![](/Images/OutliningIndicators/InBlock.gif)
323
324![](/Images/OutliningIndicators/InBlock.gif)
325
private static void PrepareCommand(SqlCommand cmd,SqlConnection conn,SqlTransaction trans, string cmdText, SqlParameter[] cmdParms)
326![](/Images/OutliningIndicators/InBlock.gif)
327![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
328![](/Images/OutliningIndicators/InBlock.gif)
329
if (conn.State != ConnectionState.Open)
330![](/Images/OutliningIndicators/InBlock.gif)
331
conn.Open();
332![](/Images/OutliningIndicators/InBlock.gif)
333
cmd.Connection = conn;
334![](/Images/OutliningIndicators/InBlock.gif)
335
cmd.CommandText = cmdText;
336![](/Images/OutliningIndicators/InBlock.gif)
337
if (trans != null)
338![](/Images/OutliningIndicators/InBlock.gif)
339
cmd.Transaction = trans;
340![](/Images/OutliningIndicators/InBlock.gif)
341
cmd.CommandType = CommandType.Text;//cmdType;
342![](/Images/OutliningIndicators/InBlock.gif)
343
if (cmdParms != null)
344![](/Images/OutliningIndicators/InBlock.gif)
345![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
346![](/Images/OutliningIndicators/InBlock.gif)
347
foreach (SqlParameter parameter in cmdParms)
348![](/Images/OutliningIndicators/InBlock.gif)
349![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
350![](/Images/OutliningIndicators/InBlock.gif)
351
if ( ( parameter.Direction == ParameterDirection.InputOutput || parameter.Direction == ParameterDirection.Input ) &&
352![](/Images/OutliningIndicators/InBlock.gif)
353
(parameter.Value == null))
354![](/Images/OutliningIndicators/InBlock.gif)
355![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
356![](/Images/OutliningIndicators/InBlock.gif)
357
parameter.Value = DBNull.Value;
358![](/Images/OutliningIndicators/InBlock.gif)
359
}
360![](/Images/OutliningIndicators/InBlock.gif)
361
cmd.Parameters.Add(parameter);
362![](/Images/OutliningIndicators/InBlock.gif)
363
}
364![](/Images/OutliningIndicators/InBlock.gif)
365
}
366![](/Images/OutliningIndicators/InBlock.gif)
367
}
368![](/Images/OutliningIndicators/InBlock.gif)
369
370![](/Images/OutliningIndicators/InBlock.gif)
371
#endregion
372![](/Images/OutliningIndicators/None.gif)
373
374![](/Images/OutliningIndicators/None.gif)
375![](/Images/OutliningIndicators/ContractedBlock.gif)
存储过程操作#region 存储过程操作
376![](/Images/OutliningIndicators/InBlock.gif)
377
378![](/Images/OutliningIndicators/InBlock.gif)
379![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
380![](/Images/OutliningIndicators/InBlock.gif)
381
/// 执行存储过程,返回影响的行数
382![](/Images/OutliningIndicators/InBlock.gif)
383
/// </summary>
384![](/Images/OutliningIndicators/InBlock.gif)
385
public static int RunProcedure(string storedProcName)
386![](/Images/OutliningIndicators/InBlock.gif)
387![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
388![](/Images/OutliningIndicators/InBlock.gif)
389
Database db = DatabaseFactory.CreateDatabase();
390![](/Images/OutliningIndicators/InBlock.gif)
391
DbCommand dbCommand = db.GetStoredProcCommand(storedProcName);
392![](/Images/OutliningIndicators/InBlock.gif)
393
return db.ExecuteNonQuery(dbCommand);
394![](/Images/OutliningIndicators/InBlock.gif)
395
}
396![](/Images/OutliningIndicators/InBlock.gif)
397
398![](/Images/OutliningIndicators/InBlock.gif)
399![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
400![](/Images/OutliningIndicators/InBlock.gif)
401
/// 执行存储过程,返回输出参数的值和影响的行数
402![](/Images/OutliningIndicators/InBlock.gif)
403
/// </summary>
404![](/Images/OutliningIndicators/InBlock.gif)
405
/// <param name="storedProcName">存储过程名</param>
406![](/Images/OutliningIndicators/InBlock.gif)
407
/// <param name="parameters">存储过程参数</param>
408![](/Images/OutliningIndicators/InBlock.gif)
409
/// <param name="OutParameter">输出参数名称</param>
410![](/Images/OutliningIndicators/InBlock.gif)
411
/// <param name="rowsAffected">影响的行数</param>
412![](/Images/OutliningIndicators/InBlock.gif)
413
/// <returns></returns>
414![](/Images/OutliningIndicators/InBlock.gif)
415
public static object RunProcedure(string storedProcName, IDataParameter[] InParameters, SqlParameter OutParameter, int rowsAffected)
416![](/Images/OutliningIndicators/InBlock.gif)
417![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
418![](/Images/OutliningIndicators/InBlock.gif)
419
Database db = DatabaseFactory.CreateDatabase();
420![](/Images/OutliningIndicators/InBlock.gif)
421
DbCommand dbCommand = db.GetStoredProcCommand(storedProcName);
422![](/Images/OutliningIndicators/InBlock.gif)
423
BuildDBParameter(db, dbCommand, (SqlParameter[])InParameters);
424![](/Images/OutliningIndicators/InBlock.gif)
425
db.AddOutParameter(dbCommand, OutParameter.ParameterName, OutParameter.DbType, OutParameter.Size);
426![](/Images/OutliningIndicators/InBlock.gif)
427
rowsAffected = db.ExecuteNonQuery(dbCommand);
428![](/Images/OutliningIndicators/InBlock.gif)
429
return db.GetParameterValue(dbCommand,"@" + OutParameter.ParameterName); //得到输出参数的值
430![](/Images/OutliningIndicators/InBlock.gif)
431
}
432![](/Images/OutliningIndicators/InBlock.gif)
433
434![](/Images/OutliningIndicators/InBlock.gif)
435![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
436![](/Images/OutliningIndicators/InBlock.gif)
437
/// 执行存储过程,返回SqlDataReader ( 注意:使用后一定要对SqlDataReader进行Close )
438![](/Images/OutliningIndicators/InBlock.gif)
439
/// </summary>
440![](/Images/OutliningIndicators/InBlock.gif)
441
/// <param name="storedProcName">存储过程名</param>
442![](/Images/OutliningIndicators/InBlock.gif)
443
/// <param name="parameters">存储过程参数</param>
444![](/Images/OutliningIndicators/InBlock.gif)
445
/// <returns>SqlDataReader</returns>
446![](/Images/OutliningIndicators/InBlock.gif)
447
public static SqlDataReader RunProcedure(string storedProcName, IDataParameter[] parameters )
448![](/Images/OutliningIndicators/InBlock.gif)
449![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
450![](/Images/OutliningIndicators/InBlock.gif)
451
Database db = DatabaseFactory.CreateDatabase();
452![](/Images/OutliningIndicators/InBlock.gif)
453
DbCommand dbCommand = db.GetStoredProcCommand(storedProcName, parameters);
454![](/Images/OutliningIndicators/InBlock.gif)
455
//BuildDBParameter(db, dbCommand, parameters);
456![](/Images/OutliningIndicators/InBlock.gif)
457
return (SqlDataReader)db.ExecuteReader(dbCommand);
458![](/Images/OutliningIndicators/InBlock.gif)
459
}
460![](/Images/OutliningIndicators/InBlock.gif)
461
462![](/Images/OutliningIndicators/InBlock.gif)
463![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
464![](/Images/OutliningIndicators/InBlock.gif)
465
/// 执行存储过程,返回DataSet
466![](/Images/OutliningIndicators/InBlock.gif)
467
/// </summary>
468![](/Images/OutliningIndicators/InBlock.gif)
469
/// <param name="storedProcName">存储过程名</param>
470![](/Images/OutliningIndicators/InBlock.gif)
471
/// <param name="parameters">存储过程参数</param>
472![](/Images/OutliningIndicators/InBlock.gif)
473
/// <param name="tableName">DataSet结果中的表名</param>
474![](/Images/OutliningIndicators/InBlock.gif)
475
/// <returns>DataSet</returns>
476![](/Images/OutliningIndicators/InBlock.gif)
477
public static DataSet RunProcedure(string storedProcName, IDataParameter[] parameters, string tableName )
478![](/Images/OutliningIndicators/InBlock.gif)
479![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
480![](/Images/OutliningIndicators/InBlock.gif)
481
Database db = DatabaseFactory.CreateDatabase();
482![](/Images/OutliningIndicators/InBlock.gif)
483
DbCommand dbCommand = db.GetStoredProcCommand(storedProcName, parameters);
484![](/Images/OutliningIndicators/InBlock.gif)
485
//BuildDBParameter(db, dbCommand, parameters);
486![](/Images/OutliningIndicators/InBlock.gif)
487
return db.ExecuteDataSet(dbCommand);
488![](/Images/OutliningIndicators/InBlock.gif)
489
}
490![](/Images/OutliningIndicators/InBlock.gif)
491![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
492![](/Images/OutliningIndicators/InBlock.gif)
493
/// 执行存储过程,返回DataSet(设定等待时间)
494![](/Images/OutliningIndicators/InBlock.gif)
495
/// </summary>
496![](/Images/OutliningIndicators/InBlock.gif)
497
public static DataSet RunProcedure(string storedProcName, IDataParameter[] parameters, string tableName ,int Times)
498![](/Images/OutliningIndicators/InBlock.gif)
499![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
500![](/Images/OutliningIndicators/InBlock.gif)
501
Database db = DatabaseFactory.CreateDatabase();
502![](/Images/OutliningIndicators/InBlock.gif)
503
DbCommand dbCommand = db.GetStoredProcCommand(storedProcName, parameters);
504![](/Images/OutliningIndicators/InBlock.gif)
505
dbCommand.CommandTimeout = Times;
506![](/Images/OutliningIndicators/InBlock.gif)
507
//BuildDBParameter(db, dbCommand, parameters);
508![](/Images/OutliningIndicators/InBlock.gif)
509
return db.ExecuteDataSet(dbCommand);
510![](/Images/OutliningIndicators/InBlock.gif)
511
}
512![](/Images/OutliningIndicators/InBlock.gif)
513
514![](/Images/OutliningIndicators/InBlock.gif)
515
516![](/Images/OutliningIndicators/InBlock.gif)
517![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
518![](/Images/OutliningIndicators/InBlock.gif)
519
/// 构建SqlCommand 对象(用来返回一个结果集,而不是一个整数值)
520![](/Images/OutliningIndicators/InBlock.gif)
521
/// </summary>
522![](/Images/OutliningIndicators/InBlock.gif)
523
/// <param name="connection">数据库连接</param>
524![](/Images/OutliningIndicators/InBlock.gif)
525
/// <param name="storedProcName">存储过程名</param>
526![](/Images/OutliningIndicators/InBlock.gif)
527
/// <param name="parameters">存储过程参数</param>
528![](/Images/OutliningIndicators/InBlock.gif)
529
/// <returns>SqlCommand</returns>
530![](/Images/OutliningIndicators/InBlock.gif)
531
private static SqlCommand BuildQueryCommand(SqlConnection connection,string storedProcName, IDataParameter[] parameters)
532![](/Images/OutliningIndicators/InBlock.gif)
533![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
534![](/Images/OutliningIndicators/InBlock.gif)
535
SqlCommand command = new SqlCommand( storedProcName, connection );
536![](/Images/OutliningIndicators/InBlock.gif)
537
command.CommandType = CommandType.StoredProcedure;
538![](/Images/OutliningIndicators/InBlock.gif)
539
foreach (SqlParameter parameter in parameters)
540![](/Images/OutliningIndicators/InBlock.gif)
541![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
542![](/Images/OutliningIndicators/InBlock.gif)
543
if( parameter != null )
544![](/Images/OutliningIndicators/InBlock.gif)
545![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
546![](/Images/OutliningIndicators/InBlock.gif)
547
// 检查未分配值的输出参数,将其分配以DBNull.Value.
548![](/Images/OutliningIndicators/InBlock.gif)
549
if ( ( parameter.Direction == ParameterDirection.InputOutput || parameter.Direction == ParameterDirection.Input ) &&
550![](/Images/OutliningIndicators/InBlock.gif)
551
(parameter.Value == null))
552![](/Images/OutliningIndicators/InBlock.gif)
553![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
554![](/Images/OutliningIndicators/InBlock.gif)
555
parameter.Value = DBNull.Value;
556![](/Images/OutliningIndicators/InBlock.gif)
557
}
558![](/Images/OutliningIndicators/InBlock.gif)
559
command.Parameters.Add(parameter);
560![](/Images/OutliningIndicators/InBlock.gif)
561
}
562![](/Images/OutliningIndicators/InBlock.gif)
563
}
564![](/Images/OutliningIndicators/InBlock.gif)
565
return command;
566![](/Images/OutliningIndicators/InBlock.gif)
567
}
568![](/Images/OutliningIndicators/InBlock.gif)
569![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
/**//// <summary>
570![](/Images/OutliningIndicators/InBlock.gif)
571
/// 创建SqlCommand 对象实例(用来返回一个整数值)
572![](/Images/OutliningIndicators/InBlock.gif)
573
/// </summary>
574![](/Images/OutliningIndicators/InBlock.gif)
575
/// <param name="storedProcName">存储过程名</param>
576![](/Images/OutliningIndicators/InBlock.gif)
577
/// <param name="parameters">存储过程参数</param>
578![](/Images/OutliningIndicators/InBlock.gif)
579
/// <returns>SqlCommand 对象实例</returns>
580![](/Images/OutliningIndicators/InBlock.gif)
581
private static SqlCommand BuildIntCommand(SqlConnection connection,string storedProcName, IDataParameter[] parameters)
582![](/Images/OutliningIndicators/InBlock.gif)
583![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
584![](/Images/OutliningIndicators/InBlock.gif)
585
SqlCommand command = BuildQueryCommand(connection,storedProcName, parameters );
586![](/Images/OutliningIndicators/InBlock.gif)
587
command.Parameters.Add( new SqlParameter ( "ReturnValue",
588![](/Images/OutliningIndicators/InBlock.gif)
589
SqlDbType.Int,4,ParameterDirection.ReturnValue,
590![](/Images/OutliningIndicators/InBlock.gif)
591
false,0,0,string.Empty,DataRowVersion.Default,null ));
592![](/Images/OutliningIndicators/InBlock.gif)
593
return command;
594![](/Images/OutliningIndicators/InBlock.gif)
595
}
596![](/Images/OutliningIndicators/InBlock.gif)
597
#endregion
598![](/Images/OutliningIndicators/None.gif)
599
600![](/Images/OutliningIndicators/None.gif)
601
}
602![](/Images/OutliningIndicators/None.gif)
603![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/ContractedBlock.gif)
2
![](/Images/OutliningIndicators/InBlock.gif)
3
![](/Images/OutliningIndicators/InBlock.gif)
4
![](/Images/OutliningIndicators/InBlock.gif)
5
![](/Images/OutliningIndicators/InBlock.gif)
6
![](/Images/OutliningIndicators/InBlock.gif)
7
![](/Images/OutliningIndicators/InBlock.gif)
8
![](/Images/OutliningIndicators/InBlock.gif)
9
![](/Images/OutliningIndicators/ExpandedBlockEnd.gif)
10
![](/Images/OutliningIndicators/None.gif)
11
![](/Images/OutliningIndicators/None.gif)
12
![](/Images/OutliningIndicators/None.gif)
13
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/ContractedBlock.gif)
![](/Images/dot.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/InBlock.gif)
20
![](/Images/OutliningIndicators/InBlock.gif)
21
![](/Images/OutliningIndicators/InBlock.gif)
22
![](/Images/OutliningIndicators/InBlock.gif)
23
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/dot.gif)
24
![](/Images/OutliningIndicators/InBlock.gif)
25
![](/Images/OutliningIndicators/InBlock.gif)
26
![](/Images/OutliningIndicators/InBlock.gif)
27
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
28
![](/Images/OutliningIndicators/InBlock.gif)
29
![](/Images/OutliningIndicators/InBlock.gif)
30
![](/Images/OutliningIndicators/InBlock.gif)
31
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/dot.gif)
32
![](/Images/OutliningIndicators/InBlock.gif)
33
![](/Images/OutliningIndicators/InBlock.gif)
34
![](/Images/OutliningIndicators/InBlock.gif)
35
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
36
![](/Images/OutliningIndicators/InBlock.gif)
37
![](/Images/OutliningIndicators/ExpandedBlockEnd.gif)
38
![](/Images/OutliningIndicators/None.gif)
39
![](/Images/OutliningIndicators/None.gif)
40
![](/Images/OutliningIndicators/None.gif)
41
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/ContractedBlock.gif)
42
![](/Images/OutliningIndicators/InBlock.gif)
43
![](/Images/OutliningIndicators/InBlock.gif)
44
![](/Images/OutliningIndicators/InBlock.gif)
45
![](/Images/OutliningIndicators/InBlock.gif)
46
![](/Images/OutliningIndicators/InBlock.gif)
47
![](/Images/OutliningIndicators/InBlock.gif)
48
![](/Images/OutliningIndicators/InBlock.gif)
49
![](/Images/OutliningIndicators/ExpandedBlockEnd.gif)
50
![](/Images/OutliningIndicators/None.gif)
51
![](/Images/OutliningIndicators/None.gif)
52
![](/Images/OutliningIndicators/None.gif)
53
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/ContractedBlock.gif)
![](/Images/dot.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/InBlock.gif)
60
![](/Images/OutliningIndicators/InBlock.gif)
61
![](/Images/OutliningIndicators/InBlock.gif)
62
![](/Images/OutliningIndicators/InBlock.gif)
63
![](/Images/OutliningIndicators/InBlock.gif)
64
![](/Images/OutliningIndicators/InBlock.gif)
65
![](/Images/OutliningIndicators/ExpandedBlockEnd.gif)
66
![](/Images/OutliningIndicators/None.gif)
67
![](/Images/OutliningIndicators/None.gif)
68
![](/Images/OutliningIndicators/None.gif)
69
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/ContractedBlock.gif)
70
![](/Images/OutliningIndicators/InBlock.gif)
71
![](/Images/OutliningIndicators/InBlock.gif)
72
![](/Images/OutliningIndicators/InBlock.gif)
73
![](/Images/OutliningIndicators/InBlock.gif)
74
![](/Images/OutliningIndicators/InBlock.gif)
75
![](/Images/OutliningIndicators/InBlock.gif)
76
![](/Images/OutliningIndicators/InBlock.gif)
77
![](/Images/OutliningIndicators/ExpandedBlockEnd.gif)
78
![](/Images/OutliningIndicators/None.gif)
79
![](/Images/OutliningIndicators/None.gif)
80
![](/Images/OutliningIndicators/None.gif)
81
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/ContractedBlock.gif)
![](/Images/dot.gif)
82
![](/Images/OutliningIndicators/InBlock.gif)
83
![](/Images/OutliningIndicators/InBlock.gif)
84
![](/Images/OutliningIndicators/InBlock.gif)
85
![](/Images/OutliningIndicators/InBlock.gif)
86
![](/Images/OutliningIndicators/InBlock.gif)
87
![](/Images/OutliningIndicators/InBlock.gif)
88
![](/Images/OutliningIndicators/InBlock.gif)
89
![](/Images/OutliningIndicators/InBlock.gif)
90
![](/Images/OutliningIndicators/InBlock.gif)
91
![](/Images/OutliningIndicators/ExpandedBlockEnd.gif)
92
![](/Images/OutliningIndicators/None.gif)
93
![](/Images/OutliningIndicators/None.gif)
94
![](/Images/OutliningIndicators/None.gif)
95
![](/Images/OutliningIndicators/None.gif)
96
![](/Images/OutliningIndicators/None.gif)
97
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/ContractedBlock.gif)
![](/Images/dot.gif)
98
![](/Images/OutliningIndicators/InBlock.gif)
99
![](/Images/OutliningIndicators/InBlock.gif)
100
![](/Images/OutliningIndicators/InBlock.gif)
101
![](/Images/OutliningIndicators/InBlock.gif)
102
![](/Images/OutliningIndicators/InBlock.gif)
103
![](/Images/OutliningIndicators/InBlock.gif)
104
![](/Images/OutliningIndicators/InBlock.gif)
105
![](/Images/OutliningIndicators/InBlock.gif)
106
![](/Images/OutliningIndicators/InBlock.gif)
107
![](/Images/OutliningIndicators/ExpandedBlockEnd.gif)
108
![](/Images/OutliningIndicators/None.gif)
109
![](/Images/OutliningIndicators/None.gif)
110
![](/Images/OutliningIndicators/None.gif)
111
![](/Images/OutliningIndicators/None.gif)
112
![](/Images/OutliningIndicators/None.gif)
113
![](/Images/OutliningIndicators/None.gif)
114
![](/Images/OutliningIndicators/None.gif)
115
![](/Images/OutliningIndicators/ContractedBlock.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
116
![](/Images/OutliningIndicators/InBlock.gif)
117
![](/Images/OutliningIndicators/InBlock.gif)
118
![](/Images/OutliningIndicators/InBlock.gif)
119
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
120
![](/Images/OutliningIndicators/InBlock.gif)
121
![](/Images/OutliningIndicators/InBlock.gif)
122
![](/Images/OutliningIndicators/InBlock.gif)
123
![](/Images/OutliningIndicators/InBlock.gif)
124
![](/Images/OutliningIndicators/InBlock.gif)
125
![](/Images/OutliningIndicators/InBlock.gif)
126
![](/Images/OutliningIndicators/InBlock.gif)
127
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
128
![](/Images/OutliningIndicators/InBlock.gif)
129
![](/Images/OutliningIndicators/InBlock.gif)
130
![](/Images/OutliningIndicators/InBlock.gif)
131
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/dot.gif)
132
![](/Images/OutliningIndicators/InBlock.gif)
133
![](/Images/OutliningIndicators/InBlock.gif)
134
![](/Images/OutliningIndicators/InBlock.gif)
135
![](/Images/OutliningIndicators/InBlock.gif)
136
![](/Images/OutliningIndicators/InBlock.gif)
137
![](/Images/OutliningIndicators/InBlock.gif)
138
![](/Images/OutliningIndicators/InBlock.gif)
139
![](/Images/OutliningIndicators/InBlock.gif)
140
![](/Images/OutliningIndicators/InBlock.gif)
141
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
142
![](/Images/OutliningIndicators/InBlock.gif)
143
![](/Images/OutliningIndicators/InBlock.gif)
144
![](/Images/OutliningIndicators/InBlock.gif)
145
![](/Images/OutliningIndicators/InBlock.gif)
146
![](/Images/OutliningIndicators/InBlock.gif)
147
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
148
![](/Images/OutliningIndicators/InBlock.gif)
149
![](/Images/OutliningIndicators/InBlock.gif)
150
![](/Images/OutliningIndicators/InBlock.gif)
151
![](/Images/OutliningIndicators/InBlock.gif)
152
![](/Images/OutliningIndicators/InBlock.gif)
153
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
154
![](/Images/OutliningIndicators/InBlock.gif)
155
![](/Images/OutliningIndicators/InBlock.gif)
156
![](/Images/OutliningIndicators/InBlock.gif)
157
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/dot.gif)
158
![](/Images/OutliningIndicators/InBlock.gif)
159
![](/Images/OutliningIndicators/InBlock.gif)
160
![](/Images/OutliningIndicators/InBlock.gif)
161
![](/Images/OutliningIndicators/InBlock.gif)
162
![](/Images/OutliningIndicators/InBlock.gif)
163
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/dot.gif)
164
![](/Images/OutliningIndicators/InBlock.gif)
165
![](/Images/OutliningIndicators/InBlock.gif)
166
![](/Images/OutliningIndicators/InBlock.gif)
167
![](/Images/OutliningIndicators/InBlock.gif)
168
![](/Images/OutliningIndicators/InBlock.gif)
169
![](/Images/OutliningIndicators/InBlock.gif)
170
![](/Images/OutliningIndicators/InBlock.gif)
171
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/dot.gif)
172
![](/Images/OutliningIndicators/InBlock.gif)
173
![](/Images/OutliningIndicators/InBlock.gif)
174
![](/Images/OutliningIndicators/InBlock.gif)
175
![](/Images/OutliningIndicators/InBlock.gif)
176
![](/Images/OutliningIndicators/InBlock.gif)
177
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/dot.gif)
178
![](/Images/OutliningIndicators/InBlock.gif)
179
![](/Images/OutliningIndicators/InBlock.gif)
180
![](/Images/OutliningIndicators/InBlock.gif)
181
![](/Images/OutliningIndicators/InBlock.gif)
182
![](/Images/OutliningIndicators/InBlock.gif)
183
![](/Images/OutliningIndicators/InBlock.gif)
184
![](/Images/OutliningIndicators/InBlock.gif)
185
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/dot.gif)
186
![](/Images/OutliningIndicators/InBlock.gif)
187
![](/Images/OutliningIndicators/InBlock.gif)
188
![](/Images/OutliningIndicators/InBlock.gif)
189
![](/Images/OutliningIndicators/InBlock.gif)
190
![](/Images/OutliningIndicators/InBlock.gif)
191
![](/Images/OutliningIndicators/InBlock.gif)
192
![](/Images/OutliningIndicators/InBlock.gif)
193
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
194
![](/Images/OutliningIndicators/InBlock.gif)
195
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
196
![](/Images/OutliningIndicators/InBlock.gif)
197
![](/Images/OutliningIndicators/InBlock.gif)
198
![](/Images/OutliningIndicators/InBlock.gif)
199
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
200
![](/Images/OutliningIndicators/InBlock.gif)
201
![](/Images/OutliningIndicators/InBlock.gif)
202
![](/Images/OutliningIndicators/InBlock.gif)
203
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/dot.gif)
204
![](/Images/OutliningIndicators/InBlock.gif)
205
![](/Images/OutliningIndicators/InBlock.gif)
206
![](/Images/OutliningIndicators/InBlock.gif)
207
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
208
![](/Images/OutliningIndicators/InBlock.gif)
209
![](/Images/OutliningIndicators/InBlock.gif)
210
![](/Images/OutliningIndicators/InBlock.gif)
211
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/dot.gif)
212
![](/Images/OutliningIndicators/InBlock.gif)
213
![](/Images/OutliningIndicators/InBlock.gif)
214
![](/Images/OutliningIndicators/InBlock.gif)
215
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
216
![](/Images/OutliningIndicators/InBlock.gif)
217
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
218
![](/Images/OutliningIndicators/InBlock.gif)
219
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
220
![](/Images/OutliningIndicators/InBlock.gif)
221
![](/Images/OutliningIndicators/InBlock.gif)
222
![](/Images/OutliningIndicators/InBlock.gif)
223
![](/Images/OutliningIndicators/InBlock.gif)
224
![](/Images/OutliningIndicators/InBlock.gif)
225
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
226
![](/Images/OutliningIndicators/InBlock.gif)
227
![](/Images/OutliningIndicators/InBlock.gif)
228
![](/Images/OutliningIndicators/InBlock.gif)
229
![](/Images/OutliningIndicators/InBlock.gif)
230
![](/Images/OutliningIndicators/InBlock.gif)
231
![](/Images/OutliningIndicators/InBlock.gif)
232
![](/Images/OutliningIndicators/InBlock.gif)
233
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
234
![](/Images/OutliningIndicators/InBlock.gif)
235
![](/Images/OutliningIndicators/InBlock.gif)
236
![](/Images/OutliningIndicators/InBlock.gif)
237
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/dot.gif)
238
![](/Images/OutliningIndicators/InBlock.gif)
239
![](/Images/OutliningIndicators/InBlock.gif)
240
![](/Images/OutliningIndicators/InBlock.gif)
241
![](/Images/OutliningIndicators/InBlock.gif)
242
![](/Images/OutliningIndicators/InBlock.gif)
243
![](/Images/OutliningIndicators/InBlock.gif)
244
![](/Images/OutliningIndicators/InBlock.gif)
245
![](/Images/OutliningIndicators/InBlock.gif)
246
![](/Images/OutliningIndicators/InBlock.gif)
247
![](/Images/OutliningIndicators/InBlock.gif)
248
![](/Images/OutliningIndicators/InBlock.gif)
249
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/dot.gif)
250
![](/Images/OutliningIndicators/InBlock.gif)
251
![](/Images/OutliningIndicators/InBlock.gif)
252
![](/Images/OutliningIndicators/InBlock.gif)
253
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
254
![](/Images/OutliningIndicators/InBlock.gif)
255
![](/Images/OutliningIndicators/InBlock.gif)
256
![](/Images/OutliningIndicators/InBlock.gif)
257
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/dot.gif)
258
![](/Images/OutliningIndicators/InBlock.gif)
259
![](/Images/OutliningIndicators/InBlock.gif)
260
![](/Images/OutliningIndicators/InBlock.gif)
261
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
262
![](/Images/OutliningIndicators/InBlock.gif)
263
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
264
![](/Images/OutliningIndicators/InBlock.gif)
265
![](/Images/OutliningIndicators/InBlock.gif)
266
![](/Images/OutliningIndicators/InBlock.gif)
267
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
268
![](/Images/OutliningIndicators/InBlock.gif)
269
![](/Images/OutliningIndicators/InBlock.gif)
270
![](/Images/OutliningIndicators/InBlock.gif)
271
![](/Images/OutliningIndicators/InBlock.gif)
272
![](/Images/OutliningIndicators/InBlock.gif)
273
![](/Images/OutliningIndicators/InBlock.gif)
274
![](/Images/OutliningIndicators/InBlock.gif)
275
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
276
![](/Images/OutliningIndicators/InBlock.gif)
277
![](/Images/OutliningIndicators/InBlock.gif)
278
![](/Images/OutliningIndicators/InBlock.gif)
279
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/dot.gif)
280
![](/Images/OutliningIndicators/InBlock.gif)
281
![](/Images/OutliningIndicators/InBlock.gif)
282
![](/Images/OutliningIndicators/InBlock.gif)
283
![](/Images/OutliningIndicators/InBlock.gif)
284
![](/Images/OutliningIndicators/InBlock.gif)
285
![](/Images/OutliningIndicators/InBlock.gif)
286
![](/Images/OutliningIndicators/InBlock.gif)
287
![](/Images/OutliningIndicators/InBlock.gif)
288
![](/Images/OutliningIndicators/InBlock.gif)
289
![](/Images/OutliningIndicators/InBlock.gif)
290
![](/Images/OutliningIndicators/InBlock.gif)
291
![](/Images/OutliningIndicators/InBlock.gif)
292
![](/Images/OutliningIndicators/InBlock.gif)
293
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
294
![](/Images/OutliningIndicators/InBlock.gif)
295
![](/Images/OutliningIndicators/InBlock.gif)
296
![](/Images/OutliningIndicators/InBlock.gif)
297
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
298
![](/Images/OutliningIndicators/InBlock.gif)
299
![](/Images/OutliningIndicators/InBlock.gif)
300
![](/Images/OutliningIndicators/InBlock.gif)
301
![](/Images/OutliningIndicators/InBlock.gif)
302
![](/Images/OutliningIndicators/InBlock.gif)
303
![](/Images/OutliningIndicators/InBlock.gif)
304
![](/Images/OutliningIndicators/InBlock.gif)
305
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
306
![](/Images/OutliningIndicators/InBlock.gif)
307
![](/Images/OutliningIndicators/InBlock.gif)
308
![](/Images/OutliningIndicators/InBlock.gif)
309
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/dot.gif)
310
![](/Images/OutliningIndicators/InBlock.gif)
311
![](/Images/OutliningIndicators/InBlock.gif)
312
![](/Images/OutliningIndicators/InBlock.gif)
313
![](/Images/OutliningIndicators/InBlock.gif)
314
![](/Images/OutliningIndicators/InBlock.gif)
315
![](/Images/OutliningIndicators/InBlock.gif)
316
![](/Images/OutliningIndicators/InBlock.gif)
317
![](/Images/OutliningIndicators/InBlock.gif)
318
![](/Images/OutliningIndicators/InBlock.gif)
319
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
320
![](/Images/OutliningIndicators/InBlock.gif)
321
![](/Images/OutliningIndicators/InBlock.gif)
322
![](/Images/OutliningIndicators/InBlock.gif)
323
![](/Images/OutliningIndicators/InBlock.gif)
324
![](/Images/OutliningIndicators/InBlock.gif)
325
![](/Images/OutliningIndicators/InBlock.gif)
326
![](/Images/OutliningIndicators/InBlock.gif)
327
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/dot.gif)
328
![](/Images/OutliningIndicators/InBlock.gif)
329
![](/Images/OutliningIndicators/InBlock.gif)
330
![](/Images/OutliningIndicators/InBlock.gif)
331
![](/Images/OutliningIndicators/InBlock.gif)
332
![](/Images/OutliningIndicators/InBlock.gif)
333
![](/Images/OutliningIndicators/InBlock.gif)
334
![](/Images/OutliningIndicators/InBlock.gif)
335
![](/Images/OutliningIndicators/InBlock.gif)
336
![](/Images/OutliningIndicators/InBlock.gif)
337
![](/Images/OutliningIndicators/InBlock.gif)
338
![](/Images/OutliningIndicators/InBlock.gif)
339
![](/Images/OutliningIndicators/InBlock.gif)
340
![](/Images/OutliningIndicators/InBlock.gif)
341
![](/Images/OutliningIndicators/InBlock.gif)
342
![](/Images/OutliningIndicators/InBlock.gif)
343
![](/Images/OutliningIndicators/InBlock.gif)
344
![](/Images/OutliningIndicators/InBlock.gif)
345
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/dot.gif)
346
![](/Images/OutliningIndicators/InBlock.gif)
347
![](/Images/OutliningIndicators/InBlock.gif)
348
![](/Images/OutliningIndicators/InBlock.gif)
349
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/dot.gif)
350
![](/Images/OutliningIndicators/InBlock.gif)
351
![](/Images/OutliningIndicators/InBlock.gif)
352
![](/Images/OutliningIndicators/InBlock.gif)
353
![](/Images/OutliningIndicators/InBlock.gif)
354
![](/Images/OutliningIndicators/InBlock.gif)
355
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/dot.gif)
356
![](/Images/OutliningIndicators/InBlock.gif)
357
![](/Images/OutliningIndicators/InBlock.gif)
358
![](/Images/OutliningIndicators/InBlock.gif)
359
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
360
![](/Images/OutliningIndicators/InBlock.gif)
361
![](/Images/OutliningIndicators/InBlock.gif)
362
![](/Images/OutliningIndicators/InBlock.gif)
363
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
364
![](/Images/OutliningIndicators/InBlock.gif)
365
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
366
![](/Images/OutliningIndicators/InBlock.gif)
367
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
368
![](/Images/OutliningIndicators/InBlock.gif)
369
![](/Images/OutliningIndicators/InBlock.gif)
370
![](/Images/OutliningIndicators/InBlock.gif)
371
![](/Images/OutliningIndicators/ExpandedBlockEnd.gif)
372
![](/Images/OutliningIndicators/None.gif)
373
![](/Images/OutliningIndicators/None.gif)
374
![](/Images/OutliningIndicators/None.gif)
375
![](/Images/OutliningIndicators/ContractedBlock.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
376
![](/Images/OutliningIndicators/InBlock.gif)
377
![](/Images/OutliningIndicators/InBlock.gif)
378
![](/Images/OutliningIndicators/InBlock.gif)
379
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
380
![](/Images/OutliningIndicators/InBlock.gif)
381
![](/Images/OutliningIndicators/InBlock.gif)
382
![](/Images/OutliningIndicators/InBlock.gif)
383
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
384
![](/Images/OutliningIndicators/InBlock.gif)
385
![](/Images/OutliningIndicators/InBlock.gif)
386
![](/Images/OutliningIndicators/InBlock.gif)
387
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/dot.gif)
388
![](/Images/OutliningIndicators/InBlock.gif)
389
![](/Images/OutliningIndicators/InBlock.gif)
390
![](/Images/OutliningIndicators/InBlock.gif)
391
![](/Images/OutliningIndicators/InBlock.gif)
392
![](/Images/OutliningIndicators/InBlock.gif)
393
![](/Images/OutliningIndicators/InBlock.gif)
394
![](/Images/OutliningIndicators/InBlock.gif)
395
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
396
![](/Images/OutliningIndicators/InBlock.gif)
397
![](/Images/OutliningIndicators/InBlock.gif)
398
![](/Images/OutliningIndicators/InBlock.gif)
399
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
400
![](/Images/OutliningIndicators/InBlock.gif)
401
![](/Images/OutliningIndicators/InBlock.gif)
402
![](/Images/OutliningIndicators/InBlock.gif)
403
![](/Images/OutliningIndicators/InBlock.gif)
404
![](/Images/OutliningIndicators/InBlock.gif)
405
![](/Images/OutliningIndicators/InBlock.gif)
406
![](/Images/OutliningIndicators/InBlock.gif)
407
![](/Images/OutliningIndicators/InBlock.gif)
408
![](/Images/OutliningIndicators/InBlock.gif)
409
![](/Images/OutliningIndicators/InBlock.gif)
410
![](/Images/OutliningIndicators/InBlock.gif)
411
![](/Images/OutliningIndicators/InBlock.gif)
412
![](/Images/OutliningIndicators/InBlock.gif)
413
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
414
![](/Images/OutliningIndicators/InBlock.gif)
415
![](/Images/OutliningIndicators/InBlock.gif)
416
![](/Images/OutliningIndicators/InBlock.gif)
417
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/dot.gif)
418
![](/Images/OutliningIndicators/InBlock.gif)
419
![](/Images/OutliningIndicators/InBlock.gif)
420
![](/Images/OutliningIndicators/InBlock.gif)
421
![](/Images/OutliningIndicators/InBlock.gif)
422
![](/Images/OutliningIndicators/InBlock.gif)
423
![](/Images/OutliningIndicators/InBlock.gif)
424
![](/Images/OutliningIndicators/InBlock.gif)
425
![](/Images/OutliningIndicators/InBlock.gif)
426
![](/Images/OutliningIndicators/InBlock.gif)
427
![](/Images/OutliningIndicators/InBlock.gif)
428
![](/Images/OutliningIndicators/InBlock.gif)
429
![](/Images/OutliningIndicators/InBlock.gif)
430
![](/Images/OutliningIndicators/InBlock.gif)
431
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
432
![](/Images/OutliningIndicators/InBlock.gif)
433
![](/Images/OutliningIndicators/InBlock.gif)
434
![](/Images/OutliningIndicators/InBlock.gif)
435
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
436
![](/Images/OutliningIndicators/InBlock.gif)
437
![](/Images/OutliningIndicators/InBlock.gif)
438
![](/Images/OutliningIndicators/InBlock.gif)
439
![](/Images/OutliningIndicators/InBlock.gif)
440
![](/Images/OutliningIndicators/InBlock.gif)
441
![](/Images/OutliningIndicators/InBlock.gif)
442
![](/Images/OutliningIndicators/InBlock.gif)
443
![](/Images/OutliningIndicators/InBlock.gif)
444
![](/Images/OutliningIndicators/InBlock.gif)
445
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
446
![](/Images/OutliningIndicators/InBlock.gif)
447
![](/Images/OutliningIndicators/InBlock.gif)
448
![](/Images/OutliningIndicators/InBlock.gif)
449
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/dot.gif)
450
![](/Images/OutliningIndicators/InBlock.gif)
451
![](/Images/OutliningIndicators/InBlock.gif)
452
![](/Images/OutliningIndicators/InBlock.gif)
453
![](/Images/OutliningIndicators/InBlock.gif)
454
![](/Images/OutliningIndicators/InBlock.gif)
455
![](/Images/OutliningIndicators/InBlock.gif)
456
![](/Images/OutliningIndicators/InBlock.gif)
457
![](/Images/OutliningIndicators/InBlock.gif)
458
![](/Images/OutliningIndicators/InBlock.gif)
459
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
460
![](/Images/OutliningIndicators/InBlock.gif)
461
![](/Images/OutliningIndicators/InBlock.gif)
462
![](/Images/OutliningIndicators/InBlock.gif)
463
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
464
![](/Images/OutliningIndicators/InBlock.gif)
465
![](/Images/OutliningIndicators/InBlock.gif)
466
![](/Images/OutliningIndicators/InBlock.gif)
467
![](/Images/OutliningIndicators/InBlock.gif)
468
![](/Images/OutliningIndicators/InBlock.gif)
469
![](/Images/OutliningIndicators/InBlock.gif)
470
![](/Images/OutliningIndicators/InBlock.gif)
471
![](/Images/OutliningIndicators/InBlock.gif)
472
![](/Images/OutliningIndicators/InBlock.gif)
473
![](/Images/OutliningIndicators/InBlock.gif)
474
![](/Images/OutliningIndicators/InBlock.gif)
475
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
476
![](/Images/OutliningIndicators/InBlock.gif)
477
![](/Images/OutliningIndicators/InBlock.gif)
478
![](/Images/OutliningIndicators/InBlock.gif)
479
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/dot.gif)
480
![](/Images/OutliningIndicators/InBlock.gif)
481
![](/Images/OutliningIndicators/InBlock.gif)
482
![](/Images/OutliningIndicators/InBlock.gif)
483
![](/Images/OutliningIndicators/InBlock.gif)
484
![](/Images/OutliningIndicators/InBlock.gif)
485
![](/Images/OutliningIndicators/InBlock.gif)
486
![](/Images/OutliningIndicators/InBlock.gif)
487
![](/Images/OutliningIndicators/InBlock.gif)
488
![](/Images/OutliningIndicators/InBlock.gif)
489
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
490
![](/Images/OutliningIndicators/InBlock.gif)
491
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
492
![](/Images/OutliningIndicators/InBlock.gif)
493
![](/Images/OutliningIndicators/InBlock.gif)
494
![](/Images/OutliningIndicators/InBlock.gif)
495
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
496
![](/Images/OutliningIndicators/InBlock.gif)
497
![](/Images/OutliningIndicators/InBlock.gif)
498
![](/Images/OutliningIndicators/InBlock.gif)
499
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/dot.gif)
500
![](/Images/OutliningIndicators/InBlock.gif)
501
![](/Images/OutliningIndicators/InBlock.gif)
502
![](/Images/OutliningIndicators/InBlock.gif)
503
![](/Images/OutliningIndicators/InBlock.gif)
504
![](/Images/OutliningIndicators/InBlock.gif)
505
![](/Images/OutliningIndicators/InBlock.gif)
506
![](/Images/OutliningIndicators/InBlock.gif)
507
![](/Images/OutliningIndicators/InBlock.gif)
508
![](/Images/OutliningIndicators/InBlock.gif)
509
![](/Images/OutliningIndicators/InBlock.gif)
510
![](/Images/OutliningIndicators/InBlock.gif)
511
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
512
![](/Images/OutliningIndicators/InBlock.gif)
513
![](/Images/OutliningIndicators/InBlock.gif)
514
![](/Images/OutliningIndicators/InBlock.gif)
515
![](/Images/OutliningIndicators/InBlock.gif)
516
![](/Images/OutliningIndicators/InBlock.gif)
517
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
518
![](/Images/OutliningIndicators/InBlock.gif)
519
![](/Images/OutliningIndicators/InBlock.gif)
520
![](/Images/OutliningIndicators/InBlock.gif)
521
![](/Images/OutliningIndicators/InBlock.gif)
522
![](/Images/OutliningIndicators/InBlock.gif)
523
![](/Images/OutliningIndicators/InBlock.gif)
524
![](/Images/OutliningIndicators/InBlock.gif)
525
![](/Images/OutliningIndicators/InBlock.gif)
526
![](/Images/OutliningIndicators/InBlock.gif)
527
![](/Images/OutliningIndicators/InBlock.gif)
528
![](/Images/OutliningIndicators/InBlock.gif)
529
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
530
![](/Images/OutliningIndicators/InBlock.gif)
531
![](/Images/OutliningIndicators/InBlock.gif)
532
![](/Images/OutliningIndicators/InBlock.gif)
533
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/dot.gif)
534
![](/Images/OutliningIndicators/InBlock.gif)
535
![](/Images/OutliningIndicators/InBlock.gif)
536
![](/Images/OutliningIndicators/InBlock.gif)
537
![](/Images/OutliningIndicators/InBlock.gif)
538
![](/Images/OutliningIndicators/InBlock.gif)
539
![](/Images/OutliningIndicators/InBlock.gif)
540
![](/Images/OutliningIndicators/InBlock.gif)
541
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/dot.gif)
542
![](/Images/OutliningIndicators/InBlock.gif)
543
![](/Images/OutliningIndicators/InBlock.gif)
544
![](/Images/OutliningIndicators/InBlock.gif)
545
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/dot.gif)
546
![](/Images/OutliningIndicators/InBlock.gif)
547
![](/Images/OutliningIndicators/InBlock.gif)
548
![](/Images/OutliningIndicators/InBlock.gif)
549
![](/Images/OutliningIndicators/InBlock.gif)
550
![](/Images/OutliningIndicators/InBlock.gif)
551
![](/Images/OutliningIndicators/InBlock.gif)
552
![](/Images/OutliningIndicators/InBlock.gif)
553
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/dot.gif)
554
![](/Images/OutliningIndicators/InBlock.gif)
555
![](/Images/OutliningIndicators/InBlock.gif)
556
![](/Images/OutliningIndicators/InBlock.gif)
557
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
558
![](/Images/OutliningIndicators/InBlock.gif)
559
![](/Images/OutliningIndicators/InBlock.gif)
560
![](/Images/OutliningIndicators/InBlock.gif)
561
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
562
![](/Images/OutliningIndicators/InBlock.gif)
563
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
564
![](/Images/OutliningIndicators/InBlock.gif)
565
![](/Images/OutliningIndicators/InBlock.gif)
566
![](/Images/OutliningIndicators/InBlock.gif)
567
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
568
![](/Images/OutliningIndicators/InBlock.gif)
569
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
570
![](/Images/OutliningIndicators/InBlock.gif)
571
![](/Images/OutliningIndicators/InBlock.gif)
572
![](/Images/OutliningIndicators/InBlock.gif)
573
![](/Images/OutliningIndicators/InBlock.gif)
574
![](/Images/OutliningIndicators/InBlock.gif)
575
![](/Images/OutliningIndicators/InBlock.gif)
576
![](/Images/OutliningIndicators/InBlock.gif)
577
![](/Images/OutliningIndicators/InBlock.gif)
578
![](/Images/OutliningIndicators/InBlock.gif)
579
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
580
![](/Images/OutliningIndicators/InBlock.gif)
581
![](/Images/OutliningIndicators/InBlock.gif)
582
![](/Images/OutliningIndicators/InBlock.gif)
583
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/dot.gif)
584
![](/Images/OutliningIndicators/InBlock.gif)
585
![](/Images/OutliningIndicators/InBlock.gif)
586
![](/Images/OutliningIndicators/InBlock.gif)
587
![](/Images/OutliningIndicators/InBlock.gif)
588
![](/Images/OutliningIndicators/InBlock.gif)
589
![](/Images/OutliningIndicators/InBlock.gif)
590
![](/Images/OutliningIndicators/InBlock.gif)
591
![](/Images/OutliningIndicators/InBlock.gif)
592
![](/Images/OutliningIndicators/InBlock.gif)
593
![](/Images/OutliningIndicators/InBlock.gif)
594
![](/Images/OutliningIndicators/InBlock.gif)
595
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
596
![](/Images/OutliningIndicators/InBlock.gif)
597
![](/Images/OutliningIndicators/ExpandedBlockEnd.gif)
598
![](/Images/OutliningIndicators/None.gif)
599
![](/Images/OutliningIndicators/None.gif)
600
![](/Images/OutliningIndicators/None.gif)
601
![](/Images/OutliningIndicators/None.gif)
602
![](/Images/OutliningIndicators/None.gif)
603
![](/Images/OutliningIndicators/None.gif)