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

160         }
161
162         /// <summary>
163         /// 执行有返回值的有参数的存储过程
164         /// </summary>
165         /// <param name="cmdText">存储过程名</param>
166         /// <param name="para">参数</param>
167         /// <returns></returns>
168         public static object ExecuteScalarProc(string cmdText, Dictionary<string, object> para)
169         {
170             using (DbConnection connection = GetConnection())
171             {
172                 DbCommand command = GetCommand(cmdText, CommandType.StoredProcedure, connection);
173                 foreach (KeyValuePair<string, object> p in para)
174                 {
175                     command.Parameters.Add(GetParameter(p.Key, p.Value, command));
176                 }
177                 connection.Open();
178                 object val = command.ExecuteScalar();
179                 command.Parameters.Clear();
180                 return val;
181             }
182         }
183
184         /// <summary>
185         /// 执行有返回值的sql语句
186         /// </summary>
187         /// <param name="cmdText"></param>
188         /// <returns></returns>
189         public static object ExecuteScalar(string cmdText)