產品小類管理實訓

1、實訓七 產品小類治理實訓目的:實訓內容:實訓過程:界面制作(smallClass.aspx頁面)該頁面全部靜態(tài)代碼如下: 無標題頁 小類名稱： 所屬大類： 小類編號： asp:Label ID=Label1 runat=server Text= asp:HiddenField ID=HiddenField2 runat=server Value= / asp:HiddenField ID=HiddenField1 runat=server Value= / asp:Label ID=Label1 runat=server Text= asp:HiddenField ID=HiddenField

2、2 runat=server Value= / 動態(tài)代碼編寫(smallclass.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.HtmlControls;using System.Web.UI.WebControls;using System.Web.UI.W

3、ebControls.WebParts;using System.Xml.Linq;public partial class bigClass : System.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, bigName, bi

4、gID, null); void binddata() GridView1.DataSource = db.getDataView(select * from smallClass); GridView1.DataBind(); protected void Button1_Click(object sender, EventArgs e) if (Sessionquanxian != null & Sessionquanxian.ToString() != 0) ScriptManager.RegisterStartupScript(this, GetType(), , alert(對不起，

5、您的權限不夠!), true); return; else if (TextBox1.Text.Trim().Length 0 & TextBox2.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 sm

6、allClass(smallName,smallID,bigID) values( + TextBox1.Text.Trim() + , + TextBox2.Text.Trim() + , + DropDownList1.SelectedValue.ToString() + ); binddata(); else ScriptManager.RegisterStartupScript(this, GetType(), , alert(小類編號或小類名稱不能相同！), true); else ScriptManager.RegisterStartupScript(this, GetType()

7、, , alert(小類名稱和小類編號不能為空), true); protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) TextBox tbsmallName, tbsmallID; DropDownList drpBigClass; string sqlcheck=,sqlupdate=; tbsmallID = (TextBox)GridView1.Rowse.RowIndex.Cells2.Controls0; tbsmallName = (TextBox)GridView1.Rows

8、e.RowIndex.Cells1.Controls0; drpBigClass = (DropDownList)GridView1.Rowse.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 s

9、mallid=+ tbsmallID.Text.Trim()+ or smallname=+tbsmallName.Text.Trim()+; if (!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.V

10、alue); GridView1.EditIndex = -1; binddata(); else ScriptManager.RegisterStartupScript(this, GetType(), , alert(小類編號或小類名稱不能相同), true); /GridView1.EditIndex = -1; / binddata(); return; else ScriptManager.RegisterStartupScript(this, GetType(), , alert(小類名稱和小類編號不能為空), true); protected void GridView1_Row

11、Editing(object sender, GridViewEditEventArgs e) if (Sessionquanxian != null & Sessionquanxian.ToString() != 0) ScriptManager.RegisterStartupScript(this, GetType(), , alert(對不起，您的權限不夠!), true); return; else GridView1.EditIndex = e.NewEditIndex; binddata(); protected void GridView1_RowDeleting1(object

12、 sender, GridViewDeleteEventArgs e) if (Sessionquanxian != null & Sessionquanxian.ToString() != 0) ScriptManager.RegisterStartupScript(this, GetType(), , alert(對不起，您的權限不夠!), true); return; else db.sqlExecute(delete from smallClass where id= + GridView1.DataKeyse.RowIndex.Value); binddata(); protecte

13、d void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs 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

14、.Row.Attributes.Add(onmouseover, bg=this.style.backgroundColor; this.style.backgroundColor=#dddddd); e.Row.Attributes.Add(onmouseout, this.style.backgroundColor=bg); if (e.Row.RowState = DataControlRowState.Alternate | 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 = drbigname.ToString(); if (e.Row.RowState = DataControlRowState.Edit | e.Row.RowState = (DataControlRowState.Alternate