private void StringReplaseSettings_Load(object sender, EventArgs e)
{
//Получим наименование ключевого поля
try
{
key_field_db_name = DBFunctions.GetGlobalParameter("StringReplaceKeyField");
}
catch (Exception err)
{
System.Windows.Forms.MessageBox.Show(err.Message, "Ошибка", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error);
Close();
}
//Теперь пользовательское наименование для размещения в label на тулстрипе
Dictionary <string, object> parameters = new Dictionary <string, object>();
parameters.Add("coldbname", key_field_db_name);
tslKeyFieldName.Text = (string)DBFunctions.ReadScalarFromDB("SELECT ColumnName FROM tableconfig WHERE ColumnDBName = @coldbname", parameters);
//Получим все возможные значения ключевого поля
cbKeyFieldValues.Items.Clear();
key_field_values = new ArrayList();
DataTable dt_key_field_values = DBFunctions.ReadFromDB("SELECT DISTINCT " + key_field_db_name + " AS key_field FROM table_credprogr ORDER BY " + key_field_db_name);
foreach (DataRow kf_row in dt_key_field_values.Rows)
{
cbKeyFieldValues.Items.Add(kf_row["key_field"]);
key_field_values.Add(kf_row["key_field"]);
}
//Заполним справочники
reference_db_names = new ArrayList();
DataTable dt_references = DBFunctions.ReadFromDB("SELECT referencesconfig.ReferenceDBName,referencesconfig.ReferenceName FROM referencesconfig ORDER BY referencename");
foreach (DataRow ref_row in dt_references.Rows)
{
cbReferenceNames.Items.Add(ref_row["ReferenceName"]);
reference_db_names.Add(ref_row["ReferenceDBName"]);
}
dgReplaceStrings.AutoGenerateColumns = false;
dgReplaceStrings.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
DataGridViewTextBoxColumn ref_id_column = new DataGridViewTextBoxColumn();
ref_id_column.Name = "ref_id";
ref_id_column.HeaderText = "ID элемента справочника";
ref_id_column.DataPropertyName = "table_reference_id";
ref_id_column.Visible = false;
dgReplaceStrings.Columns.Add(ref_id_column);
DataGridViewComboBoxColumn ref_name_column = new DataGridViewComboBoxColumn();
ref_name_column.Name = "ref_name";
ref_name_column.HeaderText = "Элемент справочника";
ref_name_column.DataPropertyName = "table_reference_value";
dgReplaceStrings.Columns.Add(ref_name_column);
DataGridViewTextBoxColumn replace_string_column = new DataGridViewTextBoxColumn();
replace_string_column.Name = "replace_string";
replace_string_column.HeaderText = "Строка для замены";
replace_string_column.DataPropertyName = "replace_string";
dgReplaceStrings.Columns.Add(replace_string_column);
dt_replaces = new DataTable();
dgReplaceStrings.DataSource = dt_replaces;
cbReferenceNames.SelectedIndex = 0;
cbKeyFieldValues.SelectedIndex = 0;
TestRights();
}
