private void State_Image_MouseLeftButtonDown(object sender, MouseEventArgs e)
{
Image iImage = (Image)sender;
MySqlCommand CMD = new MySqlCommand();
CMD.Connection = CN;
CMD.CommandType = CommandType.Text;
//outputStatus = DirectCast(sender, PictureBox).Tag
foreach (ScreenObject dso in aScreenObject)
{
if (dso.Object_Name == iImage.Tag)
{
if (dso.Object_State == "ON")
{
CMD.CommandText = "SELECT COUNT(*) FROM osae_v_object_method WHERE object_name='" + dso.Object_Name + "' AND method_name='OFF'";
try
{
CN.Open();
Int32 iResults = Convert.ToInt32(CMD.ExecuteScalar());
CN.Close();
if (iResults > 0)
{
OSAEApi.MethodQueueAdd(dso.Object_Name, "OFF", "", "");
}
else
{
OSAEApi.ObjectStateSet(dso.Object_Name, "OFF");
}
}
catch (Exception ex)
{
MessageBox.Show("Error ClickControlStateImage: " + ex.Message);
CN.Close();
}
}
else
{
CMD.CommandText = "SELECT COUNT(*) FROM osae_v_object_method WHERE object_name='" + dso.Object_Name + "' AND method_name='ON'";
try
{
CN.Open();
Int32 iResults = Convert.ToInt32(CMD.ExecuteScalar());
CN.Close();
if (iResults > 0)
{
OSAEApi.MethodQueueAdd(dso.Object_Name, "ON", "", "");
}
else
{
OSAEApi.ObjectStateSet(dso.Object_Name, "ON");
}
}
catch (Exception ex)
{
MessageBox.Show("Error ClickControlStateImage: " + ex.Message);
CN.Close();
}
}
}
}
}
