private void llenaDesglose(string isla, string fecha, string cierreSelect) { string sql = "select c.usuario,count(c.id_caja)as id_cajaS," + " (u.nombre + ' ' + u.apellido_pat + ' ' + isnull(u.apellido_mat, '')) as nombre," + " sum(c.efectivo) as efectivoS ,sum(c.t_credito) as t_creditoS,sum(c.t_debito) as t_debitoS,sum(c.t_gastos) as t_gastosS,sum(c.t_cancelacion) as t_cancelacion," + " (sum(c.efectivo) + sum(c.t_credito) + sum(c.t_debito) - sum(c.t_gastos) - sum(c.t_cancelacion)) as total,c.recargas,c.pagoServicios,c.ventaTaller,c.ventaCredito " + " from cajas c" + " inner join usuarios_PV u on u.usuario = c.usuario" + " where c.id_cierre = " + cierreSelect + " and c.id_punto = " + isla + " GROUP BY c.usuario,u.nombre,u.apellido_pat,u.apellido_mat,c.recargas,c.pagoServicios"; BaseDatos ejecuta = new BaseDatos(); DataSet data = new DataSet(); object[] ejecutado = ejecuta.scalarData(sql); if ((bool)ejecutado[0]) { data = (DataSet)ejecutado[1]; } else { data = null; } lblCierreSelect.Text = "No. Cierre: " + cierreSelect; GridDesglose.Visible = true; GridDesglose.DataSource = data; GridDesglose.DataBind(); }
protected void btnBuscar_Click(object sender, EventArgs e) { cargaGrid(); GridDesglose.DataSource = null; GridDesglose.DataBind(); GridDesglose.Visible = false; lblCierreSelect.Text = "Seleccione No. Cierre"; lblError.Text = ""; }
protected void GridCierre_PageIndexChanging(object sender, GridViewPageEventArgs e) { lblError.Text = ""; GridCierre.PageIndex = e.NewPageIndex; cargaGrid(); GridDesglose.DataSource = null; GridDesglose.DataBind(); GridDesglose.Visible = false; lblCierreSelect.Text = "Seleccione No. Cierre"; }
protected void Page_Load(object sender, EventArgs e) { GridCierre.EmptyDataText = "No hay cierres de caja para mostrar."; if (!IsPostBack) { txtFechaFin.Text = fechas.obtieneFechaLocal().ToString("yyyy-MM-dd"); txtFechIni.Text = fechas.obtieneFechaLocal().ToString("yyyy-MM-dd"); lblError.Text = ""; cargaGrid(); GridDesglose.DataSource = null; GridDesglose.DataBind(); GridDesglose.Visible = false; lblCierreSelect.Text = "Seleccione No. Cierre"; lblError.Text = ""; } }
protected void GridDesglose_PageIndexChanging(object sender, GridViewPageEventArgs e) { try { GridDesglose.PageIndex = e.NewPageIndex; string fecha = Session["fechaDesglose"].ToString(); string isla = Session["islaDesglose"].ToString(); string cierreSelect = Session["cierreSelectDesglose"].ToString(); llenaDesglose(isla, fecha, cierreSelect); } catch (Exception) { cargaGrid(); GridDesglose.DataSource = null; GridDesglose.DataBind(); GridDesglose.Visible = false; lblCierreSelect.Text = "Seleccione No. Cierre"; } }