实训六产品大类管理

1、实训六 产品大类管理 实训目的 :实训内容 :实训过程 :1. 界面制作 （bigClass.aspx 页面 ）该页面全部静态代码如下 :无标题页 大类名称： 大类编号： 2. 动态代码编写 (bigClass.aspx.cx):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.H

2、tmlControls;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Xml.Linq;PageEventArgs e)public partial class bigClass : System.Web.UI.DBfunction db = new DBfunction ();protected void Page_Load( object sender,db.isLogin();if (!IsPostBack)binddata();void binddata()Gr

3、idView1.DataSource = db.getDataView(GridView1.DataBind();protected void Button1_Click( object sender,if (Session quanxian != null &Session quanxian .ToString() != 0 )ScriptManager .RegisterStartupScript(alert( 对不起，您的权限不够 !) , true );select * from bigClass );EventArgs e)this , GetType(), returnelseif

4、 (TextBox1.Text.Trim().Length 0 &TextBox2.Text.Trim().Length0)if (!db.isExist( select * from bigClass where bigID=TextBox2.Text.Trim() + or bigName= + TextBox1.Text.Trim() + )db.sqlExecute(insert into bigClass(bigName,bigID)values( + TextBox1.Text.Trim() + TextBox2.Text.Trim() +);binddata();elseScri

5、ptManager .RegisterStartupScript( this , GetType(),alert( 大类编号或大类名称不能相同！ ) , true );elseScriptManager .RegisterStartupScript( this , GetType(), alert( 大类名称和大类编号不能为空 ) , true );protected void GridView1_RowUpdating( object sender, GridViewUpdateEventArgs e)TextBox tbName,tbID;string sqlcheck = ;tbID =

6、 ( TextBox )GridView1.Rowse.RowIndex.Cells0.Controls0;tbName =( TextBox )GridView1.Rowse.RowIndex.Cells1.Controls0;if (tbName.Text.Trim().Length 0 & tbID.Text.Trim().Length0)sqlcheck =select * from (select * from bigllclass where id) as t1 where bigid=+ GridView1.DataKeyse.RowIndex.Value +tbID.Text.

7、Trim() + or bigname= + tbName.Text.Trim() + ;if (!db.isExist(sqlcheck)db.sqlExecute(update bigClass set bigName=+tbName.Text.Trim() +,bigID= + tbID.Text.Trim() + where id=GridView1.DataKeyse.RowIndex.Value);GridView1.EditIndex = -1;binddata();elseScriptManager .RegisterStartupScript( this , GetType(

8、),alert( 大类编号或大类名称不能相同 ) , true );/GridView1.EditIndex = -1;/ binddata();returnelseScriptManager .RegisterStartupScript( this , GetType(),alert( 大类名称和大类编号不能为空 ) , true );protected void GridView1_RowEditing( object sender, GridViewEditEventArgs e)GridView1.EditIndex = e.NewEditIndex;binddata();protec

9、ted void GridView1_RowDeleting1( object sender,GridViewDeleteEventArgs e)if (Session quanxian != null &Session quanxian .ToString() != 0 )ScriptManager .RegisterStartupScript( this , GetType(),alert( 对不起，您的权限不够 !) , true );return ;elsedb.sqlExecute(delete from bigClass where id=+GridView1.DataKeyse.RowIndex