using System;
using System.Data;
using System.Windows.Forms;
using DevComponents.DotNetBar;

namespace Cyberpipe
{
    public partial class FrmUserRoleMgr : Office2007Form
    {
        public FrmUserRoleMgr()
        {
            InitializeComponent();
        }
        /// <summary>
        /// 窗体初始化事件处理
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void FrmUserRoleMgr_Load(object sender, EventArgs e)
        {
            string sql = "select \"id\",\"username\",\"reroid\" from casic_userstatus";
            DataTable dt = OledbHelper.QueryTable(sql);
            if (dt != null && dt.Rows.Count > 0)
            {
                foreach (DataRow row in dt.Rows)
                {
                    TreeNode node = new TreeNode();
                    node.Text = row[1].ToString().Trim();
                    node.Tag = row[0].ToString();
                    node.ToolTipText = row[2].ToString();
                    treeView1.Nodes.Add(node);
                   
                }
                treeView1.ExpandAll();
            }
        }
    }
}