xm_tree.cs

实习时候做的一个c#的财务管理系统

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace cwgl.yjxm
{
    public partial class xm_tree : Form
    {
        public static xm_tree tr = null;
        public void TV_Refresh()
        {
            GetScoule();
        }
        public xm_tree()
        {
            
            InitializeComponent();
            tr = this;
        }

        public void xm_tree_Load(object sender, EventArgs e)
        {
            GetScoule();
        }
        public void GetScoule()
        {
            SqlConnection con = new SqlConnection(global::cwgl.Properties.Settings.Default.cwglCon);
            con.Open();
            SqlCommand com = new SqlCommand("select * from v_xmsz order by 项目类型,分类,项目名称", con);
            SqlDataReader dr = com.ExecuteReader();

            TreeNode NodeClassInfo = treeView1.Nodes.Add("A", "财政项目", 0, 1);

            String name1 = null, name2 = "", name3 = "";
            TreeNode node1=null, node2=null,node3 = null;
            while (dr.Read())
            {
             
                if (name1 != dr[1].ToString())
                {
                    node1 = new TreeNode(dr[1].ToString());
                    name1 = dr[1].ToString();
                    NodeClassInfo.Nodes.Add(node1);
                }
                if (name2 != dr[25].ToString())
                {
                    node2 = new TreeNode(dr[25].ToString());
                    name2 = dr[25].ToString();
                    node1.Nodes.Add(node2);
                    node3 = new TreeNode(dr[2].ToString());
                    name3 = dr[2].ToString();
                    node2.Nodes.Add(node3);
                }
                else  if(name2 == "" &&name3 != dr[2].ToString())
                {
                    node3 = new TreeNode(dr[2].ToString());
                    name3 = dr[2].ToString();
                    node1.Nodes.Add(node3);
                }
                else if (name2 != "")
                {
                    node3 = new TreeNode(dr[2].ToString());
                    name3 = dr[2].ToString();
                    node2.Nodes.Add(node3);
                }
                

            }
            dr.Close();
            con.Close();
        }
           
        public void GetText(string strID)
        {

            try
            {
                SqlConnection conn = new SqlConnection(global::cwgl.Properties.Settings.Default.cwglCon);
                conn.Open();
                SqlCommand com = new SqlCommand("select * from v_xmsz where 项目名称 = '" + strID + "'", conn);
                SqlDataReader dr = com.ExecuteReader();
                while (dr.Read())
                {
                    this.textBox1.Text = Convert.ToString(dr[2]);
                    this.textBox2.Text = dr[1].ToString();
                    this.textBox3.Text = dr[25].ToString();
                    this.textBox4.Text = dr[3].ToString();
                    this.textBox5.Text = dr[4].ToString();

                    this.textBox6.Text = dr[14].ToString();

                    this.textBox7.Text = dr[21].ToString();

                    this.textBox8.Text = dr[12].ToString();
                }
                dr.Close();
                conn.Close();
            }
            catch(SqlException e1)
            {
                MessageBox.Show(e1.Message, "请选择添加项目的地点");
            }
            
            
        }

        private void timer1_Tick(object sender, EventArgs e)
        {
            this.toolStripStatusLabel1.Text = "系统时间：" + DateTime.Now.ToLongTimeString();
        }

        private void button4_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        
        private void button1_Click(object sender, EventArgs e)
        {
            if (treeView1.SelectedNode.Text == "财政项目")
            {
                string strpp = "";
                string strp = "";
                string str = treeView1.SelectedNode.Text;
                tjxm tj = new tjxm(str, strp, strpp);
                tj.ShowDialog();
                treeView1.Refresh();
            }
            else if (treeView1.SelectedNode.Parent.Text == "财政项目")
            {
                string strpp = "";
                string strp = treeView1.SelectedNode.Parent.Text;
                string str = treeView1.SelectedNode.Text;
                tjxm tj = new tjxm(str, strp, strpp);
                tj.ShowDialog();
                treeView1.Refresh();

            }


            else if (treeView1.SelectedNode.Parent.Parent.Text != null)
            {
                string strpp = treeView1.SelectedNode.Parent.Parent.Text;
                string strp = treeView1.SelectedNode.Parent.Text;
                string str = treeView1.SelectedNode.Text;
                tjxm tj = new tjxm(str, strp, strpp);
                tj.ShowDialog();
                treeView1.Refresh();

            }

        }

        private void button2_Click(object sender, EventArgs e)
        {
            upform up = new upform(this.textBox1.Text,this.label2.Text);
            up.ShowDialog();
          
        }

        public void treeView1_AfterSelect(object sender, TreeViewEventArgs e)
        {
            GetText(treeView1.SelectedNode.Text);
            
        }

      
    }
}