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