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

261         /// <param name="sqlCommand"></param>
262         /// <param name="parameters"></param>
263         /// <returns></returns>
264         public static DbDataReader GetReaderProc(string sqlCommand, Dictionary<string, object> parameters)
265         {
266
267             try
268             {
269
270                 DbConnection connection = GetConnection();
271
272                 DbCommand command = GetCommand(sqlCommand, CommandType.StoredProcedure, connection);
273
274                 foreach (KeyValuePair<string, object> p in parameters)
275                 {
276
277                     command.Parameters.Add(GetParameter(p.Key, p.Value, command));
278
279                 }
280
281                 connection.Open();
282
283                 DbDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection);
284
285                 command.Parameters.Clear();
286
287                 return reader;
288
289             }
290
291             catch
292             {
293
294                 return null;
295
296             }
297
298         }
299         #region
300
301         /// <summary>
302         /// 执行无参数的sql语句,返回DbDataReader对象