protected void sbconsultar()
{
try
{
//Session[_nameSessionData]= Lider.Lider.fget_afiliados(Convert.ToDateTime(txtDateStart.Text), Convert.ToDateTime(txtDateEnd.Text)).Tables[0];
msnMessage.Visible = false;
DataSet dsreturn = Facturacion.Get_VentaSemanal(Convert.ToDateTime(txtDateStart.Text), Convert.ToDateTime(txtDateEnd.Text));
Pivot pvt = new Pivot(dsreturn.Tables[0]);
//string[] fila = { };
string[] fila = { "AQ" };
//string[] col = { "Ano","Mes","Semana", "Dia" };
string[] col = { "anio", "Mes", "dia" };
gvReturns.DataSource = pvt.PivotData("Total", AggregateFunction.Sum, fila, col);
gvReturns.DataBind();
// MergeRows(gvReturns, 2);
Session[_nameSessionData] = dsreturn.Tables[0];
//gvReturns.DataSource = Documents_Trans.get_reportsemana(Convert.ToDateTime(txtDateStart.Text), Convert.ToDateTime(txtDateEnd.Text)).Tables[0];// (DataTable)Session[_nameSessionData];
//gvReturns.DataBind();
//Session[_nameSessionData] = gvReturns.DataSource;
//MergeRows(gvReturns, 4);
}
catch (Exception ex)
{
msnMessage.Visible = true;
msnMessage.LoadMessage(ex.Message, UserControl.ucMessage.MessageType.Error);
}
}