/// <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(); } }