OA系统

开发平台：
ASP/ASPX

考勤查看.aspx：源码内容
							﻿<%@ Page Language="C#" AutoEventWireup="true" CodeFile="考勤查看.aspx.cs" Inherits="web_Default2" %>
<!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>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:Panel ID="Panel1" runat="server" Height="517px" Style="vertical-align: middle;
            text-align: center" Width="778px">
            <asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" DataSourceID="SqlDataSource1"
                DataTextField="department_name" DataValueField="department_id" Height="33px"
                Style="left: 120px; position: absolute; top: 25px" Width="536px">
            </asp:DropDownList>
            <br />
            <asp:DropDownList ID="DropDownList2" runat="server" DataSourceID="SqlDataSource2"
                DataTextField="name" DataValueField="name" Height="53px" Style="left: 120px;
                position: absolute; top: 51px" Width="537px">
            </asp:DropDownList>
            <br />
            <br />
            <asp:Label ID="Label1" runat="server" Height="20px" Style="left: 120px; vertical-align: middle;
                position: absolute; top: 78px; text-align: center; border-right: 1px solid; border-top: 1px solid; border-left: 1px solid; border-bottom: 1px solid;" Text="起始日期" Width="106px" BorderColor="#804040"></asp:Label>
            &nbsp;&nbsp;
            <asp:ImageButton ID="ImageButton1" runat="server" ImageUrl="~/images/calbtn.gif"
                OnClick="ImageButton1_Click" Style="left: 346px; position: absolute; top: 80px" />
            <asp:ImageButton ID="ImageButton2" runat="server" ImageUrl="~/images/calbtn.gif"
                OnClick="ImageButton2_Click" Style="left: 624px; position: absolute; top: 83px" />
             <asp:Calendar ID="Calendar1" runat="server" OnSelectionChanged="Calendar1_SelectionChanged" style="left: 206px; position: absolute; top: 102px" Visible="False">
            </asp:Calendar>
            <asp:TextBox ID="TextBox2" runat="server" Height="21px" Style="left: 513px; position: absolute;
                top: 80px" Width="101px"></asp:TextBox>
            &nbsp;&nbsp;
            <asp:Label ID="Label3" runat="server" Height="19px" Style="left: 399px;
                position: absolute; top: 82px; text-align: center; border-right: 1px solid; border-top: 1px solid; border-left: 1px solid; border-bottom: 1px solid;" Text="截止日期" Width="106px"></asp:Label>
            &nbsp;&nbsp;&nbsp;&nbsp;
             <asp:Calendar ID="Calendar2" runat="server" OnSelectionChanged="Calendar2_SelectionChanged" style="left: 503px; position: absolute; top: 107px" Visible="False">
            </asp:Calendar>
            <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Style="left: 356px;
                position: absolute; top: 115px" Text="确定" Width="44px" />
            &nbsp; &nbsp;&nbsp;&nbsp;&nbsp; &nbsp;<br />
            <br />
            <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:oa1ConnectionString %>"
                SelectCommand="SELECT [department_name], [department_id] FROM [OA_FENGONGSI]"></asp:SqlDataSource>
            <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:oa1ConnectionString %>"
                SelectCommand="SELECT [last_id], [name] FROM [OA_DEPARTMENT] WHERE ([last_id] = @last_id)">
                <SelectParameters>
                    <asp:ControlParameter ControlID="DropDownList1" Name="last_id" PropertyName="SelectedValue"
                        Type="Int32" />
                </SelectParameters>
            </asp:SqlDataSource>
            <br />
            <asp:Table ID="Table1" runat="server" Height="322px" Style="left: 71px; position: absolute;
                top: 167px" Visible="False" Width="662px">
            </asp:Table>
            <br />
            <br />
            <asp:TextBox ID="TextBox1" runat="server" Height="21px" Style="left: 236px; position: absolute;
                top: 78px" Width="101px"></asp:TextBox>
            &nbsp;&nbsp;<br />
            <br />
            <br />
            &nbsp; &nbsp;
            &nbsp; &nbsp;&nbsp; &nbsp;&nbsp;
        </asp:Panel>
        &nbsp;&nbsp;</div>
    </form>
</body>
</html>

						