public override DataTable ImplementReport(DateTime inicio, DateTime final)
{
base.query = ReportsOperations.GetQueryReportsApproved("4", inicio, final);
base.cmd = new SqlCommand(base.query, base.conn);
try
{
base.conn.Open();
base.reader = base.cmd.ExecuteReader();
base.data.Load(base.reader);
}
catch (Exception ex)
{
throw ex;
}
finally
{
base.conn.Close();
}
return(base.data);
}
public override DataTable ImplementReport(DateTime inicio, DateTime final)
{
base.query = ReportsOperations.GetQueryReportsApproved("1", inicio, final);
//base.query = String.Format(@"select * from xvr_ReportCNBVRelevantes where [FECHA DE LA OPERACION] between '{0}' and '{1}'",
// inicio.ToString("yyyy-MM-dd HH:mm:ss.fff"), final.ToString("yyyy-MM-dd HH:mm:ss.fff"));
base.cmd = new SqlCommand(base.query, base.conn);
try
{
base.conn.Open();
base.cmd.CommandTimeout = 0;
base.reader = base.cmd.ExecuteReader();
base.data.Load(base.reader);
}
catch (Exception ex)
{
throw ex;
}
finally
{
base.conn.Close();
}
return(base.data);
}