コード例 #1
0
        private void Load_Objects(String sScreen)
        {
            String sStateMatch = "";
            String sImage = "";

            List<OSAE.OSAEObject> screenObjects = OSAEApi.GetObjectsByContainer(sScreen);

            foreach (OSAE.OSAEObject obj in screenObjects)
            {
                ScreenObject sObj = new ScreenObject();
                #region CONTROL STATE IMAGE
                if (obj.Type == "CONTROL STATE IMAGE")
                {
                    sObj.Object_Name = obj.Property("Object Name").Value;
                    sObj.Control_Name = obj.Name;
                    sObj.Control_Type = obj.Type;
                    OSAE.OSAEObject osaObject = OSAEApi.GetObjectByName(sObj.Object_Name);
                    Image dsi = new Image();
                    dsi.Tag = sObj.Object_Name;
                    dsi.MouseLeftButtonUp += new MouseButtonEventHandler(State_Image_MouseLeftButtonUp);

                    sObj.Object_State_Time = obj.LastUpd;

                    foreach (OSAE.ObjectProperty p in obj.Properties)
                    {
                        if (p.Value.ToLower() == osaObject.State.Value.ToLower())
                        {
                            sStateMatch = p.Name.Substring(0, p.Name.LastIndexOf(' '));
                        }
                    }

                    sImage = OSAEApi.APIpath + obj.Property(sStateMatch + " Image").Value;

                    OSAE.ObjectProperty pZOrder = obj.Property("ZOrder");
                    OSAE.ObjectProperty pX = obj.Property(sStateMatch + " X");
                    OSAE.ObjectProperty pY = obj.Property(sStateMatch + " Y");
                    sObj.Object_State = osaObject.State.Value;
                    sObj.ScreenImage = dsi;
                    aScreenObject.Add(sObj);
                    if (File.Exists(sImage))
                    {
                        canGUI.Children.Add(dsi);

                        Double dX = Convert.ToDouble(pX.Value);
                        Canvas.SetLeft(dsi, dX);
                        Double dY = Convert.ToDouble(pY.Value);
                        Canvas.SetTop(dsi, dY);
                        int dZ = Convert.ToInt32(pZOrder.Value);
                        Canvas.SetZIndex(dsi, dZ);

                        byte[] byteArray = File.ReadAllBytes(sImage);
                        var imageStream = new MemoryStream(byteArray);
                        var bitmapImage = new BitmapImage();

                        bitmapImage.BeginInit();
                        bitmapImage.StreamSource = imageStream;
                        bitmapImage.EndInit();

                        dsi.Source = bitmapImage;

                        dsi.Visibility = System.Windows.Visibility.Visible;
                    }
                    else
                    {
                        dsi.Source = null;
                        dsi.Visibility = System.Windows.Visibility.Hidden;
                    }
                    aScreenObject.Add(sObj);
                }
                #endregion

                #region CONTROL PROPERTY LABEL
                else if (obj.Type == "CONTROL PROPERTY LABEL")
                {
                    sObj.Object_Name = obj.Property("Object Name").Value;
                    String sPropertyName = obj.Property("Property Name").Value;
                    sObj.Property_Name = sPropertyName;
                    String sPropertyValue = OSAEApi.GetObjectPropertyValue(sObj.Object_Name, sPropertyName).Value;
                    String sBackColor = obj.Property("Back Color").Value;
                    String sForeColor = obj.Property("Fore Color").Value;
                    String sPrefix = obj.Property("Prefix").Value;
                    String sSuffix = obj.Property("Suffix").Value;
                    String iFontSize = obj.Property("Font Size").Value;
                    String sFontName = obj.Property("Font Name").Value;
                    Label dpl = new Label();
                    dpl.Tag = sObj.Object_Name;
                    OSAE.ObjectProperty pX = obj.Property("X");
                    OSAE.ObjectProperty pY = obj.Property("Y");
                    canGUI.Children.Add(dpl);
                    sObj.ScreenLabel = dpl;
                    Double dX = Convert.ToDouble(pX.Value);
                    Canvas.SetLeft(dpl, dX);
                    Double dY = Convert.ToDouble(pY.Value);
                    Canvas.SetTop(dpl, dY);
                    if (sPropertyValue != "")
                    {
                        if (sBackColor != "")
                        {
                            try
                            {
                                BrushConverter conv = new BrushConverter();
                                SolidColorBrush brush = conv.ConvertFromString(sBackColor) as SolidColorBrush;
                                dpl.Background = brush;
                            }
                            catch (Exception myerror)
                            {
                            }
                        }
                        if (sForeColor != "")
                        {
                            try
                            {
                                BrushConverter conv = new BrushConverter();
                                SolidColorBrush brush = conv.ConvertFromString(sForeColor) as SolidColorBrush;
                                dpl.Foreground = brush;
                            }
                            catch (Exception myerror)
                            {
                            }
                        }
                        if (iFontSize != "")
                        {
                            try
                            {
                                dpl.FontSize = Convert.ToDouble(iFontSize);
                            }
                            catch (Exception myerror)
                            {
                            }
                        }
                        dpl.Content = sPrefix + sPropertyValue + sSuffix;
                        sObj.Object_State = "";
                    }
                    else
                    {
                        dpl.Content = "";
                    }
                    aScreenObject.Add(sObj);
                }
                #endregion

                #region CONTROL STATIC LABEL
                else if (obj.Type == "CONTROL STATIC LABEL")
                {
                    String sPropertyValue = obj.Property("Value").Value;
                    String sBackColor = obj.Property("Back Color").Value;
                    String sForeColor = obj.Property("Fore Color").Value;
                    Label dsl = new Label();
                    OSAE.ObjectProperty pX = obj.Property("X");
                    OSAE.ObjectProperty pY = obj.Property("Y");
                    canGUI.Children.Add(dsl);
                    Double dX = Convert.ToDouble(pX.Value);
                    Canvas.SetLeft(dsl, dX);
                    Double dY = Convert.ToDouble(pY.Value);
                    Canvas.SetTop(dsl, dY);

                    if (sPropertyValue != "")
                    {
                        if (sBackColor != "")
                        {
                            try
                            {
                                BrushConverter conv = new BrushConverter();
                                SolidColorBrush brush = conv.ConvertFromString(sBackColor) as SolidColorBrush;
                                dsl.Background = brush;
                            }
                            catch (Exception myerror)
                            {
                            }
                        }
                        if (sForeColor != "")
                        {
                            try
                            {
                                BrushConverter conv = new BrushConverter();
                                SolidColorBrush brush = conv.ConvertFromString(sForeColor) as SolidColorBrush;
                                dsl.Foreground = brush;
                            }
                            catch (Exception myerror)
                            {
                            }
                        }
                        dsl.Content = sPropertyValue;
                    }
                    else
                    {
                        dsl.Content = "";
                    }
                }
                #endregion

                #region CONTROL TIMER LABEL
                else if (obj.Type == "CONTROL TIMER LABEL")
                {
                    sObj.Object_Name = obj.Property("Object Name").Value;
                    OSAE.OSAEObject timerObject = OSAEApi.GetObjectByName(sObj.Object_Name);
                    String sBackColor = obj.Property("Back Color").Value;
                    String sForeColor = obj.Property("Font Color").Value;
                    Label dtl = new Label();
                    OSAE.ObjectProperty pX = obj.Property("X");
                    OSAE.ObjectProperty pY = obj.Property("Y");
                    canGUI.Children.Add(dtl);
                    Double dX = Convert.ToDouble(pX.Value);
                    Canvas.SetLeft(dtl, dX);
                    Double dY = Convert.ToDouble(pY.Value);
                    Canvas.SetTop(dtl, dY);

                    sObj.Object_State_Time = Convert.ToInt32(timerObject.State.TimeInState).ToString();
                    sObj.Object_Last_Updated = timerObject.LastUpd;

                    if (sBackColor != "")
                    {
                        try
                        {
                            BrushConverter conv = new BrushConverter();
                            SolidColorBrush brush = conv.ConvertFromString(sBackColor) as SolidColorBrush;
                            dtl.Background = brush;
                        }
                        catch (Exception myerror)
                        {
                        }
                    }
                    if (sForeColor != "")
                    {
                        try
                        {
                            BrushConverter conv = new BrushConverter();
                            SolidColorBrush brush = conv.ConvertFromString(sForeColor) as SolidColorBrush;
                            dtl.Foreground = brush;
                        }
                        catch (Exception myerror)
                        {
                        }
                    }

                }
                #endregion

                //    else if (aScreenObject(iLoop).Control_Type = "CONTROL METHOD IMAGE")
                //        iMethodImageCount = iMethodImageCount + 1
                //        aScreenObject(iLoop).Object_Name = OSAEApi.GetObjectProperty(aScreenObject(iLoop).Control_Name, "Object Name")
                //        aScreenObject(iLoop).Control_Index = iMethodImageCount
                //        aControlMethodImage(aControlMethodImage.Count).Tag = iLoop
                //        g_toolTip.SetToolTip(aControlMethodImage(iMethodImageCount), aScreenObject(iLoop).Object_Name)
                //        CMD.Parameters.Clear()
                //        try
                //        {
                //            sImage = OSAEApi.GetObjectProperty(aScreenObject(iLoop).Control_Name, "Image");
                //            sImage = sImage.Replace(".\", "\");
                //            If File.Exists(gAppPath & sImage) Then sImage = gAppPath & sImage
                //            iZOrder = Val(OSAEApi.GetObjectProperty(aScreenObject(iLoop).Control_Name, "ZOrder"));
                //            iX = Val("" & OSAEApi.GetObjectProperty(aScreenObject(iLoop).Control_Name, "X"));
                //            iY = Val("" & OSAEApi.GetObjectProperty(aScreenObject(iLoop).Control_Name, "Y"));
                //            if (File.Exists(sImage))
                //            {
                //                aControlMethodImage(aScreenObject(iLoop).Control_Index).Image = Image.FromFile(sImage);
                //                aScreenObject(iLoop).Object_State = ""
                //                aControlMethodImage(aScreenObject(iLoop).Control_Index).Left = iX;
                //                aControlMethodImage(aScreenObject(iLoop).Control_Index).Top = iY;
                //                aControlMethodImage(aScreenObject(iLoop).Control_Index).Visible = True;
                //            }
                //            else
                //            {
                //                aControlMethodImage(aScreenObject(iLoop).Control_Index).Image = Nothing;
                //                aControlMethodImage(aScreenObject(iLoop).Control_Index).Visible = False;
                //            }
                //        }
                //         catch (MySqlException myerror)
                //        {
                //            MessageBox.Show("GUI Error Load_Objects 4: " + myerror.Message);
                //            CN.Close();
                //         }

                #region CONTROL NAVIGATION IMAGE
                else if (obj.Type == "CONTROL NAVIGATION IMAGE")
                {
                    sObj.Object_Name = obj.Property("Screen").Value;
                    sObj.Object_State = "";
                    Image dni = new Image();
                    dni.Tag = sObj.Object_Name;
                    try
                    {
                        sImage = obj.Property("Image").Value;
                        if (File.Exists(OSAEApi.APIpath + sImage))
                        {
                            sImage = OSAEApi.APIpath + sImage;
                        }
                        OSAE.ObjectProperty pZOrder = obj.Property("ZOrder");
                        OSAE.ObjectProperty pX = obj.Property("X");
                        OSAE.ObjectProperty pY = obj.Property("Y");
                        if (File.Exists(sImage))
                        {
                            canGUI.Children.Add(dni);
                            Double dX = Convert.ToDouble(pX.Value);
                            Canvas.SetLeft(dni, dX);
                            Double dY = Convert.ToDouble(pY.Value);
                            Canvas.SetTop(dni, dY);
                            int dZ = Convert.ToInt32(pZOrder.Value);
                            Canvas.SetZIndex(dni, dZ);

                            byte[] byteArray = File.ReadAllBytes(sImage);
                            var imageStream = new MemoryStream(byteArray);
                            var bitmapImage = new BitmapImage();

                            bitmapImage.BeginInit();
                            bitmapImage.StreamSource = imageStream;
                            bitmapImage.EndInit();
                            dni.Source = bitmapImage;
                        }
                    }
                    catch (MySqlException myerror)
                    {
                        MessageBox.Show("GUI Error Load_Objects 5: " + myerror.Message);
                    }
                }
                #endregion

                #region CONTROL CAMERA VIEWER
                else if (obj.Type == "CONTROL CAMERA VIEWER")
                {
                    try
                    {
                        string stream = OSAEApi.GetObjectPropertyValue(obj.Property("Object Name").Value, "Stream Address").Value;
                        OSAE.UI.Controls.VideoStreamViewer vsv = new OSAE.UI.Controls.VideoStreamViewer(stream);
                        canGUI.Children.Add(vsv);
                        OSAE.ObjectProperty pZOrder =obj.Property("ZOrder");
                        OSAE.ObjectProperty pX = obj.Property("X");
                        OSAE.ObjectProperty pY = obj.Property("Y");
                        Double dX = Convert.ToDouble(pX.Value);
                        Canvas.SetLeft(vsv, dX);
                        Double dY = Convert.ToDouble(pY.Value);
                        Canvas.SetTop(vsv, dY);
                        int dZ = Convert.ToInt32(pZOrder.Value);
                        Canvas.SetZIndex(vsv, dZ);

                    }
                    catch (MySqlException myerror)
                    {
                        MessageBox.Show("GUI Error Load Camera Viewer: " + myerror.Message);
                    }
                }
                #endregion

                #region USER CONTROL
                else if (obj.Type == "USER CONTROL")
                {
                    string sUCType = obj.Property("Control Type").Value;
                    if (sUCType == "USER CONTROL WEATHER")
                    {
                        OSAE.UI.Controls.Weather wc = new OSAE.UI.Controls.Weather();
                        canGUI.Children.Add(wc);
                        OSAE.ObjectProperty pZOrder = obj.Property("ZOrder");
                        OSAE.ObjectProperty pX = obj.Property("X");
                        OSAE.ObjectProperty pY = obj.Property("Y");
                        Double dX = Convert.ToDouble(pX.Value);
                        Canvas.SetLeft(wc, dX);
                        Double dY = Convert.ToDouble(pY.Value);
                        Canvas.SetTop(wc, dY);
                        int dZ = Convert.ToInt32(pZOrder.Value);
                        Canvas.SetZIndex(wc, dZ);
                    }
                }
                #endregion

                //If iStateImageList.EndsWith(",") Then iStateImageList = iStateImageList.Substring(0, iStateImageList.Length - 1)
                //Timer1.Enabled = True
            }
        }
コード例 #2
0
        private void Load_Objects(String sScreen)
        {
            MySqlCommand CMD = new MySqlCommand();
             //   MySqlDataReader myReader = new MySqlDataReader();
            String sState = "";
            String sStateMatch = "";
            String sImage = "";

            CMD.Connection = CN;
            CMD.CommandType = CommandType.Text;

            //COUNT **ALL** control objects for this screen
            //CMD.CommandText = "SELECT COUNT(*) as Results FROM osae_v_screen_object WHERE screen_name=?pscreen";
            //CMD.Parameters.AddWithValue("?pscreen", sScreen);
            //try
            //{
            //    CN.Open();
            //    iObjectCount = Convert.ToInt32(CMD.ExecuteScalar());
            //    CN.Close();
            //}
            //catch (Exception myerror)
            //{
            //    MessageBox.Show("GUI Error Load_Objects 1: " + myerror.Message);
            //    CN.Close();
            //}
            CMD.Parameters.Clear();
            //Select **ALL** control objects for this screen
            CMD.CommandText = "SELECT * FROM osae_v_object_property WHERE object_id IN(SELECT control_id FROM osae_v_screen_object WHERE screen_name=?pscreen) AND property_name='ZOrder' ORDER BY property_value";
            CMD.Parameters.AddWithValue("?pscreen", sScreen);
            try
            {
             CN.Open();
            MySqlDataReader myReader = CMD.ExecuteReader();
            while (myReader.Read())
            {
                ScreenObject so = new ScreenObject();
                so.Control_Name = Convert.ToString(myReader.GetString("object_name"));
                so.Control_Type = Convert.ToString(myReader.GetString("object_type"));
                aScreenObject.Add(so);
            }
            CN.Close();
            }
            catch (MySqlException myerror)
            {
            MessageBox.Show("GUI Error Load_Objects 2: " + myerror.Message);
            CN.Close();
            }
            CMD.Parameters.Clear();
            foreach (ScreenObject dso in aScreenObject)
            {
            if (dso.Control_Type == "CONTROL STATE IMAGE")
            {
                dso.Object_Name = OSAEApi.GetObjectProperty(dso.Control_Name, "Object Name");
                Image dsi = new Image();
                dsi.Tag = dso.Object_Name;
                dsi.MouseLeftButtonDown += new MouseButtonEventHandler(State_Image_MouseLeftButtonDown);
                sState = OSAEApi.GetObjectState(dso.Object_Name);
                CMD.Parameters.Clear();
                CMD.CommandText = "SELECT COALESCE(last_state_change,NOW()) FROM osae_v_object WHERE object_name=?ObjectName";
                CMD.Parameters.AddWithValue("?ObjectName", dso.Object_Name);
                try
                {
                    CN.Open();
                    dso.Object_State_Time = Convert.ToString(CMD.ExecuteScalar());
                    CN.Close();
                }
                catch (Exception myerror)
                {
                    MessageBox.Show("GUI Error Load_Objects 2.5: " + myerror.Message);
                    CN.Close();
                }
                CMD.Parameters.Clear();
                CMD.CommandText = "SELECT property_name FROM osae_v_object_property WHERE object_name=?ObjectName AND property_value=?pstate";
                CMD.Parameters.AddWithValue("?ObjectName", dso.Control_Name);
                CMD.Parameters.AddWithValue("?pstate", sState);
                try
                {
                    CN.Open();
                    sStateMatch = Convert.ToString(CMD.ExecuteScalar());
                    CN.Close();
                    if (sStateMatch != "")
                    {
                        sStateMatch = sStateMatch.Substring(0, 7);
                    }
                    sImage = OSAEApi.GetObjectProperty(dso.Control_Name, sStateMatch + " Image");
                    if (File.Exists(OSAEApi.APIpath + sImage))
                    {
                        sImage = OSAEApi.APIpath + sImage;
                    }

                    OSAE.ObjectProperty pZOrder = OSAEApi.GetObjectPropertyValue(dso.Control_Name, "ZOrder");
                    OSAE.ObjectProperty pX = OSAEApi.GetObjectPropertyValue(dso.Control_Name, sStateMatch + " X");
                    OSAE.ObjectProperty pY = OSAEApi.GetObjectPropertyValue(dso.Control_Name, sStateMatch + " Y");
                    dso.Object_State = sState;
                    dso.ScreenImage = dsi;
                    if (File.Exists(sImage))
                    {
                        canGUI.Children.Add(dsi);

                        Double dX = Convert.ToDouble(pX.Value);
                        Canvas.SetLeft(dsi, dX);
                        Double dY = Convert.ToDouble(pY.Value);
                        Canvas.SetTop(dsi, dY);

                        byte[] byteArray = File.ReadAllBytes(sImage);
                        var imageStream = new MemoryStream(byteArray);
                        var bitmapImage = new BitmapImage();

                        bitmapImage.BeginInit();
                        bitmapImage.StreamSource = imageStream;
                        bitmapImage.EndInit();
                        //canGUI.Background = new ImageBrush(bitmapImage);

                        dsi.Source = bitmapImage;

                        if (pZOrder.Value == "0")
                        {
                            // dsi.SendToBack();
                        }
                        else
                        {
                            // dsi.BringToFront();
                        }
                        dsi.Visibility = System.Windows.Visibility.Visible;
                    }
                    else
                    {
                        dsi.Source = null;
                        dsi.Visibility = System.Windows.Visibility.Hidden;
                    }
                }
                catch (Exception myerror)
                {
                    MessageBox.Show("GUI Error Load_Objects 3: " + myerror.Message);
                    CN.Close();
                }
            }
            else if (dso.Control_Type == "CONTROL PROPERTY LABEL")
            {
                dso.Object_Name = OSAEApi.GetObjectProperty(dso.Control_Name, "Object Name");
                String sPropertyName = OSAEApi.GetObjectProperty(dso.Control_Name, "Property Name");
                dso.Property_Name = sPropertyName;
                String sPropertyValue = OSAEApi.GetObjectProperty(dso.Object_Name, sPropertyName);
                String sBackColor = OSAEApi.GetObjectProperty(dso.Control_Name, "Back Color");
                String sForeColor = OSAEApi.GetObjectProperty(dso.Control_Name, "Fore Color");
                String sPrefix = OSAEApi.GetObjectProperty(dso.Control_Name, "Prefix");
                String sSuffix = OSAEApi.GetObjectProperty(dso.Control_Name, "Suffix");
                String iFontSize = OSAEApi.GetObjectProperty(dso.Control_Name, "Font Size");
                String sFontName = OSAEApi.GetObjectProperty(dso.Control_Name, "Font Name");
                Label dpl = new Label();
                dpl.Tag = dso.Object_Name;
                OSAE.ObjectProperty pX = OSAEApi.GetObjectPropertyValue(dso.Control_Name, "X");
                OSAE.ObjectProperty pY = OSAEApi.GetObjectPropertyValue(dso.Control_Name, "Y");
                canGUI.Children.Add(dpl);
                dso.ScreenLabel = dpl;
                Double dX = Convert.ToDouble(pX.Value);
                Canvas.SetLeft(dpl, dX);
                Double dY = Convert.ToDouble(pY.Value);
                Canvas.SetTop(dpl, dY);
                if (sPropertyValue != "")
                {
                    if (sBackColor != "")
                    {
                        try
                        {
                            BrushConverter conv = new BrushConverter();
                            SolidColorBrush brush = conv.ConvertFromString(sBackColor) as SolidColorBrush;
                            dpl.Background = brush;
                        }
                        catch (Exception myerror)
                        {
                        }
                    }
                    if (sForeColor != "")
                    {
                        try
                        {
                            BrushConverter conv = new BrushConverter();
                            SolidColorBrush brush = conv.ConvertFromString(sForeColor) as SolidColorBrush;
                            dpl.Foreground = brush;
                        }
                        catch (Exception myerror)
                        {
                        }
                    }
                    if (iFontSize != "")
                    {
                        try
                        {
                            dpl.FontSize = Convert.ToDouble(iFontSize);
                        }
                        catch (Exception myerror)
                        {
                        }
                    }
                    dpl.Content = sPrefix + sPropertyValue + sSuffix;
                    dso.Object_State = "";
                }
                else
                {
                    dpl.Content = "";
                }
            }
            else if (dso.Control_Type == "CONTROL STATIC LABEL")
            {
                dso.Object_Name = OSAEApi.GetObjectProperty(dso.Control_Name, "Object Name");
                String sPropertyValue = OSAEApi.GetObjectProperty(dso.Object_Name, "Value");
                String sBackColor = OSAEApi.GetObjectProperty(dso.Control_Name, "Back Color");
                String sForeColor = OSAEApi.GetObjectProperty(dso.Control_Name, "Fore Color");
                Label dsl = new Label();
                dsl.Tag = dso.Object_Name;
                OSAE.ObjectProperty pX = OSAEApi.GetObjectPropertyValue(dso.Control_Name, "X");
                OSAE.ObjectProperty pY = OSAEApi.GetObjectPropertyValue(dso.Control_Name, "Y");
                canGUI.Children.Add(dsl);
                Double dX = Convert.ToDouble(pX.Value);
                Canvas.SetLeft(dsl, dX);
                Double dY = Convert.ToDouble(pY.Value);
                Canvas.SetTop(dsl, dY);
                if (sPropertyValue != "")
                {
                    if (sBackColor != "")
                    {
                        try
                        {
                            BrushConverter conv = new BrushConverter();
                            SolidColorBrush brush = conv.ConvertFromString(sBackColor) as SolidColorBrush;
                            dsl.Background = brush;
                        }
                        catch (Exception myerror)
                        {
                        }
                    }
                    if (sForeColor != "")
                    {
                        try
                        {
                            BrushConverter conv = new BrushConverter();
                            SolidColorBrush brush = conv.ConvertFromString(sForeColor) as SolidColorBrush;
                            dsl.Foreground = brush;
                        }
                        catch (Exception myerror)
                        {
                        }
                    }
                    dsl.Content = sPropertyValue;
                }
                else
                {
                    dsl.Content = "";
                }
            }

            //    else if aScreenObject(iLoop).Control_Type = "CONTROL TIMER LABEL" Then
            //        iTimerLabelCount = iTimerLabelCount + 1
            //        aScreenObject(iLoop).Control_Index = iTimerLabelCount
            //        aScreenObject(iLoop).Object_Name = OSAEApi.GetObjectProperty(aScreenObject(iLoop).Control_Name, "Object Name")
            //        sPropertyName = OSAEApi.GetObjectProperty(aScreenObject(iLoop).Control_Name, "Type")
            //        aScreenObject(iLoop).Property_Name = sPropertyName
            //        sPropertyValue = OSAEApi.GetObjectProperty(aScreenObject(iLoop).Object_Name, "OFF Timer")
            //        aScreenObject(iLoop).Property_Value = sPropertyValue
            //        sBackColor = OSAEApi.GetObjectProperty(aScreenObject(iLoop).Control_Name, "Back Color")
            //        sForeColor = OSAEApi.GetObjectProperty(aScreenObject(iLoop).Control_Name, "Fore Color")
            //        aControlTimerLabel(iTimerLabelCount).Tag = iLoop
            //        sState = OSAEApi.GetObjectState(aScreenObject(iLoop).Object_Name)
            //        aScreenObject(iLoop).Object_State = sState
            //        CMD.Parameters.Clear()

            //        CMD.CommandText = "SELECT COALESCE(last_updated,NOW()) FROM osae_v_object WHERE object_name=?ObjectName"
            //        CMD.Parameters.AddWithValue("?ObjectName", aScreenObject(iLoop).Object_Name)
            //        try
            //        {
            //            CN.Open();
            //            aScreenObject(iLoop).Object_Last_Updated = CMD.ExecuteScalar;
            //            CN.Close();
            //        }
            //        catch (MySqlException myerror)
            //        {
            //            MessageBox.Show("GUI Error Load_Objects 2.7: " & myerror.Message);
            //            CN.Close();
            //        }
            //        CMD.Parameters.Clear();
            //        CMD.CommandText = "SELECT COALESCE(last_state_change,NOW()) FROM osae_v_object WHERE object_name=?ObjectName";
            //        CMD.Parameters.AddWithValue("?ObjectName", aScreenObject(iLoop).Object_Name);
            //        try
            //        {
            //            CN.Open();
            //            aScreenObject(iLoop).Object_State_Time = CMD.ExecuteScalar;
            //            CN.Close();
            //        }
            //        catch (MySqlException myerror)
            //        {
            //            MessageBox.Show("GUI Error Load_Objects 666: " & myerror.Message);
            //            CN.Close();
            //        }
            //        iX = Val("" & OSAEApi.GetObjectProperty(aScreenObject(iLoop).Control_Name, "X"));
            //        iY = Val("" & OSAEApi.GetObjectProperty(aScreenObject(iLoop).Control_Name, "Y"));
            //        if (sBackColor <> "")
            //        {
            //            try
            //            {
            //                aControlTimerLabel(aScreenObject(iLoop).Control_Index).BackColor = Color.FromName(sBackColor);
            //            }
            //            catch (MySqlException myerror)
            //            {}
            //        }
            //        if (sForeColor <> "")
            //                    {
            //            try
            //            {
            //                aControlTimerLabel(aScreenObject(iLoop).Control_Index).ForeColor = Color.FromName(sForeColor)
            //            }
            //        catch (MySqlException myerror)
            //        {}
            //            }
            //        aControlTimerLabel(aScreenObject(iLoop).Control_Index).Text = sPropertyValue;
            //        aControlTimerLabel(aScreenObject(iLoop).Control_Index).Width = sPropertyValue.Length * 7;
            //        aControlTimerLabel(aScreenObject(iLoop).Control_Index).Left = iX;
            //        aControlTimerLabel(aScreenObject(iLoop).Control_Index).Top = iY;
            //        aControlTimerLabel(aScreenObject(iLoop).Control_Index).BringToFront();
            //        aControlTimerLabel(aScreenObject(iLoop).Control_Index).Visible = True;
            //    else if (aScreenObject(iLoop).Control_Type = "CONTROL METHOD IMAGE")
            //        iMethodImageCount = iMethodImageCount + 1
            //        aScreenObject(iLoop).Object_Name = OSAEApi.GetObjectProperty(aScreenObject(iLoop).Control_Name, "Object Name")
            //        aScreenObject(iLoop).Control_Index = iMethodImageCount
            //        aControlMethodImage(aControlMethodImage.Count).Tag = iLoop
            //        g_toolTip.SetToolTip(aControlMethodImage(iMethodImageCount), aScreenObject(iLoop).Object_Name)
            //        CMD.Parameters.Clear()
            //        try
            //        {
            //            sImage = OSAEApi.GetObjectProperty(aScreenObject(iLoop).Control_Name, "Image");
            //            sImage = sImage.Replace(".\", "\");
            //            If File.Exists(gAppPath & sImage) Then sImage = gAppPath & sImage
            //            iZOrder = Val(OSAEApi.GetObjectProperty(aScreenObject(iLoop).Control_Name, "ZOrder"));
            //            iX = Val("" & OSAEApi.GetObjectProperty(aScreenObject(iLoop).Control_Name, "X"));
            //            iY = Val("" & OSAEApi.GetObjectProperty(aScreenObject(iLoop).Control_Name, "Y"));
            //            if (File.Exists(sImage))
            //            {
            //                aControlMethodImage(aScreenObject(iLoop).Control_Index).Image = Image.FromFile(sImage);
            //                aScreenObject(iLoop).Object_State = ""
            //                aControlMethodImage(aScreenObject(iLoop).Control_Index).Left = iX;
            //                aControlMethodImage(aScreenObject(iLoop).Control_Index).Top = iY;
            //                aControlMethodImage(aScreenObject(iLoop).Control_Index).Visible = True;
            //            }
            //            else
            //            {
            //                aControlMethodImage(aScreenObject(iLoop).Control_Index).Image = Nothing;
            //                aControlMethodImage(aScreenObject(iLoop).Control_Index).Visible = False;
            //            }
            //        }
            //         catch (MySqlException myerror)
            //        {
            //            MessageBox.Show("GUI Error Load_Objects 4: " + myerror.Message);
            //            CN.Close();
            //         }
            else if (dso.Control_Type == "CONTROL NAVIGATION IMAGE")
            {
                    dso.Object_Name = OSAEApi.GetObjectProperty(dso.Control_Name, "Screen");
                    dso.Object_State = "";
                    Image dni = new Image();
                    dni.Tag = dso.Object_Name;
                    //aControlNavImage(iNavImageCount).Tag = iLoop
                   // g_toolTip.SetToolTip(aControlNavImage(iNavImageCount), aScreenObject(iLoop).Object_Name)
                    CMD.Parameters.Clear();
                    try
                    {
                        sImage = OSAEApi.GetObjectProperty(dso.Control_Name, "Image");
                        if (File.Exists(OSAEApi.APIpath + sImage))
                        {
                            sImage = OSAEApi.APIpath + sImage;
                        }
                        OSAE.ObjectProperty pZOrder = OSAEApi.GetObjectPropertyValue(dso.Control_Name, "ZOrder");
                        OSAE.ObjectProperty pX = OSAEApi.GetObjectPropertyValue(dso.Control_Name, "X");
                        OSAE.ObjectProperty pY = OSAEApi.GetObjectPropertyValue(dso.Control_Name, "Y");
                        if (File.Exists(sImage))
                        {
                            canGUI.Children.Add(dni);
                            Double dX = Convert.ToDouble(pX.Value);
                            Canvas.SetLeft(dni, dX);
                            Double dY = Convert.ToDouble(pY.Value);
                            Canvas.SetTop(dni, dY);

                            byte[] byteArray = File.ReadAllBytes(sImage);
                            var imageStream = new MemoryStream(byteArray);
                            var bitmapImage = new BitmapImage();

                            bitmapImage.BeginInit();
                            bitmapImage.StreamSource = imageStream;
                            bitmapImage.EndInit();
                        //canGUI.Background = new ImageBrush(bitmapImage);

                            dni.Source = bitmapImage;

                            if (pZOrder.Value == "0")
                            {
                                // dsi.SendToBack();
                            }
                            else
                            {
                                // dsi.BringToFront();
                            }
                     }
                   }
                    catch (MySqlException myerror)
                    {
                        MessageBox.Show("GUI Error Load_Objects 5: " + myerror.Message);
                        CN.Close();
                    }
            }

            //    ElseIf aScreenObject(iLoop).Control_Type = "USER CONTROL" Then
            //        iUserControlCount += 1
            //        Dim sUCType As String = OSAEApi.GetObjectProperty(aScreenObject(iLoop).Control_Name, "Control Type")
            //                 If sUCType = "USER CONTROL WEATHER" Then
            //            Me.Controls.Add(New ucWeather)
            //            aScreenObject(iLoop).Control_Index = Me.Controls.Count - 1
            //            Me.Controls(aScreenObject(iLoop).Control_Index).Top = OSAEApi.GetObjectProperty(aScreenObject(iLoop).Control_Name, "Y")
            //            Me.Controls(aScreenObject(iLoop).Control_Index).Left = OSAEApi.GetObjectProperty(aScreenObject(iLoop).Control_Name, "X")
            //            Me.Controls(aScreenObject(iLoop).Control_Index).BringToFront()

            //            '
            //        End If
            //    End If
            //If iStateImageList.EndsWith(",") Then iStateImageList = iStateImageList.Substring(0, iStateImageList.Length - 1)
            //Timer1.Enabled = True
            }
        }
コード例 #3
0
        private void Load_Objects(String sScreen)
        {
            MySqlCommand CMD = new MySqlCommand();
            //   MySqlDataReader myReader = new MySqlDataReader();
            String sState      = "";
            String sStateMatch = "";
            String sImage      = "";


            CMD.Connection  = CN;
            CMD.CommandType = CommandType.Text;

            //COUNT **ALL** control objects for this screen
            //CMD.CommandText = "SELECT COUNT(*) as Results FROM osae_v_screen_object WHERE screen_name=?pscreen";
            //CMD.Parameters.AddWithValue("?pscreen", sScreen);
            //try
            //{
            //    CN.Open();
            //    iObjectCount = Convert.ToInt32(CMD.ExecuteScalar());
            //    CN.Close();
            //}
            //catch (Exception myerror)
            //{
            //    MessageBox.Show("GUI Error Load_Objects 1: " + myerror.Message);
            //    CN.Close();
            //}
            CMD.Parameters.Clear();
            //Select **ALL** control objects for this screen
            CMD.CommandText = "SELECT * FROM osae_v_object_property WHERE object_id IN(SELECT control_id FROM osae_v_screen_object WHERE screen_name=?pscreen) AND property_name='ZOrder' ORDER BY property_value";
            CMD.Parameters.AddWithValue("?pscreen", sScreen);
            try
            {
                CN.Open();
                MySqlDataReader myReader = CMD.ExecuteReader();
                while (myReader.Read())
                {
                    ScreenObject so = new ScreenObject();
                    so.Control_Name = Convert.ToString(myReader.GetString("object_name"));
                    so.Control_Type = Convert.ToString(myReader.GetString("object_type"));
                    aScreenObject.Add(so);
                }
                CN.Close();
            }
            catch (MySqlException myerror)
            {
                MessageBox.Show("GUI Error Load_Objects 2: " + myerror.Message);
                CN.Close();
            }
            CMD.Parameters.Clear();
            foreach (ScreenObject dso in aScreenObject)
            {
                if (dso.Control_Type == "CONTROL STATE IMAGE")
                {
                    dso.Object_Name = OSAEApi.GetObjectProperty(dso.Control_Name, "Object Name");
                    Image dsi = new Image();
                    dsi.Tag = dso.Object_Name;
                    dsi.MouseLeftButtonDown += new MouseButtonEventHandler(State_Image_MouseLeftButtonDown);
                    sState = OSAEApi.GetObjectState(dso.Object_Name);
                    CMD.Parameters.Clear();
                    CMD.CommandText = "SELECT COALESCE(last_state_change,NOW()) FROM osae_v_object WHERE object_name=?ObjectName";
                    CMD.Parameters.AddWithValue("?ObjectName", dso.Object_Name);
                    try
                    {
                        CN.Open();
                        dso.Object_State_Time = Convert.ToString(CMD.ExecuteScalar());
                        CN.Close();
                    }
                    catch (Exception myerror)
                    {
                        MessageBox.Show("GUI Error Load_Objects 2.5: " + myerror.Message);
                        CN.Close();
                    }
                    CMD.Parameters.Clear();
                    CMD.CommandText = "SELECT property_name FROM osae_v_object_property WHERE object_name=?ObjectName AND property_value=?pstate";
                    CMD.Parameters.AddWithValue("?ObjectName", dso.Control_Name);
                    CMD.Parameters.AddWithValue("?pstate", sState);
                    try
                    {
                        CN.Open();
                        sStateMatch = Convert.ToString(CMD.ExecuteScalar());
                        CN.Close();
                        if (sStateMatch != "")
                        {
                            sStateMatch = sStateMatch.Substring(0, 7);
                        }
                        sImage = OSAEApi.GetObjectProperty(dso.Control_Name, sStateMatch + " Image");
                        if (File.Exists(OSAEApi.APIpath + sImage))
                        {
                            sImage = OSAEApi.APIpath + sImage;
                        }

                        OSAE.ObjectProperty pZOrder = OSAEApi.GetObjectPropertyValue(dso.Control_Name, "ZOrder");
                        OSAE.ObjectProperty pX      = OSAEApi.GetObjectPropertyValue(dso.Control_Name, sStateMatch + " X");
                        OSAE.ObjectProperty pY      = OSAEApi.GetObjectPropertyValue(dso.Control_Name, sStateMatch + " Y");
                        dso.Object_State = sState;
                        dso.ScreenImage  = dsi;
                        if (File.Exists(sImage))
                        {
                            canGUI.Children.Add(dsi);

                            Double dX = Convert.ToDouble(pX.Value);
                            Canvas.SetLeft(dsi, dX);
                            Double dY = Convert.ToDouble(pY.Value);
                            Canvas.SetTop(dsi, dY);

                            byte[] byteArray   = File.ReadAllBytes(sImage);
                            var    imageStream = new MemoryStream(byteArray);
                            var    bitmapImage = new BitmapImage();

                            bitmapImage.BeginInit();
                            bitmapImage.StreamSource = imageStream;
                            bitmapImage.EndInit();
                            //canGUI.Background = new ImageBrush(bitmapImage);

                            dsi.Source = bitmapImage;

                            if (pZOrder.Value == "0")
                            {
                                // dsi.SendToBack();
                            }
                            else
                            {
                                // dsi.BringToFront();
                            }
                            dsi.Visibility = System.Windows.Visibility.Visible;
                        }
                        else
                        {
                            dsi.Source     = null;
                            dsi.Visibility = System.Windows.Visibility.Hidden;
                        }
                    }
                    catch (Exception myerror)
                    {
                        MessageBox.Show("GUI Error Load_Objects 3: " + myerror.Message);
                        CN.Close();
                    }
                }
                else if (dso.Control_Type == "CONTROL PROPERTY LABEL")
                {
                    dso.Object_Name = OSAEApi.GetObjectProperty(dso.Control_Name, "Object Name");
                    String sPropertyName = OSAEApi.GetObjectProperty(dso.Control_Name, "Property Name");
                    dso.Property_Name = sPropertyName;
                    String sPropertyValue = OSAEApi.GetObjectProperty(dso.Object_Name, sPropertyName);
                    String sBackColor     = OSAEApi.GetObjectProperty(dso.Control_Name, "Back Color");
                    String sForeColor     = OSAEApi.GetObjectProperty(dso.Control_Name, "Fore Color");
                    String sPrefix        = OSAEApi.GetObjectProperty(dso.Control_Name, "Prefix");
                    String sSuffix        = OSAEApi.GetObjectProperty(dso.Control_Name, "Suffix");
                    String iFontSize      = OSAEApi.GetObjectProperty(dso.Control_Name, "Font Size");
                    String sFontName      = OSAEApi.GetObjectProperty(dso.Control_Name, "Font Name");
                    Label  dpl            = new Label();
                    dpl.Tag = dso.Object_Name;
                    OSAE.ObjectProperty pX = OSAEApi.GetObjectPropertyValue(dso.Control_Name, "X");
                    OSAE.ObjectProperty pY = OSAEApi.GetObjectPropertyValue(dso.Control_Name, "Y");
                    canGUI.Children.Add(dpl);
                    dso.ScreenLabel = dpl;
                    Double dX = Convert.ToDouble(pX.Value);
                    Canvas.SetLeft(dpl, dX);
                    Double dY = Convert.ToDouble(pY.Value);
                    Canvas.SetTop(dpl, dY);
                    if (sPropertyValue != "")
                    {
                        if (sBackColor != "")
                        {
                            try
                            {
                                BrushConverter  conv  = new BrushConverter();
                                SolidColorBrush brush = conv.ConvertFromString(sBackColor) as SolidColorBrush;
                                dpl.Background = brush;
                            }
                            catch (Exception myerror)
                            {
                            }
                        }
                        if (sForeColor != "")
                        {
                            try
                            {
                                BrushConverter  conv  = new BrushConverter();
                                SolidColorBrush brush = conv.ConvertFromString(sForeColor) as SolidColorBrush;
                                dpl.Foreground = brush;
                            }
                            catch (Exception myerror)
                            {
                            }
                        }
                        if (iFontSize != "")
                        {
                            try
                            {
                                dpl.FontSize = Convert.ToDouble(iFontSize);
                            }
                            catch (Exception myerror)
                            {
                            }
                        }
                        dpl.Content      = sPrefix + sPropertyValue + sSuffix;
                        dso.Object_State = "";
                    }
                    else
                    {
                        dpl.Content = "";
                    }
                }
                else if (dso.Control_Type == "CONTROL STATIC LABEL")
                {
                    dso.Object_Name = OSAEApi.GetObjectProperty(dso.Control_Name, "Object Name");
                    String sPropertyValue = OSAEApi.GetObjectProperty(dso.Object_Name, "Value");
                    String sBackColor     = OSAEApi.GetObjectProperty(dso.Control_Name, "Back Color");
                    String sForeColor     = OSAEApi.GetObjectProperty(dso.Control_Name, "Fore Color");
                    Label  dsl            = new Label();
                    dsl.Tag = dso.Object_Name;
                    OSAE.ObjectProperty pX = OSAEApi.GetObjectPropertyValue(dso.Control_Name, "X");
                    OSAE.ObjectProperty pY = OSAEApi.GetObjectPropertyValue(dso.Control_Name, "Y");
                    canGUI.Children.Add(dsl);
                    Double dX = Convert.ToDouble(pX.Value);
                    Canvas.SetLeft(dsl, dX);
                    Double dY = Convert.ToDouble(pY.Value);
                    Canvas.SetTop(dsl, dY);
                    if (sPropertyValue != "")
                    {
                        if (sBackColor != "")
                        {
                            try
                            {
                                BrushConverter  conv  = new BrushConverter();
                                SolidColorBrush brush = conv.ConvertFromString(sBackColor) as SolidColorBrush;
                                dsl.Background = brush;
                            }
                            catch (Exception myerror)
                            {
                            }
                        }
                        if (sForeColor != "")
                        {
                            try
                            {
                                BrushConverter  conv  = new BrushConverter();
                                SolidColorBrush brush = conv.ConvertFromString(sForeColor) as SolidColorBrush;
                                dsl.Foreground = brush;
                            }
                            catch (Exception myerror)
                            {
                            }
                        }
                        dsl.Content = sPropertyValue;
                    }
                    else
                    {
                        dsl.Content = "";
                    }
                }

                //    else if aScreenObject(iLoop).Control_Type = "CONTROL TIMER LABEL" Then
                //        iTimerLabelCount = iTimerLabelCount + 1
                //        aScreenObject(iLoop).Control_Index = iTimerLabelCount
                //        aScreenObject(iLoop).Object_Name = OSAEApi.GetObjectProperty(aScreenObject(iLoop).Control_Name, "Object Name")
                //        sPropertyName = OSAEApi.GetObjectProperty(aScreenObject(iLoop).Control_Name, "Type")
                //        aScreenObject(iLoop).Property_Name = sPropertyName
                //        sPropertyValue = OSAEApi.GetObjectProperty(aScreenObject(iLoop).Object_Name, "OFF Timer")
                //        aScreenObject(iLoop).Property_Value = sPropertyValue
                //        sBackColor = OSAEApi.GetObjectProperty(aScreenObject(iLoop).Control_Name, "Back Color")
                //        sForeColor = OSAEApi.GetObjectProperty(aScreenObject(iLoop).Control_Name, "Fore Color")
                //        aControlTimerLabel(iTimerLabelCount).Tag = iLoop
                //        sState = OSAEApi.GetObjectState(aScreenObject(iLoop).Object_Name)
                //        aScreenObject(iLoop).Object_State = sState
                //        CMD.Parameters.Clear()

                //        CMD.CommandText = "SELECT COALESCE(last_updated,NOW()) FROM osae_v_object WHERE object_name=?ObjectName"
                //        CMD.Parameters.AddWithValue("?ObjectName", aScreenObject(iLoop).Object_Name)
                //        try
                //        {
                //            CN.Open();
                //            aScreenObject(iLoop).Object_Last_Updated = CMD.ExecuteScalar;
                //            CN.Close();
                //        }
                //        catch (MySqlException myerror)
                //        {
                //            MessageBox.Show("GUI Error Load_Objects 2.7: " & myerror.Message);
                //            CN.Close();
                //        }
                //        CMD.Parameters.Clear();
                //        CMD.CommandText = "SELECT COALESCE(last_state_change,NOW()) FROM osae_v_object WHERE object_name=?ObjectName";
                //        CMD.Parameters.AddWithValue("?ObjectName", aScreenObject(iLoop).Object_Name);
                //        try
                //        {
                //            CN.Open();
                //            aScreenObject(iLoop).Object_State_Time = CMD.ExecuteScalar;
                //            CN.Close();
                //        }
                //        catch (MySqlException myerror)
                //        {
                //            MessageBox.Show("GUI Error Load_Objects 666: " & myerror.Message);
                //            CN.Close();
                //        }
                //        iX = Val("" & OSAEApi.GetObjectProperty(aScreenObject(iLoop).Control_Name, "X"));
                //        iY = Val("" & OSAEApi.GetObjectProperty(aScreenObject(iLoop).Control_Name, "Y"));
                //        if (sBackColor <> "")
                //        {
                //            try
                //            {
                //                aControlTimerLabel(aScreenObject(iLoop).Control_Index).BackColor = Color.FromName(sBackColor);
                //            }
                //            catch (MySqlException myerror)
                //            {}
                //        }
                //        if (sForeColor <> "")
                //                    {
                //            try
                //            {
                //                aControlTimerLabel(aScreenObject(iLoop).Control_Index).ForeColor = Color.FromName(sForeColor)
                //            }
                //        catch (MySqlException myerror)
                //        {}
                //            }
                //        aControlTimerLabel(aScreenObject(iLoop).Control_Index).Text = sPropertyValue;
                //        aControlTimerLabel(aScreenObject(iLoop).Control_Index).Width = sPropertyValue.Length * 7;
                //        aControlTimerLabel(aScreenObject(iLoop).Control_Index).Left = iX;
                //        aControlTimerLabel(aScreenObject(iLoop).Control_Index).Top = iY;
                //        aControlTimerLabel(aScreenObject(iLoop).Control_Index).BringToFront();
                //        aControlTimerLabel(aScreenObject(iLoop).Control_Index).Visible = True;
                //    else if (aScreenObject(iLoop).Control_Type = "CONTROL METHOD IMAGE")
                //        iMethodImageCount = iMethodImageCount + 1
                //        aScreenObject(iLoop).Object_Name = OSAEApi.GetObjectProperty(aScreenObject(iLoop).Control_Name, "Object Name")
                //        aScreenObject(iLoop).Control_Index = iMethodImageCount
                //        aControlMethodImage(aControlMethodImage.Count).Tag = iLoop
                //        g_toolTip.SetToolTip(aControlMethodImage(iMethodImageCount), aScreenObject(iLoop).Object_Name)
                //        CMD.Parameters.Clear()
                //        try
                //        {
                //            sImage = OSAEApi.GetObjectProperty(aScreenObject(iLoop).Control_Name, "Image");
                //            sImage = sImage.Replace(".\", "\");
                //            If File.Exists(gAppPath & sImage) Then sImage = gAppPath & sImage
                //            iZOrder = Val(OSAEApi.GetObjectProperty(aScreenObject(iLoop).Control_Name, "ZOrder"));
                //            iX = Val("" & OSAEApi.GetObjectProperty(aScreenObject(iLoop).Control_Name, "X"));
                //            iY = Val("" & OSAEApi.GetObjectProperty(aScreenObject(iLoop).Control_Name, "Y"));
                //            if (File.Exists(sImage))
                //            {
                //                aControlMethodImage(aScreenObject(iLoop).Control_Index).Image = Image.FromFile(sImage);
                //                aScreenObject(iLoop).Object_State = ""
                //                aControlMethodImage(aScreenObject(iLoop).Control_Index).Left = iX;
                //                aControlMethodImage(aScreenObject(iLoop).Control_Index).Top = iY;
                //                aControlMethodImage(aScreenObject(iLoop).Control_Index).Visible = True;
                //            }
                //            else
                //            {
                //                aControlMethodImage(aScreenObject(iLoop).Control_Index).Image = Nothing;
                //                aControlMethodImage(aScreenObject(iLoop).Control_Index).Visible = False;
                //            }
                //        }
                //         catch (MySqlException myerror)
                //        {
                //            MessageBox.Show("GUI Error Load_Objects 4: " + myerror.Message);
                //            CN.Close();
                //         }
                else if (dso.Control_Type == "CONTROL NAVIGATION IMAGE")
                {
                    dso.Object_Name  = OSAEApi.GetObjectProperty(dso.Control_Name, "Screen");
                    dso.Object_State = "";
                    Image dni = new Image();
                    dni.Tag = dso.Object_Name;
                    //aControlNavImage(iNavImageCount).Tag = iLoop
                    // g_toolTip.SetToolTip(aControlNavImage(iNavImageCount), aScreenObject(iLoop).Object_Name)
                    CMD.Parameters.Clear();
                    try
                    {
                        sImage = OSAEApi.GetObjectProperty(dso.Control_Name, "Image");
                        if (File.Exists(OSAEApi.APIpath + sImage))
                        {
                            sImage = OSAEApi.APIpath + sImage;
                        }
                        OSAE.ObjectProperty pZOrder = OSAEApi.GetObjectPropertyValue(dso.Control_Name, "ZOrder");
                        OSAE.ObjectProperty pX      = OSAEApi.GetObjectPropertyValue(dso.Control_Name, "X");
                        OSAE.ObjectProperty pY      = OSAEApi.GetObjectPropertyValue(dso.Control_Name, "Y");
                        if (File.Exists(sImage))
                        {
                            canGUI.Children.Add(dni);
                            Double dX = Convert.ToDouble(pX.Value);
                            Canvas.SetLeft(dni, dX);
                            Double dY = Convert.ToDouble(pY.Value);
                            Canvas.SetTop(dni, dY);

                            byte[] byteArray   = File.ReadAllBytes(sImage);
                            var    imageStream = new MemoryStream(byteArray);
                            var    bitmapImage = new BitmapImage();

                            bitmapImage.BeginInit();
                            bitmapImage.StreamSource = imageStream;
                            bitmapImage.EndInit();
                            //canGUI.Background = new ImageBrush(bitmapImage);

                            dni.Source = bitmapImage;

                            if (pZOrder.Value == "0")
                            {
                                // dsi.SendToBack();
                            }
                            else
                            {
                                // dsi.BringToFront();
                            }
                        }
                    }
                    catch (MySqlException myerror)
                    {
                        MessageBox.Show("GUI Error Load_Objects 5: " + myerror.Message);
                        CN.Close();
                    }
                }

                //    ElseIf aScreenObject(iLoop).Control_Type = "USER CONTROL" Then
                //        iUserControlCount += 1
                //        Dim sUCType As String = OSAEApi.GetObjectProperty(aScreenObject(iLoop).Control_Name, "Control Type")
                //                 If sUCType = "USER CONTROL WEATHER" Then
                //            Me.Controls.Add(New ucWeather)
                //            aScreenObject(iLoop).Control_Index = Me.Controls.Count - 1
                //            Me.Controls(aScreenObject(iLoop).Control_Index).Top = OSAEApi.GetObjectProperty(aScreenObject(iLoop).Control_Name, "Y")
                //            Me.Controls(aScreenObject(iLoop).Control_Index).Left = OSAEApi.GetObjectProperty(aScreenObject(iLoop).Control_Name, "X")
                //            Me.Controls(aScreenObject(iLoop).Control_Index).BringToFront()

                //            '
                //        End If
                //    End If
                //If iStateImageList.EndsWith(",") Then iStateImageList = iStateImageList.Substring(0, iStateImageList.Length - 1)
                //Timer1.Enabled = True
            }
        }