} // private bool CuadrarFila private void btnLISTAR_Click(object sender, EventArgs e) { string gIdent = this.GetType().FullName + " " + System.Reflection.MethodBase.GetCurrentMethod().Name + " "; try { GloblaVar.TIPO_REPORT = 6; // Listado de CUADRE DEL DIA GloblaVar.sQReport = ""; GloblaVar.sQReport = "(ISNULL({Comando.F_Cuadre}) "; GloblaVar.sQReport += " OR "; GloblaVar.sQReport += "{Comando.F_Cuadre}=#" + dtpFecha.Value.ToString("M/dd/yyyy") + "#)"; //GloblaVar.sQReport += " AND "; GloblaVar.sQReport += " AND "; //GloblaVar.sQReport += "({Comando.C_Prov}<97)"; //GloblaVar.sQReport+=" AND "; GloblaVar.sQReport += "( {Comando.C_Art}<7000)"; //GloblaVar.sQReport += " {comando.ProCod} IN " + tProvIni.Text + " TO " + tProvFin.Text; //GloblaVar.sQReport += " AND "; //GloblaVar.sQReport += " {comando.ArtCod} IN " + tArtIni.Text + " TO " + tArtFin.Text; frmCR1 frmREPORT = new frmCR1(); frmREPORT.Show(); } catch (Exception ex) { GloblaVar.gUTIL.ATraza(ex.ToString()); MessageBox.Show(gIdent + " " + ex.ToString()); } //private void dG1_CellValueChanged(object sender, DataGridViewCellEventArgs e) }
} //private void btn_Listar_Albaranes_Click(object sender, EventArgs e) private void btn_Listar_Albaranes_Separ_Click(object sender, EventArgs e) { string gIdent = this.GetType().FullName + " " + System.Reflection.MethodBase.GetCurrentMethod().Name; GloblaVar.gUTIL.ATraza(gIdent + " " + this.GetType().FullName); GloblaVar.TIPO_REPORT = 10; GloblaVar.sQReport = ""; int c_Check = 11; int c_Alb = 0; int c_Año = 1; foreach (DataGridViewRow row in dgVC.Rows) { if (row.Index < dgVC.RowCount && (Funciones.Valor_CheckGrid(row, c_Check) == true)) { if (GloblaVar.sQReport == "") { GloblaVar.sQReport = "({Comando.ComLpa}=" + row.Cells[c_Alb].Value.ToString() + " AND {Comando.Anyo}=" + row.Cells[c_Año].Value.ToString() + ")"; } else { GloblaVar.sQReport += " OR ({Comando.ComLpa}=" + row.Cells[c_Alb].Value.ToString() + " AND {Comando.Anyo}=" + row.Cells[c_Año].Value.ToString() + ")"; } } } //foreach (DataGridViewRow row in dgVC.Rows ) frmCR1 frmREPORT = new frmCR1(); frmREPORT.Show(); } // private void btn_Listar_Albaranes_Separ_Click(object sender, EventArgs e)
private void btn_Listar_Albaranes_Click(object sender, EventArgs e) { GloblaVar.TIPO_REPORT = 9; GloblaVar.sQReport = ""; int c_Check = 11; int c_Alb = 0; int c_Año = 1; foreach (DataGridViewRow row in dgVC.Rows) { if (row.Index < dgVC.RowCount && (Funciones.Valor_CheckGrid(row, c_Check) == true)) { if (GloblaVar.sQReport == "") { GloblaVar.sQReport = "({Comando.ComLpa}=" + row.Cells[c_Alb].Value.ToString() + " AND {Comando.Anyo}=" + row.Cells[c_Año].Value.ToString() + ")"; } else { GloblaVar.sQReport += " OR ({Comando.ComLpa}=" + row.Cells[c_Alb].Value.ToString() + " AND {Comando.Anyo}=" + row.Cells[c_Año].Value.ToString() + ")"; } } } //foreach (DataGridViewRow row in dgVC.Rows ) frmCR1 frmREPORT = new frmCR1(); frmREPORT.Show(); } //private void btn_Listar_Albaranes_Click(object sender, EventArgs e)
} //private void frmSeleccionDatos_Load(object sender, EventArgs e) private void btnF5_Click(object sender, EventArgs e) { string gIdent = this.GetType().FullName + " " + System.Reflection.MethodBase.GetCurrentMethod().Name; GloblaVar.gUTIL.ATraza(gIdent + "Listado Tipo " + GloblaVar.TIPO_REPORT); // Planteamos el query según el TIPO_REPORT que hayamos elegido y llamamos para mostrarlo a frmCR switch (GloblaVar.TIPO_REPORT) { case 1: //Listado de Rendimiento para Carabal GloblaVar.gUTIL.SP2(dateTimePicker_Inicio.Value.Date.ToShortDateString(), dateTimePicker_Fin.Value.ToShortDateString(), int.Parse(tVendedIni.Text), int.Parse(tVendedFin.Text)); GloblaVar.gUTIL.ATraza("btnF5_Click().- Preparada lista con datos para listar "); GloblaVar.sQReport = "{Comando.ArtCod} IN " + tArtIni.Text + " TO " + tArtFin.Text; //MessageBox.Show("HOLA"); break; case 2: //Listado de Ventas de Articulos, Fecha y Detallistas GloblaVar.sQReport = "{Comando.VelFec} in DateTime (" + dateTimePicker_Inicio.Value.Year + "," + dateTimePicker_Inicio.Value.Month + "," + dateTimePicker_Inicio.Value.Day + ",00,00,00 )"; GloblaVar.sQReport += " to DateTime (" + dateTimePicker_Fin.Value.Year + "," + dateTimePicker_Fin.Value.Month + "," + dateTimePicker_Fin.Value.Day + ",00,00,00)"; GloblaVar.sQReport += " AND "; GloblaVar.sQReport += " {comando.DetCod} IN " + tDetIni.Text + " TO " + tDetFin.Text; GloblaVar.sQReport += " AND "; GloblaVar.sQReport += " {comando.ArtCod} IN " + tArtIni.Text + " TO " + tArtFin.Text; break; case 3: //LISTADO DE FACTURAS DE CLIENTES GloblaVar.sQReport = "{Comando.FechaEmision} in DateTime (" + dateTimePicker_Inicio.Value.Year + "," + dateTimePicker_Inicio.Value.Month + "," + dateTimePicker_Inicio.Value.Day + ",00,00,00 )"; GloblaVar.sQReport += " to DateTime (" + dateTimePicker_Fin.Value.Year + "," + dateTimePicker_Fin.Value.Month + "," + dateTimePicker_Fin.Value.Day + ",00,00,00)"; GloblaVar.sQReport += " AND "; GloblaVar.sQReport += " {comando.DetCod} IN " + tDetIni.Text + " TO " + tDetFin.Text; if (OptFacturasCobradas.Checked) { GloblaVar.sQReport += " AND {Comando.ImptePendiente}=0"; } if (OptFactPendientes.Checked) { GloblaVar.sQReport += " AND {Comando.ImptePendiente}>0"; } break; case 4: MessageBox.Show("Nada que Listar"); break; case 5: //Listado de Compras: Fecha, Artículos Proveedores GloblaVar.sQReport = "{Comando.ComCfa} in DateTime (" + dateTimePicker_Inicio.Value.Year + "," + dateTimePicker_Inicio.Value.Month + "," + dateTimePicker_Inicio.Value.Day + ",00,00,00 )"; GloblaVar.sQReport += " to DateTime (" + dateTimePicker_Fin.Value.Year + "," + dateTimePicker_Fin.Value.Month + "," + dateTimePicker_Fin.Value.Day + ",00,00,00)"; GloblaVar.sQReport += " AND "; GloblaVar.sQReport += " {comando.ProCod} IN " + tProvIni.Text + " TO " + tProvFin.Text; GloblaVar.sQReport += " AND "; GloblaVar.sQReport += " {comando.ArtCod} IN " + tArtIni.Text + " TO " + tArtFin.Text; break; case 6: //Listado de Rendimiento para Dialpesca por vendedores GloblaVar.gUTIL.SP2(dateTimePicker_Inicio.Value.Date.ToShortDateString(), dateTimePicker_Fin.Value.ToShortDateString(), int.Parse(tVendedIni.Text), int.Parse(tVendedFin.Text)); GloblaVar.gUTIL.ATraza("btnF5_Click().- Preparada lista con datos para listar "); //GloblaVar.sQReport = "{Comando.ArtCod} IN " + tArtIni.Text + " TO " + tArtFin.Text; break; case 8: //Listado de Stock por Artículos Basado en Partidas GloblaVar.sQReport = "{Comando.ArtCod} IN " + tArtIni.Text + " TO " + tArtFin.Text; if (GloblaVar.gCERCLE_105 == true) { } else { GloblaVar.sQReport += " AND "; GloblaVar.sQReport += " {comando.Stock}>0"; } GloblaVar.sQReport += " AND "; GloblaVar.sQReport += " ISNULL({comando.FCua})"; break; case 9: //Listado de Diferencias de Stock //GloblaVar.gUTIL.SP2( dateTimePicker_Inicio.Value.Date.ToShortDateString(), dateTimePicker_Fin.Value.ToShortDateString(), 0, 0 ) ; GloblaVar.gUTIL.ATraza("btnF5_Click().- Preparada lista con datos para listar Diferencias de Stock "); break; case 11: //Listado de Ventas por Detallistas GloblaVar.sQReport = "{Comando.VelFec} in DateTime (" + dateTimePicker_Inicio.Value.Year + "," + dateTimePicker_Inicio.Value.Month + "," + dateTimePicker_Inicio.Value.Day + ",00,00,00 )"; GloblaVar.sQReport += " to DateTime (" + dateTimePicker_Fin.Value.Year + "," + dateTimePicker_Fin.Value.Month + "," + dateTimePicker_Fin.Value.Day + ",00,00,00)"; break; case 12: //Listado de Compras por Proveedor GloblaVar.sQReport = "{Comando.comcfa} in DateTime (" + dateTimePicker_Inicio.Value.Year + "," + dateTimePicker_Inicio.Value.Month + "," + dateTimePicker_Inicio.Value.Day + ",00,00,00 )"; GloblaVar.sQReport += " to DateTime (" + dateTimePicker_Fin.Value.Year + "," + dateTimePicker_Fin.Value.Month + "," + dateTimePicker_Fin.Value.Day + ",00,00,00)"; break; case 13: GloblaVar.sQReport = "{Comando.VelFec} in DateTime (" + dateTimePicker_Inicio.Value.Year + "," + dateTimePicker_Inicio.Value.Month + "," + dateTimePicker_Inicio.Value.Day + ",00,00,00 )"; GloblaVar.sQReport += " to DateTime (" + dateTimePicker_Fin.Value.Year + "," + dateTimePicker_Fin.Value.Month + "," + dateTimePicker_Fin.Value.Day + ",00,00,00)"; GloblaVar.sQReport += " AND "; GloblaVar.sQReport += " {comando.ProCod} IN " + tProvIni.Text + " TO " + tProvFin.Text; GloblaVar.sQReport += " AND "; GloblaVar.sQReport += " {comando.ArtCod} IN " + tArtIni.Text + " TO " + tArtFin.Text; break; case 14: //Estadisticas de Compras por Proveedor_Artículo para ENDUMAR GloblaVar.sQReport = "{Comando.ComCfa} in DateTime (" + dateTimePicker_Inicio.Value.Year + "," + dateTimePicker_Inicio.Value.Month + "," + dateTimePicker_Inicio.Value.Day + ",00,00,00 )"; GloblaVar.sQReport += " to DateTime (" + dateTimePicker_Fin.Value.Year + "," + dateTimePicker_Fin.Value.Month + "," + dateTimePicker_Fin.Value.Day + ",23,59,59)"; GloblaVar.sQReport += " AND "; GloblaVar.sQReport += " {comando.ProCod} IN " + tProvIni.Text + " TO " + tProvFin.Text; GloblaVar.sQReport += " AND "; GloblaVar.sQReport += " {comando.ArtCod} IN " + tArtIni.Text + " TO " + tArtFin.Text; break; case 15: //Listado de Rendimiento para Valpeix GloblaVar.gUTIL.SP2(dateTimePicker_Inicio.Value.Date.ToShortDateString(), dateTimePicker_Fin.Value.ToShortDateString(), int.Parse(tVendedIni.Text), int.Parse(tVendedFin.Text)); GloblaVar.gUTIL.ATraza("btnF5_Click().- Preparada lista con datos para listar "); GloblaVar.sQReport = "{Comando.ArtCod} IN " + tArtIni.Text + " TO " + tArtFin.Text; //MessageBox.Show("HOLA"); break; } frmCR1 frmREPORT = new frmCR1(); switch (GloblaVar.TIPO_REPORT) { case 4: break; case 6: //Llamada a Rutina o Código para generar fichero Excel con el Listado try { string query = @"SELECT ArtCod as C_Art, ArtDes as Artículo, Vendedor, ProCod as C_Prov, ProNom as Proveedor, DetCod as Cod_Cli, DetNom as Detallista, convert(varchar, FVenta, 103) as F_Venta, KgsVenta as Kgs_Venta, PreVenta as Pr_Venta, PreCompra as Pr_Compra, Partida, PartAnyo as Año_Pda, ImpteVenta as Impte_Venta, ImpteCompra as Impte_Compra, Beneficio, Margen as [Margen (%)] FROM RENDIMIENTO02 ORDER BY FVenta ASC, ArtCod ASC"; DataTable dtRendimiento = new DataTable(); using (SqlCommand cmd = new SqlCommand(query, GloblaVar.gConRem)) { SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dtRendimiento); } ExportarExcel(dtRendimiento); } catch (Exception ex) { MessageBox.Show("Al exportar a excel se ha producido el siguiente error: \n\n" + ex.Message); } MessageBox.Show("La exportación a excel se ha realizado correctamente"); break; case 9: //Llamada a Rutina o Código para generar fichero Excel con el Listado de Diferencias de Stock string mensaje = ""; string sql = "SELECT p.Partida, p.Anyo, p.AlmMay, p.ArtCod as CodArt, p.ProCod as CodProv, p.StockInicial, p.Stock, p.FCua As Fecha_Cuadre, a.ComLpr as PCompra,(p.Stock * a.ComLpr) * -1 As [Beneficio/Perdida] "; sql += "FROM PARTIDAS p INNER JOIN [COMALB_LINEAS] a ON p.Partida=a.Partida and p.Anyo=a.anyo and p.AlmMay=a.AlmMay "; sql += "WHERE "; sql += "p.Stock<>0 "; sql += "AND p.FCua is not NULL AND (p.FCua>='" + dateTimePicker_Inicio.Text + "' AND p.FCua<='" + dateTimePicker_Fin.Text + "') "; //sql += " ORDER BY VENALB_CABE.AUX1 asc"; //string path = "C:\\CERCLE\\Excell"; string path = obtenerPath(); MessageBox.Show("Se va a generar listado excell en " + path); if (!string.IsNullOrEmpty(path)) { clase_excel excel = new clase_excel(); excel.CnO = GloblaVar.gConRem; excel.Query = sql; excel.Path = path; excel.NombreFichero = "Diferencias_STOCK"; mensaje = excel.exportarExcel(dateTimePicker_Inicio.Value); if (mensaje != "") { MessageBox.Show(mensaje); } else { MessageBox.Show("La exportación a excel se ha realizado correctamente"); } } else { MessageBox.Show("La ubicación de los ficheros es obligatoria. Debe rellenar el campo 'ConPathExcell' de la tabla 'CONTROL"); } break; case 11: frmREPORT.fechaDesde = dateTimePicker_Inicio.Text; frmREPORT.fechaHasta = dateTimePicker_Fin.Text; frmREPORT.Show(); break; case 12: frmREPORT.fechaDesde = dateTimePicker_Inicio.Text; frmREPORT.fechaHasta = dateTimePicker_Fin.Text; frmREPORT.Show(); break; case 15: frmREPORT.fechaDesde = dateTimePicker_Inicio.Text; frmREPORT.fechaHasta = dateTimePicker_Fin.Text; frmREPORT.artCodDesde = tArtIni.Text; frmREPORT.artCodHasta = tArtFin.Text; frmREPORT.Show(); break; default: frmREPORT.Show(); break; } //switch (GloblaVar.TIPO_REPORT ) //if (GloblaVar.TIPO_REPORT==4) //{ // //Genera_File_FP_OMP(); //} //else //{ //frmCR1 frmREPORT = new frmCR1(); //frmREPORT.Show(); //} } // private void btnF5_Click(object sender, EventArgs e)