📄 stock_search.aspx
字号:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Stock_Search.aspx.cs" Inherits="查询统计_Default" %>
<%@ Register Assembly="CustomControlFreak" Namespace="CustomControlFreak" TagPrefix="cc1" %>
<!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 style="vertical-align: middle; text-align: center">
<asp:Label ID="Label2" runat="server" Style="font-size: smaller; color: #990000"></asp:Label><br />
<br />
<table style="border-collapse: collapse; text-align: center;">
<tr>
<td style="width: 100px; height: 26px; text-align: center;">
<asp:CheckBox ID="CheckBox1" runat="server" Text="供应商" Font-Size="Small" AutoPostBack="True" OnCheckedChanged="CheckBox1_CheckedChanged" style="left: 8px; position: relative" /></td>
<td style="width: 170px; text-align: left;">
<asp:TextBox ID="CompanyID" runat="server" Width="100px" Enabled="False"></asp:TextBox></td>
<td style="width: 90px; height: 26px; text-align: left;">
<asp:CheckBox ID="CheckBox2" runat="server" Text="商品名称" Font-Size="Small" AutoPostBack="True" OnCheckedChanged="CheckBox2_CheckedChanged" /></td>
<td style="text-align: left; width: 221px;">
<asp:TextBox ID="CommodityName" runat="server" Width="200px" Enabled="False"></asp:TextBox></td>
<td style="width: 62px; height: 26px; text-align: left;">
<asp:Button ID="btnselect" runat="server" Text="查询" OnClick="btnselect_Click" /></td>
</tr>
<tr>
<td style="height: 16px; text-align: center;">
<asp:CheckBox ID="CheckBox3" runat="server" Text="经手人" Font-Size="Small" AutoPostBack="True" OnCheckedChanged="CheckBox3_CheckedChanged" style="left: 8px; position: relative" /></td>
<td style="text-align: left;">
<asp:TextBox ID="ManageMan" runat="server" Width="100px" Enabled="False"></asp:TextBox></td>
<td style="width: 90px; text-align: left;">
<asp:CheckBox ID="CheckBox4" runat="server" Text="起止日期" Font-Size="Small" AutoPostBack="True" /></td>
<td style="height: 16px; text-align: left; width: 221px;">
<cc1:DaintyDate ID="DaintyDate1" runat="server" CalendarType="JustTextBox" Width="54px" EnableTextBox="False" />
至
<cc1:DaintyDate ID="DaintyDate2" runat="server" CalendarType="JustTextBox" Width="94px" />
</td>
<td style="height: 16px; width: 62px; text-align: left;">
<asp:Button ID="btnback" runat="server" Text="返回" OnClick="btnback_Click" /></td>
</tr>
<tr>
<td colspan="5" style="vertical-align: top; text-align: center;" rowspan="2">
<asp:GridView ID="GridView1" runat="server" style="font-size: smaller; vertical-align: top; text-align: center;" DataSourceID="SqlDataSource1" CellPadding="4" ForeColor="#333333" GridLines="None" Width="670px" AllowPaging="True" AutoGenerateColumns="False" DataKeyNames="id" OnPageIndexChanging="GridView1_PageIndexChanging" OnSelectedIndexChanged="GridView1_SelectedIndexChanged" OnSelectedIndexChanging="GridView1_SelectedIndexChanging" Font-Size="12pt">
<FooterStyle BackColor="#507CD1" 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:BoundField DataField="CommodityName" HeaderText="商品名称" SortExpression="CommodityName" />
<asp:BoundField DataField="CompanyName" HeaderText="供应商" SortExpression="CompanyName" />
<asp:BoundField DataField="ManageMan" HeaderText="经手人" SortExpression="ManageMan" />
<asp:BoundField DataField="Number" HeaderText="数量" SortExpression="Number" />
<asp:BoundField DataField="StockDate" HeaderText="日期" SortExpression="StockDate" DataFormatString="{0:d}" HtmlEncode=False/>
<asp:CommandField SelectText="详细信息" ShowSelectButton="True" HeaderText="详细信息" />
<asp:BoundField DataField="id" HeaderText="id" InsertVisible="False" ReadOnly="True"
SortExpression="id" Visible="False" />
</Columns>
</asp:GridView>
</td>
</tr>
<tr>
</tr>
</table>
</div>
<script type="text/javascript">
var textDaintyDate1 = document.getElementById("txtDaintyDate1");
var textDaintyDate2 = document.getElementById("txtDaintyDate2");
textDaintyDate1.style.width = "75px";
textDaintyDate2.style.width = "75px";
</script>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:db_sellConnectionString %>" SelectCommand="SELECT dbo.tb_Company.CompanyName, dbo.tb_Commodity.CommodityName, dbo.tb_Stock.id, dbo.tb_Stock.Number, dbo.tb_Stock.ManageMan,dbo.tb_Stock.StockDate FROM dbo.tb_Company INNER JOIN dbo.tb_Commodity ON dbo.tb_Company.id = dbo.tb_Commodity.CompanyID INNER JOIN dbo.tb_Stock ON dbo.tb_Commodity.id = dbo.tb_Stock.CommodityID WHERE dbo.tb_Stock.Type='"+Label1.Text+"'" ProviderName="<%$ ConnectionStrings:db_sellConnectionString4.ProviderName %>">
</asp:SqlDataSource>
<asp:Label ID="Label1" runat="server" Text="Label" Visible="False"></asp:Label>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -