private void ShowResult(StuGLSearch stuGLSearch)
{
//Img05.Visible = false; Img10.Visible = false; Img25.Visible = false; Img50.Visible = false; Img100.Visible = false; ImgLast.Visible = false;
pnlDetail.Controls.Clear();
stuGLSearch.InDisplayPeriod = stuGLSearch.InDisplayPeriod == 0 ? int.Parse(Properties.Resources.defaultDisplayPeriodValue, InvariantCulture) : stuGLSearch.InDisplayPeriod;
int intLNums = int.Parse(ddlNums.SelectedValue, InvariantCulture);
#region pnlChartActive
Panel pnlChartActive = new GalaxyApp().CreatPanel(string.Format(InvariantCulture, "pnlActive{0:d2}", intLNums), "max-width");
pnlDetail.Controls.Add(pnlChartActive);
#endregion pnlChartActive
#region Chart chActive
Chart chActive = new GalaxyApp().CreatChart(string.Format(InvariantCulture, "chActive{0:d2}", intLNums),
intDisplay * 20,
800);
chActive.Titles.Add(new GalaxyApp().CreatTitle(string.Format(InvariantCulture, "sNum{0:d2}", intLNums),
string.Format(InvariantCulture, "{0:d02} ", intLNums),
Docking.Top, Color.Yellow, Color.Black));
pnlChartActive.Controls.Add(chActive);
#endregion
#region ChartArea chaArea
ChartArea chaArea = new GalaxyApp().CreatChartArea(string.Format(InvariantCulture, "chaArea{0:d2}", intLNums), 0);
chaArea.BackColor = priDicNumcssclass.ContainsKey(intLNums.ToString(InvariantCulture)) ? Color.FromArgb(50, 217, 161, 199) : Color.White;
chaArea.AxisY.Minimum = -1;
chActive.ChartAreas.Add(chaArea);
#endregion
CreatLegent(chActive, chaArea, "series", Docking.Bottom, false, StringAlignment.Center, Color.LightYellow, 1, Color.Orange, 11);
#region Loop
foreach (KeyValuePair <string, object> dicSecEachResult in priDicSecFreqActive)
{
priDicFreqActive = (Dictionary <string, DataTable>)dicSecEachResult.Value;
stuGLSearch.InSearchLimit = dicSecEachResult.Key == "m" ? 0 : int.Parse(dicSecEachResult.Key, InvariantCulture);
#region lstFirstNums,lstSeachLimitNums
List <int> lstFirstNums = new GalaxyApp().GetLstNumbers(stuGLSearch, priDicFreqActive["gen"], 2);
List <int> lstSeachLimitNums = new GalaxyApp().GetLstNumbers(stuGLSearch, priDicFreqActive["gen"], stuGLSearch.InSearchLimit + 1);
switch (dicSecEachResult.Key)
{
case "5":
ph05.Visible = lstSeachLimitNums.Contains(intLNums);
phLast.Visible = lstFirstNums.Contains(intLNums);
break;
case "10":
ph10.Visible = lstSeachLimitNums.Contains(intLNums);
phLast.Visible = lstFirstNums.Contains(intLNums);
break;
case "25":
ph25.Visible = lstSeachLimitNums.Contains(intLNums);
phLast.Visible = lstFirstNums.Contains(intLNums);
break;
case "50":
ph50.Visible = lstSeachLimitNums.Contains(intLNums);
phLast.Visible = lstFirstNums.Contains(intLNums);
break;
case "100":
ph100.Visible = lstSeachLimitNums.Contains(intLNums);
phLast.Visible = lstFirstNums.Contains(intLNums);
break;
}
#endregion lstFirstNums,lstSeachLimitNums
string lngF = dicSecEachResult.Key == "m" ? "lngM" : "lngN";
using DataTable dtFreqResult = priDicFreqActive["gen"].Select(string.Empty, "[lngTotalSN] ASC").Take(priDicFreqActive["gen"].Rows.Count - 1).CopyToDataTable();
double dblSumT = double.Parse(dtFreqResult.Compute(string.Format(InvariantCulture, "SUM([{0}{1}])", lngF, intLNums), string.Empty).ToString(), InvariantCulture);
double dblAvgT = Math.Round(dblSumT / (double)dtFreqResult.Rows.Count, 2);
int intMaxT = int.Parse(dtFreqResult.Compute(string.Format(InvariantCulture, "MAX([{0}{1}])", lngF, intLNums), string.Empty).ToString(), InvariantCulture);
int intMinT = int.Parse(dtFreqResult.Compute(string.Format(InvariantCulture, "MIN([{0}{1}])", lngF, intLNums), string.Empty).ToString(), InvariantCulture);
//dtFreqResult.Columns.Remove("lngTotalSN");
#region Max,Min,Avg
int intCurrent = int.Parse(dtFreqResult.Rows[0][string.Format(InvariantCulture, "{0}{1}", lngF, intLNums)].ToString(), InvariantCulture);
using (DataTable dataTable = stuGLSearch.InSearchLimit > 0 ? dtFreqResult.Rows.Cast <DataRow>().Take(stuGLSearch.InDisplayPeriod).CopyToDataTable() : dtFreqResult)
{
double dblSumS = double.Parse(dataTable.Compute(string.Format(InvariantCulture, "SUM([{0}{1}])", lngF, intLNums), string.Empty).ToString(), InvariantCulture);
double dblAvgS = Math.Round(dblSumS / (double)stuGLSearch.InSearchLimit, 2);
int intMaxS = int.Parse(dataTable.Compute(string.Format(InvariantCulture, "MAX([{0}{1}])", lngF, intLNums), string.Empty).ToString(), InvariantCulture);
int intMinS = int.Parse(dataTable.Compute(string.Format(InvariantCulture, "MIN([{0}{1}])", lngF, intLNums), string.Empty).ToString(), InvariantCulture);
}
#endregion Max,Min,Avg
using DataTable dtCurve = priDicFreqActive["gen"].Select("", "lngTotalSN DESC").Take <DataRow>(intDisplay).CopyToDataTable();
dtCurve.DefaultView.Sort = "[lngDateSN] ASC";
bool display = true;
display = dicSecEachResult.Key switch
{
"5" => chk05.Checked,
"10" => chk10.Checked,
"25" => chk25.Checked,
"50" => chk50.Checked,
"100" => chk100.Checked,
"m" => chkm.Checked,
_ => true,
};
if (display)
{
#region Series
Series sirNum = new GalaxyApp().CreatSeries(string.Format(InvariantCulture, "sirNum{0}{1:d2}", dicSecEachResult.Key, intLNums), chaArea.Name);
sirNum.IsValueShownAsLabel = true;
sirNum.ChartType = SeriesChartType.Line;
sirNum.Color = PriDicSectionColor[dicSecEachResult.Key];
sirNum.LegendText = string.Format(InvariantCulture, " {0}區, 大:[{1}], 小[{2}], 號[{3}] ", dicSecEachResult.Key, intMaxT, intMinT, string.Join(",", lstSeachLimitNums));
sirNum.Legend = "series";
sirNum.Points.DataBind(dtCurve.DefaultView, "", string.Format(InvariantCulture, "{0}{1}", lngF, intLNums), string.Format(InvariantCulture, "Tooltip = {0}{1}", lngF, intLNums));
chActive.Series.Add(sirNum);
#endregion Series
#region LineAnnotation
HorizontalLineAnnotation hlaMax = new GalaxyApp().CreatHorizontalLineAnnotation(string.Format(InvariantCulture, "sirhlaMax{0}{1:d2}", dicSecEachResult.Key, intLNums), chaArea);
hlaMax.LineColor = PriDicSectionColor[dicSecEachResult.Key];
hlaMax.ToolTip = intMaxT.ToString(InvariantCulture);
hlaMax.AnchorY = intMaxT;
hlaMax.LineDashStyle = ChartDashStyle.Dot;
chActive.Annotations.Add(hlaMax);
HorizontalLineAnnotation hlaMin = new GalaxyApp().CreatHorizontalLineAnnotation(string.Format(InvariantCulture, "sirhlaMin{0}{1:d2}", dicSecEachResult.Key, intLNums), chaArea);
hlaMin.LineColor = PriDicSectionColor[dicSecEachResult.Key];
hlaMin.ToolTip = intMinT.ToString(InvariantCulture);
hlaMin.AnchorY = intMinT;
hlaMin.LineDashStyle = ChartDashStyle.Dot;
chActive.Annotations.Add(hlaMin);
VerticalLineAnnotation vlaSearchLimit = new GalaxyApp().CreatVerticalLineAnnotation(string.Format(InvariantCulture, "sirSL{0}{1:d2}", dicSecEachResult.Key, intLNums), chaArea);
vlaSearchLimit.LineColor = PriDicSectionColor[dicSecEachResult.Key];
hlaMin.LineDashStyle = ChartDashStyle.Dash;
vlaSearchLimit.ToolTip = vlaSearchLimit.AnchorX.ToString(InvariantCulture);
vlaSearchLimit.AnchorX = (dtCurve.Rows.Count - stuGLSearch.InSearchLimit + 1) > 0 ? dtCurve.Rows.Count - stuGLSearch.InSearchLimit + 1 : 0;
chActive.Annotations.Add(vlaSearchLimit);
#endregion
}
}
#endregion Loop
}
