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());
}
private void SelectEQPModel_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;
BISTel.eSPC.Page.eSPCWebService.eSPCWebService spcWebService = new WebServiceController <eSPCWebService.eSPCWebService>().Create();
//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");
//llstCondtion.Add(BISTel.eSPC.Common.Definition.CONDITION_KEY_DEFAULT_COL, "Y");
DataSet dsModelLevel = spcWebService.GetATTCodeData(llstCondtion.GetSerialData());
if (DSUtil.CheckRowCount(dsModelLevel))
{
_sSPCModelLevel = dsModelLevel.Tables[0].Rows[0][BISTel.eSPC.Common.COLUMN.CODE].ToString();
if (!_sSPCModelLevel.Equals(BISTel.eSPC.Common.Definition.CONDITION_KEY_EQP_MODEL))
{
this.btnIgnore.Text = "Use Current Area";
}
}
}
///
/// DC에서 설정된 값으로 만들어진 BTreeView 인스턴스를 받아서
/// 추가적으로 노드 혹은 이벤트를 연결한다.
///
///
public void SetDCTree(BTreeView btv)
{
this._spcWebService = new WebServiceController <eSPCWebService.eSPCWebService>().Create();
this._mlthandler = MultiLanguageHandler.getInstance();
_btvCondition = btv;
btv.RefreshNode += new BTreeView.RefreshNodeEventHandler(Tree_RefreshNode);
btv.AfterExpand += new TreeViewEventHandler(btv_AfterExpand);
btv.BeforeExpand += new TreeViewCancelEventHandler(Tree_BeforeExpand);
_btvCondition.ImageList.Images.AddRange(ImageLoaderHandler.Instance.TreeArrayImage);
// btv.CheckCountType = BTreeView.CheckCountTypes.Single;
//SPC MODEL LEVEL을 가져옴
LinkedList llstCondtion = new LinkedList();
llstCondtion.Add(Definition.CONDITION_KEY_CATEGORY, "SPC_MODEL_LEVEL");
llstCondtion.Add(Definition.CONDITION_KEY_USE_YN, "Y");
//llstCondtion.Add(Definition.CONDITION_KEY_DEFAULT_COL, "Y");
DataSet dsModelLevel = this._spcWebService.GetCodeData(llstCondtion.GetSerialData());
if (DSUtil.CheckRowCount(dsModelLevel))
{
this._sSPCModelLevel = dsModelLevel.Tables[0].Rows[0][COLUMN.CODE].ToString();
}
// _sSPCModelLevel = Definition.CONDITION_KEY_EQP_MODEL;
}
public void SetDCTree(BISTel.PeakPerformance.Client.BISTelControl.BTreeView btv)
{
this._spcWebService = new WebServiceController <eSPCWebService.eSPCWebService>().Create();
this._mlthandler = MultiLanguageHandler.getInstance();
//SPC MODEL LEVEL을 가져옴
LinkedList llstCondtion = new LinkedList();
if (this.GetType().FullName == "BISTel.eSPC.Condition.Controls.ComboTree.AreasComboTreeControl")
{
llstCondtion.Add(Definition.CONDITION_KEY_CATEGORY, "SPC_MODEL_LEVEL");
}
else if (this.GetType().FullName == "BISTel.eSPC.Condition.ATT.Controls.ComboTree.AreasComboTreeControl")
{
llstCondtion.Add(Definition.CONDITION_KEY_CATEGORY, "SPC_ATT_MODEL_LEVEL");
}
llstCondtion.Add(Definition.CONDITION_KEY_USE_YN, "Y");
//llstCondtion.Add(Definition.CONDITION_KEY_DEFAULT_COL, "Y");
DataSet dsModelLevel = this._spcWebService.GetCodeData(llstCondtion.GetSerialData());
if (DSUtil.CheckRowCount(dsModelLevel))
{
this._sSPCModelLevel = dsModelLevel.Tables[0].Rows[0][COLUMN.CODE].ToString();
}
//_sSPCModelLevel = Definition.CONDITION_KEY_EQP_MODEL;
_btvCondition = btv;
//_btvCondition.CheckCountType = BTreeView.CheckCountTypes.SingleByNode;
btv.BeforeExpand += new TreeViewCancelEventHandler(Tree_BeforeExpand);
btv.RefreshNode += new BTreeView.RefreshNodeEventHandler(Tree_RefreshNode);
btv.AfterExpand += new TreeViewEventHandler(btv_AfterExpand);
//modified by enkim SPC-599 -- change area multi --> check processcapabilitydata.cs(appliauthority[syntax error])
//if (this._sSPCModelLevel.Equals(Definition.CONDITION_KEY_EQP_MODEL))
//{
btv.CheckCountType = BTreeView.CheckCountTypes.Single;
//}
//else
//{
//btv.CheckCountType = BTreeView.CheckCountTypes.Multi;
//}
//modified end SPC-599
_btvCondition.ImageList.Images.AddRange(ImageLoaderHandler.Instance.TreeArrayImage);
_btvCondition.AddImageForLevel(0, _btvCondition.ImageList.Images[0], _btvCondition.ImageList.Images[0]);
_btvCondition.AddImageForLevel(1, _btvCondition.ImageList.Images[1], _btvCondition.ImageList.Images[1]);
_btvCondition.AddImageForLevel(2, _btvCondition.ImageList.Images[2], _btvCondition.ImageList.Images[2]);
_btvCondition.AddImageForLevel(3, _btvCondition.ImageList.Images[3], _btvCondition.ImageList.Images[3]);
if (this._sSPCModelLevel.Equals(Definition.CONDITION_KEY_EQP_MODEL))
{
_btvCondition.AddImageForLevel(4, _btvCondition.ImageList.Images[4], _btvCondition.ImageList.Images[4]);
}
}
public DataSet getDataSetDATA_TRX_Data(DataSet dsData)
{
DataSet dsRetrun = new DataSet();
try
{
if (DSUtil.CheckRowCount(dsData))
{
BISTel.PeakPerformance.Client.CommonUtil.GZip gZip = new BISTel.PeakPerformance.Client.CommonUtil.GZip();
string module_id = string.Empty;
string module_alias = string.Empty;
foreach (DataRow drData in dsData.Tables[0].Rows)
{
using (StreamReader sr = gZip.DecompressForStream(drData["DATA_FILE"]))
{
this.ParseHeader(sr);
_llstLineInfo = this.ParseContextLineInfo(sr, arrLineInfo);
_llstParamName = this.ParseContextLineInfo(sr, arrLineInfo);
//this.ParseContextLineInfo(sr);
//switch (ParseType)
//{
// default:
// break;
//}
}
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex);
LogHandler.ExceptionLogWrite(Definition.APPLICATION_NAME, ex);
}
return(dsRetrun);
}
public ContextCondition()
{
this._wsSPC = new WebServiceController <eSPCWebService.eSPCWebService>().Create();
this._comUtil = new CommonUtility();
InitializeComponent();
this.bcboModuleID.DropDownWidth = 300;
LinkedList llstCondtion = new LinkedList();
llstCondtion.Add(Definition.CONDITION_KEY_CATEGORY, "SPC_MODEL_LEVEL");
llstCondtion.Add(Definition.CONDITION_KEY_USE_YN, "Y");
//llstCondtion.Add(Definition.CONDITION_KEY_DEFAULT_COL, "Y");
DataSet dsModelLevel = this._wsSPC.GetCodeData(llstCondtion.GetSerialData());
if (DSUtil.CheckRowCount(dsModelLevel))
{
this._sSPCModelLevel = dsModelLevel.Tables[0].Rows[0][COLUMN.CODE].ToString();
}
}
private void ConfigListDataBinding(string _sSPCModelRawid)
{
try
{
LinkedList _llstSearchCondition = new LinkedList();
DataSet _dsSPCModeData = new DataSet();
string strParamAlias = "";
//초기화
_llstSearchCondition.Clear();
_llstSearchCondition.Add(Definition.CONDITION_KEY_MODEL_RAWID, _sSPCModelRawid);
EESProgressBar.ShowProgress(this, this._mlthandler.GetMessage(Definition.LOADING_DATA), true);
AsyncCallHandler ach = new AsyncCallHandler(EESProgressBar.AsyncCallManager);
object objDataSet = ach.SendWait(_ws, "GetSPCModelData", new object[] { _llstSearchCondition.GetSerialData() });
EESProgressBar.CloseProgress(this);
//
if (objDataSet != null)
{
_dsSPCModeData = (DataSet)objDataSet;
}
else
{
MSGHandler.DisplayMessage(MSGType.Warning, MSGHandler.GetMessage("INFORMATION_NODATA"));
return;
}
if (!DSUtil.CheckRowCount(_dsSPCModeData, TABLE.MODEL_MST_SPC))
{
MSGHandler.DisplayMessage(MSGType.Information, "SPC_INFO_MODEL_ELIMINATED", null, null);
return;
}
DataTable dtConfig = _dsSPCModeData.Tables[TABLE.MODEL_CONFIG_MST_SPC];
DataTable dtContext = _dsSPCModeData.Tables[TABLE.MODEL_CONTEXT_MST_SPC];
DataTable dtRuleMst = _dsSPCModeData.Tables[TABLE.MODEL_RULE_MST_SPC];
EESProgressBar.ShowProgress(this, MSGHandler.GetMessage("PROCESS_LOADING_PAGE_DATA"), false);
DataTable dtSPCModelChartList = new DataTable();
dtSPCModelChartList.Columns.Add(COLUMN.SELECT, typeof(Boolean));
dtSPCModelChartList.Columns.Add(COLUMN.CHART_ID);
dtSPCModelChartList.Columns.Add(COLUMN.PARAM_ALIAS);
dtSPCModelChartList.Columns.Add(COLUMN.MAIN_YN);
dtSPCModelChartList.Columns.Add(COLUMN.VERSION);
dtSPCModelChartList.Columns.Add("MODE");
//CONTEXT COLUMN 생성
DataRow[] drConfigs = dtConfig.Select(COLUMN.MAIN_YN + " = 'Y'", COLUMN.RAWID);
if (drConfigs != null && drConfigs.Length > 0)
{
DataRow[] drMainContexts = dtContext.Select(string.Format("{0} = '{1}'", COLUMN.MODEL_CONFIG_RAWID, drConfigs[0][COLUMN.RAWID]), COLUMN.KEY_ORDER);
foreach (DataRow drMainContext in drMainContexts)
{
dtSPCModelChartList.Columns.Add(drMainContext["CONTEXT_KEY_NAME"].ToString());
}
}
LinkedList llCondition = new LinkedList();
llCondition.Add(Definition.CONDITION_KEY_CATEGORY, Definition.CODE_CATEGORY_CHART_MODE);
DataSet _dsChartMode = this._ws.GetCodeData(llCondition.GetSerialData());
Dictionary <string, string> modeCodeData = new Dictionary <string, string>();
if (_dsChartMode != null && _dsChartMode.Tables.Count > 0)
{
foreach (DataRow dr in _dsChartMode.Tables[0].Rows)
{
modeCodeData.Add(dr[COLUMN.CODE].ToString(), dr[COLUMN.NAME].ToString());
}
}
foreach (DataRow drConfig in dtConfig.Rows)
{
DataRow drChartList = dtSPCModelChartList.NewRow();
drChartList[COLUMN.CHART_ID] = drConfig[COLUMN.RAWID].ToString();
drChartList[COLUMN.PARAM_ALIAS] = drConfig[COLUMN.PARAM_ALIAS].ToString();
drChartList[COLUMN.MAIN_YN] = drConfig[COLUMN.MAIN_YN].ToString();
//#Version이 Null 또는 Empty인 경우 대비 Check Logic 추가
if (!string.IsNullOrEmpty(drConfig[COLUMN.VERSION].ToString()))
{
drChartList[COLUMN.VERSION] = (1 + Convert.ToDouble(drConfig[COLUMN.VERSION].ToString()) / 100).ToString("N2");
}
string modeValue = drConfig[COLUMN.CHART_MODE_CD].ToString();
if (modeCodeData.ContainsKey(modeValue))
{
modeValue = modeCodeData[modeValue];
}
drChartList["MODE"] = modeValue;
if (strParamAlias == "")
{
strParamAlias = drConfig[COLUMN.PARAM_ALIAS].ToString();
}
DataRow[] drContexts = dtContext.Select(string.Format("{0} = '{1}'", COLUMN.MODEL_CONFIG_RAWID, drConfig[COLUMN.RAWID]));
foreach (DataRow drContext in drContexts)
{
//2009-11-27 bskwon 추가 : Sub Model 상속 구조가 아닌경우 예외처리
if (!dtSPCModelChartList.Columns.Contains(drContext["CONTEXT_KEY_NAME"].ToString()))
{
dtSPCModelChartList.Columns.Add(drContext["CONTEXT_KEY_NAME"].ToString());
}
drChartList[drContext["CONTEXT_KEY_NAME"].ToString()] = drContext[COLUMN.CONTEXT_VALUE].ToString();
}
dtSPCModelChartList.Rows.Add(drChartList);
}
dtSPCModelChartList.AcceptChanges();
bsprData.ClearHead();
bsprData.UseEdit = true;
bsprData.UseHeadColor = true;
bsprData.Locked = true;
for (int i = 0; i < dtSPCModelChartList.Columns.Count; i++)
{
string sColumn = dtSPCModelChartList.Columns[i].ColumnName.ToString();
if (i == 0)
{
this.bsprData.AddHead(i, sColumn, sColumn, 50, 20, null, null, null, ColumnAttribute.Null,
ColumnType.CheckBox, null, null, null, false, true);
}
else
{
this.bsprData.AddHead(i, sColumn, sColumn, 100, 20, null, null, null, ColumnAttribute.Null,
ColumnType.Null, null, null, null, false, true);
}
}
this.bsprData.AddHeadComplete();
this.bsprData.DataSet = dtSPCModelChartList;
this.bsprData.Locked = true;
this.bsprData.ActiveSheet.Columns[0].Locked = false;
this.bsprData.ActiveSheet.Columns[2].Visible = false;
this.bsprData.AllowNewRow = false;
FarPoint.Win.Spread.CellType.TextCellType tc = new FarPoint.Win.Spread.CellType.TextCellType();
tc.MaxLength = 1024;
//Column Size 조절
for (int cIdx = 0; cIdx < this.bsprData.ActiveSheet.Columns.Count; cIdx++)
{
this.bsprData.ActiveSheet.Columns[cIdx].Width = this.bsprData.ActiveSheet.Columns[cIdx].GetPreferredWidth();
if (this.bsprData.ActiveSheet.Columns[cIdx].Width > 150)
{
this.bsprData.ActiveSheet.Columns[cIdx].Width = 150;
}
if (this.bsprData.ActiveSheet.Columns[cIdx].CellType != null &&
this.bsprData.ActiveSheet.Columns[cIdx].CellType.GetType() == typeof(FarPoint.Win.Spread.CellType.TextCellType))
{
this.bsprData.ActiveSheet.Columns[cIdx].CellType = tc;
}
}
//MAIN은 첫번째 ROW에 배치하고 ROW HIGHLIGHT
if (this.bsprData.GetCellText(0, 3).Equals("Y"))
{
this.bsprData.ActiveSheet.Rows[0].BackColor = Color.LightGreen; //Color.LemonChiffon;
}
this.bsprData.LeaveCellAction();
}
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);
}
LogHandler.ExceptionLogWrite(Definition.APPLICATION_NAME, ex);
}
finally
{
EESProgressBar.CloseProgress(this);
}
}
private void ConfigListDataBinding()
{
string strParamAlias = "";
//초기화
_llstSearchCondition.Clear();
_llstSearchCondition.Add(Definition.CONDITION_KEY_MODEL_RAWID, this._sSPCModelRawid);
_llstSearchCondition.Add(Definition.VARIABLE_USE_COMMA, _bUseComma);
_dsSPCModeData = _wsSPC.GetSPCModelData(_llstSearchCondition.GetSerialData());
this._dsSPCProductData = _wsSPC.GetProductIDMappingData();
if (!DSUtil.CheckRowCount(_dsSPCModeData, TABLE.MODEL_MST_SPC))
{
MSGHandler.DisplayMessage(MSGType.Information, "SPC_INFO_ALREADY_ELIMINATED", new string[] { _sSPCModelName }, null);
return;
}
DataTable dtConfig = _dsSPCModeData.Tables[TABLE.MODEL_CONFIG_MST_SPC];
DataTable dtContext = _dsSPCModeData.Tables[TABLE.MODEL_CONTEXT_MST_SPC];
DataTable dtRuleMst = _dsSPCModeData.Tables[TABLE.MODEL_RULE_MST_SPC];
//#01. SPC Model Chart List를 위한 Datatable 생성
DataTable dtSPCModelChartList = new DataTable();
dtSPCModelChartList.Columns.Add(COLUMN.RAWID);
dtSPCModelChartList.Columns.Add(COLUMN.PARAM_ALIAS);
dtSPCModelChartList.Columns.Add(COLUMN.MAIN_YN);
//CONTEXT COLUMN 생성
DataRow[] drConfigs = dtConfig.Select(COLUMN.MAIN_YN + " = 'Y'", COLUMN.RAWID);
if (drConfigs != null && drConfigs.Length > 0)
{
DataRow[] drMainContexts = dtContext.Select(string.Format("{0} = '{1}'", COLUMN.MODEL_CONFIG_RAWID, drConfigs[0][COLUMN.RAWID]), COLUMN.KEY_ORDER);
foreach (DataRow drMainContext in drMainContexts)
{
dtSPCModelChartList.Columns.Add(drMainContext["CONTEXT_KEY_NAME"].ToString());
}
}
//2009-12-08 dkshin 추가 : CREATE_BY, CREATE_TIME COLUMN
dtSPCModelChartList.Columns.Add(COLUMN.CREATE_BY);
dtSPCModelChartList.Columns.Add(COLUMN.CREATE_DTTS);
//#02. CONFIG MST에 생성된 CONTEXT COLUMN에 Data 입력
foreach (DataRow drConfig in dtConfig.Rows)
{
DataRow drChartList = dtSPCModelChartList.NewRow();
drChartList[COLUMN.RAWID] = drConfig[COLUMN.RAWID].ToString();
drChartList[COLUMN.PARAM_ALIAS] = drConfig[COLUMN.PARAM_ALIAS].ToString();
drChartList[COLUMN.MAIN_YN] = drConfig[COLUMN.MAIN_YN].ToString();
if (strParamAlias == "")
{
strParamAlias = drConfig[COLUMN.PARAM_ALIAS].ToString();
}
DataRow[] drContexts = dtContext.Select(string.Format("{0} = '{1}'", COLUMN.MODEL_CONFIG_RAWID, drConfig[COLUMN.RAWID]));
foreach (DataRow drContext in drContexts)
{
//2009-11-27 bskwon 추가 : Sub Model 상속 구조가 아닌경우 예외처리
if (!dtSPCModelChartList.Columns.Contains(drContext["CONTEXT_KEY_NAME"].ToString()))
{
dtSPCModelChartList.Columns.Add(drContext["CONTEXT_KEY_NAME"].ToString());
}
drChartList[drContext["CONTEXT_KEY_NAME"].ToString()] = drContext[COLUMN.CONTEXT_VALUE].ToString();
}
//MODEL 정보
drChartList[COLUMN.CREATE_BY] = drConfig[COLUMN.CREATE_BY].ToString();
drChartList[COLUMN.CREATE_DTTS] = drConfig[COLUMN.CREATE_DTTS] == DBNull.Value ? null : DateTime.Parse(drConfig[COLUMN.CREATE_DTTS].ToString()).ToString(Definition.DATETIME_FORMAT_MS).ToString();
dtSPCModelChartList.Rows.Add(drChartList);
}
dtSPCModelChartList.AcceptChanges();
this.bsprData.DataSet = dtSPCModelChartList;
for (int cIdx = 0; cIdx < this.bsprData.ActiveSheet.Columns.Count; cIdx++)
{
this.bsprData.ActiveSheet.Columns[cIdx].Width = this.bsprData.ActiveSheet.Columns[cIdx].GetPreferredWidth();
}
this.bsprProductData.DataSource = this._dsSPCProductData;
for (int i = 0; i < this._dsSPCProductData.Tables[0].Rows.Count; i++)
{
this.srtLstProductID.Add(this._dsSPCProductData.Tables[0].Rows[i][0].ToString(), this._dsSPCProductData.Tables[0].Rows[i][1].ToString());
}
this.bsprData.Locked = true;
this.bsprProductData.Locked = true;
}