/
ivan
/
ModMas
Обзор
Документация
Войти
/
ivan
/
ModMas
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
main
ModuleMaster/qc/lpr_price_check.aspx
51 строка
2 KB
i.krivokon
Initial commit
13 мар 2026, 13:49
13 мар 2026, 13:49
00d9fb6
Код
Авторство
О чём код?
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="lpr_price_check.aspx.vb" Inherits="QC_lpr_price_check" %> <!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> <link href="../Styles/Site.css" rel="stylesheet" type="text/css" /> <style type="text/css"> table{margin: 0 auto;} </style> </head> <body> <form id="form1" runat="server"> <div> <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" BackColor="White" BorderColor="#E7E7FF" BorderStyle="None" BorderWidth="1px" CellPadding="3" DataSourceID="sdsPriceCheck" GridLines="Horizontal"> <AlternatingRowStyle BackColor="#F7F7F7" /> <Columns> <asp:BoundField DataField="id" HeaderText="id" InsertVisible="False" ReadOnly="True" SortExpression="id" /> <asp:BoundField DataField="model" HeaderText="model" SortExpression="model" /> <asp:BoundField DataField="code" HeaderText="code" ReadOnly="True" SortExpression="code" /> <asp:BoundField DataField="price" HeaderText="price" SortExpression="price" /> </Columns> <FooterStyle BackColor="#B5C7DE" ForeColor="#4A3C8C" /> <HeaderStyle BackColor="#4A3C8C" Font-Bold="True" ForeColor="#F7F7F7" /> <PagerStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" HorizontalAlign="Right" /> <RowStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" /> <SelectedRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="#F7F7F7" /> <SortedAscendingCellStyle BackColor="#F4F4FD" /> <SortedAscendingHeaderStyle BackColor="#5A4C9D" /> <SortedDescendingCellStyle BackColor="#D8D8F0" /> <SortedDescendingHeaderStyle BackColor="#3E3277" /> </asp:GridView> <asp:SqlDataSource ID="sdsPriceCheck" runat="server" ConnectionString="<%$ ConnectionStrings:SERKIntranetConnectionString %>" SelectCommand="select tt.id, t.model,t.code,tt.price from ( SELECT distinct model, SUBSTRING(model, 3, 7) as code FROM [usermodules].[user].[2013_LPR_SAMPLES_EVALUATION_GRADE] ) t left join [usermodules].[user].[2013_lpr_sample_price] tt on t.code = tt.code order by t.code "></asp:SqlDataSource> </div> </form> </body> </html>