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