Dim kgtcj,zgtcj As Integer '声明记录客观题和主观题成绩变量 Dim cjdr As DataRow = DataTables("成绩").Find("学号 = '" & e.DataRow("学号") & "' And 姓名 = '" & e.DataRow("姓名") & "'") If cjdr IsNot Nothing For i As Integer = 1 To 3 Dim fkgdr As DataRow = DataTables("客观题答案").find("客观题" & i & " = '" & e.DataRow("客观题" & i) & "' And 试卷号 = '" & DataTables("卷1答").name.Chars(1) & "'") If fkgdr IsNot Nothing Then kgtcj + = 1 End If Next For i As Integer = 1 To 7 If e.DataRow("主观题" & i ) = "t" Then zgtcj + = 1 End If Next cjdr("卷1") = kgtcj + zgtcj '给成绩表格相关试卷赋分代码 End If
|