reports.aspx

数据库学习的绝好例子简单的数据库经典入门

<%@ Page Language="VB" MasterPageFile="~/MasterPage.master" AutoEventWireup="false" CodeFile="Reports.aspx.vb" Inherits="Reports" title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
 <script language=javascript>
      function TimeSheetReport(ReportType)
      {
         window.open("TimeSheetReport.aspx?Report=" + ReportType + 
            "&ManagerID=" + "<%=Request.QueryString("UserID")%>" + 
            "&WeekEndingDate=" + 
            escape(document.all.ctl00$ContentPlaceHolder1$cboWeekEndingDate.options[
            document.all.ctl00$ContentPlaceHolder1$cboWeekEndingDate.options.selectedIndex].value),
            "TimeSheetReport",
            "width=800,height=600,scrollbars=yes,resizable=yes,toolbar=yes");
      }
</script>
<table border="0" cellpadding="1" cellspacing="2">
    <tr>
        <td>Week Ending Date</td>
        <td colspan="4">
            <asp:DropDownList ID="cboWeekEndingDate" runat="server" CssClass="General">
            </asp:DropDownList></td>
    </tr>
    <tr>
        <td>
            <input id="Button1" class="FlatButton" type="button" value="Timesheets Due" onclick="JavaScript:TimeSheetReport('TimesheetsDue');"/></td>
        <td>
            <input id="Button2" class="FlatButton" type="button" value="Timesheets Submitted" onclick="JavaScript:TimeSheetReport('TimesheetsSubmitted');"/></td>
        <td>
            <input id="Button3" class="FlatButton" type="button" value="Timesheets MTD" onclick="JavaScript:TimeSheetReport('TimesheetsMTD');"/></td>
        <td>
            <input id="Button4" class="FlatButton" type="button" value="Timesheets QTD" onclick="JavaScript:TimeSheetReport('TimesheetsQTD');"/></td>
        <td>
            <input id="Button5" class="FlatButton" type="button" value="Timesheets YTD" onclick="JavaScript:TimeSheetReport('TimesheetsYTD');"/></td>
    </tr>
</table>
</asp:Content>