public static void AddDataToComboBox(ComboBoxEdit control, IExperimentResultItem result, string tableName, string colName, bool addALL = true)
{
var dtable = result.LoadInput(tableName, null);
var datas = Distinct(dtable, colName, "");
foreach (string data in datas)
{
if (control.Properties.Items.Contains(data) == false)
{
control.Properties.Items.Add(data);
}
}
if (addALL)
{
control.Properties.Items.Insert(0, Consts.ALL);
}
if (control.Properties.Items.Count > 0)
{
control.SelectedIndex = 0;
}
control.Properties.TextEditStyle = TextEditStyles.DisableTextEditor;
}
protected DataView GetPlanData()
{
var loadHistDt = _result.LoadOutput(EqpGanttChartData.LOAD_HIST_TABLE_NAME);
string targetShopID = this.TargetShopID;
string filter = string.Empty;
if (targetShopID.Equals(Consts.ALL) == false)
{
string str = StringHelper.Equals(targetShopID, "ARRAY") ? "({0} = '{1}' OR {0} = 'CF')" : "({0} = '{1}')";
filter = string.Format(str, EqpGanttChartData.LoadingHistory.Schema.SHOP_ID, targetShopID);
}
string eqpGrpFilter = string.Empty;
if (this.SelectedEqpGroups.Count > 0)
{
foreach (string eqpGrpID in this.SelectedEqpGroups)
{
eqpGrpFilter = eqpGrpFilter == string.Empty ?
string.Format("{0} = '{1}'", EqpGanttChartData.LoadingHistory.Schema.EQP_GROUP_ID, eqpGrpID)
: eqpGrpFilter = eqpGrpFilter + string.Format(" OR {0} = '{1}'"
, EqpGanttChartData.LoadingHistory.Schema.EQP_GROUP_ID, eqpGrpID);
}
}
eqpGrpFilter = eqpGrpFilter == string.Empty ? eqpGrpFilter : filter + " AND (" + eqpGrpFilter + ")";
DataTable dtEqp = _result.LoadInput(EqpGanttChartData.EQP_TABLE_NAME, eqpGrpFilter);
string eqpFilter = string.Empty;
if (dtEqp != null)
{
foreach (DataRow drow in dtEqp.Rows)
{
string eqpID = drow.GetString("EQP_ID");
eqpFilter = eqpFilter == string.Empty ?
string.Format("{0} = '{1}'", EqpGanttChartData.LoadingHistory.Schema.EQP_ID, eqpID)
: eqpFilter = eqpFilter + string.Format(" OR {0} = '{1}'", EqpGanttChartData.LoadingHistory.Schema.EQP_ID, eqpID);
}
}
if (string.IsNullOrEmpty(eqpFilter))
{
eqpFilter = string.Format("{0} = 'NULL'", EqpGanttChartData.LoadingHistory.Schema.EQP_ID);
}
filter = filter + " AND (" + eqpFilter + ")";
string sorter = string.Format("{0},{1}", ColName.EqpID, ColName.TargetDate);
DataView dv = new DataView(loadHistDt, filter, sorter, DataViewRowState.CurrentRows);
return(dv);
}
private void InitializeData()
{
//var modelContext = _result.GetCtx<ModelDataContext>();
base.SetWaitDialogCaption(EqpArrProductAnalViewData.EQP_ARRANGE_DT);
_dtEqpArrange = _result.LoadInput(EqpArrProductAnalViewData.EQP_ARRANGE_DT);
base.SetWaitDialogCaption(EqpArrProductAnalViewData.STD_STEP_DT);
_dtStdStep = _result.LoadInput(EqpArrProductAnalViewData.STD_STEP_DT);
var modelContext = this._result.GetCtx <ModelDataContext>();
_prodTypeDic = new Dictionary <string, string>();
foreach (var row in modelContext.Product)
{
if (_prodTypeDic.ContainsKey(row.SHOP_ID + row.PRODUCT_ID) == false)
{
_prodTypeDic.Add(row.SHOP_ID + row.PRODUCT_ID /*+ row.PRODUCT_VERSION*/, row.PRODUCT_TYPE);
}
}
}
private void SetControl()
{
#region Product Group
_prodGroupDict = new Dictionary <string, List <string> >();
DataTable prodTable = _result.LoadInput(JobChangePlanData.PRODUCT_DATA_TABLE);
foreach (DataRow pRow in prodTable.Rows)
{
JobChangePlanData.Product prod = new JobChangePlanData.Product(pRow);
if (prod.ProductGroup == "BARE")
{
continue;
}
List <string> prodList;
if (_prodGroupDict.TryGetValue(prod.ProductGroup, out prodList) == false)
{
prodList = new List <string>();
_prodGroupDict.Add(prod.ProductGroup, prodList);
}
if (!prodList.Contains(prod.ProductID))
{
prodList.Add(prod.ProductID);
}
}
foreach (string prodGrp in _prodGroupDict.Keys)
{
this.prodGrpCombo.Items.Add(prodGrp);
}
this.prodGrpCombo.SelectedIndex = 0;
UpdateProductList();
#endregion
}
public static EntityTable <T> GetEntityTable <T>(this IExperimentResultItem result, string key, string filter = "") where T : IEntityObject
{
IEnumerable <T> item;
try
{
item = result.LoadOutput <T>(key, filter);
}
catch
{
item = result.LoadInput <T>(key, filter);
return(item.ToEntityTable());
}
return(item.ToEntityTable());
}
private void SetProductCombo()
{
this.productCombo.Properties.Items.Clear();
DataTable productTable = _result.LoadInput(TargetPlanCompareData.DATA_TABLE_0);
List <string> products = new List <string>();
foreach (DataRow prow in productTable.Rows)
{
TargetPlanCompareData.Product prod = new TargetPlanCompareData.Product(prow);
if (this.TargetShopID != "ALL")
{
if (StringHelper.Equals(this.TargetShopID, prod.ShopID) == false)
{
continue;
}
}
if (!products.Contains(prod.ProductID))
{
products.Add(prod.ProductID);
}
string key = prod.ShopID + prod.ProductID;
if (!_productDict.Keys.Contains(key))
{
_productDict.Add(key, prod.ProductID);
}
}
products.Sort();
foreach (string product in products)
{
this.productCombo.Properties.Items.Add(product);
}
if (this.productCombo.Properties.Items.Count > 0)
{
foreach (CheckedListBoxItem item in productCombo.Properties.Items)
{
item.CheckState = CheckState.Checked;
}
}
}
internal void LoadEqp(IExperimentResultItem result)
{
this.Table = result.LoadInput(EqpGanttChartData.EQP_TABLE_NAME);
var dt = this.Table;
if (dt != null)
{
foreach (DataRow srow in dt.Rows)
{
Eqp eqp = new Eqp(srow);
this.AddEqps(eqp);
}
}
SetDspEqpGroupSeq(result);
}
private void InitializeData()
{
var item = (IMenuDocItem)this.Document.ProjectItem;
_result = (IExperimentResultItem)item.Arguments[0];
Globals.InitFactoryTime(_result.Model);
//base.SetWaitDialogCaption(DataConsts.In_StdStep);
//_dtStdStep = _result.LoadInput(DataConsts.In_StdStep);
base.SetWaitDialogCaption(EuData.DATA_TABLE_1);
_dtEquipment = _result.LoadInput(EuData.DATA_TABLE_1);
base.SetWaitDialogCaption(EuData.DATA_TABLE_2);
_dtLoadStat = _result.LoadOutput(EuData.DATA_TABLE_2);
}
private void LoadBaseData()
{
_dtEqpPlan = _result.LoadOutput(LotGanttChartData.EQP_PLAN_TABLE_NAME);
_productKindDict = new Dictionary <string, string>();
DataTable dt = _result.LoadInput(EqpGanttChartData.PRODUCT_TABLE_NAME);
foreach (DataRow row in dt.Rows)
{
LotGanttChartData.Product prod = new LotGanttChartData.Product(row);
string key = prod.LineID + prod.ProductID;
if (!_productKindDict.Keys.Contains(key))
{
_productKindDict.Add(key, prod.ProductKind);
}
}
}
private void InitializeData()
{
_dtStepMove = _result.LoadOutput(SimResultData.OutputName.StepMove);
//_dtStepMoveAct = _result.LoadInput(SimInputData.InputName.StepMoveAct);
_eqpGrpDic = new Dictionary <string, string>();
DataTable dtEqp = _result.LoadInput(SimInputData.InputName.Eqp);
foreach (DataRow dRow in dtEqp.Rows)
{
SimInputData.Eqp eqp = new SimInputData.Eqp(dRow);
if (_eqpGrpDic.ContainsKey(eqp.ShopID + eqp.EqpID) == false)
{
_eqpGrpDic.Add(eqp.ShopID + eqp.EqpID, eqp.EqpGroupID);
}
}
}
private void SetData()
{
#region Target Shift Range 생성
// TARGET SHIFT List 생성
_targetShiftList = new List <string>();
DateTime startTime = _result.StartTime;
int shiftEndCount = Convert.ToInt32(this.endCountPicker.Value);
startTime = this.startDatePicker.DateTime;
for (int i = 0; i < shiftEndCount; i++)
{
string shift = startTime.AddHours(i * ShopCalendar.ShiftHours).ToString("yyyy-MM-dd HH");
_targetShiftList.Add(shift);
}
_targetShiftList.Sort();
_targetShiftList.Insert(0, BalanceTableViewData.INITIAL_SHIFT);
#endregion
#region InnerBom
_resultDict = new Dictionary <string, CellInfo>();
_bomDict = new Dictionary <string, string>();
_bomReverseDict = new Dictionary <string, string>();
string filter = string.Format("STEP_ID = '{0}' OR STEP_ID = '{1}'", BalanceTableViewData.NEXT_STEP, BalanceTableViewData.CELL_STEP);
DataTable innerBomTable = _result.LoadInput(BalanceTableViewData.INNER_BOM_DATA_TABLE, filter);
foreach (DataRow iRow in innerBomTable.Rows)
{
BalanceTableViewData.InnerBom bom = new BalanceTableViewData.InnerBom(iRow);
if (bom.StepID == BalanceTableViewData.NEXT_STEP)
{
CellInfo cinfo;
if (_resultDict.TryGetValue(bom.ToProductID, out cinfo) == false)
{
cinfo = new CellInfo(bom.ToProductID);
_resultDict.Add(bom.ToProductID, cinfo);
}
if (bom.FromProductID.StartsWith("C"))
{
cinfo.CFProductID = bom.FromProductID;
}
else if (bom.FromProductID.StartsWith("T"))
{
cinfo.TFProductID = bom.FromProductID;
}
else
{
continue;
}
if (cinfo.QtyDict == null)
{
cinfo.InitDict(_targetShiftList);
}
}
if (!_bomDict.Keys.Contains(bom.FromProductID))
{
_bomDict.Add(bom.FromProductID, bom.ToProductID);
}
}
#endregion
#region Demand
DataTable demandTable = _result.LoadInput(BalanceTableViewData.DEMAND_DATA_TABLE);
_demandList = new List <string>();
foreach (DataRow dRow in demandTable.Rows)
{
BalanceTableViewData.Demand demand = new BalanceTableViewData.Demand(dRow);
if (_demandList.Contains(demand.ProductID) == false)
{
_demandList.Add(demand.ProductID);
}
}
#endregion
_categories = new List <string>();
_categories.Add(CellInfo.TFT_DONE);
_categories.Add(CellInfo.TFT_WIP);
_categories.Add(CellInfo.CF_DONE);
_categories.Add(CellInfo.CF_WIP);
_categories.Add(CellInfo.CELL_IN_TARGET);
_categories.Add(CellInfo.CELL_IN_PLAN);
_categories.Add(CellInfo.CELL_IN_BALANCE);
_categories.Add(CellInfo.CELL_OUT_TARGET);
_categories.Add(CellInfo.CELL_OUT_PLAN);
_categories.Add(CellInfo.CELL_OUT_BALANCE);
}
private void InitializeControl()
{
var modelContext = this._result.GetCtx <ModelDataContext>();
// ShopID ComboBox
ComboHelper.AddDataToComboBox(this.shopIdComboBoxEdit, _result,
SimInputData.InputName.StdStep, SimInputData.StdStepSchema.SHOP_ID, false);
if (this.shopIdComboBoxEdit.Properties.Items.Contains("ARRAY"))
{
this.shopIdComboBoxEdit.SelectedIndex = this.shopIdComboBoxEdit.Properties.Items.IndexOf("ARRAY");
}
// Area CheckComboBox
_eqpGrpsInAreaDic = new Dictionary <string, List <string> >();
string filter = string.Format("{0} = '{1}'", SimInputData.ConstSchema.CATEGORY, "AREA_INFO");
DataTable dtConst = _result.LoadInput(SimInputData.InputName.Const, filter);
if (dtConst != null)
{
List <string> eqpGrpsAllInAreaList = new List <string>();
foreach (DataRow drow in dtConst.Rows)
{
SimInputData.Const configConst = new SimInputData.Const(drow);
if (this.areaChkBoxEdit.Properties.Items.Contains(configConst.Code) == false)
{
this.areaChkBoxEdit.Properties.Items.Add(configConst.Code);
}
string[] eqpGrps = configConst.Description.Split('@');
foreach (string eqpGrp in eqpGrps)
{
if (eqpGrpsAllInAreaList.Contains(eqpGrp) == false)
{
eqpGrpsAllInAreaList.Add(eqpGrp);
}
List <string> eqpGrpList;
if (_eqpGrpsInAreaDic.TryGetValue(configConst.Code, out eqpGrpList) == false)
{
_eqpGrpsInAreaDic.Add(configConst.Code, eqpGrpList = new List <string>());
}
if (eqpGrpList.Contains(eqpGrp) == false)
{
eqpGrpList.Add(eqpGrp);
}
}
}
if (this.areaChkBoxEdit.Properties.Items.Contains("OTHERS") == false)
{
this.areaChkBoxEdit.Properties.Items.Add("OTHERS");
}
var eqpGrpInEqpList = modelContext.Eqp.Select(x => x.DSP_EQP_GROUP_ID).Distinct();
foreach (var eqpGrp in eqpGrpInEqpList)
{
if (eqpGrpsAllInAreaList.Contains(eqpGrp) == false)
{
List <string> eqpGrpList;
if (_eqpGrpsInAreaDic.TryGetValue("OTHERS", out eqpGrpList) == false)
{
_eqpGrpsInAreaDic.Add("OTHERS", eqpGrpList = new List <string>());
}
if (eqpGrpList.Contains(eqpGrp) == false)
{
eqpGrpList.Add(eqpGrp);
}
}
}
}
if (this.areaChkBoxEdit.Properties.Items.Count > 0)
{
this.areaChkBoxEdit.CheckAll();
}
_eqpGrpInEqpDic = new Dictionary <string, string>();
_eqpListbyEqpGrpDic = new Dictionary <string, List <string> >();
foreach (var row in modelContext.Eqp)
{
if (_eqpGrpInEqpDic.ContainsKey(row.SHOP_ID + row.EQP_ID) == false)
{
_eqpGrpInEqpDic.Add(row.SHOP_ID + row.EQP_ID, row.DSP_EQP_GROUP_ID);
}
List <string> eqpList;
if (_eqpListbyEqpGrpDic.TryGetValue(row.SHOP_ID + row.DSP_EQP_GROUP_ID, out eqpList) == false)
{
_eqpListbyEqpGrpDic.Add(row.SHOP_ID + row.DSP_EQP_GROUP_ID, eqpList = new List <string>());
}
if (eqpList.Contains(row.EQP_ID) == false)
{
eqpList.Add(row.EQP_ID);
}
}
// EqpGroup CheckComboBox
SetEqpGroupCheckBox();
//DateEdit Controls
this.fromDateEdit.DateTime = ShopCalendar.SplitDate(_planStartTime);
ComboHelper.ShiftName(this.shiftComboBoxEdit, _planStartTime);
dayShiftSpinEdit.Value = 1; // _result.GetPlanPeriod(1);
}