protected void Page_Load(object sender, EventArgs e)
        {
            DBConn oConn = new DBConn();

            if (oConn.Open())
            {
                cLogEventos oLogEventos = new cLogEventos(ref oConn);
                DataTable   dt          = oLogEventos.Get();

                XLWorkbook wb = new XLWorkbook();
                wb.Worksheets.Add(dt, "LogEventos");
                oConn.Close();

                Response.Clear();
                Response.Buffer      = true;
                Response.Charset     = "";
                Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
                Response.AddHeader("content-disposition", "attachment;filename=SqlExport.xlsx");
                using (MemoryStream MyMemoryStream = new MemoryStream())
                {
                    wb.SaveAs(MyMemoryStream);
                    MyMemoryStream.WriteTo(Response.OutputStream);
                    Response.Flush();
                    Response.End();
                }
            }
        }
Exemple #2
0
        protected void RadGrid1_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
        {
            DBConn oConn = new DBConn();

            if (oConn.Open())
            {
                cLogEventos oLogEventos = new cLogEventos(ref oConn);
                oLogEventos.NkeyDeudor = hdd_nkey_deudor.Value;
                oLogEventos.NoContrato = txt_no_contrato.Text;
                oLogEventos.CodFlujo   = dropdownflujo.SelectedValue;

                if ((RadDatePicker1.SelectedDate != null) && (RadDatePicker2.SelectedDate != null))
                {
                    oLogEventos.FchDesdeLog = RadDatePicker1.SelectedDate.Value.ToString("yyyyMMdd") + " 00:00:00";
                    oLogEventos.FchHastaLog = RadDatePicker2.SelectedDate.Value.ToString("yyyyMMdd") + " 23:59:59";
                }

                RadGrid1.DataSource = oLogEventos.Get();
            }
            oConn.Close();
        }
        public void ProcessRequest(HttpContext context)
        {
            DBConn oConn = new DBConn();

            if (oConn.Open())
            {
                cLogEventos oLogEventos = new cLogEventos(ref oConn);
                oLogEventos.NkeyDeudor = oWeb.GetData("sNkeyDeudor");
                oLogEventos.NoContrato = oWeb.GetData("sNoContrato");
                oLogEventos.CodFlujo   = oWeb.GetData("sCodFlujo");

                if ((!string.IsNullOrEmpty(oWeb.GetData("sRadDatePicker1"))) && (!string.IsNullOrEmpty(oWeb.GetData("sRadDatePicker2"))))
                {
                    oLogEventos.FchDesdeLog = oWeb.GetData("sRadDatePicker1");
                    oLogEventos.FchHastaLog = oWeb.GetData("sRadDatePicker2");
                }
                DataTable dt = oLogEventos.Get();

                XLWorkbook wb = new XLWorkbook();
                wb.Worksheets.Add(dt, "LogEventos");
                oConn.Close();

                context.Response.Clear();
                context.Response.Buffer      = true;
                context.Response.Charset     = "";
                context.Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
                context.Response.AddHeader("content-disposition", "attachment;filename=LogEventos.xlsx");
                using (MemoryStream MyMemoryStream = new MemoryStream())
                {
                    wb.SaveAs(MyMemoryStream);
                    MyMemoryStream.WriteTo(context.Response.OutputStream);
                    context.Response.Flush();
                    context.Response.End();
                }
            }
        }