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";
}
}
