OA系统

开发平台：
ASP/ASPX

my_list.aspx：源码内容
							﻿<%@ Page Language="C#" AutoEventWireup="true" CodeFile="my_list.aspx.cs" Inherits="web_approvel_tw_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>
    <link href="../../../css/style.css" rel="stylesheet" type="text/css" />
</head>
<body>
    <form id="form1" runat="server">
    <div>
    <center>
        <asp:Label ID="LblTitle" runat="server" Font-Bold="True" Font-Size="Medium" Style="position: relative"
            Text="我的申請單"></asp:Label>&nbsp;</center>
        <center>
            &nbsp;</center>
        <center>
        <asp:GridView ID="ApprovelList" runat="server" BackColor="White" BorderColor="#CCCCCC"
            BorderStyle="None" BorderWidth="1px" CellPadding="3" Style="position: relative" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" DataSourceID="SqlDataSource1" Width="580px" OnRowDataBound="ApprovelList_RowDataBound" OnRowCreated="ApprovelList_RowCreated">
            <FooterStyle BackColor="White" ForeColor="#000066" />
            <RowStyle ForeColor="Black" />
            <PagerStyle BackColor="White" ForeColor="Black" HorizontalAlign="Left" />
            <SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />
            <HeaderStyle BackColor="Menu" Font-Bold="True" ForeColor="Black" />
            <Columns>
                <asp:BoundField DataField="apply_date" SortExpression="apply_date" HeaderText="申請日期" />
                <asp:BoundField DataField="form_id" SortExpression="form_id" HeaderText="單號" />
                <asp:BoundField DataField="type" HeaderText="類別" SortExpression="type" />
                <asp:BoundField DataField="total_result" SortExpression="total_result" HeaderText="處理結果" />
                <asp:TemplateField>
                    <ItemTemplate>
                        <asp:LinkButton ID="LbRevoke" OnClientClick="return confirm('確定要撤銷嗎？')" runat="server" Style="position: relative" Enabled="false">撤销</asp:LinkButton>
                    </ItemTemplate>
                </asp:TemplateField>
            </Columns>
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:oaConnection %>"
            SelectCommand="select a.id, a.form_id, a.apply_date, t.name type, a.total_result from OA_TW_APPROVEL_FORM a inner join OA_TW_OFF_TYPE t on a.off_type=t.id where a.emp_id=@user_id order by a.apply_date desc">
            <SelectParameters>
                <asp:SessionParameter DefaultValue="0" Name="user_id" SessionField="user_id" />
            </SelectParameters>
        </asp:SqlDataSource>
        <asp:Panel ID="PnlApprovel" runat="server" Style="position: relative" Visible="False">
            <br />
            &nbsp;<asp:Table ID="TblForm" runat="server" Height="300" Width="574px">
                <asp:TableHeaderRow runat="server">
                    <asp:TableHeaderCell runat="server" BackColor="Menu" ColumnSpan="4" Height="20px"
                        HorizontalAlign="Left">流通事業群POS來客數統計單</asp:TableHeaderCell>
                </asp:TableHeaderRow>
                <asp:TableRow runat="server">
                    <asp:TableCell runat="server" BorderWidth="1px">
                        <asp:Label ID="LblFormNo" runat="server" BorderStyle="None" Text="申請單號"></asp:Label>
                    </asp:TableCell>
                    <asp:TableCell runat="server" BorderWidth="1px" HorizontalAlign="Left">
                        <asp:TextBox ID="TxtFormNo" runat="server" Enabled="False"></asp:TextBox>
                    </asp:TableCell>
                    <asp:TableCell ID="TableCell3" runat="server" BorderWidth="1px">
                        <asp:Label ID="Label1" runat="server" BorderStyle="None" Text="申請人工號"></asp:Label>
                    </asp:TableCell>
                    <asp:TableCell ID="TableCell4" runat="server" BorderWidth="1px" HorizontalAlign="Left">
                        <asp:TextBox ID="TxtEmpNo" runat="server" Enabled="False"></asp:TextBox>
                    </asp:TableCell>
                </asp:TableRow>
                <asp:TableRow runat="server">
                    <asp:TableCell ID="TableCell5" runat="server" BorderWidth="1px">
                        <asp:Label ID="Label2" runat="server" BorderStyle="None" Text="申請人姓名"></asp:Label>
                    </asp:TableCell>
                    <asp:TableCell ID="TableCell6" runat="server" BorderWidth="1px" HorizontalAlign="Left">
                        <asp:TextBox ID="TxtEmpName" runat="server" Enabled="False"></asp:TextBox>
                    </asp:TableCell>
                    <asp:TableCell ID="TableCell7" runat="server" BorderWidth="1px">
                        <asp:Label ID="Label3" runat="server" BorderStyle="None" Text="申請日期"></asp:Label>
                    </asp:TableCell>
                    <asp:TableCell ID="TableCell8" runat="server" BorderWidth="1px" HorizontalAlign="Left">
                        <asp:TextBox ID="TxtApplyDate" runat="server" Enabled="False"></asp:TextBox>
                    </asp:TableCell>
                </asp:TableRow>
                <asp:TableRow runat="server">
                    <asp:TableCell ID="TableCell9" runat="server" BorderWidth="1px">
                        <asp:Label ID="Label4" runat="server" BorderStyle="None" Text="申請人部門"></asp:Label>
                    </asp:TableCell>
                    <asp:TableCell ID="TableCell10" runat="server" BorderWidth="1px" HorizontalAlign="Left">
                        <asp:TextBox ID="TxtDepartment" runat="server" Enabled="False"></asp:TextBox>
                    </asp:TableCell>
                    <asp:TableCell ID="TableCell11" runat="server" BorderWidth="1px">
                        <asp:Label ID="Label5" runat="server" BorderStyle="None" Text="申請人職稱"></asp:Label>
                    </asp:TableCell>
                    <asp:TableCell ID="TableCell12" runat="server" BorderWidth="1px" HorizontalAlign="Left">
                        <asp:TextBox ID="TxtPosition" runat="server" Enabled="False"></asp:TextBox>
                    </asp:TableCell>
                </asp:TableRow>
                <asp:TableRow ID="TableRow1" runat="server">
                    <asp:TableCell ID="TableCell1" runat="server" BorderWidth="1px">
                        <asp:Label ID="Label6" runat="server" BorderStyle="None" Text="來客數"></asp:Label>
                    </asp:TableCell>
                    <asp:TableCell ID="TableCell2" runat="server" BorderWidth="1px" HorizontalAlign="Left">
                        <asp:TextBox ID="TextCount" runat="server" Enabled="False"></asp:TextBox>
                    </asp:TableCell>
                    <asp:TableCell ID="TableCell13" runat="server" BorderWidth="1px">
                        <asp:Label ID="Label7" runat="server" BorderStyle="None" Text="提袋數"></asp:Label>
                    </asp:TableCell>
                    <asp:TableCell ID="TableCell14" runat="server" BorderWidth="1px" HorizontalAlign="Left">
                        <asp:TextBox ID="TextCount1" runat="server" Enabled="False"></asp:TextBox>
                    </asp:TableCell>
                </asp:TableRow>
                <asp:TableRow ID="TableRow2" runat="server">
                    <asp:TableCell ID="TableCell15" runat="server" BorderWidth="1px">
                        <asp:Label ID="Label8" runat="server" BorderStyle="None" Text="提袋率"></asp:Label>
                    </asp:TableCell>
                    <asp:TableCell ID="TableCell16" runat="server" BorderWidth="1px" HorizontalAlign="Left">
                        <asp:TextBox ID="TextLv" runat="server" Enabled="False"></asp:TextBox>
                    </asp:TableCell>
                    <asp:TableCell ID="TableCell17" runat="server" BorderWidth="1px">
                        <asp:Label ID="Label9" runat="server" BorderStyle="None" Text="提袋日期"></asp:Label>
                    </asp:TableCell>
                    <asp:TableCell ID="TableCell18" runat="server" BorderWidth="1px" HorizontalAlign="Left">
                        <asp:TextBox ID="TextDate" runat="server" Enabled="False"></asp:TextBox>
                    </asp:TableCell>
                </asp:TableRow>
                <asp:TableRow ID="TableRow3" runat="server">
                    <asp:TableCell ID="TableCell19" runat="server" BorderWidth="1px">
                        <asp:Label ID="LblReason" runat="server" BorderStyle="None" Text="備注"></asp:Label>
                    </asp:TableCell>
                    <asp:TableCell ID="TableCell20" runat="server" BorderWidth="1px" ColumnSpan="3" HorizontalAlign="Left">
                        <asp:TextBox ID="TxtRemark" runat="server" Enabled="False" Rows="3" TextMode="MultiLine"
                            Width="450px"></asp:TextBox>
                    </asp:TableCell>
                </asp:TableRow>
                <asp:TableRow runat="server" BorderWidth="1px">
                    <asp:TableCell runat="server" BorderWidth="1px" ColumnSpan="4">
                        <asp:Button ID="BtnOk" runat="server" OnClick="BtnOk_Click" Text="送件" />&nbsp;
                        <asp:Button ID="BtnSave" runat="server" OnClick="BtnSave_Click" Text="存储" />
                    </asp:TableCell>
                </asp:TableRow>
            </asp:Table>
        </asp:Panel>
        </center>
        <center>
            &nbsp;<asp:Panel ID="Panel1" runat="server" Style="position: relative" Visible="false">
                <asp:Label ID="LblError" ForeColor="red" runat="server"></asp:Label>
                <asp:Button ID="BtnOk" runat="server" Style="position: relative" Text="送件" OnClick="BtnOk_Click" />
                <asp:HiddenField ID="State" runat="server" />
                <asp:HiddenField ID="PositionId" runat="server" />
                <asp:HiddenField ID="DepartmentId" runat="server" />
            </asp:Panel>
            <asp:Panel ID="PnlFlow" runat="server" Style="position: relative; left: 0px; top: 0px;" Width="580px">
                <asp:GridView ID="FlowList" runat="server" BackColor="White" BorderColor="#CCCCCC"
            BorderStyle="None" BorderWidth="1px" CellPadding="3" Style="position: relative" AutoGenerateColumns="False" DataSourceID="SqlDataSource2" Width="580px" OnRowCreated="FlowList_RowCreated">
                    <FooterStyle BackColor="White" ForeColor="#000066" />
                    <RowStyle ForeColor="Black" />
                    <Columns>
                        <asp:BoundField DataField="step" HeaderText="步驟" SortExpression="step" />
                        <asp:BoundField DataField="emp_name" HeaderText="辦理人" SortExpression="emp_name" />
                        <asp:TemplateField HeaderText="簽核類別">
                            <ItemTemplate>
                                <asp:Label ID="LblApplyType" runat="server" Style="position: relative"></asp:Label>
                            </ItemTemplate>
                        </asp:TemplateField>
                        <asp:TemplateField HeaderText="處理狀態">
                            <ItemTemplate>
                                <asp:Label ID="LblIsCheck" runat="server" Style="position: relative"></asp:Label>
                            </ItemTemplate>
                        </asp:TemplateField>
                        <asp:TemplateField HeaderText="是否同意">
                            <ItemTemplate>
                                <asp:Label ID="LblIsAgree" runat="server" Style="position: relative"></asp:Label>
                            </ItemTemplate>
                        </asp:TemplateField>
                        <asp:TemplateField HeaderText="處理意見">
                            <ItemTemplate>
                                <asp:Label ID="LblComment" runat="server" Style="position: relative"></asp:Label>
                            </ItemTemplate>
                        </asp:TemplateField>
                        <asp:BoundField DataField="check_date" HeaderText="辦理日期" SortExpression="check_date" />
                    </Columns>
                    <PagerStyle BackColor="White" ForeColor="Black" HorizontalAlign="Left" />
                    <SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />
                    <HeaderStyle BackColor="Menu" Font-Bold="True" ForeColor="Black" />
                </asp:GridView>
                <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:oaConnection %>"
                    SelectCommand="select f.id, f.step,e.emp_name, f.comment, f.check_date from OA_TW_APPROVEL_FORM_FLOW f inner join OA_EMPLOYEE e on e.id=f.operator_id where form_id=@form_id">
                    <SelectParameters>
                        <asp:QueryStringParameter DefaultValue="0" Name="form_id" QueryStringField="a_id" />
                    </SelectParameters>
                </asp:SqlDataSource>
            </asp:Panel>
        </center>
    </div>
    </form>
</body>
</html>

						