/// <summary>
/// 执行SQL语句返回结果集DataSet
/// </summary>
/// <param name="sql">SQL语句</param>
/// <param name="cmdParms">参数</param>
/// <returns></returns>
public DataSet GetDataSet(string sql, params IDbDataParameter[] cmdParms)
{
using (IDbConn = DataBaseFactory.GetIDbConnection())
{
IDbConn.Open();
using (IDbComm = DataBaseFactory.GetIDbCommand())
{
try
{
PrepareCommand(IDbComm, IDbConn, null, CommandType.Text, sql, cmdParms);
IDbDataAdapter dataAdapter = DataBaseFactory.GetIDbDataAdapter();
dataAdapter.SelectCommand = IDbComm;
DataSet dataSet = new DataSet();
dataAdapter.Fill(dataSet);
IDbComm.Parameters.Clear();
return(dataSet);
}
catch (Exception E)
{
IDbConn.Close();
return(null);
throw new Exception(E.Message);
}
finally
{
IDbConn.Close();
}
}
}
}
/// <summary>
/// 执行SQL语句返回结果集DataSet
/// </summary>
/// <param name="sql">SQL语句</param>
/// <returns></returns>
public DataSet GetDataSet(string sql)
{
using (IDbConn = DataBaseFactory.GetIDbConnection())
{
IDbConn.Open();
DataSet dataset = new DataSet();
try
{
IDbComm = DataBaseFactory.GetIDbCommand(sql);
//IDbComm.CommandText = sql;
//IDbComm.CommandType = CommandType.Text;
IDbAdpter = DataBaseFactory.GetIDbDataAdapter(IDbComm);
//IDbAdpter.SelectCommand = IDbComm;
IDbAdpter.Fill(dataset);
}
catch (Exception e)
{
IDbConn.Close();
throw new Exception(e.Message);
}
finally
{
IDbConn.Close();
}
return(dataset);
}
}
/// <summary>
/// 执行SQL语句返回结果集DataSet
/// </summary>
/// <param name="sql">SQL语句</param>
/// <returns></returns>
public static DataResult GetDataSet(string sql)
{
sql = DataBaseFactory.GetSQL(sql);
DataResult result = new DataResult();
result.Sql = sql + ";";
using (IDbConn = DataBaseFactory.GetIDbConnection())
{
IDbConn.Open();
using (IDbComm = DataBaseFactory.GetIDbCommand())
{
try
{
PrepareCommand(IDbComm, IDbConn, null, CommandType.Text, sql, IDbParams);
IDbDataAdapter dataAdapter = DataBaseFactory.GetIDbDataAdapter();
dataAdapter.SelectCommand = IDbComm;
DataSet dataSet = new DataSet();
dataAdapter.Fill(dataSet);
IDbComm.Parameters.Clear();
result.DataSet = dataSet;
}
catch (Exception E)
{
IDbConn.Close();
result.Error = E.Message;
return(result);
}
finally
{
IDbConn.Close();
}
}
}
return(result);
//using (IDbConn = DataBaseFactory.GetIDbConnection())
//{
// IDbConn.Open();
// DataSet dataset = new DataSet();
// try
// {
// IDbComm = DataBaseFactory.GetIDbCommand(sql);
// //IDbComm.CommandText = sql;
// //IDbComm.CommandType = CommandType.Text;
// IDbAdpter = DataBaseFactory.GetIDbDataAdapter(IDbComm);
// //IDbAdpter.SelectCommand = IDbComm;
// IDbAdpter.Fill(dataset);
// }
// catch (Exception e)
// {
// IDbConn.Close();
// throw new Exception(e.Message);
// }
// finally
// {
// IDbConn.Close();
// }
// return dataset;
//}
}
/// <summary>
/// 打开数据库连接
/// </summary>
public void Open()
{
if (IDbConn == null || IDbConn.State == ConnectionState.Closed)
{
IDbConn = DataBaseFactory.GetIDbConnection();
IDbComm = DataBaseFactory.GetIDbCommand();
IDbAdpter = DataBaseFactory.GetIDbDataAdapter();
// IDbTrans = DataBaseFactory.GetIDbTransaction();
}
IDbComm.Connection = IDbConn;
IDbAdpter.SelectCommand = IDbComm;
IDbComm.CommandType = CommandType.Text;
try
{
IDbConn.Open();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
/// <summary>
/// 执行SQL语句返回结果集DataSet
/// </summary>
/// <param name="sql">SQL语句</param>
/// <param name="cmdParms">参数</param>
/// <returns></returns>
public static DataResult GetDataSet(string sql, params IDbDataParameter[] cmdParms)
{
sql = DataBaseFactory.GetSQL(sql);
DataResult result = new DataResult();
result.Sql = sql + ";";
result.IDbDataParameter = cmdParms;
using (IDbConn = DataBaseFactory.GetIDbConnection())
{
IDbConn.Open();
using (IDbComm = DataBaseFactory.GetIDbCommand())
{
try
{
PrepareCommand(IDbComm, IDbConn, null, CommandType.Text, sql, cmdParms);
IDbDataAdapter dataAdapter = DataBaseFactory.GetIDbDataAdapter();
dataAdapter.SelectCommand = IDbComm;
DataSet dataSet = new DataSet();
dataAdapter.Fill(dataSet);
IDbComm.Parameters.Clear();
result.DataSet = dataSet;
}
catch (Exception E)
{
IDbConn.Close();
result.Error = E.Message;
return(result);
}
finally
{
IDbConn.Close();
}
}
}
return(result);
}
