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); }