frmplatfteatree.cs

功能设计：平台管理、收费点维护、收费项目管理、缴费管理

using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using System.Data.OracleClient;
using System.Threading;
using GlobleUtility;



namespace PlatF
{
	/// <summary>
	/// 学校地址的查询界面。
	/// </summary>
	public class CfrmPlatFTeaTree : System.Windows.Forms.Form
	{
		private System.Windows.Forms.ListView lvTeaTree;
		private System.Windows.Forms.ImageList imageListtbr;
		private System.Windows.Forms.ToolBar tbrTeaTree;
		private System.Windows.Forms.ToolBarButton toolBarButton8;
		private System.Windows.Forms.ToolBarButton tbrButtonAdd;
		private System.Windows.Forms.ToolBarButton tbrButtonDel;
		private System.Windows.Forms.ToolBarButton tbrButtonExit;
		private System.Windows.Forms.Label labview;
		private System.ComponentModel.IContainer components;
		private System.Windows.Forms.TreeView trvDept;
		private System.Windows.Forms.ImageList imgDeptList;
		
		//动态数组，保存从查询窗口传回的两条数据，第一条是查询窗口生成的sql查询语句，第二条是查询的内容显示
		//private ArrayList arrayPipe;  
		//private CfrmProgressStatus status; //查询操作时弹出的进度条
		//进度条时间刷新
		//private System.Threading.TimerCallback frmTimerCB;

		//private System.Threading.Timer frmTimer;
		 
		private bool blocalmodified;
		public CfrmPlatFTeaTree()
		{
			//
			// Windows 窗体设计器支持所必需的
			//
			InitializeComponent();
			//blocalmodified = false;
			//
			// TODO: 在 InitializeComponent 调用后添加任何构造函数代码
			//
		}

		/// <summary>
		/// 清理所有正在使用的资源。
		/// </summary>
		protected override void Dispose( bool disposing )
		{
			if( disposing )
			{
				if(components != null)
				{
					components.Dispose();
				}
			}
			base.Dispose( disposing );
		}

		#region Windows 窗体设计器生成的代码
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{
			this.components = new System.ComponentModel.Container();
			System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(CfrmPlatFTeaTree));
			this.lvTeaTree = new System.Windows.Forms.ListView();
			this.imageListtbr = new System.Windows.Forms.ImageList(this.components);
			this.tbrTeaTree = new System.Windows.Forms.ToolBar();
			this.toolBarButton8 = new System.Windows.Forms.ToolBarButton();
			this.tbrButtonAdd = new System.Windows.Forms.ToolBarButton();
			this.tbrButtonDel = new System.Windows.Forms.ToolBarButton();
			this.tbrButtonExit = new System.Windows.Forms.ToolBarButton();
			this.labview = new System.Windows.Forms.Label();
			this.trvDept = new System.Windows.Forms.TreeView();
			this.imgDeptList = new System.Windows.Forms.ImageList(this.components);
			this.SuspendLayout();
			// 
			// lvTeaTree
			// 
			this.lvTeaTree.BackColor = System.Drawing.SystemColors.Info;
			this.lvTeaTree.Location = new System.Drawing.Point(232, 104);
			this.lvTeaTree.Name = "lvTeaTree";
			this.lvTeaTree.Size = new System.Drawing.Size(552, 376);
			this.lvTeaTree.TabIndex = 0;
			//this.lvTeaTree.DoubleClick += new System.EventHandler(this.lvTeaTree_DoubleClick);
			this.lvTeaTree.ColumnClick += new System.Windows.Forms.ColumnClickEventHandler(this.lvTeaTree_ColumnClick);
			// 
			// imageListtbr
			// 
			this.imageListtbr.ImageSize = new System.Drawing.Size(32, 32);
			this.imageListtbr.ImageStream = ((System.Windows.Forms.ImageListStreamer)(resources.GetObject("imageListtbr.ImageStream")));
			this.imageListtbr.TransparentColor = System.Drawing.Color.Transparent;
			// 
			// tbrTeaTree
			// 
			this.tbrTeaTree.Buttons.AddRange(new System.Windows.Forms.ToolBarButton[] {
																						  this.toolBarButton8,
																						  this.tbrButtonAdd,
																						  this.tbrButtonDel,
																						  this.tbrButtonExit});
			this.tbrTeaTree.ButtonSize = new System.Drawing.Size(52, 52);
			this.tbrTeaTree.DropDownArrows = true;
			this.tbrTeaTree.ImageList = this.imageListtbr;
			this.tbrTeaTree.Location = new System.Drawing.Point(0, 0);
			this.tbrTeaTree.Name = "tbrTeaTree";
			this.tbrTeaTree.ShowToolTips = true;
			this.tbrTeaTree.Size = new System.Drawing.Size(792, 58);
			this.tbrTeaTree.TabIndex = 8;
			this.tbrTeaTree.ButtonClick += new System.Windows.Forms.ToolBarButtonClickEventHandler(this.tbrTeaTree_ButtonClick);
			// 
			// toolBarButton8
			// 
			this.toolBarButton8.Enabled = false;
			this.toolBarButton8.Style = System.Windows.Forms.ToolBarButtonStyle.Separator;
			// 
			// tbrButtonAdd
			// 
			this.tbrButtonAdd.ImageIndex = 0;
			this.tbrButtonAdd.Text = "新增";
			this.tbrButtonAdd.ToolTipText = "新增";
			// 
			// tbrButtonDel
			// 
			this.tbrButtonDel.ImageIndex = 3;
			this.tbrButtonDel.Text = "删除";
			this.tbrButtonDel.ToolTipText = "删除";
			// 
			// tbrButtonExit
			// 
			this.tbrButtonExit.ImageIndex = 6;
			this.tbrButtonExit.Text = "退出";
			this.tbrButtonExit.ToolTipText = "退出";
			// 
			// labview
			// 
			this.labview.Font = new System.Drawing.Font("黑体", 10.5F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.labview.Location = new System.Drawing.Point(8, 64);
			this.labview.Name = "labview";
			this.labview.Size = new System.Drawing.Size(696, 32);
			this.labview.TabIndex = 9;
			this.labview.Text = "教工信息：";
			// 
			// trvDept
			// 
			this.trvDept.HideSelection = false;
			this.trvDept.ImageList = this.imgDeptList;
			this.trvDept.Location = new System.Drawing.Point(0, 104);
			this.trvDept.Name = "trvDept";
			this.trvDept.Size = new System.Drawing.Size(224, 376);
			this.trvDept.TabIndex = 10;
			this.trvDept.AfterSelect += new System.Windows.Forms.TreeViewEventHandler(this.trvDept_AfterSelect);
			// 
			// imgDeptList
			// 
			this.imgDeptList.ImageSize = new System.Drawing.Size(16, 16);
			this.imgDeptList.ImageStream = ((System.Windows.Forms.ImageListStreamer)(resources.GetObject("imgDeptList.ImageStream")));
			this.imgDeptList.TransparentColor = System.Drawing.Color.Transparent;
			// 
			// CfrmPlatFTeaTree
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
			this.ClientSize = new System.Drawing.Size(792, 501);
			this.Controls.Add(this.trvDept);
			this.Controls.Add(this.labview);
			this.Controls.Add(this.tbrTeaTree);
			this.Controls.Add(this.lvTeaTree);
			this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedDialog;
			this.MaximizeBox = false;
			this.MinimizeBox = false;
			this.Name = "CfrmPlatFTeaTree";
			this.ShowInTaskbar = false;
			this.StartPosition = System.Windows.Forms.FormStartPosition.CenterParent;
			this.Text = "教工信息维护";
			this.Load += new System.EventHandler(this.CfrmPlatFTeaTree_Load);
			this.ResumeLayout(false);

		}
		#endregion

		private void CfrmPlatFTeaTree_Load(object sender, System.EventArgs e)
		{
			//窗体初始化
			//TeaTreeview();
			lvTeaTree.FullRowSelect =true;  //整行选择
			lvTeaTree.HideSelection = false; //当listview没有焦点时，选定项是否仍然突出显示
			lvTeaTree.View=View.Details;  
			lvTeaTree.GridLines=true; 
			lvTeaTree.Clear();
			string[] UserFieldInfo = {"姓名","性别","教工号","职务","部门"};
	
			for (int i = 0; i <= 4; i++)
			{
				lvTeaTree.Columns.Add(UserFieldInfo[i], 80, HorizontalAlignment.Center);
			}			
			//对arrayPipe分配内存空间，保存查询窗体传递回来的sql查询语句
			//this.arrayPipe = new ArrayList();
			//初始化pnlDept部门显示控件
			//数据库查询操作，listview中按照名称顺序显示记录
			System.Data.OracleClient.OracleConnection Org_myConn = Connection.DBConnection;
			if (Org_myConn == null)
			{
				return;	
			}
			//部门信息的查询语句
			string Org_mySql = "SELECT OrgName FROM charge_school_Info";
			OracleCommand selCommand = new OracleCommand(Org_mySql,Org_myConn);
			
			OracleDataReader trvDataReader = null;
			try
			{
				trvDataReader = selCommand.ExecuteReader();
			}
			catch(Exception ee)
			{
				MessageBox.Show("数据库查询出错，消息如下：\r\n"+ee.Message,"消息：",MessageBoxButtons.OK,MessageBoxIcon.Warning);
				return;
			}
			if (!trvDataReader.HasRows)
			{
				
				MessageBox.Show("必须先建立学校信息！");
				this.Close();
				return;
			}
			//初始化TreeView控件，将学校设为其根节点
			trvTagTemp TagTemp= new trvTagTemp();//为结构trvTagTemp分配内存
			TreeNode rootNode = new TreeNode();
			while (trvDataReader.Read ())
			{
				
				rootNode =trvDept.Nodes.Add(trvDataReader.GetValue(0).ToString().Trim());
				rootNode.ImageIndex = 2;
				rootNode.SelectedImageIndex = 2;
				TagTemp.temp_id = "0";   //在部门部门关系表中将一级部门的上级部门ID设为0
				TagTemp.temp_isexpand = 2; //表示根节点已展开过

				//该值为0代表此节点是最高节点，该值为1代表此节点是部门类型，该值为2代表此节点是班级类型，该值为3代表此节点是专业类型
				TagTemp.temp_type = 0; 
				rootNode.Tag = TagTemp;

			}	
			GetDepttree(rootNode);
			//GetClasstree(rootNode);
			trvDept.CollapseAll(); //折叠所有树节点

		}

		/****************************************************************************
			Function Description:
				获得下属部门列表
			Arguments:
				Type_ID		查找类别	1—查下属有教工的部门
										2—查下属有老师
	的部门
										3—查所有部门
				Node		当前点击的树结点，即当前部门
			Return Value:
				NONE
			History:
				Modified on 07/23/2004 by [e-mail]
				Modified on 08/02/2004 by [e-mail]
				Modified on 08/14/2004 by cellz
		
		
	*****************************************************************************/
		private void GetDepttree(TreeNode Node)//ok
		{
			string strDtName = "dtDept";
			DataSet dsDept = new DataSet();

			//存储过程的名称
			string strProcedureName = "";

			//输出参数(两个)
			OracleParameter[] outParam = {new OracleParameter(), new OracleParameter()};
			outParam[0].ParameterName = "p_Result";
			outParam[0].OracleType = OracleType.Number;
			outParam[0].Direction = ParameterDirection.Output;
			outParam[1].ParameterName = "Re_CURSOR";
			outParam[1].OracleType = OracleType.Cursor;
			outParam[1].Direction = ParameterDirection.Output;

			//输入参数（两个）
			OracleParameter[] inParam = {new OracleParameter(), new	OracleParameter()};			

			
			//Node.tag里保存的是节点的类别
			
			//实例化结构trvTagTemp，用来取得选定treenode的tag属性中保存的Deptid
			trvTagTemp selectedTag = (trvTagTemp)Node.Tag ;
			//int nTag = selectedTag.temp_type;
	
			//显示教工部门类型
		
			strProcedureName = "SP_charge_GETDEPTBYID";
			inParam[0].ParameterName = "p_DeptID";
			inParam[0].OracleType = OracleType.Int32;
			inParam[0].Value = selectedTag.temp_id;
			inParam[1].ParameterName = "p_Type";
			inParam[1].OracleType = OracleType.Int32;
			inParam[1].Value = 2;
				

			//存储过程的调用，更新dtDept,dsDept
			
			GlobleHelper.ExecStoredProc(strProcedureName, inParam, ref outParam, ref dsDept);
			if (Convert.ToInt32(outParam[0].Value) == 0)
			{
				trvTagTemp TagTemp= new trvTagTemp();//为结构trvTagTemp分配内存
			
				foreach(DataTable dtTable in dsDept.Tables)
				{
					dtTable.TableName = strDtName;
									

					TreeNode NewNode;

					if (dtTable.Rows.Count > 0)
					{						
	
						foreach (DataRow myRow in dtTable.Rows)
						{
							//在treeview中显示数据
							NewNode = new TreeNode(Node.Index.ToString() + myRow[0].ToString());//保证node唯一性
							Node.Nodes.Add(NewNode);
							NewNode.Text = myRow["DeptName"].ToString();	//DeptName或ClassName
							TagTemp.temp_id = myRow[0].ToString();   //部门ID
							TagTemp.temp_isexpand = 1; //表示根节点未展开过
							TagTemp.temp_type = 1; //该节点是部门类型
							NewNode.Tag = TagTemp;
							NewNode.ImageIndex = 0;
							NewNode.SelectedImageIndex = 1;
							
						}

					}
					Node.Expand();
					selectedTag.temp_isexpand = 2;
					Node.Tag = selectedTag;				
		
				}
			}
			else
			{
				
				MessageBox.Show("未知数据库操作错误，请重新打开窗体！");
			}
		}
	
		private void trvDept_AfterSelect(object sender, System.Windows.Forms.TreeViewEventArgs e)
		{
			//实例化结构trvTagTemp
			trvTagTemp selectedTag = (trvTagTemp)e.Node.Tag ;	
			
			
			switch (selectedTag.temp_type) //节点类型
			{
				case 0://教工下部门节点
					lvTeaTree.Items.Clear();
					e.Node.Nodes.Clear();
					GetDepttree(e.Node);					
					break;
				case 1://教工下部门节点
					lvTeaTree.Items.Clear();
					e.Node.Nodes.Clear();
					GetDepttree(e.Node);
					GetTUserList(e.Node);//获得某部门的教工列表	
					break;						
				default:
					break;