发布时间 : 星期一 文章基于ASP.NET仓库管理信息系统 - 图文更新完毕开始阅读fd8273fb770bf78a652954a3
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