private void button2_Click(object sender, EventArgs e)
{
_parentForm.CloseModalElem();
}
private void button1_Click(object sender, EventArgs e)
{
parent.CloseModalElem();
}
private void button1_Click(object sender, EventArgs e)
{
var fi = classesOfMetods.getFieldInfo(id);
var ti = classesOfMetods.getTableInfo(fi.idTable);
if (comboBox8.SelectedIndex == 1)
{
if (comboBox1.SelectedItem != null &&
comboBox2.SelectedItem != null &&
comboBox3.SelectedItem != null)
{
string sql = "";
if (ti.style_field == fi.nameDB && (((itemObj)comboBox1.SelectedItem).Id_o != fi.ref_table ||
((itemObj)comboBox2.SelectedItem).Id_o != fi.ref_field ||
((itemObj)comboBox3.SelectedItem).Id_o != fi.ref_field_name))
{
if (MessageBox.Show(Rekod.Properties.Resources.FELC_DeletingFieldStyle + Environment.NewLine +
Rekod.Properties.Resources.PFC_EditingFieldsAsk,
Rekod.Properties.Resources.PFC_EditingFields,
MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation, MessageBoxDefaultButton.Button2) != DialogResult.Yes)
{
return;
}
else
{
sql = "UPDATE " + Program.scheme + ".table_info SET default_style=true, style_field='style' WHERE id=" + ti.idTable + ";";
}
}
SqlWork sqlCmd = new SqlWork();
sqlCmd.sql = sql + "UPDATE " + Program.scheme + ".table_field_info SET is_reference = true, is_interval=false, " +
"ref_table = " + ((itemObj)comboBox1.SelectedItem).Id_o + ", " +
"ref_field = " + ((itemObj)comboBox2.SelectedItem).Id_o + ", " +
"ref_field_name = " + ((itemObj)comboBox3.SelectedItem).Id_o + " " +
" WHERE id =" + id;
sqlCmd.Execute(true);
sqlCmd.Close();
parent.CloseModalElem();
classesOfMetods cls = new classesOfMetods();
cls.reloadInfo();
DBTablesEdit.SyncController.ReloadTable(ti.idTable);
return;
}
else
{
MessageBox.Show(Rekod.Properties.Resources.PFC_AllFieldsFill);
return;
}
}
else
if (comboBox8.SelectedIndex == 3)
{
if (comboBox9.SelectedItem != null &&
comboBox10.SelectedItem != null &&
comboBox11.SelectedItem != null)
{
string sql = "";
if (ti.style_field == fi.nameDB && (((itemObj)comboBox9.SelectedItem).Id_o != fi.ref_table ||
((itemObj)comboBox10.SelectedItem).Id_o != fi.ref_field ||
((itemObj)comboBox11.SelectedItem).Id_o != fi.ref_field_name))
{
if (MessageBox.Show(Rekod.Properties.Resources.FELC_DeletingFieldStyle + Environment.NewLine +
Rekod.Properties.Resources.PFC_EditingFieldsAsk,
Rekod.Properties.Resources.PFC_EditingFields,
MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation, MessageBoxDefaultButton.Button2) != DialogResult.Yes)
{
return;
}
else
{
sql = "UPDATE " + Program.scheme + ".table_info SET default_style=true, style_field='style' WHERE id=" + ti.idTable + ";";
}
}
SqlWork sqlCmd = new SqlWork();
sqlCmd.sql = sql + "UPDATE " + Program.scheme + ".table_field_info SET is_reference = true, is_interval=false, " +
"ref_table = " + ((itemObj)comboBox9.SelectedItem).Id_o + ", " +
"ref_field = " + ((itemObj)comboBox10.SelectedItem).Id_o + ", " +
"ref_field_name = " + ((itemObj)comboBox11.SelectedItem).Id_o + " " +
" WHERE id =" + id;
sqlCmd.Execute(true);
sqlCmd.Close();
parent.CloseModalElem();
classesOfMetods cls = new classesOfMetods();
cls.reloadInfo();
DBTablesEdit.SyncController.ReloadTable(ti.idTable);
return;
}
else
{
MessageBox.Show(Rekod.Properties.Resources.PFC_AllFieldsFill);
return;
}
}
else
{
if (comboBox8.SelectedIndex == 2)
{
if (comboBox4.SelectedItem != null &&
comboBox5.SelectedItem != null &&
comboBox6.SelectedItem != null &&
comboBox7.SelectedItem != null)
{
string sql = "";
if (ti.style_field == fi.nameDB && (((itemObj)comboBox4.SelectedItem).Id_o != fi.ref_table ||
((itemObj)comboBox5.SelectedItem).Id_o != fi.ref_field ||
((itemObj)comboBox6.SelectedItem).Id_o != fi.ref_field_end ||
((itemObj)comboBox7.SelectedItem).Id_o != fi.ref_field_name))
{
if (MessageBox.Show(Rekod.Properties.Resources.FELC_DeletingFieldStyle + Environment.NewLine +
Rekod.Properties.Resources.PFC_EditingFieldsAsk,
Rekod.Properties.Resources.PFC_EditingFields,
MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation, MessageBoxDefaultButton.Button2) != DialogResult.Yes)
{
return;
}
else
{
sql = "UPDATE " + Program.scheme + ".table_info SET default_style=true, style_field='style' WHERE id=" + ti.idTable + ";";
}
}
SqlWork sqlCmd = new SqlWork();
sqlCmd.sql = sql + "UPDATE " + Program.scheme + ".table_field_info SET is_reference = false, is_interval=true, " +
"ref_table = " + ((itemObj)comboBox4.SelectedItem).Id_o + ", " +
"ref_field = " + ((itemObj)comboBox5.SelectedItem).Id_o + ", " +
"ref_field_end = " + ((itemObj)comboBox6.SelectedItem).Id_o + ", " +
"ref_field_name = " + ((itemObj)comboBox7.SelectedItem).Id_o + " " +
" WHERE id =" + id;
sqlCmd.Execute(true);
sqlCmd.Close();
//MessageBox.Show("Настройки зафиксированы!");
parent.CloseModalElem();
classesOfMetods cls = new classesOfMetods();
cls.reloadInfo();
DBTablesEdit.SyncController.ReloadTable(ti.idTable);
return;
}
else
{
MessageBox.Show(Rekod.Properties.Resources.PFC_AllFieldsFill);
return;
}
}
else
{
string sql = "";
if (ti.Style.DefaultStyle != true && ti.style_field == fi.nameDB && fi.ref_table != null)
{
if (MessageBox.Show(Rekod.Properties.Resources.FELC_DeletingFieldStyle + Environment.NewLine +
Rekod.Properties.Resources.PFC_EditingFieldsAsk,
Rekod.Properties.Resources.PFC_EditingFields,
MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation, MessageBoxDefaultButton.Button2) == DialogResult.Yes)
{
sql = "UPDATE " + Program.scheme + ".table_info SET default_style=true, style_field='style' WHERE id=" + ti.idTable + ";";
}
else
{
return;
}
}
SqlWork sqlCmd = new SqlWork();
sqlCmd.sql = sql + "UPDATE " + Program.scheme + ".table_field_info SET is_reference = false, is_interval = false, is_style = false, ref_table = NULL, ref_field = NULL, ref_field_end = NULL, ref_field_name = NULL " +
" WHERE id =" + id.ToString();
sqlCmd.Execute(true);
sqlCmd.Close();
parent.CloseModalElem();
classesOfMetods cls = new classesOfMetods();
cls.reloadInfo();
DBTablesEdit.SyncController.ReloadTable(ti.idTable);
return;
}
}
}
