private void ParseDataTable() { LinkedList _llstData = new LinkedList(); DataSet dsContextType = _wsSPC.GetContextType(_llstData.GetSerialData()); LinkedList mllstContextType = SetContextType(dsContextType); mllstContextType.Add("RAW", null); mllstContextType.Add("RAW_USL", null); mllstContextType.Add("RAW_UCL", null); mllstContextType.Add("RAW_TARGET", null); mllstContextType.Add("RAW_LCL", null); mllstContextType.Add("RAW_LSL", null); mllstContextType.Add("PARAM_LIST", null); mllstContextType.Add("RAW_DTTS", null); if (!mllstContextType.Contains("EQP_ID")) { mllstContextType.Add("EQP_ID", null); } for (int i = 0; i < this._dtOriData.Columns.Count; i++) { if (!mllstContextType.Contains(this._dtOriData.Columns[i].ColumnName.ToUpper())) { this._dtOriData.Columns.Remove(this._dtOriData.Columns[i].ColumnName); i--; } } }
private void PROC_DataBinding() { this._bRemovedDuplicatedRow = false; ParseCLOB pclob = null; try { _dsOCAPList = new DataSet(); EESProgressBar.ShowProgress(this, this._lang.GetMessage(Definition.LOADING_DATA), true); AsyncCallHandler ach = new AsyncCallHandler(EESProgressBar.AsyncCallManager); object objDataSet = ach.SendWait(_wsSPC, "GetATTOCAPList", new object[] { _llstSearchCondition.GetSerialData() }); EESProgressBar.CloseProgress(this); this.bsprData.ActiveSheet.RowCount = 0; this.bsprData.DataSource = null; //this.bsprData.ActiveSheet.FrozenColumnCount = 1; this.bsprData.ColFronzen = 1; if (objDataSet != null) { _dsOCAPList = (DataSet)objDataSet; } else { MSGHandler.DisplayMessage(MSGType.Warning, MSGHandler.GetMessage("INFORMATION_NODATA")); return; } if (DataUtil.IsNullOrEmptyDataSet(_dsOCAPList)) { MSGHandler.DisplayMessage(MSGType.Warning, MSGHandler.GetMessage("INFORMATION_NODATA")); return; } EESProgressBar.ShowProgress(this, MSGHandler.GetMessage("PROCESS_LOADING_PAGE_DATA"), false); pclob = new ParseCLOB(); LinkedList _llstData = new LinkedList(); _llstData.Add(Definition.DynamicCondition_Condition_key.USE_YN, "Y"); DataSet dsContextType = _wsSPC.GetContextType(_llstData.GetSerialData()); LinkedList mllstContextType = CommonPageUtil.SetContextType(dsContextType); _dsOCAPList = pclob.DecompressOCAPDataTRXData(_dsOCAPList.Tables[0], mllstContextType, false); string strTempWhere = ""; if (this._sFilterEQPID.Length > 0) { strTempWhere += string.Format(" EQP_ID = '{0}'", this._sFilterEQPID); } if (this._sFilterModuleID.Length > 0) { if (strTempWhere.Length > 0) { strTempWhere += string.Format(" AND MODULE_ID = '{0}'", this._sFilterModuleID); } else { strTempWhere += string.Format(" MODULE_ID = '{0}'", this._sFilterModuleID); } } if (this._sFilterLot.Length > 0) { if (strTempWhere.Length > 0) { strTempWhere += string.Format(" AND LOT_ID = '{0}'", this._sFilterLot); } else { strTempWhere += string.Format(" LOT_ID = '{0}'", this._sFilterLot); } } if (this._sFilterSubStrate.Length > 0) { if (strTempWhere.Length > 0) { strTempWhere += string.Format(" AND SUBSTRATE_ID = '{0}'", this._sFilterSubStrate); } else { strTempWhere += string.Format(" SUBSTRATE_ID = '{0}'", this._sFilterSubStrate); } } if (this._sFilterRecipe.Length > 0) { if (strTempWhere.Length > 0) { strTempWhere += string.Format(" AND RECIPE_ID = '{0}'", this._sFilterRecipe); } else { strTempWhere += string.Format(" RECIPE_ID = '{0}'", this._sFilterRecipe); } } if (strTempWhere.Length > 0) { DataRow[] drs = _dsOCAPList.Tables[0].Select(strTempWhere); DataSet _dsOCAPList_Filter = _dsOCAPList.Clone(); foreach (DataRow drTemp in drs) { _dsOCAPList_Filter.Tables[0].ImportRow(drTemp); } if (DataUtil.IsNullOrEmptyDataSet(_dsOCAPList_Filter)) { this.MsgClose(); MSGHandler.DisplayMessage(MSGType.Warning, MSGHandler.GetMessage("INFORMATION_NODATA")); return; } this.bsprData.DataSource = _dsOCAPList_Filter; } else { this.bsprData.DataSource = _dsOCAPList; } } catch (Exception ex) { EESProgressBar.CloseProgress(this); if (ex is OperationCanceledException || ex is TimeoutException) { MSGHandler.DisplayMessage(MSGType.Error, ex.Message, null, null, true); } else { LogHandler.ExceptionLogWrite(Definition.APPLICATION_NAME, ex); MSGHandler.DisplayMessage(MSGType.Error, ex.Message, null, null, true); } } finally { EESProgressBar.CloseProgress(this); this._dsOCAPList.Dispose(); } }