OA系统

开发平台：
ASP/ASPX

finish_list.aspx：源码内容
							﻿<%@ Page Language="C#" AutoEventWireup="true" CodeFile="finish_list.aspx.cs" Inherits="web_equipment_finish_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:MultiView ID="MultiView1" runat="server" ActiveViewIndex="0">
            <asp:View ID="View1" runat="server">
                <asp:Label ID="Label2" runat="server" Text="已簽核表單" Width="200px"></asp:Label>
                <asp:GridView ID="GridView1" runat="server" BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" CellPadding="3" Style="position: relative" AllowPaging="True" AutoGenerateColumns="False" DataSourceID="SqlDataSource2" Width="668px" OnRowDataBound="GridView1_RowDataBound" PageSize="8">
                    <Columns>
                        <asp:BoundField DataField="form_id" HeaderText="申請單號" SortExpression="form_id" />
                        <asp:BoundField DataField="emp_name" HeaderText="申請人" SortExpression="emp_name" />
                        <asp:BoundField DataField="check_date" HeaderText="接收日期" SortExpression="check_date" />
                        <asp:BoundField DataField="stuse" HeaderText="狀態" ReadOnly="True" SortExpression="stuse" />
                    </Columns>
                </asp:GridView>
                <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:oa1ConnectionString %>"
                    SelectCommand="SELECT distinct f.form_id,g.emp_name ,f.check_date,case  f.is_agree  when 'N' THEN '不同意' when 'Y' then '已同意' end as stuse FROM oa_equipment_flow as f ,oa_employee as g ,oa_equipment_form as e WHERE (g.id=e.emp_id) and (f.is_check='Y') and (e.form_id=f.form_id)and (f.operator_id = @operator_id) order by f.form_id desc">
                    <SelectParameters>
                        <asp:SessionParameter Name="operator_id" SessionField="user_id" Type="String" />
                    </SelectParameters>
                </asp:SqlDataSource>
                &nbsp;
            </asp:View>
        </asp:MultiView>
        &nbsp;
    </div>
        <asp:MultiView ID="MultiView2" runat="server">
            <asp:View ID="View2" runat="server">
                <br />
                <asp:Table ID="Table1" runat="server" GridLines="Both" Style="left: -226px;
                    position: relative; top: -14px" Width="218px">
                    <asp:TableRow runat="server">
                        <asp:TableCell runat="server" Width="2cm">申請單號</asp:TableCell>
                        <asp:TableCell runat="server" Width="2cm">
                            <asp:Label ID="Label3" runat="server" Text="Label"></asp:Label></asp:TableCell>
                    </asp:TableRow>
                </asp:Table>
                <asp:GridView ID="GridView2" runat="server" AllowPaging="True" AutoGenerateColumns="False" DataSourceID="SqlDataSource1" PageSize="8" 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="SqlDataSource1" 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_id2)">
                    <SelectParameters>
                        <asp:QueryStringParameter Name="form_id2" QueryStringField="form_id" Type="String" />
                    </SelectParameters>
                </asp:SqlDataSource>
                <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>
    </form>
    </center>
</body>
</html>

						