产品小类管理实训_第1页
产品小类管理实训_第2页
产品小类管理实训_第3页
产品小类管理实训_第4页
产品小类管理实训_第5页
已阅读5页，还剩2页未读， 继续免费阅读

下载本文档

版权说明：本文档由用户提供并上传，收益归属内容提供方，若内容存在侵权，请进行举报或认领

文档简介

1、 实训七 产品小类管理实训目的:实训容:实训过程:1. 界面制作(smallClass.aspx页面)该页面全部静态代码如下:<%PageLanguage="C#"AutoEventWireup="true"CodeFile="smallClass.aspx.cs"Debug="true"Inherits="bigClass"%><!DOCTYPEhtmlPUBLIC"-/W3C/DTD XHTML 1.0 Transitional/EN"".w3

2、.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><htmlxmlns="./1999/xhtml"><headrunat="server"><title>无标题页</title><linkhref="style.css"rel="stylesheet"type="text/css"/></head><body><formid="f

3、orm1"runat="server"><div><asp:ScriptManagerID="ScriptManager1"runat="server"></asp:ScriptManager><tablealign="center"cellpadding="0"cellspacing="0"width="800"><tr><td><asp:UpdatePanel

4、ID="UpdatePanel1"runat="server"><ContentTemplate><tablealign="center"cellpadding="0"cellspacing="0"width="100%"style="border: 1pxsolid#C0C0C0; margin-top: 5px; margin-bottom: 5px;"><trbgcolor="Silver"&g

5、t;<tdalign="center"width="200">小类名称：</td><tdalign="center"height="35"width="200">所属大类：</td><tdalign="center"height="35"width="200">小类编号：</td><tdalign="center">&nbsp

6、;</td></tr><tr><tdalign="center"><asp:TextBoxID="TextBox1"runat="server"Width="92px"></asp:TextBox></td><tdalign="center"height="35"><asp:DropDownListID="DropDownList1"runat="

7、;server"></asp:DropDownList></td><tdalign="center"height="35"><asp:TextBoxID="TextBox2"runat="server"Width="82px"></asp:TextBox></td><tdalign="center"><asp:ButtonID="Button1"run

8、at="server"onclick="Button1_Click"Text="添加"Width="77px"/></td></tr></table><asp:GridViewID="GridView1"runat="server"AutoGenerateColumns="False"BackColor="White"BorderColor="#3366CC"Borde

9、rStyle="None"BorderWidth="1px"CellPadding="4"CssClass="gridview"DataKeyNames="id"onrowcancelingedit="GridView1_RowCancelingEdit"onrowdatabound="GridView1_RowDataBound"onrowdeleting="GridView1_RowDeleting1"onrowediting=&q

10、uot;GridView1_RowEditing"onrowupdating="GridView1_RowUpdating"Width="100%"><FooterStyleBackColor="#99CCCC"ForeColor="#003399"/><RowStyleBackColor="White"ForeColor="#003399"/><Columns><asp:TemplateFieldHeaderText

11、="大类名称"><AlternatingItemTemplate><asp:LabelID="Label1"runat="server"Text='<%# Bind("bigID") %>'></asp:Label><asp:HiddenFieldID="HiddenField2"runat="server"Value='<%# Eval("bigID") %>

12、'/></AlternatingItemTemplate><EditItemTemplate><asp:DropDownListID="DropDownList2"runat="server"></asp:DropDownList><asp:HiddenFieldID="HiddenField1"runat="server"Value='<%# Eval("bigID") %>'/></E

13、ditItemTemplate><ItemTemplate><asp:LabelID="Label1"runat="server"Text='<%# Bind("bigID") %>'></asp:Label><asp:HiddenFieldID="HiddenField2"runat="server"Value='<%# Eval("bigID") %>'/><

14、;/ItemTemplate><ItemStyleWidth="150px"/></asp:TemplateField><asp:BoundFieldDataField="smallName"HeaderText="小类名称"><ItemStyleWidth="150px"/></asp:BoundField><asp:BoundFieldDataField="smallID"HeaderText="小类编号&qu

15、ot;><ItemStyleWidth="150px"/></asp:BoundField><asp:CommandFieldShowEditButton="True"/><asp:CommandFieldShowDeleteButton="True"><ItemStyleWidth="100px"/></asp:CommandField></Columns><PagerStyleBackColor="#99C

16、CCC"ForeColor="#003399"HorizontalAlign="Left"/><SelectedRowStyleBackColor="#009999"Font-Bold="True"ForeColor="#CCFF99"/><HeaderStyleBackColor="#003399"Font-Bold="True"ForeColor="#CCCCFF"/></asp:Gri

17、dView></ContentTemplate></asp:UpdatePanel></td></tr></table></div></form></body></html>2. 动态代码編写(smallclass.aspx.cx)using System;using System.Collections;using System.Configuration;using System.Data;using System.Linq;using System.Web;using Sys

18、tem.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;publicpartialclassbigClass : System.Web.UI.PagepublicDBfunction db = newDBfunction();protectedvoid Page_Load(object sender, EventArgs e

19、) db.isLogin();if (!IsPostBack) binddata(); db.initDropDownList(DropDownList1, "select * from bigclass", "bigName", "bigID", null); void binddata() GridView1.DataSource = db.getDataView("select * from smallClass"); GridView1.DataBind(); protectedvoid Button1_C

20、lick(object sender, EventArgs e) if (Session"quanxian" != null && Session"quanxian".ToString() != "0") ScriptManager.RegisterStartupScript(this, GetType(), "", "alert('对不起，您的权限不够!')", true);return; else if (TextBox1.Text.Trim().Length

21、 > 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()+"

22、9;") db.sqlExecute("insert into smallClass(smallName,smallID,bigID) values('" + TextBox1.Text.Trim() + "','" + TextBox2.Text.Trim() + "','" + DropDownList1.SelectedValue.ToString() + "')"); binddata(); else ScriptManager.RegisterSt

23、artupScript(this, GetType(), "", "alert('小类编号或小类名称不能一样！')", true); else ScriptManager.RegisterStartupScript(this, GetType(), "", "alert('小类名称和小类编号不能为空')", true); protectedvoid GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) Text

24、Box tbsmallName, tbsmallID;DropDownList drpBigClass;string sqlcheck="",sqlupdate="" tbsmallID = (TextBox)GridView1.Rowse.RowIndex.Cells2.Controls0; tbsmallName = (TextBox)GridView1.Rowse.RowIndex.Cells1.Controls0; drpBigClass = (DropDownList)GridView1.Rowse.RowIndex.Cells0.FindCo

25、ntrol("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

26、()+"' or smallname='"+tbsmallName.Text.Trim()+"'"if (!db.isExist(sqlcheck) db.sqlExecute("update smallClass set smallName='" + tbsmallName.Text.Trim() + "',smallID='" + tbsmallID.Text.Trim() + "',bigID='" + drpBigClass

27、.SelectedValue.ToString() + "' where id=" + GridView1.DataKeyse.RowIndex.Value); GridView1.EditIndex = -1; binddata(); else ScriptManager.RegisterStartupScript(this, GetType(), "", "alert('小类编号或小类名称不能一样')", true);/GridView1.EditIndex = -1;/ binddata();return

28、; else ScriptManager.RegisterStartupScript(this, GetType(), "", "alert('小类名称和小类编号不能为空')", true); protectedvoid GridView1_RowEditing(object sender, GridViewEditEventArgs e) if (Session"quanxian" != null && Session"quanxian".ToString() != "0

29、") ScriptManager.RegisterStartupScript(this, GetType(), "", "alert('对不起，您的权限不够!')", true);return; else GridView1.EditIndex = e.NewEditIndex; binddata(); protectedvoid GridView1_RowDeleting1(object sender, GridViewDeleteEventArgs e) if (Session"quanxian" !=

30、null && Session"quanxian".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 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 = Dat

人人文库> 全部分类> 应用文书 > 产品手册

温馨提示

  • 1. 本站所有资源如无特殊说明，都需要本地电脑安装OFFICE2007和PDF阅读器。图纸软件为CAD,CAXA,PROE,UG,SolidWorks等.压缩文件请下载最新的WinRAR软件解压。
  • 2. 本站的文档不包含任何第三方提供的附件图纸等，如果需要附件，请联系上传者。文件的所有权益归上传用户所有。
  • 3. 本站RAR压缩包中若带图纸，网页内容里面会有图纸预览，若没有图纸预览就没有图纸。
  • 4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
  • 5. 人人文库网仅提供信息存储空间，仅对用户上传内容的表现方式做保护处理，对用户上传分享的文档内容本身不做任何修改或编辑，并不能对任何下载内容负责。
  • 6. 下载文件中如有侵权或不适当内容，请与我们联系，我们立即纠正。
  • 7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。

最新文档

评论

0/150

提交评论