实训六 产品大类管理

实训内容实训过程界面制作(bigClass.aspx页面该页面全部静态代码如下<%@PageLanguage="C#"AutoEventWireup="true"CodeFile="bigClass.aspx.cs"Inherits="bigClass"%><!DOCTYPEhtmlPUBLIC"-//W3C//DTDXHTML1.0Transitional//EN"<html<head<formid="form1"<asp:ScriptManagerID="ScriptManager1"<tablealign="center"cellpadding="0"cellspacing="0"

<asp:UpdatePanelID="UpdatePanel1"<tablealign="center"cellpadding="0"style="border:1pxsolid#C0C0C0;margin-top:margin-bottom:

<tdalign="right"<tdonclick="Button1_Click"Text="添加

<asp:TextBoxID="TextBox1"<tdalign="right"height="35"<td<asp:TextBox<td<asp:ButtonID="Button1"Width="77px"

<asp:GridViewID="GridView1"BackColor="White"BorderStyle="None" Width="100%"DataKeyNames="id"<FooterStyleBackColor="#99CCCC"号类名称HorizontalAlign="Left"/>ForeColor="#CCFF99"

<RowStyleBackColor="White"ForeColor="#003399"<asp:BoundFieldDataField="bigID"HeaderText="<asp:BoundFieldDataField="bigName"HeaderText="<ItemStyleWidth="200px"<asp:CommandFieldShowEditButton="True"<asp:CommandFieldShowDeleteButton="True"<PagerStyleBackColor="#99CCCC"<SelectedRowStyleBackColor="#009999"Font-<HeaderStyleBackColor="#003399"Font-ForeColor="#CCCCFF"

动态代码编写usingusingSystem.Collections;usingSystem.Configuration;usingSystem.Data;usingSystem.Linq;usingusingSystem.Web.Security;usingSystem.Web.UI;usingSystem.Web.UI.HtmlControls;usingusingSystem.Web.UI.WebControls.WebParts;usingSystem.Xml.Linq;publicpartialclassbigClass:DBfunctiondb=newprotectedvoidPage_Load(objectsender,EventArgsifvoidGridView1.DataSource=db.getDataView("select*frombigClass");protectedvoidButton1_Click(objectsender,EventArgsif(Session["quanxian"]!=null&&Session["quanxian"].ToString()!=够!')",

ScriptManager.RegisterStartupScript(thisGetType(),"""alert('对不起，您的权限不if(TextBox1.Text.Trim().Length>0&&if(!db.isExist("select*frombigClasswherebigID='"+TextBox2.Text.Trim()+"'orbigName='"+TextBox1.Text.Trim()+"'"))db.sqlExecute("insertintobigClass(bigName,bigID)values('"+TextBox1.Text.Trim()+"','"+TextBox2.Text.Trim()+"')");ScriptManager.RegisterStartupScript(thisGetType(),"","alert('类名称不能相同！')"ScriptManager.RegisterStartupScript(thisGetType(),"","alert('号不能为空')"protectedvoidGridView1_RowUpdating(objectsender,GridViewUpdateEventArgsTextBoxtbName,tbID;stringsqlcheck="";tbID=(TextBox)GridView1.Rows[e.RowIndex].Cells[0].Controls[0];tbName=(TextBox)GridView1.Rows[e.RowIndex].Cells[1].Controls[0];if(tbName.Text.Trim().Length>0&&sqlcheck="select*from(select*frombigllclasswhereid<>"GridView1.DataKeys[e.RowIndex].Value+")ast1wherebigid='"+tbID.Text.Trim()+"'orbigname='"+tbName.Text.Trim()+"'";ifdb.sqlExecute("updatebigClasssetbigName='"+tbName.Text.Trim()+"',bigID='"+tbID.Text.Trim()+"'whereid="+GridView1.DataKeys[e.RowIndex].Value);GridView1.EditIndex=-1;ScriptManager.RegisterStartupScript(thisGetType(),"","alert('称不能相同')"//GridView1.EditIndex=-//binddata();

ScriptManager.RegisterStartupScript(thisGetType(),"","alert('能为空')",protectedvoidGridView1_RowEditing(objectsender,GridViewEditEventArgsGridView1.EditIndex=e.NewEditIndex;protectedvoidGridView1_RowDeleting1(objectsender,GridViewDeleteEventArgsif(Session["quanxian"]!=null&&Session["quanxian"].ToString()!=够!')",

ScriptManager.RegisterStartupScript(thisGetType