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)); }