/
ivan
/
ModMas
Обзор
Документация
Войти
/
ivan
/
ModMas
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
main
ModuleMaster/mm/plan_with_key_materials_print.aspx
96 строк
5 KB
i.krivokon
Initial commit
13 мар 2026, 13:49
13 мар 2026, 13:49
00d9fb6
Код
Авторство
О чём код?
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="plan_with_key_materials_print.aspx.vb" Inherits="MM_plan_with_key_materials" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title></title> <style type="text/css"> body{ font-family : Arial; font-size : 8pt;} table {margin: 0 auto;} </style> </head> <body> <form id="form1" runat="server"> <div> </div> <div> <asp:GridView ID="GridView1" runat="server" DataSourceID="sdsReport" AutoGenerateColumns="False" BackColor="White" BorderColor="#DEDFDE" BorderStyle="None" BorderWidth="1px" CellPadding="4" ForeColor="Black" GridLines="Vertical"> <AlternatingRowStyle BackColor="White" /> <Columns> <asp:BoundField DataField="line" HeaderText="Line" SortExpression="line" /> <asp:BoundField DataField="model" HeaderText="Model" SortExpression="model" /> <asp:BoundField DataField="version" HeaderText="Version" SortExpression="version" /> <asp:BoundField DataField="start_time" HeaderText="Start time" SortExpression="start_time" /> <asp:BoundField DataField="order" HeaderText="Order" SortExpression="order" /> <asp:BoundField DataField="qty" HeaderText="Plan qty" SortExpression="qty" /> <asp:BoundField DataField="panel" HeaderText="Panel" SortExpression="panel" /> <asp:BoundField DataField="ip_smps" HeaderText="IP/SMPS" SortExpression="ip_smps" /> <asp:BoundField DataField="speaker" HeaderText="Speaker" SortExpression="speaker" /> <asp:BoundField DataField="stand" HeaderText="Stand" SortExpression="stand" /> <asp:BoundField DataField="v1" HeaderText="Vedor" ReadOnly="True" SortExpression="v1" /> <asp:BoundField DataField="front" HeaderText="Front" SortExpression="front" /> <asp:BoundField DataField="v2" HeaderText="Vendor" ReadOnly="True" SortExpression="v2" /> <asp:BoundField DataField="rear" HeaderText="Rear" SortExpression="rear" /> <asp:BoundField DataField="v3" HeaderText="Vendor" ReadOnly="True" SortExpression="v3" /> </Columns> <FooterStyle BackColor="#CCCC99" /> <HeaderStyle BackColor="#6B696B" Font-Bold="True" ForeColor="White" /> <PagerStyle BackColor="#F7F7DE" ForeColor="Black" HorizontalAlign="Right" /> <RowStyle BackColor="#F7F7DE" /> <SelectedRowStyle BackColor="#CE5D5A" Font-Bold="True" ForeColor="White" /> <SortedAscendingCellStyle BackColor="#FBFBF2" /> <SortedAscendingHeaderStyle BackColor="#848384" /> <SortedDescendingCellStyle BackColor="#EAEAD3" /> <SortedDescendingHeaderStyle BackColor="#575357" /> </asp:GridView> <asp:SqlDataSource ID="sdsReport" runat="server" ConnectionString="<%$ ConnectionStrings:SAPDataConnectionString %>" SelectCommand="select * from ( select t1.line, t1.model, t1.version, t1.start_time, t1.po as 'order', t1.qty, case t2.panel WHEN '' THEN t2.lcm_assy else t2.panel end as panel, t2.ip_smps, t2.speaker, t2.stand, (select top 1 vendor from UserModules.[user].MATERIAL_MASTER_WITH_VENDOR where material=t2.stand) as v1, t2.front, (select top 1 vendor from UserModules.[user].MATERIAL_MASTER_WITH_VENDOR where material=t2.front) as v2, case t2.rear when '' then t2.assy_cover_pmiddle else t2.rear end as rear, (select top 1 vendor from UserModules.[user].MATERIAL_MASTER_WITH_VENDOR where material= (case t2.rear when '' then t2.assy_cover_pmiddle else t2.rear end )) as v3 from daily_plan_with_version t1 left join key_material_list t2 on t1.model = t2.model where t1.plan_date = @plan_date and t1.line like @line and t1.model like @model ) ttt where ttt.v1 like @vendor or ttt.v2 like @vendor or ttt.v3 like @vendor order by line"> <SelectParameters> <asp:QueryStringParameter DefaultValue="%" Name="plan_date" QueryStringField="plan_date" /> <asp:QueryStringParameter DefaultValue="%" Name="line" QueryStringField="line" /> <asp:QueryStringParameter DefaultValue="%" Name="model" QueryStringField="model" /> <asp:QueryStringParameter DefaultValue="%" Name="vendor" QueryStringField="vendor" /> </SelectParameters> </asp:SqlDataSource> </div> </form> </body> </html>