Example #1
0
        private void buttonBringDown_Click(object sender, EventArgs e)
        {
            if (listBox1.SelectedItems.Count > 0)
            {
                List <itemObjOrdered> lllist = new List <itemObjOrdered>();
                int max = 0;
                foreach (itemObjOrdered sel in listBox1.SelectedItems)
                {
                    if (listBox1.Items.IndexOf(sel) > max)
                    {
                        max = listBox1.Items.IndexOf(sel);
                    }

                    lllist.Add(sel);
                }
                if (max < listBox1.Items.Count - 1)
                {
                    listBox1.ClearSelected();
                    for (int i = lllist.Count - 1; i >= 0; i--)
                    {
                        itemObjOrdered sel = lllist[i];
                        int            k   = listBox1.Items.IndexOf(sel);
                        listBox1.Items.Remove(sel);
                        listBox1.Items.Insert(k + 1, sel);
                        listBox1.SelectedItems.Add(sel);
                    }
                }
            }
        }
Example #2
0
        public void reloadGroups()
        {
            itemObjOrdered selectedItem = comboBox1.SelectedItem as itemObjOrdered;

            comboBox1.Items.Clear();
            List <itemObjOrdered> list_groups = gf.LoadGroups();

            itemObjOrdered[] arr_group = new itemObjOrdered[list_groups.Count];
            list_groups.CopyTo(arr_group);
            comboBox1.Items.AddRange(arr_group);
            label8.Text = changeTextOfCount2(comboBox1.Items.Count);

            if (selectedItem != null)
            {
                for (int i = 0; i < comboBox1.Items.Count; i++)
                {
                    if ((comboBox1.Items[i] as itemObjOrdered).Id_o == selectedItem.Id_o)
                    {
                        comboBox1.SelectedItem = (comboBox1.Items[i] as itemObjOrdered);
                        break;
                    }
                }
            }
            if (comboBox1.SelectedItem == null)
            {
                panel1.Visible = false;
            }
        }
Example #3
0
        /// <summary>
        /// Метод загружает из базы все группы в List
        /// </summary>
        public List <itemObjOrdered> LoadGroups()
        {
            List <itemObjOrdered> list_groups = new List <itemObjOrdered>();
            SqlWork sqlCmd = new SqlWork();

            sqlCmd.sql = "SELECT id,name_group,descript,order_num FROM " + Program.scheme + ".table_groups ORDER BY order_num";
            try
            {
                sqlCmd.Execute(false);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
                sqlCmd.Close();
                return(null);
            }
            while (sqlCmd.CanRead())
            {
                int            id_gr     = sqlCmd.GetInt32(0);
                string         name_gr   = sqlCmd.GetString(1);
                string         desc_gr   = sqlCmd.GetString(2);
                int            order_num = sqlCmd.GetInt32(3);
                itemObjOrdered io        = new itemObjOrdered(id_gr, name_gr, desc_gr, order_num);//использую уже готовую структуру, вместо Layer там будет храниться описание
                list_groups.Add(io);
            }
            sqlCmd.Close();

            return(list_groups);
        }
Example #4
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;
            }
        }
Example #5
0
        public void reloadTables()
        {
            listBox1.Items.Clear();
            listBox2.Items.Clear();

            List <itemObjOrdered> list_of_tables         = new List <itemObjOrdered>();
            List <itemObjOrdered> list_of_tables_visible = new List <itemObjOrdered>();

            SqlWork sqlCmd = new SqlWork();

            sqlCmd.sql = "SELECT id,name_map,order_num,default_visibl FROM " + Program.scheme + ".table_info WHERE type=1 ORDER BY order_num";
            sqlCmd.Execute(false);
            while (sqlCmd.CanRead())
            {
                itemObjOrdered item = new itemObjOrdered(sqlCmd.GetInt32(0), sqlCmd.GetString(1), sqlCmd.GetBoolean(3).ToString(), sqlCmd.GetInt32(2));
                list_of_tables.Add(item);
                if (item.Layer.Contains("True"))
                {
                    list_of_tables_visible.Add(item);
                }
            }
            sqlCmd.Close();

            listBox1.Items.AddRange(list_of_tables_visible.ToArray());
            listBox2.Items.AddRange(list_of_tables.ToArray());

            label6.Text = changeTextOfCount(listBox1.Items.Count);
            label7.Text = changeTextOfCount(listBox2.Items.Count);
        }
Example #6
0
        /// <summary>
        /// Конструктор
        /// </summary>
        /// <param name="id_group">ID группы, если же создаеться новая то должно быть отрицательным</param>
        /// <param name="par">Форма на которой создаеться этот контрол</param>
        /// <param name="p_group">Контрол из которого создаеться</param>
        public AddEditGroup(itemObjOrdered itemObjOrd, EditGroupsOrder parent)
        {
            InitializeComponent();
            _parent = parent;
            _id     = itemObjOrd.Id_o;
            gf      = new GroupFunct();

            textBox1.Text = itemObjOrd.Name_o;
            textBox2.Text = itemObjOrd.Layer;
        }
Example #7
0
        private void reloadGroups()
        {
            listBox1.Items.Clear();
            List <itemObjOrdered> listGroups = _groupFunct.LoadGroups();

            itemObjOrdered[] arr_group = new itemObjOrdered[listGroups.Count];
            listGroups.CopyTo(arr_group);
            listBox1.Items.AddRange(arr_group);
            labelCount.Text = listBox1.Items.Count.ToString() + " " + Rekod.Properties.Resources.EGO_groups;
        }
Example #8
0
        /// <summary>
        /// Возвращает список таблиц в(вне) группе
        /// </summary>
        /// <param name="id">ID группы</param>
        /// <param name="in_group">Если TRUE, то то список будет таблиц в группе, FALSE- список вне группы</param>
        /// <returns></returns>
        public List <itemObjOrdered> GetListTablesInOrOutGroup(int id, bool in_group)
        {
            List <itemObjOrdered> list_of_tables = new List <itemObjOrdered>();
            SqlWork sqlCmd = new SqlWork();

            if (in_group)
            {
                sqlCmd.sql = "SELECT t.id,t.name_db,t.name_map,g.order_num FROM " + Program.scheme + ".table_groups_table AS g,"
                             + Program.scheme + ".table_info AS t WHERE g.id_group=" + id.ToString() + " AND g.id_table=t.id AND t.type=1 and hidden = false ORDER BY g.order_num";
                try
                {
                    sqlCmd.Execute(false);
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                    return(null);
                }
            }
            else
            {
                sqlCmd.sql =
                    "SELECT * FROM " +
                    "(SELECT t.id,t.name_db,t.name_map FROM " + Program.scheme + ".table_info AS t WHERE t.type=1 and hidden=false" +
                    " EXCEPT " +
                    "SELECT DISTINCT t.id,t.name_db,t.name_map FROM " + Program.scheme + ".table_groups_table AS g," + Program.scheme +
                    ".table_info AS t WHERE g.id_group=" + id.ToString() + " AND g.id_table=t.id and hidden = false " +
                    ")AS al ORDER BY al.name_map";
                try
                {
                    sqlCmd.Execute(false);
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                    return(null);
                }
            }

            while (sqlCmd.CanRead())
            {
                int    id_table       = sqlCmd.GetInt32(0);
                string db_name_table  = sqlCmd.GetString(1);
                string map_name_table = sqlCmd.GetString(2);
                int    ord            = 0;
                if (in_group)
                {
                    ord = sqlCmd.GetInt32(3);
                }
                itemObjOrdered io = new itemObjOrdered(id_table, map_name_table, db_name_table, ord);
                list_of_tables.Add(io);
            }
            sqlCmd.Close();
            return(list_of_tables);
        }
Example #9
0
 private void button3_Click(object sender, EventArgs e)
 {
     for (int i = 0; i < listBox2.Items.Count; i++)
     {
         itemObjOrdered item = (listBox2.Items[i] as itemObjOrdered);
         if (item.Layer.Contains("True") != listBox1.Items.Contains(item) || i != item.order)
         {
             saveTable(item.Id_o, listBox1.Items.Contains(item), i);
         }
     }
     reloadTables();
 }
Example #10
0
        private void editNameDescription()
        {
            itemObjOrdered itemObjOrd = listBox1.SelectedItem as itemObjOrdered;

            if (itemObjOrd != null)
            {
                AddEditGroup aeg = new AddEditGroup(itemObjOrd, this);
                aeg.Location      = new Point((this.Width - aeg.Width) / 2, (this.Height - aeg.Height) / 2);
                groupBox1.Enabled = false;
                this.Controls.Add(aeg);
                aeg.BringToFront();
            }
        }
 public void save_data()
 {
     for (int k = 0; k < listBox1.Items.Count; k++)
     {
         itemObjOrdered obj = listBox1.Items[k] as itemObjOrdered;
         if (obj.order != k)
         {//сохраняем
             SqlWork sqlCmd = new SqlWork();
             sqlCmd.sql = "UPDATE " + Program.scheme + ".table_field_info SET num_order=" + k.ToString() + " WHERE id=" + obj.Id_o;
             sqlCmd.Execute(true);
             sqlCmd.Close();
         }
     }
 }
        public void loadFields(int idT)
        {
            listBox1.Items.Clear();
            SqlWork sqlCmd = new SqlWork();

            sqlCmd.sql = "SELECT id,name_db,type_field,name_map,num_order FROM " + Program.scheme + ".table_field_info WHERE id_table=" + idT.ToString() + " ORDER BY num_order";
            sqlCmd.Execute(false);
            while (sqlCmd.CanRead())
            {
                itemObjOrdered item = new itemObjOrdered(sqlCmd.GetInt32(0),
                                                         sqlCmd.GetString(1) + " (" + classesOfMetods.getTipField(sqlCmd.GetInt32(2)).nameTipData + ") - " +
                                                         sqlCmd.GetString(3), sqlCmd.GetString(1), sqlCmd.GetInt32(4));
                listBox1.Items.Add(item);
            }
            sqlCmd.Close();
            label2.Text = changeTextOfCount(listBox1.Items.Count);
        }
Example #13
0
        private List <itemObjOrdered> getRecalcedGroupsOrderList()
        {
            SqlWork sqlCmd = new SqlWork();

            sqlCmd.sql = String.Format("SELECT id, name_group, descript FROM {0}.{1} ORDER BY order_num", Program.scheme, "table_groups");
            sqlCmd.Execute(false);
            List <itemObjOrdered> newGroupsOrder = new List <itemObjOrdered>();
            int orderObj = 1;

            while (sqlCmd.CanRead())
            {
                int            idObj    = sqlCmd.GetInt32(0);
                String         nameObj  = sqlCmd.GetValue <string>(1);
                String         descObj  = sqlCmd.GetValue <string>(2);
                itemObjOrdered itObjOrd = new itemObjOrdered(idObj, nameObj, descObj, orderObj);
                orderObj++;
            }
            return(newGroupsOrder);
        }
Example #14
0
        public void SetGroupsOrder(List <itemObjOrdered> newGroupsOrder)
        {
            try
            {
                SqlWork sqlCmd = new SqlWork();
                sqlCmd.BeginTransaction();
                for (int i = 0; i < newGroupsOrder.Count; i++)
                {
                    itemObjOrdered itemObjOrd = newGroupsOrder[i];
                    int            objId      = itemObjOrd.Id_o;
                    int            orderNum   = i + 1;
                    sqlCmd.sql = String.Format("UPDATE {0}.{1} SET order_num={2} WHERE id={3}", Program.scheme, "table_groups", orderNum, objId);

                    sqlCmd.ExecuteNonQuery();
                }
                sqlCmd.EndTransaction();
            }
            catch (Exception ex)
            {
                Rekod.Classes.workLogFile.writeLogFile(Rekod.Properties.Resources.GF_OrderGroup + " \n" + ex.Message, false, true);
            }
        }