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

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

OA系统

开发平台：

ASP/ASPX

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