private void button1_Click_1(object sender, EventArgs e)
{
string sql = "select sno as '学号',sname as '姓名',ssex as '性别',sage as '年龄',sdept as '所属院系' from dbo.student";
//绑定到datagridview中显示
this.dataGridView1.DataSource = linkSql.QuerySQL(sql);
}
private void button1_Click_1(object sender, EventArgs e)
{
string sql = "select cno as '课程代号',cname as '课程名',chours as '课时数',ctype as '课程类型',credit as '学分' from dbo.class";
//绑定到datagridview中显示
this.dataGridView1.DataSource = linkSql.QuerySQL(sql);
}
private void button1_Click_1(object sender, EventArgs e)
{
string sql = "select dno as '院系编号',dname as '院系名',principal as '负责人' from dbo.depart";
//绑定到datagridview中显示
this.dataGridView1.DataSource = linkSql.QuerySQL(sql);
}
private void button1_Click_1(object sender, EventArgs e)
{
string sql = string.Format("select dbo.sc.sno as '学号',sname as '姓名',grade as '成绩' from dbo.student,dbo.sc where dbo.student.sno = dbo.sc.sno and cno = '{0}'", comboBox2.SelectedValue);
dt1 = linkSQL.QuerySQL(sql);
this.dataGridView1.DataSource = dt1;
}
private void GradeStatistics_Load(object sender, EventArgs e)
{
string sql = "select cno,cname from class";
dt = linkSql.QuerySQL(sql);
comboBox2.DataSource = dt; //将表绑定到控件
comboBox2.DisplayMember = "cname"; //定义要显示的内容为列名为x的内容
comboBox2.ValueMember = "cno"; //定义要映射的值为y的值
this.dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
}
private void button1_Click_1(object sender, EventArgs e)
{
string sql;
if (Program.isTeacher)
{
sql = "select tno as '工号',tname as '姓名',tsex as '性别',tdept as '所属院系',title as '职称',tage as '年龄',wage as '基本工资' from dbo.teacher";
}
else
{
sql = "select tname as '姓名',tsex as '性别',tdept as '所属院系',title as '职称' from dbo.teacher";
}
//绑定到datagridview中显示
this.dataGridView1.DataSource = linkSql.QuerySQL(sql);
}
private void WorkloadStatistics_Load(object sender, EventArgs e)
{
linkSql = new LinkSQL();
string sql = "select teacher.tno as '工号',tname as '姓名',t_workload as '工作量(课时)' from t_workload_view, teacher where t_workload_view.tno = teacher.tno";
this.dataGridView1.DataSource = linkSql.QuerySQL(sql);
this.dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
}
private void QueryGrade_Load(object sender, EventArgs e)
{
linkSql = new LinkSQL();
this.dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
string sql = string.Format("select sno as '学号',cno as '课程',grade as '成绩' from dbo.sc where sno = '{0}'", Program.loginId);
this.dataGridView1.DataSource = linkSql.QuerySQL(sql);
//学分统计
string sql2 = string.Format("select SUM(credit) from class where cno in (select cno from sc where sno = '{0}' and grade >= 60)", Program.loginId);
dt = linkSql.QuerySQL(sql2);
int loginCredit = 0;
try
{
loginCredit = Convert.ToInt32(dt.Rows[0][0].ToString());
}
catch
{
}
label1.Text = string.Format("您已选修学分为{0}学分，最高可选修120学分", loginCredit);
}
private void ElectiveCourse_Load(object sender, EventArgs e)
{
//获取全部课程
string sql1 = "select * from class";
dt1 = linkSql.QuerySQL(sql1);
//创建表头
this.listView1.Columns.Clear(); //先清除再添加保证数据的一致性
this.listView1.Columns.Add("", 60, HorizontalAlignment.Left);
this.listView1.Columns.Add("课程号", 60, HorizontalAlignment.Left);
this.listView1.Columns.Add("课程名称", 150, HorizontalAlignment.Left);
this.listView1.Columns.Add("学时", 60, HorizontalAlignment.Left);
this.listView1.Columns.Add("课程类型", 150, HorizontalAlignment.Left);
this.listView1.Columns.Add("学分", 60, HorizontalAlignment.Left);
//绑定数据
foreach (DataRow row in dt1.Rows)
{
ListViewItem item = new ListViewItem();
item.SubItems.Add(row["cno"].ToString());
item.SubItems.Add(row["cname"].ToString());
item.SubItems.Add(row["chours"].ToString());
item.SubItems.Add(row["ctype"].ToString());
item.SubItems.Add(row["credit"].ToString());
listView1.Items.Add(item);
}
//查询已选课程
string sql2;
sql2 = string.Format("select cno from sc where sno = '{0}'", Program.loginId);
dt2 = linkSql.QuerySQL(sql2);
//移除已选课程
for (int i = 0; i < listView1.Items.Count; i++)
{
for (int j = 0; j < dt2.Rows.Count; j++)
{
if (listView1.Items[i].SubItems[1].Text == dt2.Rows[j]["cno"].ToString())
{
listView1.Items.RemoveAt(i);
}
}
}
//学分统计
string sql3 = string.Format("select SUM(credit) from class where cno in (select cno from sc where sno = '{0}' and grade >= 60)", Program.loginId);
dt3 = linkSql.QuerySQL(sql3);
int loginCredit = 0;
try
{
loginCredit = Convert.ToInt32(dt3.Rows[0][0].ToString());
}
catch
{
}
label1.Text = string.Format("您已选修学分为{0}学分，最高可选修120学分", loginCredit);
//如果学分大于120，则不能选课
if (loginCredit > 120)
{
//将复选框关闭
listView1.CheckBoxes = false;
}
//选课人数统计
string sql4 = "select sc.cno,count(distinct sno) as snoCount,count(distinct tno) as tnoCount from sc,tc where sc.cno = tc.cno group by sc.cno";
dt4 = linkSql.QuerySQL(sql4);
foreach (DataRow dr in dt4.Rows)
{
//选课人数小于教师数*15，不开课
if (Convert.ToInt32(dr["snoCount"].ToString()) < 15 * Convert.ToInt32(dr["tnoCount"].ToString()))
{
Program.startClass = false;
}
//选课人数大于教师数*50，无法选课
else if (Convert.ToInt32(dr["snoCount"].ToString()) > 50 * Convert.ToInt32(dr["tnoCount"].ToString()))
{
cnoList.Add(dr["cno"].ToString()); //记录下课程号
}
//正常选课，开课
else
{
Program.startClass = true;
}
}
//移除选课人数已满的课程
for (int i = 0; i < listView1.Items.Count; i++)
{
for (int j = 0; j < cnoList.Count; j++)
{
if (listView1.Items[i].SubItems[1].Text == cnoList[j])
{
listView1.Items.RemoveAt(i);
}
}
}
}