/// <summary>
/// cdvFactory_ValueSelectedItemChanged
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void cdvFactory_ValueSelectedItemChanged(object sender, MCCodeViewSelChanged_EventArgs e)
{
this.SetFactory(cdvFactory.txtValue);
this.cdvTeam.sFactory = cdvFactory.txtValue;
string strQuery = string.Empty;
strQuery += "SELECT KEY_1 CODE, DATA_1 DATA" + "\n";
strQuery += " FROM MGCMTBLDAT " + "\n";
strQuery += " WHERE FACTORY " + cdvFactory.SelectedValueToQueryString + "\n";
strQuery += " AND TABLE_NAME = 'H_DEPARTMENT' " + "\n";
strQuery += " AND KEY_1 IN ('650','660')" + "\n";
strQuery += " UNION ALL" + "\n";
strQuery += " SELECT 'A0000' CODE, '투입대기' DATA FROM DUAL" + "\n";
strQuery += " UNION ALL" + "\n";
strQuery += " SELECT 'A0800' CODE, 'IVI Gate' DATA FROM DUAL" + "\n";
strQuery += " UNION ALL" + "\n";
strQuery += " SELECT 'AZ010' CODE, '출하대기' DATA FROM DUAL" + "\n";
strQuery += "ORDER BY DATA, CODE " + "\n";
System.Windows.Forms.Clipboard.SetText(strQuery.ToString());
if (cdvFactory.txtValue != "")
{
cdvTeam.sDynamicQuery = strQuery;
}
else
{
cdvTeam.sDynamicQuery = "";
}
}
private void cdvFactory_ValueSelectedItemChanged(object sender, MCCodeViewSelChanged_EventArgs e)
{
if (cdvFactory.txtValue.Equals("HMKB1"))
{
BaseFormType = eBaseFormType.BUMP_BASE;
pnlBUMPDetail.Visible = false;
cdvCharID.Visible = false;
cdvRasId.Visible = false;
cdvOperID.Visible = true;
cdvSpecID.Visible = true;
}
else
{
BaseFormType = eBaseFormType.WIP_BASE;
pnlWIPDetail.Visible = false;
cdvCharID.Visible = true;
cdvRasId.Visible = true;
cdvOperID.Visible = false;
cdvSpecID.Visible = false;
}
this.SetFactory(cdvFactory.txtValue);
cdvRasId.sFactory = cdvFactory.txtValue;
cdvOperID.sFactory = cdvFactory.txtValue;
//GridColumnInit();
SortInit();
}
private void cdvFactory_ValueSelectedItemChanged(object sender, MCCodeViewSelChanged_EventArgs e)
{
this.SetFactory(cdvFactory.txtValue);
//cdvLotType.sFactory = cdvFactory.txtValue;
cdvOper.sFactory = cdvFactory.txtValue;
}
private void cdvFactory_ValueSelectedItemChanged(object sender, MCCodeViewSelChanged_EventArgs e)
{
this.SetFactory(cdvFactory.txtValue);
//cdvLotType.sFactory = cdvFactory.txtValue;
StringBuilder strSqlString = new StringBuilder();
StringBuilder strSqlString1 = new StringBuilder();
strSqlString.Append("SELECT OPER_GRP_1" + "\n");
strSqlString.Append(" FROM MWIPOPRDEF " + "\n");
strSqlString.Append(" WHERE FACTORY " + cdvFactory.SelectedValueToQueryString + "\n");
strSqlString.Append(" AND OPER_CMF_4 <> ' ' " + "\n");
strSqlString.Append(" GROUP BY OPER_GRP_1" + "\n");
strSqlString.Append(" ORDER BY TO_NUMBER(MIN(OPER_CMF_4)) ASC" + "\n");
dtOperGrp = CmnFunction.oComm.GetFuncDataTable("DYNAMIC", strSqlString.ToString());
strSqlString1.Append("SELECT OPER " + "\n");
strSqlString1.Append(" FROM MWIPOPRDEF A" + "\n");
strSqlString1.Append(" WHERE FACTORY " + cdvFactory.SelectedValueToQueryString + "\n");
strSqlString1.Append(" AND OPER NOT IN ('00001', '00002') " + "\n");
strSqlString1.Append(" AND OPER LIKE SUBSTR(A.FACTORY, 4, 1) || '%' " + "\n");
strSqlString1.Append(" ORDER BY DECODE(OPER_CMF_2, ' ', 99999, TO_NUMBER(OPER_CMF_2)), OPER" + "\n");
dtOper = CmnFunction.oComm.GetFuncDataTable("DYNAMIC", strSqlString1.ToString());
}
private void cdvSubValue_SelectedItemChanged(object sender, MCCodeViewSelChanged_EventArgs e)
{
if (SubValueSelectedItemChangedEvent != null)
{
SubValueSelectedItemChangedEvent(this, e);
}
}
/// <summary>
/// Selected Item Change 이벤트 발생시 조건 타입에 해당하는 로직처리.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void cdvValue_SelectedItemChanged(object sender, MCCodeViewSelChanged_EventArgs e)
{
if (ValueSelectedItemChangedEvent != null)
{
ValueSelectedItemChangedEvent(this, e);
}
switch (m_e_FromTo_type)
{
case eFromToType.FACTORY:
break;
case eFromToType.MATERIAL:
break;
case eFromToType.FLOW:
break;
case eFromToType.OPER:
if (cdvFromValue.Equals((Miracom.UI.Controls.MCCodeView.MCCodeView)sender))
{
if (cdvToValue.Text.Trim().Length != 0)
{
if (cdvFromValue.SelectedItem.Index > cdvToValue.SelectedItem.Index)
{
cdvToValue.Text = cdvFromValue.Text;
}
}
}
else
{
if (cdvFromValue.Text.Trim().Length != 0)
{
if (cdvFromValue.SelectedItem.Index > cdvToValue.SelectedItem.Index)
{
cdvToValue.Text = cdvFromValue.Text;
}
}
}
break;
case eFromToType.RESOURCE:
break;
case eFromToType.EVENT:
break;
case eFromToType.TABLE:
break;
case eFromToType.TEXT:
break;
case eFromToType.HQ_TABLE:
break;
case eFromToType.CUSTOM:
break;
}
}
private void cdvValue_SelectedItemChanged(object sender, MCCodeViewSelChanged_EventArgs e)
{
if (ValueSelectedItemChangedEvent != null)
{
ValueSelectedItemChangedEvent(this, e);
}
switch (m_e_condition_type)
{
case eConditionype.FACTORY:
break;
case eConditionype.FACTORY_ASSEMBLY:
break;
case eConditionype.MATERIAL:
break;
case eConditionype.FLOW:
if (this.ParentValue != "" && this.ParentSubValue != "")
{
int iSeq = cdvValue.SelectedItem.Index + 1;
cdvSubValue.Text = iSeq.ToString(); //기본선택된순번을 Seq값에 넣어줌
}
break;
case eConditionype.OPER:
break;
case eConditionype.RESOURCE:
break;
case eConditionype.EVENT:
break;
case eConditionype.TABLE:
break;
case eConditionype.AREA:
break;
case eConditionype.TEXT:
break;
case eConditionype.CUSTOM:
break;
case eConditionype.HQ_TABLE:
break;
// 2010-04-19-임종우 : 원부자재 조회용 MATERIAL_TYPE 추가
case eConditionype.MATERIAL_TYPE:
break;
}
}
private void OnSelectionChanged()
{
if (this.m_MCCodeDropList.SelectedItems.Count > 0)
{
MCCodeViewSelChanged_EventArgs oArgs = new MCCodeViewSelChanged_EventArgs(((ListViewItem)this.m_MCCodeDropList.SelectedItems[0]), this.SelectedSubItemIndex, this.DisplaySubItemIndex);
ShowPopup(false);
if (SelectionChangedEvent != null)
{
SelectionChangedEvent(this, oArgs);
}
}
}
private void cdvMatType_ValueSelectedItemChanged(object sender, MCCodeViewSelChanged_EventArgs e)
{
udcMat_Code.Text = "";
if (cdvMatType.Text == "MC")
{
ChkEmc.Visible = true;
}
else
{
ChkEmc.Visible = false;
}
}
private void cdvFactory_ValueSelectedItemChanged(object sender, MCCodeViewSelChanged_EventArgs e)
{
if (cdvFactory.Text.Trim() == "HMKB1")
{
BaseFormType = eBaseFormType.BUMP_BASE;
pnlBUMPDetail.Visible = false;
}
else
{
BaseFormType = eBaseFormType.WIP_BASE;
pnlWIPDetail.Visible = false;
}
SortInit(); //add 150529
}
private void cdvFactory_ValueSelectedItemChanged(object sender, MCCodeViewSelChanged_EventArgs e)
{
this.SetFactory(cdvFactory.txtValue);
cdvStep.sFactory = cdvFactory.txtValue;
cdvStep.SetChangedFlag(true);
cdvStep.Text = "";
string strQuery = string.Empty;
//strQuery += "SELECT DISTINCT OPER CODE, (SELECT OPER_DESC FROM MWIPOPRDEF WHERE FACTORY = LTH.FACTORY AND OPER = LTH.OPER AND ROWNUM = 1) DATA " + "\n";
//strQuery += " FROM MRASRESLTH LTH " + "\n";
//strQuery += " WHERE FACTORY " + cdvFactory.SelectedValueToQueryString + "\n";
//strQuery += " AND TRAN_TIME BETWEEN '" + cdvDate.Value.AddDays(-1).ToString("yyyyMMdd") + "220000" + "' AND '" + cdvDate.Value.ToString("yyyyMMdd") + "220000" + "' " + "\n";
//strQuery += " ORDER BY OPER " + "\n";
strQuery += "SELECT DISTINCT OPR.OPER CODE, OPR.OPER_DESC DATA" + "\n";
strQuery += " FROM MRASRESMFO RES, MWIPOPRDEF OPR " + "\n";
strQuery += " WHERE RES.FACTORY " + cdvFactory.SelectedValueToQueryString + "\n";
strQuery += " AND REL_LEVEL='R' " + "\n";
if (cdvFactory.txtValue.Equals(GlobalVariable.gsAssyDefaultFactory))
{
//2010-07-28-임종우 : A1300 공정 표시 되도록 추가함(임태성 요청), 원부자재 공정 제거함.
strQuery += " AND RES.OPER NOT IN ('A0100','A0150','A0250','A0320','A0330','A0340','A0350','A0370','A0380','A0390','A0500','A0501',";
strQuery += "'A0502','A0503','A0504','A0505','A0506','A0507','A0508','A0509','A0550','A0950','A1100','A1110','A1180','A1230','A1720','A1950', 'A2050', 'A2100')" + "\n";
strQuery += " AND OPR.OPER LIKE 'A%'" + "\n";
}
else
{
strQuery += " AND RES.OPER IN ('T0100','T0650','T0900','T1040','T1080','T1200')" + "\n";
}
strQuery += " AND RES.FACTORY=OPR.FACTORY " + "\n";
strQuery += " AND RES.OPER=OPR.OPER " + "\n";
strQuery += "ORDER BY OPR.OPER " + "\n";
if (cdvFactory.txtValue != "")
{
cdvStep.sDynamicQuery = strQuery;
}
else
{
cdvStep.sDynamicQuery = "";
}
}
private void cdvFactory_ValueSelectedItemChanged(object sender, MCCodeViewSelChanged_EventArgs e)
{
if (cdvFactory.Text.Trim() == "HMKB1")
{
BaseFormType = eBaseFormType.BUMP_BASE;
pnlBUMPDetail.Visible = false;
}
else
{
BaseFormType = eBaseFormType.WIP_BASE;
pnlWIPDetail.Visible = false;
}
this.SetFactory(cdvFactory.txtValue);
cdvCharID.sFactory = cdvFactory.txtValue;
SortInit(); //add 150529
GetCharIDData();
}
/// <summary>
/// FactorySelectChanged
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void cdvFactory_ValueSelectedItemChanged(object sender, MCCodeViewSelChanged_EventArgs e)
{
this.SetFactory(cdvFactory.txtValue);
}
private void cdvFactory_ValueSelectedItemChanged(object sender, MCCodeViewSelChanged_EventArgs e)
{
if (cdvFactory.txtValue.Equals("HMKB1"))
{
BaseFormType = eBaseFormType.BUMP_BASE;
pnlBUMPDetail.Visible = false;
}
else
{
BaseFormType = eBaseFormType.WIP_BASE;
pnlWIPDetail.Visible = false;
}
this.SetFactory(cdvFactory.txtValue);
cdvModel.sFactory = cdvFactory.txtValue;
cdvStep.sFactory = cdvFactory.txtValue;
cdvStep.SetChangedFlag(true);
cdvStep.Text = "";
string strQuery = string.Empty;
/*
* if (cdvFactory.txtValue != "")
* cdvStep.sDynamicQuery = @"SELECT DISTINCT OPER Code, OPER_DESC Data FROM MWIPOPRDEF WHERE FACTORY " + cdvFactory.SelectedValueToQueryString + " ORDER BY 1 ";
* else
* cdvStep.sDynamicQuery = "";
*/
strQuery += "SELECT DISTINCT OPR.OPER CODE, OPR.OPER_DESC DATA" + "\n";
strQuery += " FROM MRASRESMFO RES, MWIPOPRDEF OPR " + "\n";
strQuery += " WHERE RES.FACTORY " + cdvFactory.SelectedValueToQueryString + "\n";
strQuery += " AND REL_LEVEL='R' " + "\n";
if (cdvFactory.txtValue.Equals(GlobalVariable.gsAssyDefaultFactory))
{
//2010-07-28-임종우 : A1300 공정 표시 되도록 추가함(임태성 요청), 원부자재 공정 제거함.
strQuery += " AND RES.OPER NOT IN ('A0100','A0150','A0250','A0320','A0330','A0340','A0350','A0370','A0380','A0390','A0500','A0501',";
strQuery += "'A0502','A0503','A0504','A0505','A0506','A0507','A0508','A0509','A0550','A0950','A1100','A1110','A1180','A1230','A1720','A1950', 'A2050', 'A2100')" + "\n";
strQuery += " AND OPR.OPER LIKE 'A%'" + "\n";
}
else
{
strQuery += " AND RES.OPER IN ('T0100','T0650','T0900','T1040','T1080','T1200')" + "\n";
}
strQuery += " AND RES.FACTORY=OPR.FACTORY " + "\n";
strQuery += " AND RES.OPER=OPR.OPER " + "\n";
strQuery += "ORDER BY OPR.OPER " + "\n";
if (cdvFactory.txtValue != "")
{
cdvStep.sDynamicQuery = strQuery;
}
else
{
cdvStep.sDynamicQuery = "";
}
SortInit(); //add. 150601
}
//private void cdvAlarm_ID_ValueButtonPress(object sender, EventArgs e)
//{
// if (cdvRes_ID.Text == "")
// {
// MessageBox.Show("설비를 선택해주세요!" , this.Title, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
// return;
// }
// else
// {
// string strquery1 = string.Empty;
// strquery1 = "SELECT DISTINCT KEY_2,DATA_1 FROM MGCMTBLDAT WHERE TABLE_NAME = 'H_EQ_ALARM_ALL' AND KEY_1 IN(SELECT DISTINCT RES_GRP_6 FROM MRASRESDEF WHERE RES_ID = '" + cdvRes_ID.Text + "')ORDER BY KEY_2";
// cdvAlarm_ID.sDynamicQuery = strquery1;
// }
//}
private void cdvStep_ValueSelectedItemChanged(object sender, MCCodeViewSelChanged_EventArgs e)
{
//cdvRes_ID.Text = "";
//cdvAlarm_ID.Text = "";
}
private void cdvMatType_ValueSelectedItemChanged(object sender, MCCodeViewSelChanged_EventArgs e)
{
cdvMatCode.Text = "";
}
private void cdvLoss_ValueSelectedItemChanged(object sender, MCCodeViewSelChanged_EventArgs e)
{
cdvDownCodeDetail.Init();
cdvDownCodeDetail.sDynamicQuery = "SELECT DISTINCT KEY_2,'' AS DATA_1 FROM CWIPSITDEF WHERE FACTORY = '" + cdvFactory.Text + "'" + "AND TABLE_NAME = 'MAINT_CODE' AND LENGTH(KEY_2) = 4 AND KEY_2 LIKE '" + cdvDownCode.Text + "%'" + "ORDER BY KEY_2";
}
private void cdvFactory_ValueSelectedItemChanged(object sender, MCCodeViewSelChanged_EventArgs e)
{
this.SetFactory(cdvFactory.txtValue);
udcCUSFromToCondition1.sFactory = cdvFactory.txtValue;
//cdvLotType.sFactory = cdvFactory.txtValue;
}