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();
}
}
static public DateTime GetServerTime()
{
string str = "select getdate() as serverDate";
DatabaseCmd datacmd = new DatabaseCmd();
SqlDataReader myreader;
try
{
datacmd.SqlExecuteReader(str, out myreader);
if (myreader.Read())
{
return(myreader.GetDateTime(0));
}
else
{
return(DateTime.Now);
}
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message);
return(DateTime.Now);
}
finally
{
datacmd.SqlReaderClose();
}
}
static public int GetWeek()
{
int week = 0;
string str = @"select top 1 datediff(day,[开学日期],getdate())/7+1 from [开学日期]";
DatabaseCmd databasecmd = new DatabaseCmd();
SqlDataReader myreader = null;
databasecmd.SqlExecuteReader(str, out myreader);
week = (myreader.Read()) ? (myreader.GetInt32(0)) : (-1);
databasecmd.SqlReaderClose();
return(week);
}
static public string GetSemester()
{
string Semester = string.Empty;
string str = "select 学期 from [开学日期]";
DatabaseCmd databasecmd = new DatabaseCmd();
SqlDataReader myreader;
databasecmd.SqlExecuteReader(str, out myreader);
if (myreader.Read())
{
Semester = myreader.GetString(0);
}
databasecmd.SqlReaderClose();
return(Semester);
}
public float SumOnlineTime(UserInfo userinfo)
{
float OnlineTime = -1;
string str_time = "select SUM(合计时间) from 时间统计 where 学号 = '" +
userinfo.StuNum + "' and 周次 = " + NowWeek + " and 学期 ='" + Semester + "'";
DatabaseCmd databasecmd = new DatabaseCmd();
SqlDataReader myreader;
databasecmd.SqlExecuteReader(str_time, out myreader);
if (myreader.Read())
{
OnlineTime = (float)myreader.GetDouble(0);
}
databasecmd.SqlReaderClose();
return(OnlineTime);
}
