/
ivan
/
ModMas
Обзор
Документация
Войти
/
ivan
/
ModMas
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
main
ModuleMaster/fi/fifo_account_list.aspx
100 строк
5 KB
i.krivokon
Initial commit
13 мар 2026, 13:49
13 мар 2026, 13:49
00d9fb6
Код
Авторство
О чём код?
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="fifo_account_list.aspx.vb" Inherits="FI_fifo_account_list" %> <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title>Document list by GTD and account</title> <link href="../Styles/page.css" rel="stylesheet" /> <link href="../Styles/Site.css" rel="stylesheet" /> <script src="../Scripts/jquery-1.9.1.min.js"></script> </head> <body> <form id="form1" runat="server"> <div> GTD: <asp:TextBox ID="gtd" runat="server" ClientIDMode="Static" ></asp:TextBox> Acocunt: <asp:DropDownList ID="account" runat="server" ClientIDMode="Static" DataSourceID="SqlDataSource2" DataTextField="from_account" DataValueField="from_account"></asp:DropDownList> <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:ModMas %>" SelectCommand="SELECT DISTINCT from_account FROM UserMOdules.[user].mvt_vs_account_mapping WHERE Enabled = 'Y' UNION SELECT DISTINCT to_account FROM UserMOdules.[user].mvt_vs_account_mapping WHERE Enabled = 'Y'"></asp:SqlDataSource> <%--Movement: <asp:DropDownList ID="movement" runat="server"></asp:DropDownList>--%> <asp:ImageButton ID="Button1" runat="server" Text="Refresh" ImageUrl="~/Images/Refresh.png" /> <asp:Image ID="Print" runat="server" Text="Print" ClientIDMode="Static" ImageUrl="~/Images/Buttons/24/Print.png" CssClass ="click"/> <hr /> <asp:GridView ID="report" runat="server" AutoGenerateColumns="False" CellPadding="4" DataSourceID="SqlDataSource1" ForeColor="#333333" ShowHeaderWhenEmpty="True"> <AlternatingRowStyle BackColor="White" /> <Columns> <asp:BoundField DataField="MAT__DOC_" HeaderText="MAT__DOC_" SortExpression="MAT__DOC_" /> <asp:BoundField DataField="MATERIAL" HeaderText="MATERIAL" SortExpression="MATERIAL" /> <asp:BoundField DataField="PSTNG_DATE" HeaderText="PSTNG_DATE" SortExpression="PSTNG_DATE" /> <asp:BoundField DataField="MVT" HeaderText="MVT" SortExpression="MVT" /> <asp:BoundField DataField="Sloc" HeaderText="Sloc" SortExpression="Sloc" /> <asp:BoundField DataField="QUANTITY" HeaderText="QUANTITY" SortExpression="QUANTITY" ReadOnly="True" /> <asp:BoundField DataField="AMOUNT_IN_LC" HeaderText="AMOUNT_IN_LC" SortExpression="AMOUNT_IN_LC" ReadOnly="True" /> <asp:BoundField DataField="REMARK" HeaderText="REMARK" SortExpression="REMARK" ReadOnly="True" /> <asp:BoundField DataField="REFERENCE" HeaderText="REFERENCE" SortExpression="REFERENCE" ReadOnly="True" /> <asp:BoundField DataField="FROM_ACCOUNT" HeaderText="FROM_ACCOUNT" SortExpression="FROM_ACCOUNT" /> <asp:BoundField DataField="TO_ACCOUNT" HeaderText="TO_ACCOUNT" SortExpression="TO_ACCOUNT" /> </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="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ModMas %>" SelectCommand=" SELECT T1.MAT__DOC_ , T1.MATERIAL , T1.PSTNG_DATE , T1.MVT , T1.Sloc , SUM(cast(T1.QUANTITY as integer)) as QUANTITY , SUM(cast(T1.AMOUNT_IN_LC as decimal(18,2)) ) as AMOUNT_IN_LC , ISNULL(T1.REMARK , T1.REFERENCE_GTD + ':::' + QUANTITY) as REMARK , T1.REFERENCE , T2.FROM_ACCOUNT , T2.TO_ACCOUNT FROM UserModules.[user].[GERP_MB_51_FOR_GTD] T1 LEFT JOIN UserModules.[user].MVT_VS_ACCOUNT_MAPPING T2 ON T1.MVT = T2.MOVEMENT_TYPE WHERE REFERENCE_GTD like '%' + @GTD + '%' AND (T2.FROM_ACCOUNT = @ACC OR T2.TO_ACCOUNT = @ACC) GROUP BY T1.MAT__DOC_ , T1.MATERIAL , T1.PSTNG_DATE , T1.MVT , T1.SLoc , ISNULL(T1.REMARK , T1.REFERENCE_GTD + ':::' + QUANTITY) , T1.REFERENCE , T2.FROM_ACCOUNT , T2.TO_ACCOUNT ORDER BY PSTNG_DATE, MAT__DOC_ "> <SelectParameters> <asp:ControlParameter ControlID="gtd" Name="GTD" PropertyName="Text" /> <asp:ControlParameter ControlID="account" Name="ACC" PropertyName="SelectedValue" /> </SelectParameters> </asp:SqlDataSource> </div> <script> $("#Print").click(function () { console.log($("#account").val()); console.log($("#gtd").val()); window.open('fifo_account_card.aspx?gtd=' + $("#gtd").val() + '&acc=' + $("#account").val(), '_blank'); }) </script> </form> </body> </html>