private void Btn_Connection_Click(object sender, EventArgs e) { if (JudgeLogin()) { if (Drop_DataBase.Text == "暂未连接") { MessageBox.Show("请先测试连接,选择目标数据库!"); Btn_TestConnect.Focus(); return; } if (checkBox1.Checked) SaveSettings(); else DeleteSettings(); Config.DataBase = Drop_DataBase.SelectedValue.ToString(); Config.Pwd = Tb_Pwd.Text; Config.Server = Tb_Server.Text; Config.User = Tb_User.Text; Config.Conn = CONN; this.Visible = false; if (rbo_Assembly.Checked) { Main_Assembly m = new Main_Assembly(); m.Show(); } else if (rbo_WCF_Restful.Checked) { Main f1 = new Main(); f1.Show(); } } }
private void btnlogin_Click(object sender, EventArgs e) { /*MySqlConnection con = new MySqlConnection(@"Server=192.168.0.24;Database=inventory_items;Uid=tina;Pwd=!ojt2015;"); MySqlDataAdapter sda = new MySqlDataAdapter("Select acct_type from users where uname ='"+textBox1.Text+"' and pword ='"+txtpword.Text+"'", con); DataTable dt = new System.Data.DataTable(); sda.Fill(dt); if(dt.Rows.Count ==1) { } else { }*/ this.Hide(); Main main = new Main(); main.Show(); }
private void btn_login_Click(object sender, EventArgs e) { string var_username = username.Text.ToString(); string var_password = password.Text.ToString(); string selectOne = "SELECT * FROM users where username = @username and password = @password LIMIT 1"; MySqlCommand cmd = new MySqlCommand(selectOne, conn); cmd.Parameters.AddWithValue("@username", var_username); cmd.Parameters.AddWithValue("@password", var_password); conn.Open(); MySqlDataReader reader = cmd.ExecuteReader(); int n = 0; while (reader.Read()) { string name = reader.GetString("name"); string surname = reader.GetString("surname"); string[] user = new string[4]; user[0] = reader.GetString("user_id"); user[1] = reader.GetString("name"); user[2] = reader.GetString("type"); user[3] = reader.GetString("surname"); MessageBox.Show("ยืนดีต้อนรับ คุณ" + name + " " + surname + " เข้าสู่ระบบ"); Main ds = new Main(user); ds.Show(); this.Hide(); n++; } if (n == 0) { MessageBox.Show("Username หรือ password ไม่ถูกต้อง"); } conn.Close(); }
private void btnlogin_Click(object sender, EventArgs e) { if (staff.Checked == true) { conn.dbcon(); try { cm = new SqlCommand("Select username, password from userpass where Username = '******' and Password = '******'"); cm.Connection = Connectionclass.con; SqlDataReader dr; dr = cm.ExecuteReader(); if (dr.Read()) { MessageBox.Show("Successfully Log In", "Welcome"); this.Hide(); Main dis = new Main(); dis.Show(); } else { MessageBox.Show("Failed to Login. Please Check your Username and Password", "Error"); return; } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { conn.Closecon(); } } else if (admin.Checked == true) { conn.dbcon(); try { cm = new SqlCommand("Select username, password from adminpass where Username = '******' and Password = '******'"); cm.Connection = Connectionclass.con; SqlDataReader dr; dr = cm.ExecuteReader(); if (dr.Read()) { MessageBox.Show("Successfully Log In", "Welcome"); this.Hide(); Main dis = new Main(); dis.Show(); } else { MessageBox.Show("Failed to Login. Please Check your Username and Password", "Error"); return; } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { conn.Closecon(); } } else { MessageBox.Show("Please Select User Type.", "Error"); return; } }
private void btn_Denglu_Click(object sender, EventArgs e) { //判定各种是否为空 if (txtbox_Zhanghao.Text.Trim() == string.Empty) { MessageBox.Show("账号不能为空!"); txtbox_Zhanghao.Focus(); } if (txtbox_Mima.Text.Trim() == string.Empty) { MessageBox.Show("密码不能为空!"); txtbox_Mima.Focus(); } else { string zhanghao = txtbox_Zhanghao.Text.Trim(); string mima = txtbox_Mima.Text.Trim(); Opertion bean = new Opertion(); if (rbtn_Yonghu.Checked) { if (txtbox_Xuehao.Text.Trim() == string.Empty) { MessageBox.Show("学号不能为空"); txtbox_Xuehao.Focus(); } else { string xuehao = txtbox_Xuehao.Text.Trim(); Boolean ok = bean.pswCheck(zhanghao, mima, xuehao); if (ok) { //密码正确需要跳转页面到main MessageBox.Show("success!"); this.Hide(); UsrZhanghao = txtbox_Zhanghao.Text.Trim().ToString(); UsrXuehao = txtbox_Xuehao.Text.Trim().ToString(); f_m = new Main(); f_m.Show(); } else { MessageBox.Show("mima Error!"); } } } else if (rbtn_Guanliyuan.Checked) { Boolean glyLog = bean.gylLogin(zhanghao, mima); if (glyLog) { //密码正确需要跳转页面到main MessageBox.Show("success!"); this.Hide(); f_gly = new Guanliyuan(); f_gly.Show(); } } } }
private void Start_Click(object sender, EventArgs e) { Main M1 = new Main(); M1.Show(); }
private void button1_Click(object sender, EventArgs e) { Main m = new Main(); m.Show(); }