public FilterControl() { InitializeComponent(); btxt_Filter.Enabled = true; _ws = new WebServiceController <eSPCWebService.eSPCWebService>().Create(); LinkedList llstCondition = new LinkedList(); if (this.GetType().FullName == "BISTel.eSPC.Condition.Controls.Filter.FilterControl") { llstCondition.Add(Definition.CONDITION_KEY_CATEGORY, "SPC_MODEL_LEVEL"); } else if (this.GetType().FullName == "BISTel.eSPC.Condition.ATT.Controls.Filter.FilterControl") { llstCondition.Add(Definition.CONDITION_KEY_CATEGORY, "SPC_ATT_MODEL_LEVEL"); } llstCondition.Add(Definition.CONDITION_KEY_USE_YN, "Y"); //llstCondition.Add(Definition.CONDITION_KEY_DEFAULT_COL, "Y"); DataSet ds = _ws.GetCodeData(llstCondition.GetSerialData()); if (ds != null && ds.Tables[0].Rows[0]["CODE"].ToString().ToUpper() == "AREA") { this._sSPC_MODEL_LEVEL = "AREA"; } else { this._sSPC_MODEL_LEVEL = "EQP MODEL"; } if (this.GetType().FullName == "BISTel.eSPC.Condition.Controls.Filter.FilterControl") { llstCondition.Clear(); llstCondition.Add(Definition.CONDITION_KEY_CATEGORY, "SPC_MET_MODEL_LEVEL"); llstCondition.Add(Definition.CONDITION_KEY_USE_YN, "Y"); //llstCondition.Add(Definition.CONDITION_KEY_DEFAULT_COL, "Y"); ds = _ws.GetCodeData(llstCondition.GetSerialData()); if (ds != null && ds.Tables[0].Rows[0]["CODE"].ToString().ToUpper() == "AREA") { this._sSPC_MET_MODEL_LEVEL = "AREA"; } else { this._sSPC_MET_MODEL_LEVEL = "EQP MODEL"; } } }
public string GetConditionType(string name) { //condition type을 확인 LinkedList llst = new LinkedList(); llst.Add(Definition.CONDITION_KEY_CATEGORY, Definition.CODE_CATEGORY_USE_CONDITION_TYPE); byte[] btdata = llst.GetSerialData(); DataSet ds = _spcWebService.GetCodeData(btdata); string sKey = name; if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { string config = ds.Tables[0].Rows[0][Definition.VARIABLE_CODE].ToString(); if (config == Definition.CODE_CATEGORY_USE_TREE) { sKey = name; BISTel.PeakPerformance.Client.CommonLibrary.GlobalDefinition.IsDeveloping = true; } else { sKey = "x"; BISTel.PeakPerformance.Client.CommonLibrary.GlobalDefinition.IsDeveloping = false; } } else { sKey = "x"; BISTel.PeakPerformance.Client.CommonLibrary.GlobalDefinition.IsDeveloping = false; } return(sKey); }
private void SPCModelGroupPopup_Load(object sender, EventArgs e) { DynamicConditionFactory dcf = new DynamicConditionFactory(); _dynamicEQP = dcf.GetDCOfPageByKey("BISTel.eSPC.Page.ATT.Modeling.SPCATTModelingUC"); Control ctrlEQP = ((DCBar)_dynamicEQP).GetControlByContextID("ESPC_ATT_COMBO_TREE"); this._btreeComboEQP = (BTreeCombo)ctrlEQP; this._btreeComboEQP.SelectionCommitted += new EventHandler(_btreeComboEQP_SelectionCommitted); this.bplEQPModel.Controls.Add(ctrlEQP); ctrlEQP.Dock = DockStyle.Fill; //SPC MODEL LEVEL을 가져옴 LinkedList llstCondtion = new LinkedList(); llstCondtion.Add(BISTel.eSPC.Common.Definition.CONDITION_KEY_CATEGORY, "SPC_ATT_MODEL_LEVEL"); llstCondtion.Add(BISTel.eSPC.Common.Definition.CONDITION_KEY_USE_YN, "Y"); DataSet dsModelLevel = _wsSPC.GetCodeData(llstCondtion.GetSerialData()); if (DSUtil.CheckRowCount(dsModelLevel)) { _sSPCModelLevel = dsModelLevel.Tables[0].Rows[0][BISTel.eSPC.Common.COLUMN.CODE].ToString(); } EESProgressBar.ShowProgress(this, this._mlthandler.GetMessage(Definition.LOADING_DATA), true); this._dsGroupList = _wsSPC.GetATTSPCModelGroupList(); EESProgressBar.CloseProgress(this); this._btreeComboEQP_SelectionCommitted(_btreeComboEQP, new EventArgs()); }
public void RefreshTreeView() { this.bTreeView1.Nodes.Clear(); if (string.IsNullOrEmpty(this.sEQPModel) && string.IsNullOrEmpty(this.sAreaRawID)) { return; } if (isATT) { BTreeNode node = TreeDCUtil.CreateBTreeNode(Definition.DynamicCondition_Search_key.PARAM_TYPE, "trs", "AttributeName"); node.Nodes.Add(BTreeView.CreateDummyNode()); this.bTreeView1.Nodes.Add(node); this.bTreeView1.ExpandAll(); } else { LinkedList llstCondition = new LinkedList(); if (isMET) { llstCondition.Add(Definition.CONDITION_KEY_CATEGORY, Definition.CODE_CATEGORY_MET_PARAM_TYPE); } else { llstCondition.Add(Definition.CONDITION_KEY_CATEGORY, Definition.CODE_CATEGORY_PARAM_TYPE); } DataSet ds = ws.GetCodeData(llstCondition.GetSerialData()); if (ds == null || ds.Tables[0].Rows.Count == 0) { return; } foreach (DataRow row in ds.Tables[0].Rows) { BTreeNode node = TreeDCUtil.CreateBTreeNode(Definition.DynamicCondition_Search_key.PARAM_TYPE, row["CODE"].ToString(), row["NAME"].ToString()); if (isMET) { node.Nodes.Add(BTreeView.CreateDummyNode()); this.bTreeView1.Nodes.Add(node); } else { if (node.Text != "METROLOGY") { node.Nodes.Add(BTreeView.CreateDummyNode()); this.bTreeView1.Nodes.Add(node); } } } } }
private void InitializeComboTree() { this.conditionComboTree1.CheckCountType = BTreeView.CheckCountTypes.Single; LinkedList llstCondition = new LinkedList(); if (this.GetType().FullName == "BISTel.eSPC.Condition.Compare.SPCModelCompareCondition") { llstCondition.Add(Definition.CONDITION_KEY_CATEGORY, "SPC_MODEL_LEVEL"); this.spcModelCompareConditionTree1.ISMET = false; } else if (this.GetType().FullName == "BISTel.eSPC.Condition.Compare.MET.SPCModelCompareCondition") { llstCondition.Add(Definition.CONDITION_KEY_CATEGORY, "SPC_MET_MODEL_LEVEL"); this.spcModelCompareConditionTree1.ISMET = true; } else if (this.GetType().FullName == "BISTel.eSPC.Condition.ATT.Compare.SPCModelCompareCondition") { llstCondition.Add(Definition.CONDITION_KEY_CATEGORY, "SPC_ATT_MODEL_LEVEL"); this.spcModelCompareConditionTree1.ISATT = true; } llstCondition.Add(Definition.CONDITION_KEY_USE_YN, "Y"); //llstCondition.Add(Definition.CONDITION_KEY_DEFAULT_COL, "Y"); DataSet ds = ws.GetCodeData(llstCondition.GetSerialData()); this.conditionComboTree1.AddVisibleLevel(ConditionLevel.SITE, false); this.conditionComboTree1.AddVisibleLevel(ConditionLevel.FAB, false); this.conditionComboTree1.AddVisibleLevel(ConditionLevel.LINE, false); if (ds != null && ds.Tables[0].Rows[0]["CODE"].ToString().ToUpper() == "AREA") { this.conditionComboTree1.Title = "AREA"; this.conditionComboTree1.AddVisibleLevel(ConditionLevel.AREA, true); } else { this.conditionComboTree1.Title = "EQP MODEL"; this.conditionComboTree1.AddVisibleLevel(ConditionLevel.AREA, false); this.conditionComboTree1.AddVisibleLevel(ConditionLevel.EQPMODEL, true); } }
private DataTable GetSPCModelList(LinkedList llCondition) { string sSite = string.Empty; string sFab = string.Empty; string sLineRawID = string.Empty; string sLine = string.Empty; string sAreaRawID = string.Empty; string sArea = string.Empty; string sEqpModel = string.Empty; string sParamAlias = string.Empty; string sParamTypeCd = string.Empty; string sSPC_MODEL_LEVEL = string.Empty; DataTable dtresult = null; DataSet dsData = null; try { LinkedList llstCondition = new LinkedList(); if (this.isMET) { llstCondition.Add(Definition.CONDITION_KEY_CATEGORY, "SPC_MET_MODEL_LEVEL"); } else { llstCondition.Add(Definition.CONDITION_KEY_CATEGORY, "SPC_MODEL_LEVEL"); } llstCondition.Add(Definition.CONDITION_KEY_USE_YN, "Y"); //llstCondition.Add(Definition.CONDITION_KEY_DEFAULT_COL, "Y"); DataSet ds = _ws.GetCodeData(llstCondition.GetSerialData()); if (ds != null && ds.Tables[0].Rows[0]["CODE"].ToString().ToUpper() == "AREA") { sSPC_MODEL_LEVEL = "AREA"; } else { sSPC_MODEL_LEVEL = "EQP MODEL"; } if (llCondition[Definition.DynamicCondition_Search_key.SITE] != null && ((DataTable)llCondition[Definition.DynamicCondition_Search_key.SITE]).Rows.Count > 0) { sSite = ((DataTable)llCondition[Definition.DynamicCondition_Search_key.SITE]).Rows[0][Definition.CONDITION_SEARCH_KEY_VALUEDATA].ToString(); } if (llCondition[Definition.DynamicCondition_Search_key.FAB] != null && ((DataTable)llCondition[Definition.DynamicCondition_Search_key.FAB]).Rows.Count > 0) { sFab = ((DataTable)llCondition[Definition.DynamicCondition_Search_key.FAB]).Rows[0][Definition.CONDITION_SEARCH_KEY_VALUEDATA].ToString(); } if (llCondition[Definition.DynamicCondition_Search_key.LINE] != null && ((DataTable)llCondition[Definition.DynamicCondition_Search_key.LINE]).Rows.Count > 0) { sLineRawID = ((DataTable)llCondition[Definition.DynamicCondition_Search_key.LINE]).Rows[0][Definition.CONDITION_SEARCH_KEY_VALUEDATA].ToString(); sLine = ((DataTable)llCondition[Definition.DynamicCondition_Search_key.LINE]).Rows[0][Definition.CONDITION_SEARCH_KEY_DISPLAYDATA].ToString(); } if (llCondition[Definition.DynamicCondition_Search_key.AREA] != null && ((DataTable)llCondition[Definition.DynamicCondition_Search_key.AREA]).Rows.Count > 0) { sAreaRawID = ((DataTable)llCondition[Definition.DynamicCondition_Search_key.AREA]).Rows[0][Definition.CONDITION_SEARCH_KEY_VALUEDATA].ToString(); sArea = ((DataTable)llCondition[Definition.DynamicCondition_Search_key.AREA]).Rows[0][Definition.CONDITION_SEARCH_KEY_VALUEDATA].ToString(); } if (llCondition[Definition.DynamicCondition_Search_key.EQPMODEL] != null && ((DataTable)llCondition[Definition.DynamicCondition_Search_key.EQPMODEL]).Rows.Count > 0) { sEqpModel = ((DataTable)llCondition[Definition.DynamicCondition_Search_key.EQPMODEL]).Rows[0][Definition.CONDITION_SEARCH_KEY_VALUEDATA].ToString(); } if (llCondition[Definition.DynamicCondition_Search_key.PARAM_ALIAS] != null && ((DataTable)llCondition[Definition.DynamicCondition_Search_key.PARAM_ALIAS]).Rows.Count > 0) { sParamAlias = ((DataTable)llCondition[Definition.DynamicCondition_Search_key.PARAM_ALIAS]).Rows[0][Definition.CONDITION_SEARCH_KEY_VALUEDATA].ToString(); } if (llCondition[Definition.DynamicCondition_Search_key.PARAM_TYPE] != null && ((DataTable)llCondition[Definition.DynamicCondition_Search_key.PARAM_TYPE]).Rows.Count > 0) { sParamTypeCd = ((DataTable)llCondition[Definition.DynamicCondition_Search_key.PARAM_TYPE]).Rows[0][Definition.CONDITION_SEARCH_KEY_VALUEDATA].ToString(); } if (string.IsNullOrEmpty(sLineRawID) || (sSPC_MODEL_LEVEL == "AREA" && string.IsNullOrEmpty(sAreaRawID)) || (sSPC_MODEL_LEVEL == "EQP MODEL" && string.IsNullOrEmpty(sEqpModel)) || string.IsNullOrEmpty(sParamAlias) || string.IsNullOrEmpty(sParamTypeCd)) { this.MsgClose(); MSGHandler.DisplayMessage(MSGType.Information, "SPC_INFO_SELECT_PARAM", null, null); return(null); } if (!this.ApplyAuthory(this.bbtnList, sSite, sFab, sLine, sAreaRawID)) { return(null); } EESProgressBar.ShowProgress(this, this._lang.GetMessage(Definition.LOADING_DATA), true); AsyncCallHandler ach = new AsyncCallHandler(EESProgressBar.AsyncCallManager); object objDataSet = ach.SendWait(_ws, "GetSPCModelList", new object[] { sLineRawID, sAreaRawID, sEqpModel, sParamAlias, sParamTypeCd, _bUseComma }); EESProgressBar.CloseProgress(this); //return this.controller.GetSPCModelList(sLineRawID, sAreaRawID, sEqpModel, sParamAlias, sParamTypeCd); if (objDataSet != null) { dsData = (DataSet)objDataSet; dtresult = MergeWithContextTable(dsData.Tables[TABLE.CHART_VW_SPC], dsData.Tables[TABLE.MODEL_CONTEXT_MST_SPC]); //SPC-941 by Louis this.controller.dtSPCModelList = dtresult; } else { MSGHandler.DisplayMessage(MSGType.Warning, MSGHandler.GetMessage("INFORMATION_NODATA")); } } 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); } //this.MsgClose(); LogHandler.ExceptionLogWrite(Definition.APPLICATION_NAME, ex); } finally { EESProgressBar.CloseProgress(this); } return(dtresult); }
public void InitializeCode() { //Select,Target,Step,Info,Item,SubData this.bSpreadSelect.ActiveSheet.RowCount = 0; this.bSpreadSelect.ActiveSheet.Columns.Count = 8; this.bSpreadSelect.AddHead(0, this._mlthandler.GetVariable(Definition.SpreadHeaderColKey.V_SELECT), "_SELECT", 50, 20, null, null, null, ColumnAttribute.Null, ColumnType.CheckBox, null, null, null, false, true); this.bSpreadSelect.AddHead(1, Definition.STEP_DATAMAPPING.BASE, Definition.STEP_DATAMAPPING.BASE, 50, 20, null, null, null, ColumnAttribute.Null, ColumnType.CheckBox, null, null, null, false, true); this.bSpreadSelect.AddHead(2, Definition.CHART_COLUMN.OPERATION_ID, Definition.STEP_DATAMAPPING.OPERATION_ID, 100, 20, null, null, null, ColumnAttribute.Null, ColumnType.Null, null, null, null, false, false); this.bSpreadSelect.AddHead(3, this._mlthandler.GetVariable(Definition.CHART_COLUMN.OPERATION_ID), Definition.STEP_DATAMAPPING.OPERATION_DESCRIPTION, 180, 20, null, null, null, ColumnAttribute.Null, ColumnType.Null, null, null, null, false, true); this.bSpreadSelect.AddHead(4, Definition.STEP_DATAMAPPING.INFORMATION, Definition.STEP_DATAMAPPING.INFORMATION, 150, 300, null, null, null, ColumnAttribute.Null, ColumnType.Null, null, null, null, false, true); this.bSpreadSelect.AddHead(5, Definition.STEP_DATAMAPPING.ITEM, Definition.STEP_DATAMAPPING.ITEM, 150, 300, null, null, null, ColumnAttribute.Null, ColumnType.Null, null, null, null, false, true); this.bSpreadSelect.AddHead(6, Definition.STEP_DATAMAPPING.SUBDATA, Definition.STEP_DATAMAPPING.SUBDATA, 150, 300, null, null, null, ColumnAttribute.Null, ColumnType.Null, null, null, null, false, true); this.bSpreadSelect.AddHead(7, Definition.STEP_DATAMAPPING.PROBE, Definition.STEP_DATAMAPPING.PROBE, 150, 300, null, null, null, ColumnAttribute.Null, ColumnType.Null, null, null, null, false, false); this.bSpreadSelect.AddHead(8, Definition.STEP_DATAMAPPING.TYPE, Definition.STEP_DATAMAPPING.TYPE, 150, 300, null, null, null, ColumnAttribute.Null, ColumnType.Null, null, null, null, false, false); this.bSpreadSelect.AddHeadComplete(); this.bSpreadSelect.DataSource = this.dtParam; //Probe 공정 this.PROC_ProbDataCall(); this._llstData.Clear(); if (brbtnMetrology.Checked == true) { this._llstData.Add(Definition.DynamicCondition_Condition_key.OPERATION_TYPE, "METROLOGY"); } else if (brbtnMain.Checked == true) { this._llstData.Add(Definition.DynamicCondition_Condition_key.OPERATION_TYPE, "PROCESSING"); } else //Default = Metrology { this._llstData.Add(Definition.DynamicCondition_Condition_key.OPERATION_TYPE, "METROLOGY"); } DataSet _ds = _wsSPC.GetOperationID(_llstData.GetSerialData()); if (!DataUtil.IsNullOrEmptyDataSet(_ds)) { DataTable dt = _ds.Tables[0]; if (!DataUtil.IsNullOrEmptyDataSet(this._dsProbeOperation)) { DataRow _dr = null; foreach (DataRow dr in _dsProbeOperation.Tables[0].Rows) { string sCode = dr[Definition.CHART_COLUMN.OPERATION_ID].ToString(); bool bContains = false; foreach (DataRow dRow in dt.Rows) { if (dRow[Definition.CHART_COLUMN.OPERATION_ID].ToString().Equals(sCode)) { bContains = true; break; } } if (!bContains) { _dr = dt.NewRow(); _dr[Definition.CHART_COLUMN.OPERATION_ID] = sCode; _dr[Definition.DynamicCondition_Condition_key.CODE_DESCRIPTION] = sCode + " " + dr[Definition.DynamicCondition_Condition_key.CODE_DESCRIPTION].ToString(); dt.Rows.Add(_dr); } } } this.bSpreadStepMet.ClearHead(); this.bSpreadStepMet.DataSource = null; this.bSpreadStepMet.ActiveSheet.RowCount = 0; this.bSpreadStepMet.ActiveSheet.Columns.Count = 3; this.bSpreadStepMet.AddHead(0, this._mlthandler.GetVariable(Definition.SpreadHeaderColKey.V_SELECT), "_SELECT", 50, 20, null, null, null, ColumnAttribute.Null, ColumnType.CheckBox, null, null, null, false, true); this.bSpreadStepMet.AddHead(1, Definition.CONDITION_KEY_CODE, Definition.CHART_COLUMN.OPERATION_ID, 50, 20, null, null, null, ColumnAttribute.Null, ColumnType.Null, null, null, null, false, false); this.bSpreadStepMet.AddHead(2, Definition.CONDITION_KEY_NAME, Definition.DynamicCondition_Condition_key.CODE_DESCRIPTION, 150, 300, null, null, null, ColumnAttribute.Null, ColumnType.Null, null, null, null, false, true); this.bSpreadStepMet.AddHeadComplete(); this.bSpreadStepMet.DataSource = dt; } this._llstData.Clear(); this._llstData.Add(Definition.CONDITION_KEY_CATEGORY, Definition.CODE_CATEGORY_SORTING_KEY); this._llstData.Add(Definition.CONDITION_KEY_USE_YN, "Y"); _ds = _wsSPC.GetCodeData(_llstData.GetSerialData()); if (!DataUtil.IsNullOrEmptyDataSet(_ds)) { this.bSpreadSorting.ClearHead(); this.bSpreadSorting.DataSource = null; this.bSpreadSorting.ActiveSheet.RowCount = 0; this.bSpreadSorting.ActiveSheet.Columns.Count = 3; this.bSpreadSorting.AddHead(0, this._mlthandler.GetVariable(Definition.SpreadHeaderColKey.V_SELECT), "_SELECT", 50, 20, null, null, null, ColumnAttribute.Null, ColumnType.CheckBox, null, null, null, false, true); this.bSpreadSorting.AddHead(1, Definition.CONDITION_KEY_CODE, Definition.CONDITION_KEY_CODE, 50, 20, null, null, null, ColumnAttribute.Null, ColumnType.Null, null, null, null, false, false); this.bSpreadSorting.AddHead(2, Definition.CONDITION_KEY_NAME, Definition.CONDITION_KEY_NAME, 80, 20, null, null, null, ColumnAttribute.Null, ColumnType.Null, null, null, null, false, true); this.bSpreadSorting.AddHeadComplete(); this.bSpreadSorting.DataSource = _ds; } }