/// <summary> /// 执行命令 并返回影响行数 /// </summary> /// <param name="cmdText"></param> /// <param name="commandParameters"></param> /// <param name="cmdType"></param> /// <returns></returns> public int ExecuteNonQuery(string cmdText, DbParameter[] commandParameters, CommandType cmdType = CommandType.Text) { this.SqlOutPutToLogAsync(cmdText, commandParameters); using (DbConnection conn = DatabaseFactory.GetDbConnection(this._dbConfig)) { if (conn.State != ConnectionState.Open) { conn.Open(); } using (DbCommand cmd = DatabaseFactory.GetDbDbCommand(this._dbConfig)) { int val = -1; try { PrepareCommand(cmd, conn, null, cmdType, cmdText, commandParameters); val = cmd.ExecuteNonQuery(); cmd.Parameters.Clear(); } catch (Exception ex) { throw ex; } return(val); } } }
/// <summary> /// 执行查询 返回 DataSet /// </summary> /// <param name="cmdText"></param> /// <param name="commandParameters"></param> /// <param name="cmdType"></param> /// <returns></returns> public DataSet ExecuteDataSet(string cmdText, DbParameter[] commandParameters, CommandType cmdType = CommandType.Text) { DataSet resultData = new DataSet(); this.SqlOutPutToLogAsync(cmdText, commandParameters); using (DbConnection conn = DatabaseFactory.GetDbConnection(this._dbConfig)) { if (conn.State != ConnectionState.Open) { conn.Open(); } using (DbCommand cmd = DatabaseFactory.GetDbDbCommand(this._dbConfig)) { try { PrepareCommand(cmd, conn, null, cmdType, cmdText, commandParameters); var dataAdapter = DatabaseFactory.GetDbDataAdapter(cmd, this._dbConfig); dataAdapter.Fill(resultData); cmd.Parameters.Clear(); } catch (Exception ex) { throw ex; } return(resultData); } } }
/// <summary> ///执行命令 并返回首列结果 /// </summary> /// <param name="cmdText"></param> /// <param name="commandParameters"></param> /// <param name="cmdType"></param> /// <returns></returns> public object ExecuteScalar(string cmdText, DbParameter[] commandParameters, CommandType cmdType = CommandType.Text) { object val = null; this.SqlOutPutToLogAsync(cmdText, commandParameters); using (DbConnection conn = DatabaseFactory.GetDbConnection(this._dbConfig)) { DbCommand cmd = DatabaseFactory.GetDbDbCommand(this._dbConfig); try { if (conn.State != ConnectionState.Open) { conn.Open(); } if (conn.State != ConnectionState.Open) { conn.Open(); } PrepareCommand(cmd, conn, null, cmdType, cmdText, commandParameters); val = cmd.ExecuteScalar(); cmd.Parameters.Clear(); } catch (Exception ex) { throw ex; } finally { cmd.Dispose(); conn.Close(); conn.Dispose(); } } return(val); }
/// <summary> /// 执行命令 并返回一个可读的Reader /// </summary> /// <param name="cmdText"></param> /// <param name="commandParameters"></param> /// <param name="cmdType"></param> /// <returns></returns> public DbDataReader ExecuteReader(string cmdText, DbParameter[] commandParameters, CommandType cmdType = CommandType.Text) { this.SqlOutPutToLogAsync(cmdText, commandParameters); try { DbConnection conn = DatabaseFactory.GetDbConnection(this._dbConfig); if (conn.State != ConnectionState.Open) { conn.Open(); } DbCommand cmd = DatabaseFactory.GetDbDbCommand(this._dbConfig); PrepareCommand(cmd, conn, null, cmdType, cmdText, commandParameters); DbDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection); return(rdr); } catch (Exception ex) { throw ex; } }