private void GetModelConfigRawID() { LinkedList _llstModelConfigRawID = new LinkedList(); _llstModelConfigRawID.Add(Definition.DynamicCondition_Condition_key.LINE_RAWID, this.sLineRawid); _llstModelConfigRawID.Add(Definition.DynamicCondition_Condition_key.AREA_RAWID, this.sAreaRawid); if (!string.IsNullOrEmpty(this.sEqpModel)) { _llstModelConfigRawID.Add(Definition.DynamicCondition_Condition_key.EQP_MODEL, this.sEqpModel); } _llstModelConfigRawID.Add(Definition.DynamicCondition_Condition_key.PARAM_TYPE_CD, this.sParamType); _llstModelConfigRawID.Add(Definition.DynamicCondition_Condition_key.PARAM_ALIAS, GetConcat(this.sParamItem)); _llstModelConfigRawID.Add(Definition.DynamicCondition_Condition_key.MAIN_YN, "Y"); DataSet _dsModel = _wsSPC.GetSPCModelConfigSearch(_llstModelConfigRawID.GetSerialData()); this.lstModelConfigRawID.Clear(); if (!DataUtil.IsNullOrEmptyDataSet(_dsModel)) { restrict_sample_count = 0; restrict_sample_days = 0; foreach (DataRow dr in _dsModel.Tables[0].Rows) { string strModelCongifRawID = dr[Definition.DynamicCondition_Condition_key.MODEL_CONFIG_RAWID].ToString(); int iRestrict_sample_count = int.Parse(dr[COLUMN.RESTRICT_SAMPLE_COUNT].ToString()); int iRestrict_sample_days = int.Parse(dr[COLUMN.RESTRICT_SAMPLE_DAYS].ToString()); if (iRestrict_sample_count > restrict_sample_count) { restrict_sample_count = iRestrict_sample_count; } if (iRestrict_sample_days > restrict_sample_days) { restrict_sample_days = iRestrict_sample_days; } if (!this.lstModelConfigRawID.Contains(strModelCongifRawID)) { this.lstModelConfigRawID.Add(strModelCongifRawID); } } } else { restrict_sample_count = Definition.RESTRICT_SAMPLE_COUNT; restrict_sample_days = Definition.RESTRICT_SAMPLE_DAYS; } }
public override void PageSearch(LinkedList llstCondition) { this._llstSearchCondition.Clear(); DataTable dt = null; DataSet _ds = null; if (llstCondition[Definition.DynamicCondition_Search_key.DATETIME_FROM] != null) { dt = (DataTable)llstCondition[Definition.DynamicCondition_Search_key.DATETIME_FROM]; sStartTime = CommonPageUtil.StartDate(dt.Rows[0][Definition.DynamicCondition_Condition_key.VALUEDATA].ToString()); } if (llstCondition[Definition.DynamicCondition_Search_key.DATETIME_TO] != null) { dt = (DataTable)llstCondition[Definition.DynamicCondition_Search_key.DATETIME_TO]; sEndTime = CommonPageUtil.EndDate(dt.Rows[0][Definition.DynamicCondition_Condition_key.VALUEDATA].ToString()); } if (llstCondition[Definition.DynamicCondition_Search_key.LINE] != null) { dt = (DataTable)llstCondition[Definition.DynamicCondition_Search_key.LINE]; _Line = DataUtil.GetDisplayData(dt); _LineRawID = DCUtil.GetValueData(dt); } if (llstCondition[Definition.DynamicCondition_Search_key.AREA] != null) { dt = (DataTable)llstCondition[Definition.DynamicCondition_Search_key.AREA]; _AreaRawID = DataUtil.GetConditionKeyDataList(dt, Definition.DynamicCondition_Condition_key.VALUEDATA); } if (llstCondition[Definition.DynamicCondition_Search_key.EQPMODEL] != null) { dt = (DataTable)llstCondition[Definition.DynamicCondition_Search_key.EQPMODEL]; _EQPModel = DataUtil.GetConditionKeyDataList(dt, Definition.DynamicCondition_Condition_key.VALUEDATA, true); } DataTable dtParameter = (DataTable)llstCondition[Definition.DynamicCondition_Search_key.PARAM]; this._sParamTypeCD = DCUtil.GetValueData((DataTable)llstCondition[Definition.DynamicCondition_Search_key.PARAM_TYPE]); this._sOperationID = DataUtil.GetConditionKeyDataList((DataTable)llstCondition[Definition.DynamicCondition_Search_key.OPERATION], Definition.DynamicCondition_Condition_key.VALUEDATA, true); this._sEQPID = DataUtil.GetConditionKeyDataList((DataTable)llstCondition[Definition.DynamicCondition_Search_key.EQP_ID], Definition.DynamicCondition_Condition_key.VALUEDATA, true); this._sProductID = DataUtil.GetConditionKeyDataList((DataTable)llstCondition[Definition.DynamicCondition_Search_key.PRODUCT], Definition.DynamicCondition_Condition_key.VALUEDATA, true); this._sPeriodPpk = DCUtil.GetValueData((DataTable)llstCondition[Definition.DynamicCondition_Search_key.PERIOD_PPK]); this.arrSortingKey = CommonPageUtil.GetConditionKeyDataListArr((DataTable)llstCondition[Definition.DynamicCondition_Search_key.SORTING_KEY], Definition.DynamicCondition_Condition_key.VALUEDATA); LinkedList _llstModelConfigRawID = new LinkedList(); arrModelCongifRawID.Clear(); string sParameter = DataUtil.GetConditionKeyDataList(dtParameter, Definition.DynamicCondition_Condition_key.VALUEDATA, true); _llstModelConfigRawID.Clear(); _llstModelConfigRawID.Add(Definition.DynamicCondition_Condition_key.LINE_RAWID, _LineRawID); if (!string.IsNullOrEmpty(_AreaRawID)) { _llstModelConfigRawID.Add(Definition.DynamicCondition_Condition_key.AREA_RAWID, _AreaRawID); } if (!string.IsNullOrEmpty(_EQPModel)) { _llstModelConfigRawID.Add(Definition.DynamicCondition_Condition_key.EQP_MODEL, _EQPModel); } _llstModelConfigRawID.Add(Definition.DynamicCondition_Condition_key.PARAM_TYPE_CD, _sParamTypeCD); if (!string.IsNullOrEmpty(sParameter) && sParameter.IndexOf(Definition.VARIABLE.STAR) < 0) { _llstModelConfigRawID.Add(Definition.DynamicCondition_Condition_key.PARAM_ALIAS, sParameter); } _llstModelConfigRawID.Add(Definition.DynamicCondition_Condition_key.MAIN_YN, "Y"); if (!string.IsNullOrEmpty(_sOperationID) && _sOperationID != "*") { _llstModelConfigRawID.Add(Definition.DynamicCondition_Condition_key.OPERATION_ID, _sOperationID); } //sub modeling 존재여부 확인 _ds = _wsSPC.GetSPCModelConfigSearch(_llstModelConfigRawID.GetSerialData()); if (!DataUtil.IsNullOrEmptyDataSet(_ds)) { for (int i = 0; i < _ds.Tables[0].Rows.Count; i++) { string strModelCongifRawID = _ds.Tables[0].Rows[i][Definition.DynamicCondition_Condition_key.MODEL_CONFIG_RAWID].ToString(); if (!arrModelCongifRawID.Contains(strModelCongifRawID)) { arrModelCongifRawID.Add(strModelCongifRawID); } } } if (arrModelCongifRawID.Count == 0) { MSGHandler.DisplayMessage(MSGType.Warning, MSGHandler.GetMessage("INFORMATION_NODATA")); return; } string sModelCongifRawid = CommonPageUtil.GetConditionKeyArrayList(arrModelCongifRawID); this._llstSearchCondition.Clear(); this._llstSearchCondition.Add(Definition.DynamicCondition_Condition_key.START_DTTS, sStartTime); this._llstSearchCondition.Add(Definition.DynamicCondition_Condition_key.END_DTTS, sEndTime); this._llstSearchCondition.Add(Definition.DynamicCondition_Condition_key.PERIOD_PPK, this._sPeriodPpk); this._llstSearchCondition.Add(Definition.DynamicCondition_Condition_key.MODEL_CONFIG_RAWID, sModelCongifRawid); if (this._sParamTypeCD.Equals("MET")) { _OperationColumnName = Definition.CHART_COLUMN.MEASURE_OPERATION_ID; } else { _OperationColumnName = Definition.CHART_COLUMN.OPERATION_ID; } PROC_DataBinding(); }
private DataSet GetResultDataSet(bool _pProb, string _pParamItem, string _pOperationID, ArrayList _arrInfo, ArrayList _arrSubData) { DataSet _dsResult = null; if (_pProb) { LinkedList _llstCol = new LinkedList(); string sCol = string.Empty; string sGroup = string.Empty; for (int i = 0; i < this._arrSortingKey.Count; i++) { if (this._arrSortingKey[i].ToString().Equals("SAMPLE")) { continue; } else if (this._arrSortingKey[i].ToString().Equals("WORKDATE")) { sCol += "TO_CHAR(EVENT_DTTS,'yyyy-MM-dd') AS WORKDATE,"; sGroup += "TO_CHAR(EVENT_DTTS,'yyyy-MM-dd'),"; } else { sCol += this._arrSortingKey[i].ToString() + ","; sGroup += this._arrSortingKey[i].ToString() + ","; } } for (int i = 0; i < _arrInfo.Count; i++) { sCol += _arrInfo[i].ToString() + ","; sGroup += _arrInfo[i].ToString() + ","; } for (int i = 0; i < _arrSubData.Count; i++) { if (_arrSubData[i].ToString().Equals(Definition.CHART_COLUMN.USL) || _arrSubData[i].ToString().Equals(Definition.CHART_COLUMN.LSL)) { sCol += _arrSubData[i].ToString() + ","; sGroup += _arrSubData[i].ToString() + ","; } } if (!string.IsNullOrEmpty(sCol)) { sCol = sCol.Substring(0, sCol.Length - 1); sGroup = sGroup.Substring(0, sGroup.Length - 1); } this._llstData.Clear(); this._llstData.Add(Definition.DynamicCondition_Condition_key.FAB, this._sFab); this._llstData.Add(Definition.DynamicCondition_Condition_key.START_DTTS, this._sStartTime); this._llstData.Add(Definition.DynamicCondition_Condition_key.END_DTTS, this._sEndTime); this._llstData.Add(Definition.DynamicCondition_Condition_key.PARAM, _pParamItem); this._llstData.Add(Definition.DynamicCondition_Condition_key.OPERATION_ID, _pOperationID); this._llstData.Add(Definition.DynamicCondition_Condition_key.COLUMN_LIST, sCol); this._llstData.Add(Definition.DynamicCondition_Condition_key.GROUP, sGroup); _dsResult = this._wsSPC.GetMultiData(this._llstData.GetSerialData()); } else { string sModelConfigRawID = string.Empty; this._llstData.Clear(); this._llstData.Add(Definition.DynamicCondition_Condition_key.LINE_RAWID, this._LineRawID); if (!string.IsNullOrEmpty(this._AreaRawID)) { this._llstData.Add(Definition.DynamicCondition_Condition_key.AREA_RAWID, this._AreaRawID); } if (!string.IsNullOrEmpty(this._EQPModel)) { this._llstData.Add(Definition.DynamicCondition_Condition_key.EQP_MODEL, this._EQPModel); } this._llstData.Add(Definition.DynamicCondition_Condition_key.PARAM_TYPE_CD, this._ParamType); this._llstData.Add(Definition.DynamicCondition_Condition_key.PARAM_ALIAS, _pParamItem); this._llstData.Add(Definition.DynamicCondition_Condition_key.OPERATION_ID, CommonPageUtil.GetConCatString(_pOperationID)); DataSet ds = _wsSPC.GetSPCModelConfigSearch(_llstData.GetSerialData()); if (!DataUtil.IsNullOrEmptyDataSet(ds)) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { sModelConfigRawID += ds.Tables[0].Rows[i][COLUMN.MODEL_CONFIG_RAWID].ToString() + ","; } if (ds != null) { ds.Dispose(); } if (!string.IsNullOrEmpty(sModelConfigRawID)) { sModelConfigRawID = sModelConfigRawID.Substring(0, sModelConfigRawID.Length - 1); } } if (ds != null) { ds.Dispose(); } this._llstData.Clear(); this._llstData.Add(Definition.DynamicCondition_Condition_key.START_DTTS, this._sStartTime); this._llstData.Add(Definition.DynamicCondition_Condition_key.END_DTTS, this._sEndTime); this._llstData.Add(Definition.DynamicCondition_Condition_key.MODEL_CONFIG_RAWID, sModelConfigRawID); _dsResult = this._wsSPC.GetSPCControlChartData(this._llstData.GetSerialData()); } return(_dsResult); }