protected void btnBuscarDesdeHasta_Click(object sender, EventArgs e) { SisPackController.AdministrarGrillas.Configurar(this.dtgBuenasPracticasEmitidas, "buenaspracticasemisionid", 15); IBuenasPracticas buenaspracticas = BuenasPracticasFactory.GetBuenasPracticas(); DataSet ds = new DataSet(); buenaspracticas.MovilID = Convert.ToInt32(this.ddlMoviles.SelectedValue); string desde = this.txtFiltroDesde.Text; string hasta = this.txtFiltroHasta.Text; DateTime desdeDateTime = DateTime.ParseExact(desde, "dd/MM/yyyy", CultureInfo.InvariantCulture); DateTime hastaDateTime = DateTime.ParseExact(hasta, "dd/MM/yyyy", CultureInfo.InvariantCulture); buenaspracticas.FechaDesde = desdeDateTime; buenaspracticas.FechaHasta = hastaDateTime; ds = buenaspracticas.GetBuenasPracticasEmitidas(); this.dtgBuenasPracticasEmitidas.DataSource = ds.Tables[0]; this.dtgBuenasPracticasEmitidas.CurrentPageIndex = 0; this.dtgBuenasPracticasEmitidas.DataBind(); Session.Remove("DsGridView"); this.Session["DsGridView"] = ds; //this.Session["DsGridView"] = ds; }
private void BindGrid(int currentPage) { SisPackController.AdministrarGrillas.Configurar(this.dtgBuenasPracticasEmitidas, "buenaspracticasemisionid", 15); IBuenasPracticas buenaspracticas = BuenasPracticasFactory.GetBuenasPracticas(); DataSet ds = new DataSet(); ds = buenaspracticas.GetBuenasPracticasEmitidas(); this.dtgBuenasPracticasEmitidas.DataSource = ds.Tables[0]; this.dtgBuenasPracticasEmitidas.CurrentPageIndex = currentPage; this.dtgBuenasPracticasEmitidas.DataBind(); //this.Session["DsGridView"] = ds; }
protected void ddlMoviles_SelectedIndexChanged(object sender, EventArgs e) { this.txtFiltroDesde.Text = ""; this.txtFiltroHasta.Text = ""; SisPackController.AdministrarGrillas.Configurar(this.dtgBuenasPracticasEmitidas, "buenaspracticasemisionid", 15); IBuenasPracticas buenaspracticas = BuenasPracticasFactory.GetBuenasPracticas(); DataSet ds = new DataSet(); buenaspracticas.MovilID = Convert.ToInt32(this.ddlMoviles.SelectedValue); ds = buenaspracticas.GetBuenasPracticasEmitidas(); this.dtgBuenasPracticasEmitidas.DataSource = ds.Tables[0]; this.dtgBuenasPracticasEmitidas.CurrentPageIndex = 0; this.dtgBuenasPracticasEmitidas.DataBind(); Session.Remove("DsGridView"); this.Session["DsGridView"] = ds; }
protected void btnExportarExcel_Click(object sender, EventArgs e) { SisPackController.AdministrarGrillas.Configurar(this.dtgBuenasPracticasEmitidas, "buenaspracticasemisionid", 15, true, false); dtgBuenasPracticasEmitidas.FooterStyle.CssClass = "TextoGrilla"; dtgBuenasPracticasEmitidas.AllowPaging = false; int mov1 = 0; int mov2 = 0; int DtoCreditos = 0; decimal DtoConAyudante = 0; decimal DtoSinAyudante = 0; if (Session["DsGridView"] != null) { DataSet ds = new DataSet(); ds = Session["DsGridView"] as DataSet; if (ds.Tables[0].Rows.Count != 0) { ds.Tables[0].Columns.RemoveAt(9); dtgBuenasPracticasEmitidas.Columns.RemoveAt(9); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { mov1 = Convert.ToInt32(ds.Tables[0].Rows[0]["movilid"]); mov2 = Convert.ToInt32(ds.Tables[0].Rows[i]["movilid"]); string aa = ds.Tables[0].Rows[i]["descontar"].ToString(); if (mov2 == mov1) { if (aa == "Si") { DtoCreditos += Convert.ToInt32(ds.Tables[0].Rows[i]["DtoCreditos"]); DtoConAyudante += Convert.ToDecimal(ds.Tables[0].Rows[i]["DtoConAyudante"]); DtoSinAyudante += Convert.ToDecimal(ds.Tables[0].Rows[i]["DtoSinAyudante"]); } } } DataRow dr = null; dr = ds.Tables[0].NewRow(); dr["Descontar"] = "TOTAL: "; dr["DtoCreditos"] = DtoCreditos; dr["DtoConAyudante"] = DtoConAyudante; dr["DtoSinAyudante"] = DtoSinAyudante; ds.Tables[0].Rows.Add(dr); this.dtgBuenasPracticasEmitidas.DataSource = ds; this.dtgBuenasPracticasEmitidas.CurrentPageIndex = 0; this.dtgBuenasPracticasEmitidas.DataBind(); new Utiles.DataGridExcelExporter(dtgBuenasPracticasEmitidas, "Buenas Practicas Emitidas").Export("BuenasPracticasExcel.xls"); Session.Remove("DsGridView"); } } else { IBuenasPracticas buenaspracticas = BuenasPracticasFactory.GetBuenasPracticas(); DataSet ds = new DataSet(); ds = buenaspracticas.GetBuenasPracticasEmitidas(); ds.Tables[0].Columns.RemoveAt(9); dtgBuenasPracticasEmitidas.Columns.RemoveAt(9); this.dtgBuenasPracticasEmitidas.CurrentPageIndex = 0; this.dtgBuenasPracticasEmitidas.DataSource = ds; this.dtgBuenasPracticasEmitidas.DataBind(); new Utiles.DataGridExcelExporter(dtgBuenasPracticasEmitidas, "Buenas Practicas Emitidas").Export("BuenasPracticasExcel.xls"); } }