personlist.cs

一个用vs2003编写的客户工资管理系统客户端程序/一个用vs2003编写的客户工资管理系统客户端程序

					InitTree(OrgTree.Nodes,conn.GetValueFromName("ParentId","OrgBase","IsMainOrg = 'True' "),ds);
				}
				
				OrgTree.ExpandAll();
			}
			else
			{
				MessageBox.Show("没有检测到任何单位信息,请先更新单位信息!");
			}
		}

		//建树的基本思路是：从根节点开始递归调用显示子树
		private void InitTree(System.Windows.Forms.TreeNodeCollection Nds,string ParentId,DataSet ds)
		{
			DataView dv=new DataView();
			dv.Table=ds.Tables[0];
			dv.RowFilter="ParentId='" + ParentId + "'";
			foreach(DataRowView drv in dv)
			{
				TreeNode tmpNd = null;
				if(drv["WJGLXId"].ToString() != "EMUI000011" && drv["WJGLXId"].ToString() != "EMUI000012")//党政机关
				{
					tmpNd = new TreeNode(drv["OrgName"].ToString());
					tmpNd.Tag = "XZ|" + drv["OrgBaseId"].ToString();
				}
				else//事业单位
				{
					tmpNd = new TreeNode(drv["OrgName"].ToString());
					tmpNd.Tag = "SY|" + drv["OrgBaseId"].ToString();
				}

				TreeNode tmpNd_NX = new TreeNode("内设机构");//内设机构根节点
				tmpNd_NX.Tag = "NSRoot|";

				DataSet ds_xx= conn.GetDs("*","NSBase","WOrgBaseId = '"+ drv["OrgBaseId"].ToString() +"' ","");
				for(int i=0;i<ds_xx.Tables[0].Rows.Count;i++)
				{
					TreeNode tmpNd_NX_XX = new TreeNode(ds_xx.Tables[0].Rows[i]["NSName"].ToString());//内设机构根节点
					tmpNd_NX_XX.Tag = "NS|" + ds_xx.Tables[0].Rows[i]["NSBaseId"].ToString();
					
					tmpNd_NX.Nodes.Add(tmpNd_NX_XX);
				}

				tmpNd.Nodes.Add(tmpNd_NX);

				Nds.Add(tmpNd);
				InitTree(tmpNd.Nodes,tmpNd.Tag.ToString().Split('|')[1].ToString(),ds);
			}
		}
		#endregion

		/// <summary>
		/// 获取当前Grid的选定项的IDCard
		/// </summary>
		/// <returns></returns>
		private string GetSelectedIDCard() 
		{
			if (PersonListGrid.DataSource == null || !PersonListGrid.TableStyles.Contains(PersonListDgStyle.TableName))
				return "-1";

			try 
			{
				int taskIDColumnIndex = 0;
				foreach (DataGridColumnStyle dgColumnStyle in PersonListGrid.TableStyles[PersonListDgStyle.TableName].GridColumnStyles)
				{
					if (dgColumnStyle.HeaderText == "身份证")
						break;
					else
						taskIDColumnIndex++;
				} 
				int currentRow = PersonListGrid.CurrentRowIndex;

				return (string) PersonListGrid[currentRow, taskIDColumnIndex];
			} 
			catch (Exception)
			{
				return "-1";
			}
		}

		private void OrgTree_AfterSelect(object sender, System.Windows.Forms.TreeViewEventArgs e)
		{
			if(OrgTree.SelectedNode != null)
			{
				TreeNode node = OrgTree.SelectedNode;
				
				string[] temp   = node.Tag.ToString().Split('|');
				string tempType = temp[0].ToString();
				tempId   = temp[1].ToString();

				if(tempType == "XZ" || tempType == "SY")
				{
					ds= conn.GetDs("*","Person","WOrgBaseId = '"+ tempId +"' order by persontype desc,PersonSort ","Person");
					PersonListGrid.DataSource = ds.Tables[0].DefaultView;

					pageSplit1.InitPageInfo(ds.Tables[0].Rows.Count,20);

				}
				else if(tempType == "NS")
				{
					ds= conn.GetDs("*","Person","WNSBaseId = '"+ tempId +"' order by persontype desc,PersonSort ","Person");
					PersonListGrid.DataSource = ds.Tables[0].DefaultView;
				}
			}
		}

		private void SwapRows(DataRow one, DataRow two)
		{
			for(int i=0;i<one.Table.Columns.Count;i++ )
			{
				MessageBox.Show(one[i].ToString());
//				object pivot = one.Cells[ i ].Value;
//				one.Cells[ i ].Value = two.Cells[ i ].Value;
//				two.Cells[ i ].Value = pivot;
			}
		}
		
		private void MainMenu_Click(object sender, System.EventArgs e)
		{
			int currentRow = 0;
			int previousRow = 0;
			int nextRow = 0;

			if(sender==UpTop)
			{
				PersonListGrid.CurrentRowIndex = 0;
				PersonListGrid.Select();
				SwapRows(ds.Tables[0].Rows[0],ds.Tables[0].Rows[0]);
			}

			if(sender==Up1)
			{
				currentRow = PersonListGrid.CurrentRowIndex;
				PersonListGrid.CurrentRowIndex = currentRow - 1;
				PersonListGrid.Select();
				
			}

			if(sender==Down1)
			{
				currentRow = PersonListGrid.CurrentRowIndex;
				PersonListGrid.CurrentRowIndex = currentRow + 1;
				PersonListGrid.Select();
			}

			if(sender==DownAll)
			{
				currentRow = PersonListGrid.CurrentRowIndex;
				PersonListGrid.CurrentRowIndex = ds.Tables[0].Rows.Count-1;
				PersonListGrid.Select();
			}

//			if(OrgTree.SelectedNode != null)
//			{
//				TreeNode node = OrgTree.SelectedNode;
//				
//				string[] temp   = node.Tag.ToString().Split('|');
//				string tempType = temp[0].ToString();
//				tempId   = temp[1].ToString();
//			
//				if(sender==UpTop)
//				{
//					string tempIDCard = GetSelectedIDCard();
//					conn.ExecUpdate("Person","PersonSort = '0' ","IDCard = '"+ tempIDCard +"' ");
//				}
//
//				if(sender==Up1)
//				{
//					string tempIDCard = GetSelectedIDCard();
//					int sort = Convert.ToInt32(conn.GetValueFromName("PersonSort","Person","IDCard = '"+ tempIDCard +"' "))-3;
//					conn.ExecUpdate("Person","PersonSort = '"+ sort +"' ","IDCard = '"+ tempIDCard +"' ");
//					
//				}
//
//				if(sender==Down1)
//				{
//					string tempIDCard = GetSelectedIDCard();
//					int sort = Convert.ToInt32(conn.GetValueFromName("PersonSort","Person","IDCard = '"+ tempIDCard +"' "))+3;
//					conn.ExecUpdate("Person","PersonSort = '"+ sort +"' ","IDCard = '"+ tempIDCard +"' ");
//				}
//
//				if(sender==DownAll)
//				{
//					string tempIDCard = GetSelectedIDCard();
//					int sort = Convert.ToInt32(conn.GetMaxId("PersonSort","Person","WOrgBaseId = '"+ tempId +"' "))+1;
//					conn.ExecUpdate("Person","PersonSort = '"+ sort +"' ","IDCard = '"+ tempIDCard +"' ");
//				}
//				
//				if(sender==SortAll)
//				{
//					this.Cursor = Cursors.WaitCursor;
//					MessageBox.Show("重新排序成功！");
//					this.Cursor = Cursors.Default;
//				}
//
//				if(sender==UpdateServ)
//				{
//					this.Cursor = Cursors.WaitCursor;
//					JinrmGzglServ.GetGzglData jgs = null;
//					try
//					{
//						DataSet ds= conn.GetDs("*","Person","WOrgBaseId = '"+ tempId +"' order by PersonSort ","Person");
//						jgs = new GzglClient.JinrmGzglServ.GetGzglData(AllStr.WebServiceUrl);
//						jgs.UpdatePersonSort(ds);
//						MessageBox.Show("更新成功！");
//					}
//					catch
//					{
//						
//					}
//					this.Cursor = Cursors.Default;
//					return;
//				}
//
//				Thread tr = new Thread(new ThreadStart(sortall));
//				tr.IsBackground = true;
//				tr.Start();
//
//				DataSet ds2= conn.GetDs("*","Person","WOrgBaseId = '"+ tempId +"' order by persontype desc,PersonSort ","Person");
//				PersonListGrid.DataSource = ds2.Tables[0].DefaultView;
//
//				PersonListGrid.CurrentRowIndex = 5;
//				PersonListGrid.Select();
//				this.Cursor = Cursors.Default;
//			}
		}

		private void sortall()
		{
			string _WOrgBaseId = tempId;

			DataSet ds = conn.GetDs("*","Person","WOrgBaseId = '"+ _WOrgBaseId +"' order by persontype desc,PersonSort","");
			int sort = 1;
			for(int i=0;i<ds.Tables[0].Rows.Count;i++)
			{
				conn.ExecUpdate("Person","PersonSort = '"+ sort +"' ","PersonId = '"+ ds.Tables[0].Rows[i]["PersonId"].ToString() +"' ");
				conn.ExecUpdate("V_TaoGai_Down","PersonSort = '"+ sort +"' ","PersonId = '"+ ds.Tables[0].Rows[i]["PersonId"].ToString() +"' ");
				conn.ExecUpdate("V_TaoGai_Down_LTX","PersonSort = '"+ sort +"' ","PersonId = '"+ ds.Tables[0].Rows[i]["PersonId"].ToString() +"' ");

				sort += 2;
			}
		}

		#region IView 成员
		public void Release()
		{
			Dispose();
		}

		private void PersonListGrid_Navigate(object sender, System.Windows.Forms.NavigateEventArgs ne)
		{
		
		}

		private void PersonListGrid_MouseDown(object sender, System.Windows.Forms.MouseEventArgs e)
		{
//			System.Windows.Forms.DataGrid.HitTestInfo myHitTest;
//			// Use the DataGrid control's HitTest method with the x and y properties.
//			myHitTest = PersonListGrid.HitTest(e.X,e.Y);
//			//MessageBox.Show(myHitTest);
//			MessageBox.Show("Column " + myHitTest.Column);
//			MessageBox.Show("Row " + myHitTest.Row);
//			MessageBox.Show("Type " + myHitTest.Type);
//			MessageBox.Show("ToString " + myHitTest.ToString());
//			MessageBox.Show("Hit " + myHitTest.Type.ToString());

		}

		private void PersonListGrid_KeyDown(object sender, System.Windows.Forms.KeyEventArgs e)
		{
		
		}

		private void pageSplit1_PageChanged_1(object sender, System.EventArgs e)
		{
			MessageBox.Show(pageSplit1.CurrentPage.ToString());
		}

		private void PersonSort_Popup(object sender, System.EventArgs e)
		{
		
		}

		public ViewType TheType
		{
			get {return ViewType.PersonList;}
		}
		#endregion
	}
}