/// <summary>
/// 构造方法
/// </summary>
/// <param name="l_DBManager">访问管理器</param>
public BaseAccess(DBManager l_DBManager)
{
this.m_DBManager = l_DBManager;
}
/// <summary>
/// 操作系统或浏览器情况
/// </summary>
/// <param name="strSql">SQL语句</param>
/// <returns>操作系统或浏览器情况数据集</returns>
public static DataSet ExecuteSqlForDataSet(string strSql)
{
DBManager objDB = new DBManager();
OleDbCommand objCmd = new OleDbCommand(strSql.FilterSql());
try
{
objCmd.Connection = objDB.CurrentlyConnection;
if (objDB.CurrentlyTransaction != null)
{
objCmd.Transaction = objDB.CurrentlyTransaction;
}
OleDbDataAdapter objAdapter = new OleDbDataAdapter(objCmd);
DataSet ds = new DataSet();
objAdapter.Fill(ds);
return ds;
}
catch (System.Data.SqlClient.SqlException e)
{
throw new Exception(e.Message);
}
finally
{
objCmd.Dispose();
}
}
