📄 stockpile_search.aspx
字号:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="StockPile_search.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 runat="server">
<title>无标题页</title>
</head>
<body style="text-align: center">
<form id="form1" runat="server">
<div>
<span style="font-size: 10pt; color: #990000">查询统计→商品库存查询<br />
</span><br />
<table style="font-size: smaller">
<tr>
<td style="width: 80px; height: 26px;">
<asp:CheckBox ID="commodityname" runat="server" AutoPostBack="True" OnCheckedChanged="commodityname_CheckedChanged"
Text="商品名称" Width="75px" /></td>
<td style="width: 70px; height: 26px;">
<asp:TextBox ID="TextBox1" runat="server" ReadOnly="True" Width="82px"></asp:TextBox></td>
<td style="width: 65px; height: 26px;">
<asp:CheckBox ID="companyid" runat="server" OnCheckedChanged="companyid_CheckedChanged"
Text="供应商" Width="63px" AutoPostBack="True" /></td>
<td style="width: 70px; height: 26px;">
<asp:TextBox ID="TextBox2" runat="server" ReadOnly="True" Width="75px"></asp:TextBox></td>
<td style="width: 70px; height: 26px;">
<asp:Button ID="Button1" runat="server" Text="查询" Width="65px" OnClick="Button1_Click" /></td>
<td style="width: 70px; height: 26px;">
<asp:Button ID="Button2" runat="server" Text="返回" Width="65px" OnClick="Button2_Click" /></td>
</tr>
<tr>
<td colspan="6">
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CellPadding="4"
DataSourceID="SqlDataSource1" GridLines="None" Style="border-right: #003399 0px solid;
border-top: #003399 0px solid; border-left: #003399 0px solid; border-bottom: #003399 0px solid"
Width="500px" AllowPaging="True" OnSelectedIndexChanged="GridView1_SelectedIndexChanged" ForeColor="#333333" OnPageIndexChanging="GridView1_PageIndexChanging">
<FooterStyle BackColor="#507CD1" ForeColor="White" Font-Bold="True" />
<Columns>
<asp:BoundField DataField="CommodityName" HeaderText="商品名称" SortExpression="CommodityName" />
<asp:BoundField DataField="CompanyName" HeaderText="供应商" SortExpression="CompanyName" />
<asp:BoundField DataField="Unit" HeaderText="单位" SortExpression="Unit" />
<asp:BoundField DataField="jinhuo" HeaderText="进货数量" ReadOnly="True" SortExpression="jinhuo" />
<asp:BoundField DataField="xiaoshou" HeaderText="销售数量" ReadOnly="True" SortExpression="xiaoshou" />
<asp:BoundField DataField="kucun" HeaderText="库存" ReadOnly="True" SortExpression="kucun" />
</Columns>
<RowStyle BackColor="#EFF3FB" />
<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" />
<EditRowStyle BackColor="#2461BF" />
</asp:GridView>
</td>
</tr>
</table>
</div>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:db_sellConnectionString %>"
SelectCommand="SELECT [CompanyName], [CommodityName], [xiaoshou], [jinhuo], [kucun], [Unit] FROM [view_2]">
</asp:SqlDataSource>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -