protected void ibExportToExcel_Click(object sender, ImageClickEventArgs e)
{
GridView dw = new GridView();
DataTable dt = new DataTable();
DataTable dtgrilla = (DataTable)Session[_nameSessionData];
dw.DataSource = dtgrilla;
dw.DataBind();
//for (int i = 0; dtgrilla.Columns.Count > i; ++i)
//{
// dt.Columns.Add(dtgrilla.Columns[i].ColumnName);
//}
////foreach (DataRow vfila in dtgrilla)
//dw = gvclientes;
dw.AllowPaging = false;
GridViewExportUtil.removeFormats(ref dw);
dw.DataBind();
string nameFile = "Clientes";
// pass the grid that for exporting ...
GridViewExportUtil.Export(nameFile + ".xls", dw, true);
}
/// <summary>
/// Click boton de export grid a archivo de excel
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ibExportToExcel_Click(object sender, ImageClickEventArgs e)
{
gvSepLiq.AllowPaging = false;
GridViewExportUtil.removeFormats(ref gvSepLiq);
gridStatus();
// pass the grid that for exporting ...
GridViewExportUtil.Export("LiquidacionesSeparAQUARELLAs.xls", gvSepLiq);
}
/// <summary>
/// Exportar a excel
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ibExportToExcel_Click(object sender, ImageClickEventArgs e)
{
gvReturns.AllowPaging = false;
GridViewExportUtil.removeFormats(ref gvReturns);
gvReturns.DataBind();
string nameFile = "ComisionLider";
// pass the grid that for exporting ...
GridViewExportUtil.Export(nameFile + ".xls", gvReturns);
}
protected void ibExportToExcel_Click(object sender, ImageClickEventArgs e)
{
gvped.AllowPaging = false;
GridViewExportUtil.removeFormats(ref gvped);
gvped.DataBind();
string nameFile = "HistorialPedido";
// pass the grid that for exporting ...
GridViewExportUtil.Export(nameFile + ".xls", gvped);
}
/// <summary>
/// Click boton de export grid a archivo de excel
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ibExportToExcel_Click(object sender, ImageClickEventArgs e)
{
gvListPays.AllowPaging = false;
GridViewExportUtil.removeFormats(ref gvListPays);
gvListPays.DataBind();
string nameFile = "ListPayments_" + DateTime.Now;
// pass the grid that for exporting ...
GridViewExportUtil.Export(nameFile + ".xls", gvListPays);
}
//protected void gdlista_PageIndexChanging1(object sender, System.Web.UI.WebControls.GridViewPageEventArgs e)
//{
// gdlista.PageIndex = e.NewPageIndex;
// gdlista.DataSource = (DataTable)Session[_nameSessionData];
// gdlista.DataBind();
//}
#region Exportar Excel
protected void ibExportToExcel_Click(object sender, ImageClickEventArgs e)
{
gdlista.AllowPaging = false;
GridViewExportUtil.removeFormats(ref gdlista);
gdlista.DataBind();
string nameFile = "Listalideres";
// pass the grid that for exporting ...
GridViewExportUtil.Export(nameFile + ".xls", gdlista);
}
protected void ibExportToExcel_Click(object sender, ImageClickEventArgs e)
{
gvReturns.AllowPaging = false;
GridViewExportUtil.removeFormats(ref gvReturns);
gvReturns.DataBind();
string nameFile = "VentaLiderResumido";
Decimal[] columna = { 1 };
// pass the grid that for exporting ...
GridViewExportUtil.Export(nameFile + ".xls", gvReturns, false, columna);
}
protected void ibExportToExcel_Click(object sender, ImageClickEventArgs e)
{
gvReturns.AllowPaging = false;
GridViewExportUtil.removeFormats(ref gvReturns);
gvReturns.DataSource = (DataTable)Session[_nameSessionData];
gvReturns.DataBind();
string nameFile = "VentaLiderNuevos";
// pass the grid that for exporting ...
GridViewExportUtil.Export(nameFile + ".xls", gvReturns);
}
protected void ibExportToExcel_Click(object sender, ImageClickEventArgs e)
{
gvReturns.DataSource = (DataTable)Session[_nameSessDatavenazonaconsulta];
gvReturns.AllowPaging = false;
GridViewExportUtil.removeFormats(ref gvReturns);
gvReturns.DataBind();
string nameFile = "ventadet_cn";
Decimal[] columna = { 1 };
// pass the grid that for exporting ...
GridViewExportUtil.Export(nameFile + ".xls", gvReturns, false, columna);
}
protected void ibExportToExcel_Click(object sender, ImageClickEventArgs e)
{
gvReturns.AllowPaging = false;
GridViewExportUtil.removeFormats(ref gvReturns);
gvReturns.DataSource = (DataSet)Session[_nameSessionData];
gvReturns.DataBind();
string nameFile = "PremiosContinuo";
decimal[] columna = { 3 };
// pass the grid that for exporting ...
GridViewExportUtil.Export(nameFile + ".xls", gvReturns, false, columna);
}
protected void ibExportToExcel_Click(object sender, ImageClickEventArgs e)
{
gvReturns.DataSource = (DataTable)Session[_nameSessionData];
gvReturns.AllowPaging = false;
GridViewExportUtil.removeFormats(ref gvReturns);
gvReturns.DataBind();
string nameFile = "pago_mov";
Decimal[] _columna_caracter = { 1, 3, 5 };
// pass the grid that for exporting ...
GridViewExportUtil.Export(nameFile + ".xls", gvReturns, false, _columna_caracter);
}
protected void ibExportToExcel_Click(object sender, ImageClickEventArgs e)
{
gvrel_lider.DataSource = (DataTable)Session[_nameSessData_lider_asesor];
gvrel_lider.AllowPaging = false;
GridViewExportUtil.removeFormats(ref gvrel_lider);
gvrel_lider.DataBind();
string nameFile = "Asesor-Lider";
Decimal[] _columna_caracter = { 0 };
// pass the grid that for exporting ...
GridViewExportUtil.Export(nameFile + ".xls", gvrel_lider, false, _columna_caracter);
}
protected void ibExportToExcel_Click(object sender, ImageClickEventArgs e)
{
gvDocTrans.DataSource = Session[_nameSessionData];
gvDocTrans.AllowPaging = false;
GridViewExportUtil.removeFormats(ref gvDocTrans);
this.gvDocTrans.DataBind();
//gvDocTrans.DataBind();
string nameFile = "Asientos_AQ";
// pass the grid that for exporting ...
GridViewExportUtil.Export(nameFile + ".xls", gvDocTrans);
}
/// <summary>
/// Exportar Grid a Excel
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ibExportToExcel_Click(object sender, ImageClickEventArgs e)
{
gvLiqs.AllowPaging = false;
gvLiqs.ShowFooter = false;
GridViewExportUtil.removeFormats(ref gvLiqs);
gvLiqs.DataSourceID = string.Empty;
DataTable dt = (DataTable)Session[_nameSessDataOri];
gvLiqs.DataSource = dt;
gvLiqs.DataBind();
// pass the grid that for exporting ...
GridViewExportUtil.Export("Info_Liq_" + DateTime.Today.ToShortDateString() + "_.xls", gvLiqs);
}
/// <summary>
/// Exportar Grid a Excel
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ibExportToExcel_Click(object sender, ImageClickEventArgs e)
{
gvPays.AllowPaging = false;
gvPays.ShowFooter = false;
GridViewExportUtil.removeFormats(ref gvPays);
gvPays.DataSourceID = string.Empty;
DataTable dt = (DataTable)Session[_nameSessionData];
gvPays.DataSource = dt;
gvPays.DataBind();
// pass the grid that for exporting ...
GridViewExportUtil.Export("Payments_.xls", gvPays);
}
protected void ibExportToExcel_Click(object sender, ImageClickEventArgs e)
{
//gvSepLiq.AllowPaging = false;
//GridViewExportUtil.removeFormats(ref gvSepLiq);
//gridStatus();
//// pass the grid that for exporting ...
//GridViewExportUtil.Export("LiquidacionesSeparAQUARELLAs.xls", gvSepLiq);
// gvReturns.DataSource = Session[_nameSessionData];
// gvReturns.DataBind();
gvReturns.AllowPaging = false;
GridViewExportUtil.removeFormats(ref gvReturns);
gridStatus();
// pass the grid that for exporting ...
GridViewExportUtil.Export("liquidespacho.xls", gvReturns);
}
protected void ibExportToExcel_Click(object sender, ImageClickEventArgs e)
{
gvReturns.DataSource = (DataTable)Session[_nameSessionData];
gvReturns.AllowPaging = false;
GridViewExportUtil.removeFormats(ref gvReturns);
gvReturns.DataBind();
string nameFile = "VentaSemanalFz";
Decimal[] _columna_caracter = { 1 };
// pass the grid that for exporting ...
GridViewExportUtil.Export(nameFile + ".xls", gvReturns, false, _columna_caracter);
//this.Session[this._nombreSession] = null;
//sbcargarcrystal();
}
/// <summary>
/// Click boton de export grid a archivo de excel
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ibExportToExcel_Click(object sender, ImageClickEventArgs e)
{
gvSales.AllowPaging = false;
GridViewExportUtil.removeFormats(ref gvSales);
gridStatus();
string nameFile;
if (chkGroupByWeek.Checked)
{
nameFile = "VentaxCategoriaxSemana";
}
else
{
nameFile = "VentaxCategoria";
}
// pass the grid that for exporting ...
GridViewExportUtil.Export(nameFile + ".xls", gvSales);
}