《实训六 产品大类管理.docx》由会员分享，可在线阅读，更多相关《实训六 产品大类管理.docx（6页珍藏版）》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。
1、编号：时间：2021年x月x日书山有路勤为径，学海无涯苦作舟页码：第6页 共6页实训六 产品大类管理实训目的:实训内容:实训过程:1. 界面制作(bigClass.aspx页面)该页面全部静态代码如下: 无标题页 大类名称： 大类编号： 2. 动态代码编写(bigClass.aspx.cx):using System;using System.Collections;using System.Configuration;using System.Data;using System.Linq;using System.Web;using System.Web.Security;using Sys
2、tem.Web.UI;using System.Web.UI.HtmlControls;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Xml.Linq;public partial class bigClass : System.Web.UI.Page DBfunction db = new DBfunction(); protected void Page_Load(object sender, EventArgs e) db.isLogin(); if (!IsPo
3、stBack) binddata(); void binddata() GridView1.DataSource = db.getDataView(select * from bigClass); GridView1.DataBind(); protected void Button1_Click(object sender, EventArgs e) if (Sessionquanxian != null & Sessionquanxian.ToString() != 0) ScriptManager.RegisterStartupScript(this, GetType(), , aler
4、t(对不起，您的权限不够!), true); return; else if (TextBox1.Text.Trim().Length 0 & TextBox2.Text.Trim().Length0) if (!db.isExist(select * from bigClass where bigID= + TextBox2.Text.Trim() + or bigName= + TextBox1.Text.Trim() + ) db.sqlExecute(insert into bigClass(bigName,bigID) values( + TextBox1.Text.Trim() +
5、 , + TextBox2.Text.Trim() + ); binddata(); else ScriptManager.RegisterStartupScript(this, GetType(), , alert(大类编号或大类名称不能相同！), true); else ScriptManager.RegisterStartupScript(this, GetType(), , alert(大类名称和大类编号不能为空), true); protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
6、 TextBox tbName,tbID; string sqlcheck = ; tbID = (TextBox)GridView1.Rowse.RowIndex.Cells0.Controls0; tbName = (TextBox)GridView1.Rowse.RowIndex.Cells1.Controls0; if (tbName.Text.Trim().Length 0 & tbID.Text.Trim().Length0) sqlcheck = select * from (select * from bigllclass where id + GridView1.DataKe
7、yse.RowIndex.Value + ) as t1 where bigid= + tbID.Text.Trim() + or bigname= + tbName.Text.Trim() + ; if (!db.isExist(sqlcheck) db.sqlExecute(update bigClass set bigName= + tbName.Text.Trim() + ,bigID= + tbID.Text.Trim() + where id= + GridView1.DataKeyse.RowIndex.Value); GridView1.EditIndex = -1; bind
8、data(); else ScriptManager.RegisterStartupScript(this, GetType(), , alert(大类编号或大类名称不能相同), true); /GridView1.EditIndex = -1; / binddata(); return; else ScriptManager.RegisterStartupScript(this, GetType(), , alert(大类名称和大类编号不能为空), true); protected void GridView1_RowEditing(object sender, GridViewEditEv
9、entArgs e) GridView1.EditIndex = e.NewEditIndex; binddata(); protected void GridView1_RowDeleting1(object sender, GridViewDeleteEventArgs e) if (Sessionquanxian != null & Sessionquanxian.ToString() != 0) ScriptManager.RegisterStartupScript(this, GetType(), , alert(对不起，您的权限不够!), true); return; else db.sqlExecute(delete from bigClass where id= + GridView1.DataKeyse.RowIndex.Value); binddata(); protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) GridView1.EditIndex = -1; binddata(); 第 6 页 共 6 页