//登录按钮功能 private void Login_Click(object sender, EventArgs e) { Home.Refresh(); if (userName.Text == "" || userPwd.Text == "") { if (userName.Text == "") { labelUser.Visible = true; } if (userPwd.Text == "") { labelPwd.Visible = true; } } else if(radioSu.Checked) { MyConfig mc=new MyConfig(); if (userName.Text == mc.getUser() && userPwd.Text == mc.getPwd()) { //连接数据库 sc.Connect(); //设置登录状态 fd.setAdminStatus(true); fd.setWords("用户登录成功!相应操作已解锁,\n\n 新用户请先进行客房信息录入"); Home.panel_Wel(); } else { labelLogin.Text = "用户名或密码不正确!"; } } else if(radioUser.Checked) { sc.Connect(); string cmdText = "select Username,Pwd from Users"; SqlDataAdapter adapter = new SqlDataAdapter(cmdText, sc.getConn()); DataSet dataSet = new DataSet(); adapter.Fill(dataSet); adapter.Dispose(); int flag = 0; for (int i = 0; i < dataSet.Tables[0].Rows.Count; i++) { if (dataSet.Tables[0].Rows[i][0].ToString().Trim() == userName.Text.Trim() && dataSet.Tables[0].Rows[i][1].ToString().Trim() == userPwd.Text.Trim()) { flag = 1; fd.setUserStatus(true); fd.setWords("用户登录成功!相应操作已解锁,\n\n "); Home.panel_Wel(); } } if (flag == 0) { labelLogin.Text = "用户名或密码不正确!"; } } else { MessageBox.Show("未选中登录方式!"); } }
public void setAll() { MyConfig mc = new MyConfig(); setServer(mc.getServer()); setUser(mc.getUser()); setPwd(mc.getPwd()); setDatabase(mc.getDbname()); }
public void ConnectServer() { MyConfig mc = new MyConfig(); setServer(mc.getServer()); setUser(mc.getUser()); setPwd(mc.getPwd()); string ConString = "server=" + servername + ";uid=" + username + ";pwd=" + pwd; conn = new SqlConnection(ConString); conn.Open(); //if (conn.State == ConnectionState.Open) //{ // MessageBox.Show("连接数据库成功!"); //} //else //{ // MessageBox.Show("连接数据库失败!"); //} }