产品小类管理实训七

1、实训七产品小类管理实训目的：实训内容： 实训过程：1. 界面制作（smallClass.aspx 页面）该页面全部静态代码如下： 无标题页 TOC o 1-5 h z 小类名称： 所属大类： 小类编号： / td / td / td Text = runat =serverrunat =serverrunat =serverText = runat =serverHeaderText =小类名称小类编号HorizontalAlign =Left /Font-Bold =True ForeColorColumnsasp: HiddenField ID=HiddenField2”Value = /

2、asp: DropDownList ID =DropDownList2asp: HiddenField ID=HiddenField1Value = ， /ItemTemplate asp: HiddenField ID=HiddenField2Value = /ItemStyle Width =150px” /asp: BoundField DataField =smallNameasp: BoundField DataField =smallID HeaderText = 2.动态代码编写(smallclass.aspx.cx) using System;using System.Coll

3、ections;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 bigClass : System

4、.Web.UI. Page public DBfunction db = new DBfunction (); protected void Page_Load( object sender, EventArgs e)db.isLogin(); if (!IsPostBack)binddata();db.initDropDownList(DropDownList1,select * from bigclass , bigNamebigID , null ); void binddata()GridView1.DataSource = db.getDataView(select * from s

5、mallClass );GridView1.DataBind();protected void Button1_Click( object sender, EventArgs e)if (Session quanxian != null & Session quanxian .ToString() !=0 )ScriptManager .RegisterStartupScript( this , GetType(), , alert( 对不起， 您的权限不够!) , true );return ;elseif (TextBox1.Text.Trim().Length 0 & TextBox2.

6、Text.Trim().Length 0)if (!db.isExist( select * from smallClass where smallID=+TextBox2.Text.Trim() + and smallName= + TextBox1.Text.Trim() + and bigid= +DropDownList1.SelectedValue.ToString()+ ) db.sqlExecute(insert into smallClass(smallName,smallID,bigID)values( + TextBox1.Text.Trim() +,+ TextBox2.

7、Text.Trim() +,+DropDownList1.SelectedValue.ToString() +) );binddata();elseScriptManager .RegisterStartupScript( this , GetType(), , alert( 小类编号或小类名称不能相同！ ) , true ); else ScriptManager .RegisterStartupScript( this , GetType(), , alert( 小 类名称和小类编号不能为空) , true );protected void GridView1_RowUpdating( o

8、bject sender, GridViewUpdateEventArgs e)TextBox tbsmallName, tbsmallID;DropDownList drpBigClass;string sqlcheck= ,sqlupdate=tbsmallID = ( TextBox )GridView1.Rowse.RowIndex.Cells2.Controls0;tbsmallName = ( TextBox )GridView1.Rowse.RowIndex.Cells1.Controls0; drpBigClass =( DropDownList )GridView1.Rows

9、e.RowIndex.Cells0.FindControl(DropDownList2 );if (tbsmallName.Text.Trim().Length 0 & tbsmallID.Text.Trim().Length 0) sqlcheck=select * from (select * from smallclass where id+GridView1.DataKeyse.RowIndex.Value +) as t1 where smallid= +tbsmallID.Text.Trim()+ or smallname= +tbsmallName.Text.Trim()+ ;i

10、f (!db.isExist(sqlcheck)db.sqlExecute(update smallClass set smallName= +tbsmallName.Text.Trim() + ,smallID= + tbsmallID.Text.Trim() +,bigID=drpBigClass.SelectedValue.ToString() + where id= +GridView1.DataKeyse.RowIndex.Value);GridView1.EditIndex = -1;binddata(); elseScriptManager .RegisterStartupScr

11、ipt( this , GetType(), , alert( 小 类编号或小类名称不能相同 ) , true );/GridView1.EditIndex = -1;/ binddata();return ; elseScriptManager .RegisterStartupScript( this , GetType(), , alert( 小类名 称和小类编号不能为空) , true );protected void GridView1_RowEditing( object sender, GridViewEditEventArgs e)if (Session quanxian !=

12、null & Session quanxian .ToString() !=0 )ScriptManager .RegisterStartupScript( this , GetType(), , alert( 对不起， 您的权限不够!) , true );returnelseGridView1.EditIndex = e.NewEditIndex;binddata();protected void GridView1_RowDeleting1( object sender, GridViewDeleteEventArgs e) if (Session quanxian != null & S

13、ession quanxian .ToString() !=0 )ScriptManager .RegisterStartupScript( this , GetType(), , alert( 对不起，您的权限不够!) , true );return ;elsedb.sqlExecute(delete from smallClass where id=+GridView1.DataKeyse.RowIndex.Value);binddata();protected void GridView1_RowCancelingEdit( object sender, GridViewCancelEd

14、itEventArgs e)GridView1.EditIndex = -1;binddata();protected void GridView1_RowDataBound( object sender, GridViewRowEventArgs e) DataRow dr;Label Lb;DropDownList ddl;HiddenField hf;if (e.Row.RowType = DataControlRowType .DataRow)e.Row.Attributes.Add(onmouseover , bg=this.style.backgroundColor;this.st

15、yle.backgroundColor=#dddddd );e.Row.Attributes.Add(onmouseout , this.style.backgroundColor=bg );DataControlRowState .Alternate | e.Row.RowState =if (e.Row.RowState =DataControlRowState .Normal)Lb = (Label )e.Row.Cells0.FindControl( Label1 );hf = (HiddenField )e.Row.Cells0.FindControl(HiddenField2 );dr = db.getDataRow(select * from bigClass where bigid=hf.Value.ToString() +Lb.Text = dr );bigname .ToString();if (e.Row.RowState = DataControlRowState( DataControlRowState.Alternate | DataControlRow