/
ivan
/
ModMas
Обзор
Документация
Войти
/
ivan
/
ModMas
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
main
ModuleMaster/hr/srdc.aspx
63 строки
4 KB
i.krivokon
Initial commit
13 мар 2026, 13:49
13 мар 2026, 13:49
00d9fb6
Код
Авторство
О чём код?
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="SRDC.aspx.vb" Inherits="HR_SRDC" %> <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title>SRDC Check card log</title> <link href="../Styles/page.css" rel="stylesheet" /> </head> <body> <form id="form1" runat="server"> <div class="center"> <table style="margin: 0 auto;"> <tr> <td>Date : <asp:TextBox ID="fromdate" runat="server" TextMode="Date"></asp:TextBox> ~ <asp:TextBox ID="todate" runat="server" TextMode="Date"></asp:TextBox> </td> <td rowspan="2"><asp:ImageButton ID="Button1" runat="server" Text="Refresh" ImageUrl="~/Images/Refresh.png" /> </td> </tr> <tr> <td>Employee name: <asp:TextBox ID="name" runat="server" TextMode="Search"></asp:TextBox> </td> </tr> </table> <br /> </div> <div class="center"> <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1" CellPadding="4" ForeColor="#333333" style="margin: 0 auto;" AllowPaging="True" AllowSorting="True" PageSize="30"> <AlternatingRowStyle BackColor="White" ForeColor="#284775" /> <Columns> <asp:BoundField DataField="FEVENTTYPEID" HeaderText="Event type" SortExpression="FEVENTTYPEID" /> <asp:BoundField DataField="FINITOBJNAME" HeaderText="Check point" SortExpression="FINITOBJNAME" /> <asp:BoundField DataField="FREGISTERTIME" HeaderText="Date & time" SortExpression="FREGISTERTIME" /> <asp:BoundField DataField="FHOLDERNAME" HeaderText="Short name" SortExpression="FHOLDERNAME" /> <asp:BoundField DataField="FLASTNAME" HeaderText="Last name" SortExpression="FLASTNAME" /> <asp:BoundField DataField="FFIRSTNAME" HeaderText="First name" SortExpression="FFIRSTNAME" /> <asp:BoundField DataField="FMIDDLENAME" HeaderText="Midlle name" SortExpression="FMIDDLENAME" /> </Columns> <EditRowStyle BackColor="#999999" /> <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" /> <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" /> <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" /> <RowStyle BackColor="#F7F6F3" ForeColor="#333333" /> <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" /> <SortedAscendingCellStyle BackColor="#E9E7E2" /> <SortedAscendingHeaderStyle BackColor="#506C8C" /> <SortedDescendingCellStyle BackColor="#FFFDF8" /> <SortedDescendingHeaderStyle BackColor="#6F8DAE" /> </asp:GridView> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ModMas %>" SelectCommand="select * from hr.dbo.vi_srdc_check_card_log where flastname+' '+ffirstname+' '+fmiddlename like '%' + @name +'%' and FREGISTERTIME between @fromdate + ' 00:00:00' and @todate + ' 23:59:59'"> <SelectParameters> <asp:ControlParameter ControlID="name" DefaultValue="% " Name="name" PropertyName="Text" /> <asp:ControlParameter ControlID="fromdate" DefaultValue='' Name="fromdate" PropertyName="Text" /> <asp:ControlParameter ControlID="todate" DefaultValue='' Name="todate" PropertyName="Text" /> </SelectParameters> </asp:SqlDataSource> </div> </form> </body> </html>