//登录按钮功能
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("连接数据库失败！");
//}
}
//private void buttonOK_Click(object sender, EventArgs e)
//{
//}
//private void readCheck_CheckedChanged(object sender, EventArgs e)
//{
//}
//private void buttonClear_Click(object sender, EventArgs e)
//{
//}
private void buttonOK_Click_1(object sender, EventArgs e)
{
this.Refresh();
MyConfig mc = new MyConfig();
if (!readCheck.Checked || userName.Text == "" || userPwd.Text == "" || hotelName.Text == "")
{
if (!readCheck.Checked)
{
readCheck.ForeColor = Color.Red;
}
if (userName.Text == "")
{
labelUsercan.Text = "";
labelUser.Text = "请输入用户名";
}
if (userName.Text != null)
{
int flag = 0;
foreach (char c in userName.Text.Trim())
{
if ((c > 'z' || c < 'a') && (c > 'Z' || c < 'A') && (c > '9' || c < '0'))
{
flag = 1;
}
}
if (flag == 1)
{
labelUser.Text = "";
labelUsercan.Text = "用户名中只能包含大小写字母和数字";
}
}
if (userPwd.Text == "")
{
labelPwd.Text = "请输入密码";
}
if (textPwd.Text == "")
{
labelPwd.Text = "两次输入密码不一致！";
}
if (hotelName.Text == "")
{
labelHotel.Text = "请输入酒店名";
}
if (hotelAddr.Text == "")
{
labelAddr.Text = "请输入地址";
}
}
//将用户信息添加到数据库
else
{
if (textPwd.Text != userPwd.Text)
{
labelPwd.Text = "两次输入密码不一致！";
}
else
{
if (mc.getStatus().ToLower() != "yes")
{
SqlTransaction transaction = null;
sc.Connect();
try
{
//新建用户名密码，并获取数据库访问权限
string cmdText = "sp_addlogin " + userName.Text + "," + userPwd.Text;
SqlCommand cmd = new SqlCommand(cmdText, sc.getConn());
cmd.ExecuteNonQuery();
cmd.Dispose();
//mc.setXmlDocument(userName.Text,userPwd.Text);
//sc.Connect();
cmdText = "sp_grantdbaccess N'" + userName.Text + "'";
transaction = sc.getConn().BeginTransaction();
cmd.Transaction = transaction;
cmd.CommandType = CommandType.Text;
cmd.CommandText = cmdText;
cmd.Connection = sc.getConn();
cmd.ExecuteNonQuery();
cmd.Dispose();
cmdText = "EXEC sp_addrolemember N'db_owner',N'" + userName.Text + "'";
cmd.CommandType = CommandType.Text;
cmd.CommandText = cmdText;
cmd.Connection = sc.getConn();
cmd.ExecuteNonQuery();
cmd.Dispose();
cmdText = "EXEC sp_addsrvrolemember '" + userName.Text.Trim() + "','sysadmin'";
cmd.CommandType = CommandType.Text;
cmd.CommandText = cmdText;
cmd.Connection = sc.getConn();
cmd.ExecuteNonQuery();
cmd.Dispose();
mc.setXmlDocument(userName.Text, userPwd.Text, hotelName.Text, hotelTel.Text, hotelAddr.Text);
sc.Connect();
sc.createNew();
sc.Close();
mc.setStatus("yes");
transaction.Commit();
Home.panel_Log();
}
catch (Exception ex)
{
MessageBox.Show("注册失败：" + ex.Message);
transaction.Rollback();
}
}
else
{
MessageBox.Show("系统中已存在一个用户，不能再次注册！");
Home.panel_Log();
}
}
}
}
