protected void btnbuscar_Click(object sender, EventArgs e) { PanillaDAO db = new PanillaDAO(); string fi = txtfechainicia.Text; string ff = txtfechafinal.Text; if (txtzonmer.Text.Length == 1) { grvplanilla.DataSource = db.BuscarxZona(txtzonmer.Text, fi, ff); grvplanilla.DataBind(); } else if (txtzonmer.Text.Length == 2) { string zona = txtzonmer.Text.Substring(0, 1); string mercado = txtzonmer.Text.Substring(1, 1); grvplanilla.DataSource = db.BuscarxZonaMercado(zona, mercado, fi, ff); grvplanilla.DataBind(); } else { txtmensaje.Text = ""; txtmensaje.Text = "Debe ingresar la zona o el mercado."; string script = "openModal();"; ScriptManager.RegisterStartupScript(this, typeof(Page), "error", script, true); } lbltotal.Text = ""; }
protected void grvplanilla_RowCommand(object sender, GridViewCommandEventArgs e) { try { int fila = Convert.ToInt32(e.CommandArgument); if (e.CommandName == "Eliminar") { int id = Convert.ToInt32(grvplanilla.Rows[fila].Cells[0].Text); PagoDAO pg = new PagoDAO(); PanillaDAO db = new PanillaDAO(); pg.Eliminar(id); db.Eliminar(id); cargar(); } else if (e.CommandName == "Agregar") { int id = Convert.ToInt32(grvplanilla.Rows[fila].Cells[0].Text); int cliente = Convert.ToInt32(grvplanilla.Rows[fila].Cells[1].Text); Response.Redirect("Agregar.aspx?ID=" + id + "&Cl=" + cliente, true); } } catch (Exception ex) { throw ex; } }
void listar() { PanillaDAO db = new PanillaDAO(); grvplanilla.DataSource = db.ListarPlanilla(); grvplanilla.DataBind(); }
protected void ddlclie_SelectedIndexChanged(object sender, EventArgs e) { PanillaDAO db = new PanillaDAO(); string id = ddlclie.SelectedValue; txtnumero.Text = ""; grvplanilla.DataSource = db.Buscarxcliente(id); grvplanilla.DataBind(); }
protected void txtnumero_TextChanged(object sender, EventArgs e) { PanillaDAO db = new PanillaDAO(); string id = txtnumero.Text; ddlclie.SelectedValue = "0"; grvplanilla.DataSource = db.Buscarxnumeropedido(id); grvplanilla.DataBind(); }