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); }
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> /// Метод загружает из базы все группы в 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); }
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 void SaveGroup(int id_gr, string name_gr, string desc_gr) { SqlWork sqlCmd = new SqlWork(); sqlCmd.sql = "UPDATE " + Program.scheme + ".table_groups SET name_group=@name_group, descript=@descript WHERE id=" + id_gr.ToString(); //"SELECT name_group,descript FROM " + Program.scheme + ".table_groups WHERE id=" + id_gr.ToString(); Params[] parms = new Params[2]; parms[0] = new Params(); parms[0].paramName = "@name_group"; parms[0].typeData = NpgsqlTypes.NpgsqlDbType.Text; parms[0].value = name_gr; parms[1] = new Params(); parms[1].paramName = "@descript"; parms[1].typeData = NpgsqlTypes.NpgsqlDbType.Text; parms[1].value = desc_gr; try { sqlCmd.ExecuteNonQuery(parms); } catch (NpgsqlException ex) { MessageBox.Show(ex.BaseMessage); } finally { sqlCmd.Close(); } }
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(); } }
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); }
/// <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 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(); }
/// <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> /// Загрузка связанных таблиц /// </summary> private void LoadRelatedTables(object idObject) { if (idObject != null && (_table.Type == AbsM.ETableType.Data || _table.Type == AbsM.ETableType.MapLayer)) { RelatedTables.Clear(); using (SqlWork sqlWork = new SqlWork(Connect)) { // Запрос для получения идентификаторов связанных таблиц sqlWork.sql = String.Format(@"SELECT tfi.id_table, tfi.name_db, tfi.ref_field FROM sys_scheme.table_field_info tfi INNER JOIN sys_scheme.table_info ti ON tfi.id_table = ti.id INNER JOIN sys_scheme.table_type_table ttt ON ttt.id = ti.type WHERE tfi.ref_table = {0} AND (ttt.id = 1 OR ttt.id = 4)", _table.Id); sqlWork.ExecuteReader(); while (sqlWork.CanRead()) { int idTable = sqlWork.GetInt32("id_table"); string colName = sqlWork.GetString("name_db"); int refFieldId = sqlWork.GetInt32("ref_field"); PgM.PgFieldM field = _table.Fields.FirstOrDefault(f => f.Id == refFieldId) as PgM.PgFieldM; if (field != null && field.Table != null && field.Table.Id is int && classesOfMetods.getRefTableRight(_table.Id, (int)field.Table.Id)) { PgAtM.PgAttributeM attr = _attributesListVM.Attributes.FirstOrDefault(a => a.Field == field); String filterValue = null; if (attr.Value != null) { filterValue = attr.Value.ToString(); } PgM.PgTableBaseM pgTable = _table.Source.Tables.FirstOrDefault(p => (int)p.Id == idTable) as PgM.PgTableBaseM; if (pgTable != null) { FilterRelationModel filterRM = new FilterRelationModel() { Type = TypeRelation.ELEMENT, Element = new FilterElementModel() { Column = colName, Type = TypeOperation.Equal, Value = filterValue } }; RelatedTables.Add(new PgTV.PgTableViewVM(pgTable, filterRM)); } } } sqlWork.Close(); } } OnPropertyChanged("HasRelatedTables"); }
/// <summary> /// Открывает окно для редактирования стиля /// </summary> public void EditStyle(object parameter = null) { using (SqlWork sqlWork = new SqlWork(_connect)) { sqlWork.sql = String.Format(@"SELECT {0}, {1}, {2}, {3}, {4}, {5}, {6}, {7}, {8}, {9}, {10}, {11} FROM sys_scheme.style_object_info WHERE id_table={12} AND id_obj={13}", "fontname", "fontcolor", "fontframecolor", "fontsize", "brushbgcolor", "brushfgcolor", "brushstyle", "brushhatch", "pencolor", "pentype", "penwidth", "symbol", _table.Id, _pkAttribute.Value); sqlWork.ExecuteReader(); sqlWork.CanRead(); String fontname = sqlWork.GetString(0); Int32 fontcolor = sqlWork.GetInt32(1); Int32 fontframecolor = sqlWork.GetInt32(2); Int32 fontsize = sqlWork.GetInt32(3); Int32 brushbgcolor = sqlWork.GetInt32(4); Int32 brushfgcolor = sqlWork.GetInt32(5); Int16 brushstyle = (short)sqlWork.GetInt32(6); Int16 brushhatch = (short)sqlWork.GetInt32(7); Int32 pencolor = sqlWork.GetInt32(8); Int32 pentype = sqlWork.GetInt32(9); Int32 penwidth = sqlWork.GetInt32(10); Int32 symbol = sqlWork.GetInt32(11); sqlWork.Close(); Style.SetFont(fontname, fontcolor, fontframecolor, fontsize); Style.SetBrush(brushbgcolor, brushfgcolor, brushhatch, brushstyle); Style.SetPen(pencolor, pentype, penwidth); Style.SetSymbol(symbol); } PgV.ObjectStyleEditV styleWindow = new PgV.ObjectStyleEditV(); styleWindow.DataContext = this; styleWindow.Owner = Program.WinMain; styleWindow.Show(); }
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); }
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); }
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 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; } }
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 button5_Click(object sender, EventArgs e) { int splitPlace = textBox1.SelectionStart; String leftPart = textBox1.Text.Substring(0, splitPlace); String rightPart = textBox1.Text.Substring(splitPlace); if (textBox2.Text.Replace(" ", "") == "") { MessageBox.Show(Properties.Resources.LabelControl_NotEmpty, Properties.Resources.AWT_EditLabel, MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (textBox2.Text.Contains("SELECT") || textBox2.Text.Contains("DROP") || textBox2.Text.Contains("INSERT") || textBox2.Text.Contains("UPDATE") || textBox2.Text.Contains("DELETE")) { MessageBox.Show(Rekod.Properties.Resources.LabelControl_InvalidExpression, Properties.Resources.AWT_EditLabel, MessageBoxButtons.OK, MessageBoxIcon.Error); return; } tablesInfo ti = classesOfMetods.getTableInfo(_idT); SqlWork sqlCmd = new SqlWork(true); sqlCmd.sql = string.Format("SELECT {0} FROM \"{1}\".\"{2}\" LIMIT 1", textBox2.Text, ti.nameSheme, ti.nameDB); try { sqlCmd.ExecuteNonQuery(null); } catch (Exception ex) { MessageBox.Show(Rekod.Properties.Resources.LabelControl_InvalidExpression, Properties.Resources.AWT_EditLabel, MessageBoxButtons.OK, MessageBoxIcon.Error); return; } finally { sqlCmd.Close(); } textBox1.Text = leftPart + (((leftPart.Replace(" ", "") != "") ? "+" : "") + "{" + textBox2.Text + "}") + rightPart; textBox1.SelectionStart = textBox1.Text.Length; textBox1.SelectionLength = 0; textBox1.Focus(); }
/// <summary> /// Проверка подписи /// </summary> private bool IsCorrectExpression(String labelmask, ref String message) { if (labelmask.Contains("SELECT") || labelmask.Contains("DROP") || labelmask.Contains("INSERT") || labelmask.Contains("UPDATE") || labelmask.Contains("DELETE")) { message = "Вы используете недопустимое выражение"; return(false); } if (Table != null) { SqlWork sqlCmd = new SqlWork((Table.Source as PgVM.PgDataRepositoryVM).Connect, true); sqlCmd.sql = string.Format("SELECT str FROM (SELECT {0} AS str FROM {1}.{2}) AS query WHERE str IS NOT NULL LIMIT 1", labelmask, Table.SchemeName, Table.Name); try { sqlCmd.ExecuteReader(null); if (sqlCmd.CanRead()) { message = sqlCmd.GetValue(0).ToString(); } else { message = "Предпросмотр невозможен. Похоже в таблице этого слоя нет ни одной непустой записи"; } } catch (Exception ex) { message = "Вы ввели некорректное выражение"; return(false); } finally { sqlCmd.Close(); } return(true); } else { message = "Нет доступа к источнику"; return(false); } }
private void button_preview_Click(object sender, EventArgs e) { String result = parseResult(textBox1.Text); if (result.Replace(" ", "") == "") { MessageBox.Show(Rekod.Properties.Resources.LabelControl_NotEmpty, Properties.Resources.AWT_EditLabel, MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (result.Contains("SELECT") || result.Contains("DROP") || result.Contains("INSERT") || result.Contains("UPDATE") || result.Contains("DELETE")) { MessageBox.Show(Rekod.Properties.Resources.LabelControl_InvalidExpression, Properties.Resources.AWT_EditLabel, MessageBoxButtons.OK, MessageBoxIcon.Error); return; } tablesInfo ti = classesOfMetods.getTableInfo(_idT); SqlWork sqlCmd = new SqlWork(true); sqlCmd.sql = string.Format("SELECT {0} FROM \"{1}\".\"{2}\" LIMIT 1", result, ti.nameSheme, ti.nameDB); try { sqlCmd.ExecuteReader(null); if (sqlCmd.CanRead()) { MessageBox.Show(sqlCmd.GetValue <string>(0)); } else { MessageBox.Show(Rekod.Properties.Resources.LabelControl_ErrorShowResult, Properties.Resources.AWT_EditLabel, MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception ex) { MessageBox.Show(Rekod.Properties.Resources.LabelControl_InvalidExpression, Properties.Resources.AWT_EditLabel, MessageBoxButtons.OK, MessageBoxIcon.Error); return; } finally { sqlCmd.Close(); } }
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(); }