实训八供应商信息管理.docx
实训八供应商信息管理实训目的:实训内容:实训过程：1.制作供应商信息管理界面(gongyingshang.aspx)供应商添加版旗询名称I地址I电话：|Email:|联系人:|备注:|没加 Scr>ptNActrl供应商信息ScriptIaBacer供应有名称供应商地址供应荏电话效据绑定数宪绑定数据绑定故据绑定数据绑定数据绑定ffi½效据绑定数据绑定数据绑定数据绑定数据绑定数据绑定ffiB效据绑定效据被数据绑定全部静态代码如下：<%PageLangUage="C#"AUtOEVentWireUP="true"CodeFile=gongyingshang.aspx.cs*Inherits=*gongyingshang*%><headrunat=*server*>title)无标题页/title)<head><body><formid="forml"runat=*server*><div><asp:ScriptManagerID=ScriptManagerl*runat="server”><asp:ScriptManager><asp:UpdatePanelID=*UpdatePanell*runat="server”><ContentTemplate><tableCeIIPadding="O"CellSPaCing="O"StyIe="border:Ipxsolid#3333FF;font-size:14px;*Width="800”align=*center*><tr><tdbgcolor="#6699FF"hcight="30”> 供应商信息 <td><tr><tr><tdStyIe="padding:10px”><tablealign="center“CellPadding="O"CellSPaCing="O"style=*border:Ipxsolid#6699FF;margin-bottom:IOpx;"Width="100%”><tr><tdbgco1or=*ft6699FF*CoISPan="4"height=*30*> 供应商添加/修改/查询 /td><tdbgcolor="#6699FF"height="30”> </td><tdbgcolor="#6699FF"height="30”> </td><tdbgcolor="#6699FF"height="30”> </td><tr><tr><td> 名称：<td><td><asp:TextBoxID=*TextBoxl*runat="server”Width="129px"Xasp:TeXtBOx><td><tdheight=*30*><td><asp:TextBoxID="TextBox2"runat="server”Width="200px"><asp:TeXtBox><td><td><td><asp:TextBoxID="TextBox3”runat="server"><asp:TextBox><td><td> ：</td><tr><tr><td> :Email:</td><td><asp:TextBoxID="TextBox4”runat=*server*></asp:TextBox><td><tdheight=*30*>联系人:<td><td><asp:TextBoxID="TextBox5”runat="server"><asp:TextBox><td><td>备注:<td><td><asp:TextBoxID="TextBox6”runat=*server*></asp:TextBox><td><td><asp:ButtonID=*Bttonl*runat=*server*Text="添加"Width="103px”OnCIiCk="ButtonLCIiCk"><td><tr><table><asp:GridViewID=GriclViewl*runat="server”AutoGenerateCo1UmnS="Fa1se”BackCo1or=，xWhite"BOrderCOIor="#6699FF”BorderSty1e="Solid“BorderWidth="1px"CellPadding="4"Width="100%"DataKeyNameS="id"OnroWCOnInland="GridVieWLROWCOnInlanCronrowdeIeting="GridViewl_RowDeleting*><FooterStyleBaCkCoIOr="#99CCeC"FOreCoIor="#003399”><RowStyleBackColor=wWhite*ForeCOlOr="#003399”/><Columns><asp:BoundFieldDataField=*company*HeaderText=*供应商名称“><aspIBoundFieldDataFieId="address,HeaderText="供应商地址“><asp:BoundFieldDataField="tel"HeaderTcxt="供应商电话”/><asp:TemplateField><ItemTemplate><asp:LinkButtonID=*LinkButtonl7zrunat=*server*CommandArgument=><%#Eval("id")%>,CommandName="xiugai”>修改<asp:LinkButton></ItemTemplate></asp:TemplateField><asp:CommandFieIclShowDeleteButton=zzTrue*><Columns><PagerStyleBaCkCOIor="#99CCCC"FOrCCOIOr="#003399”HorizontalAlign=*Left*><Se1CCtedRowStyleBackCo1Or="#009999”FOnLBold="True"ForeCOIOr="#CCFF99"><HeaderStyleBaCkColOr="#6699FF“Font-Bold=True*FOreCoIOr="Black"></asp:GridView><td><tr><table><ContentTemplate><asp:UpdatePanel><div></form><body><html>2.编写动态代码(gongyingshang.aspx.es)usingSystem;usingSystem.Collections;usingSystem.Configuration;usingSystem.Data;usingSystem.Linq;usingSystem.Web;usingSystem.Web.Security;usingSystem.Web.UI;usingSystem.Web.ULHtmlControls;usingSystem.Web.ULWebControls;usingSystem.Web.ULWebControls.WebParts;usingSystem.Xml.Linq;publicpartialclassgongyingshang:System.Web.ULPage(DBfunctiondb=newDBfunctionO：protectedvoidPage_Load(objectsender,EventArgse)(db.isLogin();if(!IsPostBack)(binddata();)voidbinddata()GridViewl.DataSource=db.getDataView(*select*fromgys");GridViewl.DataBindO；)protectedvoidButtonlClick(objectsender,EventArgse)(stringsqlcheck="”;stringsql="”;if(Sessiontquanxian*I=null&&Session*quanxian*.ToStringO!="0")(ScriptManager.RegisterStartupScript(this,GetTypeO,"","alert('对不起，您的权限不够!)"，true);return;)else(if(TextBoxl.Text.TrimO.Length>0&&TextBox2.Text.Trim().Length>0&&TextBox3.Text.Trim().Length>0&&TextBox5.Text.TrimO.Length>O)(SqICheCk="select*fromgyswherecompany=*"+TextBoxl.Text.TrimO+“'andtel='"+TextBox3.Text.TrimO+“'andname='"+TextBox5.Text.TrimO+if(!db.isExist(sqlcheck)(if(Buttonl.Text="添加")(sql="insertintogys(company,email,name,address,tel,beizhu)values(,+TextBoxl.Text.TrimO+sql+=TextBox4.Text.TrimO+,'"+TextBox5.Text.TrimO+,'"+TextBox2.Text.TrimO+sql+=TextBox3.Text.TrimO+,'"+TextBox6.Text.TrimO+else(sql="updategyssetcompany=*"+TeXtBoXLTeXt.Trim。+”',email='"+TeXtBoX4.Text.Trim。+“',name='"sql+=TextBox5.Text.TrimO+"',address='"+TextBox2.Text.TrimO+"',tel='"+TextBox3.Text.TrimO+sql+="beizhu='"+TextBox6.Text.TrimO+"'whereid="+ViewState*id*.ToStringO;db.SqlExecute(sql);Buttonl.Text="添加”；binddata();TextBoxl.Text=TextBox2.Text=TextBox3.Text="”;TextBox4.Text=TextBox5.Text=TextBox6.Text=TextBoxl.FocusO；)else(ScriptManager.RegisterStartupScript(this,GetTypeO,"”,"alert('该记录已经存在！')"，true);)else(ScriptManager.RegisterStartupScript(this,GetTypeO,"alert('供应商名称、供应商电话与联系人姓名不能为空')"，true);)protectedvoidGridViewl-RowDeleting(objectsender,GridViCwDeleteEventArgse)(if(SeSSiOn"quanxian"!=null&&Session*quanxianw.ToStringO!="0")(ScriptManager.RegisterStartupScript(this,GetTypeO,"","alert('对不起，您的权限不够!)"，true);return;else(db.SqlExecute(deletefromgyswhereid="+GridViewl.DataKeyse.Rowindex.Value);binddataO;)protectedvoidGridViewl_RowCommand(objectsender,GridViewCommandEventArgse)(intid;DataRowdr;if(SessionLquanxian"!=null&&Sessionquanxian.ToStringOI="O")(ScriptManager.RegisterStartupScript(this,GetTypeO,"","alert('对不起，您的权限不够!)"，true);return;)elseTextBoxLText ;TextBox2. Text :TextBox3. Text :TextBox4. Text ;TextBox5. Text :TextBox6. Text :Buttonl. Text =ViewStateE*id*=id;dr=db.getDataRow(,zselect*fromgyswhereid="+id);dr“company".ToStringO；dr,address*.ToStringO；dr,tel*.ToStringO;dr,emailz,.ToStringO；=dr"name".ToStringO;=dr"beizhu".ToStringO;储存”;
