Commit: 44c0c71583d2c32f739d266020fd99d0354e45bc - UmaTest (git)

EveryDB2のデータベースを読み込んでWinFormでGUI表示するサンプル

Commit MetaInfo

• Revisión: 44c0c71583d2c32f739d266020fd99d0354e45bc (tree)
• Tiempo: 2021-06-07 02:27:27
• Autor: yoshy <yoshy@user...>
• Commiter: yoshy

Log Message

temp_20210607_0227

Cambiar Resumen

• modified: App/Presentation/View/MainWindow.cs

Diferencia incremental

--- a/App/Presentation/View/MainWindow.cs
+++ b/App/Presentation/View/MainWindow.cs
@@ -18,6 +18,7 @@ using UmaTest.App.Domain.Model.Repository.Database.Entity.EveryDB2;
 using UmaTest.Infra.Adaptor.Command;
 using UmaTest.Infra.Adaptor.ViewModel;
 using UmaTest.Infra.Domain.Translator;
+using UmaTest.Infra.Helper;
 using UmaTest.Infra.Presentation.View;
 
 namespace UmaTest.App.Presentation.View
@@ -202,8 +203,8 @@ namespace UmaTest.App.Presentation.View
                 },
                 new DataGridViewTextBoxColumn
                 {
-                    DataPropertyName = "Zenso.GradeName",
-                    Name = "前走G",
+                    DataPropertyName = "Zenso.JyoName",
+                    Name = "前走場所",
                 },
                 new DataGridViewTextBoxColumn
                 {
@@ -212,6 +213,11 @@ namespace UmaTest.App.Presentation.View
                 },
                 new DataGridViewTextBoxColumn
                 {
+                    DataPropertyName = "Zenso.GradeName",
+                    Name = "前走G",
+                },
+                new DataGridViewTextBoxColumn
+                {
                     DataPropertyName = "Zenso.RaceName",
                     Name = "前走ﾚｰｽ名",
                 },
@@ -287,8 +293,8 @@ namespace UmaTest.App.Presentation.View
                 },
                 new DataGridViewTextBoxColumn
                 {
-                    DataPropertyName = "NisoMae.GradeName",
-                    Name = "前々走G",
+                    DataPropertyName = "NisoMae.JyoName",
+                    Name = "前々走場所",
                 },
                 new DataGridViewTextBoxColumn
                 {
@@ -297,6 +303,11 @@ namespace UmaTest.App.Presentation.View
                 },
                 new DataGridViewTextBoxColumn
                 {
+                    DataPropertyName = "NisoMae.GradeName",
+                    Name = "前々走G",
+                },
+                new DataGridViewTextBoxColumn
+                {
                     DataPropertyName = "NisoMae.RaceName",
                     Name = "前々走ﾚｰｽ名",
                 },
@@ -546,13 +557,13 @@ namespace UmaTest.App.Presentation.View
                 },
                 new DataGridViewTextBoxColumn
                 {
-                    DataPropertyName = "GradeName",
-                    Name = "G",
+                    DataPropertyName = "CourseName",
+                    Name = "ｺｰｽ",
                 },
                 new DataGridViewTextBoxColumn
                 {
-                    DataPropertyName = "CourseName",
-                    Name = "ｺｰｽ",
+                    DataPropertyName = "GradeName",
+                    Name = "G",
                 },
                 new DataGridViewTextBoxColumn
                 {
@@ -841,9 +852,13 @@ namespace UmaTest.App.Presentation.View
         {
             foreach (DataGridViewRow row in dataGridView1.Rows)
             {
+                UmaSummaryRowDto rowDto = row.DataBoundItem as UmaSummaryRowDto;
+
+                DataGridViewCell cellJyuni = row.Cells["着順"];
                 DataGridViewCell cellNinki = row.Cells["人気"];
 
                 ColorizeNinki(cellNinki);
+                ColorizeJyuni(cellJyuni, cellNinki);
 
                 DataGridViewCell cellKankaku = row.Cells["間隔"];
 
@@ -853,6 +868,18 @@ namespace UmaTest.App.Presentation.View
 
                 ColorizeKankaku(cellZensoKankaku);
 
+                DataGridViewCell cellZensoGrade = row.Cells["前走G"];
+                DataGridViewCell cellZensoBasyo = row.Cells["前走場所"];
+                DataGridViewCell cellZensoCourse = row.Cells["前走ｺｰｽ"];
+
+                ColorizeGradeBasyoCourse(rowDto.Zenso?.Race, cellZensoGrade, cellZensoBasyo, cellZensoCourse);
+
+                DataGridViewCell cellNisoMaeGrade = row.Cells["前々走G"];
+                DataGridViewCell cellNisoMaeBasyo = row.Cells["前々走場所"];
+                DataGridViewCell cellNisoMaeCourse = row.Cells["前々走ｺｰｽ"];
+
+                ColorizeGradeBasyoCourse(rowDto.NisoMae?.Race, cellNisoMaeGrade, cellNisoMaeBasyo, cellNisoMaeCourse);
+
                 DataGridViewCell cellZensoJyuni = row.Cells["前走着順"];
                 DataGridViewCell cellZensoNinki = row.Cells["前走人気"];
 
@@ -891,23 +918,20 @@ namespace UmaTest.App.Presentation.View
             }
         }
 
-        private static void ChangeCellBackColor(DataGridViewCell cell, Color backColor)
-        {
-            cell.Style.BackColor = backColor;
-            cell.Style.SelectionBackColor = backColor;
-            cell.Style.SelectionForeColor = SystemColors.WindowText;
-        }
-
         private void ColorizeUmaRaceListView()
         {
             foreach (DataGridViewRow row in dataGridView2.Rows)
             {
-                DataGridViewCell cellNinki = row.Cells["人気"];
+                DataGridViewCell cellGrade = row.Cells["G"];
+                DataGridViewCell cellBasyo = row.Cells["場所"];
+                DataGridViewCell cellCourse = row.Cells["ｺｰｽ"];
 
-                ColorizeNinki(cellNinki);
+                ColorizeGradeBasyoCourse(row, cellGrade, cellBasyo, cellCourse);
 
+                DataGridViewCell cellNinki = row.Cells["人気"];
                 DataGridViewCell cellJyuni = row.Cells["着順"];
 
+                ColorizeNinki(cellNinki);
                 ColorizeJyuni(cellJyuni, cellNinki);
 
                 DataGridViewCell cellPCI = row.Cells["ﾍﾟｰｽ変化指数"];
@@ -924,9 +948,182 @@ namespace UmaTest.App.Presentation.View
             }
         }
 
+        private void ColorizeGradeBasyoCourse(DataGridViewRow row, DataGridViewCell cellGrade, DataGridViewCell cellBasyo, DataGridViewCell cellCourse)
+        {
+            NRace race = null;
+
+            if (row.DataBoundItem.GetType() == typeof(UmaRaceRowDto))
+            {
+                UmaRaceRowDto rowDto = row.DataBoundItem as UmaRaceRowDto;
+                race = rowDto.Race;
+            }
+
+            if (race == null)
+            {
+                return;
+            }
+
+            ColorizeGradeBasyoCourse(race, cellGrade, cellBasyo, cellCourse);
+        }
+
+        private void ColorizeGradeBasyoCourse(NRace race, DataGridViewCell cellGrade, DataGridViewCell cellBasyo, DataGridViewCell cellCourse)
+        {
+            if ( (race == null) || (cellGrade?.Value == null) || (cellBasyo?.Value == null) || (cellCourse?.Value == null) )
+            {
+                return;
+            }
+
+            if (!int.TryParse(raceInfo?.Kyori, out int raceKyori))
+            {
+                return;
+            }
+
+            if (!int.TryParse(race?.Kyori, out int rowKyori))
+            {
+                return;
+            }
+
+            string raceTurfDirt = CodeHelper.GetInstance().GetTurfDurtName(raceInfo?.Trackcd, string.Empty);
+            string rowTurfDirt = CodeHelper.GetInstance().GetTurfDurtName(race.Trackcd, string.Empty);
+
+            bool isRowNearKyori = Math.Abs(raceKyori - rowKyori) <= 200;
+            bool isRowEqualKyori = raceKyori == rowKyori;
+            bool isRowEqualTrackCd = raceInfo?.Trackcd == race.Trackcd;
+            bool isRowEqualJyoCd = raceInfo?.Jyocd == race.Jyocd;
+            bool isRowEqualTurfDirt = raceTurfDirt == rowTurfDirt;
+            bool isRowEqualGrade = raceInfo?.GradeName == CodeHelper.GetInstance().GetGradeName(race, string.Empty);
+
+            bool isNearCourse = isRowEqualTurfDirt && isRowNearKyori;
+            bool isEqualCourse = isNearCourse && isRowEqualKyori && isRowEqualTrackCd;
+
+            bool isNearBasyoCourse = isNearCourse && isRowEqualJyoCd;
+            bool isEqualBasyoCourse = isNearBasyoCourse && isEqualCourse;
+
+            bool isNearGrade = isNearCourse && isRowEqualGrade;
+            bool isEqualGrade = isNearGrade && isEqualBasyoCourse;
+
+            Color colorGrade = isNearGrade
+                    ? isEqualGrade
+                            ? Color.Yellow
+                            : Color.Cyan
+                    : Color.Transparent;
+
+            Color colorBasyo = isNearBasyoCourse
+                    ? isEqualBasyoCourse
+                            ? Color.Yellow
+                            : Color.Cyan
+                    : Color.Transparent;
+
+            Color colorCourse = isNearCourse
+                    ? isEqualCourse
+                            ? Color.Yellow
+                            : Color.Cyan
+                    : Color.Transparent;
+
+            if (colorGrade != Color.Transparent)
+            {
+                ChangeCellBackColor(cellGrade, colorGrade);
+            }
+
+            if (colorBasyo != Color.Transparent)
+            {
+                ChangeCellBackColor(cellBasyo, colorBasyo);
+            }
+
+            if (colorCourse != Color.Transparent)
+            {
+                ChangeCellBackColor(cellCourse, colorCourse);
+            }
+        }
+
+        private static void ColorizeKankaku(DataGridViewCell cellKankaku)
+        {
+            if (cellKankaku?.Value == null)
+            {
+                return;
+            }
+
+            if (int.TryParse(cellKankaku.Value.ToString(), out int kankaku))
+            {
+                if (kankaku >= 30)
+                {
+                    ChangeCellBackColor(cellKankaku, Color.Orange);
+                }
+                else if (kankaku >= 10)
+                {
+                    ChangeCellBackColor(cellKankaku, Color.Yellow);
+                }
+            }
+        }
+
+        private static void ColorizeNinki(DataGridViewCell cellNinki)
+        {
+            if (cellNinki?.Value == null)
+            {
+                return;
+            }
+
+            if (int.TryParse(cellNinki.Value.ToString(), out int ninki))
+            {
+                switch (ninki)
+                {
+                    case 1:
+                        ChangeCellBackColor(cellNinki, Color.Yellow);
+                        break;
+                    case 2:
+                        ChangeCellBackColor(cellNinki, Color.Cyan);
+                        break;
+                    case 3:
+                        ChangeCellBackColor(cellNinki, Color.LightGreen);
+                        break;
+                    default:
+                        break;
+                }
+            }
+        }
+
+        private static void ColorizeJyuni(DataGridViewCell cellJyuni, DataGridViewCell cellNinki)
+        {
+            if ((cellJyuni?.Value == null) || (cellNinki?.Value == null))
+            {
+                return;
+            }
+
+            if (int.TryParse(cellJyuni.Value.ToString(), out int jyuni)
+                    && int.TryParse(cellNinki.Value.ToString(), out int ninki))
+            {
+                switch (jyuni)
+                {
+                    case 1:
+                        ChangeCellBackColor(cellJyuni, Color.Yellow);
+                        break;
+                    case 2:
+                        ChangeCellBackColor(cellJyuni, Color.Cyan);
+                        break;
+                    case 3:
+                        ChangeCellBackColor(cellJyuni, Color.LightGreen);
+                        break;
+                    default:
+                        if ( (ninki >= 6) && (jyuni <= 6) && (ninki - jyuni > 1) )
+                        {
+                            ChangeCellBackColor(cellJyuni, Color.LightSkyBlue);
+                        }
+                        else if ((ninki <= 3) && (jyuni > 3))
+                        {
+                            ChangeCellBackColor(cellJyuni, Color.Orange);
+                        }
+                        else if (ninki - jyuni < -2)
+                        {
+                            ChangeCellBackColor(cellJyuni, Color.Orange);
+                        }
+                        break;
+                }
+            }
+        }
+
         private void ColorizePCI(DataGridViewCell cellPCI, DataGridViewCell cellJyuni)
         {
-            if ( (cellPCI?.Value == null) || (cellJyuni?.Value == null) )
+            if ((cellPCI?.Value == null) || (cellJyuni?.Value == null))
             {
                 return;
             }
@@ -1099,89 +1296,11 @@ namespace UmaTest.App.Presentation.View
             }
         }
 
-        private static void ColorizeKankaku(DataGridViewCell cellKankaku)
-        {
-            if (cellKankaku?.Value == null)
-            {
-                return;
-            }
-
-            if (int.TryParse(cellKankaku.Value.ToString(), out int kankaku))
-            {
-                if (kankaku >= 30)
-                {
-                    ChangeCellBackColor(cellKankaku, Color.Orange);
-                }
-                else if (kankaku >= 10)
-                {
-                    ChangeCellBackColor(cellKankaku, Color.Yellow);
-                }
-            }
-        }
-
-        private static void ColorizeNinki(DataGridViewCell cellNinki)
-        {
-            if (cellNinki?.Value == null)
-            {
-                return;
-            }
-
-            if (int.TryParse(cellNinki.Value.ToString(), out int ninki))
-            {
-                switch (ninki)
-                {
-                    case 1:
-                        ChangeCellBackColor(cellNinki, Color.Yellow);
-                        break;
-                    case 2:
-                        ChangeCellBackColor(cellNinki, Color.Cyan);
-                        break;
-                    case 3:
-                        ChangeCellBackColor(cellNinki, Color.LightGreen);
-                        break;
-                    default:
-                        break;
-                }
-            }
-        }
-
-        private static void ColorizeJyuni(DataGridViewCell cellJyuni, DataGridViewCell cellNinki)
+        private static void ChangeCellBackColor(DataGridViewCell cell, Color backColor)
         {
-            if ((cellJyuni?.Value == null) || (cellNinki?.Value == null))
-            {
-                return;
-            }
-
-            if (int.TryParse(cellJyuni.Value.ToString(), out int jyuni)
-                    && int.TryParse(cellNinki.Value.ToString(), out int ninki))
-            {
-                switch (jyuni)
-                {
-                    case 1:
-                        ChangeCellBackColor(cellJyuni, Color.Yellow);
-                        break;
-                    case 2:
-                        ChangeCellBackColor(cellJyuni, Color.Cyan);
-                        break;
-                    case 3:
-                        ChangeCellBackColor(cellJyuni, Color.LightGreen);
-                        break;
-                    default:
-                        if ( (ninki >= 6) && (jyuni <= 6) && (ninki - jyuni > 1) )
-                        {
-                            ChangeCellBackColor(cellJyuni, Color.LightSkyBlue);
-                        }
-                        else if ((ninki <= 3) && (jyuni > 3))
-                        {
-                            ChangeCellBackColor(cellJyuni, Color.Orange);
-                        }
-                        else if (ninki - jyuni < -2)
-                        {
-                            ChangeCellBackColor(cellJyuni, Color.Orange);
-                        }
-                        break;
-                }
-            }
+            cell.Style.BackColor = backColor;
+            cell.Style.SelectionBackColor = backColor;
+            cell.Style.SelectionForeColor = SystemColors.WindowText;
         }
 
         private void MainWindow_ResizeBegin(object sender, EventArgs e)