miniSql

创建
zgc123@gmail.com authored at 11/19/2023 1:40:15 AM
6136600
Tree
0 Parent(s)
Summary: 1 changed files with 416 additions and 0 deletions.
Added +416 -0
Added +416 -0
diff --git a/minisqlquery-master/src/MiniSqlQuery/BasicEditor.cs b/minisqlquery-master/src/MiniSqlQuery/BasicEditor.cs
new file mode 100644
index 0000000..dd87e8d
--- /dev/null
+++ b/minisqlquery-master/src/MiniSqlQuery/BasicEditor.cs
@@ -0,0 +1,416 @@
+#region License
+
+// Copyright 2005-2019 Paul Kohler (https://github.com/paulkohler/minisqlquery). All rights reserved.
+// This source code is made available under the terms of the GNU Lesser General Public License v3.0
+// https://github.com/paulkohler/minisqlquery/blob/master/LICENSE
+#endregion
+
+using System;
+using System.IO;
+using System.Windows.Forms;
+using ICSharpCode.TextEditor.Document;
+using Microsoft.VisualBasic;
+using MiniSqlQuery.Commands;
+using MiniSqlQuery.Core;
+using MiniSqlQuery.Core.Commands;
+using WeifenLuo.WinFormsUI.Docking;
+
+namespace MiniSqlQuery
+{
+    /// <summary>The basic editor.</summary>
+    public partial class BasicEditor : DockContent, IEditor, IFindReplaceProvider, INavigatableDocument
+    {
+        /// <summary>The _services.</summary>
+        private readonly IApplicationServices _services;
+
+        /// <summary>The _settings.</summary>
+        private readonly IApplicationSettings _settings;
+
+        /// <summary>The _file name.</summary>
+        private string _fileName;
+
+        /// <summary>The _highlighting provider loaded.</summary>
+        private bool _highlightingProviderLoaded;
+
+        /// <summary>The _is dirty.</summary>
+        private bool _isDirty;
+
+        /// <summary>The _text find service.</summary>
+        private ITextFindService _textFindService;
+
+        /// <summary>Initializes a new instance of the <see cref="BasicEditor"/> class.</summary>
+        public BasicEditor()
+        {
+            InitializeComponent();
+            txtEdit.Document.DocumentChanged += DocumentDocumentChanged;
+        }
+
+        /// <summary>Initializes a new instance of the <see cref="BasicEditor"/> class.</summary>
+        /// <param name="services">The services.</param>
+        /// <param name="settings">The settings.</param>
+        public BasicEditor(IApplicationServices services, IApplicationSettings settings)
+            : this()
+        {
+            _services = services;
+            _settings = settings;
+
+            formContextMenuStrip.Items.Add(CommandControlBuilder.CreateToolStripMenuItem<SaveFileCommand>());
+            formContextMenuStrip.Items.Add(CommandControlBuilder.CreateToolStripMenuItemSeparator());
+            formContextMenuStrip.Items.Add(CommandControlBuilder.CreateToolStripMenuItem<CloseActiveWindowCommand>());
+            formContextMenuStrip.Items.Add(CommandControlBuilder.CreateToolStripMenuItem<CloseAllWindowsCommand>());
+            formContextMenuStrip.Items.Add(CommandControlBuilder.CreateToolStripMenuItem<CopyQueryEditorFileNameCommand>());
+
+            CommandControlBuilder.MonitorMenuItemsOpeningForEnabling(formContextMenuStrip);
+        }
+
+        /// <summary>Gets or sets AllText.</summary>
+        public string AllText
+        {
+            get { return txtEdit.Text; }
+            set { txtEdit.Text = value; }
+        }
+
+        /// <summary>Gets a value indicating whether CanReplaceText.</summary>
+        public bool CanReplaceText
+        {
+            get { return true; }
+        }
+
+        /// <summary>Gets or sets CursorColumn.</summary>
+        public int CursorColumn
+        {
+            get { return txtEdit.ActiveTextAreaControl.Caret.Column; }
+            set { txtEdit.ActiveTextAreaControl.Caret.Column = value; }
+        }
+
+        /// <summary>Gets or sets CursorLine.</summary>
+        public int CursorLine
+        {
+            get { return txtEdit.ActiveTextAreaControl.Caret.Line; }
+            set { txtEdit.ActiveTextAreaControl.Caret.Line = value; }
+        }
+
+        /// <summary>Gets CursorOffset.</summary>
+        public int CursorOffset
+        {
+            get { return txtEdit.ActiveTextAreaControl.Caret.Offset; }
+        }
+
+        /// <summary>Gets FileFilter.</summary>
+        public virtual string FileFilter
+        {
+            get { return "Text Files (*.txt)|*.txt|All Files (*.*)|*.*"; }
+        }
+
+        /// <summary>Gets or sets FileName.</summary>
+        public string FileName
+        {
+            get { return _fileName; }
+            set
+            {
+                _fileName = value;
+                Text = FileName;
+                TabText = FileName;
+            }
+        }
+
+        /// <summary>Gets or sets a value indicating whether IsDirty.</summary>
+        public bool IsDirty
+        {
+            get { return _isDirty; }
+            set
+            {
+                if (_isDirty != value)
+                {
+                    _isDirty = value;
+                    SetTabTextByFilename();
+                }
+            }
+        }
+
+        /// <summary>Gets SelectedText.</summary>
+        public string SelectedText
+        {
+            get { return txtEdit.ActiveTextAreaControl.SelectionManager.SelectedText; }
+        }
+
+        /// <summary>Gets TextFindService.</summary>
+        public ITextFindService TextFindService
+        {
+            get
+            {
+                if (_textFindService == null)
+                {
+                    _textFindService = _services.Resolve<ITextFindService>();
+                }
+
+                return _textFindService;
+            }
+        }
+
+        /// <summary>Gets TotalLines.</summary>
+        public int TotalLines
+        {
+            get { return txtEdit.Document.TotalNumberOfLines; }
+        }
+
+        /// <summary>The load highlighting provider.</summary>
+        public void LoadHighlightingProvider()
+        {
+            if (_highlightingProviderLoaded)
+            {
+                return;
+            }
+
+            // see: http://wiki.sharpdevelop.net/Syntax%20highlighting.ashx
+            string dir = Path.GetDirectoryName(GetType().Assembly.Location);
+            FileSyntaxModeProvider fsmProvider = new FileSyntaxModeProvider(dir);
+            HighlightingManager.Manager.AddSyntaxModeFileProvider(fsmProvider); // Attach to the text editor.
+            _highlightingProviderLoaded = true;
+        }
+
+        /// <summary>The clear selection.</summary>
+        public void ClearSelection()
+        {
+            txtEdit.ActiveTextAreaControl.SelectionManager.ClearSelection();
+        }
+
+        /// <summary>The highlight string.</summary>
+        /// <param name="offset">The offset.</param>
+        /// <param name="length">The length.</param>
+        public void HighlightString(int offset, int length)
+        {
+            if (offset < 0 || length < 1)
+            {
+                return;
+            }
+
+            int endPos = offset + length;
+            txtEdit.ActiveTextAreaControl.SelectionManager.SetSelection(
+                txtEdit.Document.OffsetToPosition(offset),
+                txtEdit.Document.OffsetToPosition(endPos));
+            SetCursorByOffset(endPos);
+        }
+
+        /// <summary>The insert text.</summary>
+        /// <param name="text">The text.</param>
+        public void InsertText(string text)
+        {
+            if (string.IsNullOrEmpty(text))
+            {
+                return;
+            }
+
+            int offset = txtEdit.ActiveTextAreaControl.Caret.Offset;
+
+            // if some text is selected we want to replace it
+            if (txtEdit.ActiveTextAreaControl.SelectionManager.IsSelected(offset))
+            {
+                offset = txtEdit.ActiveTextAreaControl.SelectionManager.SelectionCollection[0].Offset;
+                txtEdit.ActiveTextAreaControl.SelectionManager.RemoveSelectedText();
+            }
+
+            txtEdit.Document.Insert(offset, text);
+            int newOffset = offset + text.Length; // new offset at end of inserted text
+
+            // now reposition the caret if required to be after the inserted text
+            if (CursorOffset != newOffset)
+            {
+                SetCursorByOffset(newOffset);
+            }
+
+            txtEdit.Focus();
+        }
+
+
+        /// <summary>The load file.</summary>
+        public void LoadFile()
+        {
+            txtEdit.LoadFile(FileName);
+            IsDirty = false;
+        }
+
+        /// <summary>The save file.</summary>
+        public void SaveFile()
+        {
+            txtEdit.SaveFile(FileName);
+            IsDirty = false;
+        }
+
+        /// <summary>The set syntax.</summary>
+        /// <param name="name">The name.</param>
+        public void SetSyntax(string name)
+        {
+            LoadHighlightingProvider();
+            txtEdit.SetHighlighting(name);
+        }
+
+        /// <summary>The find string.</summary>
+        /// <param name="value">The value.</param>
+        /// <param name="startIndex">The start index.</param>
+        /// <param name="comparisonType">The comparison type.</param>
+        /// <returns>The find string.</returns>
+        public int FindString(string value, int startIndex, StringComparison comparisonType)
+        {
+            if (string.IsNullOrEmpty(value) || startIndex < 0)
+            {
+                return -1;
+            }
+
+            string text = AllText;
+            int pos = text.IndexOf(value, startIndex, comparisonType);
+            if (pos > -1)
+            {
+                ClearSelection();
+                HighlightString(pos, value.Length);
+            }
+
+            return pos;
+        }
+
+        /// <summary>The replace string.</summary>
+        /// <param name="value">The value.</param>
+        /// <param name="startIndex">The start index.</param>
+        /// <param name="length">The length.</param>
+        /// <returns>The replace string.</returns>
+        public bool ReplaceString(string value, int startIndex, int length)
+        {
+            if (value == null || startIndex < 0 || length < 0)
+            {
+                return false;
+            }
+
+            if ((startIndex + length) > AllText.Length)
+            {
+                return false;
+            }
+
+            txtEdit.Document.Replace(startIndex, length, value);
+
+            return true;
+        }
+
+        /// <summary>The set text find service.</summary>
+        /// <param name="textFindService">The text find service.</param>
+        public void SetTextFindService(ITextFindService textFindService)
+        {
+            // accept nulls infering a reset
+            _textFindService = textFindService;
+        }
+
+        /// <summary>The set cursor by location.</summary>
+        /// <param name="line">The line.</param>
+        /// <param name="column">The column.</param>
+        /// <returns>The set cursor by location.</returns>
+        public bool SetCursorByLocation(int line, int column)
+        {
+            if (line > TotalLines)
+            {
+                return false;
+            }
+
+            txtEdit.ActiveTextAreaControl.Caret.Line = line;
+            txtEdit.ActiveTextAreaControl.Caret.Column = column;
+
+            return true;
+        }
+
+        /// <summary>The set cursor by offset.</summary>
+        /// <param name="offset">The offset.</param>
+        /// <returns>The set cursor by offset.</returns>
+        public bool SetCursorByOffset(int offset)
+        {
+            if (offset >= 0)
+            {
+                txtEdit.ActiveTextAreaControl.Caret.Position = txtEdit.Document.OffsetToPosition(offset);
+                return true;
+            }
+
+            return false;
+        }
+
+        /// <summary>The basic editor_ form closing.</summary>
+        /// <param name="sender">The sender.</param>
+        /// <param name="e">The e.</param>
+        private void BasicEditor_FormClosing(object sender, FormClosingEventArgs e)
+        {
+            if (_isDirty)
+            {
+                DialogResult saveFile = _services.HostWindow.DisplayMessageBox(
+                    this,
+                    "Contents changed, do you want to save the file?\r\n" + TabText, "Save Changes?",
+                    MessageBoxButtons.YesNoCancel,
+                    MessageBoxIcon.Question,
+                    MessageBoxDefaultButton.Button1,
+                    0,
+                    null,
+                    null);
+
+                if (saveFile == DialogResult.Cancel)
+                {
+                    e.Cancel = true;
+                }
+                else if (saveFile == DialogResult.Yes)
+                {
+                    CommandManager.GetCommandInstance<SaveFileCommand>().Execute();
+                }
+            }
+        }
+
+        /// <summary>The basic editor_ load.</summary>
+        /// <param name="sender">The sender.</param>
+        /// <param name="e">The e.</param>
+        private void BasicEditor_Load(object sender, EventArgs e)
+        {
+#if DEBUG
+            lblEditorInfo.Text = GetType().FullName;
+#else
+			panel1.Visible = false;
+#endif
+        }
+
+        /// <summary>The document document changed.</summary>
+        /// <param name="sender">The sender.</param>
+        /// <param name="e">The e.</param>
+        private void DocumentDocumentChanged(object sender, DocumentEventArgs e)
+        {
+            IsDirty = true;
+        }
+
+        /// <summary>The get value.</summary>
+        /// <param name="name">The name.</param>
+        /// <returns>The get value.</returns>
+        private string GetValue(string name)
+        {
+            string val = Interaction.InputBox(string.Format("Value for '{0}'", name), "Supply a Value", name, -1, -1);
+            return val;
+        }
+
+        /// <summary>The set tab text by filename.</summary>
+        private void SetTabTextByFilename()
+        {
+            string dirty = string.Empty;
+            string text = "Untitled";
+            string tabtext;
+
+            if (_isDirty)
+            {
+                dirty = " *";
+            }
+
+            if (txtEdit.FileName != null)
+            {
+                text = FileName;
+                tabtext = Path.GetFileName(FileName);
+            }
+            else
+            {
+                text += _settings.GetUntitledDocumentCounter();
+                tabtext = text;
+            }
+
+            TabText = tabtext + dirty;
+            ToolTipText = text + dirty;
+        }
+    }
+}
\ No newline at end of file