1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104
| Imports CrystalDecisions.CrystalReports.Engine
Imports MySql.Data.MySqlClient
Imports CrystalDecisions.Shared
Imports System.Configuration
Public Class Venta_Pales_por_Fecha_RPT
Dim da As MySqlDataAdapter
Dim ds As DataSet
Dim p(7) As MySqlParameter
Dim MysqlConn As MySqlConnection
Dim COMMAND As MySqlCommand
Dim READER As MySqlDataReader
Dim con As New MySqlConnection(ConfigurationManager.ConnectionStrings("xCantera.My.MySettings.xCantera_OVH_MARIADB").ToString)
Private Sub CrystalReportViewer1_Load(sender As Object, e As EventArgs)
End Sub
Private Sub DateTimePicker1_ValueChanged(sender As Object, e As EventArgs) Handles DateTimePicker1.ValueChanged
'DateTimePicker1.CustomFormat = "yyyy-MM-dd"
End Sub
Private Sub DateTimePicker2_ValueChanged(sender As Object, e As EventArgs) Handles DateTimePicker2.ValueChanged
'DateTimePicker1.CustomFormat = "yyyy-MM-dd"
End Sub
Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
Me.Cursor = Cursors.WaitCursor
Dim table As New DataTable()
Dim command As New MySqlCommand("SELECT
Produccion.Producto,
Produccion.Producto_tipo,
Produccion.Formato,
Produccion.Marcado,
Produccion.Codigo_referencia,
Produccion.Particularidad,
count(*) as TOTAL_PALES,
SUM(Piezas) AS TOTAL_PIEZAS,SUM(Kilos) AS TOTAL_Kilos,
CONCAT(Produccion.Longitud, 'x',Produccion.Anchura) AS TAMANO
FROM Lote_Cliente, Produccion
WHERE (fecha_preparacion BETWEEN @FECHAINICIO AND @FECHAFINAL) AND Lote_Cliente.numero_lote_cliente = Produccion.Lote_cliente AND Produccion.Nave = @NAVE AND Produccion.Producto = @PRODUCTO
GROUP BY Produccion.Producto,Produccion.Producto_tipo,Produccion.Formato,Produccion.Marcado,Produccion.Codigo_referencia,Produccion.Particularidad,TAMANO
ORDER BY Produccion.Producto, Produccion.Producto_tipo,Produccion.Formato,TAMANO ASC,Produccion.Codigo_referencia,Produccion.Marcado ASC", con)
command.Parameters.AddWithValue("@FECHAINICIO", DateTimePicker1.Value.ToString("yyyy-MM-dd"))
command.Parameters.AddWithValue("@FECHAFINAL", DateTimePicker2.Value.ToString("yyyy-MM-dd"))
command.Parameters.AddWithValue("@NAVE", ComboBox1.Text)
command.Parameters.AddWithValue("@PRODUCTO", ComboBox2.Text)
command.CommandTimeout = 21600
Dim adapter As New MySqlDataAdapter(command)
adapter.Fill(table)
DataGridView1.DataSource = table
Dim ds As New DataSet
Dim query As String
p(0) = New MySqlParameter("@FECHAINICIO", DateTimePicker1.Value.ToString("yyyy-MM-dd"))
p(0).Value = DateTimePicker1.Text
p(1) = New MySqlParameter("@FECHAFINAL", DateTimePicker2.Value.ToString("yyyy-MM-dd"))
p(1).Value = DateTimePicker2.Text
p(2) = New MySqlParameter("@NAVE", ComboBox1.Text)
p(2).Value = ComboBox1.Text
p(3) = New MySqlParameter("@PRODUCTO", ComboBox2.Text)
p(3).Value = ComboBox2.Text
query = "SELECT
Produccion.Producto,
Produccion.Producto_tipo,
Produccion.Formato,
Produccion.Marcado,
Produccion.Codigo_referencia,
Produccion.Particularidad,
count(*) as TOTAL_PALES,
SUM(Piezas) AS TOTAL_PIEZAS,SUM(Kilos) AS TOTAL_Kilos,
CONCAT(Produccion.Longitud, 'x',Produccion.Anchura) AS TAMANO
FROM Lote_Cliente, Produccion
WHERE (fecha_preparacion BETWEEN @FECHAINICIO AND @FECHAFINAL) AND Lote_Cliente.numero_lote_cliente = Produccion.Lote_cliente AND Produccion.Nave = @NAVE AND Produccion.Producto = @PRODUCTO
GROUP BY Produccion.Producto,Produccion.Producto_tipo,Produccion.Formato,Produccion.Marcado,Produccion.Codigo_referencia,Produccion.Particularidad,TAMANO
ORDER BY Produccion.Producto, Produccion.Producto_tipo,Produccion.Formato,TAMANO ASC,Produccion.Codigo_referencia,Produccion.Marcado ASC"
Dim dscmd As New MySqlDataAdapter(query, con)
dscmd.SelectCommand.Parameters.Add(p(0))
dscmd.SelectCommand.Parameters.Add(p(1))
dscmd.SelectCommand.Parameters.Add(p(2))
dscmd.SelectCommand.Parameters.Add(p(3))
dscmd.Fill(ds, "VENTASPALESPORFECHAS")
con.Close()
Dim cryds As New Venta_Pales_por_Fecha
cryds.SetDataSource(ds.Tables(0))
CrystalReportViewer1.ReportSource = cryds
CrystalReportViewer1.Refresh()
con.Close()
con.Close()
Me.Cursor = Cursors.Default
End Sub
Private Sub Venta_Pales_por_Fecha_RPT_Load(sender As Object, e As EventArgs) Handles MyBase.Load
End Sub
End Class |
Partager