/
ivan
/
ModMas
Обзор
Документация
Войти
/
ivan
/
ModMas
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
main
ModuleMaster/hr/restaurant01.aspx
127 строк
7 KB
i.krivokon
Initial commit
13 мар 2026, 13:49
13 мар 2026, 13:49
00d9fb6
Код
Авторство
О чём код?
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="restaurant01.aspx.vb" Inherits="HR_restaurant" %> <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title>Restaurant statistics</title> <link href="../Styles/page.css" rel="stylesheet" /> <script src="../Scripts/jquery-1.9.1.min.js"></script> </head> <body> <form id="form1" runat="server"> <div class="center"> Company: <asp:DropDownList runat="server" ID="company" DataSourceID="sdsCompany" DataTextField="company" DataValueField="company" AutoPostBack="True"></asp:DropDownList> <asp:SqlDataSource ID="sdsCompany" runat="server" ConnectionString="<%$ ConnectionStrings:ModMas %>" SelectCommand=" select DISTINCT company from [user].OUTSOURCING_PERSONAL_DATA ORDER BY COMPANY"></asp:SqlDataSource> Period: <asp:TextBox runat="server" ID="fromDate" TextMode="Date" Width="130px"></asp:TextBox>~<asp:TextBox runat="server" ID="toDate" TextMode="Date" Width="130px" ></asp:TextBox> <asp:Button runat="server" ID="refresh" Text ="Refresh" /> <asp:Button runat="server" ID="excel" Text="Excel" /> <hr /> </div> <div> <asp:GridView ID="GridView1" runat="server" BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" CellPadding="5" AllowSorting="True" AutoGenerateColumns="False" PageSize="30" DataKeyNames="id" DataSourceID="sdsRestStat"> <Columns> <asp:BoundField DataField="COMPANY" HeaderText="COMPANY" SortExpression="COMPANY" /> <asp:BoundField DataField="FIO" HeaderText="FIO" SortExpression="FIO" /> <asp:BoundField DataField="BIRTH_DATE" HeaderText="BIRTH DATE" SortExpression="BIRTH_DATE" /> <asp:BoundField DataField="CITIZENSHIP" HeaderText="CITIZENSHIP" SortExpression="CITIZENSHIP" /> <asp:BoundField DataField="RF_ENTRY_DATE_FOR_LAST_12_MONTH" HeaderText="RF ENTRY DATE FORLAST 12 MONTH" SortExpression="RF_ENTRY_DATE_FOR_LAST_12_MONTH" /> <asp:BoundField DataField="DOCUMENT_TYPE" HeaderText="DOCUMENT TYPE" SortExpression="DOCUMENT_TYPE" /> <asp:BoundField DataField="DOCUMENT_NUMBER" HeaderText="DOCUMENT NUMBER" SortExpression="DOCUMENT_NUMBER" /> <asp:BoundField DataField="ISSED_BY" HeaderText="ISSED BY" SortExpression="ISSED_BY" /> <asp:BoundField DataField="ISSUE_DATE" HeaderText="ISSUE DATE" SortExpression="ISSUE_DATE" /> <asp:BoundField DataField="ADDRESS" HeaderText="ADDRESS" SortExpression="ADDRESS" /> <asp:BoundField DataField="ACTUAL_ADDRESS" HeaderText="ACTUAL ADDRESS" SortExpression="ACTUAL_ADDRESS" /> <asp:BoundField DataField="INN" HeaderText="INN" SortExpression="INN" /> <asp:BoundField DataField="GEN" HeaderText="GEN" SortExpression="GEN" /> <asp:BoundField DataField="Quantity" HeaderText="Quantity" SortExpression="Quantity" ReadOnly="True" /> <asp:BoundField DataField="Cost" HeaderText="Cost" SortExpression="Cost" ReadOnly="True" /> </Columns> <FooterStyle BackColor="White" ForeColor="#000066" /> <HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" /> <PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" /> <RowStyle ForeColor="#000066" /> <AlternatingRowStyle BackColor ="#EFEFEF" ForeColor="#000066" /> <SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" /> <SortedAscendingCellStyle BackColor="#F1F1F1" /> <SortedAscendingHeaderStyle BackColor="#007DBB" /> <SortedDescendingCellStyle BackColor="#CAC9C9" /> <SortedDescendingHeaderStyle BackColor="#00547E" /> </asp:GridView> <asp:SqlDataSource ID="sdsRestStat" runat="server" ConnectionString="<%$ ConnectionStrings:ModMas %>" SelectCommand="select * from ( select *, case gen when 0 then 999 else GEN end as idd from [user].OUTSOURCING_PERSONAL_DATA where company = @company ) t1 left join ( SELECT companyname, employeeno, employeename, count (*) as Quantity, sum(cost) as Cost FROM [user].[RESTAURANT_STATISTICS] WHERE procdate between @fromDate and @toDate group by companyname, employeeno, employeename ) t2 on t1.idd = t2.employeeno"> <SelectParameters> <asp:ControlParameter ControlID="company" Name="company" PropertyName="SelectedValue" /> <asp:ControlParameter ControlID="fromDate" Name="fromdate" PropertyName="Text" /> <asp:ControlParameter ControlID="toDate" Name="todate" PropertyName="Text" /> </SelectParameters> </asp:SqlDataSource> </div> <div id="details" style="background-color: white; display : none; border: 2px solid gray;"> <div class="right"> <img id="closePopup" src="../Images/Cancel.png" class="click"/> </div> <div id="detailsBody"> </div> </div> <script type="text/javascript"> $("#closePopup").click(function () { $("#details").css("display", "none") }) $("#GridView1 tr").dblclick(function () { var request = $.ajax({ url: "reststatbyperson.aspx", data: { gen: $(this).attr("gen"), from: $("#fromDate").val(), to: $("#toDate").val() } }); request.done(showDetails); request.fail(showDetailsFails); }) function showDetails(result) { $("#detailsBody").html(result); centerPopup($("#details")); } function showDetailsFails() { } function centerPopup(popup) { popup.css("display", ""); popup.css("position", "absolute"); popup.css("top", (($(window).height() - popup.outerHeight()) / 2) + $(window).scrollTop() + "px"); popup.css("left", (($(window).width() - popup.outerWidth()) / 2) + $(window).scrollLeft() + "px"); } </script> </form> </body> </html>