private void button2_Click(object sender, EventArgs e) // boton de ventas de dias anteriores
{
controles(false, false, 829, 429);
string[] fecha_separada = calendario.Value.ToShortDateString().Split('/');
string ventas_t = "SELECT DATE_FORMAT(fyh,'%Y/%M/%d') as fecha,SUM(totalVenta) as total,SUM(tarjeta) as tarjeta FROM detalles_pagos d, venta v WHERE d.folio_venta=v.folio_venta GROUP BY month(fyh),year(fyh),day(fyh)";
funcionesSQL.llenartabla(dataGridView1, ventas_t);
}
private void Productos_Load(object sender, EventArgs e)
{
string cadena = "SELECT a.id_producto as id_prod,a.id_articulo as id_art,nombre,descripcion,categoria,precio FROM producto p,articulos a,categoria c,clasificacion cl WHERE a.id_cat=c.id_cat AND a.id_producto=p.id_producto AND cl.id_clase=p.clase ORDER BY a.id_producto,a.id_articulo";
funciones.llenartabla(dataGridView1, cadena);
dataGridView1.Columns[0].SortMode = DataGridViewColumnSortMode.NotSortable;
dataGridView1.Columns[1].SortMode = DataGridViewColumnSortMode.NotSortable;
dataGridView1.Columns[2].SortMode = DataGridViewColumnSortMode.NotSortable;
dataGridView1.Columns[3].SortMode = DataGridViewColumnSortMode.NotSortable;
dataGridView1.Columns[4].SortMode = DataGridViewColumnSortMode.NotSortable;
dataGridView1.Columns[0].Width = 60;
dataGridView1.Columns[1].Width = 60;
dataGridView1.Columns[4].DefaultCellStyle.Format = "C2";
}