?? checkgrade.aspx
字號:
?<%@ Page Language="C#" AutoEventWireup="true" CodeFile="CheckGrade.aspx.cs" Inherits="Student_Check_Grade_CheckGrade" %>
<!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;
/*if (msec<0)
{
alert('不能過期！');
obj.value='';
}*/
}
</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 style="text-align: left">
<div>
<table align="center" bgcolor="#666666" border="1" bordercolor="#ffffff" cellpadding="1"
cellspacing="1" class="style2" frame="border" 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" AppendDataBoundItems="True" DataSourceID="SqlDataSource_TestInfo"
DataTextField="TESTNO" DataValueField="TESTNO" Width="90px">
<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" Width="79px">
<asp:ListItem>---請選擇---</asp:ListItem>
</asp:DropDownList></td>
<td align="right" bgcolor="#ffffff" colspan="1" rowspan="2" style="width: 98px; height: 24px">
分數范圍： </td>
<td align="right" bgcolor="#ffffff" colspan="3" rowspan="2" style="width: 168px;
height: 24px">
><asp:TextBox ID="TxtMinGrade" runat="server" MaxLength="3" Width="60px"></asp:TextBox><
<asp:TextBox ID="TxtMaxGrade" runat="server" MaxLength="3" Width="62px"></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" Height="16px" onclick="showcalendar(this,this)"
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" OnClick="BtnQuery_Click" Text="查詢統計" />
<asp:GridView ID="GridView_StatInfo" runat="server" AutoGenerateColumns="False" Caption="查詢到以下數據"
EmptyDataText="沒有找到所要的信息！" Height="1px" Width="800px">
<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">
</td>
<td align="right" bgcolor="#ffffff" colspan="3" style="width: 168px; height: 1px">
<asp:Button ID="BtnReturn" runat="server" OnClick="BtnReturn_Click" Text="返回" /></td>
</tr>
</table>
</div>
<asp:SqlDataSource ID="SqlDataSource_TestInfo" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT [TESTNO] FROM [TAB_GRADE] WHERE ([SNO] = @SNO)">
<SelectParameters>
<asp:SessionParameter DefaultValue="3103003343" Name="SNO" 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>
</div>
</form>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -