/
ivan
/
ModMas
Обзор
Документация
Войти
/
ivan
/
ModMas
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
main
ModuleMaster/fi/gilistsum.aspx
177 строк
10 KB
i.krivokon
Initial commit
13 мар 2026, 13:49
13 мар 2026, 13:49
00d9fb6
Код
Авторство
О чём код?
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="gilistsum.aspx.vb" Inherits="FI_gilistsum" EnableEventValidation ="false" %> <%@ 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> </head> <body> <form id="form1" runat="server"> <div> <uc1:fimenu runat="server" ID="fimenu" /> <asp:Panel ID="headerPanel" runat="server" CssClass ="center" DefaultButton ="ibrefresh"> <div> Year: <asp:TextBox ID="searchYear" runat="server" TextMode ="Search" Width="50"></asp:TextBox> Gtd: <asp:TextBox ID="searchGtd" runat="server" TextMode ="Search" Width="150"></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="ibWhGr" runat="server" ImageUrl="../Images/Buttons/24/PrintGreen.png" ToolTip ="Print WH GR Documents" /> <asp:ImageButton ID="ibGiToProd" runat="server" ImageUrl="../Images/Buttons/24/Print.png" ToolTip ="Print GI to Production Documents" /> <asp:ImageButton ID="ibFgGr" runat="server" ImageUrl="../Images/Buttons/24/PrintPurple.png" ToolTip ="Print FG GR Documents" /> <asp:ImageButton ID="ImageButton2" runat="server" ImageUrl="../Images/Microsoft Office 2003 Excel.png" ToolTip ="Print FG GR Documents" Height ="28" Width ="28" /> </div> <div> <asp:CheckBox ID="onlyInvEqGi" runat ="server" Text ="Show only Invoice QTY = GI Qty" Checked ="true" AutoPostBack="True"/> <asp:CheckBox ID="byGtdList" runat ="server" Text ="Check by GTD & Material list" Checked ="false" AutoPostBack="True" Visible="true"/> </div> </asp:Panel> <asp:Panel ID ="messagePanel" CssClass="center" runat ="server"> <asp:Label runat ="server" ID="message" Visible="False"></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" ForeColor="#333333" PageSize="25"> <AlternatingRowStyle BackColor="White" /> <Columns> <asp:BoundField DataField="gtd" HeaderText="GTD No." SortExpression="gtd" /> <asp:BoundField DataField="inv" HeaderText="Invoice" SortExpression="inv" /> <asp:BoundField DataField="material" HeaderText="Material" SortExpression="material" /> <asp:BoundField DataField="description" HeaderText="Description" SortExpression="description" /> <asp:BoundField DataField="iv_date" HeaderText="Invoice date" SortExpression="iv_date" /> <asp:BoundField DataField="GI_QTY" HeaderText="GI qty" ReadOnly="True" SortExpression="GI_QTY" > <ItemStyle HorizontalAlign="Right" /> </asp:BoundField> <asp:BoundField DataField="INVOICE_QTY" HeaderText="Invoice qty" ReadOnly="True" SortExpression="INVOICE_QTY" > <ItemStyle HorizontalAlign="Right" /> </asp:BoundField> <asp:BoundField DataField="INVOICE_AMNT" HeaderText="Invoice amount" ReadOnly="True" SortExpression="INVOICE_AMNT" DataFormatString="{0:n}" > <ItemStyle HorizontalAlign="Right" /> </asp:BoundField> <asp:BoundField DataField="currency" HeaderText="Curr." ReadOnly="True" SortExpression="currency" /> <asp:BoundField DataField="exch_rate" HeaderText="Exchange rate" ReadOnly="True" SortExpression="exch_rate" > <ItemStyle HorizontalAlign="Right" /> </asp:BoundField> <asp:BoundField DataField="Amount_RUB" HeaderText="Amount RUB" ReadOnly="True" SortExpression="Amount_RUB" DataFormatString="{0:n}" > <ItemStyle HorizontalAlign="Right" /> </asp:BoundField> <asp:BoundField DataField="PRINT_DOCUMENT_NUMBER" HeaderText="GI Doc" ReadOnly="True" SortExpression="PRINT_DOCUMENT_NUMBER" > <ItemStyle HorizontalAlign="Right" /> </asp:BoundField> <asp:BoundField DataField="FG_GR_DOCUMENT_NUMBER" HeaderText="FG GR Doc" ReadOnly="True" SortExpression="FG_GR_DOCUMENT_NUMBER" > <ItemStyle HorizontalAlign="Right" /> </asp:BoundField> <asp:BoundField DataField="GR_DOCUMENT_NUMBER" HeaderText="GR Doc" ReadOnly="True" SortExpression="GR_DOCUMENT_NUMBER" > <ItemStyle HorizontalAlign="Right" /> </asp:BoundField> <asp:TemplateField> <HeaderTemplate > <asp:CheckBox ID="CheckBox0" CssClass="click" runat="server" ToolTip="Select all" /> </HeaderTemplate> <ItemTemplate> <asp:CheckBox ID="CheckBox1" CssClass="check" runat="server" ToolTip='<%# Eval("gtd") & "|" & Eval("inv") & "|" & Eval("material") & "|" & Eval("WENUM")%>' /> </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 t1.*, t1.exch_rate * t1.invoice_amnt as Amount_RUB from ( SELECT gtd, inv, material, description, iv_date, sum(cast (VSOLM as numeric) )as GI_QTY, max(INVOICE_QTY) as INVOICE_QTY, max( case INVOICE_AMNT when '' then 0 else cast (replace(replace(INVOICE_AMNT,',','.'),' ','') as decimal (18,3)) end ) as INVOICE_AMNT, max(curr) as currency, max(exch__rate__rub) as exch_rate, (SELECT STUFF(( SELECT DISTINCT (',' + PRINT_DOCUMENT_NUMBER) FROM UserModules.[user].WMS_GI_INFORMATION WHERE gtd = WGI.gtd AND material = WGI.material AND inv = WGI.inv FOR XML PATH ('')), 1, 1, '' )) as PRINT_DOCUMENT_NUMBER, (SELECT STUFF(( SELECT DISTINCT (',' + FG_GR_DOCUMENT_NUMBER) FROM UserModules.[user].WMS_GI_INFORMATION WHERE gtd = WGI.gtd AND material = WGI.material AND inv = WGI.inv FOR XML PATH ('')), 1, 1, '' )) as FG_GR_DOCUMENT_NUMBER, (SELECT STUFF(( SELECT DISTINCT (',' + GR_DOCUMENT_NUMBER) FROM UserModules.[user].WMS_GI_INFORMATION WHERE gtd = WGI.gtd AND material = WGI.material AND inv = WGI.inv FOR XML PATH ('')), 1, 1, '' )) as GR_DOCUMENT_NUMBER, WENUM FROM UserModules.[user].[WMS_GI_INFORMATION] WGI where gtd <> '' group by gtd, material, inv, description, iv_date, WENUM -- having sum(cast (VSOLM as decimal(18,2))) = max(INVOICE_QTY) ) t1 WHERE t1.gtd like '%' + @gtd + '%' and t1.material like '%' + @material + '%' and t1.inv like '%' + @invoice + '%' and t1.iv_date like '%' + @iv_date + '%'"> <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" /> <asp:ControlParameter ControlID="searchYear" DefaultValue="%" Name="iv_date" PropertyName="Text" /> </SelectParameters> </asp:SqlDataSource> </asp:Panel> <script type="text/javascript"> $("#GridView1_ctl01_CheckBox0").on("click", function () { $(".check").each(function () { $(this).children(0).prop("checked",$("#GridView1_ctl01_CheckBox0").prop("checked") == true); }) }) </script> </div> </form> </body> </html>