private void button1_Click(object sender, EventArgs e) { oracle.LinkToOracle("orcl", "test", "test");//连接数据库 OracleCommand cmd = oracle.getConnection().CreateCommand(); String tno = textBox1.Text; String pwd = textBox2.Text; if (radioButton1.Checked == true) { cmd.CommandText = String.Format("select * from teacher where tno='{0}'", tno);//从数据库中选出行 OracleDataReader reader = cmd.ExecuteReader();//把数据赋给reader reader.Read(); if (reader.HasRows) if (reader["pwd"].ToString() == pwd) { MessageBox.Show("登录成功"); oracle.LinkClose(); Form5 form5 = new Form5(textBox1.Text); this.Hide(); form5.Show(); //return; } else { MessageBox.Show("用户名不存在或者密码错误"); oracle.LinkClose(); } } else{ cmd.CommandText = String.Format("select * from teacher where tno='{0}'", "m123");//从数据库中选出行 OracleDataReader reader = cmd.ExecuteReader();//把数据赋给reader reader.Read(); if (reader.HasRows) if (reader["pwd"].ToString() == pwd) { MessageBox.Show("登录成功"); oracle.LinkClose(); Form2 form2 = new Form2(); this.Hide(); form2.Show(); //return; } else { MessageBox.Show("用户名不存在或者密码错误"); oracle.LinkClose(); } } }
private void button1_Click(object sender, EventArgs e) { try { MongoClient client = new MongoClient("mongodb://localhost"); MongoServer server = client.GetServer(); MongoDatabase db = server.GetDatabase("dms"); MongoCursor <Class1> put = db.GetCollection <Class1>("u_signup").FindAll(); foreach (Class1 i in put) { if (textBox1.Text == i.uname && textBox2.Text == i.password) { if (ad == 0) { Form1 f1 = new Form1(); f1.Show(); this.Hide(); } else if (ad == 1) { Form5 f5 = new Form5(); f5.Show(); this.Hide(); } else { MessageBox.Show("Select User Type!"); } } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void button10_iClick(object sender, EventArgs e) { Form5 frm = new Form5(); frm.Show(); }
private void button4_Click(object sender, EventArgs e) { Form5 form = new Form5(); //ดึง form มาใช้ form.Show(); //แสดง from ที่ดึงมา }
private void label7_Click(object sender, EventArgs e) { Form5 f5 = new Form5(); f5.Show(); }
private void button5_Click(object sender, EventArgs e) { MySqlConnection con = new MySqlConnection("server=localhost;user id=root;persistsecurityinfo=True;database=voteme;Password =jaishriRAM0385"); MySqlCommand cmd = new MySqlCommand("select * from Ulogin where UserId='" + textBox1.Text + "' and Password ='******'", con); cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@UserId", textBox1.Text); cmd.Parameters.AddWithValue("@Password", textBox2.Text); Form2 obj2 = new Form2(); obj2.id = textBox1.Text; con.Open(); MySqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { Form5 obj1 = new Form5(); obj1.Show(); this.Hide(); obj1.id = textBox1.Text; } else { MessageBox.Show("Invalid Username or Password"); Form1 obj1 = new Form1(); obj1.Show(); this.Hide(); } /* string uid, pass; * uid = textBox1.Text; * pass = textBox2.Text; * * MySqlConnection con; * con = new MySqlConnection(); * con.ConnectionString = "server=localhost;user id=root;persistsecurityinfo=True;database=voteme"; * * MySqlCommand cmd; * //MySqlDataReader reader; * //string query; * // cmd = new SqlCommand("SELECT UserId FROM Ulogin WHERE UserId=" + textBox1.Text + " and Password = "******"'", con); * try * { * con.Open(); * string query; * query = "select password from voteme.ulogin where username = '******'"; * cmd = new MySqlCommand("SELECT UserId FROM Ulogin WHERE UserId=" + textBox1.Text + " and Password = "******"'", con); * //cmd = new MySqlCommand(query, con); * //reader = cmd.ExecuteReader(); * //string upass = query; * * //MySqlDataReader dr = cmd.ExecuteReader(); * * { * Form5 obj1 = new Form5(); * obj1.Show(); * this.Hide(); * } * else * { * MessageBox.Show("Invalid username or password"); * } * * * * con.Close(); } * catch * { * MessageBox.Show("Error!!!!"); * } * finally { con.Dispose(); * } */ /* MySqlDataAdapter a = new MySqlDataAdapter("select count(*) from ulogin where UserId=" + textBox1.Text + " and Password ="******"'", con); * DataTable dt = new DataTable(); * a.Fill(dt); * if (dt.Rows[0][0].ToString()=="1") * { * MessageBox.Show("Login Succesfully"); * this.Hide(); * Form5 obj1 = new Form5(); * obj1.Show(); * * } * else * { * MessageBox.Show("Invalid Username and Password"); * } */ }
private void button4_Click(object sender, EventArgs e) { Form5 f5 = new Form5(); f5.Show(); }
private void button5_Click(object sender, EventArgs e) { Form5 f5 = new Form5(); f5.Show(); }
private void заказыToolStripMenuItem_Click(object sender, EventArgs e) { Form f5 = new Form5(); f5.Show(); }
private void aboutToolStripMenuItem_Click(object sender, EventArgs e) { AboutForm.Show(); }
private void оПрогреммеToolStripMenuItem_Click(object sender, EventArgs e) { Form5 d = new Form5(); d.Show(); }
private void button9_Click(object sender, EventArgs e) //“调度命令模板”按钮 { Form5 form5 = new Form5(); form5.Show(); }
private void button3_Click(object sender, EventArgs e) { this.Visible = false; Form5 connectionMode = new Form5(); connectionMode.Show(); }
private void первыйToolStripMenuItem_Click(object sender, EventArgs e) { Form5 f2 = new Form5(Managers); f2.ShowInTaskbar = false; f2.Owner = this; f2.Show(); }
private void button4_Click(object sender, EventArgs e) { Form5 ob1 = new Form5(); ob1.Show(); }
private void button1_Click(object sender, EventArgs e) { Form5 a = new Form5(); a.Show(this); }
private void listaEStudentaveToolStripMenuItem_Click(object sender, EventArgs e) { Form5 frm5 = new Form5(); frm5.Show(); }
private void button3_Click(object sender, EventArgs e) { Form5 f2 = new Form5(); f2.Show(); }
private void button4_Click(object sender, EventArgs e) { Form Form5 = new Form5(); Form5.Show(); }
private void button1_Click(object sender, EventArgs e) { Form5 fr = new Form5(); fr.Show(); }
private void button5_Click(object sender, EventArgs e) { if (txtRefNo.Text == "") { string delivary = "select Delivaryid from salesOrderDelivery"; DataTable dt3 = d.getDetailByQuery(delivary); string delivaryid = ""; foreach (DataRow dr in dt3.Rows) { delivaryid = dr[0].ToString(); } int del = Convert.ToInt32(delivaryid); int deli = del + 1; string order = "select orderid from orderdetails "; DataTable d1 = d.getDetailByQuery(order); string id = ""; foreach (DataRow dr in d1.Rows) { id = dr[0].ToString(); } if (id == "") { id = "1"; string insertquery = "insert into orderdetails values('" + txtCustcode.Text + "','" + dtpdate.Text + "','" + txttotalammount.Text + "')"; int insertrows = d.saveDetails(insertquery); if (insertrows > 0) { DataGridViewRowCollection rowcollection = gridsalesinvoice.Rows; List <string> show = new List <string>(); for (int a = 0; a < rowcollection.Count; a++) { DataGridViewRow currentrow = rowcollection[a]; DataGridViewCellCollection cellcollection = currentrow.Cells; string txtitemcode = cellcollection[0].Value.ToString(); string txtProductName = cellcollection[1].Value.ToString(); string txtRate = cellcollection[2].Value.ToString(); string txtQuantity = cellcollection[3].Value.ToString(); string txtAmount = cellcollection[4].Value.ToString(); string Orderid = id; string query = "insert into customerorderdescriptions Values('" + Orderid + "','" + txtitemcode + "','" + txtRate + "','" + txtQuantity + "','" + txtAmount + "')"; show.Add(query); } int inserirow1 = d.saveDetails(show); if (inserirow1 > 0) { string salesdelivary = "Insert into salesOrderDelivery values('" + id + "','true','" + dtpdate.Text + "')"; int insertrow = d.saveDetails(salesdelivary); string invoice = "Insert into salesinvoice values('" + deli + "','" + id + "','" + dtpdate.Text + "')"; int insertrow1 = d.saveDetails(invoice); if (insertrow1 > 0) { MessageBox.Show("details save successfully"); } else { MessageBox.Show("details save not successfully"); } } } } else { int id1 = Convert.ToInt32(id); int id2 = id1 + 1; string Orde = id2.ToString(); string insertquery1 = "insert into orderdetails values('" + txtCustcode.Text + "','" + dtpdate.Text + "','" + txttotalammount.Text + "')"; int insertrows1 = d.saveDetails(insertquery1); if (insertrows1 > 0) { DataGridViewRowCollection rowcollection1 = gridsalesinvoice.Rows; List <string> show1 = new List <string>(); for (int a = 0; a < rowcollection1.Count; a++) { DataGridViewRow currentrow = rowcollection1[a]; DataGridViewCellCollection cellcollection = currentrow.Cells; string txtitemcode = cellcollection[0].Value.ToString(); string txtProductName = cellcollection[1].Value.ToString(); string txtRate = cellcollection[2].Value.ToString(); string txtQuantity = cellcollection[3].Value.ToString(); string txtAmount = cellcollection[4].Value.ToString(); string Orderid = id2.ToString(); string query = "insert into customerorderdescriptions Values('" + Orderid + "','" + txtitemcode + "','" + txtRate + "','" + txtQuantity + "','" + txtAmount + "')"; show1.Add(query); } int inserirow2 = d.saveDetails(show1); if (inserirow2 > 0) { string salesdelivary = "Insert into salesOrderDelivery values('" + id2.ToString() + "','true','" + dtpdate.Text + "')"; int insertrow = d.saveDetails(salesdelivary); string invoice = "Insert into salesinvoice values('" + deli + "','" + id2.ToString() + "','" + dtpdate.Text + "')"; int insertrow2 = d.saveDetails(invoice); if (insertrow2 > 0) { MessageBox.Show("details save successfully"); } else { MessageBox.Show("details save not successfully"); } } } } } if (txtRefNo.Text != "") { string delivary = "select Delivaryid from salesOrderDelivery"; DataTable dt3 = d.getDetailByQuery(delivary); string delivaryid = txtRefNo.Text; //foreach (DataRow dr in dt3.Rows) //{ // delivaryid = dr[0].ToString(); //} //int del = Convert.ToInt32(delivaryid); //int deli = del + 1; string order = "select Orderid from salesOrderDelivery where Delivaryid ='" + txtRefNo.Text + "' "; DataTable d1 = d.getDetailByQuery(order); string id = ""; foreach (DataRow dr in d1.Rows) { id = dr[0].ToString(); } string update = "update orderdetails set totalammount='" + txttotalammount.Text + "'where Orderid='" + id + "'"; int c = d.saveDetails(update); string deletequrri1 = "delete customerorderdescriptions where OrderId='" + id + "'"; DataTable dt1 = d.getDetailByQuery(deletequrri1); string insertquery = "insert into orderdetails values('" + txtCustcode.Text + "','" + dtpdate.Text + "','" + txttotalammount.Text + "')"; int insertrows = d.saveDetails(insertquery); if (insertrows > 0) { DataGridViewRowCollection rowcollection = gridsalesinvoice.Rows; List <string> show = new List <string>(); for (int a = 0; a < rowcollection.Count; a++) { DataGridViewRow currentrow = rowcollection[a]; DataGridViewCellCollection cellcollection = currentrow.Cells; string txtitemcode = cellcollection[0].Value.ToString(); string txtProductName = cellcollection[1].Value.ToString(); string txtRate = cellcollection[2].Value.ToString(); string txtQuantity = cellcollection[3].Value.ToString(); string txtAmount = cellcollection[4].Value.ToString(); // string Orderid = id; string query = "insert into customerorderdescriptions Values('" + id + "','" + txtitemcode + "','" + txtRate + "','" + txtQuantity + "','" + txtAmount + "')"; show.Add(query); } int inserirow1 = d.saveDetails(show); if (inserirow1 > 0) { string salesdelivary = "Update salesOrderDelivery set DeliveryDate='" + dtpdate.Text + "' where delivaryid='" + delivaryid + "'"; int insertrow = d.saveDetails(salesdelivary); string invoic = "Insert into salesinvoice values('" + txtRefNo.Text + "','" + id + "','" + dtpdate.Text + "')"; int insertrow1 = d.saveDetails(invoic); if (insertrow1 > 0) { MessageBox.Show("details save successfully"); } else { MessageBox.Show("details save not successfully"); } } } } int id3 = Convert.ToInt32(txtSrNo.Text); int id4 = id3 + 1; txtSrNo.Text = id4.ToString(); Form5 s = new Form5(id3.ToString()); s.Show(); makeblank(); }
private void form5ToolStripMenuItem_Click(object sender, EventArgs e) { Form5 frm = new Form5(); frm.Show(); }
private void button2_Click_1(object sender, EventArgs e) { Form5 yeni = new Form5(); yeni.Show(); }
public void Afisare_Forma(string Text_Forma, Form frn, string Close_or_Hide) { Form f = new Form(); switch (Text_Forma) { case "MENIU": f = new Form1(); f.Show(); Verifica_daca_Close_sau_Hide(Close_or_Hide, frn); break; case "LECTII": f = new Form2(); f.Show(); Verifica_daca_Close_sau_Hide(Close_or_Hide, frn); break; case "CONGRUENTA INTRODUCERE1": f = new Form3(); f.Show(); Verifica_daca_Close_sau_Hide(Close_or_Hide, frn); break; case "CONGRUENTA INTRODUCERE2": f = new Form4(); f.Show(); Verifica_daca_Close_sau_Hide(Close_or_Hide, frn); break; case "CONGRUENTA INTRODUCERE3": f = new Form5(); f.Show(); Verifica_daca_Close_sau_Hide(Close_or_Hide, frn); break; case "CONGRUENTA CAZURI1": f = new Form6(); f.Show(); Verifica_daca_Close_sau_Hide(Close_or_Hide, frn); break; case "CONGRUENTA CAZURI2": f = new Form7(); f.Show(); Verifica_daca_Close_sau_Hide(Close_or_Hide, frn); break; case "CONGRUENTA CAZURI3": f = new Form8(); f.Show(); Verifica_daca_Close_sau_Hide(Close_or_Hide, frn); break; case "CONGRUENTA CAZURI4": f = new Form9(); f.Show(); Verifica_daca_Close_sau_Hide(Close_or_Hide, frn); break; case "CONGRUENTA CAZURI5": f = new Form10(); f.Show(); Verifica_daca_Close_sau_Hide(Close_or_Hide, frn); break; case "CONGRUENTA CAZURI6": f = new Form11(); f.Show(); Verifica_daca_Close_sau_Hide(Close_or_Hide, frn); break; case "CONGRUENTA DREPTUNGHICE": f = new Form12(); f.Show(); Verifica_daca_Close_sau_Hide(Close_or_Hide, frn); break; case "TESTE": f = new Form16(); f.Show(); Verifica_daca_Close_sau_Hide(Close_or_Hide, frn); break; case "TEST USOR": f = new Test_Usor_Pagina_1(); f.Show(); Verifica_daca_Close_sau_Hide(Close_or_Hide, frn); break; case "TEST MEDIU": f = new Test_Mediu(); f.Show(); Verifica_daca_Close_sau_Hide(Close_or_Hide, frn); break; case "TEST GREU": f = new Test_Greu(); f.Show(); Verifica_daca_Close_sau_Hide(Close_or_Hide, frn); break; } }
private void showForm5ToolStripMenuItem_Click(object sender, EventArgs e) { Form5 objektForm5 = new Form5(); objektForm5.Show(); }
private void btnGoTOAdptiveHuffman_Click(object sender, EventArgs e) { Form5 form5 = new Form5(); form5.Show(); }
private void pictureBox3_Click(object sender, EventArgs e) { Form5 f5 = new Form5(); f5.Show(); }
private void portátilToolStripMenuItem_Click(object sender, EventArgs e) { Form5 form5 = new Form5(); form5.MdiParent = this; form5.Show(); }