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

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

OA系统

开发平台：

ASP/ASPX

deal1_list.aspx：源码内容
  1. <%@ Page Language="C#" AutoEventWireup="true" CodeFile="deal1_list.aspx.cs" Inherits="web_pos_c_deal1_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. </head>
  9. <body>
  10.     <form id="form1" runat="server">
  11.     <div>
  12.         &nbsp;<asp:Label ID="Label11" runat="server" Text="區域:"></asp:Label>&nbsp;
  13.         <asp:DropDownList ID="textArea" runat="server" DataSourceID="SqlDataSource3" DataTextField="name" DataValueField="id">
  14.         </asp:DropDownList><asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:oaConnection %>"
  15.             SelectCommand="SELECT [id], [name], [last_id] FROM [OA_DEPARTMENT] where id=144 or id=145 or id=146 or id=147 or&#13;&#10;id=194">
  16.         </asp:SqlDataSource>
  17.         <br />
  18.         <asp:Label ID="Label22" runat="server" Text="日期:"></asp:Label>
  19.         <asp:TextBox ID="textDate" runat="server"></asp:TextBox>
  20.          <asp:ImageButton ID="ImageButton2" ImageUrl="~/images/calbtn.gif" runat="server" OnClick="ImageButton2_Click" ></asp:ImageButton>
  21.                     <asp:Calendar ID="Calendar2" runat="server" BackColor="White" BorderColor="#999999"
  22.                         CellPadding="4" DayNameFormat="Shortest" Font-Names="Verdana" Font-Size="8pt"
  23.                         ForeColor="Black" Height="145px" OnSelectionChanged="Calendar2_SelectionChanged"
  24.                         Style="position: relative" Visible="False" Width="200px">
  25.                         <SelectedDayStyle BackColor="#666666" Font-Bold="True" ForeColor="White" />
  26.                         <SelectorStyle BackColor="#CCCCCC" />
  27.                         <WeekendDayStyle BackColor="#FFFFCC" />
  28.                         <TodayDayStyle BackColor="#CCCCCC" ForeColor="Black" />
  29.                         <OtherMonthDayStyle ForeColor="Gray" />
  30.                         <NextPrevStyle VerticalAlign="Bottom" />
  31.                         <DayHeaderStyle BackColor="#CCCCCC" Font-Bold="True" Font-Size="7pt" />
  32.                         <TitleStyle BackColor="#999999" BorderColor="Black" Font-Bold="True" />
  33.                     </asp:Calendar>
  34.         <br />
  35.         <asp:Button ID="Btn_ok" runat="server" Text="查詢" OnClick="Btn_ok_Click" />
  36.         &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp;
  37.         &nbsp; &nbsp; &nbsp;
  38.         <asp:Panel ID="Panel1" runat="server" Height="148px" Width="521px">
  39.         <asp:GridView ID="PosCList" runat="server" BackColor="White" BorderColor="#999999"
  40.             BorderStyle="None" BorderWidth="1px" CellPadding="3" DataSourceID="SqlDataSource2"
  41.             GridLines="Vertical" AutoGenerateColumns="False"   OnRowDataBound="PosCList_RowDataBound">
  42.             <FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
  43.             <RowStyle BackColor="#EEEEEE" ForeColor="Black" />
  44.             <SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" />
  45.             <PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
  46.             <HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" />
  47.             <AlternatingRowStyle BackColor="Gainsboro" />
  48.             <Columns>
  49.                 <asp:BoundField DataField="name" HeaderText="店名" SortExpression="name" />
  50.                 <asp:BoundField DataField="t_count" HeaderText="來客數" SortExpression="t_count" />
  51.                 <asp:BoundField DataField="t_count1" HeaderText="提袋數" SortExpression="t_count1" />
  52.                 <asp:BoundField DataField="t_lv" HeaderText="提袋率" SortExpression="t_lv" />
  53.                 <asp:BoundField DataField="t_date" HeaderText="提袋日期" SortExpression="t_date" />
  54.                 <asp:BoundField DataField="remark" HeaderText="備注" SortExpression="remark" />
  55.                 <asp:BoundField DataField="apply_date" HeaderText="填單日期" SortExpression="apply_date" />
  56.             </Columns>
  57.         </asp:GridView>
  58.         </asp:Panel>       
  59.         <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:oaConnection %>" SelectCommand="select f.id,d.name,f.t_count,f.t_count1,f.t_lv,f.t_date,f.remark,f.apply_date from oa_pos_c_form &#13;&#10;as f left join oa_department as d on f.department_id=d.id &#13;&#10;where t_date=convert(varchar(10),getdate(),120) order by d.id"></asp:SqlDataSource>
  60.         <asp:Panel ID="Panel2" runat="server" Height="145px" Width="529px" Visible="false">
  61.         <asp:GridView ID="PosCList_select" runat="server" AutoGenerateColumns="False" BackColor="White"
  62.             BorderColor="#999999" BorderStyle="None" BorderWidth="1px" CellPadding="3" DataSourceID="SqlDataSource1"
  63.             GridLines="Vertical"  Width="508px"   OnRowDataBound="PosCList_select_RowDataBound">
  64.             <FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
  65.             <Columns>
  66.                 <asp:BoundField DataField="name" HeaderText="店名" SortExpression="name" />
  67.                 <asp:BoundField DataField="t_count" HeaderText="來客數" SortExpression="t_count" />
  68.                 <asp:BoundField DataField="t_count1" HeaderText="提代數" SortExpression="t_count1" />
  69.                 <asp:BoundField DataField="t_lv" HeaderText="提袋率" SortExpression="t_lv" />
  70.                 <asp:BoundField DataField="t_date" HeaderText="提袋日期" SortExpression="t_date" />               
  71.                 <asp:BoundField DataField="remark" HeaderText="備注" SortExpression="remark" />
  72.                 <asp:BoundField DataField="apply_date" HeaderText="填單日期" SortExpression="apply_date" />
  73.             </Columns>
  74.             <RowStyle BackColor="#EEEEEE" ForeColor="Black" />
  75.             <SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" />
  76.             <PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
  77.             <HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" />
  78.             <AlternatingRowStyle BackColor="#DCDCDC" />
  79.         </asp:GridView>
  80.         </asp:Panel>
  81.         <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:oaConnection %>"
  82.             SelectCommand="select f.id,d.name,f.t_count,f.t_count1,f.t_lv,f.t_date,f.remark,f.apply_date from oa_pos_c_form as f left join oa_department as d on f.department_id=d.id where t_date=@t_date and d.last_id=@dpt_id">
  83.             <SelectParameters>
  84.                 <asp:QueryStringParameter  Name="t_date" QueryStringField="t_date" />
  85.                 <asp:QueryStringParameter  Name="dpt_id" QueryStringField="dpt_id" />
  86.             </SelectParameters>
  87.         </asp:SqlDataSource>
  88.         <asp:Panel ID="Panel3" runat="server" Height="1px" Visible="False" Width="521px">
  89.             &nbsp;<asp:Table ID="TblForm" runat="server" Height="300" Width="574px">
  90.                 <asp:TableHeaderRow runat="server">
  91.                     <asp:TableHeaderCell runat="server" BackColor="Menu" ColumnSpan="4" Height="20px"
  92.                         HorizontalAlign="Left">流通事業群POS來客數統計單</asp:TableHeaderCell>
  93.                 </asp:TableHeaderRow>
  94.                 <asp:TableRow runat="server">
  95.                     <asp:TableCell runat="server" BorderWidth="1px">
  96.                         <asp:Label ID="LblFormNo" runat="server" BorderStyle="None" Text="申請單號"></asp:Label>
  97.                     </asp:TableCell>
  98.                     <asp:TableCell runat="server" BorderWidth="1px" HorizontalAlign="Left">
  99.                         <asp:TextBox ID="TxtFormNo" runat="server" Enabled="False"></asp:TextBox>
  100.                     </asp:TableCell>
  101.                     <asp:TableCell ID="TableCell3" runat="server" BorderWidth="1px">
  102.                         <asp:Label ID="Label1" runat="server" BorderStyle="None" Text="申請人工號"></asp:Label>
  103.                     </asp:TableCell>
  104.                     <asp:TableCell ID="TableCell4" runat="server" BorderWidth="1px" HorizontalAlign="Left">
  105.                         <asp:TextBox ID="TxtEmpNo" runat="server" Enabled="False"></asp:TextBox>
  106.                     </asp:TableCell>
  107.                 </asp:TableRow>
  108.                 <asp:TableRow runat="server">
  109.                     <asp:TableCell ID="TableCell5" runat="server" BorderWidth="1px">
  110.                         <asp:Label ID="Label2" runat="server" BorderStyle="None" Text="申請人姓名"></asp:Label>
  111.                     </asp:TableCell>
  112.                     <asp:TableCell ID="TableCell6" runat="server" BorderWidth="1px" HorizontalAlign="Left">
  113.                         <asp:TextBox ID="TxtEmpName" runat="server" Enabled="False"></asp:TextBox>
  114.                     </asp:TableCell>
  115.                     <asp:TableCell ID="TableCell7" runat="server" BorderWidth="1px">
  116.                         <asp:Label ID="Label3" runat="server" BorderStyle="None" Text="申請日期"></asp:Label>
  117.                     </asp:TableCell>
  118.                     <asp:TableCell ID="TableCell8" runat="server" BorderWidth="1px" HorizontalAlign="Left">
  119.                         <asp:TextBox ID="TxtApplyDate" runat="server" Enabled="False"></asp:TextBox>
  120.                     </asp:TableCell>
  121.                 </asp:TableRow>
  122.                 <asp:TableRow runat="server">
  123.                     <asp:TableCell ID="TableCell9" runat="server" BorderWidth="1px">
  124.                         <asp:Label ID="Label4" runat="server" BorderStyle="None" Text="申請人部門"></asp:Label>
  125.                     </asp:TableCell>
  126.                     <asp:TableCell ID="TableCell10" runat="server" BorderWidth="1px" HorizontalAlign="Left">
  127.                         <asp:TextBox ID="TxtDepartment" runat="server" Enabled="False"></asp:TextBox>
  128.                     </asp:TableCell>
  129.                     <asp:TableCell ID="TableCell11" runat="server" BorderWidth="1px">
  130.                         <asp:Label ID="Label5" runat="server" BorderStyle="None" Text="申請人職稱"></asp:Label>
  131.                     </asp:TableCell>
  132.                     <asp:TableCell ID="TableCell12" runat="server" BorderWidth="1px" HorizontalAlign="Left">
  133.                         <asp:TextBox ID="TxtPosition" runat="server" Enabled="False"></asp:TextBox>
  134.                     </asp:TableCell>
  135.                 </asp:TableRow>
  136.                 <asp:TableRow ID="TableRow1" runat="server">
  137.                     <asp:TableCell ID="TableCell1" runat="server" BorderWidth="1px">
  138.                         <asp:Label ID="Label6" runat="server" BorderStyle="None" Text="來客數"></asp:Label>
  139.                     </asp:TableCell>
  140.                     <asp:TableCell ID="TableCell2" runat="server" BorderWidth="1px" HorizontalAlign="Left">
  141.                         <asp:TextBox ID="TextCount" runat="server" Enabled="False"></asp:TextBox>
  142.                     </asp:TableCell>
  143.                     <asp:TableCell ID="TableCell13" runat="server" BorderWidth="1px">
  144.                         <asp:Label ID="Label7" runat="server" BorderStyle="None" Text="提袋數"></asp:Label>
  145.                     </asp:TableCell>
  146.                     <asp:TableCell ID="TableCell14" runat="server" BorderWidth="1px" HorizontalAlign="Left">
  147.                         <asp:TextBox ID="TextCount1" runat="server" Enabled="False"></asp:TextBox>
  148.                     </asp:TableCell>
  149.                 </asp:TableRow>
  150.                 <asp:TableRow ID="TableRow2" runat="server">
  151.                     <asp:TableCell ID="TableCell15" runat="server" BorderWidth="1px">
  152.                         <asp:Label ID="Label8" runat="server" BorderStyle="None" Text="提袋率"></asp:Label>
  153.                     </asp:TableCell>
  154.                     <asp:TableCell ID="TableCell16" runat="server" BorderWidth="1px" HorizontalAlign="Left">
  155.                         <asp:TextBox ID="TextLv" runat="server" Enabled="False"></asp:TextBox>
  156.                     </asp:TableCell>
  157.                     <asp:TableCell ID="TableCell17" runat="server" BorderWidth="1px">
  158.                         <asp:Label ID="Label9" runat="server" BorderStyle="None" Text="提袋日期"></asp:Label>
  159.                     </asp:TableCell>
  160.                     <asp:TableCell ID="TableCell18" runat="server" BorderWidth="1px" HorizontalAlign="Left">
  161.                         <asp:TextBox ID="TextDate1" runat="server" Enabled="False"></asp:TextBox>
  162.                     </asp:TableCell>
  163.                 </asp:TableRow>
  164.                 <asp:TableRow ID="TableRow3" runat="server">
  165.                     <asp:TableCell ID="TableCell19" runat="server" BorderWidth="1px">
  166.                         <asp:Label ID="LblReason" runat="server" BorderStyle="None" Text="備注"></asp:Label>
  167.                     </asp:TableCell>
  168.                     <asp:TableCell ID="TableCell20" runat="server" BorderWidth="1px" ColumnSpan="3" HorizontalAlign="Left">
  169.                         <asp:TextBox ID="TxtRemark" runat="server" Enabled="False" Rows="3" TextMode="MultiLine"
  170.                             Width="450px"></asp:TextBox>
  171.                     </asp:TableCell>
  172.                 </asp:TableRow>
  173.                 <asp:TableRow runat="server" BorderWidth="1px">
  174.                     <asp:TableCell runat="server" BorderWidth="1px" ColumnSpan="4">
  175.                         <asp:Button ID="BtnSave" runat="server" Enabled="false" Text="存储" />
  176.                     </asp:TableCell>
  177.                 </asp:TableRow>
  178.             </asp:Table>
  179.         </asp:Panel>
  180.         <br />
  181.         &nbsp;<br />
  182.         &nbsp; &nbsp;&nbsp; &nbsp;
  183.     </div>
  184.     </form>
  185. </body>
  186. </html>