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);
}
private void DBConnection_Click(object sender, EventArgs e)
{
if (Mysql == null)
{
Mysql = new UserWeb(MsgEngine);
isOnDB = true;
DBLabel.Text = "DB ON";
}
else
{
if (isOnPort == true)
{
MsgEngine.Enqueue("first, terminate SerialPort.");
return;
}
isOnDB = false;
Mysql.terminated();
Mysql = null;
MsgEngine.Enqueue("Mysql is closed..");
DBLabel.Text = "DB OFF";
}
}
private void Form1_Load(object sender, EventArgs e)
{
List <string> listOfCOM = GetConnectComDevice();
foreach (string COM in listOfCOM)
{
Port_COM.Items.Add(COM);
}
MsgEngine = new interfaceEngine(500);
InsEngine = new interfaceEngine(500);
Sender = new Protocol();
Proto = new string[5];
Proto[0] = "LTemp";
Proto[1] = "LHumi";
Proto[2] = "BTemp";
Proto[3] = "BHumi";
Proto[4] = "Parking";
Mysql = new UserWeb(MsgEngine);
isOnDB = true;
DBLabel.Text = "DB ON";
}