using ESRI.ArcGIS.Carto;
using ESRI.ArcGIS.Geodatabase;
using KGIS.Framework.Maps;
using KGIS.Framework.Platform;
using KGIS.Framework.Utils;
using KGIS.Framework.Utils.Helper;
using KGIS.Framework.Views;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Runtime.InteropServices;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace Kingo.Plugin.BHTB_Extract.View
{
    public partial class UcZYQManager : UserControl, IDockPanel3
    {
        private IFeatureLayer _Layer = null;
        private DataTable _Data = new DataTable();
        private string queryWhere = string.Empty;
        public UcZYQManager()
        {
            InitializeComponent();
            this.DockAreas = KGIS.Framework.Views.DockStyle.DockLeft | KGIS.Framework.Views.DockStyle.Float;
            this.FloatSize = new System.Drawing.Size(230, 160);
            this.DefaultArea = KGIS.Framework.Views.DockStyle.DockLeft;
            this.ShowCloseButton = true;
            this.ShowAutoHideButton = true;
            this.Title = "作业区管理";
            this.IsShowInMap = false;
            this.DockHeight = 160;
            this.DockWidth = 230;
            this.IsDockToPanel = true;
            this.DockToPanelStyle = KGIS.Framework.Views.DockStyle.DockLeft;
            this.cbSearchType.SelectedIndex = 0;
            _Layer = MapsManager.Instance.MapService.GetFeatureLayerByName("ZYQ");
        }

        DataTable dtData;
        public void Init(string type)
        {
            try
            {
                //绑定数据
                tvDirectory.Nodes.Clear();

                InitTreeViewJD(dtData);
            }
            catch (Exception ex)
            {
                MessageHelper.ShowError(ex.Message);
            }
            finally
            {
                //if (irdbHelper != null)
                //{
                //    irdbHelper.DisConnect();
                //}
            }
        }
        public void Clear()
        {
            tvDirectory.Nodes.Clear();
        }
        private void ConstructColumn(IFields fields)
        {
            if (fields != null)
            {
                _Data.Clear();
                _Data.PrimaryKey = null;
                _Data.Columns.Clear();

                AddInitFieldData(fields);
                string oidField = "OBJECTID";
                if (!_Data.Columns.Contains(oidField) && _Data.Columns.Contains("FID"))
                {
                    oidField = "FID";
                }
                _Data.PrimaryKey = new DataColumn[] { _Data.Columns[oidField] };
            }
        }
        private void AddInitFieldData(IFields fields)
        {
            try
            {
                for (int i = 0; i < fields.FieldCount; i++)
                {
                    IField field = fields.get_Field(i);
                    if (field.Name.ToUpper().EndsWith("SHAPE"))
                        continue;
                    DataColumn col = new DataColumn();
                    col.ExtendedProperties.Add("index", i);
                    col.ColumnName = field.Name;
                    col.Caption = field.AliasName;
                    switch (field.Type)
                    {
                        case esriFieldType.esriFieldTypeSmallInteger:
                            col.DataType = typeof(short);
                            break;
                        case esriFieldType.esriFieldTypeInteger:
                            col.DataType = typeof(int);
                            break;
                        case esriFieldType.esriFieldTypeSingle:
                            break;
                        case esriFieldType.esriFieldTypeDouble:
                            col.DataType = typeof(double);
                            break;
                        case esriFieldType.esriFieldTypeString:
                            col.DataType = typeof(string);
                            break;
                        case esriFieldType.esriFieldTypeDate:
                            col.DataType = typeof(DateTime);
                            break;
                        case esriFieldType.esriFieldTypeOID:
                            col.DataType = typeof(Int32);
                            break;
                        case esriFieldType.esriFieldTypeGeometry:
                            break;
                        case esriFieldType.esriFieldTypeBlob:
                            break;
                        case esriFieldType.esriFieldTypeRaster:
                            break;
                        case esriFieldType.esriFieldTypeGUID:
                            break;
                        case esriFieldType.esriFieldTypeGlobalID:
                            break;
                        case esriFieldType.esriFieldTypeXML:
                            break;
                        default:
                            break;
                    }
                    col.ReadOnly = !field.Editable;//编辑状态启用默认是否可以编辑
                    if (_Data.Columns.Contains(col.ColumnName) == false)//不存在则添加
                    {
                        _Data.Columns.Add(col);
                    }
                    Marshal.ReleaseComObject(field);
                }
            }
            catch (Exception ex)
            {
                LogAPI.Debug("加载表格数据失败！" + ex);
                return;
            }

        }
        private void AddInitDictionaryData(Dictionary<int, string> fieldIndex_NameDic, IFields fields)
        {
            try
            {
                if (fields == null || fields.FieldCount == 0) return;
                foreach (var item in fieldIndex_NameDic)
                {
                    int itemIndex = fields.FindField(item.Value);
                    if (itemIndex == -1) continue;
                    IField field = fields.get_Field(itemIndex);
                    if (field.Name.ToUpper().EndsWith("SHAPE"))
                        continue;
                    DataColumn col = new DataColumn();
                    col.ExtendedProperties.Add("index", item.Key);
                    col.ColumnName = field.Name;
                    col.Caption = field.AliasName;
                    switch (field.Type)
                    {
                        case esriFieldType.esriFieldTypeSmallInteger:
                            col.DataType = typeof(short);
                            break;
                        case esriFieldType.esriFieldTypeInteger:
                            col.DataType = typeof(int);
                            break;
                        case esriFieldType.esriFieldTypeSingle:
                            break;
                        case esriFieldType.esriFieldTypeDouble:
                            col.DataType = typeof(double);
                            break;
                        case esriFieldType.esriFieldTypeString:
                            col.DataType = typeof(string);
                            break;
                        case esriFieldType.esriFieldTypeDate:
                            col.DataType = typeof(DateTime);
                            break;
                        case esriFieldType.esriFieldTypeOID:
                            col.DataType = typeof(Int32);
                            break;
                        case esriFieldType.esriFieldTypeGeometry:
                            break;
                        case esriFieldType.esriFieldTypeBlob:
                            break;
                        case esriFieldType.esriFieldTypeRaster:
                            break;
                        case esriFieldType.esriFieldTypeGUID:
                            break;
                        case esriFieldType.esriFieldTypeGlobalID:
                            break;
                        case esriFieldType.esriFieldTypeXML:
                            break;
                        default:
                            break;
                    }
                    col.ReadOnly = !field.Editable;//编辑状态启用默认是否可以编辑
                    if (_Data.Columns.Contains(col.ColumnName) == false)//不存在则添加
                    {
                        _Data.Columns.Add(col);
                    }
                    Marshal.ReleaseComObject(field);
                }
            }
            catch (Exception ex)
            {
                LogAPI.Debug("加载表格数据失败！" + ex);
                return;
            }
        }

        private void InitTreeViewJD(DataTable dtData)
        {
            try
            {
                if (_Layer == null) return;
                ConstructColumn(this._Layer.FeatureClass.Fields);

                IAttributeTable AttrTable = _Layer as IAttributeTable;
                IQueryFilter queryfilter = new QueryFilterClass
                {
                    WhereClause = queryWhere
                };
                //ITable table = SourceFeature as ITable;
                ICursor cursor = AttrTable.AttributeTable.Search(queryfilter, true);

                int count = AttrTable.AttributeTable.RowCount(queryfilter);
                IRow row = null;
                DataTable tempDt = _Data.Copy();
                tempDt.Rows.Clear();
                bool isExitFeatureXML = false;// JudgeExistsCurrentFeatureXML();
                int columnCount = 0;
                int fieldIndex = 0;
                while ((row = cursor.NextRow()) != null)
                {
                    DataRow dr = tempDt.NewRow();
                    if (isExitFeatureXML) columnCount = tempDt.Columns.Count - 1;
                    else columnCount = tempDt.Columns.Count;
                    for (int i = 0; i < columnCount; i++)
                    {
                        if (isExitFeatureXML)
                            fieldIndex = (int)tempDt.Columns[row.Fields.FindField(tempDt.Columns[i].ColumnName)].ExtendedProperties["index"];
                        else
                            fieldIndex = (int)tempDt.Columns[i].ExtendedProperties["index"];
                        object obj = row.get_Value(fieldIndex);
                        if (obj == null)
                        {
                            continue;
                        }
                        else
                        {
                            if (obj.ToString().Contains("1899/12/30 0:00:00"))
                            {
                                obj = DBNull.Value;
                            }
                        }
                        dr[i] = obj;
                    }
                    tempDt.Rows.Add(dr);
                    if (tempDt.Rows.Count == 10000)
                    {
                        
                    }
                }
                _Data = tempDt.Copy();
                Marshal.ReleaseComObject(AttrTable);
                Marshal.ReleaseComObject(_Layer); 
                this.Invoke((Action)delegate ()
                {
                    _Data = tempDt.Copy();
                    TreeNode node = new TreeNode();
                    node.Text = "图幅";
                    foreach (DataRow _dr in _Data.Rows)
                    {
                        TreeNode subNode = new TreeNode();
                        subNode.Text = _dr["ZYQBH"] is DBNull ? "" : _dr["ZYQBH"].ToString();
                        subNode.Tag = _dr["OBJECTID"];
                        node.Nodes.Add(subNode);
                    }
                    tvDirectory.Nodes.Add(node);

                    //gridControl1.DataSource = null;
                    //gridView1.Columns.Clear();
                    //gridControl1.DataSource = Data;
                    ////OpaqueLayerHelper.HideOpaqueLayer();
                    //UpdateViewState();
                    ////OpaqueLayerHelper.ShowOpaqueLayer(this, 50, true);
                    ////barEditItem3.EditValue = "(" + gridView1.GetSelectedRows().Length + "/" + Data.Rows.Count + "已选择)";
                });

                //string strConn = Config.SysConfigsOprator.GetDBConnectionByName("MDBOledbConnection");
                //strConn = string.Format(strConn, Env.Instance.Project.GetProjMDBPath());
                //helper = RDBFactory.CreateDbHelper(strConn, DatabaseType.MSAccess);
                //string strSQL = string.Format("select objectid,图幅编号 from {0}", "JHTB");
                //dtData = helper.ExecuteDatatable("dtData", strSQL, true);
                //helper.DisConnect();
                //if (dtData != null)
                //{
                //    TreeNode node = new TreeNode();
                //    node.Text = "图幅";
                //    foreach (DataRow row in dtData.Rows)
                //    {
                //        TreeNode subNode = new TreeNode();
                //        subNode.Text = row["图幅编号"] is DBNull ? "" : row["图幅编号"].ToString();
                //        subNode.Tag = row["OBJECTID"];
                //        node.Nodes.Add(subNode);
                //    }
                //    tvDirectory.Nodes.Add(node);
                //}
            }
            catch (Exception ex)
            {

                throw ex;
            }
        }

        int selectIndex = -1;
        string preSearchText = string.Empty;
        DataRow[] drSearchs;
        int index = 0;
        private void btnSearch_Click(object sender, EventArgs e)
        {
            if (dtData != null && this.cbSearchType.SelectedIndex != -1 && !string.IsNullOrEmpty(this.txtSearchText.Text.Trim()))
            {
                if (selectIndex != this.cbSearchType.SelectedIndex || preSearchText != this.txtSearchText.Text.Trim())
                {
                    selectIndex = this.cbSearchType.SelectedIndex;
                    preSearchText = this.txtSearchText.Text.Trim();
                    if (this.cbSearchType.SelectedIndex == 0)
                    {
                        if (dtData.Columns.Contains("ORDERDM"))
                        {
                            drSearchs = dtData.Select("ORDERDM like '%" + this.txtSearchText.Text.Trim() + "%'", "ORDERNO ASC");
                        }
                        else
                        {
                            drSearchs = dtData.Select("XZQDM like '%" + this.txtSearchText.Text.Trim() + "%'", "XZQDM ASC");
                        }
                    }
                    else
                    {
                        drSearchs = dtData.Select("XZQMC like '%" + this.txtSearchText.Text.Trim() + "%'", "XZQDM ASC");
                    }
                    index = 0;
                }

                if (drSearchs != null && drSearchs.Length > 0)
                {
                    if (index >= drSearchs.Length)
                    {
                        index = 0;
                    }
                    SelectNode(drSearchs[index]);
                    index++;
                }
            }
            else
            {
                MessageHelper.ShowTips("搜索之前请确保有数据，并且输入了搜索条件！");
            }
        }

        private void SelectNode(DataRow dr)
        {
            //foreach (TreeNode node in tvDirectory.Nodes)
            //{
            //    if (node.Tag != null)
            //    {
            //        XZQEntity xzq = node.Tag as XZQEntity;
            //        if (dr["XZQDM"].ToString() == xzq.XZQDM)
            //        {
            //            this.tvDirectory.Focus();
            //            tvDirectory.SelectedNode = node;
            //        }
            //    }
            //    else
            //    {
            //        foreach (TreeNode subNode in node.Nodes)
            //        {
            //            if (subNode.Tag != null)
            //            {
            //                XZQEntity xzq = subNode.Tag as XZQEntity;
            //                if (dr["XZQDM"].ToString() == xzq.XZQDM)
            //                {
            //                    this.tvDirectory.Focus();
            //                    tvDirectory.SelectedNode = subNode;
            //                }
            //            }
            //            else
            //            {
            //                foreach (TreeNode subSubNode in subNode.Nodes)
            //                {
            //                    if (subSubNode.Tag == null)
            //                        continue;
            //                    XZQEntity xzq = subSubNode.Tag as XZQEntity;
            //                    if (dr["XZQDM"].ToString() == xzq.XZQDM)
            //                    {
            //                        this.tvDirectory.Focus();
            //                        subSubNode.Checked = true;
            //                        tvDirectory.SelectedNode = subSubNode;
            //                    }
            //                    else
            //                    {
            //                        subSubNode.Checked = false;
            //                    }
            //                    IsZoom = true;
            //                }
            //            }
            //        }
            //    }
            //}
        }

        private void tvDirectory_NodeMouseClick(object sender, TreeNodeMouseClickEventArgs e)
        {

        }

        private void tvDirectory_NodeMouseDoubleClick(object sender, TreeNodeMouseClickEventArgs e)
        {
            //if (e.Button == System.Windows.Forms.MouseButtons.Left && e.Node != null && e.Node.Tag != null)
            //{
            //    XZQEntity xzq = e.Node.Tag as XZQEntity;
            //    if (xzq != null)
            //    {
            //        Common.Utility.CommonAPI.MoveToCenterBySelectFeature(Map as IMapControlDefault, "XZQ", xzq.OBJECTID);
            //    }
            //}
        }
        bool IsZoom = false;

        public event EventHandler CloseViewHandler;

        public bool IsDockToPanel { get ; set ; }
        public KGIS.Framework.Views.DockStyle DockToPanelStyle { get ; set ; }
        public bool IsShowInMap { get ; set ; }
        public Guid ID { get ; set ; }
        public KGIS.Framework.Views.DockStyle DockAreas { get ; set ; }
        public Size FloatSize { get ; set ; }
        public int DockWidth { get ; set ; }
        public int DockHeight { get ; set ; }
        public KGIS.Framework.Views.DockStyle DefaultArea { get ; set ; }
        public bool ShowCloseButton { get ; set ; }
        public bool ShowAutoHideButton { get ; set ; }
        public string Title { get ; set ; }

        private void tvDirectory_AfterCheck(object sender, TreeViewEventArgs e)
        {
            //if (e.Action != TreeViewAction.ByMouse && e.Node.Nodes.Count == 0 && !IsZoom)
            //    return;
            //if (e.Node.Checked)
            //{
            //    IsZoom = false;
            //}
            //XZQEntity xzq = e.Node.Tag as XZQEntity;
            //if (xzq != null)
            //{
            //    if (e.Node.Checked)
            //    {
            //        xzq.Element = CommonAPI.ZoomAndDrawGraph(Env.Instance.DefaultValue.XZQ_TableName, xzq.OBJECTID);
            //        Env.Instance.SelectXZQByCatalog.Add(xzq);
            //    }
            //    else
            //    {
            //        if (xzq.Element != null)
            //        {
            //            CommonAPI.ClearGraph(xzq.Element as IElement);
            //            Env.Instance.SelectXZQByCatalog.Remove(xzq);
            //            xzq.Element = null;
            //        }
            //    }
            //}
            //if (e.Node.Nodes != null)
            //{
            //    foreach (TreeNode item in e.Node.Nodes)
            //    {
            //        item.Checked = e.Node.Checked;
            //        xzq = item.Tag as XZQEntity;
            //        if (xzq != null)
            //        {
            //            if (item.Checked)
            //            {
            //                xzq.Element = CommonAPI.ZoomAndDrawGraph(Env.Instance.DefaultValue.XZQ_TableName, xzq.OBJECTID);
            //                Env.Instance.SelectXZQByCatalog.Add(xzq);
            //            }
            //            else
            //            {
            //                if (xzq.Element != null)
            //                {
            //                    CommonAPI.ClearGraph(xzq.Element as IElement);
            //                    Env.Instance.SelectXZQByCatalog.Remove(xzq);
            //                    xzq.Element = null;
            //                }
            //            }
            //        }
            //    }
            //}
        }

        public void ShowPanel()
        {
            Platform.Instance.OpenView(this, false);
        }

        public void ClosePanel()
        {

        }

        public void ClosePanelInvoke()
        {

        }
    }
}