OA系统

开发平台：
ASP/ASPX

my_list.aspx：源码内容
							﻿<%@ Page Language="C#" AutoEventWireup="true" CodeFile="my_list.aspx.cs" Inherits="web_equipment_my_list" %>
<!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>
    <center>
    <form id="form1" runat="server">
    <div>
       <asp:Label ID="Label1" runat="server" Text="我的申請單"></asp:Label>
            <asp:MultiView ID="MultiView1" runat="server" ActiveViewIndex="0" EnableTheming="False">
                <asp:View ID="View1" runat="server" EnableTheming="True">
                    <asp:GridView ID="GridView1" runat="server" BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" CellPadding="3" Style="position: relative" AllowPaging="True" AutoGenerateColumns="False" DataSourceID="SqlDataSource1" Width="661px" OnRowDataBound="GridView1_RowDataBound" >
                        <Columns>
                            <asp:BoundField DataField="form_id" HeaderText="申請單號" SortExpression="form_id" />
                            <asp:BoundField DataField="type" HeaderText="設備類型" SortExpression="type" />
                            <asp:BoundField DataField="apply_date" HeaderText="申請日期" SortExpression="apply_date" />
                            <asp:BoundField DataField="total_result" HeaderText="狀態" SortExpression="total_result" />
                        </Columns>
                        <PagerSettings PageButtonCount="5" />
                    </asp:GridView>
                    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:oa1ConnectionString %>"
                        SelectCommand="SELECT [form_id], [type], [apply_date], [total_result] FROM [oa_equipment_form] WHERE ([emp_id] = @emp_id) order by form_id desc"
                        >
                        <SelectParameters>
                            <asp:SessionParameter Name="emp_id" SessionField="user_id" Type="String" />
                        </SelectParameters>
                    </asp:SqlDataSource>
                </asp:View>
            </asp:MultiView>
        <asp:MultiView ID="MultiView2" runat="server">
            <asp:View ID="View2" runat="server">
                <br />
                <asp:Table ID="Table1" runat="server" GridLines="Both" Style="left: -236px; position: relative;
                    top: 0px" Width="201px">
                    <asp:TableRow runat="server">
                        <asp:TableCell runat="server" Width="2cm">申請單號</asp:TableCell>
                        <asp:TableCell runat="server" Width="2cm">
                            <asp:Label ID="Label2" runat="server" Text="Label"></asp:Label></asp:TableCell>
                    </asp:TableRow>
                </asp:Table>
                &nbsp;
                <asp:GridView ID="GridView2" runat="server" AllowPaging="True"
                    AutoGenerateColumns="False" DataSourceID="SqlDataSource2" PageSize="5" Width="677px">
                    <Columns>
                        <asp:BoundField DataField="equipment_name" HeaderText="用品名稱" SortExpression="equipment_name" />
                        <asp:BoundField DataField="standard" HeaderText="品牌/規格" SortExpression="standard" />
                        <asp:BoundField DataField="equipment_unit" HeaderText="單位" SortExpression="equipment_unit" />
                        <asp:BoundField DataField="equipment_num" HeaderText="數量" SortExpression="equipment_num" />
                        <asp:BoundField DataField="cause" HeaderText="需求原因" SortExpression="cause" />
                        <asp:BoundField DataField="apply_date" HeaderText="需求日期" SortExpression="apply_date" />
                        <asp:BoundField DataField="type" HeaderText="評估說明" SortExpression="type" />
                        <asp:BoundField DataField="charge" HeaderText="評估費用" SortExpression="charge" />
                        <asp:BoundField DataField="remark" HeaderText="備注" SortExpression="remark" />
                    </Columns>
                </asp:GridView>
                <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:oa1ConnectionString %>"
                    SelectCommand="SELECT [equipment_name], [standard], [equipment_unit], [equipment_num], [cause], [apply_date], [type], [charge], [remark] FROM [oa_equipment_form_d] WHERE ([form_id] = @form_id)">
                    <SelectParameters>
                        <asp:ControlParameter ControlID="Label2" Name="form_id" PropertyName="Text" Type="String" />
                    </SelectParameters>
                </asp:SqlDataSource>
                <asp:Button ID="Button1" runat="server" Text="送件" Visible="False" OnClick="Button1_Click" />&nbsp;
                <asp:Table ID="FlowTable" runat="server" GridLines="Both" Style="width: 680px" Visible="true"
                    Width="636px">
                    <asp:TableRow runat="server">
                        <asp:TableCell runat="server">步驟</asp:TableCell>
                        <asp:TableCell runat="server">辦理人</asp:TableCell>
                        <asp:TableCell runat="server">簽核類別</asp:TableCell>
                        <asp:TableCell runat="server">處理狀態</asp:TableCell>
                        <asp:TableCell runat="server">是否同意</asp:TableCell>
                        <asp:TableCell runat="server">處理意見</asp:TableCell>
                        <asp:TableCell runat="server">辦理日期</asp:TableCell>
                    </asp:TableRow>
                </asp:Table>
            </asp:View>
        </asp:MultiView></div>
    </form>
    </center>
</body>
</html>

						