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

OA系统

开发平台:

ASP/ASPX

  1. <%@ Page Language="C#" AutoEventWireup="true" CodeFile="my_list.aspx.cs" Inherits="web_approvel_tw_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.         <asp:Label ID="LblTitle" runat="server" Font-Bold="True" Font-Size="Medium" Style="position: relative"
  13.             Text="我的申請單"></asp:Label>&nbsp;</center>
  14.         <center>
  15.             &nbsp;</center>
  16.         <center>
  17.         <asp:GridView ID="ApprovelList" runat="server" BackColor="White" BorderColor="#CCCCCC"
  18.             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">
  19.             <FooterStyle BackColor="White" ForeColor="#000066" />
  20.             <RowStyle ForeColor="Black" />
  21.             <PagerStyle BackColor="White" ForeColor="Black" HorizontalAlign="Left" />
  22.             <SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />
  23.             <HeaderStyle BackColor="Menu" Font-Bold="True" ForeColor="Black" />
  24.             <Columns>
  25.                 <asp:BoundField DataField="apply_date" SortExpression="apply_date" HeaderText="申請日期" />
  26.                 <asp:BoundField DataField="form_id" SortExpression="form_id" HeaderText="單號" />
  27.                 <asp:BoundField DataField="type" HeaderText="類別" SortExpression="type" />
  28.                 <asp:BoundField DataField="total_result" SortExpression="total_result" HeaderText="處理結果" />
  29.                 <asp:TemplateField>
  30.                     <ItemTemplate>
  31.                         <asp:LinkButton ID="LbRevoke" OnClientClick="return confirm('確定要撤銷嗎?')" runat="server" Style="position: relative" Enabled="false">撤销</asp:LinkButton>
  32.                     </ItemTemplate>
  33.                 </asp:TemplateField>
  34.             </Columns>
  35.         </asp:GridView>
  36.         <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:oaConnection %>"
  37.             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">
  38.             <SelectParameters>
  39.                 <asp:SessionParameter DefaultValue="0" Name="user_id" SessionField="user_id" />
  40.             </SelectParameters>
  41.         </asp:SqlDataSource>
  42.         <asp:Panel ID="PnlApprovel" runat="server" Style="position: relative" Visible="False">
  43.             <br />
  44.             <asp:Table ID="TblForm" runat="server" Style="position: relative" Width="580px">
  45.                 <asp:TableHeaderRow runat="server">
  46.                     <asp:TableHeaderCell runat="server" BackColor="Menu" ColumnSpan="4" Height="20px"
  47.                         HorizontalAlign="Left">流通事業群台幹差假單</asp:TableHeaderCell>
  48.                 </asp:TableHeaderRow>
  49.                 <asp:TableRow runat="server">
  50.                     <asp:TableCell runat="server" BorderWidth="1px">
  51.                         <asp:Label ID="LblFormNo" runat="server" BorderStyle="None" Text="申請單號"></asp:Label>
  52.                     </asp:TableCell>
  53.                     <asp:TableCell runat="server" BorderWidth="1px" HorizontalAlign="Left">
  54.                         <asp:TextBox ID="TxtFormNo" runat="server" Enabled="False"></asp:TextBox>
  55.                     </asp:TableCell>
  56.                     <asp:TableCell runat="server" BorderWidth="1px">
  57.                         <asp:Label ID="LblVacationBegin" runat="server" BorderStyle="None"
  58.                             Text="休假日期起"></asp:Label>
  59.                     </asp:TableCell>
  60.                     <asp:TableCell runat="server" BorderWidth="1px" HorizontalAlign="Left">
  61.                         <asp:TextBox ID="TxtVacationBegin" runat="server" Enabled="False"></asp:TextBox>
  62.                     </asp:TableCell>
  63.                 </asp:TableRow>
  64.                 <asp:TableRow runat="server">
  65.                     <asp:TableCell runat="server" BorderWidth="1px">
  66.                         <asp:Label ID="LblEmpNo" runat="server" BorderStyle="None" Text="申請人工號"></asp:Label>
  67.                     </asp:TableCell>
  68.                     <asp:TableCell runat="server" BorderWidth="1px" HorizontalAlign="Left">
  69.                         <asp:TextBox ID="TxtEmpNo" runat="server" Enabled="False"></asp:TextBox>
  70.                     </asp:TableCell>
  71.                     <asp:TableCell runat="server" BorderWidth="1px">
  72.                         <asp:Label ID="LblVacationEnd" runat="server" BorderStyle="None"
  73.                             Text="休假日期止"></asp:Label>
  74.                     </asp:TableCell>
  75.                     <asp:TableCell runat="server" BorderWidth="1px" HorizontalAlign="Left">
  76.                         <asp:TextBox ID="TxtVacationEnd" runat="server" Enabled="False"></asp:TextBox>
  77.                     </asp:TableCell>
  78.                 </asp:TableRow>
  79.                 <asp:TableRow runat="server">
  80.                     <asp:TableCell runat="server" BorderWidth="1px">
  81.                         <asp:Label ID="LblApplyDate" runat="server" BorderStyle="None" Text="申請日期"></asp:Label>
  82.                     </asp:TableCell>
  83.                     <asp:TableCell runat="server" BorderWidth="1px" HorizontalAlign="Left">
  84.                         <asp:TextBox ID="TxtApplyDate" runat="server" Enabled="False"></asp:TextBox>
  85.                     </asp:TableCell>
  86.                     <asp:TableCell runat="server" BorderWidth="1px">
  87.                         <asp:Label ID="LblVacationPlace" runat="server" BorderStyle="None"
  88.                             Text="休假區域"></asp:Label>
  89.                     </asp:TableCell>
  90.                     <asp:TableCell runat="server" BorderWidth="1px" HorizontalAlign="Left">
  91.                         <asp:TextBox ID="TxtVacationPlace" runat="server" Enabled="false"></asp:TextBox>
  92.                     </asp:TableCell>
  93.                 </asp:TableRow>
  94.                 <asp:TableRow runat="server">
  95.                     <asp:TableCell runat="server" BorderWidth="1px">
  96.                         <asp:Label ID="LblEmpId" runat="server" BorderStyle="None" Text="申請人姓名"></asp:Label>
  97.                     </asp:TableCell>
  98.                     <asp:TableCell runat="server" BorderWidth="1px" HorizontalAlign="Left">
  99.                         <asp:TextBox ID="TxtEmpName" runat="server" Enabled="False"></asp:TextBox>
  100.                     </asp:TableCell>
  101.                     <asp:TableCell runat="server" BorderWidth="1px">
  102.                         <asp:Label ID="LblFlightGoDepart" runat="server" BorderStyle="None" Text="班機(往)出發地"></asp:Label>
  103.                     </asp:TableCell>
  104.                     <asp:TableCell runat="server" BorderWidth="1px" HorizontalAlign="Left">
  105.                         <asp:TextBox ID="TxtFlightGoDepart" runat="server" Enabled="False"></asp:TextBox>
  106.                     </asp:TableCell>
  107.                 </asp:TableRow>
  108.                 <asp:TableRow runat="server">
  109.                     <asp:TableCell runat="server" BorderWidth="1px">
  110.                         <asp:Label ID="LblDepartment" runat="server" BorderStyle="None" Text="申請人部門"></asp:Label>
  111.                     </asp:TableCell>
  112.                     <asp:TableCell runat="server" BorderWidth="1px" HorizontalAlign="Left">
  113.                         <asp:TextBox ID="TxtDepartment" runat="server" Enabled="False"></asp:TextBox>
  114.                     </asp:TableCell>
  115.                     <asp:TableCell runat="server" BorderWidth="1px">
  116.                         <asp:Label ID="LblFlightGoArrive" runat="server" BorderStyle="None" Text="班機(往)終地點"></asp:Label>
  117.                     </asp:TableCell>
  118.                     <asp:TableCell runat="server" BorderWidth="1px" HorizontalAlign="Left">
  119.                         <asp:TextBox ID="TxtFlightGoArrive" runat="server" Enabled="False"></asp:TextBox>
  120.                     </asp:TableCell>
  121.                 </asp:TableRow>
  122.                 <asp:TableRow runat="server">
  123.                     <asp:TableCell runat="server" BorderWidth="1px">
  124.                         <asp:Label ID="LblPosition" runat="server" BorderStyle="None" Text="申請人職稱"></asp:Label>
  125.                     </asp:TableCell>
  126.                     <asp:TableCell runat="server" BorderWidth="1px" HorizontalAlign="Left">
  127.                         <asp:TextBox ID="TxtPosition" runat="server" Enabled="False"></asp:TextBox>
  128.                     </asp:TableCell>
  129.                     <asp:TableCell runat="server" BorderWidth="1px">
  130.                         <asp:Label ID="LblFlightGoTime" runat="server" BorderStyle="None" Text="(往)起飛時間"></asp:Label>
  131.                     </asp:TableCell>
  132.                     <asp:TableCell runat="server" BorderWidth="1px" HorizontalAlign="Left">
  133.                         <asp:TextBox ID="TxtFlightGoTime" runat="server" Enabled="False"></asp:TextBox>
  134.                     </asp:TableCell>
  135.                 </asp:TableRow>
  136.                 <asp:TableRow runat="server">
  137.                     <asp:TableCell runat="server" BorderWidth="1px">
  138.                         <asp:Label ID="LblDelegate" runat="server" BorderStyle="None" Text="代理人"></asp:Label>
  139.                     </asp:TableCell>
  140.                     <asp:TableCell runat="server" BorderWidth="1px" HorizontalAlign="Left">
  141.                         <asp:TextBox ID="TxtDelegate" runat="server" Enabled="False"></asp:TextBox>
  142.                     </asp:TableCell>
  143.                     <asp:TableCell runat="server" BorderWidth="1px">
  144.                         <asp:Label ID="LblFlightBackTime" runat="server" BorderStyle="None" Text="(返)起飛時間"></asp:Label>
  145.                     </asp:TableCell>
  146.                     <asp:TableCell runat="server" BorderWidth="1px" HorizontalAlign="Left">
  147.                         <asp:TextBox ID="TxtFlightBackTime" runat="server" Enabled="False"></asp:TextBox>
  148.                     </asp:TableCell>
  149.                 </asp:TableRow>
  150.                 <asp:TableRow runat="server">
  151.                     <asp:TableCell runat="server" BorderWidth="1px">
  152.                         <asp:Label ID="LblOffType" runat="server" BorderStyle="None" Text="假別"></asp:Label>
  153.                     </asp:TableCell>
  154.                     <asp:TableCell runat="server" BorderWidth="1px" HorizontalAlign="Left">
  155.                         <asp:TextBox ID="TxtOffType" runat="server" Enabled="False"></asp:TextBox>
  156.                     </asp:TableCell>
  157.                     <asp:TableCell runat="server" BorderWidth="1px">
  158.                         <asp:Label ID="LblFlightBackDepart" runat="server" BorderStyle="None" Text="班機(返)出發地"></asp:Label>
  159.                     </asp:TableCell>
  160.                     <asp:TableCell runat="server" BorderWidth="1px" HorizontalAlign="Left">
  161.                         <asp:TextBox ID="TxtFlightBackDepart" runat="server" Enabled="False"></asp:TextBox>
  162.                     </asp:TableCell>
  163.                 </asp:TableRow>
  164.                 <asp:TableRow runat="server">
  165.                     <asp:TableCell runat="server" BorderWidth="1px">
  166.                         <asp:Label ID="LblParenthesis" runat="server" BorderStyle="None" Text="附帶公務假"></asp:Label>
  167.                     </asp:TableCell>
  168.                     <asp:TableCell runat="server" BorderWidth="1px" HorizontalAlign="Left">
  169.                         <asp:TextBox ID="TxtParenthesis" runat="server" Enabled="False"></asp:TextBox>
  170.                     </asp:TableCell>
  171.                     <asp:TableCell runat="server" BorderWidth="1px">
  172.                         <asp:Label ID="LblFlightBackArrive" runat="server" BorderStyle="None" Text="班機(返)終地點"></asp:Label>
  173.                     </asp:TableCell>
  174.                     <asp:TableCell runat="server" BorderWidth="1px" HorizontalAlign="Left">
  175.                         <asp:TextBox ID="TxtFlightBackArrive" runat="server" Enabled="False"></asp:TextBox>
  176.                     </asp:TableCell>
  177.                 </asp:TableRow>
  178.                 <asp:TableRow runat="server">
  179.                     <asp:TableCell runat="server" BorderWidth="1px">
  180.                         <asp:Label ID="LblDays" runat="server" BorderStyle="None" Text="工作日數"></asp:Label>
  181.                     </asp:TableCell>
  182.                     <asp:TableCell runat="server" BorderWidth="1px" HorizontalAlign="Left">
  183.                         <asp:TextBox ID="TxtDays" runat="server" Enabled="False"></asp:TextBox>
  184.                     </asp:TableCell>
  185.                     <asp:TableCell runat="server" BorderWidth="1px">
  186.                         <asp:Label ID="LblBusinessBegin" runat="server" BorderStyle="None" Text="工作日期起"></asp:Label>
  187.                     </asp:TableCell>
  188.                     <asp:TableCell runat="server" BorderWidth="1px" HorizontalAlign="Left">
  189.                         <asp:TextBox ID="TxtBusinessBegin" runat="server" Enabled="False"></asp:TextBox>
  190.                     </asp:TableCell>
  191.                 </asp:TableRow>
  192.                 <asp:TableRow runat="server">
  193.                     <asp:TableCell runat="server" BorderWidth="1px">
  194.                         <asp:Label ID="LblBusinessPlace" runat="server" BorderStyle="None" Text="工作地點"></asp:Label>
  195.                     </asp:TableCell>
  196.                     <asp:TableCell runat="server" BorderWidth="1px" HorizontalAlign="Left">
  197.                         <asp:TextBox ID="TxtBusinessPlace" runat="server" Enabled="False"></asp:TextBox>
  198.                     </asp:TableCell>
  199.                     <asp:TableCell runat="server" BorderWidth="1px">
  200.                         <asp:Label ID="LblBusinessEnd" runat="server" BorderStyle="None" Text="工作日期止"></asp:Label>
  201.                     </asp:TableCell>
  202.                     <asp:TableCell runat="server" BorderWidth="1px" HorizontalAlign="Left">
  203.                         <asp:TextBox ID="TxtBusinessEnd" runat="server" Enabled="False"></asp:TextBox>
  204.                     </asp:TableCell>
  205.                 </asp:TableRow>
  206.                 <asp:TableRow runat="server">
  207.                     <asp:TableCell runat="server" BorderWidth="1px">
  208.                         <asp:Label ID="LblReason" runat="server" BorderStyle="None" Text="申請事由"></asp:Label>
  209.                     </asp:TableCell>
  210.                     <asp:TableCell runat="server" BorderWidth="1px" ColumnSpan="3" HorizontalAlign="Left">
  211.                         <asp:TextBox ID="TxtReason" runat="server" Rows="3" TextMode="MultiLine" Width="450px" Enabled="False"></asp:TextBox>
  212.                     </asp:TableCell>
  213.                 </asp:TableRow>
  214.             </asp:Table>
  215.         </asp:Panel>
  216.         </center>
  217.         <center>
  218.             &nbsp;<asp:Panel ID="Panel1" runat="server" Style="position: relative" Visible="false">
  219.                 <asp:Label ID="LblError" ForeColor="red" runat="server"></asp:Label>
  220.                 <asp:Button ID="BtnOk" runat="server" Style="position: relative" Text="送件" OnClick="BtnOk_Click" />
  221.                 <asp:HiddenField ID="State" runat="server" />
  222.                 <asp:HiddenField ID="PositionId" runat="server" />
  223.                 <asp:HiddenField ID="DepartmentId" runat="server" />
  224.             </asp:Panel>
  225.             <asp:Panel ID="PnlFlow" runat="server" Style="position: relative; left: 0px; top: 0px;" Width="580px">
  226.                 <asp:GridView ID="FlowList" runat="server" BackColor="White" BorderColor="#CCCCCC"
  227.             BorderStyle="None" BorderWidth="1px" CellPadding="3" Style="position: relative" AutoGenerateColumns="False" DataSourceID="SqlDataSource2" Width="580px" OnRowCreated="FlowList_RowCreated">
  228.                     <FooterStyle BackColor="White" ForeColor="#000066" />
  229.                     <RowStyle ForeColor="Black" />
  230.                     <Columns>
  231.                         <asp:BoundField DataField="step" HeaderText="步驟" SortExpression="step" />
  232.                         <asp:BoundField DataField="emp_name" HeaderText="辦理人" SortExpression="emp_name" />
  233.                         <asp:TemplateField HeaderText="簽核類別">
  234.                             <ItemTemplate>
  235.                                 <asp:Label ID="LblApplyType" runat="server" Style="position: relative"></asp:Label>
  236.                             </ItemTemplate>
  237.                         </asp:TemplateField>
  238.                         <asp:TemplateField HeaderText="處理狀態">
  239.                             <ItemTemplate>
  240.                                 <asp:Label ID="LblIsCheck" runat="server" Style="position: relative"></asp:Label>
  241.                             </ItemTemplate>
  242.                         </asp:TemplateField>
  243.                         <asp:TemplateField HeaderText="是否同意">
  244.                             <ItemTemplate>
  245.                                 <asp:Label ID="LblIsAgree" runat="server" Style="position: relative"></asp:Label>
  246.                             </ItemTemplate>
  247.                         </asp:TemplateField>
  248.                         <asp:TemplateField HeaderText="處理意見">
  249.                             <ItemTemplate>
  250.                                 <asp:Label ID="LblComment" runat="server" Style="position: relative"></asp:Label>
  251.                             </ItemTemplate>
  252.                         </asp:TemplateField>
  253.                         <asp:BoundField DataField="check_date" HeaderText="辦理日期" SortExpression="check_date" />
  254.                     </Columns>
  255.                     <PagerStyle BackColor="White" ForeColor="Black" HorizontalAlign="Left" />
  256.                     <SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />
  257.                     <HeaderStyle BackColor="Menu" Font-Bold="True" ForeColor="Black" />
  258.                 </asp:GridView>
  259.                 <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:oaConnection %>"
  260.                     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">
  261.                     <SelectParameters>
  262.                         <asp:QueryStringParameter DefaultValue="0" Name="form_id" QueryStringField="a_id" />
  263.                     </SelectParameters>
  264.                 </asp:SqlDataSource>
  265.             </asp:Panel>
  266.         </center>
  267.     </div>
  268.     </form>
  269. </body>
  270. </html>