goodssavealert.aspx.txt
来自「本源码实现了对数据库的最基本的操作」· 文本 代码 · 共 150 行
TXT
150 行
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="GoodsSaveAlert.aspx.cs" Inherits="Manage_GoodsSaveAlert" %>
<!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>
<%=typename%>
--后台管理</title>
<link href="../App_Themes/Theme1/StyleSheetManage2.css" rel="stylesheet" type="text/css" />
</head>
<body>
<form id="form1" runat="server">
<asp:Panel ID="PalAllGoodsSaveAlert" runat="server">
<table class="bor_1" id="Table1" cellspacing="0" cellpadding="0" width="800" align="center"
border="0">
<tr>
<td class="bgTitler" align="center" width="600" height="30">
<b>库存预警商品列表</b></td>
<td class="bgTitler" align="center" width="200">
<asp:Button ID="AddAll" runat="server" Text="预警商品全部满库" CssClass="btn1" OnClick="AddAll_Click">
</asp:Button></td>
</tr>
</table>
<br>
<table id="Table2" bordercolor="#003399" cellspacing="0" cellpadding="0" width="800"
align="center" border="0">
<tr>
<td valign="top" align="center" width="100%">
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:WShopConnectionString %>"
SelectCommand="SELECT d.SaveNum, d.SaveAddNum, d.SaveTime, d.SaveAddTime, c.GoodsID, c.GoodsName, a.TypeName, b.BorderName FROM GoodsType AS a INNER JOIN GoodsInfo AS c ON a.TypeID = c.TypeID INNER JOIN GoodsBorder AS b ON c.BorderID = b.BorderID INNER JOIN GoodsSave AS d ON c.GoodsID = d.GoodsID INNER JOIN GoodsSaveInfo AS e ON d.SaveNum < e.AlertNum ORDER BY d.SaveNum, a.TypeID DESC, b.BorderID DESC, c.GoodsOrder DESC">
</asp:SqlDataSource>
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
AutoGenerateColumns="False" CellPadding="4" DataKeyNames="GoodsID" DataSourceID="SqlDataSource1"
ForeColor="#333333" Width="100%">
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<Columns>
<asp:BoundField DataField="TypeName" HeaderText="所属一级分类" SortExpression="TypeName">
<ItemStyle Width="12%" />
<HeaderStyle Wrap="True" />
</asp:BoundField>
<asp:BoundField DataField="BorderName" HeaderText="所属二级分类" SortExpression="BorderName">
<ItemStyle Width="12%" />
<HeaderStyle Wrap="True" />
</asp:BoundField>
<asp:BoundField DataField="GoodsName" HeaderText="商品名称" SortExpression="GoodsName">
<ItemStyle Width="176px" Wrap="True" HorizontalAlign="Left" />
<HeaderStyle Wrap="True" />
</asp:BoundField>
<asp:BoundField DataField="SaveNum" HeaderText="当前库存数量" SortExpression="SaveNum">
<ItemStyle ForeColor="Red" Width="12%" />
<HeaderStyle Wrap="True" />
</asp:BoundField>
<asp:BoundField DataField="SaveTime" HeaderText="最初入库时间" SortExpression="SaveTime"
DataFormatString="{0:yyyy-MM-dd}" HtmlEncode="False">
<ItemStyle Width="12%" />
<HeaderStyle Wrap="True" />
</asp:BoundField>
<asp:BoundField DataField="SaveAddNum" HeaderText="最近增加数量" SortExpression="SaveAddNum">
<ItemStyle ForeColor="Blue" Width="12%" />
<HeaderStyle Wrap="True" />
</asp:BoundField>
<asp:BoundField DataField="SaveAddTime" HeaderText="最近增加时间" SortExpression="SaveAddTime"
DataFormatString="{0:yyyy-MM-dd}" HtmlEncode="False">
<ItemStyle Width="12%" />
<HeaderStyle Wrap="True" />
</asp:BoundField>
<asp:BoundField DataField="GoodsID" HeaderText="GoodsID" InsertVisible="False" ReadOnly="True"
SortExpression="GoodsID" Visible="False" />
<asp:HyperLinkField HeaderText="操作" Text="编辑" DataNavigateUrlFields="GoodsID" DataNavigateUrlFormatString="GoodsSaveAlert.aspx?GoodsID={0}">
<ItemStyle Width="6%" />
<HeaderStyle Wrap="True" />
</asp:HyperLinkField>
</Columns>
<RowStyle BackColor="#EFF3FB" />
<EditRowStyle BackColor="#2461BF" />
<SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
<PagerStyle BackColor="White" Font-Underline="True" ForeColor="Black" HorizontalAlign="Center" />
<HeaderStyle BackColor="White" Font-Bold="True" ForeColor="Black" />
<AlternatingRowStyle BackColor="White" />
</asp:GridView>
</td>
</tr>
</table>
</asp:Panel>
<asp:Panel ID="PalOneGoodsSaveAlert" runat="server" Visible="False">
<table class="bor_1" cellspacing="0" cellpadding="0" width="800" align="center" border="0">
<tr>
<td class="bgTitler" align="center" colspan="3" height="30">
<img id="image1" height="22" src="../images/icon_008.gif" width="22" align="absMiddle"
border="0" name="image1"> <b>库存预警商品数量修改</b>
</td>
</tr>
<tr>
<td width="250" height="30">
</td>
<td width="110" height="30">
商品名称：<font color="red">*</font></td>
<td width="450">
<asp:TextBox ID="GoodsID" runat="server" Visible="False" ReadOnly="True"></asp:TextBox>
<asp:TextBox ID="GoodsName" runat="server" CssClass="box1" Width="200px" ReadOnly="True"
MaxLength="50" BackColor="#EEEEEE"></asp:TextBox></td>
</tr>
<tr>
<td width="250" height="30">
</td>
<td width="110" height="30">
商品库存数量：</td>
<td width="450">
<asp:TextBox ID="SaveNum" runat="server" CssClass="box1" Width="200px" MaxLength="8"></asp:TextBox></td>
</tr>
<tr>
<td width="250" height="30">
</td>
<td width="110" height="30">
最近增加数量：</td>
<td width="450">
<asp:TextBox ID="SaveAddNum" runat="server" CssClass="box1" Width="200px" ReadOnly="True"
MaxLength="8" BackColor="#EEEEEE"></asp:TextBox></td>
</tr>
<tr>
<td width="250" height="30">
</td>
<td width="110" height="30">
商品入库时间：<font color="red">*</font></td>
<td width="450">
<asp:TextBox ID="SaveTime" runat="server" CssClass="box1" Width="200px" ReadOnly="True"
MaxLength="50" BackColor="#EEEEEE"></asp:TextBox></td>
</tr>
<tr>
<td width="250" height="30">
</td>
<td width="110" height="30">
最近增加时间：<font color="red">*</font></td>
<td width="450">
<asp:TextBox ID="SaveAddTime" runat="server" CssClass="box1" Width="200px" ReadOnly="True"
MaxLength="50" BackColor="#EEEEEE"></asp:TextBox></td>
</tr>
<tr>
<td align="center" colspan="3" style="height: 40px">
<asp:Button ID="IsAdd" runat="server" Text="提 交" CssClass="button-a" OnClick="IsAdd_Click">
</asp:Button>
<input class="button-a" onfocus="if(this.blur)this.blur()" type="reset" value="清 空">
</td>
</tr>
</table>
</asp:Panel>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?