📄 taxis.aspx
字号:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Taxis.aspx.cs" Inherits="_Default" %>
<!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 id="Head1" runat="server">
<title>无标题页</title>
</head>
<body>
<form id="form1" runat="server">
<div style="text-align: center">
<span style="font-size: 10pt; color: #990000">查询统计→商品销售排行<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:db_sellConnectionString3 %>"
SelectCommand="SELECT tb_Commodity.CommodityName, tb_Company.CompanyName, tb_Commodity.Unit, temp.num FROM tb_Commodity INNER JOIN (SELECT CompanyID, CommodityID, SUM(Number * (CASE type WHEN '销售信息' THEN 1 WHEN '销售退货' THEN - 1 ELSE 0 END)) AS num FROM tb_Stock GROUP BY CommodityID, CompanyID) AS temp ON tb_Commodity.id = temp.CommodityID INNER JOIN tb_Company ON temp.CompanyID = tb_Company.id ORDER BY temp.num DESC">
</asp:SqlDataSource>
</span>
<asp:GridView ID="GridView1" runat="server" CellPadding="4" ForeColor="#333333" GridLines="None" Width="400px" AutoGenerateColumns="False" DataSourceID="SqlDataSource2" OnSelectedIndexChanged="GridView1_SelectedIndexChanged" AllowPaging="True" AllowSorting="True" style="font-size: smaller">
<FooterStyle BackColor="#003399" Font-Bold="True" ForeColor="White" />
<RowStyle BackColor="#EFF3FB" />
<EditRowStyle BackColor="#2461BF" />
<SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
<PagerStyle BackColor="#003399" ForeColor="White" HorizontalAlign="Center" />
<HeaderStyle BackColor="#003399" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="White" />
<Columns>
<asp:TemplateField ConvertEmptyStringToNull="False" HeaderText="排行">
<ItemTemplate>
<asp:Label ID="sid" Runat="Server" Text='<%# i++ %>' />
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="CommodityName" HeaderText="商品名" SortExpression="CommodityName" />
<asp:BoundField DataField="CompanyName" HeaderText="供应商" SortExpression="CompanyName" />
<asp:BoundField DataField="Unit" HeaderText="单位" SortExpression="Unit" />
<asp:BoundField DataField="num" HeaderText="销售数量" ReadOnly="True" SortExpression="num" />
</Columns>
</asp:GridView>
</div>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -