#region

using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using CSFrameworkV5.Business;
using CSFrameworkV5.Business.BLL_Permission;
using CSFrameworkV5.Common;
using CSFrameworkV5.Core;
using CSFrameworkV5.Interfaces;
using CSFrameworkV5.Interfaces.InterfaceModels;
using CSFrameworkV5.Library.CommonClass;
using CSFrameworkV5.Models;
using DevExpress.XtraEditors;
using DevExpress.XtraEditors.Controls;
using DevExpress.XtraGrid.Views.Base;
using ItemCheckEventArgs = DevExpress.XtraEditors.Controls.ItemCheckEventArgs;

#endregion

namespace CSFrameworkV5.Library
{
    public partial class frmGroupOrganization_DataRightsConfig : XtraForm
    {
        private List<GridPermissionItem> _AllGrids =
            new List<GridPermissionItem>();

        private IDictionary<string, List<DbTableModel>> _cache =
            new Dictionary<string, List<DbTableModel>>();

        private NodeModel _nodeModel;

        private frmGroupOrganization_DataRightsConfig()
        {
            InitializeComponent();
        }

        private void btnAddConfig_Click(object sender, EventArgs e)
        {
            if (txtTables.Text == "")
            {
                txtTables.Focus();
                return;
            }

            var o = txtTables.Properties.GetDataSourceRowByKeyValue(txtTables
                .EditValue);
            var m = o as DbTableModel;

            var dtConfig = gcMain.DataSource as DataTable;
            var rows = dtConfig.Select(
                $"DataType='{_nodeModel.Type}' AND DataId='{_nodeModel.DataID}' AND DBName='{m.DBName}' AND TableName='{m.TableName}'");
            if (rows.Length > 0)
            {
                Msg.Warning("当前用户已经存此表格的配置，不可重复！");
                return;
            }

            var R = dtConfig.Rows.Add();

            R[sys_DataPermission.RowID] = Guid.NewGuid().ToStringEx().ToLower();
            R[sys_DataPermission.DataSetID] = Loginer.CurrentUser.DBID;
            R[sys_DataPermission.DataType] = _nodeModel.Type;
            R[sys_DataPermission.DataID] = _nodeModel.DataID;
            R[sys_DataPermission.DBName] = m.DBName;
            R[sys_DataPermission.TableName] = m.TableName;
            R[sys_DataPermission.AllowColumns] = "";
            R[sys_DataPermission.ColumnCount] = 0;
            R[sys_DataPermission.CreateTime] = DateTime.Now;
            R["DisplayText"] = _nodeModel.Text; //lookup字段
            R["FlagChild"] = "N"; //lookup字段

            //刷新表格，定位新增的记录
            gcMain.RefreshDataSource();
            gvMain.FocusedRowHandle =
                gvMain.GetRowHandle(dtConfig.Rows.IndexOf(R));
            if (gvMain.RowCount == 1)
                gvMain_FocusedRowChanged(gvMain,
                    new FocusedRowChangedEventArgs(0, 0));

            txtTables.EditValue = null;
        }

        private void btnCancel_Click(object sender, EventArgs e)
        {
            Close();
        }

        private void btnCheckAll_Click(object sender, EventArgs e)
        {
            listColumns.CheckAll();
        }

        private void btnOk_Click(object sender, EventArgs e)
        {
            DoSave();
        }

        private void btnUnCheck_Click(object sender, EventArgs e)
        {
            listColumns.UnCheckAll();
        }

        private void DoSave()
        {
            try
            {
                frmWaitingEx.ShowMe(this);

                SetAllColumns();

                var data = (gcMain.DataSource as DataTable).GetChanges();
                if (data == null) return; //没有修改数据

                var ok = new bllPermission().SaveDataPermission(data);

                if (ok)
                {
                    (gcMain.DataSource as DataTable).AcceptChanges();
                    Msg.ShowInformation("保存成功！");
                }
                else
                {
                    Msg.Warning("保存失败！");
                }
            }
            finally
            {
                frmWaitingEx.HideMe(this);
            }
        }

        /// <summary>
        /// </summary>
        /// <param name="dataType">数据类型：Group/User</param>
        /// <param name="dataID">组编号GroupCode/用户账号Account</param>
        public static void Execute(NodeModel m)
        {
            var form = new frmGroupOrganization_DataRightsConfig();
            form._nodeModel = m;
            form.ShowDialog();
        }

        private void frmGridPermissionConfig_FormClosing(object sender,
            FormClosingEventArgs e)
        {
            if (gcMain.DataSource != null &&
                (gcMain.DataSource as DataTable).GetChanges() != null)
                e.Cancel = !Msg.AskQuestion("您配置了表格权限数据没有保存，确定要退出吗?");
        }

        private void frmGridPermissionConfig_Load(object sender, EventArgs e)
        {
            DataBinderTools.BoundCheckEdit(chk);

            txtTables.Properties.DropDownRows = 25;
            txtTables.Properties.PopupWidth = 400;

            LoadTablesLookup();
            LoadConfig();
        }

        private void gvMain_FocusedRowChanged(object sender,
            FocusedRowChangedEventArgs e)
        {
            var R = gvMain.GetFocusedDataRow();
            if (R != null)
                ShowConfig(R);
            else
                listColumns.Items.Clear();
        }

        private void listColumns_ItemCheck(object sender, ItemCheckEventArgs e)
        {
            UpdateRow();
        }

        private void LoadConfig()
        {
            if (_nodeModel.Type.ToUpper() == "USER")
            {
                var data =
                    new bllPermission().GetDataPermissionConfigByUser(_nodeModel
                        .DataID);
                gcMain.DataSource = data;

                picCurrent.Image = picUser.Image;
                lblCurrent.Text =
                    _nodeModel.Text + "(" + _nodeModel.DataID + ")";
            }

            if (_nodeModel.Type.ToUpper() == "GROUP")
            {
                var data =
                    new bllPermission().GetDataPermissionConfigByGroup(
                        _nodeModel.DataID);
                gcMain.DataSource = data;

                picCurrent.Image = picDept.Image;
                lblCurrent.Text =
                    _nodeModel.Text + "(" + _nodeModel.DataID + ")";
            }
        }

        /// <summary>
        ///     加载表格列表
        /// </summary>
        private void LoadTablesLookup()
        {
            var data = CommonData.GetDbTables();
            txtTables.Properties.DisplayMember = "TableName";
            txtTables.Properties.ValueMember = "TableName";
            txtTables.Properties.DataSource = data;
        }

        private void SetAllColumns()
        {
            var R = gvMain.GetFocusedDataRow();

            var sb = new StringBuilder();

            foreach (CheckedListBoxItem item in listColumns.Items)
                sb.Append((item.Value as ColumnItem).FieldName + ",");

            R["AllFields"] = sb.ToStringEx();
        }

        /// <summary>
        ///     显示当前配置的详细资料。
        /// </summary>
        /// <param name="R"></param>
        private void ShowConfig(DataRow R)
        {
            var allowFields =
                ConvertEx.ToString(
                    R[sys_DataPermission.AllowColumns]); //已配置的数据权限
            var key = ConvertEx.ToString(R[sys_DataPermission.RowID]);
            var dbname = ConvertEx.ToString(R[sys_DataPermission.DBName]);
            var tableName = ConvertEx.ToString(R[sys_DataPermission.TableName]);
            var flagChild = ConvertEx.ToString(R["FlagChild"]);

            var allowColumns = allowFields.Split(new[] { ',' },
                StringSplitOptions.RemoveEmptyEntries);

            var allFields = new List<DbTableModel>();

            if (_cache.ContainsKey(key))
            {
                allFields = _cache[key];
            }
            else
            {
                allFields = CommonData.GetDbTableFields(dbname, tableName);
                _cache[key] = allFields;
            }

            listColumns.Items.Clear();
            foreach (var m in allFields)
            {
                var isCheck =
                    allowColumns
                        .Where(e => m.FieldName.ToLower() == e.ToLower())
                        .FirstOrDefault() != null;
                listColumns.Items.Add(
                    new ColumnItem(m.FieldName, m.DisplayName), isCheck);
            }

            //子级组不可配置
            listColumns.Enabled = flagChild == "N";
            lblTip.Visible = flagChild == "Y";
        }

        private void UpdateRow()
        {
            var R = gvMain.GetFocusedDataRow();
            if (R == null) return;

            var sb = new StringBuilder();

            foreach (var item in listColumns.CheckedItems)
            {
                var cdata = (item as CheckedListBoxItem).Value as ColumnItem;
                sb.Append(cdata.FieldName + ",");
            }

            R[sys_DataPermission.AllowColumns] = sb.ToStringEx();
            R[sys_DataPermission.ColumnCount] = listColumns.CheckedItems.Count;
        }

        private void 全部不勾选ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            listColumns.UnCheckAll();
        }

        private void 全部勾选ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            listColumns.CheckAll();
        }
    }

    public class ColumnItem
    {
        public ColumnItem(string fieldName, string caption)
        {
            FieldName = fieldName;
            Caption = caption;
        }

        public string Caption { get; set; }

        public string FieldName { get; set; }

        public override string ToString()
        {
            return Caption;
        }
    }

    public class UserItem
    {
        public UserItem(string userId, string name)
        {
            Account = userId;
            UserName = name;
        }

        public string Account { get; set; }

        public int ImageIndex { get; set; } = 0;

        public string UserName { get; set; }

        public override string ToString()
        {
            return UserName;
        }
    }
}