📄 goodclass.aspx
字号:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="GoodClass.aspx.cs" Inherits="admin_GoodClass" %>
<!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>
<script type="text/javascript">
function GiveKeeps()
{
var oSelector = document.getElementById("<asp:Literal ID="fd" runat="Server"></asp:Literal>");
var IntKid = oSelector.value;
var DivNames = "Div"+IntKid;
document.getElementById("SysDiv").style.display="none";
document.getElementById(DivNames).style.display="inline";
}
function Xianshi(obj,obj1)
{
document.getElementById(obj1).style.display="none";
document.getElementById("KeepsN").value=obj;
document.getElementById("SysDiv").style.display="inline";
//document.getElementById("KeepsN")="asdf"
//alert(obj);
}
</script>
</head>
<body>
<form id="form1" runat="server">
<div>
<table width="550" border="0" align="center" cellpadding="0" cellspacing="2">
<tr>
<td height="50" valign="bottom">
<asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="False" OnClick="LinkButton1_Click">产品列表</asp:LinkButton>
<asp:LinkButton ID="LinkButton2" runat="server" CausesValidation="False" OnClick="LinkButton2_Click">新加产品</asp:LinkButton>
<asp:LinkButton ID="LinkButton3" runat="server" CausesValidation="False" OnClick="LinkButton3_Click">产品搜索</asp:LinkButton>
<asp:LinkButton ID="LinkButton4" runat="server" CausesValidation="False" OnClick="LinkButton4_Click">新加大类</asp:LinkButton><br /><br />
</td>
</tr>
<tr>
<td>
<asp:Panel ID="Panel1" runat="server">
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
AutoGenerateColumns="False" CellPadding="4" DataKeyNames="ID" DataSourceID="SqlDataSource1"
ForeColor="#333333" GridLines="None" Width="550px">
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<Columns>
<asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False" ReadOnly="True"
SortExpression="ID">
<ItemStyle Width="40px" HorizontalAlign="Center" />
</asp:BoundField>
<asp:BoundField DataField="GoodsNum" HeaderText="产品编码" SortExpression="GoodsNum">
<ItemStyle Width="100px" HorizontalAlign="Center" />
<ControlStyle Width="100px" />
</asp:BoundField>
<asp:BoundField DataField="GoodsName" HeaderText="产品名称" SortExpression="GoodsName">
<ItemStyle Width="100px" HorizontalAlign="Center" />
<ControlStyle Width="100px" />
</asp:BoundField>
<asp:BoundField DataField="NowNum" HeaderText="现存数量" SortExpression="NowNum">
<ItemStyle Width="60px" HorizontalAlign="Center" />
<ControlStyle Width="60px" />
</asp:BoundField>
<asp:BoundField DataField="TopNum" HeaderText="数量上限" SortExpression="TopNum">
<ItemStyle Width="60px" HorizontalAlign="Center" />
<ControlStyle Width="60px" />
</asp:BoundField>
<asp:BoundField DataField="EndNum" HeaderText="数量下限" SortExpression="EndNum" >
<ControlStyle Width="60px" />
<ItemStyle HorizontalAlign="Center" />
</asp:BoundField>
<asp:CommandField ShowEditButton="True" HeaderText="操作">
<ItemStyle Width="80px" HorizontalAlign="Center" />
</asp:CommandField>
</Columns>
<RowStyle BackColor="#EFF3FB" />
<EditRowStyle BackColor="#C3C3C3" />
<SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
<PagerStyle BackColor="#A3C5CE" ForeColor="White" HorizontalAlign="Center" />
<HeaderStyle BackColor="#A3C5CE" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="White" />
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:al_bysjConnectionString %>"
DeleteCommand="DELETE FROM [AllGood] WHERE [ID] = @ID" InsertCommand="INSERT INTO [AllGood] ([GoodsNum], [GoodsName], [NowNum], [TopNum], [EndNum]) VALUES (@GoodsNum, @GoodsName, @NowNum, @TopNum, @EndNum)"
SelectCommand="SELECT [ID], [GoodsNum], [GoodsName], [NowNum], [TopNum], [EndNum] FROM [AllGood]"
UpdateCommand="UPDATE [AllGood] SET [GoodsNum] = @GoodsNum, [GoodsName] = @GoodsName, [NowNum] = @NowNum, [TopNum] = @TopNum, [EndNum] = @EndNum WHERE [ID] = @ID">
<DeleteParameters>
<asp:Parameter Name="ID" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="GoodsNum" Type="String" />
<asp:Parameter Name="GoodsName" Type="String" />
<asp:Parameter Name="NowNum" Type="Int32" />
<asp:Parameter Name="TopNum" Type="Int32" />
<asp:Parameter Name="EndNum" Type="Int32" />
<asp:Parameter Name="ID" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="GoodsNum" Type="String" />
<asp:Parameter Name="GoodsName" Type="String" />
<asp:Parameter Name="NowNum" Type="Int32" />
<asp:Parameter Name="TopNum" Type="Int32" />
<asp:Parameter Name="EndNum" Type="Int32" />
</InsertParameters>
</asp:SqlDataSource>
</asp:Panel>
<asp:Panel ID="Panel2" runat="server">
<table width="550" bgcolor="#a3c5ce" border="0" align="center" cellpadding="0" cellspacing="1">
<tr><td colspan="2" height="20" align="center"><b><font color="#ffffff">新加产品</font></b></td></tr>
<tr>
<td bgcolor="#f0fbfd" align="right" width="200" height="20">产品编码:</td>
<td bgcolor="#f0fbfd"><asp:TextBox ID="KeepGoods" runat="server" Width="120px"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ErrorMessage="产品编码不能为空" ControlToValidate="KeepGoods"></asp:RequiredFieldValidator></td>
</tr>
<tr>
<td bgcolor="#f0fbfd" align="right" width="200" height="20">产品名称:</td>
<td bgcolor="#f0fbfd"><asp:TextBox ID="GoodsName" runat="server" Width="120px"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" ErrorMessage="产品名称不能为空" ControlToValidate="GoodsName"></asp:RequiredFieldValidator></td>
</tr>
<tr>
<td align="right" width="200" height="20" bgcolor="#f0fbfd">所属大类:</td>
<td bgcolor="#f0fbfd">
<asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="SqlDataSource2"
DataTextField="GoodsName" DataValueField="ID">
</asp:DropDownList><asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:al_bysjConnectionString %>"
SelectCommand="SELECT [ID], [GoodsName] FROM [BigClass] ORDER BY [ID]"></asp:SqlDataSource>
</td>
</tr>
<tr>
<td align="right" bgcolor="#f0fbfd" width="200" height="20">数量上限:</td>
<td style="height: 20px" bgcolor="#f0fbfd"><asp:TextBox ID="KeepTop" runat="server" Width="80px"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server" ErrorMessage="数量上限不能为空" ControlToValidate="KeepTop"></asp:RequiredFieldValidator></td>
</tr>
<tr>
<td align="right" width="200" height="20" bgcolor="#f0fbfd">数量下限:</td>
<td bgcolor="#f0fbfd"><asp:TextBox ID="KeepEnd" runat="server" Width="80px"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator4" runat="server" ErrorMessage="数量下限不能为空" ControlToValidate="KeepEnd"></asp:RequiredFieldValidator></td>
</tr>
<tr>
<td align="right" width="200" height="20" bgcolor="#f0fbfd">所属仓库:</td>
<td bgcolor="#f0fbfd">
<div id ="SysDiv">
<asp:DropDownList ID="DropDownList2" runat="server" DataSourceID="SqlDataSource3"
DataTextField="KeepName" DataValueField="ID">
</asp:DropDownList> 货架:<asp:TextBox ID="KeepsN" runat="server" Width="40px" onclick="javascript:GiveKeeps();"></asp:TextBox>
<asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:al_bysjConnectionString %>"
SelectCommand="SELECT [ID], [KeepName] FROM [KeepNum] ORDER BY [ID]"></asp:SqlDataSource>
</div>
</td>
</tr>
<tr>
<td bgcolor="#f0fbfd" height="20" valign="bottom"></td>
<td bgcolor="#f0fbfd"><asp:Button ID="Button1" runat="server" Text=" 添 加 " UseSubmitBehavior="False" OnClick="Button1_Click" /></td>
</tr>
</table>
</asp:Panel>
<asp:Panel ID="Panel3" runat="server">
<table width="550" bgcolor="#a3c5ce" border="0" align="center" cellpadding="0" cellspacing="1">
<tr><td colspan="2" height="20" align="center"><b><font color="#ffffff">产品搜索</font></b></td></tr>
<tr>
<td bgcolor="#f0fbfd" align="right" width="200" height="20">
关 键 字:</td>
<td bgcolor="#f0fbfd"><asp:TextBox ID="KeyWords" runat="server" Width="120px"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator5" runat="server" ErrorMessage="关键字不能为空" ControlToValidate="KeyWords"></asp:RequiredFieldValidator></td>
</tr>
<tr>
<td bgcolor="#f0fbfd" align="right" width="200" height="20">
搜索范围:</td>
<td bgcolor="#f0fbfd">
<input id="Radio1" type="radio" name="Types" value="0" checked runat="server"/>产品名称<input id="Radio2" name="Types" type="radio" value="1" runat="server"/>产品编码</td>
</tr>
<tr>
<td bgcolor="#f0fbfd" height="20" valign="bottom"></td>
<td bgcolor="#f0fbfd"><asp:Button ID="Button2" runat="server" Text=" 搜 索 " UseSubmitBehavior="False" OnClick="Button2_Click" /></td>
</tr>
</table>
</asp:Panel>
<asp:Panel ID="Panel4" runat="server">
<table width="550" bgcolor="#a3c5ce" border="0" align="center" cellpadding="0" cellspacing="1">
<tr><td colspan="2" height="20" align="center"><b><font color="#ffffff">新加大类</font></b></td></tr>
<tr>
<td bgcolor="#f0fbfd" align="right" width="200" height="20">
大类名称:</td>
<td bgcolor="#f0fbfd"><asp:TextBox ID="BigClass" runat="server" Width="120px"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator6" runat="server" ErrorMessage="大类名称不能为空" ControlToValidate="BigClass"></asp:RequiredFieldValidator></td>
</tr>
<tr>
<td bgcolor="#f0fbfd" height="20" valign="bottom"></td>
<td bgcolor="#f0fbfd"><asp:Button ID="Button3" runat="server" Text=" 确 定 " UseSubmitBehavior="False" OnClick="Button3_Click" /></td>
</tr>
</table>
</asp:Panel>
<asp:Panel ID="Panel5" runat="server">
<asp:DataList ID="DataList1" runat="server" Width="550">
<HeaderTemplate><table width="550" bgcolor="#a3c5ce" border="0" align="center" cellpadding="0" cellspacing="1">
<tr align="center"><td height="20"><font color="#ffffff"><b>产品编号</b></font></td><td><font color="#ffffff"><b>产品名称</b></font></td><td><font color="#ffffff"><b>现有库存</b></font></td><td><font color="#ffffff"><b>数量上限</b></font></td><td><font color="#ffffff"><b>数量下限</b></font></td><td><font color="#ffffff"><b>所属货架</b></font></td><td><font color="#ffffff"><b>所属仓库</b></font></td></tr></HeaderTemplate>
<ItemTemplate><tr bgcolor="#f0fbfd" align="center"><td height="20"><%#Eval("GoodsNum")%></td><td><%#Eval("GoodsName")%></td><td><%#Eval("NowNum")%></td><td><%#Eval("TopNum")%></td><td><%#Eval("EndNum")%></td><td><%#Eval("AlignGoodC")%></td><td><%#Eval("AlignKeeps")%></td></tr></ItemTemplate>
<FooterTemplate></table></FooterTemplate>
</asp:DataList>
</asp:Panel>
</td>
</tr>
</table>
<asp:Panel ID="KeepsDiv" runat="server" Width="550">
</asp:Panel>
</div>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -