private void button2_Click(object sender, EventArgs e)
{
Form3 view = new Form3();
view.ShowDialog();
}
private void button1_Click(object sender, EventArgs e)
{
Form3 f2 = new Form3();
f2.ShowDialog();
}
private void button7_Click(object sender, EventArgs e)
{
Form3 frm = new Form3();
frm.ShowDialog();
}
private void button3_Click(object sender, EventArgs e)
{
Form3 form = new Form3(prod[listBox1.SelectedIndex]);
form.ShowDialog();
}
private void button8_Click(object sender, EventArgs e)
{
Form3 form3 = new Form3();
form3.ShowDialog();
}
private void button2_Click(object sender, EventArgs e)
{
form3.ShowDialog();
}
private void inCustomerToolStripMenuItem_Click(object sender, EventArgs e)
{
Form3 forma = new Form3();
forma.ShowDialog();
}
private void button10_Click(object sender, EventArgs e)
{
Form3 f = new Form3();
f.Text = " ";
if (f.ShowDialog() == DialogResult.OK)
{
int index, index_old;
string ID;
string CommandText = "DELETE FROM ";
index = dataGridView2.CurrentRow.Index; // № по порядку в таблице представления
index_old = index;
ID = Convert.ToString(dataGridView2[0, index].Value); // ID подаем в запрос как строку
// Формируем строку CommandText
if (act_table == 1) // обрабатываем таблицу "Билет"
{
CommandText = "DELETE FROM Билет WHERE Билет.ID_Bilet = " + ID;
}
if (act_table == 2) // обрабатываем таблицу "Маршрут"
{
CommandText = "DELETE FROM Маршрут WHERE Маршрут.ID_Marshrut = " + ID;
}
if (act_table == 3) // обрабатываем таблицу "Автобус"
{
CommandText = "DELETE FROM Автобус WHERE Автобус.ID_Avtobus = " + ID;
}
if (act_table == 4) // обрабатываем таблицу "Водитель"
{
CommandText = "DELETE FROM Водитель WHERE Водитель.ID_Voditel = " + ID;
}
if (act_table == 5) // обрабатываем таблицу "Диспетчер"
{
CommandText = "DELETE FROM Диспетчер WHERE Диспетчер.ID_Dispetcher = " + ID;
}
// выполняем SQL-запрос
My_Execute_Non_Query(CommandText);
// перерисовывание dbGridView2
if (act_table == 1)
{
Get_Bilets();
}
else
if (act_table == 2)
{
Get_Marshruts();
}
else
if (act_table == 3)
{
Get_Avtobus();
}
else
if (act_table == 4)
{
Get_Voditel();
}
else
if (act_table == 5)
{
Get_Dispetcher();
}
if (index_old >= 0)
{
dataGridView2.ClearSelection();
dataGridView2[0, index_old].Selected = true;
}
}
}
private void 项OToolStripMenuItem_Click(object sender, EventArgs e)
{
Form3 form3 = new Form3();
form3.ShowDialog();
}
private void button2_Click(object sender, EventArgs e)
{
if (treeView1.SelectedNode.Parent != null && treeView1.SelectedNode.Parent.Text == "Tables")
{
panel1.Controls.Clear();
Form6 tdata = new Form6(treeView1.SelectedNode.Text, treeView1.SelectedNode.Parent.Parent.Text);
tdata.TopLevel = false;
tdata.AutoScroll = true;
tdata.FormBorderStyle = FormBorderStyle.None;
panel1.Controls.Add(tdata);
tdata.Show();
}
else if (treeView1.SelectedNode.Text == "Tables")
{
panel1.Controls.Clear();
Tablas tablas = new Tablas(treeView1.SelectedNode.Parent.Text);
tablas.TopLevel = false;
tablas.AutoScroll = true;
tablas.FormBorderStyle = FormBorderStyle.None;
panel1.Controls.Add(tablas);
tablas.Show();
}
else if (treeView1.SelectedNode.Text == "Views")
{
panel1.Controls.Clear();
Views views = new Views(treeView1.SelectedNode.Parent.Text);
views.TopLevel = false;
views.AutoScroll = true;
views.FormBorderStyle = FormBorderStyle.None;
panel1.Controls.Add(views);
views.Show();
}
else if (treeView1.SelectedNode.Text == "Procedures")
{
panel1.Controls.Clear();
Procedures procedures = new Procedures(treeView1.SelectedNode.Parent.Text);
procedures.TopLevel = false;
procedures.AutoScroll = true;
procedures.FormBorderStyle = FormBorderStyle.None;
panel1.Controls.Add(procedures);
procedures.Show();
}
else if (treeView1.SelectedNode.Text == "Checks")
{
panel1.Controls.Clear();
Checks checks = new Checks(treeView1.SelectedNode.Parent.Text);
checks.TopLevel = false;
checks.AutoScroll = true;
checks.FormBorderStyle = FormBorderStyle.None;
panel1.Controls.Add(checks);
checks.Show();
}
else if (treeView1.SelectedNode.Text == "Indexes")
{
panel1.Controls.Clear();
Indexes indexes = new Indexes(treeView1.SelectedNode.Parent.Text);
indexes.TopLevel = false;
indexes.AutoScroll = true;
indexes.FormBorderStyle = FormBorderStyle.None;
panel1.Controls.Add(indexes);
indexes.Show();
}
else if (treeView1.SelectedNode.Text == "Triggers")
{
panel1.Controls.Clear();
Triggers triggers = new Triggers(treeView1.SelectedNode.Parent.Text);
triggers.TopLevel = false;
triggers.AutoScroll = true;
triggers.FormBorderStyle = FormBorderStyle.None;
panel1.Controls.Add(triggers);
triggers.Show();
}
else
{
string text = treeView1.SelectedNode.Text;
foreach (var con in Globals.connections)
{
if (con.conn_name == text)
{
Globals.connection_string = "Driver=Adaptive Server Enterprise; Server=" + con.server + ";Port=" + con.port + ";";
Form3 login = new Form3();
login.ShowDialog();
OdbcConnection conn = new OdbcConnection(Globals.connection_string);
conn.Open();
OdbcCommand command = conn.CreateCommand();
OdbcDataReader reader;
command.CommandText = "select name from sysdatabases";
reader = command.ExecuteReader();
List <string> list = new List <string>();
while (reader.Read())
{
list.Add(reader.GetString(0));
}
conn.Close();
List <TreeNode> dbs = new List <TreeNode>();
foreach (var db in list)
{
List <TreeNode> objects = new List <TreeNode>();
List <TreeNode> tabs = new List <TreeNode>();
string idk = Globals.connection_string + "database=" + db + ";";
conn = new OdbcConnection(idk);
try
{
conn.Open();
command = conn.CreateCommand();
command.CommandText = "select name from sysobjects where type = 'U' and uid = user_id()";
reader = command.ExecuteReader();
List <string> list1 = new List <string>();
while (reader.Read())
{
list1.Add(reader.GetString(0));
}
conn.Close();
foreach (var tab in list1)
{
tabs.Add(new TreeNode(tab));
}
objects.Add(new TreeNode("Tables", tabs.ToArray()));
objects.Add(new TreeNode("Views"));
objects.Add(new TreeNode("Indexes"));
objects.Add(new TreeNode("Procedures"));
objects.Add(new TreeNode("Triggers"));
objects.Add(new TreeNode("Checks"));
dbs.Add(new TreeNode(db, objects.ToArray()));
}
catch (Exception)
{
}
}
treeView1.BeginUpdate();
treeView1.SelectedNode.Remove();
treeView1.Nodes.Add(new TreeNode(text, dbs.ToArray()));
treeView1.EndUpdate();
}
}
}
}
private void Button3_Click(object sender, EventArgs e)
{
Form3 frmVendas = new Form3();
frmVendas.ShowDialog();
}
// 종료버튼
private void button2_Click(object sender, EventArgs e)
{
Form3 manl = new Form3();
manl.ShowDialog();
}//도움말에 들어가기 위한 버튼
private void btnBest_Click(object sender, EventArgs e)
{
Form3 form = new Form3();
form.ShowDialog();
}
private void griYontemleriToolStripMenuItem_Click(object sender, EventArgs e)
{
Form3 griformu = new Form3();
griformu.ShowDialog();
}
private void button1_Click(object sender, EventArgs e)
{
FileStream file1 = new FileStream("password.txt", FileMode.OpenOrCreate);
StreamReader reader = new StreamReader(file1);
_passLine = reader.ReadToEnd();
reader.Close();
string _crresultChar = "";
string _randomLine = "нуkы6мцc5вlт2шajдdрэ1лrъефx3ogbeжохfа0hipnп97и8qкvщtючьzmсsзywuг4йб";
string _cryptedString = "";
string _result = "";
string _resultChar = "";
Random _rand = new Random();
int _d = (int)Math.Ceiling(Math.Sqrt(_line.Length));
if (_d % 2 != 1)
{
_d++;
}
int[,] _quad = new int[_d, _d];
for (int j = 0; j < _d; j++)
{
for (int i = 0; i < _d; i++)
{
_quad[i, j] = _d * (((i + 1) + (j + 1) - 1 + (_d / 2)) % _d) + (((i + 1) + 2 * (j + 1) - 2) % _d) + 1;
_resultChar = (_quad[i, j].ToString() + " ");
_result += _resultChar;
}
}
for (int j = 0; j < _d; j++)
{
for (int i = 0; i < _d; i++)
{
if ((_quad[i, j] - 1) < _line.Length)
{
_cryptedString += _line[_quad[i, j] - 1]; _crresultChar += _line[_quad[i, j] - 1];
}
else
{
char _randomChar = _randomLine[j];
_cryptedString += _randomChar; _crresultChar += _randomChar;
}
}
}
if (_passLine.Length == 0)
{
Hide();
Form Form5 = new Form5();
Form5.ShowDialog();
Close();
}
else
if (_cryptedString == _passLine)
{
Hide();
Form Form2 = new Form2();
Form2.ShowDialog();
Close();
}
else
{
textBox1.Text = ""; i--; label2.Text = "Осталось попыток " + i + ".";
}
if (i == 1)
{
Form Form3 = new Form3(); Form3.ShowDialog();
}
if (i == 0)
{
Close();
}
}
private void button1_Click(object sender, EventArgs e)
{
Form3 newForm = new Form3(this);
newForm.ShowDialog();
}
