还剩5页未读,继续阅读
文本内容:
实训七产品小类管理实训目的:实训内容:实训过程
1.界面制作(smaHClass.aspx页面)Scriptlnag«r-Scnpdlg岭rl小类名称,MB所属大类,■■小类编号।未绑定习।添加该页面全部静态代码如下%@PageLanguage=C#AutoEventWireup=*true,/CodeFile=/,smallClass.aspx.cs*Debug=trueInherits=bigClass%headrunat=wserver*titie〉无标题页/titlelinkhref=*style.css*rcl=stylesheettype=*text/css*//headbodyformid=formlrunat=server”divasp:ScriptManagorID=//ScriptManagcrTrunat=,,scrver,z/asp:ScriptManagertablealign=center“cellpadding=Ocellspacing=O,/width=z,800*trtdasp:UpdatePanelID=//UpdatePanel1,zrunat=z,server,,ContentTemplatetablealign=ccnter“ccllpadding=Ocellspacing=,/O/,width^lOO%style=*border:Ipxsolid#COCOCO;margin-top:5px;margin-bottom:5px;”trbgcolor=wSilverwldalign=*cenler//widlh=200”小类名称/tdtdalign=*center*height=*35*widih=200”所属大类/tdtdalign=*ccntcrz,height=35width=*200*小类编号/tdtdalign=center”Snbsp;/td/trtrtdalign=//center,zasp:TextBoxID=TcxlBoxlrunat=z,server/,Width=w92pxwX/asp:TextBox/tdtdalign=centerheight=35”asp:DropDownListID=^DropDownLis11runat=*serverA,/asp:DropDo\vnList/tdtdalign=/,center,/height=*35*asp:TextBoxID=TcxtBox2runat=//scrverz,Width=w82px,,X/asp:TextBox/tdtdalign=*centerA,asp:ButtonID=ButtonI“runat=server”onclick=z,Buttonl_Click/,Text=添加”Width=77px/,//td/tr/tableasp:GridViewID=GridViewl“runat=server”AutoGenorateColumns=^Falsc^BackColor=/,WhiteBorderColor=”#3366CC”BorderStyle=NoneBorderWidth=lpxCel1Padding=4CssClass=gridview”DataKeyNames=z,id”onrowcance1ingedil=GridView1RowCancelingEdit”onrowdatabound=/,GridViewlRowDataBound”onrowdeloting=/,GridViow1RowDcletingT/onrowediting=GridView1RowEditing”onrowupdating=,,GridViewlRowllpdating”Widlh=100%”FooterStyleBackColor=#99CCCCForeCo1or=,,#003399,//RowStyleBackColor=*White*ForeColor=#003399”/Columnsasp:TempiateFieldHeaderText=大类名称》Text=%#BindbigID%/asp:LabelText=%#BindCbiglD/asp:LabelFont-Bold=*True*ForeColor=#CCFF99”/ForeColor=#CCCCFF”//asp:GridView/ContentTemplate/asp:UpdatePanc1/td/tr/lable/div/form/body/html
2.动态代码编写smallclass.aspx.cxusingSystem;usingSystem.Collections;usingSystem.Configuration;usingSystem.Data;usingSystem.Linq;usingSystem.Web;usingSystem.Web.Security;usingSystem.Web.LI;usingSystem.Web.CT.HtmlControls;usingSystem.Web.ILWcbControls;usingSystem.Web.UI.WebControls.WebParts;usingSystem.Xml.Linq;publicpartialclassbigClass:System.Web.UI.Pagepub1icDBfunctiondb=newDBfunction;protectedvoidPage_LoadobjectsenderEventArgsedb.isLoginO;if!IsPostBackbinddataO;db.initDropDownListDropDownList1select*frombigclassbigName”“bigID”null;}voidbinddataOGridViewl.DataSource=db.getDataViewselect*fromsmalIClass;GridVicwl.DataBindO;protecledvoidButton1_C1ickobjectsenderEventArgseifSession[z,quanxian,z]!=nullSession[*quanxian*].ToString!=0ScriptManager.RegisterStartupScriptthisGetTypcaleri对不起您的权限不够!true;return;elseifTextBoxl.Text.Trim.Length0TextBox
2.Text.TrimO.Length0if!db.isExistselect*fromsmalICIasswheresmallID=+TextBox
2.Text.TrimO+andsmallName=+TextBoxl.Text.TrimO+andbigid=+DropDownListl.SelectedValue.ToString+w,/db.sqlExecute/zinsertintosmalIClasssnialINamesmallIDbigIDvalues+TextBoxl.Text.TrimO++TextBox
2.Text.TrimO++DropDownListl.SelectedValue.ToString+;binddata;elseScriptManager.RegisterStartupScriptthisGetTypeOalert小类编号或者小类名称不能相同!true;elseScriptManager.RegisterStartupScriptthisGetTypealert小类名称与小类编号不能为空〃,true;protectedvoidGridView1_RowUpdatingobjectsenderGrid\ewlpdateEventArgseTextBoxtbsmallNametbsmalHD;DropDownListdrpBigClass;stringsqlcheck=sqlupdate=;tbsmalllD=TcxiBoxGridVicwl.Rows[c.Rowindex].Cells
[2].Controls
[0];tbsmalIName=TextBoxGridViewl.Rows[e.Rowindex].Cellsfl]Controls
[0];drpBigClass=DropDownLis1GridView
1.Rows[e.Rowindex].CelIs
[0].FindControlCDropDownList2,z;iftbsmallName.Text.TrimO.Length0tbsmalllD.Text.TrimO.Length0sqlcheck=/,select*fromselect*fromsmalIclasswhereid*+GridViewl.DataKeysfe.Rowindex].Value+astlwheresmallid=+tbsmalllD.Text.Trim+“orsmallname=,w+tbsmalIName.Text.Trim+,z,;if!db.isExistsqlcheckdb.sqlExecuteupdatesmallClasssetsmallNamc=,*+tbsmallName.Text.TrimO+smal1ID=+tbsmal1ID.Text.TrimO+bigID=+drpBigClass.SelectedValue.ToStringO+whereid=+GridViewl.DataKeysfe.Rowindex].Value;GridViewl.Editindex=-1;binddata0;elseScriptManager.RegisterStartupScriptthisGetTypealert小类编号或者小类名称不能相同,true;//GridViewl.Editindex=-1;//binddataO;return;else{ScriptManager.RegisterStartupScriptthisGetTypealert小类名称与小类编号不能为空,true;protectedvoidGridView1_RowEditingobjectsenderGridViewEditEventArgseifSession[quanxian]!=nullSession[^quanxian].ToStringO!=0ScriptManager.RegisterStartupScriptthisGetTypealert对不起您的权限不够!’,true;return;elseGridViewl.Editindex=c.NewEditIndex;binddataO;}protectedvoidGridViewlRowDeletinglobjectsenderGridViewDo1cteEvcntArgsoifSession[quanxian]!=nullSession[wquanxianz,].ToStringO!=0ScriptManager.RegisterStartupScriptthisGetType0alert为不起,您的权限不够!,true;return;elsedb.sqlExecutedeletefromsmalIClasswhereid=+GridViewl.DataKeysLe.Rowindex].Value;binddataO;}protectedvoidGridViewlRowCancelingEditobjectsenderGridViewCancelEditEventArgse{GridViewl.Editindex=-1;binddataO;}protectedvoidGridViewlRowDataBoundobjectsenderGrid\iewRowEventArgse{DalaRowdr;LabelLb;DropDownListddl;HiddenFieldhf;ife.Row.RowType==DataControlRowType.DataRowe.Row.Attributes.AddConmouseoverbg=this.style.backgroundColor;this.style.backgroundColor=,#dddddd;e.Row.Attributes.Add/,onmouseout,\thisstyle.backgroundColor=bgz,;ife.Row.RowState-DataControlRowState.AlternateIIe.Row.RowState==DataContro]RowState.NormalLb=Labele.Row.Cells
[0].FindControl^Labell*;hf=HiddenFielde.Row.CellsfO].FindControl/,HiddenField2,/;dr=db.getDataRow,zselect*frombigClasswherebigid=+hf.Value.ToStringO+•、Lb.Text=drf^bignameLToStringO;ife.Row.RowState==DataControlRowState.Edit||e.Row.RowState==DataControlRowSUite.Alternate|DataControlRowSlale.Editddl=DropDownListe.Row.Cells[0j.FindContro1DropDownLis12,;hf=HiddenFielde.Row.Cells
[0].FindControl,/HiddenFielir,;db.initDropDownListddlselect*frombigclass*“bignamebigID”hf.Value.ToStringO;}大类名称小奏名称小美编号数据绑定数据绑定故据绑定出除数据绑定数据绑定数据绑定州除数据绑定数据绑定数据绑定幅数据绑定数据绑定数据绑定缰辑嗨数据绑定数据排定数据绑定AlternatingItemTomplatcasp:LabelID=Labe]1runat=server”asp:HiddenFieldID=*HiddenField2*runat=z,server/,Value=’翻EvalCbiglD%//AlternatingItemTemplateEditltcmTemplateasp:DropDownListID=,zDropDown1is12runat=*server*/asp:DropDownListasp:fliddenFieldlD=HiddenFieldl”runal=server”Value』翩EvalbigID%//EditItcmTemplateItemTemplateasp:LabellD=*Labcil*runat=*sorverz,asp:HiddenFieldID=HiddenField2runal=server”Value=翻EvalCbiglD*%//ItemTemplate1temStyleWidth=*150px*//asp:TemplateFieldasp:BoundFieldDataField=,,smalIName*HeaderText=小类名称ItemStyleWidlh=150px”//asp:BoundFieldasp:Boundl;icldDatal;ield=z/smalllD,/IIcadcrTcxt=w小类编号“ItemStyleWidth=150px”//asp:BoundFieldasp:CommandFieldShowEditButton=*True/,/asp:CommandFieldShowDeleteButton=True”ItemStyleWidth=*100px*//asp:CommandPie1d/ColumnsPagerStyleBackColor=#99CCCCForeColor=#003399HorizontalAlign=/,Left,//SelectedRowSty1eBackCo1or=#009999HeaderStyleBackColor=#003399Font-Bold=True。