Data/DbExecute.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

/*
 * Author: Kishore Reddy
 * Url: http://commonlibrarynet.codeplex.com/
 * Title: CommonLibrary.NET
 * Copyright: � 2009 Kishore Reddy
 * License: LGPL License
 * LicenseUrl: http://commonlibrarynet.codeplex.com/license
 * Description: A C# based .NET 3.5 Open-Source collection of reusable components.
 * Usage: Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */

using System;
using System.Data;
using System.Globalization;
using System.Text;

using System.Xml;
using System.Data.Common;
using System.Collections;
using System.Collections.Generic;



namespace ComLib.Data
{    
    /// <summary>
    /// Class containing various helper methods for accessing data.
    /// </summary>
    public static class DbExecute
    {
        /// <summary>
        /// Execute a non-query with a single output value.
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="dbHelper"></param>
        /// <param name="commandText">E.g. Storedprocedure : Posts_DeleteExpired</param>
        /// <param name="commandType">Type of the command.</param>
        /// <param name="outputParamName">The name of the output parameter. E.g. @TotalRows</param>
        /// <param name="dbParameters">Input parameters.</param>
        /// <returns></returns>
        public static T Execute<T>(this IDBHelper dbHelper, string commandText, CommandType commandType, DbParameter[] dbParameters, string outputParamName )
        {
            IDictionary<string, object> results = Execute(dbHelper, commandText, commandType, dbParameters, new string[] { outputParamName });
            return (T)results[outputParamName];
        }


        /// <summary>
        /// Execute a non-query with a single input parameter.
        /// </summary>
        /// <param name="dbHelper"></param>
        /// <param name="commandText">E.g. Storedprocedure : Posts_DeleteByUser</param>
        /// <param name="commandType">Type of the command.</param>
        /// <param name="paramName">E.g. "@UserName"</param>
        /// <param name="paramType">E.g. DbType.String</param>
        /// <param name="paramValue">E.g. "kreddy"</param>