public void Insert(AuthorityManagent authorityManagent, string TableName)
{
SqlConnection _SqlConnection = new SqlConnection(SqlConnectionStringBuilder.ToString());
try
{
string TestComm = string.Format("INSERT INTO dbo.{0}({1}) VALUES({2})", TableName, "UserName,Password,Authority", string.Format("'{0}','{1}','{2}'", authorityManagent.UserName, authorityManagent.Password, authorityManagent.Auth));
SqlCommand InsertComm = new SqlCommand(TestComm, _SqlConnection);
if (_SqlConnection.State == ConnectionState.Closed)
{
_SqlConnection.Open();
}
InsertComm.ExecuteNonQuery();
}
catch (Exception)
{
return;
}
finally
{
if (_SqlConnection != null && _SqlConnection.State == ConnectionState.Open)
{
_SqlConnection.Close();
}
}
}
public AuthorityManagent Login(string UserName, string Password)
{
SqlConnection _SqlConnection = new SqlConnection(SqlConnectionStringBuilder.ToString());
AuthorityManagent managent = null;
try
{
string TextComm = "SELECT * FROM dbo.Authority";
SqlCommand SelectComm = new SqlCommand(TextComm, _SqlConnection);
if (_SqlConnection.State == ConnectionState.Closed)
{
_SqlConnection.Open();
}
SqlDataReader reader = SelectComm.ExecuteReader();
while (reader.Read())
{
managent = new AuthorityManagent(reader["UserName"].ToString().Trim(), reader["Password"].ToString().Trim(), (AuthorityManagent.Authority)Enum.Parse(typeof(AuthorityManagent.Authority), reader["Authority"].ToString().Trim()));
if (managent.UserName == UserName && managent.Password == Password)
{
managent.CheckAuthority = true;
break;
}
}
return(managent);
}
catch (Exception)
{
throw;
}
finally
{
if (_SqlConnection != null && _SqlConnection.State == ConnectionState.Open)
{
_SqlConnection.Close();
}
}
}
private void Btn_Login_Click(object sender, EventArgs e)
{
if (Btn_Login.Text == "登入")
{
AuthorityManagent managent = MainForm.broker.Login(Txt_UserName.Text, Txt_Password.Text); //抓取sql server中儲存的登入權限
if (managent.CheckAuthority) // 如果輸入的帳號密碼符合sql server中登錄的資訊,則將此form關閉
{
CheckAuthoruty(this, new AuthorityCheckEvent()
{
UserName = managent.UserName, Password = managent.Password, AuthorityManagent = managent.Auth.ToString()
}); //觸發事件,告知form1當前的登入者是誰
this.Close();
}
else if (Txt_UserName.Text == "WhosYourDaddy") //開啟創造者模式
{
CheckAuthoruty(this, new AuthorityCheckEvent()
{
UserName = "******", Password = "", AuthorityManagent = "創造者"
});
this.Close();
}
else
{
MessageBox.Show("請確認輸入的帳號及密碼");
}
}
else
{
CheckAuthoruty(this, new AuthorityCheckEvent()
{
UserName = "", Password = "", AuthorityManagent = ""
});
Btn_Login.Text = "登入";
Txt_Password.Text = "";
this.Authority = "";
}
}