protected void BtnExcel_Click(object sender, EventArgs e)
{
Db.DAOrdenes OBJ = new Db.DAOrdenes();
//GcExportar.DataSource = OBJ.Reporte(txtOrden.Value.Trim(), ddlTipoResultado.SelectedValue.ToString(),
//datavalue.Value.ToString(), datavalue2.Value.ToString(), ddlMotorizado.SelectedValue.ToString(), ddlSucursal.SelectedValue.ToString());
//GcExportar.DataBind();
DataTable dt_report = new DataTable();
dt_report = OBJ.Reporte(txtOrden.Value.Trim(), ddlTipoResultado.SelectedValue.ToString(),
datavalue.Value.ToString(), datavalue2.Value.ToString(), ddlMotorizado.SelectedValue.ToString(), ddlSucursal.SelectedValue.ToString());
ClosedXML.Excel.XLWorkbook wbook = new ClosedXML.Excel.XLWorkbook();
wbook.Worksheets.Add(dt_report, "reporte");
// Preparar la respuesta
HttpResponse httpResponse = Response;
httpResponse.Clear();
httpResponse.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
// Proporcione su nombre de archivo aquí
httpResponse.AddHeader("content-disposition", "attachment;filename=\"Reporte_Pedido " + DateTime.Now + ".xlsx\"");
//Vacíe el libro de trabajo al Response.OutputStream
using (MemoryStream memoryStream = new MemoryStream())
{
wbook.SaveAs(memoryStream);
memoryStream.WriteTo(httpResponse.OutputStream);
memoryStream.Close();
}
httpResponse.End();
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "tipoTrans")
{
Int32 Indice = int.Parse(e.CommandArgument.ToString());
String IdOrden = (GridView1.Rows[Indice].Cells[0].Text).ToString();
Db.DAOrdenes OBJ = new Db.DAOrdenes();
GVDETALLE.DataSource = OBJ.ListarDetalle(IdOrden.ToString());
GVDETALLE.DataBind();
string script = @"<script type=text/javascript> showPopup()</script>";
ScriptManager.RegisterStartupScript(this, typeof(Page), "myScript", script, false);
}
}
public void ListarOrdenes(String idorden, String idTipoResultado, String FecpedidoI, String FecPedidoF, String Conductor, String sucursal)
{
DataTable dt = new DataTable();
try
{
Db.DAOrdenes OBJ = new Db.DAOrdenes();
dt = OBJ.ListarOrdenes(idorden, idTipoResultado, FecpedidoI, FecPedidoF, Conductor, sucursal);
GridView1.DataSource = dt;
GridView1.DataBind();
//GcExportar.DataSource = OBJ.Reporte(idorden, idTipoResultado, FecpedidoI, FecPedidoF, Conductor, sucursal);
//GcExportar.DataBind();
}
catch (Exception ex)
{
}
}
