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 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);
}
}
}
}
}
/// <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);
}
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);
}
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 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 SaveFile(string pathFile, int idFile, PgM.PgTableBaseM table)
{
FileStream FS;
BinaryWriter BW;
FS = new FileStream(pathFile, FileMode.OpenOrCreate, FileAccess.Write);
BW = new BinaryWriter(FS);
var Param = new IParams[]
{
new Params(":id_file", idFile, DbType.Int32)
};
using (SqlWork sqlCmd = new SqlWork((table.Source as PgVM.PgDataRepositoryVM).Connect))
{
sqlCmd.sql = string.Format(@"SELECT ""{2}"" FROM ""{0}"".""{1}"" WHERE id = :id_file;",
table.SchemeName,
table.FileInfo.TableName,
table.FileInfo.FieldFile);
sqlCmd.ExecuteReader(Param);
if (sqlCmd.CanRead())
{
BW.Write(sqlCmd.GetBytes(0));
}
}
BW.Close();
FS.Close();
}
void RFieldM_PropertyChanged(object sender, System.ComponentModel.PropertyChangedEventArgs e)
{
if (e.PropertyName == "IsSelected")
{
if (IsSelected)
{
using (SqlWork sqlWork = new SqlWork())
{
sqlWork.sql =
String.Format(
@"SELECT tfi.name_db, tfi.name_map, tfi.type_field, tfi.name_lable, tfi.id
FROM sys_scheme.table_field_info tfi, sys_scheme.table_info ti
WHERE ti.id = tfi.id_table
AND ti.scheme_name = '{0}'
AND ti.name_db = '{1}'
AND tfi.name_db = '{2}';" ,
_parentTable.ParentScheme.SchemeName,
_parentTable.Name,
Name);
sqlWork.ExecuteReader();
if (sqlWork.CanRead())
{
Text = sqlWork.GetString("name_map");
Description = sqlWork.GetString("name_lable");
DataType = sqlWork.GetValue <ERDataType>("type_field");
Id = sqlWork.GetInt32("id");
}
}
}
}
}
/// <summary>
/// Запуск процедуры ремонта БД
/// </summary>
public void LaunchSuperFixDb(object parameter = null)
{
try
{
cti.ThreadProgress.ShowWait();
using (SqlWork sqlWork = new SqlWork(true))
{
sqlWork.sql =
String.Format("SELECT * FROM sys_scheme.super_fix_db();");
sqlWork.ExecuteReader();
if (sqlWork.CanRead())
{
if (sqlWork.GetBoolean(0) == false)
{
MessageBox.Show("Ошибка выполнения функции!", "ERROR FUNCTION", MessageBoxButton.OK, MessageBoxImage.Error);
}
else
{
MessageBox.Show("Операция прошла успешно!");
}
}
}
cti.ThreadProgress.Close();
}
catch (Exception ex)
{
cti.ThreadProgress.Close();
MessageBox.Show(ex.Message);
}
}
/// <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 ReloadSchems()
{
Schems.Clear();
using (SqlWork sqlWork = new SqlWork())
{
sqlWork.sql = @"SELECT catalog_name, schema_name
FROM information_schema.schemata
WHERE schema_name not like 'pg_temp_%'
AND schema_name not like 'pg_toast_temp_%'
AND schema_name not like 'information_schema'
AND schema_name not like 'pg_catalog'
AND schema_name not like 'pg_toast'
AND schema_name not like 'rosreestr'
ORDER BY schema_name";
sqlWork.ExecuteReader();
while (sqlWork.CanRead())
{
Schems.Add(new RSchemeM(sqlWork.GetString("schema_name")));
}
}
if (Schems.Count > 0)
{
SelectedScheme = Schems[0];
}
}
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);
}
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 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();
}
/// <summary>
/// Поиск незанятого имени таблицы
/// </summary>
private string FindAcceptableTableName(string originalName, string name_scheme)
{
string name_table = originalName;
if (classesOfMetods.isReservedName(name_table))
{
MessageBox.Show(Rekod.Properties.Resources.AET_NameIsReserved +
Environment.NewLine + Rekod.Properties.Resources.AET_ConNotSave + Environment.NewLine +
Rekod.Properties.Resources.AET_ChangeTable,
Rekod.Properties.Resources.AET_CreatingTable,
MessageBoxButtons.OK,
MessageBoxIcon.Information);
return(null);
}
bool nameChanged = false;
int count = 0;
while (true)
{
using (SqlWork sqlQuery = new SqlWork())
{
sqlQuery.sql = String.Format("SELECT count(*) FROM pg_tables WHERE tablename='{0}' AND schemaname='{1}';", name_table, name_scheme);
sqlQuery.ExecuteReader();
if (sqlQuery.CanRead())
{
if (sqlQuery.GetInt32(0) > 0)
{
nameChanged = true;
count++;
}
else
{
break;
}
}
name_table = originalName + count.ToString();
}
}
if (nameChanged)
{
DialogResult dr = MessageBox.Show(Rekod.Properties.Resources.AET_AlreadyExistsTable + Environment.NewLine +
string.Format(Rekod.Properties.Resources.AET_SaveTableRename, name_table),
Rekod.Properties.Resources.AET_CreatingTable,
MessageBoxButtons.OKCancel,
MessageBoxIcon.Warning);
if (dr == DialogResult.Cancel)
{
MessageBox.Show(Rekod.Properties.Resources.AET_ConNotSave + Environment.NewLine + Rekod.Properties.Resources.AET_ChangeTable,
Rekod.Properties.Resources.AET_CreatingTable,
MessageBoxButtons.OK,
MessageBoxIcon.Information);
return(null);
}
}
return(name_table);
}
public void Reload(object param = null)
{
if (!CanReload(param))
{
return;
}
//new Thread(delegate()
// {
List <PgAtM.PgAttributeFileM> listFiles = new List <PgAtM.PgAttributeFileM>();
using (var SQLCmd = new SqlWork(_connect))
{
SQLCmd.sql = string.Format(@"
SELECT ""{2}"", ""{4}"", dataupd, img_preview, file_name, is_photo
FROM ""{0}"".""{1}""
WHERE ""{4}"" = :id_obj
ORDER BY file_name",
AttributeVM.Table.SchemeName,
AttributeVM.Table.FileInfo.TableName,
AttributeVM.Table.FileInfo.FieldId,
AttributeVM.Table.FileInfo.FieldFile,
AttributeVM.Table.FileInfo.FieldIdObj);
var Params = new IParams[]
{
new Params(":id_obj", AttributeVM.AttributesListVM.PkAttribute.Value, (AttributeVM.AttributesListVM.PkAttribute.Field as PgM.PgFieldM).DbType)
};
SQLCmd.ExecuteReader(Params);
bool hasPreview = false;
while (SQLCmd.CanRead())
{
var id = SQLCmd.GetInt32(AttributeVM.Table.FileInfo.FieldId);
var file = Files.FirstOrDefault(f => f.IdFile == id);
var fileName = SQLCmd.GetString("file_name");
if (file == null)
{
var preview = SQLCmd.GetBytes("img_preview");
hasPreview = (preview != null);
if (!hasPreview)
{
preview = FilePreviewController.GetIcon(System.IO.Path.GetExtension(fileName));
}
var imgPreview = FilePreviewController.GetBitmapImage(preview);
file = new PgAtM.PgAttributeFileM(
source: this,
idFile: id,
imgPreview: imgPreview);
}
file.Date = SQLCmd.GetValue <DateTime>("dataupd");
file.FileName = fileName;
listFiles.Add(file);
}
ExtraFunctions.Sorts.SortList(_files, listFiles);
}
//}).Start();
}
/// <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");
}
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;
}
/// <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();
}
public void Reload()
{
var listRepots = new List <IReportItem_M>();
using (var sqlCmd = new SqlWork())
{
sqlCmd.sql = @"
SELECT
id,
type_report,
body,
id_table,
caption
FROM
sys_scheme.report_templates
ORDER BY id";
if (!sqlCmd.ExecuteReader())
{
return;
}
while (sqlCmd.CanRead())
{
var id = sqlCmd.GetInt32("id");
ReportItem_M rep = FindReportById(id) as ReportItem_M;
if (rep == null)
{
var type = sqlCmd.GetValue <enTypeReport>("type_report");
var idTable = sqlCmd.GetValue <int?>("id_table");
rep = new ReportItem_M(id, type, idTable);
rep.Caption = sqlCmd.GetString("caption");
}
else
{
string caption = sqlCmd.GetString("caption");
if (caption != rep.Caption)
{
rep = new ReportItem_M(rep);
rep.Caption = caption;
}
}
rep.Body = sqlCmd.GetString("body");
listRepots.Add(rep);
}
ExtraFunctions.Sorts.SortList(_reports, listRepots);
}
}
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 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 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);
}
/// <summary>
/// Получаем srtext проекции
/// </summary>
private string GetSRText(int?srid)
{
if (srid != null)
{
using (var swork = new SqlWork())
{
swork.sql = string.Format(
"SELECT srtext from spatial_ref_sys WHERE srid={0};",
srid);
swork.ExecuteReader();
if (swork.CanRead())
{
return(swork.GetString(0));
}
}
}
return(null);
}
/// <summary>
/// Полнотекстовый поиск
/// </summary>
public void FullTextSearch(object parameter = null)
{
SearchText = parameter.ToString();
_results.Clear();
var searchTables = from PgSearchTableM ftsTable in Tables where ftsTable.SearchWithin select ftsTable.Table;
if (searchTables.Count() > 0)
{
Dictionary <int, PgSearchTableM> tableIdSearchTable = new Dictionary <int, PgSearchTableM>();
using (var sqlWork = new SqlWork(_source.Connect))
{
sqlWork.sql = String.Format(@"SELECT id_table, pkid, label_text
FROM sys_scheme.fts_index
WHERE fts @@ plainto_tsquery('{0}', '{1}') AND id_table IN ({3})
LIMIT {2}",
"russian",
SearchText,
_searchLimit,
String.Join(",", (from PgTableBaseM table in searchTables select table.Id).ToArray()));
sqlWork.ExecuteReader();
while (sqlWork.CanRead())
{
int idTable = sqlWork.GetValue <Int32>("id_table");
int primKey = sqlWork.GetValue <Int32>("pkid");
String labelText = sqlWork.GetValue <String>("label_text");
PgSearchTableM pgSearchTable = null;
if (tableIdSearchTable.ContainsKey(idTable))
{
pgSearchTable = tableIdSearchTable[idTable];
}
else
{
pgSearchTable = new PgSearchTableM(_source, idTable);
tableIdSearchTable.Add(idTable, pgSearchTable);
_results.Add(pgSearchTable);
}
PgSearchObjectM pgSearchObject = new PgSearchObjectM(pgSearchTable, primKey, labelText);
pgSearchTable.SearchObjects.Add(pgSearchObject);
}
}
}
}
/// <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 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);
}