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