private void Button1_Click(object sender, EventArgs e)
{
if (MessageBox.Show("是否将本机绑定为签到机器？", "绑定MAC",
MessageBoxButtons.YesNo) == DialogResult.Yes)
{
string Pwd = UserFunction.Md5(TextBox_pwd.Text.ToString());
string selectcmd = "select 学号 from [member] where 学号 = '" +
TextBox_num.Text.ToString() + "' and 密码 = '" +
Pwd + "'";
DatabaseCmd database = new DatabaseCmd();
SqlDataReader myreader;
database.SqlExecuteReader(selectcmd, out myreader);
if (myreader.Read())
{
string updatestr = "update [member] set MAC = '" +
UserFunction.GetMacByNetworkInterface() +
"' where 学号 = '" + myreader.GetString(0) + "'";
DatabaseCmd database2 = new DatabaseCmd();
database2.SqlExecuteNonQuery(updatestr);
}
else
{
MessageBox.Show("学号或密码错误！");
}
database.SqlReaderClose();
MessageBox.Show("绑定成功！ MAC地址为：" +
UserFunction.GetMacByNetworkInterface());
this.Close();
}
}
public bool GetInfo(ref UserInfo userinfo)
{
string str = string.Empty;
if (UserType == 1)
{
str = @"select UserName,学号,姓名,组别,电话,座右铭,年级 from [member] where USERNAME='******'";
}
else if (UserType == 2)
{
str = @"select UserName,学号,姓名,组别,电话,座右铭,年级 from [member] where MAC='" +
UserFunction.GetMacByNetworkInterface() + "'";
}
DatabaseCmd databasecmd = new DatabaseCmd();
SqlDataReader myreader;
databasecmd.SqlExecuteReader(str, out myreader);
if (myreader.Read())
{
userinfo.UserName = myreader.GetString(0).ToString();
userinfo.StuNum = myreader.GetString(1).ToString();
userinfo.user = myreader.GetString(2).ToString();
userinfo.Team = myreader.GetString(3).ToString();
userinfo.Phone = myreader.GetString(4).ToString();
userinfo.HappyMotto = myreader.GetString(5).ToString();
userinfo.Grade = myreader.GetString(6).ToString();
return(true);
}
else
{
return(false);
}
}
