private void ClickButtonShowChartData()
{
DataTable dt = _dataManager.RawDataTable.Copy();
ChartDataPopup chartDataPop = null;
try
{
chartDataPop = new ChartDataPopup();
chartDataPop.URL = this.URL;
chartDataPop.SessionData = this.sessionData;
chartDataPop.DataTableParam = CommonPageUtil.ExcelExport(dt, ChartVariable.lstRawColumn);
chartDataPop.InitializePopup();
DialogResult result = chartDataPop.ShowDialog(this);
if (result == DialogResult.OK)
{
chartDataPop.Dispose();
}
}
catch
{
}
finally
{
dt.Dispose();
}
}
public static LinkedList GetOCAPParameter(DataTable dt, int iRow)
{
LinkedList _llstParam = new LinkedList();
if (dt == null)
{
return(_llstParam);
}
_llstParam.Add(Definition.CONDITION_KEY_PARAM_ALIAS, CommonPageUtil.ColumnsContains(Definition.CONDITION_KEY_PARAM_ALIAS, iRow, dt));
_llstParam.Add(Definition.CONDITION_KEY_LOT_ID, CommonPageUtil.ColumnsContains(Definition.CONDITION_KEY_LOT_ID, iRow, dt));
_llstParam.Add(Definition.CONDITION_KEY_SUBSTRATE_ID, CommonPageUtil.ColumnsContains(Definition.CONDITION_KEY_SUBSTRATE_ID, iRow, dt));
_llstParam.Add(Definition.CONDITION_KEY_CASSETTE_SLOT, CommonPageUtil.ColumnsContains(Definition.CONDITION_KEY_CASSETTE_SLOT, iRow, dt));
_llstParam.Add(Definition.CONDITION_KEY_RECIPE_ID, CommonPageUtil.ColumnsContains(Definition.CONDITION_KEY_RECIPE_ID, iRow, dt));
_llstParam.Add(Definition.CONDITION_KEY_PRODUCT_ID, CommonPageUtil.ColumnsContains(Definition.CONDITION_KEY_PRODUCT_ID, iRow, dt));
_llstParam.Add(Definition.CONDITION_KEY_OPERATION_ID, CommonPageUtil.ColumnsContains(Definition.CONDITION_KEY_OPERATION_ID, iRow, dt));
_llstParam.Add(Definition.CONDITION_KEY_EQP_ID, CommonPageUtil.ColumnsContains(Definition.CONDITION_KEY_EQP_ID, iRow, dt));
_llstParam.Add(Definition.CONDITION_KEY_MODULE_NAME, CommonPageUtil.ColumnsContains(Definition.CONDITION_KEY_MODULE_NAME, iRow, dt));
_llstParam.Add(Definition.CONDITION_KEY_STEP_ID, CommonPageUtil.ColumnsContains(Definition.CONDITION_KEY_STEP_ID, iRow, dt));
_llstParam.Add(Definition.CONDITION_KEY_CONTEXT_LIST, CommonPageUtil.ColumnsContains(Definition.CONDITION_KEY_CONTEXT_LIST, iRow, dt));
_llstParam.Add(Definition.CONDITION_KEY_OOC_PROBLEM, CommonPageUtil.ColumnsContains(Definition.CONDITION_KEY_OOC_PROBLEM, iRow, dt));
_llstParam.Add(Definition.CONDITION_KEY_OOC_CAUSE, CommonPageUtil.ColumnsContains(Definition.CONDITION_KEY_OOC_CAUSE, iRow, dt));
_llstParam.Add(Definition.CONDITION_KEY_OOC_SOLUTION, CommonPageUtil.ColumnsContains(Definition.CONDITION_KEY_OOC_SOLUTION, iRow, dt));
_llstParam.Add(Definition.CONDITION_KEY_OOC_TRX_SPC_RAWID, CommonPageUtil.ColumnsContains(Definition.CONDITION_KEY_OOC_TRX_SPC_RAWID, iRow, dt));
_llstParam.Add(Definition.CONDITION_KEY_CONTEXT_KEY, CommonPageUtil.ColumnsContains(Definition.CONDITION_KEY_CONTEXT_KEY, iRow, dt));
_llstParam.Add(Definition.CONDITION_KEY_MODEL_NAME, CommonPageUtil.ColumnsContains(Definition.CONDITION_KEY_MODEL_NAME, iRow, dt));
_llstParam.Add(Definition.CHART_COLUMN.TIME, CommonPageUtil.ColumnsContains(Definition.CHART_COLUMN.TIME, iRow, dt));
return(_llstParam);
}
public void InitializeCondition()
{
if (chart_parent_mode == CHART_PARENT_MODE.PPK_REPORT)
{
if (ChartVariable.dtParamData == null || ChartVariable.dtParamData.Rows.Count == 0)
{
MSGHandler.DisplayMessage(MSGType.Information, MSGHandler.GetMessage("INFORMATION_NODATA"));
return;
}
}
else
{
if (ChartVariable.dtResource == null || ChartVariable.dtResource.Rows.Count == 0)
{
MSGHandler.DisplayMessage(MSGType.Information, MSGHandler.GetMessage("INFORMATION_NODATA"));
return;
}
CreateParamDataTable();
}
ChartVariable.lstDefaultChart.Clear();
ChartVariable.lstDefaultChart = CommonPageUtil.DefaultChartSplit(ChartVariable.DEFAULT_CHART);
Common.SPCChart spcControlChart = new BISTel.eSPC.Page.Common.SPCChart();
spcControlChart.Dock = System.Windows.Forms.DockStyle.Fill;
spcControlChart.URL = this.URL;
spcControlChart.ChartVariable = ChartVariable;
spcControlChart.sessionData = this.SessionData;
spcControlChart.Height = this.pnlChart.Height;
spcControlChart.InitializePage();
this.pnlChart.Controls.Add(spcControlChart);
}
public static DataTable GetDataRowSelect(DataTable _dt, LinkedList _llstCondition)
{
if (DataUtil.IsNullOrEmptyDataTable(_dt))
{
return(null);
}
DataRow[] drSelect = _dt.Select(CommonPageUtil.GetDataRowSelectString(_llstCondition));
return(DataUtil.DataTableImportRow(drSelect));
}
internal DataTable GetRawData(string startDtts, string endDtts, string chartID)
{
if (_ws == null)
{
_ws = new WebServiceController <eSPCWebService.eSPCWebService>().Create();
}
LinkedList llstCondition = new LinkedList();
llstCondition.Add(Definition.CONDITION_KEY_START_DTTS, startDtts);
llstCondition.Add(Definition.CONDITION_KEY_END_DTTS, endDtts);
llstCondition.Add(Definition.CONDITION_KEY_MODEL_CONFIG_RAWID, chartID);
DataSet ds = _ws.GetSPCControlChartData(llstCondition.GetSerialData());
if (this.ParamType.ToUpper() == "MET")
{
return(CommonPageUtil.CLOBnBLOBParsing(ds, llstCondition, false, false, false));
}
return(CommonPageUtil.CLOBnBLOBParsingRaw(ds, llstCondition, false, false));
}
private void bbtnListChart_ButtonClick(string name)
{
try
{
if (ChartVariable.dtParamData == null || ChartVariable.dtParamData.Rows.Count == 0)
{
MSGHandler.DisplayMessage(MSGType.Information, MSGHandler.GetMessage("INFORMATION_NODATA"));
return;
}
if (name.ToUpper() == Definition.ButtonKey.CALC)
{
this.ClickButtonCalc();
}
else if (name.ToUpper() == Definition.ButtonKey.SELECT_CHART_TO_VIEW)
{
this.ClickButtonChartView();
}
else if (name.ToUpper() == Definition.ButtonKey.DEFAULT_CHART)
{
_llstChart.Clear();
_llstChart = GetDefaultChart();
this.InitializeChartSeriesVisibleType();
this.InitializeChart();
}
else if (name.ToUpper() == Definition.ButtonKey.CONFIGURATION)
{
this.ClickButtonConfiguration();
}
else if (name.ToUpper() == Definition.ButtonKey.CHART_DATA)
{
this.ClickButtonShowChartData();
}
else if (name.ToUpper() == Definition.ButtonKey.OCAP_VIEW)
{
if (_chartInfomationUI.bsprInformationData.ActiveSheet.RowCount == 0)
{
MSGHandler.DisplayMessage(MSGType.Information, MSGHandler.GetMessage("INFORMATION_NODATA"));
return;
}
if (_valueIndex == -1)
{
return;
}
string strRawid = GetOCAPRawID(_dataManager.RawDataTable, _valueIndex);
string[] arr = strRawid.Split(';');
string sRawid = string.Empty;
for (int i = 0; i < arr.Length; i++)
{
if (string.IsNullOrEmpty(arr[i]))
{
continue;
}
sRawid += arr[i] + ",";
}
if (sRawid.EndsWith(","))
{
sRawid = sRawid.Substring(0, sRawid.Length - 1);
}
if (string.IsNullOrEmpty(sRawid))
{
MSGHandler.DisplayMessage(MSGType.Information, MSGHandler.GetMessage("INFORMATION_NODATA"));
return;
}
BISTel.eSPC.Page.OCAP.OCAPDetailsPopup popupOCAP = new BISTel.eSPC.Page.OCAP.OCAPDetailsPopup();
popupOCAP.ChartVariable = ChartVariable;
//popupOCAP.ChartVariable.OPERATION_ID = this._chartInfomationUI.bsprInformationData.ActiveSheet.Cells[(int)enum_ChartInfomationData.OPERATION_ID, 1].Text;
//popupOCAP.ChartVariable.PRODUCT_ID = this._chartInfomationUI.bsprInformationData.ActiveSheet.Cells[(int)enum_ChartInfomationData.PRODUCT_ID, 1].Text;
popupOCAP.ChartVariable.llstInfoCondition = CommonPageUtil.GetOCAPParameter(_dataManager.RawDataTable, _valueIndex);
popupOCAP.ChartVariable.OCAPRawID = sRawid;
popupOCAP.PopUpType = enum_PopupType.View;
popupOCAP.SessionData = this.sessionData;
popupOCAP.URL = this.URL;
popupOCAP.InitializePopup();
DialogResult result = popupOCAP.ShowDialog(this);
if (result == DialogResult.OK)
{
popupOCAP.Dispose();
}
}
}
catch (Exception ex)
{
MSGHandler.DisplayMessage(MSGType.Error, ex.Message);
}
}
public static DataTable CLOBnBLOBParsingRaw(DataSet _ds, LinkedList _llstWhere, bool bDataParsing, bool includingToggleData)
{
return(CommonPageUtil.ParsingRaw(_ds, _llstWhere, bDataParsing, includingToggleData));
}
/// <summary>
///
/// </summary>
/// <param name="_ds"></param>
/// <param name="_llstWhere"></param>
/// <param name="bDataParsing"></param>
/// <returns></returns>
public static DataTable CLOBnBLOBParsing(DataSet _ds, LinkedList _llstWhere, bool bDataParsing)
{
return(CommonPageUtil.Parsing(_ds, _llstWhere, bDataParsing, false, false));
}
