/// <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); }
/// <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); }
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); } } } } }
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(); } }
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); }
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); }
/// <summary> /// Удаляет группу с определенным ID, пересчитывает их порядок /// </summary> /// <param name="id">ID группы</param> public void DeleteGroup(int id) { SqlWork sqlCmd = new SqlWork(); sqlCmd.sql = "DELETE FROM " + Program.scheme + ".table_groups WHERE id=" + id.ToString() + " RETURNING name_group"; try { sqlCmd.Execute(false); if (sqlCmd.CanRead()) { string name_gr = sqlCmd.GetString(0); Rekod.Classes.workLogFile.writeLogFile("deleted group --> id=" + id.ToString() + " name_group=" + name_gr, false, false); } } catch (NpgsqlException ex) { if (ex.Code.CompareTo("42501") == 0) { MessageBox.Show(Rekod.Properties.Resources.GF_ErrorCreateGroup); } else { throw ex; } } finally { sqlCmd.Close(); } List <itemObjOrdered> newGroupsOrder = getRecalcedGroupsOrderList(); SetGroupsOrder(newGroupsOrder); }
private axVisUtils.Styles.objStylesM setStyleFromDB(int idT) { axVisUtils.Styles.objStylesM s1 = new axVisUtils.Styles.objStylesM(); string sql = "SELECT fontname, fontcolor, fontframecolor, fontsize,"; sql += " symbol,"; sql += " pencolor, pentype, penwidth,"; sql += " brushbgcolor, brushfgcolor, brushstyle, brushhatch"; sql += " FROM " + Program.scheme + ".table_info WHERE id=" + id.ToString(); SqlWork sqlCmd = new SqlWork(); sqlCmd.sql = sql; sqlCmd.Execute(false); while (sqlCmd.CanRead()) { s1.FontStyle.FontName = sqlCmd.GetString(0); s1.FontStyle.Color = sqlCmd.GetValue <uint>(1); s1.FontStyle.FrameColor = sqlCmd.GetValue <uint>(2); s1.FontStyle.Size = sqlCmd.GetInt32(3); s1.SymbolStyle.Shape = sqlCmd.GetValue <uint>(4); s1.PenStyle.Color = sqlCmd.GetValue <uint>(5); s1.PenStyle.Type = sqlCmd.GetValue <ushort>(6); s1.PenStyle.Width = sqlCmd.GetValue <uint>(7); s1.BrushStyle.bgColor = sqlCmd.GetValue <uint>(8); s1.BrushStyle.fgColor = sqlCmd.GetValue <uint>(9); s1.BrushStyle.Style = sqlCmd.GetValue <ushort>(10); s1.BrushStyle.Hatch = sqlCmd.GetValue <ushort>(11); } sqlCmd.Close(); return(s1); }
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); }
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(); }
private void loadNewLabelStyleIntoBase() { SqlWork sqlCmd = new SqlWork(); sqlCmd.sql = SQL; sqlCmd.Execute(true); sqlCmd.Close(); }
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(); }
private void saveTable(int id, bool default_visibl, int order_num) { SqlWork sqlCmd = new SqlWork(); sqlCmd.sql = "UPDATE " + Program.scheme + ".table_info SET default_visibl=" + default_visibl.ToString() + ", order_num=" + order_num.ToString() + " WHERE id=" + id.ToString(); sqlCmd.Execute(true); sqlCmd.Close(); }
private void loadDaipazonInfo(int id_table) { loadColumsForDiapazon(id_table); SqlWork sqlCmd = new SqlWork(); typeColors = new List <itemObj>(); typeColors.Add(new itemObj(0, Rekod.Properties.Resources.PTC_BasicElement, "")); typeColors.Add(new itemObj(1, Rekod.Properties.Resources.PTC_Background, "")); typeColors.Add(new itemObj(2, Rekod.Properties.Resources.PTC_BordersAndLines, "")); typeColors.Add(new itemObj(3, Rekod.Properties.Resources.PTC_BorderSymbol, "")); sqlCmd.sql = "SELECT range_colors, range_column, precision_point, type_color, min_color, " + "min_val, max_color, max_val, use_min_val, use_max_val, null_color, " + "use_null_color, geom_type FROM " + Program.scheme + ".table_info WHERE id = " + id_table; sqlCmd.Execute(false); if (sqlCmd.CanRead()) { switch (sqlCmd.GetInt32(12)) { case 0: //Без геометрии Classes.workLogFile.writeLogFile(new Exception("Загружена таблица без геометрии"), true, false); break; case 1: //Точки typeColors.RemoveAt(2); typeColors.RemoveAt(1); break; case 2: //Линии typeColors.RemoveAt(3); typeColors.RemoveAt(1); typeColors.RemoveAt(0); break; case 3: //площадные typeColors.RemoveAt(3); break; } cbRangeColorChange.DataSource = typeColors; setComboBox(cbRangeValueField, sqlCmd.GetValue <string>(1)); setComboBox(cbRangeColorChange, sqlCmd.GetInt32(3).ToString(), sqlCmd.GetInt32(3)); numericUpDownRangePrec.Value = sqlCmd.GetInt32(2); panelRangeMinColor.BackColor = convColor(sqlCmd.GetValue <uint>(4)); numericUpDownRangeMinValue.Value = sqlCmd.GetInt32(5); panelRangeMaxColor.BackColor = convColor(sqlCmd.GetValue <uint>(6)); numericUpDownRangeMaxValue.Value = sqlCmd.GetInt32(7); checkBoxRangeMin.Checked = sqlCmd.GetBoolean(8); checkBoxRangeMax.Checked = sqlCmd.GetBoolean(9); } sqlCmd.Close(); numericUpDownRangeMinValue.Enabled = checkBoxRangeMin.Checked; numericUpDownRangeMaxValue.Enabled = checkBoxRangeMax.Checked; }
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(); } } }
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(); }
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(); }
private string select_name_db() { string table_db = ""; SqlWork sqlCmd = new SqlWork(); sqlCmd.sql = "SELECT name_db FROM " + Program.scheme + ".table_info WHERE id = " + id.ToString(); sqlCmd.Execute(false); if (sqlCmd.CanRead()) { table_db = sqlCmd.GetValue <string>(0); } sqlCmd.Close(); return(table_db); }
private bool getGeomTable(int idT) { bool map = false; SqlWork sqlCmd = new SqlWork(); sqlCmd.sql = "SELECT tt.map_layer, ti.name_db FROM " + Program.scheme + ".table_info ti, " + Program.scheme + ".table_type_table tt" + " WHERE tt.id=ti.type AND ti.id= " + idT; sqlCmd.Execute(false); if (sqlCmd.CanRead()) { map = sqlCmd.GetBoolean(0); tableName = sqlCmd.GetValue <string>(1); } sqlCmd.Close(); return(map); }
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); }
public void DeleteTableFromGroup(int id_group, int id_table) { SqlWork sqlCmd = new SqlWork(); sqlCmd.sql = "DELETE FROM " + Program.scheme + ".table_groups_table WHERE id_table=" + id_table.ToString() + " AND id_group=" + id_group.ToString(); try { sqlCmd.Execute(true); } catch (NpgsqlException ex) { MessageBox.Show(ex.BaseMessage); } finally { sqlCmd.Close(); } }
private bool getstyleExists() { bool exists_style = false; SqlWork sqlCmd = new SqlWork(); sqlCmd.sql = "SELECT * FROM " + Program.scheme + "." + tableName + " LIMIT 1"; sqlCmd.Execute(false); for (int i = 0; sqlCmd.GetFiealdCount() > i; i++) { if (sqlCmd.GetFieldName(i) == "exists_style") { exists_style = true; break; } } sqlCmd.Close(); return(exists_style); }
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); }
public void SetOrderTableInGroup(int id_group, int id_table, int ord) { SqlWork sqlCmd = new SqlWork(); sqlCmd.sql = "UPDATE " + Program.scheme + ".table_groups_table SET order_num=" + ord.ToString() + " WHERE id_table=" + id_table.ToString() + " AND id_group=" + id_group.ToString(); //"INSERT INTO " + Program.scheme + ".table_groups_table (id_table,id_group) VALUES ("+id_table.ToString()+","+id_group.ToString()+")"; try { sqlCmd.Execute(true); } catch (NpgsqlException ex) { MessageBox.Show(ex.BaseMessage); } finally { sqlCmd.Close(); } }
private void SignControl_Load(object sender, EventArgs e) { SqlWork sqlCmd = new SqlWork(); if (!Program.WorkSets.CurrentWorkSet.IsDefault) { sqlCmd.sql = "SELECT lablefiled FROM sys_scheme.table_info_sets WHERE id_table=" + _idT.ToString() + " AND id_set = " + Program.WorkSets.CurrentWorkSet.Id; } else { sqlCmd.sql = "SELECT lablefiled FROM sys_scheme.table_info WHERE id=" + _idT.ToString(); } sqlCmd.Execute(false); if (sqlCmd.CanRead()) { String form = getFromBase(sqlCmd.GetValue <string>(0)); textBox1.Text = form; textBox1.SelectionStart = form.Length; textBox1.Focus(); } sqlCmd.Close(); List <fieldInfo> afi = classesOfMetods.getFieldInfoTable(_idT); foreach (fieldInfo fi in afi) { comboBox1.Items.Add(fi.nameDB); comboBox_2.Items.Add(fi.nameDB); } if (classesOfMetods.getTableInfo(_idT).label_showlabel) { panel1.Enabled = true; button4.Enabled = true; check_showLabel.Checked = true; } else { check_showLabel.Checked = false; panel1.Enabled = false; button4.Enabled = false; } }
/// <summary> /// Получает из базы проекции в формате proj4 /// </summary> public static string GetProj4(int srid) { string wkt = String.Empty; using (var sqlCmd = new SqlWork()) { sqlCmd.sql = "SELECT proj4text FROM spatial_ref_sys WHERE srid=" + srid; sqlCmd.Execute(false); if (sqlCmd.CanRead()) { wkt = sqlCmd.GetString(0); } else { return(null); } } return(wkt); }
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(); }
public void saveStyle(Rekod.DBTablesEdit.StyleControl sc) { objStyleBrush brush1 = sc.createBrush(); objStyleFont font1 = sc.createFont(); objStylePen pen1 = sc.createPen(); objStyleSymbol symb1 = sc.createSymbol(); string bgColor = ""; if (sc.checkBox1.Enabled && !sc.checkBox1.Checked) { bgColor = "4294967295"; } else { bgColor = brush1.bgColor.ToString(); } SqlWork sqlCmd = new SqlWork(); sqlCmd.sql = "UPDATE " + Program.scheme + ".table_info SET fontname = '" + font1.FontName + "', " + "fontcolor = " + font1.Color.ToString() + ", " + "fontframecolor = " + font1.FrameColor.ToString() + ", " + "fontsize = " + font1.Size.ToString() + ", " + "symbol = " + symb1.Shape.ToString() + ", " + "pencolor = " + pen1.Color.ToString() + ", " + "pentype = " + pen1.Type.ToString() + ", " + "penwidth = " + pen1.Width.ToString() + ", " + "brushbgcolor = " + bgColor + ", " + "brushfgcolor = " + brush1.fgColor.ToString() + ", " + "brushstyle = " + brush1.Style.ToString() + ", " + "brushhatch = " + brush1.Hatch.ToString() + " WHERE id = " + id.ToString(); sqlCmd.Execute(true); sqlCmd.Close(); sqlCmd = new SqlWork(); sqlCmd.sql = "UPDATE " + Program.scheme + ".table_info SET default_style = true WHERE id = " + id.ToString(); sqlCmd.Execute(true); sqlCmd.Close(); DBTablesEdit.SyncController.ReloadStyle(id); }
/// <summary> /// Добавляет таблицу в группу /// </summary> /// <param name="id_group"></param> /// <param name="id_table"></param> /// <returns>Была ли добавлена таблица в группу, если FALSE то были переданы неверные ID</returns> public bool MoveTableToGroup(int id_group, int id_table) { bool moved = false; SqlWork sqlCmd = new SqlWork(); sqlCmd.sql = "SELECT " + Program.scheme + ".add_table_in_group(" + id_table.ToString() + "," + id_group.ToString() + ")"; //"INSERT INTO " + Program.scheme + ".table_groups_table (id_table,id_group) VALUES ("+id_table.ToString()+","+id_group.ToString()+")"; try { sqlCmd.Execute(true); } catch (NpgsqlException ex) { if (ex.Code.CompareTo("23503") == 0) { MessageBox.Show(Rekod.Properties.Resources.GF_NonexistentGroupTable); return(false); } else if (ex.Code.CompareTo("23505") == 0) { moved = true; } else { throw ex; } } finally { sqlCmd.Close(); } if (!moved) { Rekod.Classes.workLogFile.writeLogFile("move table to group --> id_group=" + id_group.ToString() + " id_table=" + id_table.ToString(), false, false); } return(true); }
private void button2_Click(object sender, EventArgs e) { if (listBox1.SelectedItem != null) { int idTable = -1; int typetable = -1; foreach (tablesInfo ti in Program.tables_info) { if (ti.idTable == ((itemObj)listBox1.SelectedItem).Id_o) { idTable = ti.idTable; typetable = ti.type; break; } } List <itemObj> list_tables = new List <itemObj>(); if (typetable == 3) // если интервал { SqlWork sqlCmd = new SqlWork(); sqlCmd.sql = "SELECT id_table,name_db FROM " + Program.scheme + ".table_field_info WHERE ref_table=" + idTable; sqlCmd.Execute(false); while (sqlCmd.CanRead()) { list_tables.Add(new itemObj(sqlCmd.GetInt32(0), sqlCmd.GetString(1), sqlCmd.GetString(1))); } sqlCmd.Close(); } DialogResult dr = DialogResult.Cancel; switch (typetable) { case 1: dr = QuestionDelete.ShowDialog(Rekod.Properties.Resources.TLE_DeletingLayer, Rekod.Properties.Resources.TLE_DeletingLayerAsk, Rekod.Properties.Resources.FELC_Forever); break; case 2: dr = QuestionDelete.ShowDialog(Rekod.Properties.Resources.TLE_DeletingCatalog, Rekod.Properties.Resources.TLE_Attention + "\n" + Rekod.Properties.Resources.TLE_DeletingCatalogAsk, Rekod.Properties.Resources.FELC_Forever); break; case 3: dr = QuestionDelete.ShowDialog(Rekod.Properties.Resources.TLE_DeletingInterval, Rekod.Properties.Resources.TLE_Attention + "\n" + Rekod.Properties.Resources.TLE_DeletingIntervalAsk, Rekod.Properties.Resources.FELC_Forever, SystemIcons.Warning); break; case 4: dr = QuestionDelete.ShowDialog(Rekod.Properties.Resources.TLE_DeletingTable, Rekod.Properties.Resources.TLE_Attention + "\n" + Rekod.Properties.Resources.TLE_DeletingTableAsk, Rekod.Properties.Resources.FELC_Forever); break; } if (dr != DialogResult.Cancel) { SqlWork sqlCmd = new SqlWork(); foreach (itemObj io in list_tables) { sqlCmd = new SqlWork(); sqlCmd.sql = "UPDATE " + Program.scheme + ".table_info SET default_style=true,style_field='style' WHERE id=" + io.Id_o + " AND style_field='" + io.Name_o + "'"; sqlCmd.Execute(true); sqlCmd.Close(); } // удалить все ссылки на связанные таблицы sqlCmd = new SqlWork(); sqlCmd.sql = String.Format("UPDATE {0}.table_field_info SET ref_table=null, ref_field=null, ref_field_name=null, is_reference=false, is_interval = FALSE WHERE ref_table={1};", Program.scheme, idTable); sqlCmd.Execute(true); sqlCmd.Close(); sqlCmd = new SqlWork(); sqlCmd.sql = "SELECT " + Program.scheme + ".delete_table(" + ((itemObj)listBox1.SelectedItem).Id_o + "," + (dr == DialogResult.Yes).ToString() + ")"; sqlCmd.Execute(true); sqlCmd.Close(); classesOfMetods.DeleteLayerInMap(((itemObj)listBox1.SelectedItem).Id_o); try { SyncController.DeleteTable(((itemObj)listBox1.SelectedItem).Id_o, false); } catch (Exception ex) { Classes.workLogFile.writeLogFile(ex, false, true); } classesOfMetods cls = new classesOfMetods(); cls.reloadInfo(); loadTables(); MessageBox.Show(((dr == DialogResult.Yes) ? Rekod.Properties.Resources.TLE_DeleteForever : Rekod.Properties.Resources.TLE_DeleteNoForever)); Control[] cntrs = parent.Controls.Find("CloseButton", true); if (cntrs.Length == 1) { ((CloseButton)cntrs[0]).CloseBox(e); } } } }