640 lines
38 KiB
Plaintext
640 lines
38 KiB
Plaintext
@page "/tra"
|
|
@rendermode InteractiveServer
|
|
|
|
@using System.Collections.Concurrent
|
|
@using System.Collections.Specialized
|
|
@using System.Collections
|
|
@using ClosedXML.Excel
|
|
@using Web.Tra.Services
|
|
@inject CPXV2LogService CPXV2LogService
|
|
@inject PopupService PopupService
|
|
@inject NavigationManager Navigation
|
|
@inject IJSRuntime JS
|
|
|
|
<RadzenStack Style="width:100%; background-color:var(--rz-primary-lighter);" class="rz-border-bottom rz-p-3" Orientation="Orientation.Horizontal" AlignItems="AlignItems.Start" JustifyContent="JustifyContent.Start">
|
|
<!--Search Block-->
|
|
<RadzenStack Style="height:10rem; width:fit-content;" class="rz-border-right rz-pr-5" Orientation="Orientation.Horizontal" AlignItems="AlignItems.Start" JustifyContent="JustifyContent.Start">
|
|
<!--Date Picker Block-->
|
|
<RadzenStack Style="font-size:1.5rem;" Orientation="Orientation.Vertical" AlignItems="AlignItems.Start" JustifyContent="JustifyContent.Center">
|
|
<RadzenStack Style="width: 25rem; margin-bottom:0.3rem;" Orientation="Orientation.Horizontal" JustifyContent="JustifyContent.SpaceBetween">
|
|
<RadzenLabel Text="Begin"></RadzenLabel>
|
|
<RadzenDatePicker @bind-Value=@RequestSearch.SearchStart TValue="DateOnly"></RadzenDatePicker>
|
|
</RadzenStack>
|
|
<RadzenStack Style="width:25rem; margin-bottom: 0.3rem;" Orientation="Orientation.Horizontal" JustifyContent="JustifyContent.SpaceBetween">
|
|
<RadzenLabel Text="End"></RadzenLabel>
|
|
<RadzenDatePicker Style="font-size: 1.5rem !important;" @bind-Value=@RequestSearch.SearchEnd TValue="DateOnly"></RadzenDatePicker>
|
|
</RadzenStack>
|
|
</RadzenStack>
|
|
|
|
<RadzenStack Style="cursor: pointer;" class="" Orientation="Orientation.Vertical" AlignItems="AlignItems.Center" JustifyContent="JustifyContent.Start" @onclick="@OnSearch">
|
|
<RadzenIcon Style="font-size: 3.5rem; font-weight:400; color:var(--rz-warning)" Icon="search"></RadzenIcon>
|
|
<RadzenLabel Style="font-size: 1.5rem; cursor:pointer; color:var(--rz-warning)" Text="Search"></RadzenLabel>
|
|
</RadzenStack>
|
|
</RadzenStack>
|
|
|
|
<!--Selected Data Block-->
|
|
<RadzenStack Style="height:10rem; width:fit-content;" class="rz-border-right rz-pr-5" Orientation="Orientation.Horizontal" AlignItems="AlignItems.Start" JustifyContent="JustifyContent.Start">
|
|
<!--left-->
|
|
<RadzenStack Style="font-size:1.5rem;" Orientation="Orientation.Vertical" AlignItems="AlignItems.Start" JustifyContent="JustifyContent.Center">
|
|
<RadzenStack Style="width: 29rem;" Orientation="Orientation.Horizontal" JustifyContent="JustifyContent.SpaceBetween">
|
|
<RadzenLabel Text="Station Name"></RadzenLabel>
|
|
<RadzenTextBox @bind-Value=@SelectionStationName></RadzenTextBox>
|
|
</RadzenStack>
|
|
<RadzenStack Style="width: 29rem;" Orientation="Orientation.Horizontal" JustifyContent="JustifyContent.SpaceBetween">
|
|
<RadzenLabel Text="Product No"></RadzenLabel>
|
|
<RadzenTextBox @bind-Value=@SelectionProductNO></RadzenTextBox>
|
|
</RadzenStack>
|
|
<RadzenStack Style="width: 29rem;" Orientation="Orientation.Horizontal" JustifyContent="JustifyContent.SpaceBetween">
|
|
<RadzenLabel Text="Parent Info"></RadzenLabel>
|
|
<RadzenTextBox @bind-Value=@SelectionParentInfo></RadzenTextBox>
|
|
</RadzenStack>
|
|
</RadzenStack>
|
|
<!--right-->
|
|
<RadzenStack Style="font-size:1.5rem;" Orientation="Orientation.Vertical" AlignItems="AlignItems.Start" JustifyContent="JustifyContent.Center">
|
|
<RadzenStack Style="width: 29rem;" Orientation="Orientation.Horizontal" JustifyContent="JustifyContent.SpaceBetween">
|
|
<RadzenLabel Text="Search Begin"></RadzenLabel>
|
|
<RadzenTextBox @bind-Value=@SelectionSearchBegin></RadzenTextBox>
|
|
</RadzenStack>
|
|
<RadzenStack Style="width: 29rem;" Orientation="Orientation.Horizontal" JustifyContent="JustifyContent.SpaceBetween">
|
|
<RadzenLabel Text="Search End"></RadzenLabel>
|
|
<RadzenTextBox @bind-Value=@SelectionSearchEnd></RadzenTextBox>
|
|
</RadzenStack>
|
|
<RadzenStack Style="width: 29rem;" Orientation="Orientation.Horizontal" JustifyContent="JustifyContent.SpaceBetween">
|
|
<RadzenLabel Text="Step Version"></RadzenLabel>
|
|
<RadzenTextBox @bind-Value=@SelectionStepVersion></RadzenTextBox>
|
|
</RadzenStack>
|
|
</RadzenStack>
|
|
</RadzenStack>
|
|
|
|
<!--Function Block-->
|
|
<RadzenStack Style="height:10rem; width:fit-content;" class="rz-border-right rz-pr-5" Orientation="Orientation.Horizontal" AlignItems="AlignItems.Start" JustifyContent="JustifyContent.Start">
|
|
<RadzenStack Style="font-size:1.5rem;" Orientation="Orientation.Vertical" AlignItems="AlignItems.Start" JustifyContent="JustifyContent.Center">
|
|
<RadzenStack Style="cursor: pointer;" class="" Orientation="Orientation.Vertical" AlignItems="AlignItems.Center" JustifyContent="JustifyContent.Start" @onclick="@(() => OnSummary())">
|
|
<RadzenIcon Style="font-size: 3.5rem; font-weight:400; color:var(--rz-info)" Icon="ssid_chart"></RadzenIcon>
|
|
<RadzenLabel Style="font-size: 1.5rem; cursor:pointer; color:var(--rz-info)" Text="Summary"></RadzenLabel>
|
|
</RadzenStack>
|
|
</RadzenStack>
|
|
<RadzenStack Style="font-size:1.5rem;" Orientation="Orientation.Vertical" AlignItems="AlignItems.Start" JustifyContent="JustifyContent.Center">
|
|
<RadzenStack Style="cursor: pointer;" class="" Orientation="Orientation.Vertical" AlignItems="AlignItems.Center" JustifyContent="JustifyContent.Start" @onclick="@OnExportExcel">
|
|
<RadzenIcon Style="font-size: 3.5rem; font-weight:400; color:var(--rz-success)" Icon="file_export"></RadzenIcon>
|
|
<RadzenLabel Style="font-size: 1.5rem; cursor:pointer; color:var(--rz-success)" Text="Export Excel"></RadzenLabel>
|
|
</RadzenStack>
|
|
</RadzenStack>
|
|
</RadzenStack>
|
|
|
|
<!--Option Block-->
|
|
<RadzenStack Style="height:10rem; width:fit-content;" class="rz-border-right rz-pr-5" Orientation="Orientation.Horizontal" AlignItems="AlignItems.Start" JustifyContent="JustifyContent.Start">
|
|
<RadzenStack Style="font-size:1.5rem;" Orientation="Orientation.Vertical" AlignItems="AlignItems.Start" JustifyContent="JustifyContent.Center">
|
|
<RadzenStack Style="width: 18rem;" Orientation="Orientation.Horizontal" AlignItems="AlignItems.Center" JustifyContent="JustifyContent.SpaceBetween">
|
|
<RadzenLabel Text="Merge By PartNumber"></RadzenLabel>
|
|
<RadzenSwitch @bind-Value=@IsMergePartNumberOption Change="@OnChangeMergePartNumberOption"></RadzenSwitch>
|
|
</RadzenStack>
|
|
</RadzenStack>
|
|
</RadzenStack>
|
|
</RadzenStack>
|
|
|
|
<!--Data Grid-->
|
|
<RadzenTabs @ref="@tabs" Style="width:100%;" RenderMode="TabRenderMode.Client" @bind-SelectedIndex=@SelectedTabIndex>
|
|
<Tabs>
|
|
@foreach (var tab in Tabs.OrderBy(x=>x.Key.Id))
|
|
{
|
|
<RadzenTabsItem Text="@tab.Key.TabName">
|
|
<Template>
|
|
<span style="margin-right: 1rem; font-size: 1.5rem;">@context.Text</span>
|
|
<RadzenButton Size="ButtonSize.Small" Icon="close" Click="@(()=>OnClickClose(tab.Key.Id))"></RadzenButton>
|
|
</Template>
|
|
|
|
<ChildContent>
|
|
<RadzenStack Orientation="Orientation.Vertical">
|
|
<RadzenStack Style="height: 5.6rem; font-size: 1.5rem;">
|
|
<TitleCard HeaderText="Summary" ContentsHeight="2.9rem;">
|
|
<RadzenStack Style="height:100%;" Orientation="Orientation.Horizontal" AlignItems="AlignItems.Center" JustifyContent="JustifyContent.Center">
|
|
<RadzenLabel class="rz-ml-10" Text="@tab.Key.SummaryTestResult"></RadzenLabel>
|
|
<RadzenLabel class="rz-ml-10" Text="@tab.Key.SummaryTestTime"></RadzenLabel>
|
|
</RadzenStack>
|
|
</TitleCard>
|
|
</RadzenStack>
|
|
|
|
<RadzenStack Style="height:calc(100vh - 29rem);">
|
|
@if (tab.Key.EnumTab == EnumTabs.OverviewC1 || tab.Key.EnumTab == EnumTabs.OverviewC1Merged)
|
|
{
|
|
<TraGrid TDataModel="Overview" DataList="@(tab.Value.Cast<Overview>())" EnumTab="@tab.Key.EnumTab"
|
|
OnSelectRow="@OnSelectRowOverview" OnDoubleClickRow="@OnDoubleClickRowOverview" HostColumnMerge>
|
|
</TraGrid>
|
|
}
|
|
|
|
@if (tab.Key.EnumTab == EnumTabs.OverviewC1Detail || tab.Key.EnumTab == EnumTabs.OverviewC1DetailMerged)
|
|
{
|
|
<TraGrid TDataModel="Overview" DataList="@(tab.Value.Cast<Overview>())" EnumTab="@tab.Key.EnumTab" ParentTabId="@tab.Key.Id"
|
|
OnSelectRow="@OnSelectRowOverview" OnDoubleClickRow="@OnDoubleClickRowDetailOverview" HostColumnMerge>
|
|
</TraGrid>
|
|
}
|
|
|
|
@if (tab.Key.EnumTab == EnumTabs.TestHistoryC1)
|
|
{
|
|
<TraGrid TDataModel="TestHistory" DataList="@(tab.Value.Cast<TestHistory>())" EnumTab="@tab.Key.EnumTab" ParentTabId="@tab.Key.Id"
|
|
OnSelectRow="@OnSelectRowOverview" OnDoubleClickRow="@OnDoubleClickRowHistory" VisibleRowNo HostColumnMerge="false">
|
|
</TraGrid>
|
|
}
|
|
|
|
@if (tab.Key.EnumTab == EnumTabs.TestResultC1)
|
|
{
|
|
<RadzenStack Style="height:inherit;" Orientation="Orientation.Horizontal">
|
|
<!--Test Info-->
|
|
<RadzenStack Style="width:35rem; font-size: 1.5rem; height: inherit;">
|
|
@{
|
|
var history = tab.Key.Parent.Parent as TestHistory;
|
|
if(history.TestResult.ToLower().Contains("ok") == true)
|
|
{
|
|
<RadzenLabel Style="width:inherit; height: 5rem; min-height:5rem; background:var(--rz-success); border: solid 2px var(--rz-grid-hover-color); overflow:auto;" class="rz-shadow-1"/>
|
|
}
|
|
else
|
|
{
|
|
<RadzenLabel Style="width:inherit; height: 5rem; min-height:5rem; background:var(--rz-danger); border: solid 2px var(--rz-grid-hover-color); overflow:auto;" class="rz-shadow-1" />
|
|
}
|
|
|
|
<TitleCard HeaderText="Test Information" ContentsHeight="calc(100% - 5rem);" CardStyle="overflow:auto;">
|
|
<RadzenStack Style="padding:1rem; color: var(--rz-grid-hover-color); overflow-y:auto; align-items:flex-start;">
|
|
@foreach (var prop in history.GetType().GetProperties())
|
|
{
|
|
<RadzenStack Style="width:100%; background-color:transparent;" class="rz-border-bottom rz-p-1 rz-pb-2" Orientation="Orientation.Horizontal">
|
|
<span style="width:12rem; min-width:12rem; font-size: 1.3rem;">@prop.Name</span>
|
|
<BlockLabel Text="@prop.GetValue(history).ToString()" MaxWidth="20rem"></BlockLabel>
|
|
</RadzenStack>
|
|
}
|
|
</RadzenStack>
|
|
</TitleCard>
|
|
|
|
<!--display TestList-->
|
|
<RadzenButton ButtonStyle="ButtonStyle.Warning" Text="Display TestList" Click="@(() => OnClickDisplayTestList(history))"></RadzenButton>
|
|
}
|
|
</RadzenStack>
|
|
|
|
<!--TestResult-->
|
|
<RadzenStack Style="height:inherit;">
|
|
@if(tab.Value?.Count > 0)
|
|
{
|
|
<TraGrid TDataModel="ParseTestResult" DataList="@(tab.Value.Cast<ParseTestResult>())"
|
|
HostColumnMerge="false" EnumTab="@tab.Key.EnumTab" ParentTabId="@tab.Key.Id">
|
|
</TraGrid>
|
|
}
|
|
</RadzenStack>
|
|
</RadzenStack>
|
|
}
|
|
|
|
@if (tab.Key.EnumTab == EnumTabs.TestSummaryC1)
|
|
{
|
|
<RadzenStack Style="height:inherit;" Orientation="Orientation.Horizontal">
|
|
<!--Test Info-->
|
|
<RadzenStack Style="width:35rem; font-size: 1.5rem; height: inherit;">
|
|
@{
|
|
var history = tab.Key.Parent.Parent as TestSummaryInformation;
|
|
<TitleCard HeaderText="Test Information" ContentsHeight="calc(100% - 5rem);" CardStyle="overflow:auto;">
|
|
<RadzenStack Style="padding:1rem; color: var(--rz-grid-hover-color); overflow-y:auto; align-items:flex-start;">
|
|
@foreach (var prop in history.GetType().GetProperties())
|
|
{
|
|
<RadzenStack Style="width:100%; background-color:transparent;" class="rz-border-bottom rz-p-1 rz-pb-2" Orientation="Orientation.Horizontal">
|
|
<span style="width:12rem; min-width:12rem; font-size: 1.3rem;">@prop.Name</span>
|
|
<BlockLabel Text="@prop.GetValue(history).ToString()" MaxWidth="20rem"></BlockLabel>
|
|
</RadzenStack>
|
|
}
|
|
</RadzenStack>
|
|
</TitleCard>
|
|
}
|
|
</RadzenStack>
|
|
|
|
<!--TestResult-->
|
|
<RadzenStack Style="height:inherit;">
|
|
@if (tab.Value?.Count > 0)
|
|
{
|
|
<TraGrid TDataModel="ParseTestSummary" DataList="@(tab.Value.Cast<ParseTestSummary>())" ParentTabId="@tab.Key.Parent.TabID"
|
|
HostColumnMerge="false" EnumTab="@tab.Key.EnumTab" OnDoubleClickRow="@OnDoubleClickRowSummary">
|
|
</TraGrid>
|
|
}
|
|
</RadzenStack>
|
|
</RadzenStack>
|
|
}
|
|
|
|
@if (tab.Key.EnumTab == EnumTabs.TestTrendC1)
|
|
{
|
|
<!--Test Info-->
|
|
<RadzenStack Orientation="Orientation.Horizontal">
|
|
<RadzenStack Style="width:35rem; font-size: 1.5rem; height: inherit; overflow:auto;">
|
|
@{
|
|
var trend = tab.Key.Parent.Parent as TestTrend;
|
|
<TitleCard HeaderText="Test Step Info." ContentsHeight="27rem" CardStyle="">
|
|
<RadzenStack Style="padding:1rem; color: var(--rz-grid-hover-color); overflow-y:auto; align-items:flex-start;">
|
|
@foreach (var prop in trend.TestStepInfo.GetType().GetProperties())
|
|
{
|
|
if (prop.Name.ToLower().Contains("min") || prop.Name.ToLower().Contains("max") || prop.Name.ToLower().Contains("average"))
|
|
continue;
|
|
|
|
<RadzenStack Style="width:100%; background-color:transparent;" class="rz-border-bottom rz-p-1 rz-pb-2" Orientation="Orientation.Horizontal">
|
|
<span style="width:12rem; min-width:12rem; font-size: 1.3rem;">@prop.Name</span>
|
|
<BlockLabel Text="@prop.GetValue(trend.TestStepInfo).ToString()" MaxWidth="20rem"></BlockLabel>
|
|
</RadzenStack>
|
|
}
|
|
</RadzenStack>
|
|
</TitleCard>
|
|
|
|
<TitleCard HeaderText="Test Data Info." ContentsHeight="27rem" CardStyle="">
|
|
<RadzenStack Style="padding:1rem; color: var(--rz-grid-hover-color); overflow-y:auto; align-items:flex-start;">
|
|
@foreach (var prop in trend.TestDataInfo.GetType().GetProperties())
|
|
{
|
|
if (prop.Name.ToLower().Contains("min") || prop.Name.ToLower().Contains("max") || prop.Name.ToLower().Contains("average"))
|
|
continue;
|
|
|
|
<RadzenStack Style="width:100%; background-color:transparent;" class="rz-border-bottom rz-p-1 rz-pb-2" Orientation="Orientation.Horizontal">
|
|
<span style="width:12rem; min-width:12rem; font-size: 1.3rem;">@prop.Name</span>
|
|
<BlockLabel Text="@prop.GetValue(trend.TestDataInfo).ToString()" MaxWidth="20rem"></BlockLabel>
|
|
</RadzenStack>
|
|
}
|
|
</RadzenStack>
|
|
</TitleCard>
|
|
|
|
<TitleCard HeaderText="Measured Data Analysis" ContentsHeight="27rem" CardStyle="">
|
|
<RadzenStack Style="padding:1rem; color: var(--rz-grid-hover-color); overflow-y:auto; align-items:flex-start;">
|
|
@foreach (var prop in trend.MesuredDataAnalysis.GetType().GetProperties())
|
|
{
|
|
<RadzenStack Style="width:100%; background-color:transparent;" class="rz-border-bottom rz-p-1 rz-pb-2" Orientation="Orientation.Horizontal">
|
|
<span style="width:12rem; min-width:12rem; font-size: 1.3rem;">@prop.Name</span>
|
|
<BlockLabel Text="@prop.GetValue(trend.MesuredDataAnalysis).ToString()" MaxWidth="20rem"></BlockLabel>
|
|
</RadzenStack>
|
|
}
|
|
</RadzenStack>
|
|
</TitleCard>
|
|
}
|
|
</RadzenStack>
|
|
<RadzenStack Style="width:calc(100vw - 40rem); height:inherit;" Orientation="Orientation.Horizontal">
|
|
<!--TestResult-->
|
|
@if (tab.Value?.Count > 0)
|
|
{
|
|
<RadzenStack Style="width:170rem; height:calc(100vh - 29rem);">
|
|
<TraGrid TDataModel="ParseTestTrend" DataList="@(tab.Value.Cast<ParseTestTrend>().Where(x=>x.Result.ToLower().Contains("ok")))" ParentTabId="@tab.Key.Parent.TabID"
|
|
HostColumnMerge="false" EnumTab="@tab.Key.EnumTab">
|
|
</TraGrid>
|
|
</RadzenStack>
|
|
<RadzenStack Style="width:100%; height:inherit;">
|
|
<RadzenChart Style="height:100%;" ColorScheme="ColorScheme.Divergent">
|
|
<RadzenLineSeries Data="@(tab.Value.Cast<ParseTestTrend>().Where(x=>x.Result.ToLower().Contains("ok")).Select(x => new TrendPoint { Category = Convert.ToInt32(x.RowNo), Value = Convert.ToDouble(x.Value) }))"
|
|
TItem="TrendPoint" LineType="LineType.Solid" ValueProperty="Value" CategoryProperty="Category" Title="Value" Stroke="rgba(255,0,0)">
|
|
</RadzenLineSeries>
|
|
<RadzenLineSeries Data="@(tab.Value.Cast<ParseTestTrend>().Where(x => x.Result.ToLower().Contains("ok")).Select(x => new TrendPoint { Category = Convert.ToInt32(x.RowNo), Value = Convert.ToDouble(x.Min) }))"
|
|
TItem="TrendPoint" LineType="LineType.Dashed" ValueProperty="Value" CategoryProperty="Category" Title="MIN" Stroke="#2196f3" >
|
|
</RadzenLineSeries>
|
|
<RadzenLineSeries Data="@(tab.Value.Cast<ParseTestTrend>().Where(x => x.Result.ToLower().Contains("ok")).Select(x => new TrendPoint { Category = Convert.ToInt32(x.RowNo), Value = Convert.ToDouble(x.Max) }))"
|
|
TItem="TrendPoint" LineType="LineType.Dashed" ValueProperty="Value" CategoryProperty="Category" Title="MAX" Stroke="#2196f3">
|
|
</RadzenLineSeries>
|
|
|
|
<RadzenValueAxis Min="3" Max="11">
|
|
<RadzenGridLines Visible="true" />
|
|
</RadzenValueAxis>
|
|
<RadzenCategoryAxis Step="5">
|
|
</RadzenCategoryAxis>
|
|
</RadzenChart>
|
|
</RadzenStack>
|
|
}
|
|
</RadzenStack>
|
|
</RadzenStack>
|
|
}
|
|
</RadzenStack>
|
|
</RadzenStack>
|
|
</ChildContent>
|
|
</RadzenTabsItem>
|
|
}
|
|
</Tabs>
|
|
</RadzenTabs>
|
|
|
|
@code {
|
|
private RequestSearch RequestSearch = new RequestSearch();
|
|
|
|
//selection
|
|
private string SelectionStationName = string.Empty;
|
|
private string SelectionProductNO = string.Empty;
|
|
private string SelectionParentInfo = string.Empty;
|
|
private string SelectionSearchBegin = string.Empty;
|
|
private string SelectionSearchEnd = string.Empty;
|
|
private string SelectionStepVersion = string.Empty;
|
|
|
|
//options
|
|
private bool IsMergePartNumberOption = false;
|
|
private int PageSize = 30;
|
|
|
|
//tab
|
|
RadzenTabs tabs;
|
|
int SelectedTabIndex = 0;
|
|
ConcurrentDictionary<OrderdTab, List<IDataModel>> Tabs = new ConcurrentDictionary<OrderdTab, List<IDataModel>>();
|
|
|
|
//search data
|
|
List<SearchData> SearchDataOverviews = new List<SearchData>();
|
|
|
|
private async Task OnSearch()
|
|
{
|
|
//날짜 오류
|
|
if(RequestSearch.SearchStart > RequestSearch.SearchEnd)
|
|
{
|
|
LogXnet.WriteLine("DateTime Set Error", LogXLabel.Error);
|
|
return;
|
|
}
|
|
|
|
PopupService.OpenIndicator("Search Data");
|
|
|
|
SearchDataOverviews = await CPXV2LogService.GetSearchDataOverview(RequestSearch);
|
|
await GetOverviews();
|
|
|
|
PopupService.CloseIndicator();
|
|
}
|
|
|
|
private async Task GetOverviews()
|
|
{
|
|
List<Overview> overviews = new();
|
|
|
|
int tabId = 0;
|
|
if (Tabs.Count > 0)
|
|
{
|
|
tabId = Tabs.Max(x => x.Key.Id) + 1;
|
|
}
|
|
|
|
if (IsMergePartNumberOption == false)
|
|
{
|
|
overviews = await CPXV2LogService.GetOverviews(SearchDataOverviews);
|
|
Tabs.AddOrUpdate(
|
|
new OrderdTab { Id = tabId, TabName = $"{EnumTabs.OverviewC1} ({tabId})", EnumTab = EnumTabs.OverviewC1, Parent = null },
|
|
key => overviews.Cast<IDataModel>().ToList(), (key, oldValue) => overviews.Cast<IDataModel>().ToList());
|
|
}
|
|
else
|
|
{
|
|
overviews = await CPXV2LogService.GetOverviewMerged(SearchDataOverviews);
|
|
Tabs.AddOrUpdate(
|
|
new OrderdTab { Id = tabId, TabName = $"{EnumTabs.OverviewC1} ({tabId})", EnumTab = EnumTabs.OverviewC1Merged, Parent = null },
|
|
key => overviews.Cast<IDataModel>().ToList(), (key, oldValue) => overviews.Cast<IDataModel>().ToList());
|
|
}
|
|
|
|
SelectedTabIndex = Tabs.Count - 1;
|
|
}
|
|
|
|
private void OnSelectRowOverview(IDataModel overview)
|
|
{
|
|
var selectOverview = overview as Overview;
|
|
if(selectOverview is not null)
|
|
{
|
|
SelectionStationName = $"{selectOverview.StationName} ({selectOverview.Host},{selectOverview.Section})";
|
|
SelectionProductNO = $"{selectOverview.ProductNo} ({selectOverview.TestCode})";
|
|
SelectionParentInfo = $"{selectOverview.ParentNo} ({selectOverview.FileVersion},{selectOverview.FileCode})";
|
|
|
|
SelectionSearchBegin = $"{selectOverview.TestDate?.ToString("yyyy-MM-dd")} {selectOverview.FirstTestTime}";
|
|
SelectionSearchEnd = $"{selectOverview.TestDate?.ToString("yyyy-MM-dd")} {selectOverview.FinalTestTime}";
|
|
SelectionStepVersion = $"{selectOverview.StepVersion}";
|
|
}
|
|
}
|
|
|
|
private async Task OnDoubleClickRowOverview(SelectRow row)
|
|
{
|
|
var selectRow = row.Row as Overview;
|
|
if(selectRow is not null)
|
|
{
|
|
List<Overview> detailOverviews = new();
|
|
|
|
if (IsMergePartNumberOption == false)
|
|
{
|
|
detailOverviews = await CPXV2LogService.GetDetailOverview(SearchDataOverviews, selectRow);
|
|
|
|
int tabId = Tabs.Max(x => x.Key.Id) + 1;
|
|
Tabs.AddOrUpdate(
|
|
new OrderdTab { Id = tabId, TabName = $"{EnumTabs.OverviewC1Detail} ({tabId})", EnumTab = EnumTabs.OverviewC1Detail, Parent = new ParentRow { TabID = row.ParentTabID, Parent = row.Row } },
|
|
key => detailOverviews.Cast<IDataModel>().ToList(), (key, oldValue) => detailOverviews.Cast<IDataModel>().ToList());
|
|
}
|
|
else
|
|
{
|
|
detailOverviews = await CPXV2LogService.GetDetailOverviewMerged(SearchDataOverviews, selectRow);
|
|
|
|
int tabId = Tabs.Max(x => x.Key.Id) + 1;
|
|
Tabs.AddOrUpdate(
|
|
new OrderdTab { Id = tabId, TabName = $"{EnumTabs.OverviewC1Detail} ({tabId})", EnumTab = EnumTabs.OverviewC1DetailMerged, Parent = new ParentRow { TabID = row.ParentTabID, Parent = row.Row } },
|
|
key => detailOverviews.Cast<IDataModel>().ToList(), (key, oldValue) => detailOverviews.Cast<IDataModel>().ToList());
|
|
}
|
|
|
|
tabs.Reload();
|
|
SelectedTabIndex = Tabs.Count - 1;
|
|
}
|
|
}
|
|
|
|
private async Task OnDoubleClickRowDetailOverview(SelectRow row)
|
|
{
|
|
List<TestHistory> histories = new();
|
|
if (IsMergePartNumberOption == false)
|
|
{
|
|
histories = await CPXV2LogService.GetTestHistory(SearchDataOverviews, row.Row);
|
|
}
|
|
else
|
|
{
|
|
histories = await CPXV2LogService.GetTestHistoryMerged(SearchDataOverviews, row.Row);
|
|
}
|
|
|
|
//test summary
|
|
int ok = histories.Count(x => x.TestResult.ToLower().Contains("ok"));
|
|
int ng = histories.Count(x => !x.TestResult.ToLower().Contains("ok"));
|
|
double ratio = (double)(ok) / (double)(ok + ng) * 100.0;
|
|
|
|
double testTimeAvg = histories.Average(x => Convert.ToInt32(x.Duration)) / 1000.0;
|
|
double testTimeMin = histories.Min(x => Convert.ToInt32(x.Duration)) / 1000.0;
|
|
double testTimeMax = histories.Max(x => Convert.ToInt32(x.Duration)) / 1000.0;
|
|
|
|
int tabId = Tabs.Max(x => x.Key.Id) + 1;
|
|
Tabs.AddOrUpdate(
|
|
new OrderdTab { Id = tabId, TabName = $"{EnumTabs.TestHistoryC1}({tabId})", EnumTab = EnumTabs.TestHistoryC1, Parent = new ParentRow { TabID = row.ParentTabID, Parent = row.Row } ,
|
|
SummaryTestResult = $"Test Result: {ok + ng} (OK:{ok}/NG:{ng}) - Ratio:{ratio.ToString("F2")}%",
|
|
SummaryTestTime = $"Test Time: Average={testTimeAvg.ToString("F2")}sec Min={testTimeMin.ToString("F2")}sec Max={testTimeMax.ToString("F2")}sec" },
|
|
key => histories.Cast<IDataModel>().ToList(), (key, oldValue) => histories.Cast<IDataModel>().ToList());
|
|
|
|
tabs.Reload();
|
|
SelectedTabIndex = Tabs.Count - 1;
|
|
}
|
|
|
|
private async Task OnDoubleClickRowHistory(SelectRow row)
|
|
{
|
|
var selectRow = row.Row as TestHistory;
|
|
int testStepVersion = selectRow.StepVersion;
|
|
if(Int32.TryParse(SelectionStepVersion, out var inputStepVersion) == true)
|
|
{
|
|
testStepVersion = inputStepVersion;
|
|
}
|
|
|
|
var s = await CPXV2LogService.GetTestResult(row.Row, testStepVersion);
|
|
|
|
int tabId = Tabs.Max(x => x.Key.Id) + 1;
|
|
Tabs.AddOrUpdate(
|
|
new OrderdTab { Id = tabId, TabName = $"{EnumTabs.TestResultC1}({tabId})", EnumTab = EnumTabs.TestResultC1, Parent = new ParentRow { TabID = row.ParentTabID, Parent = row.Row } },
|
|
key => s?.ParseTestResult?.Cast<IDataModel>()?.ToList(), (key, oldValue) => s?.ParseTestResult?.Cast<IDataModel>()?.ToList());
|
|
|
|
tabs.Reload();
|
|
SelectedTabIndex = Tabs.Count - 1;
|
|
}
|
|
|
|
private async Task OnSummary()
|
|
{
|
|
var selectedTab = Tabs.Select(x => x.Key)?.FirstOrDefault(x => x.Id == SelectedTabIndex);
|
|
if (selectedTab is not null)
|
|
{
|
|
//history에서만 summary 사용
|
|
if (selectedTab.EnumTab == EnumTabs.TestHistoryC1)
|
|
{
|
|
if (Tabs.TryGetValue(selectedTab, out var data) == true)
|
|
{
|
|
if (Int32.TryParse(SelectionStepVersion, out int stepVersion) == true)
|
|
{
|
|
var testHistories = data.Cast<TestHistory>().ToList();
|
|
var summary = await CPXV2LogService.GetTestSummary(testHistories, stepVersion);
|
|
var summaryInformation = testHistories.GetTestSummaryInformation();
|
|
|
|
if (summary is not null && summaryInformation is not null)
|
|
{
|
|
summaryInformation.SearchRangeStart = (DateTime)new DateTime(RequestSearch.SearchStart, TimeOnly.MinValue);
|
|
summaryInformation.SearchRangeEnd = (DateTime)new DateTime(RequestSearch.SearchEnd, TimeOnly.MaxValue);
|
|
|
|
int tabId = Tabs.Max(x => x.Key.Id) + 1;
|
|
Tabs.AddOrUpdate(
|
|
new OrderdTab { Id = tabId, TabName = $"{EnumTabs.TestSummaryC1}({tabId})", EnumTab = EnumTabs.TestSummaryC1, Parent = new ParentRow { TabID = selectedTab.Id, Parent = summaryInformation } },
|
|
key => summary?.ParseTestSummary?.Cast<IDataModel>()?.ToList(), (key, oldValue) => summary?.ParseTestSummary?.Cast<IDataModel>()?.ToList());
|
|
|
|
tabs.Reload();
|
|
SelectedTabIndex = Tabs.Count - 1;
|
|
}
|
|
}
|
|
}
|
|
}
|
|
else
|
|
{
|
|
LogXnet.WriteLine("Not history", LogXLabel.Warning);
|
|
}
|
|
}
|
|
}
|
|
|
|
private async Task OnDoubleClickRowSummary(SelectRow row)
|
|
{
|
|
var selectRow = row.Row as ParseTestSummary;
|
|
if(selectRow is not null)
|
|
{
|
|
var historyTabId = Tabs.Select(x => x.Key)?.FirstOrDefault(x => x.Id == row.ParentTabID);
|
|
var selectedTab = Tabs.Select(x => x.Key)?.FirstOrDefault(x => x.Id == historyTabId.Id);
|
|
|
|
if (selectedTab is not null)
|
|
{
|
|
if (selectedTab.EnumTab == EnumTabs.TestHistoryC1)
|
|
{
|
|
if (Tabs.TryGetValue(selectedTab, out var data) == true)
|
|
{
|
|
if (Int32.TryParse(SelectionStepVersion, out int stepVersion) == true)
|
|
{
|
|
var testHistories = data.Cast<TestHistory>().ToList();
|
|
var trend = await CPXV2LogService.GetTestTrend(testHistories, stepVersion, selectRow.StepNo);
|
|
|
|
int tabId = Tabs.Max(x => x.Key.Id) + 1;
|
|
Tabs.AddOrUpdate(
|
|
new OrderdTab { Id = tabId, TabName = $"{EnumTabs.TestTrendC1}({tabId})", EnumTab = EnumTabs.TestTrendC1, Parent = new ParentRow { TabID = selectedTab.Id, Parent = trend } },
|
|
key => trend?.ParseTestTrend?.Cast<IDataModel>()?.ToList(), (key, oldValue) => trend?.ParseTestTrend?.Cast<IDataModel>()?.ToList());
|
|
|
|
tabs.Reload();
|
|
SelectedTabIndex = Tabs.Count - 1;
|
|
}
|
|
}
|
|
}
|
|
else
|
|
{
|
|
LogXnet.WriteLine("Not history", LogXLabel.Warning);
|
|
}
|
|
}
|
|
}
|
|
}
|
|
|
|
private void OnClickClose(int tabId)
|
|
{
|
|
CloseTab(tabId);
|
|
}
|
|
|
|
private void CloseTab(int tabId)
|
|
{
|
|
var removeTab = Tabs.Where(x => x.Key.Id == tabId)?.First().Key;
|
|
|
|
//remove
|
|
if (removeTab is not null)
|
|
{
|
|
Tabs.TryRemove(removeTab, out var value);
|
|
}
|
|
|
|
//select tab
|
|
var currentTab = tabs.SelectedTab;
|
|
if (Tabs.Where(x => x.Key.TabName == currentTab.Text)?.Count() > 0)
|
|
{
|
|
SelectedTabIndex = currentTab.Index;
|
|
}
|
|
else
|
|
{
|
|
SelectedTabIndex = Tabs.Count - 1;
|
|
}
|
|
tabs.Reload();
|
|
}
|
|
|
|
private async Task OnChangeMergePartNumberOption()
|
|
{
|
|
PopupService.OpenIndicator("");
|
|
await GetOverviews();
|
|
|
|
await Task.Delay(300);
|
|
PopupService.CloseIndicator();
|
|
}
|
|
|
|
private async Task OnClickDisplayTestList(TestHistory history)
|
|
{
|
|
await JS.InvokeVoidAsync("open", $"/testlist/{history.ProductNo}/{history.TestCode}/{SelectionStepVersion}", "_blank");
|
|
}
|
|
|
|
private async Task OnExportExcel()
|
|
{
|
|
var tab = Tabs.FirstOrDefault(x => x.Key.Id == SelectedTabIndex);
|
|
if(tab.Value?.Count > 0)
|
|
{
|
|
if (tab.Key.EnumTab == EnumTabs.OverviewC1 || tab.Key.EnumTab == EnumTabs.OverviewC1Detail || tab.Key.EnumTab == EnumTabs.OverviewC1Merged || tab.Key.EnumTab == EnumTabs.OverviewC1DetailMerged)
|
|
await ExportToExcelAsync(tab.Value.Cast<Overview>());
|
|
|
|
if(tab.Key.EnumTab == EnumTabs.TestSummaryC1)
|
|
await ExportToExcelAsync(tab.Value.Cast<ParseTestSummary>());
|
|
}
|
|
}
|
|
|
|
public async Task ExportToExcelAsync<T>(IEnumerable<T> data, string fileName = "export.xlsx")
|
|
{
|
|
using var workbook = new XLWorkbook();
|
|
var worksheet = workbook.Worksheets.Add("Sheet1");
|
|
|
|
var properties = typeof(T).GetProperties();
|
|
|
|
// 헤더
|
|
for (int i = 0; i < properties.Length; i++)
|
|
{
|
|
worksheet.Cell(1, i + 1).Value = properties[i].Name;
|
|
}
|
|
|
|
// 데이터
|
|
int row = 2;
|
|
foreach (var item in data)
|
|
{
|
|
for (int col = 0; col < properties.Length; col++)
|
|
{
|
|
var value = properties[col].GetValue(item);
|
|
// if(value is int)
|
|
// worksheet.Cell(row, col + 1).Value = Convert.ToInt32(value);
|
|
// else if (value is double)
|
|
// worksheet.Cell(row, col + 1).Value = Convert.ToDouble(value);
|
|
|
|
worksheet.Cell(row, col + 1).Value = $" {value}";
|
|
}
|
|
row++;
|
|
}
|
|
|
|
using var stream = new MemoryStream();
|
|
workbook.SaveAs(stream);
|
|
var bytes = stream.ToArray();
|
|
await JS.InvokeVoidAsync("downloadFile", fileName, Convert.ToBase64String(bytes));
|
|
}
|
|
} |