my_list.aspx
上传用户:xrffrp
上传日期:2022-03-25
资源大小:22155k
文件大小:9k
源码类别:

OA系统

开发平台:

ASP/ASPX

  1. <%@ Page Language="C#" AutoEventWireup="true" CodeFile="my_list.aspx.cs" Inherits="web_fair_my_list" %>
  2. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  3. <html xmlns="http://www.w3.org/1999/xhtml" >
  4. <head runat="server">
  5.     <title>无标题页</title>
  6.     <link href="../../css/style.css" rel="stylesheet" type="text/css" />
  7. </head>
  8. <body>
  9.     <form id="form1" runat="server">
  10.     <div>
  11.     <center>
  12.         &nbsp;</center>
  13.         <center>
  14.         <asp:Label ID="LblTitle" runat="server" Text="我的申請單" Font-Bold="True" Font-Size="Medium"></asp:Label>
  15.         </center>
  16.         <center>
  17.             &nbsp;</center>
  18.         <center>
  19.         <asp:GridView ID="FairList" runat="server" AllowPaging="True" AllowSorting="True"
  20.             AutoGenerateColumns="False" BackColor="White" BorderColor="#CCCCCC" BorderStyle="None"
  21.             BorderWidth="1px" CellPadding="3"
  22.             Style="position: relative" Width="580px" DataKeyNames="id" DataSourceID="SqlDataSource1" OnRowDataBound="FairList_RowDataBound">
  23.             <FooterStyle BackColor="White" ForeColor="#000066" />
  24.             <RowStyle ForeColor="Black" />
  25.             <PagerStyle BackColor="White" ForeColor="Black" HorizontalAlign="Left" />
  26.             <SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />
  27.             <HeaderStyle BackColor="Menu" Font-Bold="True" ForeColor="Black" />
  28.             <Columns>
  29.                 <asp:BoundField DataField="apply_date" SortExpression="apply_date" HeaderText="申請日期" />
  30.                 <asp:BoundField DataField="form_no" SortExpression="form_no" HeaderText="單號" />
  31.                 <asp:BoundField DataField="total_result" SortExpression="total_result" HeaderText="處理結果" />
  32.                
  33.             </Columns>
  34.         </asp:GridView>
  35.             <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:oaConnection %>"
  36.                 SelectCommand="SELECT id, form_no, apply_date, total_result FROM dbo.OA_FAIR WHERE (emp_id = @emp_id) ORDER BY form_no DESC">
  37.                 <SelectParameters>
  38.                     <asp:SessionParameter DefaultValue="0" Name="emp_id" SessionField="user_id" />
  39.                 </SelectParameters>
  40.             </asp:SqlDataSource><br />
  41.             <asp:Panel ID="PnlFair" Visible="false" runat="server" Style="position: relative">
  42.                 <asp:Table ID="TblFair" runat="server" Style="position: relative" Width="580px">
  43.                 <asp:TableHeaderRow BackColor="menu">
  44.                     <asp:TableHeaderCell ColumnSpan="2" BorderWidth="1px" HorizontalAlign="Left">費用申請表單</asp:TableHeaderCell>
  45.                 </asp:TableHeaderRow>
  46.                 <asp:TableRow>
  47.                     <asp:TableCell BorderWidth="1px" Width="130px">單號</asp:TableCell>
  48.                     <asp:TableCell BorderWidth="1px" HorizontalAlign="Left">
  49.                         <asp:TextBox ID="TxtFormNo" runat="server" Enabled="false" Width="300px"></asp:TextBox>
  50.                     </asp:TableCell>
  51.                 </asp:TableRow>
  52.                 <asp:TableRow>
  53.                     <asp:TableCell BorderWidth="1px">申請人姓名</asp:TableCell>
  54.                     <asp:TableCell BorderWidth="1px" HorizontalAlign="Left">
  55.                         <asp:TextBox ID="TxtEmpName" runat="server" Enabled="false" Width="300px"></asp:TextBox>
  56.                     </asp:TableCell>
  57.                 </asp:TableRow>
  58.                 <asp:TableRow>
  59.                     <asp:TableCell BorderWidth="1px">申請人工號</asp:TableCell>
  60.                     <asp:TableCell BorderWidth="1px" HorizontalAlign="Left">
  61.                         <asp:TextBox ID="TxtEmpNo" runat="server" Enabled="false" Width="300px"></asp:TextBox>
  62.                     </asp:TableCell>
  63.                 </asp:TableRow>
  64.                 <asp:TableRow>
  65.                     <asp:TableCell BorderWidth="1px">申請日期</asp:TableCell>
  66.                     <asp:TableCell BorderWidth="1px" HorizontalAlign="Left">
  67.                         <asp:TextBox ID="TxtApplyDate" runat="server" Enabled="false" Width="300px"></asp:TextBox>
  68.                     </asp:TableCell>
  69.                 </asp:TableRow>
  70.                 <asp:TableRow>
  71.                     <asp:TableCell BorderWidth="1px">主旨</asp:TableCell>
  72.                     <asp:TableCell BorderWidth="1px" HorizontalAlign="Left">
  73.                         <asp:TextBox ID="TxtSubject" runat="server" Width="300px" Enabled="false"></asp:TextBox>
  74.                     </asp:TableCell>
  75.                 </asp:TableRow>
  76.                 <asp:TableRow>
  77.                     <asp:TableCell BorderWidth="1px">申請金額</asp:TableCell>
  78.                     <asp:TableCell BorderWidth="1px" HorizontalAlign="Left">
  79.                         <asp:TextBox ID="TxtAmount" runat="server" Width="300px" Enabled="false"></asp:TextBox>
  80.                     </asp:TableCell>
  81.                 </asp:TableRow>
  82.                 <asp:TableRow Visible="false">
  83.                     <asp:TableCell BorderWidth="1px">差旅單號</asp:TableCell>
  84.                     <asp:TableCell BorderWidth="1px" HorizontalAlign="Left">
  85.                         <asp:HyperLink ID="HlFormNo" runat="server"></asp:HyperLink>
  86.                     </asp:TableCell>
  87.                 </asp:TableRow>
  88.                 <asp:TableRow>
  89.                     <asp:TableCell BorderWidth="1px">備註</asp:TableCell>
  90.                     <asp:TableCell BorderWidth="1px" HorizontalAlign="Left">
  91.                         <asp:TextBox ID="TxtRemark" runat="server" Width="400px" Enabled="false" TextMode="MultiLine" Rows="5"></asp:TextBox>
  92.                     </asp:TableCell>
  93.                 </asp:TableRow>
  94.                 <asp:TableRow Visible="false">
  95.                     <asp:TableCell BorderWidth="1px">圖檔</asp:TableCell>
  96.                     <asp:TableCell BorderWidth="1px" HorizontalAlign="Left">
  97.                         <asp:Panel ID="PnlPicture" runat="server" HorizontalAlign="Left">
  98.                         </asp:Panel>
  99.                     </asp:TableCell>
  100.                 </asp:TableRow>
  101.                 </asp:Table>
  102.             </asp:Panel><br />
  103.             <asp:Panel ID="PnlFlow" runat="server" Style="position: relative" Width="580px">
  104.                 <asp:GridView ID="FlowList" runat="server" BackColor="White" BorderColor="#CCCCCC"
  105.             BorderStyle="None" BorderWidth="1px" CellPadding="3" Style="position: relative" AutoGenerateColumns="False" DataSourceID="SqlDataSource2" Width="580px" OnRowCreated="FlowList_RowCreated">
  106.                     <FooterStyle BackColor="White" ForeColor="#000066" />
  107.                     <RowStyle ForeColor="Black" />
  108.                     <Columns>
  109.                         <asp:BoundField DataField="step" HeaderText="步驟" SortExpression="step" />
  110.                         <asp:BoundField DataField="emp_name" HeaderText="辦理人" SortExpression="emp_name" />
  111.                         <asp:TemplateField HeaderText="簽核類別">
  112.                             <ItemTemplate>
  113.                                 <asp:Label ID="LblApplyType" runat="server" Style="position: relative"></asp:Label>
  114.                             </ItemTemplate>
  115.                         </asp:TemplateField>
  116.                         <asp:TemplateField HeaderText="處理狀態">
  117.                             <ItemTemplate>
  118.                                 <asp:Label ID="LblIsCheck" runat="server" Style="position: relative"></asp:Label>
  119.                             </ItemTemplate>
  120.                         </asp:TemplateField>
  121.                         <asp:TemplateField HeaderText="是否同意">
  122.                             <ItemTemplate>
  123.                                 <asp:Label ID="LblIsAgree" runat="server" Style="position: relative"></asp:Label>
  124.                             </ItemTemplate>
  125.                         </asp:TemplateField>
  126.                         <asp:TemplateField HeaderText="處理意見">
  127.                             <ItemTemplate>
  128.                                 <asp:Label ID="LblComment" runat="server" Style="position: relative"></asp:Label>
  129.                             </ItemTemplate>
  130.                         </asp:TemplateField>
  131.                         <asp:BoundField DataField="check_date" HeaderText="辦理日期" SortExpression="check_date" />
  132.                     </Columns>
  133.                     <PagerStyle BackColor="White" ForeColor="Black" HorizontalAlign="Left" />
  134.                     <SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />
  135.                     <HeaderStyle BackColor="Menu" Font-Bold="True" ForeColor="Black" />
  136.                 </asp:GridView>
  137.                 <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:oaConnection %>"
  138.                     SelectCommand="select f.id, f.step,e.emp_name, f.comment, f.check_date from OA_FAIR_FORM_FLOW f inner join OA_EMPLOYEE e on e.id=f.operator_id where form_id=@form_id">
  139.                     <SelectParameters>
  140.                         <asp:QueryStringParameter DefaultValue="0" Name="form_id" QueryStringField="f_id" />
  141.                     </SelectParameters>
  142.                 </asp:SqlDataSource>
  143.             </asp:Panel>
  144.         </center>
  145.     </div>
  146.     </form>
  147. </body>
  148. </html>