📄 supplylist.aspx
字号:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="SupplyList.aspx.cs" Inherits="SupplyMag_SupplyList" %>
<!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="../style/css.css" rel="stylesheet" type="text/css" />
</head>
<body>
<form id="form1" runat="server">
<div>查询条件：<asp:DropDownList ID="DrDpSeaLei" runat="server" Width="175px">
<asp:ListItem Value="all" Selected="True">==显示所有＝＝</asp:ListItem>
<asp:ListItem Value="listid">产品编号</asp:ListItem>
<asp:ListItem Value="Produceskind">产品分类</asp:ListItem>
<asp:ListItem Value="Producesname">产品名称</asp:ListItem>
<asp:ListItem Value="rukutime">入库时间</asp:ListItem>
<asp:ListItem Value="workerid">处理人员</asp:ListItem>
<asp:ListItem Value="supplycompany">供应公司</asp:ListItem>
</asp:DropDownList>
关键字：
<asp:TextBox ID="TbSeaDetail" runat="server" Width="292px"></asp:TextBox>
<asp:Button ID="BtSearch" runat="server" Text="Search" OnClick="BtSearch_Click" />
<br />
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
BackColor="White" BorderColor="#999999" BorderStyle="None" BorderWidth="1px"
CellPadding="3" DataKeyNames="ListId" GridLines="Vertical" OnRowCancelingEdit="GridView1_RowCancelingEdit" OnRowEditing="GridView1_RowEditing" OnRowUpdating="GridView1_RowUpdating">
<FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
<Columns>
<asp:TemplateField HeaderText="所在仓库">
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%#Eval("CkName") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:DropDownList ID="Dpdckname" runat="server" DataSourceID="SqlDataSource1"
DataTextField="CkName" DataValueField="CkId" Width="133px">
</asp:DropDownList><asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:csmagConnectionString %>"
SelectCommand="SELECT [CkId], [CkName] FROM [Cklist]"></asp:SqlDataSource>
</EditItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="ListId" HeaderText="供应单编号" InsertVisible="False" ReadOnly="True"
SortExpression="ListId" />
<asp:BoundField DataField="ProducesKinds" HeaderText="产品种类" SortExpression="ProducesKinds" ReadOnly="True"/>
<asp:BoundField DataField="ProducesName" HeaderText="产品名称" SortExpression="ProducesName" ReadOnly="True"/>
<asp:BoundField DataField="NeedNum" HeaderText="供应数量" SortExpression="NeedNum" ReadOnly="True"/>
<asp:BoundField DataField="ListDateTime" HeaderText="入库时间" SortExpression="ListDateTime" ReadOnly="True" />
<asp:BoundField DataField="AffordMoney" HeaderText="应付资金" SortExpression="AffordMoney" ReadOnly="True"/>
<asp:BoundField DataField="WorkerName" HeaderText="数据处理员" SortExpression="WorkerName" ReadOnly="True"/>
<asp:BoundField DataField="ListMoreInfo" HeaderText="备注信息" SortExpression="ListMoreInfo" />
<asp:BoundField DataField="SupplyCompanyName" HeaderText="供应公司" SortExpression="SupplyCompanyName" ReadOnly="True"/>
<asp:CommandField ShowEditButton="true" HeaderText="货物转移"/>
</Columns>
<RowStyle BackColor="#EEEEEE" ForeColor="Black" HorizontalAlign="Center"/>
<SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
<HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="#DCDCDC" />
</asp:GridView>
<br />
共有
<asp:Label ID="label1" runat="server"></asp:Label>
条记录 总页数
<asp:Label ID="lblPageCount" runat="server" ForeColor="Red" Width="30"></asp:Label>当前页<asp:Label
ID="lblCurrentIndex" runat="server" ForeColor="red" Width="30"></asp:Label>
<asp:LinkButton ID="btnPrev" runat="server" CommandArgument="前一项" Font-Names="verdana"
Font-Size="8pt" ForeColor="navy" OnClick="PagerButtonClick" Text="上一页"></asp:LinkButton>
<asp:LinkButton ID="btnNext" runat="server" CommandArgument="Next" Font-Names="verdana"
Font-Size="8pt" ForeColor="navy" OnClick="PagerButtonClick" Text="下一页"></asp:LinkButton>
<asp:LinkButton ID="btnFirst" runat="server" CommandArgument="0" Font-Names="verdana"
Font-Size="8pt" ForeColor="navy" OnClick="PagerButtonClick" Text="转到第一页"></asp:LinkButton>
<asp:LinkButton ID="btnLast" runat="server" CommandArgument="最后一项" Font-Names="verdana"
Font-Size="8pt" ForeColor="navy" OnClick="PagerButtonClick" Text="转到最后一页"></asp:LinkButton>
<asp:LinkButton ID="btnPage8" runat="server" CommandArgument="X" Font-Names="verdana"
Font-Size="8pt" ForeColor="navy" OnClick="PagerButtonClick" Text="转到第"></asp:LinkButton><asp:TextBox
ID="No" runat="server" Width="20"></asp:TextBox><font style="font-size: 8pt; color: navy">页</font>
<br />
<br />
<br />
<table style="width: 393px; height: 113px">
<tr>
<td style="width: 120px">
放入仓库：</td>
<td colspan="2" style="width: 259px">
<asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="SqlDataSource1"
DataTextField="CkName" DataValueField="CkId" Width="133px">
</asp:DropDownList><asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:csmagConnectionString %>"
SelectCommand="SELECT [CkId], [CkName] FROM [Cklist]"></asp:SqlDataSource>
</td>
</tr>
<tr>
<td style="width: 120px">
供应商姓名：</td>
<td colspan="2" style="width: 259px">
<asp:DropDownList ID="DropDownList2" runat="server" DataSourceID="SqlDataSource3"
DataTextField="SupplyCompanyName" DataValueField="SupplyId" Width="133px">
</asp:DropDownList><asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:csmagConnectionString %>"
SelectCommand="SELECT [SupplyId], [SupplyCompanyName] FROM [SupplyCompany]"></asp:SqlDataSource>
</td>
</tr>
<tr>
<td style="width: 120px">
产品名称：</td>
<td colspan="2" style="width: 259px">
<asp:DropDownList ID="DropDownList3" runat="server" DataSourceID="SqlDataSource4"
DataTextField="ProducesName" DataValueField="ProducesId" Width="132px">
</asp:DropDownList><asp:SqlDataSource ID="SqlDataSource4" runat="server" ConnectionString="<%$ ConnectionStrings:csmagConnectionString %>"
SelectCommand="SELECT [ProducesId], [ProducesName] FROM [Produces]"></asp:SqlDataSource>
</td>
</tr>
<tr>
<td style="width: 120px; height: 4px;">
供应数量：</td>
<td colspan="2" style="width: 259px; height: 4px;">
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td style="width: 120px; height: 20px">
处理员工：</td>
<td colspan="2" style="width: 259px; height: 20px">
<asp:DropDownList ID="DropDownList4" runat="server" DataSourceID="SqlDataSource5"
DataTextField="WorkerName" DataValueField="WorkersListId" Width="133px">
</asp:DropDownList><asp:SqlDataSource ID="SqlDataSource5" runat="server" ConnectionString="<%$ ConnectionStrings:csmagConnectionString %>"
SelectCommand="SELECT [WorkersListId], [WorkerName] FROM [WorkersList]"></asp:SqlDataSource>
</td>
</tr>
<tr>
<td style="width: 120px">
备注信息：</td>
<td colspan="2" style="width: 259px">
<asp:TextBox ID="TextBox4" runat="server" Height="59px" TextMode="MultiLine" Width="192px"></asp:TextBox></td>
</tr>
<tr>
<td style="width: 120px">
</td>
<td colspan="2" style="width: 259px">
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="插入" /></td>
</tr>
</table>
</div>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -