实训六产品大类管理

1、实训六产品大类管理实训目的：实训内容： 实训过程：1. 界面制作（bigClass.aspx页面）Srr一 3cr大娄名诵1左辎弔1n |港U 1I衣対6号fitt集辑删除i|教据娜定澈据那定1坟据娜定该页面全部静态代码如下 vhtml xml ns =/1999/xhtml无标题页 大类名称：大类编号： 2. 动态代码编写 (bigClass.aspx.cx): using System;using System.Collections;using System.Configuration;using System.Data;using System.Linq

2、;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;Pagepublic partial class bigClass : System.Web.UI. EventArgs e)DBfunction db = new DBfunction (); protected

3、 void Page_Load( object sender, db.isLogin();if (!IsPostBack) binddata();void binddata()GridView1.DataSource = db.getDataView(select * from bigClass);GridView1.DataBind();protected void Button1_Click( object sender, EventArgs e)if (Session quanxian != null & Session quanxian .ToString() !=0 )ScriptM

4、anager .RegisterStartupScript( this , GetType(), , alert( 对不起， 您的权限不够 !) , true );return ;elseif (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 bi

5、gClass(bigName,bigID) values( + TextBox1.Text.Trim() +, + TextBox2.Text.Trim() + ) );binddata();elseScriptManager .RegisterStartupScript( this , GetType(), ,alert( 大类编号或大类名称不能相同！ ) , true );elseScriptManager .RegisterStartupScript( this , GetType(), , alert( 大 类名称和大类编号不能为空 ) , true );protected void

6、GridView1_RowUpdating( object sender, GridViewUpdateEventArgs e)TextBox tbName,tbID;string sqlcheck = ;tbID = ( 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

7、* from (select * from bigllclass where id+GridView1.DataKeyse.RowIndex.Value + ) as t1 where bigid= + tbID.Text.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.

8、DataKeyse.RowIndex.Value);GridView1.EditIndex = -1;binddata();elseScriptManager .RegisterStartupScript( this , GetType(), , alert( 大 类编号或大类名称不能相同 ) , true );/GridView1.EditIndex = -1;/ binddata(); return ; elseScriptManager .RegisterStartupScript( this , GetType(), , alert( 大类名 称和大类编号不能为空 ) , true )

9、;protected void GridView1_RowEditing( object sender, GridViewEditEventArgs e)GridView1.EditIndex = e.NewEditIndex; binddata();protected 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.Ro