/// <summary>
/// 返回一个DataTable
/// </summary>
/// <param name="commandText">SQL语句字符串</param>
/// <param name="timeOut">超时限制</param>
/// <returns></returns>
public override DataTable GetDataTable(string commandText, int timeOut)
{
IBM.Data.Informix.IfxCommand cmd = new IBM.Data.Informix.IfxCommand(commandText);
cmd.Connection = (IBM.Data.Informix.IfxConnection) this.connection;
if (timeOut > 30)
{
cmd.CommandTimeout = timeOut;
}
if (isInTransaction)
{
cmd.Transaction = (IBM.Data.Informix.IfxTransaction)transaction;
}
IBM.Data.Informix.IfxDataAdapter adapter = new IBM.Data.Informix.IfxDataAdapter((IBM.Data.Informix.IfxCommand)cmd);
try
{
DataTable dt = new DataTable();
adapter.Fill(dt);
return(dt);
}
catch (Exception err)
{
throw new EntityException(err.Message);
}
finally
{
cmd.Dispose();
cmd = null;
adapter.Dispose();
adapter = null;
}
}
/// <summary>
/// 返回一个DataTable
/// </summary>
/// <param name="cmd">IDbCommand对象</param>
/// <returns></returns>
public override DataTable GetDataTable(IDbCommand cmd)
{
cmd.Connection = this.connection;
if (isInTransaction)
{
cmd.Transaction = (IBM.Data.Informix.IfxTransaction)transaction;
}
IBM.Data.Informix.IfxDataAdapter adapter = new IBM.Data.Informix.IfxDataAdapter((IBM.Data.Informix.IfxCommand)cmd);
try
{
DataTable dt = new DataTable();
adapter.Fill(dt);
return(dt);
}
catch (Exception err)
{
throw new EntityException(err.Message);
}
finally
{
adapter.Dispose();
adapter = null;
}
}
/// <summary>
/// 返回一个IDataAdpter
/// </summary>
/// <param name="cmd">IDbCommand对象</param>
/// <returns></returns>
public override DbDataAdapter GetAdapter(IDbCommand cmd)
{
IBM.Data.Informix.IfxDataAdapter adapter = new IBM.Data.Informix.IfxDataAdapter();
adapter.SelectCommand = (IBM.Data.Informix.IfxCommand)cmd;
cmd.Connection = connection;
if (isInTransaction)
{
cmd.Transaction = (IBM.Data.Informix.IfxTransaction)transaction;
}
return(adapter);
}
public override DataRow GetDataRow(string procedurName, ParameterEx[] parameters, int timeOut)
{
IDbCommand cmd = this.GetCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = procedurName;
cmd.CommandTimeout = timeOut;
cmd.Connection = this.connection; //添加连接
if (parameters != null && parameters.Length > 0)
{
this.SetParameters(cmd, parameters);
}
DataRow r;
IBM.Data.Informix.IfxDataAdapter adapter = new IBM.Data.Informix.IfxDataAdapter();
adapter.SelectCommand = (IBM.Data.Informix.IfxCommand)cmd;
if (isInTransaction)
{
cmd.Transaction = (IBM.Data.Informix.IfxTransaction)transaction;
}
try
{
DataTable dt = new DataTable();
adapter.Fill(dt);
if (dt.Rows.Count > 0)
{
r = dt.Rows[0];
}
else
{
r = null;
}
if (parameters != null && parameters.Length > 0)
{
this.ReturnParameters(cmd, parameters);
}
return(r);
}
catch (Exception err)
{
throw new EntityException(err.Message);
}
finally
{
cmd.Dispose();
cmd = null;
adapter.Dispose();
adapter = null;
}
}
public static DataTable ExecuteQuery(IfxCommand command, IfxConnection conn, IfxTransaction trans)
{
DataTable result = new DataTable();
command.Connection = conn;
command.Transaction = trans;
IBM.Data.Informix.IfxDataAdapter datoIFX = default(IBM.Data.Informix.IfxDataAdapter);
datoIFX = new IfxDataAdapter();
datoIFX.SelectCommand = command;
datoIFX.Fill(result);
datoIFX.Dispose();
return(result);
}
/// <summary>
/// 返回一个IDataAdpter
/// </summary>
/// <param name="commandText">SQL语句字符串</param>
/// <param name="timeOut">超时限制</param>
/// <returns></returns>
public override DbDataAdapter GetAdapter(string commandText, int timeOut)
{
IBM.Data.Informix.IfxDataAdapter adapter = new IBM.Data.Informix.IfxDataAdapter();
IBM.Data.Informix.IfxCommand cmd = new IBM.Data.Informix.IfxCommand(commandText);
adapter.SelectCommand = (IBM.Data.Informix.IfxCommand)cmd;
cmd.Connection = (IBM.Data.Informix.IfxConnection)connection;
if (timeOut > 30)
{
cmd.CommandTimeout = timeOut;
}
if (isInTransaction)
{
cmd.Transaction = (IBM.Data.Informix.IfxTransaction)transaction;
}
return(adapter);
}
//EJECUTA UN QUERY
public static DataTable ExecuteQuery(IfxCommand command, string chain)
{
DataTable result = new DataTable();
IfxConnection conexionIFX = new IfxConnection();
IBM.Data.Informix.IfxDataAdapter datoIFX = default(IBM.Data.Informix.IfxDataAdapter);
conexionIFX = new IfxConnection(chain);
conexionIFX.Open();
command.Connection = conexionIFX;
datoIFX = new IfxDataAdapter();
datoIFX.SelectCommand = command;
datoIFX.Fill(result);
datoIFX.Dispose();
conexionIFX.Close();
return(result);
}
/// <summary>
/// 返回一个DataRow
/// </summary>
/// <param name="commandText">SQL语句字符串</param>
/// <param name="timeOut">超时限制</param>
/// <returns></returns>
public override DataRow GetDataRow(string commandText, int timeOut)
{
IBM.Data.Informix.IfxCommand cmd = new IBM.Data.Informix.IfxCommand(commandText);
cmd.Connection = (IBM.Data.Informix.IfxConnection) this.connection; //添加连接
if (timeOut > 30)
{
cmd.CommandTimeout = timeOut;
}
DataRow r;
IBM.Data.Informix.IfxDataAdapter adapter = new IBM.Data.Informix.IfxDataAdapter();
adapter.SelectCommand = (IBM.Data.Informix.IfxCommand)cmd;
if (isInTransaction)
{
cmd.Transaction = (IBM.Data.Informix.IfxTransaction)transaction;
}
try
{
DataTable dt = new DataTable();
adapter.Fill(dt);
if (dt.Rows.Count > 0)
{
r = dt.Rows[0];
}
else
{
r = null;
}
return(r);
}
catch (Exception err)
{
throw new EntityException(err.Message);
}
finally
{
cmd.Dispose();
cmd = null;
adapter.Dispose();
adapter = null;
}
}
/// <summary>
/// 返回一个DataTable
/// </summary>
/// <param name="procedureName">存储过程名称</param>
/// <param name="parameters">参数名称</param>
/// <param name="timeOut">超时时间</param>
/// <returns></returns>
public override DataTable GetDataTable(string procedureName, ParameterEx[] parameters, int timeOut)
{
IDbCommand cmd = this.GetCommand();
cmd.Connection = this.connection;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = procedureName;
cmd.CommandTimeout = timeOut;
if (parameters != null && parameters.Length > 0)
{
SetParameters(cmd, parameters);
}
if (isInTransaction)
{
cmd.Transaction = (IBM.Data.Informix.IfxTransaction)transaction;
}
IBM.Data.Informix.IfxDataAdapter adapter = new IBM.Data.Informix.IfxDataAdapter((IBM.Data.Informix.IfxCommand)cmd);
DataTable dt = new DataTable();
try
{
adapter.Fill(dt);
return(dt);
}
catch (Exception err)
{
throw new Exception(err.Message);
}
finally
{
cmd.Dispose();
adapter.Dispose();
}
}
/// <summary>
/// 返回一个DataRow
/// </summary>
/// <param name="cmd">IDbCommand对象</param>
/// <returns></returns>
public override DataRow GetDataRow(IDbCommand cmd)
{
cmd.Connection = this.connection; //添加连接
DataRow r;
IBM.Data.Informix.IfxDataAdapter adapter = new IBM.Data.Informix.IfxDataAdapter();
adapter.SelectCommand = (IBM.Data.Informix.IfxCommand)cmd;
if (isInTransaction)
{
cmd.Transaction = (IBM.Data.Informix.IfxTransaction)transaction;
}
try
{
DataTable dt = new DataTable();
adapter.Fill(dt);
if (dt.Rows.Count > 0)
{
r = dt.Rows[0];
}
else
{
r = null;
}
return(r);
}
catch (Exception err)
{
throw new EntityException(err.Message);
}
finally
{
adapter.Dispose();
adapter = null;
}
}