//登录按钮功能 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(); } } } }