實訓(xùn)六 產(chǎn)品大類管理

實訓(xùn)內(nèi)容實訓(xùn)過程界面制作(bigClass.aspx頁面該頁面全部靜態(tài)代碼如下<%@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"

動態(tài)代碼編寫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('對不起，您的權(quán)限不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('稱不能相同')"http://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