private void PROC_DataBinding() { DataSet ds = null; DataTableGroupBy dtGroupBy = null; string sFieldList = string.Empty; string sGroupBy = string.Empty; string sFilter = string.Empty; LinkedList _llstCol = new LinkedList(); DataRow nRow = null; DataTable dtResult = null; DataTable dtBasis = null; DataTable dtTarget = null; try { this.MsgShow(_lang.GetVariable("RMS_PROGRESS_SEARCH")); dtGroupBy = new DataTableGroupBy(); CreateChartDataTable _chartData = new CreateChartDataTable(); LinkedList _llstWhere = new LinkedList(); //Table 생성 dtResult = new DataTable(); CreateTable(dtResult); //기준Step string sParam = "'" + CommonPageUtil.GetConditionKeyArrayList(this._arrItem).Replace(",", "','") + "'"; DataSet dsBasis = GetResultDataSet(this._bProb, sParam, this._sOperation, this._arrInfo, this._arrSubData); if (!DataUtil.IsNullOrEmptyDataSet(dsBasis)) { if (!this._bProb) { _llstCol = GetQueryColumn(_bProb); if (this._arrSortingKey.Contains(Definition.CHART_COLUMN.MOCVDNAME)) { dtBasis = CommonPageUtil.CLOBnBLOBParsing(dsBasis, _llstWhere, false, true); } else { dtBasis = CommonPageUtil.CLOBnBLOBParsing(dsBasis, _llstWhere, false, false); } _llstCol.Clear(); for (int i = 0; i < this._arrSubData.Count; i++) { _llstCol.Add(this._arrSubData[i].ToString(), "1"); } dtBasis = _chartData.GetMakeDataTable(dtBasis, _llstCol); } else { dtBasis = dsBasis.Tables[0]; } } //Target if (!string.IsNullOrEmpty(_sTargetOperation)) { string sParamTarget = "'" + CommonPageUtil.GetConditionKeyArrayList(this._arrTargetItem).Replace(",", "','") + "'"; DataSet dsTarget = GetResultDataSet(this._bTartProb, sParamTarget, this._sTargetOperation, this._arrTargetInfo, this._arrTargetSubData); if (!DataUtil.IsNullOrEmptyDataSet(dsTarget)) { if (!this._bTartProb) { if (this._arrSortingKey.Contains(Definition.CHART_COLUMN.MOCVDNAME)) { dtTarget = CommonPageUtil.CLOBnBLOBParsing(dsTarget, _llstWhere, false, true); } else { dtTarget = CommonPageUtil.CLOBnBLOBParsing(dsTarget, _llstWhere, false, false); } _llstCol.Clear(); for (int i = 0; i < this._arrTargetSubData.Count; i++) { _llstCol.Add(this._arrTargetSubData[i].ToString(), "1"); } dtTarget = _chartData.GetMakeDataTable(dtTarget, _llstCol); } else { dtTarget = dsTarget.Tables[0]; } } } this.bSpread1.DataSource = null; if (!DataUtil.IsNullOrEmptyDataTable(dtBasis)) { this.MakeCrateTable(dtBasis, dtTarget, this._bProb, this._bTartProb, dtResult); } else { this.MsgClose(); MSGHandler.DisplayMessage(MSGType.Warning, MSGHandler.GetMessage("INFORMATION_NODATA")); } this.bSpread1.DataSource = dtResult; this.bSpread1.ActiveSheet.ColumnHeader.Cells[0, this._arrSortingKey.Count].Text = this._sOperationDesc; if (!string.IsNullOrEmpty(this._sTargetOperation)) { this.bSpread1.ActiveSheet.ColumnHeader.Cells[0, this.bSpread1.ActiveSheet.ColumnCount - (this._arrTargetItem.Count * this._arrTargetSubData.Count) - this._arrTargetInfo.Count].Text = this._sTargetOperationDesc; } } catch (Exception ex) { this.MsgClose(); LogHandler.ExceptionLogWrite(Definition.APPLICATION_NAME, ex); } finally { if (ds != null) { ds.Dispose(); } this.MsgClose(); } }
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(); } } }