private void DBThread_Tick(object sender, EventArgs e) { for (int i = 0; i < 5; i++) { string tmp = Sender.OutOfClass(Proto[i]); if (tmp != null && Mysql != null) { Message.Items.Add("Sql Sending.. value is " + Proto[i] + tmp); Mysql.PutQuery("update hardware set " + Proto[i] + "='" + tmp + "' where list=1"); } else if (Mysql == null && isOnDB == true) { Message.Items.Add("Mysql is closed. please turn it on!"); isOnDB = false; } } if (usingDB == false && isOnPort == true) { usingDB = true; if (usingDB = Sender.ManualControl(Mysql, Dongle)) { MsgEngine.Enqueue("Sending Manual code is completed."); } usingDB = false; } }
public bool ManualControl(UserWeb mysql, SerialPort Dongle) { reader = mysql.GetQuery("select * from manual"); while (reader.Read()) { control_unit = (string)reader[0]; } reader.Close(); if (control_unit.Equals(" ")) { reader.Close(); return(false); } if (control_unit.Equals("LmotorOn"))//on { Dongle.Write("A"); } else if (control_unit.Equals("LmotorOff"))//off { Dongle.Write("B"); } else if (control_unit.Equals("BmotorOn"))//on { Dongle.Write("C"); } else if (control_unit.Equals("BmotorOff")) { Dongle.Write("D"); } else if (control_unit.Equals("exWinOn"))//on { Dongle.Write("E"); } else if (control_unit.Equals("exWinOff")) { Dongle.Write("F"); } mysql.PutQuery("update manual set Mfield=' ' where list=1"); return(true); }