//查询按钮
private void button1_Click(object sender, EventArgs e)
{
try
{
if (FormMain.Power == "学生")
{
DBOperate operate = new DBOperate();
string name = operate.GetName();
string str1 =//创建查询字符串
"select A.stu_class as 班级,A.stu_id as 学号,A.stu_name as 姓名,B.Cour_Name as 课程名,B.Score as 成绩 from Student as A JOIN SC_result AS B ON A.stu_id=B.Stu_Id join Coures as C ON C.Cour_Id=B.Cour_Id where A.stu_name='" + name + "' and C.Cour_Semester='" + cbbSemester.SelectedItem.ToString() + "' and B.Cour_Name='" + cbbCourse.SelectedItem.ToString() + "'";
operate.BindDataGridView(dataGridView1, str1);
}
else
{
if (cbbCourse.Text == "")
{
string str =//创建查询字符串
"select A.stu_class as 班级,A.stu_id as 学号,A.stu_name as 姓名,B.Cour_Name as 课程名,B.Score as 成绩 from Student as A JOIN SC_result AS B ON A.stu_id=B.Stu_Id join Coures as C ON C.Cour_Id=B.Cour_Id where A.stu_name='" + cbbstudent.SelectedItem.ToString() + "' and C.Cour_Semester='" + cbbSemester.SelectedItem.ToString() + "' and A.Stu_class='" + cbbClass.SelectedItem.ToString() + "'";
operate.BindDataGridView(dataGridView1, str);
}
else
{
string str = //创建查询字符串
"select A.stu_class as 班级,A.stu_id as 学号,A.stu_name as 姓名,B.Cour_Name as 课程名,B.Score as 成绩 from Student as A JOIN SC_result AS B ON A.stu_id=B.Stu_Id join Coures as C ON C.Cour_Id=B.Cour_Id where B.Cour_Name='" + cbbCourse.SelectedItem.ToString() + "' and C.Cour_Semester='" + cbbSemester.SelectedItem.ToString() + "' and A.Stu_class='" + cbbClass.SelectedItem.ToString() + "'";
operate.BindDataGridView(dataGridView1, str); //将查询信息绑定到DATAGRIDVIEW控件
}
}
}
catch
{
MessageBox.Show("你还有未选择的项", "错误", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void cbbClass_SelectedIndexChanged(object sender, EventArgs e)
{
if (cbbSemester.SelectedIndex != -1 && cbbClass.SelectedIndex != -1)
{
string str1 = "select distinct Student.stu_class as 班级,Coures.Cour_Id as 课程编号,Coures.Cour_Name as 课程名,Coures.Cour_Semester as 学期 from SC_result join Student on SC_result.Stu_Id=Student.stu_id join Coures on Coures.Cour_Id=SC_result.Cour_Id where Student.stu_class='" + cbbClass.SelectedItem.ToString() + "'and Coures.Cour_Semester='" + cbbSemester.SelectedItem.ToString() + "'";
operate.BindDataGridView(dataGridView1, str1); //将查询信息绑定到DATAGRIDVIEW控件
dataGridView1.Columns[0].Width = 80; //定义数据列宽度
dataGridView1.Columns[1].Width = 80; //定义数据列宽度
}
}
private void FormManageLogin_Load(object sender, EventArgs e)
{
string str;
if (FormMain.Power == "管理员")
{
str = "select UserName as '用户名',UserPwd as '用户密码',UserPower as '用户权限',LoginTime as '登录时间' from wang_User order by LoginTime desc";
}
else
{
str = "select UserName as '用户名',UserPwd as '用户密码',UserPower as '用户权限',LoginTime as '登录时间' from wang_User where UserName='******'";
delete.Enabled = false;
}
operate.BindDataGridView(dataGridView1, str);
dataGridView1.Columns[0].Width = 100;
dataGridView1.Columns[1].Width = 145;
dataGridView1.Columns[2].Width = 100;
dataGridView1.Columns[3].Width = 120;
}
//保存按钮事件
private void FormCheckuser_Z_score_Load(object sender, EventArgs e)
{
N = "0";
string str1 = //创建查询字符串
"select A.stu_class as 班级,A.stu_id as 学号,A.stu_name as 姓名,B.COUR_ID AS 课程号,B.Cour_Name as 课程名,B.Score as 成绩 from Student as A JOIN SC_result AS B ON A.stu_id=B.Stu_Id join Coures as C ON C.Cour_Id=B.Cour_Id where A.Stu_id='" + XTID + "' and B.Score='" + "暂无成绩" + "'";
operate.BindDataGridView(dataGridView1, str1); //将查询信息绑定到DATAGRIDVIEW控件
dataGridView1.Columns[0].Width = 80; //定义数据列宽度
dataGridView1.Columns[1].Width = 100; //定义数据列宽度
adapter = new SqlDataAdapter("select A.stu_class as 班级,A.stu_id as 学号,A.stu_name as 姓名,B.COUR_ID AS 课程号,B.Cour_Name as 课程名,B.Score as 成绩 from Student as A JOIN SC_result AS B ON A.stu_id=B.Stu_Id join Coures as C ON C.Cour_Id=B.Cour_Id where A.Stu_id='" + XTID + "' and B.Score='" + "暂无成绩" + "'", conn);
dSet = new DataSet();
adapter.Fill(dSet);
dataGridView1.DataSource = dSet.Tables[0];
}
private void FormCheckuser_Load(object sender, EventArgs e)
{
string str =//创建查询字符串
"select Tea_id as '教师编号', Tea_name as '教师姓名',Tea_Dept '部门',Tea_Birthday as '生日',Tea_Nation as '民族',Tea_Marriage as '婚否',Tea_MCCP as '政治面貌',Tea_Phone as '电话',Tea_Accession as '就职日期',Tea_Pay as '薪资' from Teacher";
operate.BindDataGridView(dataGridView1, str); //将查询信息绑定到DATAGRIDVIEW控件
dataGridView1.Columns[0].Width = 60; //定义数据列宽度
dataGridView1.Columns[1].Width = 100; //定义数据列宽度
treeView1.Nodes.Add("所有学生"); //添加根节点
TreeNode tn = treeView1.Nodes.Add("所有教师"); //添加根节点
SqlConnection conn = DBConnection.MyConnection(); //创建数据库连接对象
conn.Open();
SqlCommand cmd = new SqlCommand("select distinct tea_dept from Teacher", conn); //创建命令对象
SqlDataReader sdr = cmd.ExecuteReader(); //创建数据阅读器
while (sdr.Read())
{
tn.Nodes.Add(sdr[0].ToString()); //添加节点
}
sdr.Close(); //关闭数据读取器
conn.Close(); //关闭数据连接
treeView1.ExpandAll(); //展开所有节点
string sql = "select DISTINCT count(tea_dept) from Teacher"; //定义sql字符串
Text = "当前教师编号：" + dataGridView1.SelectedCells[0].Value.ToString();
string TeaId = dataGridView1.SelectedCells[0].Value.ToString(); //得到编号（学生或者教师编号）
operate.TeaGet_Image(TeaId, pictureBox1); //显示图片信息
treeView1.SelectedNode = treeView1.Nodes[0];
if (FormMain.Power == "教师")
{
delete.Enabled = false;
ADD.Enabled = false;
treeView1.CollapseAll();
}
}
