EveryDB2のデータベースを読み込んでWinFormでGUI表示するサンプル
修訂 | 113a847f35e346718b1da49629d21e5dd1a3d45c (tree) |
---|---|
時間 | 2021-06-06 23:53:43 |
作者 | yoshy <yoshy@user...> |
Commiter | yoshy |
temp_20210606_0643
@@ -34,6 +34,8 @@ namespace UmaTest.App.Presentation.View | ||
34 | 34 | System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle3 = new System.Windows.Forms.DataGridViewCellStyle(); |
35 | 35 | System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle4 = new System.Windows.Forms.DataGridViewCellStyle(); |
36 | 36 | System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle5 = new System.Windows.Forms.DataGridViewCellStyle(); |
37 | + System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle6 = new System.Windows.Forms.DataGridViewCellStyle(); | |
38 | + System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle7 = new System.Windows.Forms.DataGridViewCellStyle(); | |
37 | 39 | this.menuStrip1 = new System.Windows.Forms.MenuStrip(); |
38 | 40 | this.toolStripMenuFile = new System.Windows.Forms.ToolStripMenuItem(); |
39 | 41 | this.toolStripMenuOpenHorseList = new System.Windows.Forms.ToolStripMenuItem(); |
@@ -174,11 +176,19 @@ namespace UmaTest.App.Presentation.View | ||
174 | 176 | dataGridViewCellStyle2.BackColor = System.Drawing.SystemColors.Control; |
175 | 177 | dataGridViewCellStyle2.Font = new System.Drawing.Font("MS ゴシック", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(128))); |
176 | 178 | dataGridViewCellStyle2.ForeColor = System.Drawing.SystemColors.WindowText; |
177 | - dataGridViewCellStyle2.SelectionBackColor = System.Drawing.SystemColors.Highlight; | |
178 | - dataGridViewCellStyle2.SelectionForeColor = System.Drawing.SystemColors.HighlightText; | |
179 | + dataGridViewCellStyle2.SelectionBackColor = System.Drawing.SystemColors.Control; | |
180 | + dataGridViewCellStyle2.SelectionForeColor = System.Drawing.SystemColors.WindowText; | |
179 | 181 | dataGridViewCellStyle2.WrapMode = System.Windows.Forms.DataGridViewTriState.True; |
180 | 182 | this.dataGridView1.ColumnHeadersDefaultCellStyle = dataGridViewCellStyle2; |
181 | 183 | this.dataGridView1.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize; |
184 | + dataGridViewCellStyle3.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleLeft; | |
185 | + dataGridViewCellStyle3.BackColor = System.Drawing.SystemColors.Window; | |
186 | + dataGridViewCellStyle3.Font = new System.Drawing.Font("Meiryo UI", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); | |
187 | + dataGridViewCellStyle3.ForeColor = System.Drawing.SystemColors.ControlText; | |
188 | + dataGridViewCellStyle3.SelectionBackColor = System.Drawing.SystemColors.Highlight; | |
189 | + dataGridViewCellStyle3.SelectionForeColor = System.Drawing.SystemColors.HighlightText; | |
190 | + dataGridViewCellStyle3.WrapMode = System.Windows.Forms.DataGridViewTriState.False; | |
191 | + this.dataGridView1.DefaultCellStyle = dataGridViewCellStyle3; | |
182 | 192 | this.dataGridView1.Dock = System.Windows.Forms.DockStyle.Fill; |
183 | 193 | this.dataGridView1.Location = new System.Drawing.Point(0, 0); |
184 | 194 | this.dataGridView1.MultiSelect = false; |
@@ -197,31 +207,39 @@ namespace UmaTest.App.Presentation.View | ||
197 | 207 | this.dataGridView2.AllowUserToDeleteRows = false; |
198 | 208 | this.dataGridView2.AllowUserToResizeColumns = false; |
199 | 209 | this.dataGridView2.AllowUserToResizeRows = false; |
200 | - dataGridViewCellStyle3.BackColor = System.Drawing.Color.WhiteSmoke; | |
201 | - this.dataGridView2.AlternatingRowsDefaultCellStyle = dataGridViewCellStyle3; | |
210 | + dataGridViewCellStyle4.BackColor = System.Drawing.Color.WhiteSmoke; | |
211 | + this.dataGridView2.AlternatingRowsDefaultCellStyle = dataGridViewCellStyle4; | |
202 | 212 | this.dataGridView2.AutoSizeColumnsMode = System.Windows.Forms.DataGridViewAutoSizeColumnsMode.ColumnHeader; |
203 | - dataGridViewCellStyle4.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; | |
204 | - dataGridViewCellStyle4.BackColor = System.Drawing.SystemColors.Control; | |
205 | - dataGridViewCellStyle4.Font = new System.Drawing.Font("MS ゴシック", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(128))); | |
206 | - dataGridViewCellStyle4.ForeColor = System.Drawing.SystemColors.WindowText; | |
207 | - dataGridViewCellStyle4.SelectionBackColor = System.Drawing.SystemColors.Highlight; | |
208 | - dataGridViewCellStyle4.SelectionForeColor = System.Drawing.SystemColors.HighlightText; | |
209 | - dataGridViewCellStyle4.WrapMode = System.Windows.Forms.DataGridViewTriState.True; | |
210 | - this.dataGridView2.ColumnHeadersDefaultCellStyle = dataGridViewCellStyle4; | |
213 | + dataGridViewCellStyle5.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; | |
214 | + dataGridViewCellStyle5.BackColor = System.Drawing.SystemColors.Control; | |
215 | + dataGridViewCellStyle5.Font = new System.Drawing.Font("MS ゴシック", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(128))); | |
216 | + dataGridViewCellStyle5.ForeColor = System.Drawing.SystemColors.WindowText; | |
217 | + dataGridViewCellStyle5.SelectionBackColor = System.Drawing.SystemColors.Control; | |
218 | + dataGridViewCellStyle5.SelectionForeColor = System.Drawing.SystemColors.WindowText; | |
219 | + dataGridViewCellStyle5.WrapMode = System.Windows.Forms.DataGridViewTriState.True; | |
220 | + this.dataGridView2.ColumnHeadersDefaultCellStyle = dataGridViewCellStyle5; | |
211 | 221 | this.dataGridView2.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize; |
222 | + dataGridViewCellStyle6.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleLeft; | |
223 | + dataGridViewCellStyle6.BackColor = System.Drawing.SystemColors.Window; | |
224 | + dataGridViewCellStyle6.Font = new System.Drawing.Font("Meiryo UI", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0))); | |
225 | + dataGridViewCellStyle6.ForeColor = System.Drawing.SystemColors.ControlText; | |
226 | + dataGridViewCellStyle6.SelectionBackColor = System.Drawing.SystemColors.Highlight; | |
227 | + dataGridViewCellStyle6.SelectionForeColor = System.Drawing.SystemColors.HighlightText; | |
228 | + dataGridViewCellStyle6.WrapMode = System.Windows.Forms.DataGridViewTriState.False; | |
229 | + this.dataGridView2.DefaultCellStyle = dataGridViewCellStyle6; | |
212 | 230 | this.dataGridView2.Dock = System.Windows.Forms.DockStyle.Fill; |
213 | 231 | this.dataGridView2.Location = new System.Drawing.Point(0, 0); |
214 | 232 | this.dataGridView2.MultiSelect = false; |
215 | 233 | this.dataGridView2.Name = "dataGridView2"; |
216 | 234 | this.dataGridView2.ReadOnly = true; |
217 | - dataGridViewCellStyle5.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; | |
218 | - dataGridViewCellStyle5.BackColor = System.Drawing.SystemColors.Control; | |
219 | - dataGridViewCellStyle5.Font = new System.Drawing.Font("MS UI Gothic", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(128))); | |
220 | - dataGridViewCellStyle5.ForeColor = System.Drawing.SystemColors.WindowText; | |
221 | - dataGridViewCellStyle5.SelectionBackColor = System.Drawing.SystemColors.Highlight; | |
222 | - dataGridViewCellStyle5.SelectionForeColor = System.Drawing.SystemColors.HighlightText; | |
223 | - dataGridViewCellStyle5.WrapMode = System.Windows.Forms.DataGridViewTriState.False; | |
224 | - this.dataGridView2.RowHeadersDefaultCellStyle = dataGridViewCellStyle5; | |
235 | + dataGridViewCellStyle7.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; | |
236 | + dataGridViewCellStyle7.BackColor = System.Drawing.SystemColors.Control; | |
237 | + dataGridViewCellStyle7.Font = new System.Drawing.Font("MS UI Gothic", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(128))); | |
238 | + dataGridViewCellStyle7.ForeColor = System.Drawing.SystemColors.WindowText; | |
239 | + dataGridViewCellStyle7.SelectionBackColor = System.Drawing.SystemColors.Highlight; | |
240 | + dataGridViewCellStyle7.SelectionForeColor = System.Drawing.SystemColors.HighlightText; | |
241 | + dataGridViewCellStyle7.WrapMode = System.Windows.Forms.DataGridViewTriState.False; | |
242 | + this.dataGridView2.RowHeadersDefaultCellStyle = dataGridViewCellStyle7; | |
225 | 243 | this.dataGridView2.RowHeadersWidthSizeMode = System.Windows.Forms.DataGridViewRowHeadersWidthSizeMode.DisableResizing; |
226 | 244 | this.dataGridView2.RowTemplate.Height = 21; |
227 | 245 | this.dataGridView2.RowTemplate.ReadOnly = true; |
@@ -481,9 +481,9 @@ namespace UmaTest.App.Presentation.View | ||
481 | 481 | grid1Cols.Do(col => col.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter); |
482 | 482 | dataGridView1.Columns.AddRange(grid1Cols); |
483 | 483 | |
484 | - dataGridView1.Columns["騎手名"].HeaderCell.Style.WrapMode = DataGridViewTriState.False; | |
485 | - dataGridView1.Columns["調教師"].HeaderCell.Style.WrapMode = DataGridViewTriState.False; | |
486 | - dataGridView1.Columns["馬体重"].HeaderCell.Style.WrapMode = DataGridViewTriState.False; | |
484 | + //dataGridView1.Columns["騎手名"].HeaderCell.Style.WrapMode = DataGridViewTriState.False; | |
485 | + //dataGridView1.Columns["調教師"].HeaderCell.Style.WrapMode = DataGridViewTriState.False; | |
486 | + //dataGridView1.Columns["馬体重"].HeaderCell.Style.WrapMode = DataGridViewTriState.False; | |
487 | 487 | //dataGridView1.Columns["オッズ"].HeaderCell.Style.WrapMode = DataGridViewTriState.False; |
488 | 488 | |
489 | 489 | dataGridView1.Columns["枠番"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; |
@@ -516,23 +516,6 @@ namespace UmaTest.App.Presentation.View | ||
516 | 516 | dataGridView1.Columns["前々走平均-3F ペース"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; |
517 | 517 | dataGridView1.Columns["前々走上3F指数"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; |
518 | 518 | |
519 | - Font meiryoUI = new Font("Meiryo UI", 9); | |
520 | - Font msGothic = new Font("MS ゴシック", 9); | |
521 | - | |
522 | - foreach (DataGridViewColumn col in dataGridView1.Columns) | |
523 | - { | |
524 | - if (col.Name == "前走通過順位") | |
525 | - { | |
526 | - col.DefaultCellStyle.Font = msGothic; | |
527 | - } | |
528 | - else | |
529 | - { | |
530 | - col.DefaultCellStyle.Font = meiryoUI; | |
531 | - } | |
532 | - } | |
533 | - | |
534 | - //dataGridView1.Columns["前走通過順位"].DefaultCellStyle.Font = msGothic; | |
535 | - | |
536 | 519 | // |
537 | 520 | // Initialize DataGridView2 |
538 | 521 | // |
@@ -700,9 +683,9 @@ namespace UmaTest.App.Presentation.View | ||
700 | 683 | grid2Cols.Do(col => col.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter); |
701 | 684 | dataGridView2.Columns.AddRange(grid2Cols); |
702 | 685 | |
703 | - dataGridView2.Columns["レース名"].HeaderCell.Style.WrapMode = DataGridViewTriState.False; | |
704 | - dataGridView2.Columns["コース"].HeaderCell.Style.WrapMode = DataGridViewTriState.False; | |
705 | - dataGridView2.Columns["馬体重"].HeaderCell.Style.WrapMode = DataGridViewTriState.False; | |
686 | + //dataGridView2.Columns["レース名"].HeaderCell.Style.WrapMode = DataGridViewTriState.False; | |
687 | + //dataGridView2.Columns["コース"].HeaderCell.Style.WrapMode = DataGridViewTriState.False; | |
688 | + //dataGridView2.Columns["馬体重"].HeaderCell.Style.WrapMode = DataGridViewTriState.False; | |
706 | 689 | |
707 | 690 | dataGridView2.Columns["G"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; |
708 | 691 | dataGridView2.Columns["頭数"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; |
@@ -719,20 +702,6 @@ namespace UmaTest.App.Presentation.View | ||
719 | 702 | dataGridView2.Columns["上3F指数"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; |
720 | 703 | dataGridView2.Columns["Avg. ペース変化"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; |
721 | 704 | |
722 | - foreach (DataGridViewColumn col in dataGridView2.Columns) | |
723 | - { | |
724 | - if (col.Name == "通過順位") | |
725 | - { | |
726 | - col.DefaultCellStyle.Font = msGothic; | |
727 | - } | |
728 | - else | |
729 | - { | |
730 | - col.DefaultCellStyle.Font = meiryoUI; | |
731 | - } | |
732 | - } | |
733 | - | |
734 | - //dataGridView2.Columns["通過順位"].DefaultCellStyle.Font = msGothic; | |
735 | - | |
736 | 705 | // |
737 | 706 | // Custom Type Descriptor for Child Entity Properties |
738 | 707 | // |
@@ -843,6 +812,8 @@ namespace UmaTest.App.Presentation.View | ||
843 | 812 | + 2; |
844 | 813 | splitContainer2.SplitterDistance = (newHeight > 100 ? newHeight : 100) + 2; |
845 | 814 | splitContainer2.FixedPanel = FixedPanel.Panel1; |
815 | + | |
816 | + ColorizeUmaSummaryView(); | |
846 | 817 | } |
847 | 818 | break; |
848 | 819 |
@@ -850,11 +821,273 @@ namespace UmaTest.App.Presentation.View | ||
850 | 821 | { |
851 | 822 | bindingSource2.DataSource = vm.RaceList; |
852 | 823 | DataGridViewHelper.AdjustDataGridView(dataGridView2, bindingSource2, vm.RaceList.Count, splitContainer2.Panel2); |
824 | + | |
825 | + ColorizeUmaRaceListView(); | |
853 | 826 | } |
854 | 827 | break; |
855 | 828 | } |
856 | 829 | } |
857 | 830 | |
831 | + private void ColorizeUmaSummaryView() | |
832 | + { | |
833 | + foreach (DataGridViewRow row in dataGridView1.Rows) | |
834 | + { | |
835 | + DataGridViewCell cellNinki = row.Cells["人気"]; | |
836 | + | |
837 | + ColorizeNinki(cellNinki); | |
838 | + | |
839 | + DataGridViewCell cellKankaku = row.Cells["間隔"]; | |
840 | + | |
841 | + ColorizeKankaku(cellKankaku); | |
842 | + | |
843 | + DataGridViewCell cellZensoKankaku = row.Cells["前走間隔"]; | |
844 | + | |
845 | + ColorizeKankaku(cellZensoKankaku); | |
846 | + | |
847 | + DataGridViewCell cellZensoJyuni = row.Cells["前走着順"]; | |
848 | + DataGridViewCell cellZensoNinki = row.Cells["前走人気"]; | |
849 | + | |
850 | + ColorizeNinki(cellZensoNinki); | |
851 | + ColorizeJyuni(cellZensoJyuni, cellZensoNinki); | |
852 | + | |
853 | + DataGridViewCell cellNisoMaeJyuni = row.Cells["前々走着順"]; | |
854 | + DataGridViewCell cellNisoMaeNinki = row.Cells["前々走人気"]; | |
855 | + | |
856 | + ColorizeNinki(cellNisoMaeNinki); | |
857 | + ColorizeJyuni(cellNisoMaeJyuni, cellNisoMaeNinki); | |
858 | + | |
859 | + DataGridViewCell cellZensoPCI = row.Cells["前走ペース変化指数"]; | |
860 | + | |
861 | + ColorizePCI(cellZensoPCI, cellZensoJyuni); | |
862 | + | |
863 | + DataGridViewCell cellNisoMaePCI = row.Cells["前々走ペース変化指数"]; | |
864 | + | |
865 | + ColorizePCI(cellNisoMaePCI, cellNisoMaeJyuni); | |
866 | + | |
867 | + DataGridViewCell cellZensoAvgHaronTimeMinus3 = row.Cells["前走平均-3F ペース"]; | |
868 | + | |
869 | + ColorizeAvgHaronTimeMinus3(cellZensoAvgHaronTimeMinus3, cellZensoJyuni); | |
870 | + | |
871 | + DataGridViewCell cellNisoMaeAvgHaronTimeMinus3 = row.Cells["前々走平均-3F ペース"]; | |
872 | + | |
873 | + ColorizeAvgHaronTimeMinus3(cellNisoMaeAvgHaronTimeMinus3, cellNisoMaeJyuni); | |
874 | + | |
875 | + DataGridViewCell cellZensoHaronTimeL3 = row.Cells["前走上3F指数"]; | |
876 | + | |
877 | + ColorizeHaronTimeL3(cellZensoHaronTimeL3, cellZensoJyuni); | |
878 | + | |
879 | + DataGridViewCell cellNisoMaeHaronTimeL3 = row.Cells["前々走上3F指数"]; | |
880 | + | |
881 | + ColorizeHaronTimeL3(cellNisoMaeHaronTimeL3, cellNisoMaeJyuni); | |
882 | + } | |
883 | + } | |
884 | + | |
885 | + private static void ChangeCellBackColor(DataGridViewCell cell, Color backColor) | |
886 | + { | |
887 | + cell.Style.BackColor = backColor; | |
888 | + cell.Style.SelectionBackColor = backColor; | |
889 | + cell.Style.SelectionForeColor = SystemColors.WindowText; | |
890 | + } | |
891 | + | |
892 | + private void ColorizeUmaRaceListView() | |
893 | + { | |
894 | + foreach (DataGridViewRow row in dataGridView2.Rows) | |
895 | + { | |
896 | + DataGridViewCell cellNinki = row.Cells["人気"]; | |
897 | + | |
898 | + ColorizeNinki(cellNinki); | |
899 | + | |
900 | + DataGridViewCell cellJyuni = row.Cells["着順"]; | |
901 | + | |
902 | + ColorizeJyuni(cellJyuni, cellNinki); | |
903 | + | |
904 | + DataGridViewCell cellPCI = row.Cells["ペース変化指数"]; | |
905 | + | |
906 | + ColorizePCI(cellPCI, cellJyuni); | |
907 | + | |
908 | + DataGridViewCell cellAvgHaronTimeMinus3 = row.Cells["平均-3F ペース"]; | |
909 | + | |
910 | + ColorizeAvgHaronTimeMinus3(cellAvgHaronTimeMinus3, cellJyuni); | |
911 | + | |
912 | + DataGridViewCell cellHaronTimeL3 = row.Cells["上3F指数"]; | |
913 | + | |
914 | + ColorizeHaronTimeL3(cellHaronTimeL3, cellJyuni); | |
915 | + } | |
916 | + } | |
917 | + | |
918 | + private void ColorizePCI(DataGridViewCell cellPCI, DataGridViewCell cellJyuni) | |
919 | + { | |
920 | + if (int.TryParse(cellJyuni.Value.ToString(), out int jyuni) && (jyuni > 6)) | |
921 | + { | |
922 | + ChangeCellBackColor(cellPCI, Color.Silver); | |
923 | + return; | |
924 | + } | |
925 | + | |
926 | + if (decimal.TryParse(cellPCI.Value.ToString(), out decimal pci)) | |
927 | + { | |
928 | + if (pci >= 115) | |
929 | + { | |
930 | + ChangeCellBackColor(cellPCI, Color.Yellow); | |
931 | + } | |
932 | + else if (pci >= 105) | |
933 | + { | |
934 | + ChangeCellBackColor(cellPCI, Color.Cyan); | |
935 | + } | |
936 | + else if (pci >= 95) | |
937 | + { | |
938 | + ChangeCellBackColor(cellPCI, Color.LightGreen); | |
939 | + } | |
940 | + else if (pci >= 85) | |
941 | + { | |
942 | + ChangeCellBackColor(cellPCI, Color.LightSkyBlue); | |
943 | + } | |
944 | + else if (pci <= 75) | |
945 | + { | |
946 | + ChangeCellBackColor(cellPCI, Color.Orange); | |
947 | + } | |
948 | + } | |
949 | + } | |
950 | + | |
951 | + private void ColorizeAvgHaronTimeMinus3(DataGridViewCell cellAvgHaronTimeMinus3, DataGridViewCell cellJyuni) | |
952 | + { | |
953 | + if (int.TryParse(cellJyuni.Value.ToString(), out int jyuni) && (jyuni > 6)) | |
954 | + { | |
955 | + ChangeCellBackColor(cellAvgHaronTimeMinus3, Color.Silver); | |
956 | + return; | |
957 | + } | |
958 | + | |
959 | + if (decimal.TryParse(cellAvgHaronTimeMinus3.Value.ToString(), out decimal pci)) | |
960 | + { | |
961 | + if (pci >= 125) | |
962 | + { | |
963 | + ChangeCellBackColor(cellAvgHaronTimeMinus3, Color.Orange); | |
964 | + } | |
965 | + else if (pci >= 115) | |
966 | + { | |
967 | + ChangeCellBackColor(cellAvgHaronTimeMinus3, Color.Yellow); | |
968 | + } | |
969 | + else if (pci >= 105) | |
970 | + { | |
971 | + ChangeCellBackColor(cellAvgHaronTimeMinus3, Color.Cyan); | |
972 | + } | |
973 | + else if (pci >= 95) | |
974 | + { | |
975 | + ChangeCellBackColor(cellAvgHaronTimeMinus3, Color.LightGreen); | |
976 | + } | |
977 | + else if (pci >= 85) | |
978 | + { | |
979 | + ChangeCellBackColor(cellAvgHaronTimeMinus3, Color.LightSkyBlue); | |
980 | + } | |
981 | + else if (pci < 85) | |
982 | + { | |
983 | + ChangeCellBackColor(cellAvgHaronTimeMinus3, Color.Orange); | |
984 | + } | |
985 | + } | |
986 | + } | |
987 | + | |
988 | + private void ColorizeHaronTimeL3(DataGridViewCell cellHaronTimeL3, DataGridViewCell cellJyuni) | |
989 | + { | |
990 | + if (int.TryParse(cellJyuni.Value.ToString(), out int jyuni) && (jyuni > 6)) | |
991 | + { | |
992 | + ChangeCellBackColor(cellHaronTimeL3, Color.Silver); | |
993 | + return; | |
994 | + } | |
995 | + | |
996 | + if (decimal.TryParse(cellHaronTimeL3.Value.ToString(), out decimal pci)) | |
997 | + { | |
998 | + if (pci >= 140) | |
999 | + { | |
1000 | + ChangeCellBackColor(cellHaronTimeL3, Color.Yellow); | |
1001 | + } | |
1002 | + else if (pci >= 120) | |
1003 | + { | |
1004 | + ChangeCellBackColor(cellHaronTimeL3, Color.Cyan); | |
1005 | + } | |
1006 | + else if (pci >= 100) | |
1007 | + { | |
1008 | + ChangeCellBackColor(cellHaronTimeL3, Color.LightGreen); | |
1009 | + } | |
1010 | + else if (pci >= 80) | |
1011 | + { | |
1012 | + ChangeCellBackColor(cellHaronTimeL3, Color.LightSkyBlue); | |
1013 | + } | |
1014 | + else if (pci < 80) | |
1015 | + { | |
1016 | + ChangeCellBackColor(cellHaronTimeL3, Color.Orange); | |
1017 | + } | |
1018 | + } | |
1019 | + } | |
1020 | + | |
1021 | + private static void ColorizeKankaku(DataGridViewCell cellKankaku) | |
1022 | + { | |
1023 | + if (int.TryParse(cellKankaku.Value.ToString(), out int kankaku)) | |
1024 | + { | |
1025 | + if (kankaku >= 30) | |
1026 | + { | |
1027 | + ChangeCellBackColor(cellKankaku, Color.Orange); | |
1028 | + } | |
1029 | + else if (kankaku >= 10) | |
1030 | + { | |
1031 | + ChangeCellBackColor(cellKankaku, Color.Yellow); | |
1032 | + } | |
1033 | + } | |
1034 | + } | |
1035 | + | |
1036 | + private static void ColorizeNinki(DataGridViewCell cellNinki) | |
1037 | + { | |
1038 | + if (int.TryParse(cellNinki.Value.ToString(), out int ninki)) | |
1039 | + { | |
1040 | + switch (ninki) | |
1041 | + { | |
1042 | + case 1: | |
1043 | + ChangeCellBackColor(cellNinki, Color.Yellow); | |
1044 | + break; | |
1045 | + case 2: | |
1046 | + ChangeCellBackColor(cellNinki, Color.Cyan); | |
1047 | + break; | |
1048 | + case 3: | |
1049 | + ChangeCellBackColor(cellNinki, Color.LightGreen); | |
1050 | + break; | |
1051 | + default: | |
1052 | + break; | |
1053 | + } | |
1054 | + } | |
1055 | + } | |
1056 | + | |
1057 | + private static void ColorizeJyuni(DataGridViewCell cellJyuni, DataGridViewCell cellNinki) | |
1058 | + { | |
1059 | + if (int.TryParse(cellJyuni.Value.ToString(), out int jyuni) | |
1060 | + && int.TryParse(cellNinki.Value.ToString(), out int ninki)) | |
1061 | + { | |
1062 | + switch (jyuni) | |
1063 | + { | |
1064 | + case 1: | |
1065 | + ChangeCellBackColor(cellJyuni, Color.Yellow); | |
1066 | + break; | |
1067 | + case 2: | |
1068 | + ChangeCellBackColor(cellJyuni, Color.Cyan); | |
1069 | + break; | |
1070 | + case 3: | |
1071 | + ChangeCellBackColor(cellJyuni, Color.LightGreen); | |
1072 | + break; | |
1073 | + default: | |
1074 | + if ((ninki > 6) && (jyuni <= 6)) | |
1075 | + { | |
1076 | + ChangeCellBackColor(cellJyuni, Color.LightSkyBlue); | |
1077 | + } | |
1078 | + else if ((ninki <= 3) && (jyuni > 3)) | |
1079 | + { | |
1080 | + ChangeCellBackColor(cellJyuni, Color.Orange); | |
1081 | + } | |
1082 | + else if (ninki - jyuni < -2) | |
1083 | + { | |
1084 | + ChangeCellBackColor(cellJyuni, Color.Orange); | |
1085 | + } | |
1086 | + break; | |
1087 | + } | |
1088 | + } | |
1089 | + } | |
1090 | + | |
858 | 1091 | private void MainWindow_ResizeBegin(object sender, EventArgs e) |
859 | 1092 | { |
860 | 1093 | if (isFormInitialized) |
@@ -81,5 +81,34 @@ namespace UmaTest.Properties { | ||
81 | 81 | return ResourceManager.GetString("NUmaRaceDao_FindAllChakudosuuSummariesByKyoriAndGradeAsync", resourceCulture); |
82 | 82 | } |
83 | 83 | } |
84 | + | |
85 | + /// <summary> | |
86 | + /// with v_uma_race_base1 as ( | |
87 | + ///select distinct | |
88 | + /// r.jyocd | |
89 | + /// , r.year | |
90 | + /// , r.monthday | |
91 | + /// , r.kyori | |
92 | + /// , r.trackcd | |
93 | + /// , case r.gradecd | |
94 | + /// when '' then case jyokencd5 | |
95 | + /// when '701' then 'N' | |
96 | + /// when '702' then 'N' | |
97 | + /// when '703' then 'M' | |
98 | + /// else case | |
99 | + /// when jyokencd5 = '000' then '-' | |
100 | + /// when jyokencd5 <= '005' then '1' | |
101 | + /// when jyokencd5 <= '010' then '2' | |
102 | + /// when jyokencd5 <= '016' then '3' | |
103 | + /// else 'OP' | |
104 | + /// end | |
105 | + /// end | |
106 | + /// when 'L' th [残りの文字列は切り詰められました]"; に類似しているローカライズされた文字列を検索します。 | |
107 | + /// </summary> | |
108 | + internal static string NUmaRaceDao_FindAllRacesByKettoNumListAsync { | |
109 | + get { | |
110 | + return ResourceManager.GetString("NUmaRaceDao_FindAllRacesByKettoNumListAsync", resourceCulture); | |
111 | + } | |
112 | + } | |
84 | 113 | } |
85 | 114 | } |
@@ -121,4 +121,7 @@ | ||
121 | 121 | <data name="NUmaRaceDao_FindAllChakudosuuSummariesByKyoriAndGradeAsync" type="System.Resources.ResXFileRef, System.Windows.Forms"> |
122 | 122 | <value>..\resources\sql\numaracedao_findallchakudosuusummariesbykyoriandgradeasync.sql;System.String, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089;shift_jis</value> |
123 | 123 | </data> |
124 | + <data name="NUmaRaceDao_FindAllRacesByKettoNumListAsync" type="System.Resources.ResXFileRef, System.Windows.Forms"> | |
125 | + <value>..\resources\sql\numaracedao_findallracesbykettonumlistasync.sql;System.String, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089;shift_jis</value> | |
126 | + </data> | |
124 | 127 | </root> |
\ No newline at end of file |