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