OA系统

开发平台：
ASP/ASPX

my_list.aspx：源码内容
							﻿<%@ Page Language="C#" AutoEventWireup="true" CodeFile="my_list.aspx.cs" Inherits="web_computer_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>
    <form id="form1" runat="server">
    <div>
    <center>
        <asp:Label ID="LblTitle" runat="server" Font-Bold="True" Font-Size="Medium" Text="我的申請單"></asp:Label><asp:GridView
            ID="FairList" runat="server" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False"
            BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px"
            CellPadding="3" DataKeyNames="id" DataSourceID="SqlDataSource1" OnRowDataBound="FairList_RowDataBound"
            Style="position: relative" Width="580px">
            <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="date1" HeaderText="申請日期" SortExpression="date1" />
                <asp:BoundField DataField="form_id" HeaderText="單號" SortExpression="form_id" />
                <asp:BoundField DataField="status" HeaderText="處理結果" SortExpression="total_result" />
            </Columns>
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:oaConnection %>"
            SelectCommand="SELECT date1,form_id,id ,status from oa_computer_form  where emp_id=@user_id order by date1 desc">
            <SelectParameters>
                <asp:SessionParameter Name="user_id" SessionField="user_id" />
            </SelectParameters>
        </asp:SqlDataSource>
           </center>
        <center>
        <br />
            <asp:Panel ID="Panform" runat="server"  Visible="False" Height="221px" Width="589px" >
            
            <table border="1" >
                <tr align="left">
                    <td colspan="4" style="height: 32px">
                        <span class="STYLE1" style="font-weight: bold">電腦設備報修單</span></td>
                </tr>
                <tr align="left">
                    <td >
                        <span class="STYLE1">申請單號</span></td>
                    <td style="width: 140px" >
                        <span class="STYLE1">
                            <asp:TextBox ID="form_no" runat="server" Enabled="false"></asp:TextBox></span></td>
                    <td style="width: 94px" >
                        <span class="STYLE1">申請人工號</span></td>
                    <td style="width: 229px" >
                        <span class="STYLE1">
                            <asp:TextBox ID="emp_no" runat="server" Enabled="false"></asp:TextBox></span></td>
                </tr>
                <tr align="left">
                    <td>
                        <span class="STYLE1">申請人姓名</span></td>
                    <td style="width: 140px" >
                        <span class="STYLE1">
                            <asp:TextBox ID="emp_name" runat="server" Enabled="false"></asp:TextBox></span></td>
                    <td style="width: 94px" >
                        <span class="STYLE1">申請日期</span></td>
                    <td style="width: 229px" >
                        <span class="STYLE1">
                            <asp:TextBox ID="date1" runat="server" Enabled="false"></asp:TextBox></span></td>
                </tr>
                <tr align="left">
                    <td >
                        <span class="STYLE1">申請人部門</span></td>
                    <td style="width: 140px" >
                        <span class="STYLE1">
                            <asp:TextBox ID="emp_dept" runat="server" Enabled="false"></asp:TextBox></span></td>
                    <td style="width: 94px" >
                        <span class="STYLE1">申請人職稱</span></td>
                    <td style="width: 229px" >
                        <span class="STYLE1">
                            <asp:TextBox ID="emp_position" runat="server" Enabled="false"></asp:TextBox></span></td>
                </tr>
                <tr align="left" >
                       <td >
                                <span >聯繫電話</span></td>
                            <td  >
                                <span>
                                    <asp:TextBox ID="f_item" runat="server" Width="145px" Enabled="false"></asp:TextBox></span></td>
                    <td style="height: 7px; width: 94px;" >
                        <span class="STYLE1">截止時間</span></td>
                    <td style="width: 229px; height: 7px" >
                        <span class="STYLE1">
                            <asp:TextBox ID="Enddate" runat="server" Enabled="false"></asp:TextBox>
                            <asp:ImageButton ID="ImageButton1" runat="server" Enabled="false" ImageUrl="~/images/calbtn.gif" /><br />
                            &nbsp;</span></td>
                </tr>
                <tr align="left">
                    <td >
                        <span class="STYLE1">說明</span></td>
                    <td colspan="3">
                        <span class="STYLE1">
                            <asp:TextBox ID="content" runat="server" Height="87px" Width="469px"  Enabled="false"></asp:TextBox></span></td>
                </tr>
                <tr>
                    <td colspan="4" style="height: 28px">
                        &nbsp;<asp:Button ID="btn_ok" runat="server" Enabled="false" Text="提交" />
                        <asp:Button ID="btn_save" runat="server" Enabled="false" Text="存儲" /></td>
                </tr>
            </table>
            </asp:Panel>
        &nbsp;
        </center>
        </div>
        <center>
        <asp:Panel ID="PnlFlow" runat="server" Style="position: relative" Width="580px" Visible="False">
            <asp:GridView ID="FlowList" runat="server" AutoGenerateColumns="False" BackColor="White"
                BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" CellPadding="3" DataSourceID="SqlDataSource2"
                OnRowCreated="FlowList_RowCreated" Style="position: relative" Width="580px">
                <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 b.id,b.step,c.emp_name,b.apply_type,a.status,b.is_agree,b.comment,b.check_date,b.form_id from oa_computer_form as a&#13;&#10; left join oa_computer_form_flow as b on a.form_id=b.form_id left join oa_employee as c on b.operator_id=c.id where a.id=@f_id">
                <SelectParameters>
                    <asp:QueryStringParameter Name="f_id" QueryStringField="f_id" />
                </SelectParameters>
            </asp:SqlDataSource>
        </asp:Panel>
        </center>
    </form>
 
</body>
</html>

						