开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > 行业应用 > OA系统 > 查看源码
my_list.aspx
资源名称：web.rar　[点击查看]
上传用户：xrffrp
上传日期：2022-03-25
资源大小：22155k
文件大小：9k
源码类别：

OA系统

开发平台：

ASP/ASPX

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