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