Exemplo n.º 1
0
        private void frmInstructionEditor_Load(object sender, EventArgs e)
        {
            SANWA.Utility.Controlling  controlling;
            SANWA.Utility.ContainerSet container;
            DataView dvTemp;

            try
            {
                controlling = new SANWA.Utility.Controlling();
                container   = new SANWA.Utility.ContainerSet();


                strsEquipmentType      = Properties.Settings.Default.EquipmentType.Cast <string>().ToArray();
                strsCommandType        = Properties.Settings.Default.CommandType.Cast <string>().ToArray();
                strsEquipment_Supplier = Properties.Settings.Default.Equipment_Supplier.Cast <string>().ToArray();


                strsCommand_Parameter_Columns = Properties.Settings.Default.Command_Parameter_Columns.Cast <string>().ToArray();

                //controlling.ListBox_ItemChange(ref lsbCreateCommandType, strsCommandType);
                //controlling.ListBox_ItemChange(ref lsbCreateEqpSupplier, strsEquipment_Supplier);
                //controlling.ListBox_ItemChange(ref lsbCreateEqpType, strsEquipmentType);

                if (File.Exists(System.AppDomain.CurrentDomain.BaseDirectory + "ParameterList.xml"))
                {
                    container.TableFormatting(ref dtParameterList, System.AppDomain.CurrentDomain.BaseDirectory + "ParameterList.xml");
                }
                else
                {
                    container.TableFormatting(ref dtParameterList, "Table", strsCommand_Parameter_Columns);
                }

                if (File.Exists(System.AppDomain.CurrentDomain.BaseDirectory + "Code.xml"))
                {
                    container.TableFormatting(ref dtCode, System.AppDomain.CurrentDomain.BaseDirectory + "Code.xml");
                }

                if (dtCode.Rows.Count > 0)
                {
                    dvTemp           = new DataView(dtCode);
                    dvTemp.RowFilter = "Category_ID = 'System'";
                    controlling.ListBox_ItemChange(ref lsbCreateEqpType, dvTemp.ToTable().Copy().Select("Code_Type = 'EquipmentType'"), "Code_ID", "Code_ID");
                    lsbCreateEqpType.SelectedIndex = -1;

                    controlling.ListBox_ItemChange(ref lsbCreateEqpSupplier, dvTemp.ToTable().Copy().Select("Code_Type = 'EquipmentSupplier'"), "Code_ID", "Code_ID");
                    lsbCreateEqpSupplier.SelectedIndex = -1;
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString(), "Exception Message", MessageBoxButtons.OK, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading);
            }
            finally
            {
                controlling = null;
                container   = null;
            }
        }
Exemplo n.º 2
0
        private void frmCodeManager_Load(object sender, EventArgs e)
        {
            SANWA.Utility.Controlling  controlling;
            SANWA.Utility.ContainerSet containerSet;

            try
            {
                controlling  = new SANWA.Utility.Controlling();
                containerSet = new SANWA.Utility.ContainerSet();
                dtCode       = new DataTable();
                dtCategory   = new DataTable();

                strColumsn  = Properties.Settings.Default.Code_Columns.Cast <string>().ToArray();
                strCategory = Properties.Settings.Default.Category.Cast <string>().ToArray();

                if (File.Exists(System.AppDomain.CurrentDomain.BaseDirectory + "Code.xml"))
                {
                    containerSet.TableFormatting(ref dtCode, System.AppDomain.CurrentDomain.BaseDirectory + "Code.xml");
                }
                else
                {
                    containerSet.TableFormatting(ref dtCode, "Table", strCategory);
                }
                containerSet.TableFormatting(ref dtCategory, "Table", new string[] { "ID", "NAME" });

                foreach (string item in strCategory)
                {
                    if (string.IsNullOrEmpty(item.Trim()))
                    {
                        continue;
                    }

                    dtCategory.Rows.Add(item.Split(','));
                }

                controlling.ListBox_ItemChange(ref lsbQueryCondition, dtCategory.Select(), "ID", "NAME");
                controlling.ListBox_ItemChange(ref lsbEditorCategoryID, dtCategory.Select(), "ID", "NAME");

                lsbQueryCondition.SelectedIndex   = -1;
                lsbEditorCategoryID.SelectedIndex = -1;
                txbEditorCategoryName.Text        = string.Empty;
                txbQueryCategoryName.Text         = string.Empty;

                dgvCode.DataSource = dtCode;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString(), "Exception Message", MessageBoxButtons.OK, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading);
            }
            finally
            {
                controlling  = null;
                containerSet = null;
            }
        }
Exemplo n.º 3
0
        private void lsbCreateCommand_Click(object sender, EventArgs e)
        {
            SANWA.Utility.Controlling controlling;

            try
            {
                lsbCreateCommandParameter.DataSource = null;

                if (dtParameterList.Rows.Count == 0)
                {
                    nudParameterOrder.Value = 1;
                    return;
                }

                controlling = new SANWA.Utility.Controlling();

                var query = (from a in dtParameterList.AsEnumerable()
                             where a.Field <string>("Equipment_Type") == lsbCreateEqpType.Text &&
                             a.Field <string>("Equipment_Supplier") == lsbCreateEqpSupplier.Text &&
                             a.Field <string>("Command_Type") == lsbCreateCommandType.Text &&
                             a.Field <string>("Command_ID") == lsbCreateCommand.Text
                             select a).ToList();

                if (query.Count > 0)
                {
                    controlling.ListBox_ItemChange(ref lsbCreateCommandParameter, query.CopyToDataTable().Select(), "Parameter_ID", "Parameter_ID");
                    nudParameterOrder.Value = Convert.ToInt32(query.CopyToDataTable().Rows[query.CopyToDataTable().Rows.Count - 1]["Parameter_Order"].ToString()) + 1;
                    lsbCreateCommandParameter.SelectedIndex = -1;
                }
                else
                {
                    nudParameterOrder.Value = 1;
                }

                txbParameterID.Text          = string.Empty;
                txbParameterDescription.Text = string.Empty;
                txbEditorParameterData.Text  = string.Empty;
                nudMAXValue.Value            = 0;
                nudMINValue.Value            = 0;
                nudValueLength.Value         = 0;
                nudDefaultValue.Value        = 0;
                chbIsFill.Checked            = false;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString(), "Exception Message", MessageBoxButtons.OK, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading);
            }
        }
Exemplo n.º 4
0
        private void lsbQueryCondition_Click(object sender, EventArgs e)
        {
            SANWA.Utility.Controlling controlling;
            DataView dvTemp;

            DataRow[] drsTemp;
            ArrayList alTemp;

            try
            {
                if (((ListBox)sender).SelectedIndex >= 0)
                {
                    switch (((ListBox)sender).Name)
                    {
                    case "lsbQueryCondition":
                        txbQueryCategoryName.Text = ((ListBox)sender).SelectedValue.ToString();

                        if (dgvCode.DataSource != null)
                        {
                            dvTemp             = new DataView(dtCode);
                            dvTemp.RowFilter   = "Category_ID = '" + ((ListBox)sender).Text + "'";
                            dgvCode.DataSource = dvTemp.ToTable();
                        }

                        break;

                    case "lsbEditorCategoryID":
                        txbEditorCategoryName.Text = ((ListBox)sender).SelectedValue.ToString();
                        controlling = new SANWA.Utility.Controlling();

                        // * Code Type Add
                        alTemp  = new ArrayList();
                        drsTemp = dtCode.DefaultView.ToTable(true, new string[] { "Category_ID", "Code_Type" }).Select("Category_ID = '" + ((ListBox)sender).Text + "'");

                        foreach (DataRow dr in drsTemp)
                        {
                            alTemp.Add(dr["Code_Type"].ToString());
                        }

                        controlling.ComboBox_ItemChange(ref cmdEditorCodeType, (string[])alTemp.ToArray(typeof(string)));
                        controlling.ListBox_ItemChange(ref lsbEditorCodeType, (string[])alTemp.ToArray(typeof(string)));

                        lsbEditorCodeList.DataSource = null;
                        txbEditorCodeListName.Text   = string.Empty;

                        break;

                    case "lsbEditorCodeType":
                        // * Code List Add
                        controlling = new SANWA.Utility.Controlling();
                        drsTemp     = dtCode.DefaultView.ToTable(true, new string[] { "Category_ID", "Code_Type", "Code_ID", "Code_Name" }).Select("Category_ID = '" + lsbEditorCategoryID.Text + "' AND Code_Type = '" + lsbEditorCodeType.Text + "'");
                        controlling.ListBox_ItemChange(ref lsbEditorCodeList, drsTemp, "Code_ID", "Code_Name");
                        lsbEditorCodeList.SelectedIndex = -1;
                        txbEditorCodeListName.Text      = string.Empty;

                        break;

                    case "lsbEditorCodeList":
                        txbEditorCodeListName.Text = ((ListBox)sender).SelectedValue.ToString();

                        break;
                    }
                }
                else
                {
                    txbQueryCategoryName.Text = string.Empty;
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString(), "Exception Message", MessageBoxButtons.OK, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading);
            }
            finally
            {
                controlling = null;
            }
        }
Exemplo n.º 5
0
        private void lsbCreateEqpType_Click(object sender, EventArgs e)
        {
            if (lsbCreateEqpType.SelectedIndex < 0)
            {
                lsbCreateCommandType.DataSource = null;
                return;
            }

            if (lsbCreateEqpSupplier.SelectedIndex < 0)
            {
                lsbCreateCommandType.DataSource = null;
                return;
            }

            SANWA.Utility.Controlling controlling;
            DataRow[] drsTemp;
            DataRow[] drsCode;
            DataView  dvTemp;

            try
            {
                controlling = new SANWA.Utility.Controlling();

                if (strEqpAssembly.Equals(""))
                {
                    dvTemp           = new DataView(dtCode);
                    dvTemp.RowFilter = "Category_ID = '" + lsbCreateEqpSupplier.SelectedValue + "." + lsbCreateEqpType.SelectedValue + "'";
                    controlling.ListBox_ItemChange(ref lsbCreateCommandType, dvTemp.ToTable(true, new string[] { "Code_Type" }).Copy().Select(""), "Code_Type", "Code_Type");
                    lsbCreateCommandType.SelectedIndex = -1;
                    strEqpAssembly = lsbCreateEqpSupplier.SelectedValue + "." + lsbCreateEqpType.SelectedValue;
                    lsbCreateCommand.DataSource = null;
                    return;
                }
                else if (strEqpAssembly != lsbCreateEqpSupplier.SelectedValue + "." + lsbCreateEqpType.SelectedValue)
                {
                    dvTemp           = new DataView(dtCode);
                    dvTemp.RowFilter = "Category_ID = '" + lsbCreateEqpSupplier.SelectedValue + "." + lsbCreateEqpType.SelectedValue + "'";
                    controlling.ListBox_ItemChange(ref lsbCreateCommandType, dvTemp.ToTable(true, new string[] { "Code_Type" }).Copy().Select(""), "Code_Type", "Code_Type");
                    lsbCreateCommandType.SelectedIndex = -1;
                    strEqpAssembly = lsbCreateEqpSupplier.SelectedValue + "." + lsbCreateEqpType.SelectedValue;
                    lsbCreateCommand.DataSource = null;
                    return;
                }


                if (lsbCreateCommandType.SelectedIndex < 0)
                {
                    return;
                }

                if (lsbCreateCommandType.DataSource != null && lsbCreateCommandType.SelectedIndex >= 0)
                {
                    if (dtCode.Rows.Count > 0)
                    {
                        drsTemp = dtCode.DefaultView.ToTable(true, new string[] { "Category_ID", "Code_Type", "Code_ID", "Code_Name" }).Select("Category_ID = '" + lsbCreateEqpSupplier.Text + "." + lsbCreateEqpType.Text + "' AND Code_Type = '" + lsbCreateCommandType.Text + "'");

                        controlling.ListBox_ItemChange(ref lsbCreateCommand, drsTemp, "Code_ID", "Code_Name");

                        lsbCreateCommand.SelectedIndex       = -1;
                        lsbCreateCommandParameter.DataSource = null;


                        drsCode = dtCode.DefaultView.ToTable(true, new string[] { "Category_ID", "Code_Type", "Code_ID", "Code_Name" }).Select("Category_ID = 'System' AND Code_Type = '" + string.Format("{0}.Command.Format", lsbCreateEqpSupplier.Text) + "'");

                        if (drsCode.Length > 0)
                        {
                            strCommandFormat = drsCode[0]["Code_ID"].ToString();
                        }
                    }
                    else
                    {
                        if (((DataTable)lsbCreateCommand.DataSource) != null)
                        {
                            ((DataTable)lsbCreateCommand.DataSource).Clear();
                            ((DataTable)lsbCreateCommandParameter.DataSource).Clear();
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString(), "Exception Message", MessageBoxButtons.OK, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading);
            }
        }