private void Form1_Load(object sender, EventArgs e)
{
dateTimePicker1.Format = DateTimePickerFormat.Time;
string Zeit = dateTimePicker1.Text;
SerialPort mySerialPort = new SerialPort("COM1");
mySerialPort.BaudRate = 9600;
mySerialPort.Parity = Parity.None;
mySerialPort.StopBits = StopBits.One;
mySerialPort.DataBits = 8;
mySerialPort.Handshake = Handshake.None;
mySerialPort.DataReceived += new SerialDataReceivedEventHandler(DataReceviedHandler);
mySerialPort.Open();
}
private void DataReceviedHandler(object sender, SerialDataReceivedEventArgs e)
{
SerialPort sp = (SerialPort)sender;
string indata = sp.ReadExisting();
Code = indata;
int Nummer = Convert.ToInt32(Code);
string mysql = "UPDATE Besucher set Ende = ? WHERE LfdNr = ?";
string mysql2 = "INSERT INTO Archiv (Name, Firma, Begleitperson, Beginn, Ende, Kennz, Datum, Bez) SELECT Name, Firma, Begleitperson, Beginn, Ende, Kennz, Datum, Bez FROM Besucher where Ende > 0";
string mysql3 = "DELETE FROM Besucher where Ende > 0";
OdbcCommand DbCommand = new OdbcCommand();
OdbcConnection DbConnection = new OdbcConnection(con);
try
{
DbConnection.Open();
DbCommand.Parameters.Add("@ende", OdbcType.Char).Value = dateTimePicker1.Text;
DbCommand.Parameters.Add("@LfdNr", OdbcType.Char).Value = Nummer;
DbCommand.Connection = DbConnection;
DbCommand.CommandText = mysql; //Ende einfügen
DbCommand.ExecuteNonQuery();
DbCommand.CommandText = mysql2; // in Archiv schreiben
DbCommand.ExecuteNonQuery();
DbCommand.CommandText = mysql3; // Aus aktueller Tabelle löschen
DbCommand.ExecuteNonQuery();
}
catch (Exception f)
{
MessageBox.Show(f.Message);
}
finally
{
DbConnection.Dispose();
}
}