cmdpart.cs

网上书店

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Data.Common;
/// <summary>
///CmdPart 的摘要说明
/// </summary>
public static  class CmdPart
{
	 //创建cmd命令
    public static DbCommand CreateCommand()
    {
        string dbProviderName = DatabaseConfiguration.DbProviderName;
        DbProviderFactory factory = DbProviderFactories.GetFactory(dbProviderName);
        DbConnection cn = factory.CreateConnection();
        cn.ConnectionString = DatabaseConfiguration.DbConnectionStrings;

        DbCommand cmd = cn.CreateCommand();
        cmd.CommandType = CommandType.StoredProcedure;
        return cmd;

    }

    //返回数据表
    public static DataTable ExcuteSelectCommand(DbCommand cmd)
    {
        DataTable dt = new DataTable();
        try
        {
            cmd.Connection.Open();
            DbDataReader ddr = cmd.ExecuteReader();
            dt.Load(ddr);
        }
        catch(Exception ex)
        {
            throw ex;
        }
        finally
        {
            cmd.Connection.Close();
            cmd.Connection.Dispose();
        }
        return dt;
    }

    //判断查询是否成功
    public static bool ExcuteNonSelectCommand(DbCommand cmd)
    {
        bool isSucces=false ;
        try
        {
            cmd.Connection.Open();
            cmd.ExecuteNonQuery();
            isSucces = true;
        }
        catch (Exception ex)
        {
            throw ex;
        }
        finally 
        {
            cmd.Connection.Close();
            cmd.Connection.Dispose();
        }
        return isSucces;
    }

    //返回查询的第一个值
    public static string ExecuteScalar(DbCommand cmd)
    {
        string value = "";
        try
        {
            cmd.Connection.Open();
            value = cmd.ExecuteScalar().ToString();
        }
        catch (Exception ex)
        {
            throw ex;
        }
        finally
        {
            cmd.Connection.Close();
            cmd.Connection.Dispose();
        }
        return value;
    }

}