コード例 #1
0
 public void loadTables()
 {
     listBox1.Items.Clear();
     if (cbTableType.SelectedItem != null)
     {
         int tableTypeId         = ((itemObj)cbTableType.SelectedItem).Id_o;
         List <tablesInfo> tInfo = classesOfMetods.getTableOfType(tableTypeId);
         tInfo.Sort(new DinoComparer());
         if (tInfo.Count > 0)
         {
             for (int i = 0; tInfo.Count > i; i++)
             {
                 if (tInfo[i].nameMap.ToLower().IndexOf(textBox1.Text.ToLower()) > -1)
                 {
                     itemObj item = new itemObj(tInfo[i].idTable,
                                                tInfo[i].nameMap,
                                                tInfo[i].nameDB);
                     listBox1.Items.Add(item);
                 }
             }
         }
         listBox1_SelectedIndexChanged(listBox1, null);
     }
     label1.Text = changeTextOfCount(listBox1.Items.Count);
 }
コード例 #2
0
ファイル: GroupFunct.cs プロジェクト: luckymenslife/autobase
        public List <itemObj> GetGroupsWithTable(int id, bool with)
        {
            List <itemObj> list_of_tables = new List <itemObj>();
            SqlWork        sqlCmd         = new SqlWork();

            if (with)
            {
                sqlCmd.sql = "SELECT * FROM " + Program.scheme + ".get_group_list_for_table(" + id.ToString() + ")";
            }
            else
            {
                sqlCmd.sql = "SELECT * FROM " + Program.scheme + ".get_group_list_no_for_table(" + id.ToString() + ")";
            }

            try
            {
                sqlCmd.Execute(false);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
                sqlCmd.Close();
                return(null);
            }
            while (sqlCmd.CanRead())
            {
                int     id_table   = sqlCmd.GetInt32(0);
                string  name_group = sqlCmd.GetString(1);
                string  descript   = sqlCmd.GetString(2);
                itemObj io         = new itemObj(id_table, name_group, descript);
                list_of_tables.Add(io);
            }
            sqlCmd.Close();
            return(list_of_tables);
        }
コード例 #3
0
        private void comboBox9_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (comboBox9.SelectedItem != null)
            {
                comboBox10.Items.Clear();
                SqlWork sqlCmd = new SqlWork();
                sqlCmd.sql = "SELECT id, name_db, name_map FROM " + Program.scheme + ".table_field_info WHERE (type_field = 1 OR type_field = 6) AND id_table = " + ((itemObj)comboBox9.SelectedItem).Id_o.ToString();
                sqlCmd.Execute(false);
                while (sqlCmd.CanRead())
                {
                    itemObj item = new itemObj(sqlCmd.GetInt32(0), sqlCmd.GetValue <string>(1), sqlCmd.GetValue <string>(2));
                    comboBox10.Items.Add(item);
                }
                sqlCmd.Close();

                comboBox11.Items.Clear();
                sqlCmd     = new SqlWork();
                sqlCmd.sql = "SELECT id, name_db, name_map FROM " + Program.scheme + ".table_field_info WHERE type_field = 2 AND id_table = " + ((itemObj)comboBox9.SelectedItem).Id_o.ToString();
                sqlCmd.Execute(false);
                while (sqlCmd.CanRead())
                {
                    itemObj item = new itemObj(sqlCmd.GetInt32(0), sqlCmd.GetValue <string>(1), sqlCmd.GetValue <string>(2));
                    comboBox11.Items.Add(item);
                }
                sqlCmd.Close();
            }
        }
コード例 #4
0
ファイル: GroupFunct.cs プロジェクト: luckymenslife/autobase
        public itemObj GetGroup(int id_gr)
        {
            itemObj group  = null;
            SqlWork sqlCmd = new SqlWork();

            sqlCmd.sql = "SELECT name_group,descript FROM " + Program.scheme + ".table_groups WHERE id=" + id_gr.ToString();
            try
            {
                sqlCmd.Execute(false);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
                sqlCmd.Close();
                return(null);
            }
            if (sqlCmd.CanRead())
            {
                string name_gr = sqlCmd.GetString(0);
                string desc_gr = sqlCmd.GetString(1);
                group = new itemObj(id_gr, name_gr, desc_gr);//использую уже готовую структуру, вместо Layer там будет храниться описание
            }
            sqlCmd.Close();

            return(group);
        }
コード例 #5
0
        private void cbRefTable_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (cbRefTable.SelectedItem != null)
            {
                cbRefLink.Items.Clear();
                cbRefFieldName.Items.Clear();
                cbFileNameColumn.Items.Clear();

                using (SqlWork sqlCmd = new SqlWork())
                {
                    sqlCmd.sql = "SELECT id, name_db, name_map, type_field FROM " + Program.scheme + ".table_field_info WHERE id_table = " + ((itemObj)cbRefTable.SelectedItem).Id_o.ToString();
                    sqlCmd.Execute(false);

                    while (sqlCmd.CanRead())
                    {
                        int     type_field = sqlCmd.GetInt32("type_field");
                        itemObj item       = new itemObj(sqlCmd.GetInt32(0), sqlCmd.GetValue <string>(1), sqlCmd.GetValue <string>(2));

                        if (type_field == 1 || type_field == 6)
                        {
                            cbRefLink.Items.Add(item);
                        }
                        else if (type_field == 2)
                        {
                            cbRefFieldName.Items.Add(item);
                            cbFileNameColumn.Items.Add(item);
                        }
                    }
                }
            }
        }
コード例 #6
0
        private void loadTableStyleField()
        {
            cbRefStyleField.Items.Clear();
            cbIntervalStyleField.Items.Clear();
            cbAngleColumn.Items.Clear();
            cbAngleColumn.Items.Add(new itemObj(-1, "<Не указано>", null));
            cbAngleColumn.SelectedIndex = 0;
            SqlWork sqlCmd = new SqlWork();

            sqlCmd.sql = String.Format(@"SELECT 
                                            tfi.id, tfi.name_db, tfi.name_map 
                                            FROM sys_scheme.table_field_info tfi
                                            INNER JOIN sys_scheme.table_info ti
                                            ON ti.id = tfi.id_table
                                            WHERE (tfi.type_field = 1 OR tfi.type_field = 6) 
                                                AND tfi.id_table = {0} AND tfi.name_db <> ti.pk_fileld", id);
            sqlCmd.Execute(false);
            while (sqlCmd.CanRead())
            {
                itemObj item = new itemObj(sqlCmd.GetInt32(0), sqlCmd.GetValue <string>(1), sqlCmd.GetValue <string>(2));
                cbRefStyleField.Items.Add(item);
                cbIntervalStyleField.Items.Add(item);
                cbAngleColumn.Items.Add(item);
            }
            sqlCmd.Close();
        }
コード例 #7
0
        private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (comboBox1.SelectedItem != null)
            {
                panel1.Visible = true;
                listBox1.Items.Clear();
                listt = gf.GetListTablesInOrOutGroup((comboBox1.SelectedItem as itemObj).Id_o, true);
                itemObjOrdered[] it = new itemObjOrdered[listt.Count];
                listt.CopyTo(it);
                listBox1.Items.AddRange(it);

                listBox2.Items.Clear();
                List <itemObjOrdered> listt2 = gf.GetListTablesInOrOutGroup((comboBox1.SelectedItem as itemObj).Id_o, false);
                itemObjOrdered[]      it2    = new itemObjOrdered[listt2.Count];
                listt2.CopyTo(it2);
                listBox2.Items.AddRange(it2);

                itemObj gr = gf.GetGroup((comboBox1.SelectedItem as itemObj).Id_o);
                textBox2.Text = gr.Layer;

                label6.Text = changeTextOfCount(listBox1.Items.Count);
                label7.Text = changeTextOfCount(listBox2.Items.Count);
            }
            else
            {
                panel1.Visible = false;
            }
        }
コード例 #8
0
        private void loadTables()
        {
            cbRefTable.Items.Clear();
            cbIntervalTable.Items.Clear();

            SqlWork sqlCmd = new SqlWork();

            sqlCmd.sql = "SELECT id, name_db, name_map, type FROM " + Program.scheme + ".table_info ti WHERE map_style = true ORDER BY name_db";
            sqlCmd.Execute(false);

            int max_width_1 = 0, max_width_2 = 0;

            while (sqlCmd.CanRead())
            {
                itemObj item = new itemObj(sqlCmd.GetInt32(0),
                                           String.Format("{0} ({1})", sqlCmd.GetValue <string>(1), sqlCmd.GetValue <string>(2)),
                                           sqlCmd.GetValue <string>(1));

                Label tempLabel = new Label();

                switch (sqlCmd.GetInt32(3))
                {
                case 2:
                    cbRefTable.Items.Add(item);

                    tempLabel.Text = item.Name_o;
                    if (tempLabel.PreferredWidth > max_width_1)
                    {
                        max_width_1 = tempLabel.PreferredWidth;
                    }
                    break;

                case 3:
                    cbIntervalTable.Items.Add(item);

                    tempLabel.Text = item.Name_o;
                    if (tempLabel.PreferredWidth > max_width_2)
                    {
                        max_width_2 = tempLabel.PreferredWidth;
                    }
                    break;

                default:
                    break;
                }
            }

            if (max_width_1 > cbRefTable.DropDownWidth)
            {
                cbRefTable.DropDownWidth = max_width_1;
            }
            if (max_width_2 > cbIntervalTable.DropDownWidth)
            {
                cbIntervalTable.DropDownWidth = max_width_2;
            }

            sqlCmd.Close();
        }
コード例 #9
0
 private void loadTableTypes()
 {
     cbTableType.Items.Clear();
     if (Program.tip_table.Count > 0)
     {
         for (int i = 0; Program.tip_table.Count > i; i++)
         {
             itemObj item = new itemObj(Program.tip_table[i].idTipTable,
                                        Program.tip_table[i].nameTip,
                                        Program.tip_table[i].mapLayer.ToString());
             cbTableType.Items.Add(item);
         }
     }
 }
コード例 #10
0
        private void loadColumsForDiapazon(int id_table)
        {
            cbRangeValueField.Items.Clear();
            SqlWork sqlCmd = new SqlWork();

            sqlCmd.sql = "SELECT id, name_db, name_map FROM " + Program.scheme + ".table_field_info WHERE (type_field = 1 OR type_field = 6) AND id_table = " + id_table.ToString();
            sqlCmd.Execute(false);
            while (sqlCmd.CanRead())
            {
                itemObj item = new itemObj(sqlCmd.GetInt32(0), sqlCmd.GetValue <string>(2), sqlCmd.GetValue <string>(1));
                cbRangeValueField.Items.Add(item);
            }
            sqlCmd.Close();
        }
コード例 #11
0
        private void loadTableGeomField()
        {
            cbGeomField.Items.Clear();
            SqlWork sqlCmd = new SqlWork();

            sqlCmd.sql = "SELECT id, name_db, name_map FROM " + Program.scheme + ".table_field_info WHERE type_field = 5 AND id_table = " + id.ToString();
            sqlCmd.Execute(false);
            while (sqlCmd.CanRead())
            {
                itemObj item = new itemObj(sqlCmd.GetInt32(0), sqlCmd.GetValue <string>(1), sqlCmd.GetValue <string>(2));
                cbGeomField.Items.Add(item);
            }
            sqlCmd.Close();
        }
コード例 #12
0
ファイル: TableGroup.cs プロジェクト: luckymenslife/autobase
        private void reload()
        {
            listBox1.Items.Clear();
            listt = gf.GetGroupsWithTable(id, true);//((comboBox1.SelectedItem as itemObj).Id_o, true);
            itemObj[] it = new itemObj[listt.Count];
            listt.CopyTo(it);
            listBox1.Items.AddRange(it);

            listBox2.Items.Clear();
            List <itemObj> listt2 = gf.GetGroupsWithTable(id, false);

            itemObj[] it2 = new itemObj[listt2.Count];
            listt2.CopyTo(it2);
            listBox2.Items.AddRange(it2);

            label1.Text = changeTextOfCount(listBox1.Items.Count);
            label2.Text = changeTextOfCount(listBox2.Items.Count);
        }
コード例 #13
0
 private void loadTipField()
 {
     comboBox1.Items.Clear();
     if (Program.tip_data.Count > 0)
     {
         for (int i = 0; Program.tip_data.Count > i; i++)
         {
             if (Program.tip_data[i].idTipData == 5 && !upd)
             {
                 continue; // пользовательский атрибут типа геометрия создать невозможно
             }
             itemObj item = new itemObj(Program.tip_data[i].idTipData,
                                        Program.tip_data[i].nameTipData,
                                        Program.tip_data[i].nameTipDataDB);
             comboBox1.Items.Add(item);
         }
     }
 }
コード例 #14
0
        private void loadTables()
        {
            comboBox1.Items.Clear();
            comboBox4.Items.Clear();
            comboBox9.Items.Clear();

            SqlWork sqlCmd = new SqlWork();

            sqlCmd.sql = "SELECT id, name_db, name_map FROM " + Program.scheme + ".table_info WHERE type = 2";
            sqlCmd.Execute(false);
            while (sqlCmd.CanRead())
            {
                itemObj item = new itemObj(sqlCmd.GetInt32(0), sqlCmd.GetValue <string>(2) + " (" +
                                           sqlCmd.GetValue <string>(1) + ")", sqlCmd.GetValue <string>(1));
                comboBox1.Items.Add(item);
            }
            sqlCmd.Close();

            sqlCmd     = new SqlWork();
            sqlCmd.sql = "SELECT id, name_db, name_map FROM " + Program.scheme + ".table_info WHERE type = 3";
            sqlCmd.Execute(false);
            while (sqlCmd.CanRead())
            {
                itemObj item = new itemObj(sqlCmd.GetInt32(0), sqlCmd.GetValue <string>(2) + " (" +
                                           sqlCmd.GetValue <string>(1) + ")", sqlCmd.GetValue <string>(1));
                comboBox4.Items.Add(item);
            }
            sqlCmd.Close();

            sqlCmd     = new SqlWork();
            sqlCmd.sql = "SELECT id, name_db, name_map FROM " + Program.scheme + ".table_info WHERE type = 1 OR type=4";
            sqlCmd.Execute(false);
            while (sqlCmd.CanRead())
            {
                itemObj item = new itemObj(sqlCmd.GetInt32(0), sqlCmd.GetValue <string>(2) + " (" +
                                           sqlCmd.GetValue <string>(1) + ")", sqlCmd.GetValue <string>(1));
                comboBox9.Items.Add(item);
            }
            sqlCmd.Close();
        }