public rfidCheckArticles(string number, ReaderMethod readerTransfered, string refPedido) { InitializeComponent(); this.ControlBox = false; reader = readerTransfered; label3.Text = refPedido; reader.AnalyCallback = AnalyData; reader.ReceiveCallback = ReceiveData; reader.SendCallback = SendData; // Cargar con datos de la bbdd numPedido = number; //Initialize mysql connection connection = new MySqlConnection(ConnectionString); connection2 = new MySqlConnection(ConnectionString2); //Get all items in datatable DTItems = GetAllItems(); //Fill grid with items dataGridView1.DataSource = DTItems; dataGridView1.Columns[0].HeaderText = "ID"; dataGridView1.Columns[1].HeaderText = "REFERENCIA"; dataGridView1.Columns[2].HeaderText = "DESCRIPCION"; dataGridView1.Columns[3].HeaderText = "CANTIDAD"; dataGridView1.ClearSelection(); refreshQuantityGridInBoxes(); btRealTimeInventory_Click(); }
private void frmMySqlSample_Load(object sender, EventArgs e) { //Initialize mysql connection connection = new MySqlConnection(ConnectionString); reader = new Reader.ReaderMethod(); reader.AnalyCallback = AnalyData; reader.ReceiveCallback = ReceiveData; reader.SendCallback = SendData; //Get all items in datatable DTItems = GetAllItems(); //Fill grid with items dataGridView1.DataSource = DTItems; dataGridView1.Columns[0].HeaderText = "ID"; dataGridView1.Columns[1].HeaderText = "REFERENCIA"; dataGridView1.Columns[2].HeaderText = "FECHA"; dataGridView1.Columns[3].HeaderText = "ARTICULOS"; string[] ports = SerialPort.GetPortNames(); if (Properties.Settings.Default.portCOM == "") { btnSave.Enabled = false; } else { comboBox1.Text = Properties.Settings.Default.portCOM; } foreach (string portAvailable in ports) { comboBox1.Items.Add(portAvailable); } DateTime fechaHoy = DateTime.Now; DateTime horaMax = Convert.ToDateTime("16:00:00"); DateTime fechaMax = new DateTime(fechaHoy.Year, fechaHoy.Month, fechaHoy.Day, horaMax.Hour, horaMax.Minute, horaMax.Second); for (int h = 0; h < dataGridView1.Rows.Count; h++) { DateTime fechaPedido = Convert.ToDateTime(dataGridView1[2, h].Value); DateTime.Now.ToString("h:mm:ss tt"); if (DateTime.Compare(fechaPedido, fechaMax) < 0) { // Do Today dataGridView1.Rows[h].DefaultCellStyle.BackColor = Color.FromArgb(255, 255, 0); } else { // Dont do today dataGridView1.Rows[h].DefaultCellStyle.BackColor = Color.FromArgb(153, 255, 104); } } dataGridView1.ClearSelection(); }
private static void StartToRead() { try { timerInventory = new System.Timers.Timer(); timerInventory.Interval = 50; timerInventory.Elapsed += new ElapsedEventHandler(timerInventory_Tick); DeviceAntennaCount = 4; reader = new Reader.ReaderMethod(); DeviceSerialPort = 2; reader.AnalyCallback = AnalyData; Connect(); new System.Threading.Thread(new System.Threading.ThreadStart(DetectPosition)).Start(); } catch (Exception ex) { Logger(ex.Message); } }