studentattend.aspx

asp.net 2.0的教务管理软件源码

<%@ Page Language="C#" MasterPageFile="~/style/MasterPage.master" AutoEventWireup="true"
    CodeFile="StudentAttend.aspx.cs" Inherits="Personal_StudentAttend" Title="学生考勤管理 - 杰邦教学管理系统" %>
<%@ Register TagPrefix="uc1" TagName="ClassCourse" Src="~/uctl/ClassCourse.ascx" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="Server">
<script language="Javascript" type="text/javascript">
var turnon = false;
function turnDatePicker()
{
    turnon = !turnon;
    if (turnon)
        document.getElementById("divDatePicker").style.visibility = "visible";
     else
         document.getElementById("divDatePicker").style.visibility = "hidden";
     return false; 
}

function opendialog(i,j,txtDate, txtTime)
{
    var d = document.getElementById(txtDate).value;
    var t = document.getElementById(txtTime).value;
    var urls = "StudentAttendIn.aspx?at_ID="+i+"&sc_ID="+j+"&d="+d+"&t="+t;
    if (typeof(w) == "undefined" || w.closed)
    {

        w = window.open(urls, "考勤记录明细", "scroll=0,resizable=0,width=450,height=180,z-look=yes");
    }
    else
    {
        w.location = urls;
    }
}

var typeNameArr = ["", "正点","迟到","早退","病假","事假","旷课"];

var AttendBox= function(tablecell, at_ID, sc_ID, at_Type, rowindex)
{
    this.Tp = parseInt(at_Type);
    this.oldTp = this.Tp;
    this.cell = tablecell;
    this.atID = at_ID;
    this.scID = sc_ID;
    this.click = function(){
    this.Tp++;
    if (this.Tp > 6) this.Tp=0;
    this.cell.className = "att"+this.Tp;
    this.cell.innerHTML = typeNameArr[this.Tp];
    }
   this.changed = function() { return(this.oldTp != this.Tp) ;}
   
   if(rowindex > typeArrlength) typeArrlength = rowindex;
}
var typeArr = new Array();
var typeArrlength = 0;
function saveChanged() 
{
   var t = new Array();
   j = 0;
    for (i = 0; i <= typeArrlength; i++)
    {
        if (typeArr[i] && typeArr[i].changed())
        {
             t[j++] = typeArr[i].atID + "|"+typeArr[i].scID+"|"+typeArr[i].Tp;
        }
    }
    if (j > 0)
    { 
        document.getElementById("ChangedInfo").value = t.join(",");
        return true;
    }
     else
     {
        document.getElementById("ChangedInfo").value = "";
        return false;
     }
}
    </script>
 <uc1:ClassCourse ID="ClassCourse" runat="server"></uc1:ClassCourse>   
    <div style="z-index: 106; left: 206px; width: 77%; position: absolute; top: 1px">
        <table border="0" cellpadding="0" cellspacing="0" width="100%">
            <tr>
                <td class="titlebar" style="height: 24px">
                    学生考勤管理：<asp:Label ID="Path" runat="server"></asp:Label>
                    <asp:Label ID="lblCounter" runat="server"></asp:Label></td>
                <td style="width: 145px; height: 24px;" align="right" class="titlebar">
                    <asp:Button ID="btnPrevtDay" runat="server" Height="24px" OnClick="btnPrevtDay_Click"
                        Text="<" Width="20px" /><asp:TextBox ID="txtStartTime" runat="server" Width="80px"></asp:TextBox><asp:Button
                        ID="btnNextDay" runat="server" OnClick="btnNextDay_Click" Text=">" Width="20px" /></td>
                <td style="width: 188px; height: 24px;" align="right" class="titlebar">
                    时间:<asp:TextBox ID="txtTime" runat="server" Width="31px">90</asp:TextBox>分钟<asp:Button
                        ID="btnSave" runat="server" OnClick="btnSave_Click" Text="保存" Width="51px" /></td>
            </tr>
        </table>
    </div>
            
    <div id="divMain" style="left: 206px; top: 26px">
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="at_ID,sc_ID,at_Type,已上课时,实上课时,co_Time"
            DataSourceID="SqlDataSource3" Width="97%" CssClass="mainView" EmptyDataText="没有发现学生选修这门课．"
            OnRowDataBound="GridView1_RowDataBound" AllowSorting="True"
            PageSize="20">
            <Columns>
                <asp:BoundField DataField="sc_ID" HeaderText="ID" InsertVisible="False" SortExpression="pe_ID">
                    <ItemStyle HorizontalAlign="Center" />
                    <HeaderStyle Width="7%" HorizontalAlign="center" />
                </asp:BoundField>
                <asp:HyperLinkField DataNavigateUrlFields="pe_ID" DataNavigateUrlFormatString="StudentIn.aspx?ID={0}"
                    DataTextField="pe_Name" HeaderText="姓名" SortExpression="pe_Name">
                    <ItemStyle HorizontalAlign="Center" />
                    <HeaderStyle HorizontalAlign="Center" Width="10%" />
                </asp:HyperLinkField>
                <asp:BoundField DataField="部门名称" HeaderText="班级" SortExpression="部门名称">
                    <HeaderStyle  HorizontalAlign="Center" />
                      <HeaderStyle HorizontalAlign="Center" Width="14%" />
              </asp:BoundField>
                <asp:BoundField DataField="co_Name" HeaderText="课程" SortExpression="co_Name">
                    <HeaderStyle  />
                </asp:BoundField>
                <asp:TemplateField HeaderText="进度" SortExpression="已上课时">
                    <HeaderStyle Width="12%" />
                    <ItemStyle HorizontalAlign="Left" />
                </asp:TemplateField>
                <asp:TemplateField HeaderText="出勤率" SortExpression="实上课时">
                    <HeaderStyle Width="12%" />
                    <ItemStyle HorizontalAlign="Left" />
                </asp:TemplateField>
                <asp:BoundField DataField="at_Time" HeaderText="时间(分)" SortExpression="at_Time">
                    <HeaderStyle Width="8%" HorizontalAlign="Center" />
                    <ItemStyle HorizontalAlign="Center" />
                </asp:BoundField>
                <asp:TemplateField HeaderText="考勤" SortExpression="at_Type">
                    <HeaderStyle Width="10%" HorizontalAlign="Center" />
                    <ItemStyle HorizontalAlign="Center" />
                    <ItemTemplate>
                    </ItemTemplate>
                    <ItemStyle HorizontalAlign="Center" />
                </asp:TemplateField>
                <asp:HyperLinkField DataNavigateUrlFields="at_ID,sc_ID" DataNavigateUrlFormatString="~/Personal/StudentAttendIn.aspx?at_ID={0}&amp;sc_ID={1}"
                    HeaderText="操作" Text="修改">
                    <ItemStyle HorizontalAlign="Center" />
                    <HeaderStyle HorizontalAlign="Center" Width="8%" />
                </asp:HyperLinkField>
            </Columns>
        </asp:GridView>
        <div id="divDatePicker" style="z-index: 202; left: 49%; visibility: hidden; width: 174px;
            position: absolute; top: 2px; height: 156px">
            <asp:Calendar ID="Calendar1" runat="server" BackColor="White" BorderColor="#999999"
                DayNameFormat="Shortest" Font-Names="Verdana" Font-Size="8pt" ForeColor="Black"
                Height="158px" OnSelectionChanged="Calendar1_SelectionChanged" Width="171px">
                <SelectedDayStyle BackColor="#666666" Font-Bold="True" ForeColor="White" />
                <TodayDayStyle BackColor="#CCCCCC" ForeColor="Black" />
                <SelectorStyle BackColor="#CCCCCC" />
                <WeekendDayStyle BackColor="#FFFFCC" />
                <OtherMonthDayStyle ForeColor="Gray" />
                <NextPrevStyle VerticalAlign="Bottom" />
                <DayHeaderStyle BackColor="#CCCCCC" Font-Bold="True" Font-Size="7pt" />
                <TitleStyle BackColor="#999999" BorderColor="Black" Font-Bold="True" />
            </asp:Calendar>
        </div>
    </div>
<!--   
 <div id="divBottom" style="left: 206px; top: 476px">
        table style="width: 100%" cellpadding="0" cellspacing="0">
            <tr>
                <td style="width: 100px;">
                </td>
                <td align="right" style="height: 26px">
                    从<asp:TextBox ID="txtStartDate" runat="server" MaxLength="10" Width="80px" Height="14px"
                        ToolTip="请输入yyyy-mm-dd格式的起始日期."></asp:TextBox>
                    ～
                    <asp:TextBox ID="txtEndDate" runat="server" MaxLength="10" Width="80px" Height="14px"
                        ToolTip="请输入yyyy-mm-dd格式的结束日期."></asp:TextBox>
                </td>
                <td style="width: 70px;">
                    &nbsp;<asp:HyperLink ID="hypStat" runat="server" NavigateUrl="#" ToolTip="单击在新窗口统计出勤率.">统计出勤</asp:HyperLink></td>
            </tr>
        </table
    </div>
-->
    <script language="javascript" src="../style/common.js" type="text/javascript"></script>

    <script language="Javascript" type="text/javascript">
function openStatWindow(classID, txtStartDate, txtEndDate)
{
    d1 = document.getElementById(txtStartDate);
    d2 = document.getElementById(txtEndDate);
    if (!isDate(d1.value)) 
    {
        alert("非法的起始日期");
        d1.focus();
        return false;
    }
    if (!isDate(d2.value))
    {
        alert("非法的结束日期");
        d2.focus();
        return false;
    }
    w = window.open ("CalcAttend.aspx?de_ID="+classID+"&d1="+d1.value+"&d2="+d2.value);
}
    </script>

    <div style="z-index: 102; left: 228px; width: 100px; position: absolute; top: 388px;
        height: 6px">
        <asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:keke100ConnectionString %>"
            SelectCommand="p_CountAllAttend" SelectCommandType="StoredProcedure" OnSelected="SqlDataSource1_Selected">
            <SelectParameters>
                <asp:Parameter Name="de_ID" Type="Int32" />
                <asp:Parameter Name="co_ID" Type="Int32" />
                <asp:Parameter Name="ThisDate" Type="DateTime" />
                <asp:Parameter Name="EmployeeID" Type="Int32" />
            </SelectParameters>
        </asp:SqlDataSource>
        <input type="hidden" id="ChangedInfo" name="ChangedInfo" value="" />
    </div>
</asp:Content>