//登录按钮功能
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("连接数据库失败！");
//}
}
