using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using WeifenLuo.WinFormsUI.Docking;
using YX.BLL;
using YX.Entity;
namespace YX
{
    public partial class FrmUserInfo : WindowParent
    {
        SystemOrganization_Bll organization_bll = new SystemOrganization_Bll();
        // SystemUserInfo_Dal user_dal = new SystemUserInfo_Dal();
        SystemUserInfo_Bll user_bll = new SystemUserInfo_Bll();
        SystemMenu_Bll menu_bll = new SystemMenu_Bll();
        public FrmUserInfo(string ParentId)
        {
            InitializeComponent();
            SetButton(ParentId, this.toolStrip1);//设置按钮权限
        }
   
        private void FrmUserInfo_Load(object sender, EventArgs e)
        {
            GetComboxList();
            BindTreeView(organization_bll.GetOrganizations());
            if (treeView1.Nodes.Count > 0)//展开一级节点
            {
                treeView1.Nodes[0].Expand();
            }
               
        }
        private void GetComboxList()
        {
            DataTable dt = new DataTable();
            DataColumn Name = new DataColumn("Name");
            DataColumn Value = new DataColumn("Value");
            dt.Columns.Add(Name);
            dt.Columns.Add(Value);

            DataRow dr1 = dt.NewRow();
            dr1["Name"] = "工号";
            dr1["Value"] = "User_Code";

            DataRow dr2 = dt.NewRow();
            dr2["Name"] = "账户";
            dr2["Value"] = "User_Account";

            DataRow dr3 = dt.NewRow();
            dr3["Name"] = "姓名";
            dr3["Value"] = "User_Name";
            dt.Rows.Add(dr1);
            dt.Rows.Add(dr2);
            dt.Rows.Add(dr3);
            this.com_Searchwhere.ComboBox.DisplayMember = "Name";
            this.com_Searchwhere.ComboBox.ValueMember = "Value";

            this.com_Searchwhere.ComboBox.DataSource = dt;
        }
        private void BindTreeView(List<Base_Organization> list)
        {
            try
            {
                treeView1.Nodes.Clear();
                list = organization_bll.GetOrganizations();
                var parents = list.Where(o => o.ParentId == "0");
                foreach (var item in parents)
                {
                    TreeNode tn = new TreeNode();
                    tn.Text = item.Organization_Name;
                    tn.Tag = item.Organization_ID;
                    tn.ImageIndex = 0;
                    FillTree(tn, list);
                    treeView1.Nodes.Add(tn);
                }
            }
            catch (Exception ex)
            {
                System_Bll.WriteLogToDB(new Entity.Base_Log
                {
                    CreateUserID = FrmLogin.LoginUserID,
                    CreateUserName = FrmLogin.loginUserName,
                    LocalIP = FrmLogin.LocalIP,
                    LogMessage = ex.Message,
                    Type = "系统错误！",
                    ClassName = typeof(FrmUserInfo).ToString()
                });
                MessageBox.Show(ex.Message);
            }
        }

        private void FillTree(TreeNode node, List<Base_Organization> list)
        {

            var childs = list.Where(o => o.ParentId == node.Tag.ToString());
            if (childs.Count() > 0)
            {
                foreach (var item in childs)
                {
                    TreeNode tnn = new TreeNode();
                    tnn.Text = item.Organization_Name;
                    tnn.Tag = item.Organization_ID;
                    tnn.ImageIndex = 0;
                    if (item.ParentId == node.Tag.ToString())
                    {
                        FillTree(tnn, list);
                    }
                    node.Nodes.Add(tnn);
                }

            }
        }

        private void treeView1_AfterSelect(object sender, TreeViewEventArgs e)
        {
            string Organization_ID = e.Node.Tag.ToString();
            StringBuilder SqlWhere = new StringBuilder();
            IList<SqlParameter> IList_param = new List<SqlParameter>();
            if (!string.IsNullOrEmpty(Organization_ID))
            {
                SqlWhere.Append(" AND S.Organization_ID =@Organization_ID");
                IList_param.Add(new SqlParameter("@Organization_ID", Organization_ID ));
            }
            this.dataGridView1.DataSource = user_bll.GetUserInfoByOrganization_Id(SqlWhere, IList_param);
     
        }

        private void dataGridView1_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
        {
            if (this.dataGridView1.Rows.Count != 0)
            {
                for (int i = 0; i < this.dataGridView1.Rows.Count; )
                {
                    this.dataGridView1.Rows[i].DefaultCellStyle.BackColor = System.Drawing.Color.BlanchedAlmond;
                    i += 2;
                }
            } 
        }

        private void btn_select_Click(object sender, EventArgs e)
        {
            StringBuilder SqlWhere = new StringBuilder();
            IList<SqlParameter> IList_param = new List<SqlParameter>();
            if (!string.IsNullOrEmpty(txt_Search.Text))
            {
                SqlWhere.Append(" and U." + com_Searchwhere.ComboBox.SelectedValue.ToString()+ " like @obj ");
                IList_param.Add(new SqlParameter("@obj", '%' + txt_Search.Text.Trim() + '%'));
            }
            if (!string.IsNullOrEmpty(treeView1.SelectedNode.Tag.ToString()))
            {
                SqlWhere.Append(" AND S.Organization_ID =@Organization_ID");
                IList_param.Add(new SqlParameter("@Organization_ID", treeView1.SelectedNode.Tag.ToString()));
            }
          this.dataGridView1.DataSource= user_bll.GetUserInfoByOrganization_Id(SqlWhere, IList_param);
        }

        private void btn_Add_Click(object sender, EventArgs e)
        {
            FrmUserInfoEdit edit = new FrmUserInfoEdit(this);
            edit.ShowDialog();
        }

        private void btn_edit_Click(object sender, EventArgs e)
        {
            if (dataGridView1.DataSource == null)
            {
                MessageBox.Show("请选择要编辑的行!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            else
            {
                DataGridViewRow dr = dataGridView1.SelectedRows[0];

                if (dr != null)
                {
                    FrmUserInfoEdit edit = new FrmUserInfoEdit(this,ref dr);
                    edit.ShowDialog();
                }
            } 
        
        }

        private void btn_delete_Click(object sender, EventArgs e)
        {

            try
            {
                DataGridViewRow dr = dataGridView1.SelectedRows[0];
                if (dr != null)
                {
                    //int result = bll.DeleteSysMenu(dr.Cells["Menu_Id"].Value.ToString());
                   // if (result == 1)
                   // {
                        MessageBox.Show("删除成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                       // this.dataGridView1.DataSource = dal.GetSysMenuChilds(this.listView1.SelectedItems[0].Tag.ToString());
                   // }
                    //else
                   // {
                        MessageBox.Show("删除失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                   // }
                }
            }
            catch (Exception ex)
            {
                System_Bll.WriteLogToDB(new Entity.Base_Log
                {
                    CreateUserID = FrmLogin.LoginUserID,
                    CreateUserName = FrmLogin.loginUserName,
                    LocalIP = FrmLogin.LocalIP,
                    LogMessage = ex.Message,
                    Type = "系统错误！",
                    ClassName = typeof(FrmUserInfo).ToString()
                });
                MessageBox.Show(ex.Message);
            }
        }

        private void btn_refresh_Click(object sender, EventArgs e)
        {
            if (treeView1.SelectedNode != null)
            {
                string Organization_ID = treeView1.SelectedNode.Tag.ToString();
                StringBuilder SqlWhere = new StringBuilder();
                IList<SqlParameter> IList_param = new List<SqlParameter>();
                if (!string.IsNullOrEmpty(Organization_ID))
                {
                    SqlWhere.Append(" AND S.Organization_ID =@Organization_ID");
                    IList_param.Add(new SqlParameter("@Organization_ID", Organization_ID));
                }
                this.dataGridView1.DataSource = user_bll.GetUserInfoByOrganization_Id(SqlWhere, IList_param);
            }
           
        }

        private void 刷新ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            BindTreeView(organization_bll.GetOrganizations());
            if (treeView1.Nodes.Count > 0)//展开一级节点
            {
                treeView1.Nodes[0].Expand();
            }
        }
    }
}