public PpkCondition()
{
this._wsSPC = new WebServiceController <eSPCWebService.eSPCWebService>().Create();
this._mlthandler = MultiLanguageHandler.getInstance();
this._comUtil = new CommonUtility();
this.sortUC = new SortingKey();
this.ppkDate = new BISTel.eSPC.Condition.Controls.Date.PpkDateCondition();
InitializeComponent();
this.blblEQPID.Text = _mlthandler.GetVariable(Definition.LABEL.EQP_ID);
this.blblOperation.Text = _mlthandler.GetVariable(Definition.LABEL.OPERATION_ID);
this.blblParameter.Text = _mlthandler.GetVariable(Definition.LABEL.PARAMETER);
this.blblProduct.Text = _mlthandler.GetVariable(Definition.LABEL.PRODUCT);
this.bTPnlSortingKey.Text = _mlthandler.GetVariable(Definition.LABEL.SORTING_KEY);
InitializeLayout();
}
public void InitializeLayerOut()
{
this.bTitlePnlPeriod.Title = _mlthandler.GetVariable(Definition.LABEL.PERIOD);
this.dateCondition1 = new BISTel.eSPC.Condition.Controls.Date.DateCondition();
this.dateCondition1.Dock = DockStyle.Fill;
this.bTitlePnlPeriod.Controls.Add(this.dateCondition1);
this._bUseComma = AppConfiguration.GetConfigValue(Definition.PATH_ESPC, Definition.PATH_SPC_MODELING, Definition.CONFIG_USE_COMMA, false);
}
public SPCControlChartCondition()
{
this._wsSPC = new WebServiceController <eSPCWebService.eSPCWebService>().Create();
this._mlthandler = MultiLanguageHandler.getInstance();
this._comUtil = new CommonUtility();
this._Initialization = new Initialization();
InitializeComponent();
this.dateCondition1 = new BISTel.eSPC.Condition.Controls.Date.DateCondition();
this.dateCondition1.Dock = System.Windows.Forms.DockStyle.Fill;
this.grpPeriod.Controls.Add(this.dateCondition1);
this.grpEpqID.Text = _mlthandler.GetVariable(Definition.LABEL.EQP_ID);
this.grpOperation.Text = _mlthandler.GetVariable(Definition.LABEL.OPERATION_ID);
this.grpParameter.Text = _mlthandler.GetVariable(Definition.LABEL.PARAMETER);
this.grpProduct.Text = _mlthandler.GetVariable(Definition.LABEL.PRODUCT);
this.grpPeriod.Text = _mlthandler.GetVariable(Definition.LABEL.PERIOD);
}
public MultiDataCondition()
{
this._wsSPC = new WebServiceController <eSPCWebService.eSPCWebService>().Create();
this._mlthandler = MultiLanguageHandler.getInstance();
this._comUtil = new CommonUtility();
this._Initialization = new Initialization();
this._bspreadutility = new BSpreadUtility();
InitializeComponent();
this.dateCondition1 = new BISTel.eSPC.Condition.Controls.Date.DateCondition();
this.dateCondition1.Dock = DockStyle.Fill;
this.bTPnlPeriod.Controls.Add(dateCondition1);
this.sortUC = new SortingKey();
this.sortUC.Dock = DockStyle.Fill;
this.bTPnlSortingKey.Controls.Add(sortUC);
this.PROC_BindSortingKey();
this.bTPnlPeriod.Title = _mlthandler.GetVariable(Definition.LABEL.PERIOD);
this.bTPnlSortingKey.Title = _mlthandler.GetVariable(Definition.Analysis.LABEL_SORTING_KEY);
InitializePage();
}
public SPCAnalysisCondition()
{
this._wsSPC = new WebServiceController <eSPCWebService.eSPCWebService>().Create();
this._mlthandler = MultiLanguageHandler.getInstance();
this._comUtil = new CommonUtility();
this._Initialization = new Initialization();
InitializeComponent();
this.dateCondition1 = new BISTel.eSPC.Condition.Controls.Date.DateCondition();
this.dateCondition1.Dock = DockStyle.Fill;
this.bTitlePnlPeriod.Controls.Add(dateCondition1);
this.grpOperation.Text = _mlthandler.GetVariable(Definition.LABEL.OPERATION_ID);
this.grpParamItem.Text = _mlthandler.GetVariable(Definition.LABEL.PARAMETER);
this.grpSubData.Text = _mlthandler.GetVariable(Definition.Analysis.LABEL_SUB_DATA);
this.grpTarget.Text = _mlthandler.GetVariable(Definition.Analysis.LABEL_TARGET);
this.grpChartList.Text = _mlthandler.GetVariable(Definition.Analysis.LABEL_CHART_LIST);
this.bTitlePnlPeriod.Title = _mlthandler.GetVariable(Definition.LABEL.PERIOD);
InitializePage();
}
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();
}
}
public void SetParentValue(LinkedList llParentValue)
{
_btvCondition.Nodes.Clear();
_llstParent = llParentValue;
if (_llstParent.Contains(Definition.CONDITION_SEARCH_KEY_AREA))
{
DataTable dtLine = (DataTable)_llstParent[Definition.DynamicCondition_Search_key.LINE];
_sLineRawid = DCUtil.GetValueData(dtLine);
DataTable dtArea = (DataTable)_llstParent[Definition.DynamicCondition_Search_key.AREA];
_sAreaRawid = DCUtil.GetValueData(dtArea);
if (dtArea.Rows.Count > 1)
{
MSGHandler.DisplayMessage(MSGType.Information, string.Format(MSGHandler.GetMessage(Definition.MSG_KEY_ALLOW_SINGLE_ONE), _mlthandler.GetVariable(Definition.LABEL_KEY_AREA)));
return;
}
XSPCOperationTree spcOperationTree = new XSPCOperationTree(_btvCondition);
spcOperationTree.LineRawid = _sLineRawid;
spcOperationTree.AreaRawid = _sAreaRawid;
spcOperationTree.IsShowCheck = true;
spcOperationTree.RecipeTypeCode = RecipeType.NONE;
spcOperationTree.ParamTypeCode = ParameterType.NONE;
spcOperationTree.IsLastNode = true;
spcOperationTree.AddRootNode();
}
_btvCondition.CheckCountType = BTreeView.CheckCountTypes.Single;
}
public void SetParentValue(LinkedList llParentValue)
{
_btvCondition.Nodes.Clear();
_llstParent = llParentValue;
if (_llstParent.Contains(Definition.DynamicCondition_Search_key.AREA))
{
DataTable dtLine = (DataTable)_llstParent[Definition.DynamicCondition_Search_key.LINE];
_sLineRawid = DCUtil.GetValueData(dtLine);
DataTable dtArea = (DataTable)_llstParent[Definition.DynamicCondition_Search_key.AREA];
_sAreaRawid = DCUtil.GetValueData(dtArea);
}
else if (_llstParent.Contains(Definition.DynamicCondition_Search_key.OPERATION))
{
DataTable dtOperation = (DataTable)_llstParent[Definition.DynamicCondition_Search_key.OPERATION];
_sOperationID = DCUtil.GetValueData(dtOperation);
if (dtOperation.Rows.Count > 1)
{
MSGHandler.DisplayMessage(MSGType.Information, string.Format(MSGHandler.GetMessage(Definition.MSG_KEY_ALLOW_SINGLE_ONE), _mlthandler.GetVariable(Definition.LABEL_KEY_OPERATION_ID)));
return;
}
XSPCParamTypeTree paramTypeTree = new XSPCParamTypeTree(_btvCondition);
paramTypeTree.LineRawid = _sLineRawid;
paramTypeTree.AreaRawid = _sAreaRawid;
paramTypeTree.IsShowCheck = false;
paramTypeTree.IsShowCheckEQP = true;
paramTypeTree.IsShowCheckEQPModel = true;
paramTypeTree.IsShowCheckProduct = true;
paramTypeTree.AddRootNode();
}
_btvCondition.CheckCountType = BTreeView.CheckCountTypes.Single;
}
private string CreateToolTipString(string strCol, string strValue, int rowIndex, string strChartName)
{
StringBuilder sb = new StringBuilder();
LinkedList llstChartSeries = new LinkedList();
string _sEQPID = "-";
string _sLOTID = "-";
string _sOperationID = "-";
string _sSubstrateID = "-";
string _sProductID = "-";
string _sTime = "-";
string _sParamList = "-";
string _sRawValue = "-";
string _sRawUSL = "-";
string _sRawUCL = "-";
string _sRawTarget = "-";
string _sRawLCL = "-";
string _sRawLSL = "-";
if (this._dtChartData.Columns.Contains(Definition.CHART_COLUMN.EQP_ID))
{
_sEQPID = this._dtChartData.Rows[rowIndex][Definition.CHART_COLUMN.EQP_ID].ToString();
}
if (this._dtChartData.Columns.Contains(Definition.CHART_COLUMN.LOT_ID))
{
_sLOTID = this._dtChartData.Rows[rowIndex][Definition.CHART_COLUMN.LOT_ID].ToString();
}
if (this._dtChartData.Columns.Contains(Definition.CHART_COLUMN.OPERATION_ID))
{
_sOperationID = this._dtChartData.Rows[rowIndex][Definition.CHART_COLUMN.OPERATION_ID].ToString();
}
if (this._dtChartData.Columns.Contains(Definition.CHART_COLUMN.SUBSTRATE_ID))
{
_sSubstrateID = this._dtChartData.Rows[rowIndex][Definition.CHART_COLUMN.SUBSTRATE_ID].ToString();
}
if (this._dtChartData.Columns.Contains(Definition.CHART_COLUMN.PRODUCT_ID))
{
_sProductID = this._dtChartData.Rows[rowIndex][Definition.CHART_COLUMN.PRODUCT_ID].ToString();
}
if (this._dtChartData.Columns.Contains("TIME"))
{
_sTime = this._dtChartData.Rows[rowIndex]["TIME"].ToString();
}
if (this._dtChartData.Columns.Contains(COLUMN.PARAM_LIST))
{
_sParamList = this._dtChartData.Rows[rowIndex][COLUMN.PARAM_LIST].ToString();
}
if (this._dtChartData.Columns.Contains("RAW"))
{
_sRawValue = this._dtChartData.Rows[rowIndex]["RAW"].ToString();
}
if (this._dtChartData.Columns.Contains("RAW_USL"))
{
_sRawUSL = this._dtChartData.Rows[rowIndex]["RAW_USL"].ToString();
}
if (this._dtChartData.Columns.Contains("RAW_UCL"))
{
_sRawUCL = this._dtChartData.Rows[rowIndex]["RAW_UCL"].ToString();
}
if (this._dtChartData.Columns.Contains("RAW_TARGET"))
{
_sRawTarget = this._dtChartData.Rows[rowIndex]["RAW_TARGET"].ToString();
}
if (this._dtChartData.Columns.Contains("RAW_LCL"))
{
_sRawLCL = this._dtChartData.Rows[rowIndex]["RAW_LCL"].ToString();
}
if (this._dtChartData.Columns.Contains("RAW_LSL"))
{
_sRawLSL = this._dtChartData.Rows[rowIndex]["RAW_LSL"].ToString();
}
sb.AppendFormat("{0} : {1}\r\n", _mlthandler.GetVariable(Definition.SPC_LABEL_ + Definition.CHART_COLUMN.PRODUCT_ID), _sProductID);
sb.AppendFormat("{0} : {1}\r\n", _mlthandler.GetVariable(Definition.SPC_LABEL_ + Definition.CHART_COLUMN.EQP_ID), _sEQPID);
sb.AppendFormat("{0} : {1}\r\n", _mlthandler.GetVariable(Definition.SPC_LABEL_ + Definition.CHART_COLUMN.LOT_ID), _sLOTID);
sb.AppendFormat("{0} : {1}\r\n", _mlthandler.GetVariable(Definition.SPC_LABEL_ + Definition.CHART_COLUMN.OPERATION_ID), _sOperationID);
sb.AppendFormat("{0} : {1}\r\n", _mlthandler.GetVariable(Definition.SPC_LABEL_ + Definition.CHART_COLUMN.SUBSTRATE_ID), _sSubstrateID);
sb.AppendFormat("{0} : {1}\r\n", "TIME", _sTime);
sb.AppendFormat("{0} : {1}\r\n", "PARAM LIST", _sParamList);
sb.AppendFormat("{0} : {1}\r\n", "VALUE", _sRawValue);
sb.AppendFormat("{0} : {1}\r\n", "USL", _sRawUSL);
sb.AppendFormat("{0} : {1}\r\n", "UCL", _sRawUCL);
sb.AppendFormat("{0} : {1}\r\n", "TARGET", _sRawTarget);
sb.AppendFormat("{0} : {1}\r\n", "LCL", _sRawLCL);
sb.AppendFormat("{0} : {1}\r\n", "LSL", _sRawLSL);
return(sb.ToString());
}