treemanager.aspx.cs

毕业设计时做的,一个管理关于污染管理的, 源代码,呵呵 想想当时还真厉害,可以实现污染检测

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using gyit.Data;
using System.Configuration;
namespace itcrm.admin
{
	/// <summary>
	/// TreeManger 的摘要说明。
	/// </summary>
	public class TreeManager : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Button cmdAdd;
		protected System.Web.UI.WebControls.Button cmdEdit;
		protected System.Web.UI.WebControls.TextBox txtCode;
		protected System.Web.UI.WebControls.TextBox txtName;
		protected System.Web.UI.WebControls.TextBox txtType;
		protected System.Web.UI.WebControls.TextBox txtPNode;
		protected System.Web.UI.WebControls.TextBox txtImage;
		protected System.Web.UI.WebControls.Button cmdClear;
		protected System.Web.UI.WebControls.Label lblMsg;
		protected System.Web.UI.WebControls.ImageButton ImageButton1;
		protected System.Web.UI.WebControls.TextBox txtPathURL;
		protected System.Web.UI.WebControls.DataGrid DataGrid1;
		protected System.Web.UI.WebControls.TextBox txtMenuID;
		public DBOperator db;
		private void Page_Load(object sender, System.EventArgs e)
		{
			DataGrid1.DataKeyField="MenuID";
			db = DBOperator.CreateObject((string)ConfigurationSettings.AppSettings["DSN"]);
			//SqlPager1.ConnectionString=(string)ConfigurationSettings.AppSettings["DSN"];
			if(!Page.IsPostBack)
				DataShow();
		}
		public void DataShow()
		{
			    db.Open();
				DataGrid1.DataSource= db.exeSqlForDataSet("select * from SysMenu order by sort");
				DataGrid1.DataBind();
			    db.Close();
			
		}
		public void delSysMenu(object sender,DataGridCommandEventArgs e)
		{
			string strKey=DataGrid1.DataKeys[e.Item.ItemIndex].ToString();
			db.Open();
			db.exeSql("delete from SysMenu where NodeID='"+strKey+"'");
			db.Close();
			DataShow();		
			
		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.cmdAdd.Click += new System.EventHandler(this.cmdAdd_Click);
			this.cmdEdit.Click += new System.EventHandler(this.cmdEdit_Click);
			this.cmdClear.Click += new System.EventHandler(this.cmdClear_Click);
			this.DataGrid1.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.DataGrid1_PageIndexChanged);
			this.DataGrid1.EditCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_EditCommand);
			this.DataGrid1.DeleteCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_DeleteCommand);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

//***********  增       加
		private void cmdAdd_Click(object sender, System.EventArgs e)
		{
			object[] objPV =new object[6];
			string[] strPV =new string[6];
			strPV[0]="@NodeID";
			strPV[1]="@NodeName";
		    strPV[2]="@ParentID";
			strPV[3]="@SysItemID";
			strPV[4]="@URLPath";
			strPV[5]="@ImagePath";

			objPV[0]=txtCode.Text;
			objPV[1]=txtName.Text;
			objPV[2]=txtPNode.Text;
			objPV[3]=txtType.Text;
			objPV[4]=txtPathURL.Text ;
			objPV[5]=txtImage.Text;
			db.Open();
			try
			{
			
				db.exeProc("AddSys_MenuRecord",strPV,objPV);
				lblMsg.Text="成功：增加纪录成功！";
				DataShow();	
			}
			catch(System.Exception ee)
			{
				lblMsg.Text="错误：增加纪录失败！"+ee.Message;
			}
			db.Close();
		}
//*********** 分     页
		private void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
		{
		
		DataGrid1.CurrentPageIndex=e.NewPageIndex;
			DataShow();
		}
//************  清       除
		private void cmdClear_Click(object sender, System.EventArgs e)
		{
			txtCode.Text="";
			txtName.Text="";
			txtType.Text="";
			txtPNode.Text="";
			txtPathURL.Text="";
			txtImage.Text="";
		}
//*************  编    辑
		private void DataGrid1_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			DataRow row=null;
			db.Open();
			DataSet ds=new DataSet();
			db.Close();
			ds=db.exeSqlForDataSet("select * from SysMenu where MenuID='"+DataGrid1.DataKeys[e.Item.ItemIndex]+"'");
			db.Close();
			//Response.Write("<br>erro"+DataGrid1.DataKeys[e.Item.ItemIndex]);
			if(ds.Tables[0].Rows.Count>0)
			{
				row=ds.Tables[0].Rows[0];
				txtMenuID.Text=row["MenuID"].ToString();
				txtCode.Text=row["NodeID"].ToString();
				txtName.Text=row["NodeName"].ToString();
				txtType.Text=row["SysItemID"].ToString();
				txtPNode.Text=row["ParentID"].ToString();
				txtPathURL.Text=row["URLPath"].ToString();
				txtImage.Text=row["ImagePath"].ToString();
			}
			
			
			
		}
//*****************    修    改
		private void cmdEdit_Click(object sender, System.EventArgs e)
		{
			string[] strPara =new string[7];
			object[] strValues=new object[7];
			strPara[0]="@MenuID";
			strPara[1]="@NodeID";
			strPara[2]="@NodeName";
			strPara[3]="@ParentID";
			strPara[4]="@SysItemID";
			strPara[5]="@URLPath";
			strPara[6]="@ImagePath";
		   
			strValues[0]=txtMenuID.Text;
			strValues[1]=txtCode.Text;
			strValues[2]=txtName.Text;
			strValues[3]=txtType.Text;
			strValues[4]=txtPNode.Text;
			strValues[5]=txtPathURL.Text;
			strValues[6]=txtImage.Text;
			try
			{
				db.Open();
				db.exeProc("Update_TreeManager",strPara,strValues);
				db.Close();
				DataShow();
				lblMsg.Text="修改纪录成功！";
				
			}
			catch(System.Exception ee)
			{
			    lblMsg.Text="错误：修改纪录失败！"+ee.Message;
			}

			
	  }

		private void DataGrid1_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			string strKey=DataGrid1.DataKeys[e.Item.ItemIndex].ToString();
			db.Open();
			db.exeSql("delete from SysMenu where MenuID='"+strKey+"'");
			db.Close();
			DataShow();		
		}
	
	}
}