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()); return(CommonPageUtil.CLOBnBLOBParsing(ds, llstCondition, false, false, false)); }
private void PROC_DataBinding() { DataSet _ds = null; CreateChartDataTable _createChartDT = null; try { _dtChartData = new DataTable(); _createChartDT = new CreateChartDataTable(); this.MsgShow(this._lang.GetVariable("RMS_PROGRESS_SEARCH")); _ds = _wsSPC.GetSPCControlChartData(_llstSearchCondition.GetSerialData()); if (DataUtil.IsNullOrEmptyDataSet(_ds)) { this.MsgClose(); MSGHandler.DisplayMessage(MSGType.Warning, MSGHandler.GetMessage("INFORMATION_NODATA")); } else { this._dtChartData = CommonPageUtil.CLOBnBLOBParsing(_ds, _llstSearchCondition, false); if (_ds != null) { _ds.Dispose(); } //초기설정된 값만큼만 조회 if (iSearch == 0) { if (_dtChartData.Rows.Count > this.restrict_sample_count) { DataTable dtCopy = new DataTable(); DataRow[] drSelect = _dtChartData.Select(null, Definition.CHART_COLUMN.TIME + " desc"); if (drSelect.Length > 0) { dtCopy = drSelect[0].Table.Clone(); } for (int i = 0; i <= this.restrict_sample_count; i++) { dtCopy.ImportRow(drSelect[i]); } _dtChartData = DataUtil.DataTableImportRow(dtCopy.Select(null, "TIME")); dtCopy.Dispose(); } } else { _dtChartData = DataUtil.DataTableImportRow(_dtChartData.Select(null, Definition.CHART_COLUMN.TIME)); } if (string.IsNullOrEmpty(_dtChartData.Rows[0]["default_chart_list"].ToString())) { this.MsgClose(); MSGHandler.DisplayMessage(MSGType.Warning, string.Format(MSGHandler.GetMessage("GENERAL_NO_ITEM"), "Default Charts")); } else { _chartVariable.lstDefaultChart.Clear(); _chartVariable.DEFAULT_CHART = _dtChartData.Rows[0]["default_chart_list"].ToString(); _chartVariable.complex_yn = _dtChartData.Rows[0]["COMPLEX_YN"].ToString(); _chartVariable.MAIN_YN = _dtChartData.Rows[0]["MAIN_YN"].ToString(); _chartVariable.MODEL_CONFIG_RAWID = _dtChartData.Rows[0]["MODEL_CONFIG_RAWID"].ToString(); _chartVariable.SPC_MODEL = _dtChartData.Rows[0]["SPC_MODEL_NAME"].ToString(); //_chartVariable.PARAM_ALIAS = sParameter; _chartVariable.PARAM_ALIAS = _dtChartData.Rows[0]["PARAM_ALIAS"].ToString(); _chartVariable.OPERATION_ID = _dtChartData.Rows[0][Definition.CHART_COLUMN.OPERATION_ID].ToString(); _chartVariable.PRODUCT_ID = _dtChartData.Rows[0][Definition.CHART_COLUMN.PRODUCT_ID].ToString(); _chartVariable.RESTRICT_SAMPLE_DAYS = _dtChartData.Rows[0]["RESTRICT_SAMPLE_DAYS"].ToString(); _chartVariable.AREA = _dtChartData.Rows[0]["AREA"].ToString(); _createChartDT.COMPLEX_YN = _chartVariable.complex_yn; _chartVariable.lstDefaultChart = CommonPageUtil.DefaultChartSplit(_chartVariable.DEFAULT_CHART); _chartVariable.CHART_PARENT_MODE = CHART_PARENT_MODE.SPC_CONTROL_CHART; _chartVariable.lstRawColumn = _createChartDT.lstRawColumn; //_createChartDT.CallRefCol(_dtChartData); Console.WriteLine(DateTime.Now.ToString()); _chartVariable.dtParamData = _createChartDT.GetMakeDataTable(_dtChartData); Console.WriteLine(DateTime.Now.ToString()); if (_createChartDT != null) { _createChartDT = null; } } } AddContrChart(); } catch (Exception ex) { LogHandler.ExceptionLogWrite(Definition.APPLICATION_NAME, ex); } finally { this.MsgClose(); if (_createChartDT != null) { _createChartDT = null; } if (_chartVariable != null) { _chartVariable = null; } if (_dtChartData != null) { _dtChartData.Dispose(); } } }