編集履歴

質問編集履歴

コードを修正・追加しました

2019/04/09 04:07

投稿

rain_x_sun

スコア10

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -18,10 +18,180 @@
 ```C#
+using System;
+using System.IO;
+using System.Text;
+using System.Text.RegularExpressions;
+using System.Threading;
+using System.Threading.Tasks;
+using System.Web;
+using System.Windows.Forms;
+using ClosedXML.Excel;
+namespace AuxiliaryTool
+{
+    public partial class Main : Form
+    {
+        public int TopCell;
+        public int LastCell;
+        public int WorkTopCell;
+        public int WorkLastCell;
+        public string Movie_change_word_default;
+        public string Copy_text;
+        public string TestXLPath /*= "C:\TestData\contact_test_data\test.xlsx"*/;
         public IXLWorkbook XLData;
         public IXLWorksheet WorkXL;
+        public int num_ = 5000;
+        public Task task;
+        public Main()
+        {
+            InitializeComponent();
+            PriInitialize();
+        }
+        private void PriInitialize()//起動処理
+        {
+            XLSetup(TestXLPath,WorkXL);
+            text_main.WatermarkText = "/*省略*/";
+            string[] str = { "A", "B", "C", "D","E" };
+            CmbObject[] obj_ = new CmbObject[str.Length];
+            int num__ = 0;
+            foreach(String str_ in str){
+                obj_[num__] = new CmbObject(num__++, str_);
+            }
+            Condition.Items.AddRange(obj_);
+            //Condition.SelectedIndex = 0;
+        }
+        private void XLInitialize()
+        {
+            num.Value = WorkTopCell;
+            Search_word.Text = InfoList(Search_num());
+            Work_range_min.Text = WorkTopCell.ToString();
+            Work_range_max.Text = WorkLastCell.ToString();
+        }
+        private string InfoList(int a)//Excel内の情報を読み込む
+        {
+            int row = a - TopCell + 2;
+            if(WorkXL != null)
+            {
+                Reason.Text = WorkXL.Cell(Cell_row(), 12).Value.ToString();
+                return WorkXL.Cell(row,4).Value.ToString() + " " + WorkXL.Cell(row, 5).Value.ToString() + " " + WorkXL.Cell(row, 6).Value.ToString();
+            }else { return "#N/A"; }
+        }
+        private int Cell_row()
+        {
+            return Search_num() - TopCell + 2;
+        }
+        private int Cell_row(int a)
+        {
+            return Search_num() - TopCell + 2 + a;
+        }
+        private int Search_num()//現在値を返す
+        {
+            return decimal.ToInt32(num.Value);
+        }
+        private int Search_num(int a)
+        {
+            return decimal.ToInt32(num.Value) + a;
+        }
         private void XLSetup(string a, IXLWorksheet xl)//Excelデータの処理
@@ -44,22 +214,6 @@
-        private void XLInitialize()
-        {
-            num.Value = WorkTopCell;
-            Search_word.Text = InfoList(Search_num());
-            Work_range_min.Text = WorkTopCell.ToString();
-            Work_range_max.Text = WorkLastCell.ToString();
-        }
         private IXLWorksheet XLOpen(string a,IXLWorksheet xl)//Excelを開く処理
         {
@@ -186,80 +340,242 @@
             }
+        }
+        private void Config()
+        {
+            Movie_change_word_default = "/*省略*/";
+        }
+        private void URL_prev()//前に戻る処理
+        {
+            num_ = decimal.ToInt32(num.Value);
+            if (num.Minimum < num.Value)
+            {
+                num_--;
+                Search_word.Text = InfoList(Search_num() - 1);
+                //Reason.Text = WorkXL.Cell(Cell_row(-1),12).Value.ToString();
+            }
+            num.Value = num_;
+            var task = Task.Run(() => Thread.Sleep(0));
+            Thread.Sleep(10);
+            if (task.IsCompleted)
+            {
+                task = XL_save();
+            }
+        }
+        private void URL_next()//次
+        {
+            num_ = decimal.ToInt32(num.Value);
+            if (num.Maximum > num.Value)
+            {
+                num_++;
+                Search_word.Text = InfoList(Search_num() + 1);
+            }
+            num.Value = num_;
+            var task = Task.Run(() => Thread.Sleep(0));
+            Thread.Sleep(10);
+            if (task.IsCompleted)
+            {
+            task = XL_save();
+            }
+        }
+        private Task XL_save()
+        {
+            string str = File_path.Text.ToString();
+            string path = str.Substring(0, str.Length - 5) + "/*省略*/" + ".xlsx";
+            //var task = Task.Run(() => Thread.Sleep(0));
+            //Thread.Sleep(100);
+            try
+            {
+            if(task.IsCompleted || task.IsFaulted || task.IsCanceled)
+            {
+            task = Task.Run(() => XL_save_async(path));
+            }
+            }
+            catch (NullReferenceException)
+            {
+                task = Task.Run(() => XL_save_async(path));
+            }
+            //task.Wait();
+            return Task.WhenAll(task);
+        }
+        private Task XL_save_async(string path)
+        {
+            App_status.Text = "セーブ中";
+            XLData.SaveAs(path);
+            if (path != File_path.Text.ToString())
+            {
+            }
+            App_status.Text = "セーブ完了";
+                XLData = new XLWorkbook(path);
+                //XLSetup(path, WorkXL);
+            return Task.CompletedTask;
+        }
+        private void File_path_DragDrop(object sender, DragEventArgs e)
+        {
+            string[] files = (string[])e.Data.GetData(DataFormats.FileDrop);
+            XLSetup(files[0], WorkXL);
+            File_path.Text = files[0];
+            XLData.SaveAs(File_path.Text.ToString().Substring(0, File_path.Text.ToString().Length - 5) + "_cfat" + ".xlsx");
+        }
+        private void File_path_DragEnter(object sender, DragEventArgs e)
+        {
+            if (e.Data.GetDataPresent(DataFormats.FileDrop))
+            {
+                // ドラッグ中のファイルやディレクトリの取得
+                string[] drags = (string[])e.Data.GetData(DataFormats.FileDrop);
+                foreach (string d in drags)
+                {
+                    if (!System.IO.File.Exists(d))
+                    {
+                        // ファイル以外であればイベント・ハンドラを抜ける
+                        return;
+                    }
+                }
+                e.Effect = DragDropEffects.Copy;
+            }
+        }
+        private void Main_FormClosed(object sender, FormClosedEventArgs e)
+        {
+            if(XLData != null)
+            {
+                var task = XL_save();
+                task.Wait();
+            }
-        }
-        private Task XL_save()
-        {
-            string str = File_path.Text.ToString();
-            string path = str.Substring(0, str.Length - 5) + "_cfat" + ".xlsx";
-            try
-            {
-            if(task.IsCompleted || task.IsFaulted || task.IsCanceled)
-            {
-            task = Task.Run(() => XL_save_async(path));
-            }
-            }
-            catch (NullReferenceException)
-            {
-                task = Task.Run(() => XL_save_async(path));
-            }
-            return Task.WhenAll(task);
-        }
-        private Task XL_save_async(string path)
-        {
-            App_status.Text = "セーブ中";
-            XLData.SaveAs(path);
-            if (path != File_path.Text.ToString())
-            {
-            }
-            App_status.Text = "セーブ完了";
-                XLData = new XLWorkbook(path);
-                //XLSetup(path, WorkXL);
-            return Task.CompletedTask;
         }
@@ -280,6 +596,46 @@
+    }
+    class CmbObject
+    {
+        public int Key { get; set; }
+        public string Value { get; set; }
+        public CmbObject(int Key, string Value)
+        {
+            this.Key = Key;
+            this.Value = Value;
+        }
+        public override string ToString()
+        {
+            return Value;
+        }
+    }
+    }
+}
 ```