/
ivan
/
ModMas
Обзор
Документация
Войти
/
ivan
/
ModMas
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
main
ModuleMaster/fi/fggrlistsum.aspx
124 строки
6 KB
i.krivokon
Initial commit
13 мар 2026, 13:49
13 мар 2026, 13:49
00d9fb6
Код
Авторство
О чём код?
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="fggrlistsum.aspx.vb" Inherits="FI_fggrlistsum" %> <%@ Register Src="~/FI/fimenu.ascx" TagPrefix="uc1" TagName="fimenu" %> <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title>GI by GTD summary</title> <link href="../Styles/page.css" rel="stylesheet" /> <link href="../Styles/editableGrid1.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> <uc1:fimenu runat="server" ID="fimenu" /> <asp:Panel ID="headerPanel" runat="server" CssClass ="center" DefaultButton ="ibrefresh"> Gtd: <asp:TextBox ID="searchGtd" runat="server" TextMode ="Search"></asp:TextBox> Invoice: <asp:TextBox ID="searchInvoice" runat="server" TextMode ="Search"></asp:TextBox> Material: <asp:TextBox ID="searchMaterial" runat="server" TextMode ="Search"></asp:TextBox> <asp:ImageButton ID="ibRefresh" runat="server" ImageUrl="../Images/Refresh.png" /> <asp:ImageButton ID="ibPrint" runat="server" ImageUrl="../Images/Buttons/24/Print.png" /> <%-- <img id="print" alt="Print" src="../Images/Buttons/24/Print.png" class="click" />--%> </asp:Panel> <asp:Panel ID ="messagePanel" CssClass="center" runat ="server"> <asp:Label runat ="server" ID="message"></asp:Label> </asp:Panel> <br /> <asp:Panel ID="bodyPanel" runat="server" CssClass ="center"> <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" CellPadding="4" DataSourceID="sdsGTDGIListSummary" ForeColor="#333333" PageSize="25"> <AlternatingRowStyle BackColor="White" /> <Columns> <asp:BoundField DataField="gtd" HeaderText="gtd" SortExpression="gtd" /> <asp:BoundField DataField="inv" HeaderText="inv" SortExpression="inv" /> <asp:BoundField DataField="material" HeaderText="material" SortExpression="material" /> <asp:BoundField DataField="model" HeaderText="model" SortExpression="model" /> <asp:BoundField DataField="ORDER_DATE" HeaderText="ORDER_DATE" SortExpression="ORDER_DATE" /> <asp:BoundField DataField="TOTAL_PROD" HeaderText="TOTAL_PROD" ReadOnly="True" SortExpression="TOTAL_PROD" > </asp:BoundField> <asp:BoundField DataField="GI_BY_GTD_QTY" HeaderText="GI_BY_GTD_QTY" ReadOnly="True" SortExpression="GI_BY_GTD_QTY" > </asp:BoundField> <asp:BoundField DataField="FG_GR_DOCUMENT_NUMBER" HeaderText="FG_GR_DOCUMENT_NUMBER" SortExpression="FG_GR_DOCUMENT_NUMBER" > </asp:BoundField> <asp:TemplateField> <ItemTemplate> <asp:CheckBox ID="CheckBox1" CssClass="check" runat="server" ToolTip='<%# Eval("gtd") & "|" & Eval("inv") & "|" & Eval("material") %>' /> </ItemTemplate> </asp:TemplateField> </Columns> <EditRowStyle BackColor="#2461BF" /> <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" /> <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" /> <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" /> <RowStyle BackColor="#EFF3FB" /> <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" /> <SortedAscendingCellStyle BackColor="#F5F7FB" /> <SortedAscendingHeaderStyle BackColor="#6D95E1" /> <SortedDescendingCellStyle BackColor="#E9EBEF" /> <SortedDescendingHeaderStyle BackColor="#4870BE" /> </asp:GridView> <asp:SqlDataSource ID="sdsGTDGIListSummary" runat="server" ConnectionString="<%$ ConnectionStrings:ModMas %>" SelectCommand="select gtd, inv, material, model, ORDER_DATE, sum(cast(po_qty as decimal(18,0))) as TOTAL_PROD, sum(gi_qty) as GI_BY_GTD_QTY, FG_GR_DOCUMENT_NUMBER, REPLACE(ORDER_DATE,'-','') + '-' + UserModules.dbo.f_pad_left(cast((ABS(CHECKSUM(NewId())) %10000) as varchar),4,'0') as to_print_doc_no FROM ( select gtd, inv, material, aufnr, model, ORDER_DATE, MAX(QUANTITY) as po_qty, sum(cast (VSOLM as numeric)) as GI_QTY, FG_GR_DOCUMENT_NUMBER from UserModules.[user].[WMS_GI_INFORMATION] where QUANTITY <> '' AND gtd <> '' and mvt='261' and gtd like '%' + @gtd + '%' and material like '%' + @material + '%' and inv like '%' + @invoice + '%' group by gtd, inv, material, aufnr, model, ORDER_DATE, FG_GR_DOCUMENT_NUMBER ) t1 group by gtd, inv, material, model, ORDER_DATE, FG_GR_DOCUMENT_NUMBER"> <SelectParameters> <asp:ControlParameter ControlID="searchGtd" DefaultValue="%" Name="gtd" PropertyName="Text" /> <asp:ControlParameter ControlID="searchMaterial" DefaultValue="%" Name="material" PropertyName="Text" /> <asp:ControlParameter ControlID="searchInvoice" DefaultValue="%" Name="invoice" PropertyName="Text" /> </SelectParameters> </asp:SqlDataSource> </asp:Panel> <script type="text/javascript"> $("#print").click(function () { console.log("!!!"); $(".check").each(function () { //$(this).children(0).val($("#select_all").is(':checked')); if ($(this).children(0).prop("checked") == true) { console.log($(this).attr("title")); } }) }) </script> </div> </form> </body> </html>