/
ivan
/
ModMas
Обзор
Документация
Войти
/
ivan
/
ModMas
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
main
ModuleMaster/hr/restaurant.aspx
118 строк
6 KB
i.krivokon
Initial commit
13 мар 2026, 13:49
13 мар 2026, 13:49
00d9fb6
Код
Авторство
О чём код?
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="restaurant.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> <style type="text/css"> .auto-style1 { width: 24px; height: 24px; } </style> </head> <body> <form id="form1" runat="server"> <div class="center"> Company: <asp:DropDownList runat="server" ID="company" DataSourceID="sdsCompany" DataTextField="companyname" DataValueField="companyname" AutoPostBack="True"></asp:DropDownList> <asp:SqlDataSource ID="sdsCompany" runat="server" ConnectionString="<%$ ConnectionStrings:ModMas %>" SelectCommand="select DISTINCT companyname from [user].[RESTAURANT_STATISTICS] ORDER BY COMPANYNAME"></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" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" DataSourceID="sdsRestStat" PageSize="30"> <Columns> <asp:BoundField DataField="companyname" HeaderText="Company " SortExpression="companyname" /> <asp:BoundField DataField="employeeno" HeaderText="GEN" SortExpression="employeeno" /> <asp:BoundField DataField="employeename" HeaderText="Name" SortExpression="employeename" /> <asp:BoundField DataField="Quantity" HeaderText="Quantity" ReadOnly="True" SortExpression="Quantity"> <ItemStyle HorizontalAlign="Right" /> </asp:BoundField> <asp:BoundField DataField="Cost" HeaderText="Cost (RUB)" ReadOnly="True" SortExpression="Cost"> <ItemStyle HorizontalAlign="Right" /> </asp:BoundField> </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 companyname, employeeno, employeename, count (*) as Quantity, sum(cost) as Cost FROM [user].[RESTAURANT_STATISTICS] WHERE companyname = @company and procdate between @fromdate and @todate group by companyname, employeeno, employeename"> <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>