产品小类管理实训
《产品小类管理实训》由会员分享,可在线阅读,更多相关《产品小类管理实训(7页珍藏版)》请在装配图网上搜索。
1、 实训七 产品小类管理实训目的:实训容:实训过程:1. 界面制作(smallClass.aspx页面)该页面全部静态代码如下:无标题页小类名称:所属大类:小类编号: asp:LabelID=Label1runat=serverText=asp:HiddenFieldID=HiddenField2runat=serverValue=/asp:HiddenFieldID=HiddenField1runat=serverValue=/asp:LabelID=Label1runat=serverText=asp:HiddenFieldID=HiddenField2runat=serverVa
2、lue=/2. 动态代码編写(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.WebControls.WebPa
3、rts;using System.Xml.Linq;publicpartialclassbigClass : System.Web.UI.PagepublicDBfunction db = newDBfunction();protectedvoid Page_Load(object sender, EventArgs e) db.isLogin();if (!IsPostBack) binddata(); db.initDropDownList(DropDownList1, select * from bigclass, bigName, bigID, null); void binddata
4、() GridView1.DataSource = db.getDataView(select * from smallClass); GridView1.DataBind(); protectedvoid Button1_Click(object sender, EventArgs e) if (Sessionquanxian != null & Sessionquanxian.ToString() != 0) ScriptManager.RegisterStartupScript(this, GetType(), , alert(对不起,您的权限不够!), true);return; el
5、se 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 smallClass(smallName,smallID,
6、bigID) values( + TextBox1.Text.Trim() + , + TextBox2.Text.Trim() + , + DropDownList1.SelectedValue.ToString() + ); binddata(); else ScriptManager.RegisterStartupScript(this, GetType(), , alert(小类编号或小类名称不能一样!), true); else ScriptManager.RegisterStartupScript(this, GetType(), , alert(小类名称和小类编号不能为空), t
7、rue); protectedvoid GridView1_RowUpdating(object 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; d
8、rpBigClass = (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 smallid=+ tbsmallID.Text.Trim()+
9、 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.Value); GridView1.EditIndex = -1;
10、 binddata(); else ScriptManager.RegisterStartupScript(this, GetType(), , alert(小类编号或小类名称不能一样), true);/GridView1.EditIndex = -1;/ binddata();return; else ScriptManager.RegisterStartupScript(this, GetType(), , alert(小类名称和小类编号不能为空), true); protectedvoid GridView1_RowEditing(object sender, GridViewEditE
11、ventArgs e) if (Sessionquanxian != null & Sessionquanxian.ToString() != 0) ScriptManager.RegisterStartupScript(this, GetType(), , alert(对不起,您的权限不够!), true);return; else GridView1.EditIndex = e.NewEditIndex; binddata(); protectedvoid GridView1_RowDeleting1(object sender, GridViewDeleteEventArgs e) if
12、 (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(); protectedvoid GridView1_RowCancelingEdit(object
13、 sender, GridViewCancelEditEventArgs e) GridView1.EditIndex = -1; binddata(); protectedvoid 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.styl
14、e.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.FindC
15、ontrol(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 | DataControlRowState.Edit) ) ddl = (DropDownList)e.Row.Cells0.FindControl(DropDownList2); hf = (HiddenField)e.Row.Cells0.FindControl(HiddenField1); db.initDropDownList(ddl, select * from bigclass, bigname, bigID, hf.Value.ToString(); 7 / 7
- 温馨提示:
1: 本站所有资源如无特殊说明,都需要本地电脑安装OFFICE2007和PDF阅读器。图纸软件为CAD,CAXA,PROE,UG,SolidWorks等.压缩文件请下载最新的WinRAR软件解压。
2: 本站的文档不包含任何第三方提供的附件图纸等,如果需要附件,请联系上传者。文件的所有权益归上传用户所有。
3.本站RAR压缩包中若带图纸,网页内容里面会有图纸预览,若没有图纸预览就没有图纸。
4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
5. 装配图网仅提供信息存储空间,仅对用户上传内容的表现方式做保护处理,对用户上传分享的文档内容本身不做任何修改或编辑,并不能对任何下载内容负责。
6. 下载文件中如有侵权或不适当内容,请与我们联系,我们立即纠正。
7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。