.net简单的三层实现功能(9)

218                 command.Parameters.Clear();
219                 return val;
220             }
221
222         }
223
224         /// <summary>
225         /// 执行无参数的存储过程,返回DbDataReader对象
226         /// </summary>
227         /// <param name="sqlCommand">存储过程名</param>
228         /// <returns></returns>
229         public static DbDataReader GetReaderProc(string sqlCommand)
230         {
231
232             try
233             {
234
235                 DbConnection connection = GetConnection();
236
237                 DbCommand command = GetCommand(sqlCommand, CommandType.StoredProcedure, connection);
238
239                 connection.Open();
240
241                 DbDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection);
242
243                 return reader;
244
245             }
246
247             catch (Exception ex)
248             {
249
250                 Console.Write("" + ex.Message);
251
252                 return null;
253
254             }
255
256         }
257
258         /// <summary>
259         /// 执行有参数的存储过程,返回DbDataReader对象
260         /// </summary>