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();
}
