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();
}