using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Text;
using?System.Windows.Forms;
using?System.Data.SqlClient;
namespace?學生考勤系統
{
????public?partial?class?checkClass?:?Form
????{
????????linkDatabase?link?=?new?linkDatabase（）;
????????DataTable?dt1dt2dt3;
????????string?update;
????????int?totalNum;
????????public?checkClass（）
????????{
????????????InitializeComponent（）;
????????}
????????private?void?checkClass_Load（object?sender?EventArgs?e）
????????{
????????????string?strSql?=?“select?*?from?班級信息“;
????????????dt1?=?link.relateData（strSql）;
????????????comboBox1.DataSource?=?dt1;
????????????comboBox1.DisplayMember?=?“班級名稱“;
????????????comboBox1.ValueMember?=?“班級編號“;
????????????
????????????strSql?=?“select?*?from?課程信息“;
????????????dt2?=?link.relateData（strSql）;
????????????comboBox2.DataSource?=?dt2;
????????????comboBox2.DisplayMember?=?“課程名稱“;
????????????comboBox2.ValueMember?=?“課程名稱“;
????????????update?=DateTime.Now.ToString（）;?
????????}
????????private?void?comboBox1_SelectedIndexChanged（object?sender?EventArgs?e）
????????{
???????????
????????????string?strSql?=?“select?*?from?學生信息?where?班級編號=‘“?+?comboBox1.SelectedValue.ToString（）+?“‘“;
????????????dt3?=?link.relateData（strSql）;
????????????totalNum?=?dt3.Rows.Count;
????????????this.Text?=?totalNum+““+comboBox1.Text;
????????????dataGridView1.DataSource?=?dt3;
????????????this.stuNum_tb.DataBindings.Clear（）;
????????????this.stuName_tb.DataBindings.Clear（）;
????????????this.stuNum_tb.DataBindings.Add（“Text“?dt3?“學號“）;
????????????this.stuName_tb.DataBindings.Add（“Text“?dt3?“姓名“）;
???????????//cmdOrder?=?（CurrencyManager）BindingContext[dt3];
????????????
????????}
????????private?void?button1_Click（object?sender?EventArgs?e）//提交
????????{
???????????int?status?=?1;
???????????if?（comboBox4.Text.Equals（“是“））
????????????????{
????????????????????status?=?1;
????????????????}
???????????if?（comboBox4.Text.Equals（“否“））
????????????????{
????????????????????status?=?0;
????????????????}
????????????if?（comboBox4.Text.Equals（“假“））
????????????????{
????????????????????status?=?3;
????????????????}
?????????????string?strSql?=?“select?課程信息.授課老師學生信息.聯系方式?from?課程信息?學生信息?where?課程名稱=‘“?+?comboBox2.Text?+?“‘“;
?????????????DataTable?strTabel?=?link.relateData（strSql）;
?????????????string?teacher?=?strTabel.Rows[0][0].ToString（）;
?????????????string?phone?=?strTabel.Rows[0][1].ToString（）;
?????????????string?strSql1?=?“select?count（*）?from?學生出勤?where?學號=@str1?and?提交日期=@str2“;
?????????????int?i?=?link.QuerNo（strSql1stuNum_tb.Text.Trim（）update）;
?????????????if?（i?>?0）
?????????????{
????????????????
????????????????MessageBox.Show（“已提交過“）;
?????????????}
?????????????else
?????????????{
????????????????
??????????????????strSql?=?“insert?into?學生出勤?values（‘“?+?stuNum_tb.Text.Trim（）?+?“‘‘“?+?stuName_tb.Text.Trim（）?+?“‘‘

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????1208??2008-06-03?07:54??學生考勤系統\學生考勤系統\學生考勤系統\Properties\AssemblyInfo.cs

?????文件???????3121??2008-06-04?21:05??學生考勤系統\學生考勤系統\學生考勤系統\Properties\Resources.Designer.cs

?????文件???????1697??2008-06-04?21:05??學生考勤系統\學生考勤系統\學生考勤系統\Properties\Settings.Designer.cs

?????文件???????6209??2008-06-03?08:08??學生考勤系統\學生考勤系統\學生考勤系統\Properties\Resources.resx

?????文件????????984??2008-06-04?08:04??學生考勤系統\學生考勤系統\學生考勤系統\Properties\Settings.settings

?????文件???????1612??2008-06-06?08:09??學生考勤系統\學生考勤系統\學生考勤系統\mainform.cs

?????文件??????10281??2008-06-06?10:46??學生考勤系統\學生考勤系統\學生考勤系統\taskinfo.cs

?????文件???????1100??2008-06-04?08:09??學生考勤系統\學生考勤系統\學生考勤系統\report.cs

?????文件???????3228??2008-06-04?08:48??學生考勤系統\學生考勤系統\學生考勤系統\query.cs

?????文件???????9106??2008-06-06?08:01??學生考勤系統\學生考勤系統\學生考勤系統\學生考勤系統.csproj

?????文件???????5632??2005-11-11?22:25??學生考勤系統\學生考勤系統\學生考勤系統\bin\Debug\學生考勤系統.vshost.exe

?????文件?????417792??2008-08-21?16:18??學生考勤系統\學生考勤系統\學生考勤系統\bin\Debug\學生考勤系統.exe

?????文件?????216576??2008-08-21?16:18??學生考勤系統\學生考勤系統\學生考勤系統\bin\Debug\學生考勤系統.pdb

?????文件????????405??2008-06-04?08:04??學生考勤系統\學生考勤系統\學生考勤系統\bin\Debug\學生考勤系統.exe.config

?????文件????????405??2008-06-04?08:04??學生考勤系統\學生考勤系統\學生考勤系統\bin\Debug\學生考勤系統.vshost.exe.config

?????文件????1572864??2008-06-06?21:04??學生考勤系統\學生考勤系統\學生考勤系統\bin\Debug\database\kaoqing_Data.MDF

?????文件????1048576??2008-06-06?21:04??學生考勤系統\學生考勤系統\學生考勤系統\bin\Debug\database\kaoqing_Log.LDF

?????文件???????5120??2008-06-04?21:05??學生考勤系統\學生考勤系統\學生考勤系統\obj\Debug\TempPE\Properties.Resources.Designer.cs.dll

?????文件???????6656??2008-06-05?09:55??學生考勤系統\學生考勤系統\學生考勤系統\obj\Debug\TempPE\CrystalReport1.cs.dll

?????文件??????40960??2008-06-05?19:35??學生考勤系統\學生考勤系統\學生考勤系統\obj\Debug\TempPE\kaoqingDataSet.Designer.cs.dll

?????文件????????180??2008-08-21?16:18??學生考勤系統\學生考勤系統\學生考勤系統\obj\Debug\學生考勤系統.checkClass.resources

?????文件???????1566??2008-06-06?08:09??學生考勤系統\學生考勤系統\學生考勤系統\obj\Debug\學生考勤系統.csproj.GenerateResource.Cache

?????文件?????216576??2008-08-21?16:18??學生考勤系統\學生考勤系統\學生考勤系統\obj\Debug\學生考勤系統.pdb

?????文件?????253377??2008-08-21?16:18??學生考勤系統\學生考勤系統\學生考勤系統\obj\Debug\學生考勤系統.Properties.Resources.resources

?????文件???????5575??2008-08-21?16:18??學生考勤系統\學生考勤系統\學生考勤系統\obj\Debug\學生考勤系統.classinfo.resources

?????文件???????6404??2008-08-21?16:18??學生考勤系統\學生考勤系統\學生考勤系統\obj\Debug\學生考勤系統.taskinfo.resources

?????文件?????417792??2008-08-21?16:18??學生考勤系統\學生考勤系統\學生考勤系統\obj\Debug\學生考勤系統.exe

?????文件????????180??2008-08-21?16:18??學生考勤系統\學生考勤系統\學生考勤系統\obj\Debug\學生考勤系統.Login_frm.resources

?????文件????????180??2008-08-21?16:18??學生考勤系統\學生考勤系統\學生考勤系統\obj\Debug\學生考勤系統.checkTask.resources

?????文件???????6378??2008-06-05?06:56??學生考勤系統\學生考勤系統\學生考勤系統\obj\Debug\ResolveAssemblyReference.cache

............此處省略62個文件信息