📄 statinfo.aspx.svn-base
字号:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="StatInfo.aspx.cs" Inherits="TestManage_StatInfo" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>统计成绩</title>
<script type="text/JavaScript">
function showcalendar(obj)
{
dv=window.showModalDialog("./calendar.htm","44","center:1;help:no;status:no;dialogHeight:246px;dialogWidth:216px;scroll:no")
if (dv)
{
if (dv=="null") obj.value='';
else obj.value=dv;
}
var s = obj.value
var n = new Date(s.replace(/\-/g, "/"));
var Y = n.getFullYear();
var M = (n.getMonth() + 1);
var D = n.getDate();
var d=new Date(Y,M-1,D);
var t=new Date();
var msec=d.getTime()-t.getTime();
msec=Math.floor(msec/1000/3600/24)+1;
}
</script>
<script type="text/JavaScript">
<!--
function MM_findObj(n, d)
{ //v4.01
var p,i,x;
if(!d) d=document;
if((p=n.indexOf("?"))>0&&parent.frames.length)
{
d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);
}
if(!(x=d[n])&&d.all) x=d.all[n];
for (i=0;!x&&i<d.forms.length;i++)
{
x=d.forms[i][n];
}
for(i=0;!x&&d.layers&&i<d.layers.length;i++)
{
x=MM_findObj(n,d.layers[i].document);
}
if(!x && d.getElementById) x=d.getElementById(n); return x;
}
function YY_checkform()
{ //v4.65
//copyright (c)1998,2002 Yaromat.com
var args = YY_checkform.arguments;
var myDot=true; var myV='';
var myErr='';
var addErr=false;
var myReq;
for (var i=1; i<args.length;i=i+4)
{
if (args[i+1].charAt(0)=='#')
{
myReq=true; args[i+1]=args[i+1].substring(1);
}
else
{
myReq=false;
}
var myObj = MM_findObj(args[i].replace(/\[\d+\]/ig,""));
myV=myObj.value;
if (myObj.type=='text'||myObj.type=='password'||myObj.type=='hidden')
{
if (myReq&&myObj.value.length==0){addErr=true}
if ((myV.length>0)&&(args[i+2]==1))
{ //fromto
var myMa=args[i+1].split('_');
if(isNaN(parseInt(myV))||myV<myMa[0]/1||myV > myMa[1]/1){addErr=true}
}
else if ((myV.length>0)&&(args[i+2]==2))
{
var rx=new RegExp("^[\\w\.=-]+@[\\w\\.-]+\\.[a-z]{2,4}$");
if(!rx.test(myV))addErr=true;
}
else if ((myV.length>0)&&(args[i+2]==3)){ // date
var myMa=args[i+1].split("#");
var myAt=myV.match(myMa[0]);
if(myAt)
{
var myD=(myAt[myMa[1]])?myAt[myMa[1]]:1;
var myM=myAt[myMa[2]]-1;
var myY=myAt[myMa[3]];
var myDate=new Date(myY,myM,myD);
if(myDate.getFullYear()!=myY||myDate.getDate()!=myD||myDate.getMonth()!=myM){addErr=true};
}
else{addErr=true}
}
else if ((myV.length>0)&&(args[i+2]==4)){ // time
var myMa=args[i+1].split("#");
var myAt=myV.match(myMa[0]);
if(!myAt){addErr=true}
}
else if (myV.length>0&&args[i+2]==5){ // check this 2
var myObj1 = MM_findObj(args[i+1].replace(/\[\d+\]/ig,""));
if(myObj1.length)myObj1=myObj1[args[i+1].replace(/(.*\[)|(\].*)/ig,"")];
if(!myObj1.checked){addErr=true}
}
else if (myV.length>0&&args[i+2]==6){ // the same
var myObj1 = MM_findObj(args[i+1]);
if(myV!=myObj1.value){addErr=true}
}
}
else if (!myObj.type&&myObj.length>0&&myObj[0].type=='radio'){
var myTest = args[i].match(/(.*)\[(\d+)\].*/i);
var myObj1=(myObj.length>1)?myObj[myTest[2]]:myObj;
if (args[i+2]==1&&myObj1&&myObj1.checked&&MM_findObj(args[i+1]).value.length/1==0){addErr=true}
if (args[i+2]==2){
var myDot=false;
for(var j=0;j<myObj.length;j++){myDot=myDot||myObj[j].checked}
if(!myDot){myErr+='* ' +args[i+3]+'\n'}
}
}
else if (myObj.type=='checkbox')
{
if(args[i+2]==1&&myObj.checked==false){addErr=true}
if(args[i+2]==2&&myObj.checked&&MM_findObj(args[i+1]).value.length/1==0){addErr=true}
}
else if (myObj.type=='select-one'||myObj.type=='select-multiple')
{
if(args[i+2]==1&&myObj.selectedIndex/1==0){addErr=true}
}
else if (myObj.type=='textarea')
{
if(myV.length<args[i+1]){addErr=true}
}
if (addErr){myErr+='* '+args[i+3]+'\n'; addErr=false}
}
if (myErr!='')
{
alert('The required information is incomplete or contains errors:\t\t\t\t\t\n\n'+myErr)
}
document.MM_returnValue = (myErr=='');
}
//-->
</script>
<style type="text/css">
<!--
.STYLE3 {color: #FF0000}
-->
</style>
</head>
<body>
<form id="form1" runat="server">
<div>
<table border="1" align="center" cellpadding="1" cellspacing="1" bordercolor="#FFFFFF" bgcolor="#666666" frame="border" class="style2" style="width: 800px; height: 1px;" >
<tr>
<td align="right" bgcolor="#ffffff" colspan="1" rowspan="2" style="width: 194px;
height: 24px">
试卷编号：</td>
<td align="left" bgcolor="#ffffff" colspan="1" rowspan="2" style="width: 81px; height: 24px">
<asp:DropDownList ID="DrpTestNo" runat="server" DataSourceID="SqlDataSource_TestInfo" DataTextField="TESTNO" DataValueField="TESTNO" AppendDataBoundItems="True">
<asp:ListItem Selected="True">---请选择---</asp:ListItem>
</asp:DropDownList>
</td>
<td align="right" bgcolor="#ffffff" colspan="1" rowspan="2" style="width: 85px; height: 24px">
班级：</td>
<td align="left" bgcolor="#ffffff" colspan="1" rowspan="2" style="width: 77px; height: 24px">
<asp:DropDownList ID="DrpSClass" runat="server" AppendDataBoundItems="True" DataSourceID="SqlDataSource_Class" DataTextField="SCLASS" DataValueField="SCLASS">
<asp:ListItem>---请选择---</asp:ListItem>
</asp:DropDownList></td>
<td align="right" bgcolor="#ffffff" colspan="1" rowspan="2" style="width: 98px; height: 24px">
分数范围： </td>
<td colspan="3" align="right" bgcolor="#FFFFFF" style="height: 24px; width: 168px;" rowspan="2">
><asp:TextBox ID="TxtMinGrade" runat="server" Width="60px" MaxLength="3"></asp:TextBox><
<asp:TextBox ID="TxtMaxGrade" runat="server" Width="62px" MaxLength="3"></asp:TextBox>
</td>
</tr>
<tr>
</tr>
<tr>
<td align="right" bgcolor="#ffffff" colspan="1" style="width: 194px; height: 18px">
难度系数：</td>
<td align="left" bgcolor="#ffffff" colspan="1" style="width: 81px; height: 18px">
<asp:DropDownList ID="DrpSSGrade" runat="server" AppendDataBoundItems="True">
<asp:ListItem>---请选择---</asp:ListItem>
<asp:ListItem>1</asp:ListItem>
<asp:ListItem>2</asp:ListItem>
<asp:ListItem>3</asp:ListItem>
<asp:ListItem>4</asp:ListItem>
<asp:ListItem Value="5"></asp:ListItem>
</asp:DropDownList></td>
<td align="right" bgcolor="#ffffff" colspan="2" style="height: 18px">
考试时间范围：</td>
<td align="center" bgcolor="#ffffff" colspan="4" style="height: 18px">
><asp:TextBox ID="TxtMinTestTime" runat="server" onclick="showcalendar(this,this)" Height="16px"
Width="117px"></asp:TextBox><<asp:TextBox ID="TxtMaxTestTime" runat="server" onclick="showcalendar(this,this)" Width="116px"></asp:TextBox> </td>
</tr>
<tr>
<td align="center" bgcolor="#ffffff" colspan="8" style="height: 22px">
<asp:Button ID="BtnQuery" runat="server" Text="查询统计" OnClick="BtnQuery_Click" />
<asp:GridView ID="GridView_StatInfo" runat="server" Height="1px" Width="800px" Caption="查询到以下数据" EmptyDataText="没有找到所要的信息！" AutoGenerateColumns="False">
<Columns>
<asp:BoundField DataField="SNO" HeaderText="学号" ReadOnly="True" SortExpression="SNO">
<ItemStyle HorizontalAlign="Justify" />
</asp:BoundField>
<asp:BoundField DataField="SNAME" HeaderText="姓名" ReadOnly="True" SortExpression="SNAME" />
<asp:BoundField DataField="TESTNO" HeaderText="试卷号" ReadOnly="True" SortExpression="TESTNO" />
<asp:BoundField DataField="SCLASS" HeaderText="班级" SortExpression="SCLASS" />
<asp:BoundField DataField="GRADE" HeaderText="分数" SortExpression="GRADE" />
<asp:BoundField DataField="TESTSTYLE" HeaderText="试卷类型" SortExpression="TESTSTYLE" />
<asp:BoundField DataField="PERTESTSYNAX" HeaderText="语法%" SortExpression="PERTESTSYNAX" />
<asp:BoundField DataField="PERTESTREAD" HeaderText="阅读%" SortExpression="PERTESTREAD" />
<asp:BoundField DataField="PERTESTFULL" HeaderText="完型%" SortExpression="PERTESTFULL" />
<asp:BoundField DataField="SETTEXTTIME" HeaderText="考试用时" SortExpression="SETTEXTTIME" />
<asp:BoundField DataField="DOTEXTTIME" HeaderText="考试时间" ReadOnly="True" SortExpression="DOTEXTTIME" />
<asp:BoundField DataField="FULLMARK" HeaderText="满分值" SortExpression="FULLMARK" />
<asp:BoundField DataField="AVERAGEGRADE" HeaderText="难度" SortExpression="难度" />
</Columns>
<RowStyle HorizontalAlign="Justify" />
</asp:GridView>
</td>
</tr>
<tr>
<td align="right" bgcolor="#ffffff" colspan="5" style="height: 1px">
<asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>
</td>
<td align="right" bgcolor="#ffffff" colspan="3" style="height: 1px; width: 168px;">
<asp:Button ID="BtnReturn" runat="server" Text="返回" OnClick="BtnReturn_Click" /></td>
</tr>
</table>
</div>
<asp:SqlDataSource ID="SqlDataSource_TestInfo" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT DISTINCT [TESTNO] FROM [V_TESTINFO] WHERE ([TNO] = @TNO) ORDER BY [TESTNO]">
<SelectParameters>
<asp:SessionParameter Name="TNO" SessionField="USERID" Type="String" />
</SelectParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource_Class" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT DISTINCT [SCLASS] FROM [V_STUDENT]"></asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource_Query" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT [PERTESTSYNAX], [PERTESTREAD], [PERTESTFULL], [GRADE], [SCLASS], [SNAME], [SNO], [TESTNO], [SETTEXTTIME], [DOTEXTTIME], [FULLMARK], [AVERAGEGRADE], [TESTSTYLE] FROM [V_TESTSTUENTGRADE] WHERE ([TESTNO] = @TESTNO) ORDER BY [TESTNO], [SNO]">
<SelectParameters>
<asp:ControlParameter ControlID="DrpTestNo" Name="TESTNO" PropertyName="SelectedValue"
Type="String" />
</SelectParameters>
</asp:SqlDataSource>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -