基于ASP.NET仓库管理信息系统 - 图文

E)

}

//连接本地计算机的WMS数据库

SqlConnection cn= new SqlConnection (strconn); cn.Open ();

SqlCommand cm=new SqlCommand (\cm.CommandType =CommandType.StoredProcedure ; cm.Parameters .Add (\ ); //从DateGrid中取得更新内容 //Cells [1]为GID列

cm.Parameters [\cm.ExecuteNonQuery ();

dgd_goodsmanage.EditItemIndex =-1; BindGrid();

[1].Text .ToString ());

下面方法用于响应DataGrid控件dgd_goodsmanage的分页显示换页事件：

public void DataGrid_Page(Object sender,DataGridPageChangedEventArgs { }

单击“开始”时，触发btn_search_Click事件，用于实现根据货物编号查找货物的功能。代码如下：

private void btn_search_Click(object sender, System.EventArgs e) {

try { } catch {

Response.Write (\输入的货品号不正确！\Response.End ();

int vargid=Convert.ToInt32 (tbx_gid.Text .ToString ()); Response.Redirect (\

dgd_goodsmanage.CurrentPageIndex =E.NewPageIndex ; BindGrid();

25

}

}

3）货物信息添加页面实现代码

货物信息添加页面的后台支持类是GoodsAdd.aspx.cs，它负责对页面的事件进行处理。首先定义GoodsAdd类，继承了System.Web.UI.Page系统类： public class GoodsAdd : System.Web.UI.Page

{

protected System.Web.UI.WebControls.TextBox tbx_gname; protected System.Web.UI.WebControls.Button btn_submit; protected System.Web.UI.WebControls.TextBox tbx_gprice; protected System.Web.UI.WebControls.TextBox tbx_gprovider1; protected System.Web.UI.WebControls.TextBox tbx_gprovider2; protected System.Web.UI.WebControls.TextBox tbx_gdescribe;

protected System.Web.UI.WebControls.RequiredFieldValidator rfv_gname; protected System.Web.UI.WebControls.RequiredFieldValidator rfv_gprice; protected System.Web.UI.WebControls.RequiredFieldValidator protected System.Web.UI.WebControls.HyperLink hlk_goodsmanage; 当用户单击“添加”后，出发btn_submit_Click()事件，该事件通过存private void btn_submit_Click(object sender, System.EventArgs e) {

if(Page.IsValid )

{ //从文件Web.config中读取连接字符串

string strconn= ConfigurationSettings.AppSettings[\//连接本地计算机的WMS数据库

SqlConnection cn= new SqlConnection (strconn); cn.Open ();

//先取得GOODS表上表示列的初始值

string getInsertID=\SqlCommand cm0=new SqlCommand (getInsertID,cn); SqlDataReader dr=cm0.ExecuteReader (); dr.Read (); int Vargid;

rfv_gprovider1;

储过程GoodsAdd将一条记录插入到数据库表Goods中。代码如下：

26

if(dr[0].ToString ()==\Vargid=1;//表初始为空的情况 else Vargid=Convert.ToInt32 (dr[0].ToString())+1 ;//表中已有数据cm0.Connection .Close ();

//利用Command对象调用存储过程

SqlCommand cm=new SqlCommand (\//将命令类型转为存储类型

cm.CommandType =CommandType.StoredProcedure ; try

{//添加并给参数付值

cm.Parameters .Add (\

cm.Parameters .Add (\cm.Parameters .Add (\cm.Parameters .Add (\cm.Parameters .Add (\har ); cm.Parameters .Add (\ );

cm.Parameters [\

cm.Parameters [\cm.Parameters [\cm.Parameters [\cm.Parameters [\cm.Parameters [\cm.Connection .Open (); cm.ExecuteNonQuery (); } catch {

Response.Write (\对不起输入信息中存在不合要求信息，请重Response.End ();

的情况

(tbx_gprice.Text .ToString ()); =tbx_gprovider1.Text .ToString (); =tbx_gprovider2.Text .ToString (); =tbx_gdescribe.Text .ToString ();

输！\

27

}

}

}

//关闭连接 cn.Close();

Response.Redirect(\

4）货物信息修改页面实现代码

货物信息修改页面的后台支持类是GoodsModify.aspx.cs,它负责对页面的时间爱你进行处理。首先，定义GoodsModify类，继承了System.Web.UI.Page系统类：

public class GoodsModify : System.Web.UI.Page

{

protected System.Web.UI.WebControls.TextBox tbx_gname;

protected System.Web.UI.WebControls.RequiredFieldValidator rfv_gname; protected System.Web.UI.WebControls.TextBox tbx_gprice;

protected System.Web.UI.WebControls.RequiredFieldValidator rfv_gprice; protected System.Web.UI.WebControls.TextBox tbx_gprovider1; protected System.Web.UI.WebControls.RequiredFieldValidator protected System.Web.UI.WebControls.TextBox tbx_gprovider2; protected System.Web.UI.WebControls.TextBox tbx_gdescribe; protected System.Web.UI.WebControls.Button btn_modify; protected System.Web.UI.WebControls.Button btn_delete; protected System.Web.UI.WebControls.Label lbl_gid;

protected System.Web.UI.WebControls.HyperLink hlk_goodsmanage; 由于这是一个信息修改页面，系统必须提供原始数据记录，在下面的

rfv_gprovider1;

Page_load()事件中，本系统通过调用存储过程GoodsDetail，实现了各个文本框初始数据绑定。代码如下

private void Page_Load(object sender, System.EventArgs e) {

if(!IsPostBack) {

//从文件Web.config中读取连接字符串

string strconn= ConfigurationSettings.AppSettings[\

28