/// <summary>
/// 执行SQL，返回datatable
/// </summary>
/// <param name="cmd"></param>
/// <returns></returns>
internal DataTable ExecuteDataTable(DbCommand cmd)
{
using (cmd.Connection = DbCommandMng.CreateConnection())
{
DbDataAdapter dbDataAdapter = DbCommandMng.CreateDataAdapter();
dbDataAdapter.SelectCommand = cmd;
DataTable dataTable = new DataTable();
dbDataAdapter.Fill(dataTable);
return(dataTable);
}
}
/// <summary>
/// 执行SQL，返回dataSet
/// </summary>
/// <param name="cmd"></param>
/// <returns></returns>
internal DataSet ExecuteDataSet(DbCommand cmd)
{
using (cmd.Connection = DbCommandMng.CreateConnection())
{
DbDataAdapter dbDataAdapter = DbCommandMng.CreateDataAdapter();
dbDataAdapter.SelectCommand = cmd;
DataSet dataset = new DataSet();
dbDataAdapter.Fill(dataset);
return(dataset);
}
}
/// <summary>
/// 执行SQL，返回dataSet
/// </summary>
/// <param name="cmd"></param>
/// <returns></returns>
internal DataSet ExecuteDataSet(DbCommand cmd, Trans trans)
{
cmd.Connection = trans.DbConnection;
cmd.Transaction = trans.DbTrans;
DbDataAdapter dbDataAdapter = DbCommandMng.CreateDataAdapter();
dbDataAdapter.SelectCommand = cmd;
DataSet dataset = new DataSet();
dbDataAdapter.Fill(dataset);
return(dataset);
}