CS_GIS/Search/SearchUI.Win/RemoteMappingSetting.cs

using System.Collections.Generic;
using System.Data;
using Tofly.Core.Stereotype;
using Tofly.CoreUI.Win.Form.Forms;
using Tofly.SearchUI.Select;
using Tofly.SearchUI.Common;
using Tofly.Core.Context.Support;
using Tofly.CoreUI.Message;
using System.Xml;
using System;
using DevExpress.XtraGrid.Columns;


namespace Tofly.SearchUI.Win
{
    /// <summary>
    /// 设置查询参数
    /// </summary>
    [Component(IsSingleton = "false", Name = "RemoteMappingSetting")]
    public partial class RemoteMappingSetting : FormClass, IRemoteMappingSetting
    {
        private readonly string xmlFilePath = RemoteMappingHelper.xmlFilePath;
        private DataTable dataTable = null;
        private XmlDocument xmlDoc = null;
        private string wordDirectory = string.Empty;
        private string lastValue = string.Empty;

        public RemoteMappingSetting()
        {
            InitializeComponent();
        }


        private void buttonSelectOnMap_Click(object sender, System.EventArgs e)
        {
           
        }


        private void FormRemoteMapping_Load(object sender, EventArgs e)
        {
            //当文件名不存在的时候
            if (!System.IO.File.Exists(xmlFilePath))
            {
                MessageManager.Show(MessageType.Information, "请加载名为'RemoteMappingSetting.xml'的配置文件！", "提示");
                this.Close();
                return;
            }
            BindDataAndSetDisplaySchema();
            this.textFolderPath.Text = wordDirectory;
            this.calcEdit.Text = this.xmlDoc.SelectSingleNode("//MaxSheetCount").InnerText;
            this.comboBox.Text = this.xmlDoc.SelectSingleNode("//DataType").InnerText;

            //if(this)
            //this.calcEdit.Enabled = false;
        }

        private void buttonOK_Click(object sender, System.EventArgs e)
        {
            if (string.IsNullOrEmpty(this.textFolderPath.Text))
            {
                MessageManager.Show(MessageType.Information, "请选择文件目录！", "提示");
                return;
            }
            if (string.IsNullOrEmpty(this.comboBox.Text))
            {
                MessageManager.Show(MessageType.Information, "请选择数据类型！", "提示");
                return;
            }
            if (string.IsNullOrEmpty(this.textFolderPath.Text))
            {
                return;
            }

            if (!CheckDataIsValid())
            {
                return;
            }

            //保存编辑的值
            SaveEditValue(this.textFolderPath.Text);
            this.Close();
        }


        private bool CheckDataIsValid()
        {
            DataTable dataTable = RemoveInvalidRowsAndFillValueForEmptyCell(this.dataTable);
            return CheckIsValid(dataTable);
        }


        //首先对DataTable做预处理
        private DataTable RemoveInvalidRowsAndFillValueForEmptyCell(DataTable dataTable)
        {
            if (dataTable == null)
            {
                return null;
            }
            DataTable copyTable = dataTable.Clone();
            for (int i = 0; i < this.dataTable.Rows.Count; i++)
            {
                DataRow dataRow = dataTable.Rows[i];
                if (CheckRowIsEmpty(dataRow))
                {
                    continue;
                }

                //新添加的一行
                DataRow newRow = copyTable.NewRow();
                if (CheckFirstCellIsEmpty(dataRow))
                {
                    newRow[0] = dataRow[0];
                    newRow[1] = 0;
                    newRow[2] = dataRow[2];
                }
                else if (CheckSecondCellIsEmpty(dataRow))
                {
                    newRow[0] = dataRow[0];
                    newRow[2] = long.MaxValue;
                    newRow[1] = dataRow[1];
                }
                else
                {
                    newRow[0] = dataRow[0];
                    newRow[1] = dataRow[1];
                    newRow[2] = dataRow[2];
                }

                //添加一行的数据
                copyTable.Rows.Add(newRow);
            }
            return copyTable;
        }

        //用来坚持DataTable是否有效
        private bool CheckIsValid(DataTable dataTable)
        {
            foreach (DataRow item in dataTable.Rows)
            {
                if (!CheckRowIsValid(item))
                {

                    return false;
                }
            }
            for (int i = 0; i < dataTable.Rows.Count - 1; i++)
            {
                for (int j = 0; j < dataTable.Rows.Count - i - 1; j++)
                {
                    DataRow rowOne = dataTable.Rows[j];
                    DataRow rowTwo = dataTable.Rows[j + 1];
                    if (CheckRoleHasIntersect(rowOne, rowTwo) || CheckRoleHasIntersect(rowTwo, rowOne))
                    {
                        MessageManager.Show(MessageType.Information, "请检查值是否有重叠！", "提示");
                        return false;
                    }
                    else
                    {
                        if (GetFirstCellValueL(rowOne) > GetFirstCellValueL(rowTwo))
                        {
                            //添加一行
                            DataRow tempRow = dataTable.NewRow();
                            tempRow[0] = rowOne[0];
                            tempRow[1] = rowOne[1];
                            tempRow[2] = rowOne[2];
                            dataTable.Rows.InsertAt(tempRow, j + 2);
                            dataTable.Rows.RemoveAt(j);
                        }
                    }
                }
            }
            return true;
        }


        //验证值是否有效
        bool CheckCellValueIsValid(object value)
        {
            if (value == null || !CanConvertToNumber(value))
            {
                return false;
            }
            if (CanConvertToNumber(value))
            {
                long myValue = long.Parse(value.ToString());
                if (myValue < 0)
                {
                    return false;
                }
            }
            return true;
        }


        //判断两行有没有相交
        bool CheckRoleHasIntersect(DataRow rowOne, DataRow rowTwo)
        {
            long firstCellValue = long.MinValue;
            bool firstCanChange = long.TryParse(rowOne[1].ToString(), out firstCellValue);

            long secondCellValue = long.MinValue;
            bool secondCanChange = long.TryParse(rowOne[2].ToString(), out secondCellValue);

            long rowTwoFirstCellValue = long.Parse(rowTwo[1].ToString());
            if (rowTwoFirstCellValue > firstCellValue && rowTwoFirstCellValue < secondCellValue)
            {
                return true;
            }

            long rowTwoSecondCellValue = long.Parse(rowTwo[2].ToString());
            if (rowTwoSecondCellValue > firstCellValue && rowTwoSecondCellValue < secondCellValue)
            {
                return true;
            }
            return false;
        }




        private void gridView_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
        {
        }

        private void gridView_MouseEnter(object sender, EventArgs e)
        {
        }

        private bool IsFirstCell(long rowIndex, long columnIndex)
        {
            return rowIndex == 0 && columnIndex == 1;
        }

        //是否为第一列
        private bool IsFirstColumn(int columnCount)
        {
            if (columnCount == 1)
            {
                return true;
            }
            return false;
        }

        //是否为最后一列
        private bool IsLastRow(int rowCount)
        {
            if (rowCount == this.dataTable.Rows.Count - 1)
            {
                return true;
            }
            return false;
        }

        //是否为第一行
        private bool IsFirstRow(int rowCount)
        {
            if (rowCount == 0)
            {
                return true;
            }
            return false;
        }


        //转换为字符串
        private string ConvertToString(object value)
        {
            try
            {
                if (value == null) return string.Empty;
                return Convert.ToString(value);
            }
            catch (Exception)
            {
                return string.Empty;
            }
        }

        private long GetFirstCellValueL(DataRow dataRow)
        {
            object firstCell = GetFirstCellValue(dataRow);
            if (firstCell != null)
            {
                return long.Parse(firstCell.ToString());
            }
            return long.MinValue;
        }

        private long GetSecondCellValueL(DataRow dataRow)
        {
            object secondCell = GetSecondCellValue(dataRow);
            if (secondCell != null)
            {
                return long.Parse(secondCell.ToString());
            }
            return long.MinValue;
        }

        //坚持当前行是否为空
        private bool CheckRowIsEmpty(DataRow dataRow)
        {
            if (dataRow == null) return true;
            //第一个象元的值
            string firstCellValue = ConvertToString(GetFirstCellValue(dataRow));
            string secondCellValue = ConvertToString(GetSecondCellValue(dataRow));

            if (string.IsNullOrEmpty(firstCellValue) && string.IsNullOrEmpty(secondCellValue))
            {
                return true;
            }
            return false;
        }

        //用来检查这行是否有效的
        private bool CheckRowIsValid(DataRow dataRow)
        {
            long firstCellValue = long.MinValue;
            bool firstCanChange = long.TryParse(dataRow[1].ToString(), out firstCellValue);

            long secondCellValue = long.MinValue;
            bool secondCanChange = long.TryParse(dataRow[2].ToString(), out secondCellValue);

            if (!firstCanChange || !secondCanChange)
            {
                MessageManager.Show(MessageType.Information, "请检查是否含有非数值类型的值！", "提示");
                return false;
            }
            if (firstCellValue - secondCellValue > 0)
            {
                MessageManager.Show(MessageType.Information, "请检查值是否有重叠部分！", "提示");
                return false;
            }
            return true;
        }

        //当前的第一个象元值是否为空
        private bool CheckFirstCellIsEmpty(DataRow dataRow)
        {
            if (dataRow == null) return true;
            //第一个象元的值
            string firstCellValue = ConvertToString(GetFirstCellValue(dataRow));
            if (string.IsNullOrEmpty(firstCellValue))
            {
                return true;
            }
            return false;
        }

        //第二个象元值是否为空
        private bool CheckSecondCellIsEmpty(DataRow dataRow)
        {
            if (dataRow == null) return true;
            //第一个象元的值
            string SecondCellValue = ConvertToString(GetSecondCellValue(dataRow));
            if (string.IsNullOrEmpty(SecondCellValue))
            {
                return true;
            }
            return false;
        }


        //是否为最后一列
        private bool IsLastColumn(int columnCount)
        {
            if (columnCount == 2)
            {
                return true;
            }
            return false;
        }

        //得到行的第一列的值
        private object GetFirstCellValue(DataRow dataRow)
        {
            return dataRow[1];
        }

        //得到第二列的值
        private object GetSecondCellValue(DataRow dataRow)
        {
            return dataRow[2];
        }

        private bool IsLastCell(long rowIndex, long columnIndex)
        {
            return (rowIndex == this.dataTable.Rows.Count - 1) && (columnIndex == this.dataTable.Columns.Count - 1);
        }

        private void calcEdit_EditValueChanged(object sender, EventArgs e)
        {
            int value;
            if (!int.TryParse(this.calcEdit.Value.ToString(), out value))
            {
                MessageManager.Show(MessageType.Information, "必须整形的！", "提示");
            }
        }


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

        #region 内部调用函数

        //保存路径
        private void SaveEditValue(string path)
        {
            //保存编辑的值
            if (SaveDataTableToXmlConfig(this.dataTable, this.xmlDoc, path))
                MessageManager.Show(MessageType.Information, "保存成功！", "提示");
            else MessageManager.Show(MessageType.Information, "保存失败！", "提示");
        }

        //读取xml文件获得一个DataTable
        private DataTable ReadXmlConfig(string filePath)
        {
            DataTable dataTable = CreateTable();
            xmlDoc = Tofly.Core.Util.XmlUtils.OpenXml(filePath);

            //当前工作目录
            wordDirectory = xmlDoc.SelectSingleNode("//DirectoryPath").InnerText;
            XmlNodeList nodeList = xmlDoc.SelectNodes("//MatchTable/MatchItem");
            if (nodeList == null) return null;
            foreach (XmlNode item in nodeList)
            {
                DataRow dataRow = dataTable.NewRow();
                dataRow["ColumnScale"] = item.Attributes["scale"].Value;
                if (item.Attributes["minValue"].Value.Equals("MINI"))
                {
                    dataRow["ColumnMiniValue"] = string.Empty;
                }
                else
                {
                    dataRow["ColumnMiniValue"] = item.Attributes["minValue"].Value;
                }
                if (item.Attributes["maxValue"].Value.Equals("MAX"))
                {
                    dataRow["ColumnMaxiValue"] = string.Empty;
                }
                else
                {
                    dataRow["ColumnMaxiValue"] = item.Attributes["maxValue"].Value;
                }
                dataTable.Rows.Add(dataRow);
            }
            return dataTable;
        }

        //是否能够转换为long型
        private bool CanConvertToNumber(object value)
        {
            try
            {
                Convert.ToInt32(value);
            }
            catch
            {
                return false;
            }
            return true;
        }

        //绑定数据并且设置显示方案
        private void BindDataAndSetDisplaySchema()
        {
            dataTable = ReadXmlConfig(xmlFilePath);
            if (dataTable != null) this.gridControl.DataSource = dataTable;
            for (int i = 0; i < this.gridView.Columns.Count; i++)
            {
                GridColumn item = this.gridView.Columns[i];
                if (i == 0)
                {
                    item.OptionsColumn.ReadOnly = true;
                }
                item.OptionsColumn.AllowSort = DevExpress.Utils.DefaultBoolean.False;
            }
        }

        //保存内存表到xml配置文件
        private bool SaveDataTableToXmlConfig(DataTable dataTable, XmlDocument xmlDoc, string dataPath)
        {
            try
            {
                if (xmlDoc == null) return false;
                XmlNode xmlNode = xmlDoc.SelectSingleNode("//DirectoryPath");
                if (xmlNode == null) return false;
                xmlNode.InnerText = dataPath;

                //图幅最大值
                XmlNode sheetCount = xmlDoc.SelectSingleNode("//MaxSheetCount");
                if (sheetCount != null)
                {
                    sheetCount.InnerText = this.calcEdit.Text;
                }

                XmlNode dataType = xmlDoc.SelectSingleNode("//DataType");
                if (dataType != null)
                {
                    dataType.InnerText = this.comboBox.Text;
                }

                //便利每一行
                for (int i = 0; i < dataTable.Rows.Count; i++)
                {
                    DataRow dataRow = dataTable.Rows[i];
                    if (dataRow != null)
                    {
                        string scale = dataRow["ColumnScale"].ToString();
                        XmlNode nodeItem = xmlDoc.SelectSingleNode("//MatchItem[@scale='" + scale + "']");
                        string miniValue = dataRow["ColumnMiniValue"].ToString();
                        string maxValue = dataRow["ColumnMaxiValue"].ToString();
                        if (i == 0 && string.IsNullOrEmpty(miniValue))
                        {
                            nodeItem.Attributes["minValue"].Value = string.Empty;
                        }
                        else
                        {
                            nodeItem.Attributes["minValue"].Value = miniValue;
                        }
                        if (i == dataTable.Rows.Count - 1 && string.IsNullOrEmpty(maxValue))
                        {
                            nodeItem.Attributes["maxValue"].Value = string.Empty;
                        }
                        else
                        {
                            nodeItem.Attributes["maxValue"].Value = maxValue;
                        }
                    }
                }
                xmlDoc.Save(this.xmlFilePath);
                return true;
            }
            catch (System.Exception)
            {
                return false;
            }
        }

        //创建一张表
        private DataTable CreateTable()
        {
            DataTable dataTable = new DataTable();
            DataColumn scaleColumn = new DataColumn();
            scaleColumn.ColumnName = "ColumnScale";
            scaleColumn.Caption = "栅格数据比例尺";

            DataColumn minValueColumn = new DataColumn();
            minValueColumn.ColumnName = "ColumnMiniValue";
            minValueColumn.Caption = "最小值";

            DataColumn maxValueColumn = new DataColumn();
            maxValueColumn.ColumnName = "ColumnMaxiValue";
            maxValueColumn.Caption = "最大值";

            dataTable.Columns.Add(scaleColumn);
            dataTable.Columns.Add(minValueColumn);
            dataTable.Columns.Add(maxValueColumn);
            return dataTable;
        }


        private bool OneIsLargerThanTwo(long one, long two)
        {
            if (one - two > 0)
            {
                return true;
            }
            return false;
        }


        #endregion



        #region IRemoteMappingSetting 成员

        public bool GridEdit
        {
            get
            {
                return this.groupControl.Enabled;
            }
            set
            {
                groupControl.Enabled = value;
            }
        }

        public bool MaxEdit
        {
            get
            {
                return this.calcEdit.Enabled;
            }
            set
            {
                calcEdit.Enabled = value;
            }
        }

        #endregion

        private void textFolderPath_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
        {
            IFolderDialog folderdialog = ContextRegistry.GetContext().GetObject("IFolderDialog") as IFolderDialog;
            string path = folderdialog.GetFolderPath("请选择文件目录?", true);
            if (!string.IsNullOrEmpty(path))
                this.textFolderPath.Text = path;
        }
    }
}