Commit: master - UmaTest (git)

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

Commit MetaInfo

• Revision: 61f5ff9bd36a871fd9fca272c05952ca02553c1b (tree)
• Time: 2021-06-27 05:07:21
• Author: yoshy <yoshy@user...>
• Commiter: yoshy

Log Message

temp_20210627_0507

Change Summary

• modified: App/Adaptor/Gateway/ViewModel/Dto/UmaRaceRowDto.cs
• modified: App/Domain/Model/Repository/Database/Dto/UmaRaceStat.cs
• modified: App/Domain/Model/Repository/Database/Entity/EveryDB2.cs
• modified: App/Presentation/View/MainWindow.cs
• modified: Infra/Helper/CodeHelper.cs
• modified: Infra/Helper/FormatHelper.cs
• modified: Resources/Sql/NUmaRaceDao_FindAllRacesByKettoNumListAsync.sql
• modified: Resources/Sql/uma_race_stddev2.sql

Incremental Difference

--- a/App/Adaptor/Gateway/ViewModel/Dto/UmaRaceRowDto.cs
+++ b/App/Adaptor/Gateway/ViewModel/Dto/UmaRaceRowDto.cs
@@ -55,6 +55,10 @@ namespace UmaTest.App.Adaptor.Gateway.ViewModel.Dto
 
             CourseName = TurfDirtName + Race?.Kyori;
 
+            TrackShapeName = CodeHelper.GetInstance().GetTrackShapeName(Race?.Trackcd, "不明");
+
+            bool isFlatRace = Race?.Trackcd.CompareTo("50") < 0;
+
             TosuFormatted = FormatHelper.FormatTosu(Race);
 
             BabaJyotaiFormatted = FormatHelper.FormatBabaJyotai(Race);
@@ -67,29 +71,52 @@ namespace UmaTest.App.Adaptor.Gateway.ViewModel.Dto
 
             Kimete = CodeHelper.GetInstance().GetName(CodeHelper.KYAKUSITU_KUBUN, Kyakusitukubun, "不明");
 
-            PCIRatioFormatted = FormatHelper.FormatPCIRatio(Harontimel3, Stat?.Harontimel3Avg, Stat?.Avgharontimeminus3Avg, Stat?.Avgharontimeminus3Dev);
+            if (isFlatRace)
+            {
+                PCIRatioFormatted = FormatHelper.FormatPCIRatio(Harontimel3, Stat?.Harontimel3Avg, Stat?.Avgharontimeminus3Avg, Stat?.Avgharontimeminus3Dev);
 
-            HaronTimeL3Formatted = FormatHelper.FormatTimeSSF(Harontimel3);
+                HaronTimeL3Formatted = FormatHelper.FormatTimeSSF(Harontimel3);
 
-            HaronTimeL3DevFormatted = FormatHelper.FormatHaronTimeL3Dev(Harontimel3, Stat?.Harontimel3Avg, Stat?.Harontimel3Dev);
+                HaronTimeL3DevFormatted = FormatHelper.FormatHaronTimeL3Dev(Harontimel3, Stat?.Harontimel3Avg, Stat?.Harontimel3Dev);
 
-            PCIFormatted = FormatHelper.FormatPCI(Harontimel3, Stat?.Avgharontimeminus3Avg, Stat?.Avgharontimeminus3Dev);
+                PCIFormatted = FormatHelper.FormatPCI(Harontimel3, Stat?.Avgharontimeminus3Avg, Stat?.Avgharontimeminus3Dev);
 
-            AvgHaronTimeMinus3Formatted = FormatHelper.FormatAvgHaronTimeMinus3(Time, Harontimel3, Race?.Kyori);
+                AvgHaronTimeMinus3Formatted = FormatHelper.FormatAvgHaronTimeMinus3(Time, Harontimel3, Race?.Kyori);
 
-            AvgHaronTimeMinus3DevFormatted = FormatHelper.FormatAvgHaronTimeMinus3Dev(Time, Harontimel3, Race?.Kyori, Stat?.Avgharontimeminus3Avg, Stat?.Avgharontimeminus3Dev);
+                AvgHaronTimeMinus3DevFormatted = FormatHelper.FormatAvgHaronTimeMinus3Dev(Time, Harontimel3, Race?.Kyori, Stat?.Avgharontimeminus3Avg, Stat?.Avgharontimeminus3Dev);
 
-            TimeFormatted = FormatHelper.FormatTimeMSSF(Time);
+                StatPCIFormatted = FormatHelper.FormatPCI(Stat?.Harontimel3Avg, Stat?.Avgharontimeminus3Avg, Stat?.Avgharontimeminus3Dev);
 
-            FutanFormatted = FormatHelper.ToNumber(Futan, 3, 1);
+                StatHaronTimeL3Formatted = FormatHelper.FormatTimeSSF(Stat?.Harontimel3Avg);
 
-            BataijyuFormatted = FormatHelper.FormatBataijyu(Bataijyu, Zogenfugo, Zogensa);
+                StatAvgHaronTimeMinus3Formatted = FormatHelper.FormatTimeSSF(Stat?.Avgharontimeminus3Avg);
+            }
+            else
+            {
+                PCIRatioFormatted = FormatHelper.NODATA;
+
+                HaronTimeL3Formatted = FormatHelper.NODATA;
+
+                HaronTimeL3DevFormatted = FormatHelper.NODATA;
+
+                PCIFormatted = FormatHelper.NODATA;
+
+                AvgHaronTimeMinus3Formatted = FormatHelper.FormatAvgHaronTime3(Time, Race?.Kyori);
 
-            StatPCIFormatted = FormatHelper.FormatPCI(Stat?.Harontimel3Avg, Stat?.Avgharontimeminus3Avg, Stat?.Avgharontimeminus3Dev);
+                AvgHaronTimeMinus3DevFormatted = FormatHelper.FormatAvgHaronTime3Dev(Time, Race?.Kyori, Stat?.Avgharontimeminus3Avg, Stat?.Avgharontimeminus3Dev);
 
-            StatHaronTimeL3Formatted = FormatHelper.FormatTimeSSF(Stat?.Harontimel3Avg);
+                StatPCIFormatted = FormatHelper.NODATA;
 
-            StatAvgHaronTimeMinus3Formatted = FormatHelper.FormatTimeSSF(Stat?.Avgharontimeminus3Avg);
+                StatHaronTimeL3Formatted = FormatHelper.NODATA;
+
+                StatAvgHaronTimeMinus3Formatted = FormatHelper.FormatTimeSSF(Stat?.Avgharontimeminus3Avg);
+            }
+
+            TimeFormatted = FormatHelper.FormatTimeMSSF(Time);
+
+            FutanFormatted = FormatHelper.ToNumber(Futan, 3, 1);
+
+            BataijyuFormatted = FormatHelper.FormatBataijyu(Bataijyu, Zogenfugo, Zogensa);
         }
 
         public string YearMonthDay { get; private set; }
@@ -108,6 +135,8 @@ namespace UmaTest.App.Adaptor.Gateway.ViewModel.Dto
 
         public string CourseName { get; private set; }
 
+        public string TrackShapeName { get; private set; }
+
         public string TosuFormatted { get; private set; }
 
         public string BabaJyotaiFormatted { get; private set; }

--- a/App/Domain/Model/Repository/Database/Dto/UmaRaceStat.cs
+++ b/App/Domain/Model/Repository/Database/Dto/UmaRaceStat.cs
@@ -8,7 +8,7 @@ using UmaTest.App.Domain.Model.Repository.Database.Entity.EveryDB2;
 
 namespace UmaTest.App.Domain.Model.Repository.Database.Dto
 {
-    public class UmaRaceStat : AppUmaRaceStddev
+    public class UmaRaceStat : AppUmaRaceStat
     {
         [Ignore]
         public string Key => $"{Jyocd}-{Kyori}-{Trackcd}-{Gradecd}-{Syubetucd}-{Kaishudate}";

--- a/App/Domain/Model/Repository/Database/Entity/EveryDB2.cs
+++ b/App/Domain/Model/Repository/Database/Entity/EveryDB2.cs
@@ -34,11 +34,11 @@ namespace UmaTest.App.Domain.Model.Repository.Database.Entity.EveryDB2
         }
     }
 
-    [TableName("\"public\".\"app_uma_race_stddev\"")]
+    [TableName("\"public\".\"app_uma_race_stat\"")]
     [PrimaryKey("kaishudate", AutoIncrement = false)]
     [ExplicitColumns]
-    public partial class AppUmaRaceStddev
-        : Record<AppUmaRaceStddev>
+    public partial class AppUmaRaceStat
+        : Record<AppUmaRaceStat>
     {
         [Column(Name = "jyocd")]
         public string Jyocd

--- a/App/Presentation/View/MainWindow.cs
+++ b/App/Presentation/View/MainWindow.cs
@@ -562,6 +562,11 @@ namespace UmaTest.App.Presentation.View
                 },
                 new DataGridViewTextBoxColumn
                 {
+                    DataPropertyName = "TrackShapeName",
+                    Name = "形状",
+                },
+                new DataGridViewTextBoxColumn
+                {
                     DataPropertyName = "GradeName",
                     Name = "G",
                 },
@@ -704,6 +709,7 @@ namespace UmaTest.App.Presentation.View
             //dataGridView2.Columns["ｺｰｽ"].HeaderCell.Style.WrapMode = DataGridViewTriState.False;
             //dataGridView2.Columns["馬体重"].HeaderCell.Style.WrapMode = DataGridViewTriState.False;
 
+            dataGridView2.Columns["形状"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
             dataGridView2.Columns["G"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
             dataGridView2.Columns["頭数"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
             dataGridView2.Columns["馬場"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
@@ -925,8 +931,9 @@ namespace UmaTest.App.Presentation.View
                 DataGridViewCell cellGrade = row.Cells["G"];
                 DataGridViewCell cellBasyo = row.Cells["場所"];
                 DataGridViewCell cellCourse = row.Cells["ｺｰｽ"];
+                DataGridViewCell cellShape = row.Cells["形状"];
 
-                ColorizeGradeBasyoCourse(row, cellGrade, cellBasyo, cellCourse);
+                ColorizeGradeBasyoCourse(row, cellGrade, cellBasyo, cellCourse, cellShape);
 
                 DataGridViewCell cellNinki = row.Cells["人気"];
                 DataGridViewCell cellJyuni = row.Cells["着順"];
@@ -948,7 +955,8 @@ namespace UmaTest.App.Presentation.View
             }
         }
 
-        private void ColorizeGradeBasyoCourse(DataGridViewRow row, DataGridViewCell cellGrade, DataGridViewCell cellBasyo, DataGridViewCell cellCourse)
+        private void ColorizeGradeBasyoCourse(DataGridViewRow row, DataGridViewCell cellGrade,
+                DataGridViewCell cellBasyo, DataGridViewCell cellCourse, DataGridViewCell cellShape)
         {
             NRace race = null;
 
@@ -963,12 +971,20 @@ namespace UmaTest.App.Presentation.View
                 return;
             }
 
-            ColorizeGradeBasyoCourse(race, cellGrade, cellBasyo, cellCourse);
+            ColorizeGradeBasyoCourse(race, cellGrade, cellBasyo, cellCourse, cellShape);
         }
 
-        private void ColorizeGradeBasyoCourse(NRace race, DataGridViewCell cellGrade, DataGridViewCell cellBasyo, DataGridViewCell cellCourse)
+        private void ColorizeGradeBasyoCourse(NRace race, DataGridViewCell cellGrade,
+                DataGridViewCell cellBasyo, DataGridViewCell cellCourse)
         {
-            if ( (race == null) || (cellGrade?.Value == null) || (cellBasyo?.Value == null) || (cellCourse?.Value == null) )
+            ColorizeGradeBasyoCourse(race, cellGrade, cellBasyo, cellCourse, null);
+        }
+
+        private void ColorizeGradeBasyoCourse(NRace race, DataGridViewCell cellGrade,
+                DataGridViewCell cellBasyo, DataGridViewCell cellCourse, DataGridViewCell cellShape)
+        {
+            if ( (race == null) || (cellGrade?.Value == null)
+                    || (cellBasyo?.Value == null) || (cellCourse?.Value == null))
             {
                 return;
             }
@@ -996,18 +1012,15 @@ namespace UmaTest.App.Presentation.View
             bool isNearCourse = isRowEqualTurfDirt && isRowNearKyori;
             bool isEqualCourse = isNearCourse && isRowEqualKyori && isRowEqualTrackCd;
 
+            bool isNearShape = isRowEqualTurfDirt && isRowNearKyori && isRowEqualTrackCd;
+            bool isEqualShape = isNearShape && isRowEqualKyori;
+
             bool isNearBasyoCourse = isNearCourse && isRowEqualJyoCd;
             bool isEqualBasyoCourse = isNearBasyoCourse && isEqualCourse;
 
             bool isNearGrade = isNearCourse && isRowEqualGrade;
             bool isEqualGrade = isNearGrade && isEqualBasyoCourse;
 
-            (Color, Color) colorGrade = isNearGrade
-                    ? isEqualGrade
-                            ? AppConst.COLOR_FIRST
-                            : AppConst.COLOR_SECOND
-                    : AppConst.COLOR_NONE;
-
             (Color, Color) colorBasyo = isNearBasyoCourse
                     ? isEqualBasyoCourse
                             ? AppConst.COLOR_FIRST
@@ -1020,10 +1033,17 @@ namespace UmaTest.App.Presentation.View
                             : AppConst.COLOR_SECOND
                     : AppConst.COLOR_NONE;
 
-            if (colorGrade != AppConst.COLOR_NONE)
-            {
-                ChangeCellBackColor(cellGrade, colorGrade);
-            }
+            (Color, Color) colorShape = isNearShape
+                    ? isEqualShape
+                            ? AppConst.COLOR_FIRST
+                            : AppConst.COLOR_SECOND
+                    : AppConst.COLOR_NONE;
+
+            (Color, Color) colorGrade = isNearGrade
+                    ? isEqualGrade
+                            ? AppConst.COLOR_FIRST
+                            : AppConst.COLOR_SECOND
+                    : AppConst.COLOR_NONE;
 
             if (colorBasyo != AppConst.COLOR_NONE)
             {
@@ -1034,6 +1054,16 @@ namespace UmaTest.App.Presentation.View
             {
                 ChangeCellBackColor(cellCourse, colorCourse);
             }
+
+            if ( (cellShape != null) && (colorShape != AppConst.COLOR_NONE) )
+            {
+                ChangeCellBackColor(cellShape, colorShape);
+            }
+
+            if (colorGrade != AppConst.COLOR_NONE)
+            {
+                ChangeCellBackColor(cellGrade, colorGrade);
+            }
         }
 
         private static void ColorizeKankaku(DataGridViewCell cellKankaku)

--- a/Infra/Helper/CodeHelper.cs
+++ b/Infra/Helper/CodeHelper.cs
@@ -26,7 +26,7 @@ namespace UmaTest.Infra.Helper
         public static readonly string KYAKUSITU_KUBUN = "9201";
         public static readonly string RACE_DATA_KUBUN = "9202";
 
-        public const string TRACK_NAME_TURF_AND_DIRT = "芝ダ";
+        public const string TRACK_NAME_TURF_TO_DIRT = "芝ダ";
         public const string TRACK_NAME_TURF = "芝";
         public const string TRACK_NAME_DIRT = "ダ";
         public const string TRACK_NAME_SAND = "砂";
@@ -40,6 +40,7 @@ namespace UmaTest.Infra.Helper
         public static readonly string RACE_CLASS_THREE_WINS = "3勝";
 
         private const string NODATA = "-";
+        private const string NODETAIL = "―";
         private const string NA = "NA";
         private const string UNKNOWN = "？";
         private const string ERROR_VALUE = "#ERROR";
@@ -66,15 +67,15 @@ namespace UmaTest.Infra.Helper
 
         public string GetRaceName(NRace race, string errorValue)
         {
-            return race != null ? GetRaceName(race.Hondai, race.Gradecd, race.Jyokencd5, errorValue) : string.Empty;
+            return race != null ? GetRaceName(race.Hondai, race.Gradecd, race.Jyokencd5, race.Kigocd, errorValue) : string.Empty;
         }
 
         public string GetRaceName(NTokuRace race, string errorValue)
         {
-            return race != null ? GetRaceName(race.Hondai, race.Gradecd, race.Jyokencd5, errorValue) : string.Empty;
+            return race != null ? GetRaceName(race.Hondai, race.Gradecd, race.Jyokencd5, race.Kigocd, errorValue) : string.Empty;
         }
 
-        private string GetRaceName(string hondai, string gradeCd, string jyokenCd, string errorValue)
+        private string GetRaceName(string hondai, string gradeCd, string jyokenCd, string kigoCd, string errorValue)
         {
             if (!String.IsNullOrEmpty(hondai))
             {
@@ -92,30 +93,49 @@ namespace UmaTest.Infra.Helper
 
             //Logger.Debug($"条件CD：{jyokenCd}");
 
+            string winClass = string.Empty;
+
             if (jyokenCd.CompareTo("100") <= 0)
             {
                 if (int.TryParse(jyokenCd, out int shokin))
                 {
                     if (shokin <= 5)
                     {
-                        return "１勝クラス";
+                        winClass =  "１勝クラス";
                     }
                     else if (shokin <= 10)
                     {
-                        return "２勝クラス";
+                        winClass =  "２勝クラス";
                     }
                     else if (shokin <= 16)
                     {
-                        return "３勝クラス";
+                        winClass =  "３勝クラス";
                     }
                     else if (shokin <= 100)
                     {
-                        return "オープン戦";
+                        winClass =  "オープン戦";
                     }
                 }
             }
 
-            return GetName(CodeHelper.JYOKEN_CODE, jyokenCd, errorValue);
+            if (string.IsNullOrEmpty(winClass))
+            {
+                winClass = GetName(CodeHelper.JYOKEN_CODE, jyokenCd, errorValue);
+            }
+
+            string himba = GetHimbaName(kigoCd);
+
+            if (!string.IsNullOrEmpty(himba))
+            {
+                return $"{winClass} ({himba})";
+            }
+
+            return winClass;
+        }
+
+        public string GetHimbaName(string kigoCd)
+        {
+            return (!string.IsNullOrEmpty(kigoCd) && (kigoCd.Length == 3) && (kigoCd[1] == '2')) ? "牝" : string.Empty;
         }
 
         public string GetGradeName(NRace race, string errorValue)
@@ -187,13 +207,18 @@ namespace UmaTest.Infra.Helper
 
             string trackEngName = GetName(TRACK_CODE, trackCd, 2, errorValue);
 
+            if (trackEngName == errorValue)
+            {
+                return trackEngName;
+            }
+
             if (trackCd.CompareTo("50") < 0)
             {
                 return ExtractTurfDartName(trackEngName);
             }
             else
             {
-                string turfDartKbn = (trackCd != "52") ? ExtractTurfDartName(trackEngName) : TRACK_NAME_TURF_AND_DIRT;
+                string turfDartKbn = (trackCd != "52") ? ExtractTurfDartName(trackEngName) : TRACK_NAME_TURF_TO_DIRT;
                 return TRACK_NAME_HURDLE + turfDartKbn;
             }
         }
@@ -225,6 +250,57 @@ namespace UmaTest.Infra.Helper
             return turfDartKbn;
         }
 
+        public string GetTrackShapeName(string trackCd, string errorValue)
+        {
+            if (string.IsNullOrEmpty(trackCd))
+            {
+                return string.Empty;
+            }
+
+            string trackName = GetName(TRACK_CODE, trackCd, 1, errorValue);
+
+            if (trackName == errorValue)
+            {
+                return trackName;
+            }
+
+            if (trackCd.CompareTo("50") < 0)
+            {
+                return ExtractFlagTrackShapeName(trackName, errorValue);
+            }
+            else
+            {
+                return ExtractJumpTrackShapeName(trackName, errorValue);
+            }
+        }
+
+        private string ExtractFlagTrackShapeName(string trackName, string errorValue)
+        {
+            string[] raceTypeAndTrackShape = trackName.Split('・');
+
+            if (raceTypeAndTrackShape.Length != 2)
+            {
+                return errorValue;
+            }
+
+            return raceTypeAndTrackShape[1];
+        }
+
+        private string ExtractJumpTrackShapeName(string trackName, string errorValue)
+        {
+            if (!trackName.StartsWith("芝・"))
+            {
+                if (trackName == "芝")
+                {
+                    return NODETAIL;
+                }
+
+                return trackName;
+            }
+
+            return trackName.Substring(2);
+        }
+
         public string GetName(string code, string value, string errorValue = ERROR_VALUE)
         {
             return GetName(code, value, 0, errorValue);

--- a/Infra/Helper/FormatHelper.cs
+++ b/Infra/Helper/FormatHelper.cs
@@ -330,6 +330,95 @@ namespace UmaTest.Infra.Helper
             return ((decimal)(time - haronTimeL3)) * (600 / divider) / (kyori - 600);
         }
 
+        public static string FormatAvgHaronTime3(string time, string kyori)
+        {
+            if (string.IsNullOrEmpty(time) || string.IsNullOrEmpty(kyori))
+            {
+                return string.Empty;
+            }
+
+            if (time == INIT_DATA_0000)
+            {
+                return NODATA;
+            }
+
+            try
+            {
+                // unit: 100[msec.]
+                int nTime = int.Parse(time.Substring(0, 1)) * 600 + int.Parse(time.Substring(1, 3));
+
+                int nKyori = int.Parse(kyori);
+
+                return FormatAvgHaronTime3(nTime, nKyori);
+            }
+            catch (Exception)
+            {
+                return NA;
+            }
+        }
+
+        public static string FormatAvgHaronTime3(int time, int kyori)
+        {
+            if (time == -1)
+            {
+                return NODATA;
+            }
+
+            // unit: 1[sec.]
+            decimal avgHaronTime3 = CalcAvgHaronTime3(time, kyori, 10);
+
+            return Math.Round(avgHaronTime3, 2, MidpointRounding.AwayFromZero).ToString("0.00");
+        }
+
+        public static string FormatAvgHaronTime3Dev(string time, string kyori, decimal? avgAvgHaronTime3F, decimal? stdDevtAvgHaronTime3)
+        {
+            if (string.IsNullOrEmpty(time) || string.IsNullOrEmpty(kyori)
+                    || !avgAvgHaronTime3F.HasValue || !stdDevtAvgHaronTime3.HasValue)
+            {
+                return string.Empty;
+            }
+
+            if (time == INIT_DATA_0000)
+            {
+                return NODATA;
+            }
+
+            try
+            {
+                // unit: 100[msec.]
+                int nTime = int.Parse(time.Substring(0, 1)) * 600 + int.Parse(time.Substring(1, 3));
+
+                int nKyori = int.Parse(kyori);
+
+                return FormatAvgHaronTime3Dev(nTime, nKyori, avgAvgHaronTime3F, stdDevtAvgHaronTime3);
+            }
+            catch (Exception)
+            {
+                return NA;
+            }
+        }
+
+        public static string FormatAvgHaronTime3Dev(int time, int kyori, decimal? avgAvgHaronTime3F, decimal? stdDevtAvgHaronTime3)
+        {
+            if (time == -1)
+            {
+                return NODATA;
+            }
+
+            // unit: 100[msec.]
+            decimal avgHaronTime3 = CalcAvgHaronTime3(time, kyori, 1);
+
+            decimal dev = CalcScoreByStdDevReverse(avgHaronTime3, avgAvgHaronTime3F.Value, stdDevtAvgHaronTime3.Value, 100, 20);
+
+            return Math.Round(dev, 1, MidpointRounding.AwayFromZero).ToString("#0.0");
+        }
+
+        private static decimal CalcAvgHaronTime3(int time, int kyori, int divider)
+        {
+            // unit: 1[sec.] / divider
+            return ((decimal)time) * (600 / divider) / kyori;
+        }
+
         public static string FormatPCI(string haronTimeL3, decimal? avgAvgHaronTimeMinus3F, decimal? stdDevtAvgHaronTimeMinus3)
         {
             if (string.IsNullOrEmpty(haronTimeL3))
@@ -496,19 +585,7 @@ namespace UmaTest.Infra.Helper
             string sibaJyotai = CodeHelper.GetInstance().GetName(CodeHelper.BABA_JYOTAI_CODE, race.Sibababacd, string.Empty);
             string dirtJyotai = CodeHelper.GetInstance().GetName(CodeHelper.BABA_JYOTAI_CODE, race.Dirtbabacd, string.Empty);
 
-            string turfDirtName = CodeHelper.GetInstance().GetTurfDurtName(race.Trackcd, string.Empty);
-
-            switch(turfDirtName)
-            {
-                case CodeHelper.TRACK_NAME_TURF:
-                    return sibaJyotai;
-                case CodeHelper.TRACK_NAME_DIRT:
-                    return dirtJyotai;
-                case CodeHelper.TRACK_NAME_TURF_AND_DIRT:
-                    return !string.IsNullOrEmpty(sibaJyotai) && !string.IsNullOrEmpty(dirtJyotai) ? sibaJyotai + "・" + dirtJyotai : string.Empty;
-            }
-
-            return string.Empty;
+            return sibaJyotai + (!string.IsNullOrEmpty(sibaJyotai) && !string.IsNullOrEmpty(dirtJyotai) ? "／" : string.Empty) + dirtJyotai;
         }
 
         public static string FormatTosu(NTokuRace race)

--- a/Resources/Sql/NUmaRaceDao_FindAllRacesByKettoNumListAsync.sql
+++ b/Resources/Sql/NUmaRaceDao_FindAllRacesByKettoNumListAsync.sql
@@ -45,7 +45,7 @@ from
   left join n_course c
   using(jyocd, kyori, trackcd)
 )
-SELECT ur.*, r.*, k.*, c.*, ot.*, h1.*, h5.*, urdev.*
+SELECT ur.*, r.*, k.*, c.*, ot.*, h1.*, h5.*, urstat.*
 FROM n_uma_race ur
 INNER JOIN n_race r USING(year, jyocd, kaiji, nichiji, racenum)
 LEFT JOIN n_uma u USING(kettonum)
@@ -75,12 +75,12 @@ AND vur.gradecd = case r.gradecd
       else r.gradecd
     end
 AND r.syubetucd = vur.syubetucd
-LEFT JOIN app_uma_race_stddev urdev
- ON vur.jyocd      = urdev.jyocd
-AND vur.kyori      = urdev.kyori
-AND vur.trackcd    = urdev.trackcd
-AND vur.gradecd    = urdev.gradecd
-AND vur.syubetucd  = urdev.syubetucd
-AND vur.kaishudate = urdev.kaishudate
+LEFT JOIN app_uma_race_stat urstat
+ ON vur.jyocd      = urstat.jyocd
+AND vur.kyori      = urstat.kyori
+AND vur.trackcd    = urstat.trackcd
+AND vur.gradecd    = urstat.gradecd
+AND vur.syubetucd  = urstat.syubetucd
+AND vur.kaishudate = urstat.kaishudate
 WHERE ur.kettonum in (@KettoNums)
 ORDER BY ur.kettonum, ur.year desc, ur.monthday desc
\ No newline at end of file

--- a/Resources/Sql/uma_race_stddev2.sql
+++ b/Resources/Sql/uma_race_stddev2.sql
@@ -1,4 +1,4 @@
-create table app_uma_race_stddev as
+create table app_uma_race_stat as
 with v_uma_race_base1 as (
 select
   r.jyocd
@@ -62,12 +62,15 @@ select
         + to_number(substring(ur.time, 2, 2), '00') * 10
         + to_number(substring(ur.time, 4, 1), '0') 
     end as time
-  , case ur.harontimel3
-      when '000' then null 
-      when '999' then null 
-      when '   ' then null 
-      else to_number(substring(ur.harontimel3, 1, 2), '00') * 10
-        + to_number(substring(ur.harontimel3, 3, 1), '0') 
+  , case
+      when ur.trackcd >= '50' then null
+      else case ur.harontimel3
+        when '000' then null 
+        when '999' then null 
+        when '   ' then null 
+        else to_number(substring(ur.harontimel3, 1, 2), '00') * 10
+          + to_number(substring(ur.harontimel3, 3, 1), '0')
+      end 
     end as harontimel3
 from
   v_uma_race_base2 ur
@@ -81,9 +84,12 @@ select
   , ur.kaishudate 
   , ur.time 
   , ur.harontimel3
-  , case ur.harontimel3
-      when null then null
-      else (ur.time - ur.harontimel3) * 600 / (ur.kyori - 600)
+  , case
+      when ur.trackcd >= '50' then ur.time * 600 / ur.kyori
+      else case ur.harontimel3
+        when null then null
+        else (ur.time - ur.harontimel3) * 600 / (ur.kyori - 600)
+      end
     end as avgharontimeminus3
 from
   v_uma_race_base3 ur
@@ -125,7 +131,7 @@ order by
   , ur.syubetucd
   , ur.kaishudate
 ;
-alter table app_uma_race_stddev add constraint pk_app_uma_race_stddev primary key (jyocd, kyori, trackcd, gradecd, syubetucd, kaishudate)
+alter table app_uma_race_stat add constraint pk_app_uma_race_stat primary key (jyocd, kyori, trackcd, gradecd, syubetucd, kaishudate)
 ;
-drop table app_uma_race_stddev
+drop table app_uma_race_stat
 ;