eight.html

本源码实现了对数据库的最基本的操作

&lt;SelectedRowStyle BackColor=&quot;#D1DDF1&quot; Font-Bold=&quot;True&quot; ForeColor=&quot;#333333&quot; /&gt;<br>
&lt;PagerStyle BackColor=&quot;White&quot; Font-Underline=&quot;True&quot; ForeColor=&quot;Black&quot; HorizontalAlign=&quot;Center&quot; /&gt;<br>
&lt;HeaderStyle BackColor=&quot;White&quot; Font-Bold=&quot;True&quot; ForeColor=&quot;Black&quot; /&gt;<br>
&lt;AlternatingRowStyle BackColor=&quot;White&quot; /&gt;<br>
&lt;/asp:GridView&gt;<br>
&lt;/td&gt;<br>
&lt;/tr&gt;<br>
&lt;/table&gt;<br>
&lt;/asp:Panel&gt;<br>
&lt;asp:Panel ID=&quot;PalOneGoodsSaveAlert&quot; runat=&quot;server&quot; Visible=&quot;False&quot;&gt;<br>
&lt;table class=&quot;bor_1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;0&quot; width=&quot;800&quot; align=&quot;center&quot; border=&quot;0&quot;&gt;<br>
&lt;tr&gt;<br>
&lt;td class=&quot;bgTitler&quot; align=&quot;center&quot; colspan=&quot;3&quot; height=&quot;30&quot;&gt;<br>
&lt;img id=&quot;image1&quot; height=&quot;22&quot; src=&quot;../images/icon_008.gif&quot; width=&quot;22&quot; align=&quot;absMiddle&quot;<br>
border=&quot;0&quot; name=&quot;image1&quot;&gt;&amp;nbsp;&amp;nbsp; &lt;b&gt;库存预警商品数量修改&lt;/b&gt;<br>
&lt;/td&gt;<br>
&lt;/tr&gt;<br>
&lt;tr&gt;<br>
&lt;td width=&quot;250&quot; height=&quot;30&quot;&gt;<br>
&amp;nbsp;&amp;nbsp;&lt;/td&gt;<br>
&lt;td width=&quot;110&quot; height=&quot;30&quot;&gt;<br>
&amp;nbsp;&amp;nbsp;商品名称：&lt;font color=&quot;red&quot;&gt;*&lt;/font&gt;&lt;/td&gt;<br>
&lt;td width=&quot;450&quot;&gt;<br>
&lt;asp:TextBox ID=&quot;GoodsID&quot; runat=&quot;server&quot; Visible=&quot;False&quot; ReadOnly=&quot;True&quot;&gt;&lt;/asp:TextBox&gt;<br>
&lt;asp:TextBox ID=&quot;GoodsName&quot; runat=&quot;server&quot; CssClass=&quot;box1&quot; Width=&quot;200px&quot; ReadOnly=&quot;True&quot;<br>
MaxLength=&quot;50&quot; BackColor=&quot;#EEEEEE&quot;&gt;&lt;/asp:TextBox&gt;&lt;/td&gt;<br>
&lt;/tr&gt;<br>
&lt;tr&gt;<br>
&lt;td width=&quot;250&quot; height=&quot;30&quot;&gt;<br>
&amp;nbsp;&amp;nbsp;&lt;/td&gt;<br>
&lt;td width=&quot;110&quot; height=&quot;30&quot;&gt;<br>
&amp;nbsp;&amp;nbsp;商品库存数量：&lt;/td&gt;<br>
&lt;td width=&quot;450&quot;&gt;<br>
&lt;asp:TextBox ID=&quot;SaveNum&quot; runat=&quot;server&quot; CssClass=&quot;box1&quot; Width=&quot;200px&quot; MaxLength=&quot;8&quot;&gt;&lt;/asp:TextBox&gt;&lt;/td&gt;<br>
&lt;/tr&gt;<br>
&lt;tr&gt;<br>
&lt;td width=&quot;250&quot; height=&quot;30&quot;&gt;<br>
&amp;nbsp;&amp;nbsp;&lt;/td&gt;<br>
&lt;td width=&quot;110&quot; height=&quot;30&quot;&gt;<br>
&amp;nbsp;&amp;nbsp;最近增加数量：&lt;/td&gt;<br>
&lt;td width=&quot;450&quot;&gt;<br>
&lt;asp:TextBox ID=&quot;SaveAddNum&quot; runat=&quot;server&quot; CssClass=&quot;box1&quot; Width=&quot;200px&quot; ReadOnly=&quot;True&quot;<br>
MaxLength=&quot;8&quot; BackColor=&quot;#EEEEEE&quot;&gt;&lt;/asp:TextBox&gt;&lt;/td&gt;<br>
&lt;/tr&gt;<br>
&lt;tr&gt;<br>
&lt;td width=&quot;250&quot; height=&quot;30&quot;&gt;<br>
&amp;nbsp;&amp;nbsp;&lt;/td&gt;<br>
&lt;td width=&quot;110&quot; height=&quot;30&quot;&gt;<br>
&amp;nbsp;&amp;nbsp;商品入库时间：&lt;font color=&quot;red&quot;&gt;*&lt;/font&gt;&lt;/td&gt;<br>
&lt;td width=&quot;450&quot;&gt;<br>
&lt;asp:TextBox ID=&quot;SaveTime&quot; runat=&quot;server&quot; CssClass=&quot;box1&quot; Width=&quot;200px&quot; ReadOnly=&quot;True&quot;<br>
MaxLength=&quot;50&quot; BackColor=&quot;#EEEEEE&quot;&gt;&lt;/asp:TextBox&gt;&lt;/td&gt;<br>
&lt;/tr&gt;<br>
&lt;tr&gt;<br>
&lt;td width=&quot;250&quot; height=&quot;30&quot;&gt;<br>
&amp;nbsp;&amp;nbsp;&lt;/td&gt;<br>
&lt;td width=&quot;110&quot; height=&quot;30&quot;&gt;<br>
&amp;nbsp;&amp;nbsp;最近增加时间：&lt;font color=&quot;red&quot;&gt;*&lt;/font&gt;&lt;/td&gt;<br>
&lt;td width=&quot;450&quot;&gt;<br>
&lt;asp:TextBox ID=&quot;SaveAddTime&quot; runat=&quot;server&quot; CssClass=&quot;box1&quot; Width=&quot;200px&quot; ReadOnly=&quot;True&quot;<br>
MaxLength=&quot;50&quot; BackColor=&quot;#EEEEEE&quot;&gt;&lt;/asp:TextBox&gt;&lt;/td&gt;<br>
&lt;/tr&gt;<br>
&lt;tr&gt;<br>
&lt;td align=&quot;center&quot; colspan=&quot;3&quot; style=&quot;height: 40px&quot;&gt;<br>
&lt;asp:Button ID=&quot;IsAdd&quot; runat=&quot;server&quot; Text=&quot;提 交&quot; CssClass=&quot;button-a&quot; OnClick=&quot;IsAdd_Click&quot;&gt;<br>
&lt;/asp:Button&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;<br>
&lt;input class=&quot;button-a&quot; onfocus=&quot;if(this.blur)this.blur()&quot; type=&quot;reset&quot; value=&quot;清 空&quot;&gt;<br>
&lt;/td&gt;<br>
&lt;/tr&gt;<br>
&lt;/table&gt;<br>
&lt;/asp:Panel&gt;<br>
&lt;/form&gt;<br>
&lt;/body&gt;<br>
&lt;/html&gt;</p>
<p>3.在GoodsSaveAlert.aspx.cs中引用命名空间</p>
<p class="code">using Kingvcn.WShop;</p>
<p>定义调用对象</p>
<p class="code">GoodsSave GoodsSave = new GoodsSave();<br>
protected string typename = ConfigurationManager.AppSettings[&quot;typename&quot;];<br>
int goodsID = 0;<br>
int alertNum = 0;</p>
<p>在Page_Load()事件中加入程序，先写上登录管理员的Session判定程序，然后在库存类文件GoodsSave.cs上创建提取库存信息数字的方法GetGoodsSaveInfoNum()，该方法的输入参数是返回结果的类型（根据输入参数确定是返回商品预警数字，还是商品满库数字），在GoodsSaveAlert.aspx.cs引用申明后调用获取商品预警数字存放在定义好的变量alertNum中，然后判断是否有GoodsID传入，有的话将其值存放在变量goodsID中，并调用GetGoodsSaveAlertByID()方法，隐藏PalAllGoodsSaveAlert Panel控件，显示PalOneGoodsSaveAlert Panel控件。如果没有GoodsID传入就显示PalAllGoodsSaveAlert Panel控件，隐藏PalOneGoodsSaveAlert Panel控件。</p>
<p class="code">protected void Page_Load(object sender, EventArgs e)<br>
{<br>
if((Session[&quot;ManagerID&quot;] == null)||(Session[&quot;ManagerID&quot;].ToString() == &quot;&quot;))<br>
{<br>
JScript.GotoParentWindow(&quot;Index.aspx&quot;);<br>
}<br>
else<br>
{<br>
alertNum = GoodsSave.GetGoodsSaveInfoNum(0);<br>
if ((Request[&quot;GoodsID&quot;] != null) &amp;&amp; (Request[&quot;GoodsID&quot;].ToString() != &quot;&quot;))<br>
{<br>
goodsID = int.Parse(Request[&quot;GoodsID&quot;].ToString());<br>
if (!IsPostBack)<br>
{<br>
GetGoodsSaveAlertByID(goodsID);<br>
PalAllGoodsSaveAlert.Visible = false;<br>
PalOneGoodsSaveAlert.Visible = true;<br>
}<br>
}<br>
else<br>
{<br>
if (!IsPostBack)<br>
{<br>
PalAllGoodsSaveAlert.Visible = true;<br>
PalOneGoodsSaveAlert.Visible = false;<br>
}<br>
}<br>
}<br>
}</p>
<p>在库存类文件GoodsSave.cs上创建提取库存信息数字的方法GetGoodsSaveInfoNum()</p>
<p class="code">/// &lt;summary&gt;<br>
/// 提取库存信息数字<br>
/// &lt;/summary&gt;<br>
/// &lt;param name=&quot;typeID&quot;&gt;库存信息种类，输入为0时提取预警数字，否则提取满库数量&lt;/param&gt;<br>
/// &lt;returns&gt;相关库存信息数字&lt;/returns&gt;<br>
public int GetGoodsSaveInfoNum(int typeID)<br>
{<br>
int flag = 0;<br>
if (typeID == 0)<br>
{<br>
cmd.CommandText = string.Format(&quot;select top 1 AlertNum from GoodsSaveInfo order by GoodsSaveInfoID desc&quot;);<br>
}<br>
else<br>
{<br>
cmd.CommandText = string.Format(&quot;select top 1 AllNum from GoodsSaveInfo order by GoodsSaveInfoID desc&quot;);<br>
}<br>
try<br>
{<br>
conn.Open();<br>
flag = Convert.ToInt32(cmd.ExecuteScalar());<br>
}<br>
catch (Exception ex)<br>
{<br>
throw (ex);<br>
}<br>
finally<br>
{<br>
cmd.Dispose();<br>
conn.Close();<br>
}<br>
return flag;<br>
}</p>
<p>4.在GoodsSaveAlert.aspx.cs中的预警商品全部满库的Click事件IsAdd_Click()中首先调用库存类文件GoodsSave.cs的GetGoodsSaveInfoNum()方法提取商品的满库数量allNum，然后调用GoodsSave.cs中的方法SetGoodsSaveAll()在数据库中写入数据，修改成功后重新跳转到库存预警商品页面GoodsSaveAlert.aspx</p>
<p class="code">/// &lt;summary&gt;<br>
  /// 把预警商品全部满库<br>
  /// &lt;/summary&gt;<br>
  protected void AddAll_Click(object sender, EventArgs e)<br>
  {<br>
  int allNum = GoodsSave.GetGoodsSaveInfoNum(1);<br>
  int modifyOk = GoodsSave.SetGoodsSaveAll(allNum, alertNum);<br>
  if (modifyOk == 1)<br>
  {<br>
  JScript.Alert(&quot;预警商品全部满库成功，欢迎使用！&quot;);<br>
  JScript.JavaScriptLocationHref(&quot;GoodsSaveAlert.aspx&quot;);<br>
  }<br>
  else<br>
  {<br>
  JScript.Alert(&quot;预警商品全部满库失败，请稍后再来！&quot;);<br>
  return;<br>
  }<br>
  }</p>
<p>在库存类文件GoodsSave.cs上创建把预警商品全部满库的方法SetGoodsSaveAll()，该方法的输入参数是商品满库数量和商品预警数量，该方法是通过判断现有库存数量将现有库存数量小于预警数量的全部商品的现有数量都更新为满库数量，并计算新增加了多少商品，记录到数据库表中。</p>
<p class="code">/// &lt;summary&gt;<br>
/// 把预警商品全部满库<br>
/// &lt;/summary&gt;<br>
/// &lt;param name=&quot;allNum&quot;&gt;商品满库数量&lt;/param&gt;<br>
/// &lt;param name=&quot;alertNum&quot;&gt;商品预警数量&lt;/param&gt;<br>
/// &lt;returns&gt;flag标记&lt;/returns&gt;<br>
public int SetGoodsSaveAll(int allNum, int alertNum)<br>
{<br>
int flag = 0;<br>
cmd.CommandText = string.Format(&quot;update GoodsSave set SaveNum = {0},SaveAddNum = {0}-SaveNum,SaveAddTime = getdate() where SaveNum &lt; {1}&quot;, allNum, alertNum);<br>
try<br>
{<br>
conn.Open();<br>
cmd.ExecuteNonQuery();<br>
flag = 1;<br>
}<br>
catch (Exception ex)<br>
{<br>
throw (ex);<br>
}<br>
finally<br>
{<br>
cmd.Dispose();<br>
conn.Close();<br>
}<br>
return flag;<br>
}</p>
<p>5.然后在GoodsSaveAlert.aspx.cs中添加提取库存预警商品信息的方法，该方法以前面定义的变量goodsID作为传入参数，调用库存类文件GoodsSave.cs上的方法GetGoodsSaveAlertByID()，完成库存预警商品信息的提取，并把存预警商品的信息字段赋值给相应的TextBox控件。</p>
<p class="code">/// &lt;summary&gt;<br>
/// 提取库存预警商品信息<br>
/// &lt;/summary&gt;<br>
/// &lt;param name=&quot;goodsID&quot;&gt;商品ID&lt;/param&gt;<br>
private void GetGoodsSaveAlertByID(int goodsID)<br>
{<br>
if (goodsID &gt; 0)<br>
{<br>
DataTable myDtb = new DataTable();<br>
myDtb = GoodsSave.GetGoodsSaveAlertByID(goodsID);<br>
if (myDtb.DefaultView.Count &gt; 0)<br>
{<br>
GoodsID.Text = myDtb.DefaultView[0][&quot;GoodsID&quot;].ToString();<br>
GoodsName.Text = myDtb.DefaultView[0][&quot;GoodsName&quot;].ToString();<br>
SaveNum.Text = myDtb.DefaultView[0][&quot;SaveNum&quot;].ToString();<br>
SaveAddNum.Text = myDtb.DefaultView[0][&quot;SaveAddNum&quot;].ToString();<br>
SaveTime.Text = myDtb.DefaultView[0][&quot;SaveTime&quot;].ToString();<br>
SaveAddTime.Text = myDtb.DefaultView[0][&quot;SaveAddTime&quot;].ToString();<br>
}<br>
else<br>
{<br>
JScript.Alert(&quot;没有找到该商品的库存信息！&quot;);<br>
JScript.GotoParentWindow(&quot;GoodsSaveAlert.aspx&quot;);<br>
}<br>
}<br>
}</p>
<p>在库存类文件GoodsSave.cs上写一个按商品的goodsID提取某个库存预警商品信息的方法GetGoodsSaveAlertByID()。</p>
<p class="code">/// &lt;summary&gt;<br>
/// 提取库存预警商品信息<br>