If Thing.SelectedItem.Value <> "-1" Then
Select Case Thing.SelectedItem.Text
Case "迟到"
sql = "select ClassName as 班级,Stu_name as 姓名, Times as 迟到 from KQRecord ,Class,Profession,Department ,Affair where KQRecord.ClassID=Class.ClassID and Class.ProfessionID=Profession.ProfessionID and Profession.DepartmentID=Department.DepartmentID and Affair.AffairID=KQRecord.AffairID and Riqi > '" & Sdate.Value & "' and Riqi< '" & Edate.Value & "' and AffairName='迟到'"
Case "早退"
sql = "select ClassName as 班级,Stu_name as 姓名, Times as 早退 from KQRecord ,Class,Profession,Department ,Affair where KQRecord.ClassID=Class.ClassID and Class.ProfessionID=Profession.ProfessionID and Profession.DepartmentID=Department.DepartmentID and Affair.AffairID=KQRecord.AffairID and Riqi > '" & Sdate.Value & "' and Riqi< '" & Edate.Value & "'and AffairName='早退'"
End Select
End If 这样我查询出班级、姓名、早退或者迟到的次数。
If Thing.SelectedItem.Value = "-1" Then
sql = ""
End If 这里我想要查询出班级、姓名、迟到(次数)、早退(次数)、旷课(次数)这条语句怎么写啊`,还是要让 GridView动态的产生几列呢?如果要动态产生几列又是怎么弄啊`?(数据库中Affair表包括AffairID字段、AffairName字段,KQRecord表中也有AffairID字段)谢谢了``
Select Case Thing.SelectedItem.Text
Case "迟到"
sql = "select ClassName as 班级,Stu_name as 姓名, Times as 迟到 from KQRecord ,Class,Profession,Department ,Affair where KQRecord.ClassID=Class.ClassID and Class.ProfessionID=Profession.ProfessionID and Profession.DepartmentID=Department.DepartmentID and Affair.AffairID=KQRecord.AffairID and Riqi > '" & Sdate.Value & "' and Riqi< '" & Edate.Value & "' and AffairName='迟到'"
Case "早退"
sql = "select ClassName as 班级,Stu_name as 姓名, Times as 早退 from KQRecord ,Class,Profession,Department ,Affair where KQRecord.ClassID=Class.ClassID and Class.ProfessionID=Profession.ProfessionID and Profession.DepartmentID=Department.DepartmentID and Affair.AffairID=KQRecord.AffairID and Riqi > '" & Sdate.Value & "' and Riqi< '" & Edate.Value & "'and AffairName='早退'"
End Select
End If 这样我查询出班级、姓名、早退或者迟到的次数。
If Thing.SelectedItem.Value = "-1" Then
sql = ""
End If 这里我想要查询出班级、姓名、迟到(次数)、早退(次数)、旷课(次数)这条语句怎么写啊`,还是要让 GridView动态的产生几列呢?如果要动态产生几列又是怎么弄啊`?(数据库中Affair表包括AffairID字段、AffairName字段,KQRecord表中也有AffairID字段)谢谢了``
这里我想要查询出班级、姓名、迟到(次数)、早退(次数)、旷课(次数)
----------------------------------------------------------------------
查询语句还能怎么写啊!
If Thing.SelectedItem.Value = "-1" Then
sql = ""
End If (下拉框没选中任何考勤项目时,就将班级、姓名、迟到(次数)、早退(次数)、旷课(次数)这些字段给查询出来啊)
即在GridView这样显示:
班级 姓名 迟到 早退 旷课
程序0501 aa 2 0 1
这个语句怎么写 sql = "" 。(Affair表中的AffairName字段值有迟到、早退、旷课、请假)
等待流星!!!!!!!!!!!!!
STU_NAME AS ÐÕÃû,
SUM(³Ùµ½) AS ³Ùµ½£¨´ÎÊý£©,
SUM(ÔçÍË) AS ÔçÍË£¨´ÎÊý£©,
SUM(¿õ¿Î) AS ¿õ¿Î£¨´ÎÊý£©
FROM KQRECORD, CLASS, PROFESSION, DEPARTMENT, AFFAIR
WHERE KQRECORD.CLASSID = CLASS.CLASSID
AND CLASS.PROFESSIONID = PROFESSION.PROFESSIONID
AND PROFESSION.DEPARTMENTID = DEPARTMENT.DEPARTMENTID
AND AFFAIR.AFFAIRID = KQRECORD.AFFAIRID
AND RIQI > '" & Sdate.Value & "'
AND RIQI < '" & Edate.Value & "'
GROUP BY CLASSNAME, STU_NAME
STU_NAME AS 姓名,
SUM(迟到) AS 迟到(次数),
SUM(早退) AS 早退(次数),
SUM(旷课) AS 旷课(次数)
FROM KQRECORD, CLASS, PROFESSION, DEPARTMENT, AFFAIR
WHERE KQRECORD.CLASSID = CLASS.CLASSID
AND CLASS.PROFESSIONID = PROFESSION.PROFESSIONID
AND PROFESSION.DEPARTMENTID = DEPARTMENT.DEPARTMENTID
AND AFFAIR.AFFAIRID = KQRECORD.AFFAIRID
AND RIQI > '" & Sdate.Value & "'
AND RIQI < '" & Edate.Value & "'
GROUP BY CLASSNAME, STU_NAME