public void BuildConstraint() { var key = WizardSQLHelper.GetPrimaryKeyName(Join.NomTable); //var param = new string[] { View.Schema, Join.NomTable, View.NomTable, Join.ChampDeRef, View.Schema, key }; //WizardHelper.ExecuteFromFile("addConstraint.sql", param, Program.AppSet.ConnectionString); WizardSQLHelper.addConstraint(View.Schema, Join.NomTable, View.NomTable, Join.ChampDeRef, View.Schema, key, _own); }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Button_end(object sender, PageEventArgs e) { if (radAuto.Checked) { foreach (TabloidConfigJointure Tj in lstAutoJoin.SelectedItems) { Tools.AddWithUniqueName(_view.Jointures, Tj, "J", _parentJoin == null ? null : _parentJoin.Jointures); } } else { var newTable = cmbTable.SelectedItem.ToString(); var dbKey = WizardSQLHelper.GetPrimaryKeyName(newTable); if (dbKey == null) { MetroMessageBox.Show(this, Properties.Resources.CantFindPrimaryKey, Properties.Resources.Erreur, MessageBoxButtons.OK, MessageBoxIcon.Error); return; } var is1N = cmbTypeJointure.SelectedItem.ToString() == "1:N"; var Tj = new TabloidConfigJointure { NomTable = newTable, Relation = cmbTypeJointure.SelectedItem.ToString(), DbKey = dbKey, Parent = _parentJoin, ChampDeRef = is1N ? getJoinParentView().NomTable + "." + cmbChampRef.SelectedItem : cmbChampRef.SelectedItem.ToString(), ChampDeRef2 = is1N ? cmbChampRef2.SelectedItem.ToString() : "", }; if (cmbOrder.SelectedIndex > 0) { Tj.Order = cmbOrder.SelectedItem + " " + (cmbOrderType.SelectedIndex == 0 ? "asc" : "desc"); } Tj.Visu = WizardSQLHelper.GetVisibiliteFromCheckedListBox(lstVisibilites); Tools.AddWithUniqueName(_view.Jointures, Tj, "J", _parentJoin == null ? null : _parentJoin.Jointures); } }