实训八 供应商信息管理.doc

实训八 供应商信息管理实训目的：实训内容：实训过程：1. 制作供应商信息管理界面(gongyingshang.aspx)全部静态代码如下： 无标题页     供应商信息    供应商添加/修改/查询          名称: 地址: 电话:     Email: 联系人: 备注: asp:LinkButton ID=LinkButton1 runat=server CommandArgument= CommandName=xiugai修改 2. 编写动态代码(gongyingshang.aspx.cs)using System;using System.Collections;using System.Configuration;using System.Data;using System.Linq;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.HtmlControls;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Xml.Linq;public partial class gongyingshang : System.Web.UI.Page DBfunction db = new DBfunction(); protected void Page_Load(object sender, EventArgs e) db.isLogin(); if (!IsPostBack) binddata(); void binddata() GridView1.DataSource = db.getDataView(select * from gys); GridView1.DataBind(); protected void Button1_Click(object sender, EventArgs e) string sqlcheck = ; string sql = ; if (Sessionquanxian != null & Sessionquanxian.ToString() != 0) ScriptManager.RegisterStartupScript(this, GetType(), , alert(对不起，您的权限不够!), true); return; else if (TextBox1.Text.Trim().Length 0 & TextBox2.Text.Trim().Length 0 & TextBox3.Text.Trim().Length 0 & TextBox5.Text.Trim().Length 0) sqlcheck=select * from gys where company= + TextBox1.Text.Trim() + and tel= + TextBox3.Text.Trim() + and name= + TextBox5.Text.Trim() + ; if (!db.isExist(sqlcheck) if (Button1.Text = 添加) sql = insert into gys(company,email,name,address,tel,beizhu) values( + TextBox1.Text.Trim() + ,; sql += TextBox4.Text.Trim() + , + TextBox5.Text.Trim() + , + TextBox2.Text.Trim() + ,; sql += TextBox3.Text.Trim() + , + TextBox6.Text.Trim() + ); else sql = update gys set company= + TextBox1.Text.Trim()+,email= + TextBox4.Text.Trim()+,name= ; sql += TextBox5.Text.Trim() + ,address= + TextBox2.Text.Trim() + ,tel= + TextBox3.Text.Trim() + ,; sql += beizhu= + TextBox6.Text.Trim() + where id= + ViewStateid.ToString(); db.sqlExecute(sql); Button1.Text = 添加; binddata(); TextBox1.Text = ; TextBox2.Text = ; TextBox3.Text = ; TextBox4.Text = ; TextBox5.Text = ; TextBox6.Text = ; TextBox1.Focus(); else ScriptManager.RegisterStartupScript(this, GetType(), , alert(该记录已经存在！), true); else ScriptManager.RegisterStartupScript(this, GetType(), , alert(供应商名称、供应商电话和联系人姓名不能为空), true); protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) if (Sessionquanxian != null & Sessionquanxian.ToString() != 0) ScriptManager.RegisterStartupScript(this, GetType(), , alert(对不起，您的权限不够!), true); return; else db.sqlExecute(delete from gys where id= + GridView1.DataKeyse.RowIndex.Value); binddata(); protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) int id; DataRow dr; if (Sessionquanxian != null & Sessionquanxian.ToString() != 0) ScriptManager.RegisterStartupScript(this, GetType(), , alert(对不起，您的权限不够!), true); return; else if (e.CommandName = xiugai) id = int.Parse(e.CommandArgument.ToString(); ViewStateid = id; dr = db.getDataRow(select * from gys where id= + id); TextBox1.Text = drcompany.ToString(); TextBox2.Text = draddress.ToString(