private void View_Plan_List()
{
ListViewItem itmX = null;
DataTable dt = null;
StringBuilder strSqlString = new StringBuilder();
int i;
try
{
CmnInitFunction.InitListView(lisUploadData);
strSqlString.Append(" SELECT DISTINCT PLAN_DATE FROM RWIPPLNDAT ");
strSqlString.AppendFormat(" WHERE FACTORY = '{0}' ", this.Factory);
strSqlString.AppendFormat(" AND PLAN_DATE LIKE '{0}%' ", dtpPlanYear.Value.ToString("yyyy") + dtpPlanMonth.Value.ToString("MM"));
strSqlString.AppendFormat(" AND PLAN_TYPE = '{0}' ", this.Plan_Type);
dt = CmnFunction.oComm.GetFuncDataTable("DYNAMIC", strSqlString.ToString());
for (i = 0; i < dt.Rows.Count; i++)
{
itmX = new ListViewItem(CmnFunction.MakeDateFormat(dt.Rows[i][0].ToString(), DATE_TIME_FORMAT.SHORTDATE), (int)SMALLICON_INDEX.IDX_CALENDAR);
lisUploadData.Items.Add(itmX);
}
}
catch (Exception ex)
{
CmnFunction.ShowMsgBox("udcCUSReportUpload001.View_Plan_List() " + "\r\n" + ex.ToString());
}
}
private void udcFLXViewInquiry_Load(object sender, EventArgs e)
{
InitCodeView();
CmnInitFunction.InitSpread(spdData);
dtpDateTime.Visible = false;
}
private void SEC1103_Load(object sender, EventArgs e)
{
lisFunc.SmallImageList = ((System.Windows.Forms.TabControl)((System.Windows.Forms.TabPage) this.Parent).Parent).ImageList;
CmnFunction.oComm.SetUrl();
CmnInitFunction.InitListView(lisFunc);
ViewFunctionList(lisFunc);
}
private void frmFMBSetupResourceImage_Load(object sender, System.EventArgs e)
{
try
{
modCommonFunction.CheckSecurityFormControl(this);
modCommonFunction.GetTextboxStyle(this.Controls);
modLanguageFunction.ToClientLanguage(this);
CmnInitFunction.InitListView(lisResource);
CmnInitFunction.InitListView(lisImagelist);
ViewImageList();
lisResource.SmallImageList = imlRes;
modCommonFunction.CheckAllFactoryOption(cdvFactory);
if (modGlobalVariable.gbAllFactory == false)
{
CmnInitFunction.InitListView(lisResource);
lisResource.SmallImageList = imlRes;
modListRoutine.ViewResourceImageList(lisResource, '1', cdvFactory.Text);
}
}
catch (Exception ex)
{
CmnFunction.ShowMsgBox("frmFMBSetupResourceImage.frmFMBSetupResourceImage_Load()" + "\r\n" + ex.Message, "FMB Client", MessageBoxButtons.OK, 1);
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
try
{
if (txtFunc.Text.Trim().Length == 0)
{
CmnFunction.ShowMsgBox("Function Name : " + RptMessages.GetMessage("STD999", GlobalVariable.gcLanguage));
}
if (CmnFunction.ShowMsgBox(RptMessages.GetMessage("INF002", GlobalVariable.gcLanguage), "Delete", MessageBoxButtons.YesNo, 2) != System.Windows.Forms.DialogResult.Yes)
{
return;
}
if (Delete_Function(txtFunc.Text.Trim()) == true)
{
CmnFunction.ShowMsgBox(RptMessages.GetMessage("INF001", GlobalVariable.gcLanguage));
CmnInitFunction.FieldClear(this, null, false);
lisFunc.SelectedIndices.Clear();
lisFunc.Items.Clear();
ViewFunctionList(lisFunc);
//lisFunc.Items.Remove(lisFunc.SelectedItems[0]);
}
}
catch (Exception ex)
{
CmnFunction.ShowMsgBox("SEC1103.btnDelete_Click() : " + ex.Message);
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
try
{
if (txtSecGrp.Text.Trim().Length == 0)
{
CmnFunction.ShowMsgBox("Security Group : " + RptMessages.GetMessage("STD999", GlobalVariable.gcLanguage));
}
if (CmnFunction.ShowMsgBox(RptMessages.GetMessage("INF002", GlobalVariable.gcLanguage), "Delete", MessageBoxButtons.YesNo, 2) != System.Windows.Forms.DialogResult.Yes)
{
return;
}
if (Delete_Security_Group(txtSecGrp.Text.Trim()) == true)
{
CmnFunction.ShowMsgBox(RptMessages.GetMessage("INF001", GlobalVariable.gcLanguage));
CmnInitFunction.FieldClear(this, null, false);
lisSecGrp.Items.Remove(lisSecGrp.SelectedItems[0]);
}
}
catch (Exception ex)
{
CmnFunction.ShowMsgBox("SEC1102.btnDelete_Click() : " + ex.ToString());
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
try
{
if (txtUserId.Text.Trim().Length == 0)
{
CmnFunction.ShowMsgBox("User ID : " + RptMessages.GetMessage("STD999", GlobalVariable.gcLanguage));
}
if (txtPassword.Text.Trim().Length == 0)
{
CmnFunction.ShowMsgBox("Password : "******"STD999", GlobalVariable.gcLanguage));
}
if (cdvSecGrpId.Text.Trim().Length == 0)
{
CmnFunction.ShowMsgBox("Secutiry Group : " + RptMessages.GetMessage("STD999", GlobalVariable.gcLanguage));
}
if (CmnFunction.ShowMsgBox(RptMessages.GetMessage("INF003", GlobalVariable.gcLanguage), "Update", MessageBoxButtons.YesNo, 2) != System.Windows.Forms.DialogResult.Yes)
{
return;
}
if (Update_Security_User(txtUserId.Text.Trim()) == true)
{
CmnFunction.ShowMsgBox(RptMessages.GetMessage("INF001", GlobalVariable.gcLanguage));
CmnInitFunction.FieldClear(this, null, false);
CmnListFunction.ViewSecUserList(lisUser);
}
}
catch (Exception ex)
{
CmnFunction.ShowMsgBox("SEC1101.btnUpdate_Click() : " + ex.ToString());
}
}
private void InitCodeView()
{
cdvConFactory.Init();
CmnInitFunction.InitListView(cdvConFactory.GetListView);
cdvConFactory.Columns.Add("Factory", 150, HorizontalAlignment.Left);
cdvConFactory.Columns.Add("Desc", 200, HorizontalAlignment.Left);
cdvConFactory.SelectedSubItemIndex = 0;
CmnListFunction.ViewFactoryList(cdvConFactory.GetListView, '1', "");
cdvFactory.Init();
CmnInitFunction.InitListView(cdvFactory.GetListView);
cdvFactory.Columns.Add("Factory", 150, HorizontalAlignment.Left);
cdvFactory.Columns.Add("Desc", 200, HorizontalAlignment.Left);
cdvFactory.SelectedSubItemIndex = 0;
CmnListFunction.ViewFactoryList(cdvFactory.GetListView, '1', "");
cdvConInqGrp.Init();
CmnInitFunction.InitListView(cdvConInqGrp.GetListView);
cdvConInqGrp.Columns.Add("Group", 150, HorizontalAlignment.Left);
cdvConInqGrp.Columns.Add("Desc", 200, HorizontalAlignment.Left);
cdvConInqGrp.SelectedSubItemIndex = 0;
cdvInqGrp.Init();
CmnInitFunction.InitListView(cdvInqGrp.GetListView);
cdvInqGrp.Columns.Add("Group", 150, HorizontalAlignment.Left);
cdvInqGrp.Columns.Add("Desc", 200, HorizontalAlignment.Left);
cdvInqGrp.SelectedSubItemIndex = 0;
cdvSelItem.Init();
CmnInitFunction.InitListView(cdvSelItem.GetListView);
cdvSelItem.Columns.Add("Item", 150, HorizontalAlignment.Left);
cdvSelItem.Columns.Add("Desc", 200, HorizontalAlignment.Left);
cdvSelItem.SelectedSubItemIndex = 0;
cdvSelValue.Init();
CmnInitFunction.InitListView(cdvSelValue.GetListView);
cdvSelValue.Columns.Add("Item", 150, HorizontalAlignment.Left);
cdvSelValue.Columns.Add("Desc", 200, HorizontalAlignment.Left);
cdvSelValue.SelectedSubItemIndex = 0;
cdvSelGrpItem.Init();
CmnInitFunction.InitListView(cdvSelGrpItem.GetListView);
cdvSelGrpItem.Columns.Add("Item", 150, HorizontalAlignment.Left);
cdvSelGrpItem.Columns.Add("Desc", 200, HorizontalAlignment.Left);
cdvSelGrpItem.SelectedSubItemIndex = 0;
cdvFilter.Init();
CmnInitFunction.InitListView(cdvFilter.GetListView);
cdvFilter.Columns.Add("Item", 150, HorizontalAlignment.Left);
cdvFilter.Columns.Add("Desc", 200, HorizontalAlignment.Left);
cdvFilter.SelectedSubItemIndex = 0;
cdvFilterValue.Init();
CmnInitFunction.InitListView(cdvFilterValue.GetListView);
cdvFilterValue.Columns.Add("Item", 150, HorizontalAlignment.Left);
cdvFilterValue.Columns.Add("Desc", 200, HorizontalAlignment.Left);
cdvFilterValue.SelectedSubItemIndex = 0;
CmnListFunction.ViewDataList(lisColList, '1', "SYSTEM", GlobalConstant.MP_GCM_FLEXWIP_COL_TBL);
}
private void btnAttach_Click(object sender, EventArgs e)
{
int seq = 0;
try
{
if (lisFunction.Items.Count != 0 &&
lisFunction.SelectedItems.Count != 0 &&
lisOper.Items.Count != 0 &&
lisOper.SelectedItems.Count != 0)
{
if (lisProcOper.Items.Count == 0)
{
seq = 0;
}
else
{
if (lisProcOper.SelectedItems.Count == 0)
{
seq = lisProcOper.Items.Count;
}
else
{
seq = lisProcOper.SelectedItems[0].Index + 1;
}
}
for (int i = 0; i < lisOper.SelectedItems.Count; i++)
{
if (FindOper(lisOper.SelectedItems[i].SubItems[0].Text))
{
if (!UpdateProcOper("1", lisOper.SelectedItems[i].SubItems[0].Text.Trim(), seq, lisOper.SelectedItems[i].SubItems[1].Text.Trim()))
{
break;
}
}
seq += 1;
}
if (rbnOper.Checked)
{
CmnInitFunction.InitListView(lisProcOper);
CmnInitFunction.InitListView(lisOper);
ProcOperationList("1");
}
else
{
CmnInitFunction.InitListView(lisProcOper);
CmnInitFunction.InitListView(lisOper);
ProcOperationList("2");
}
}
}
catch (Exception ex)
{
CmnFunction.ShowMsgBox(ex.ToString());
}
}
private Boolean fnDataFind()
{
/****************************************************
* Comment : DataBase에 저장된 데이터를 조회한다.
*
* Created By : bee-jae jung(2016-06-15-수요일)
*
* Modified By : bee-jae jung(2016-06-16-목요일)
****************************************************/
String sPackage = "", sParameter = "";
try
{
Cursor.Current = Cursors.WaitCursor;
LoadingPopUp.LoadIngPopUpShow(this);
if (fnBusinessRule() == false)
{
return(false);
}
// 2016-06-16-정비재 : Sheet / Listview를 초기화 한다.
CmnInitFunction.ClearList(SS01, true);
// 2016-06-16-정비재 : oracle package(procedure)를 이용하여 데이터를 조회한다.
sPackage = "PACKAGE_TRN090106.PROC_TRN090106";
sParameter = "P_WORK_MONTH:" + cdvFromToDate.FromYearMonth.Value.ToString("yyyyMM")
+ "│ P_CUSTOMER:" + (cdvCustomer.Text == "ALL" ? "%" : cdvCustomer.Text) + "%"
+ "│ P_PACKAGE:" + (cdvPackage.Text == "ALL" ? "%" : cdvPackage.Text) + "%";
DataTable dt = CmnFunction.oComm.fnExecutePackage("DYNAMIC", sPackage, sParameter);
if (dt.Rows.Count <= 0)
{
dt.Dispose();
LoadingPopUp.LoadingPopUpHidden();
CmnFunction.ShowMsgBox(RptMessages.GetMessage("STD010", GlobalVariable.gcLanguage));
return(false);
}
SS01.DataSource = dt;
SS01.RPT_AutoFit(false);
return(true);
}
catch (Exception ex)
{
LoadingPopUp.LoadingPopUpHidden();
MessageBox.Show(ex.Message);
return(false);
}
finally
{
LoadingPopUp.LoadingPopUpHidden();
Cursor.Current = Cursors.Default;
}
}
private void cdvFuncGrp_ButtonPress(object sender, EventArgs e)
{
cdvFuncGrp.Init();
CmnInitFunction.InitListView(cdvFuncGrp.GetListView);
cdvFuncGrp.Columns.Add("FUNC_GRP_ID", 100, HorizontalAlignment.Left);
cdvFuncGrp.SelectedSubItemIndex = 0;
ViewFuncGrpList(cdvFuncGrp.GetListView);
}
private void cdvFactory_ButtonPress(object sender, EventArgs e)
{
cdvFactory.Init();
CmnInitFunction.InitListView(cdvFactory.GetListView);
cdvFactory.Columns.Add("Factory", 50, HorizontalAlignment.Left);
cdvFactory.Columns.Add("Desc", 100, HorizontalAlignment.Left);
cdvFactory.SelectedSubItemIndex = 0;
RptListFunction.ViewFactoryList(cdvFactory.GetListView);
}
private void frmLotHistory_Load(object sender, EventArgs e)
{
CmnInitFunction.InitSpread(spdData);
WinXpStyle.FormLoad(sender, e, this);
if (sLot_ID != null)
{
txtLotID.Text = sLot_ID;
btnView_Click(null, null);
}
}
private void cdvOper_ButtonPress(object sender, EventArgs e)
{
cdvOper.Init();
CmnInitFunction.InitListView(cdvOper.GetListView);
cdvOper.Columns.Add("KEY_1", 30, HorizontalAlignment.Left);
cdvOper.Columns.Add("DATA_1", 70, HorizontalAlignment.Left);
cdvOper.SelectedSubItemIndex = 0;
RptListFunction.ViewOperList(cdvOper.GetListView, cdvFactory.Text, "");
}
private void rbnOpergrp_CheckedChanged(object sender, EventArgs e)
{
if (rbnOpergrp.Checked)
{
CmnInitFunction.InitListView(lisProcOper);
CmnInitFunction.InitListView(lisOper);
GubunOprGrpList("OPRGRP");
ProcOperationList("2");
}
}
private void cdvLotType_ButtonPress(object sender, EventArgs e)
{
cdvLotType.Init();
CmnInitFunction.InitListView(cdvLotType.GetListView);
cdvLotType.Columns.Add("KEY_1", 30, HorizontalAlignment.Left);
cdvLotType.Columns.Add("DATA_1", 70, HorizontalAlignment.Left);
cdvLotType.SelectedSubItemIndex = 0;
RptListFunction.ViewGCMTableList(cdvLotType.GetListView, cdvFactory.Text, "LOT_TYPE");
}
private void cdvRes_ButtonPress(object sender, EventArgs e)
{
cdvRes.Init();
CmnInitFunction.InitListView(cdvRes.GetListView);
cdvRes.Columns.Add("Factory", 50, HorizontalAlignment.Left);
cdvRes.Columns.Add("Desc", 100, HorizontalAlignment.Left);
cdvRes.SelectedSubItemIndex = 0;
RptListFunction.ViewResourceList(cdvRes.GetListView, cdvFactory.Text.TrimEnd());
}
private void cdvMatGrp_ButtonPress(object sender, EventArgs e)
{
cdvMatGrp.Init();
CmnInitFunction.InitListView(cdvMatGrp.GetListView);
cdvMatGrp.Columns.Add("Prompt", 30, HorizontalAlignment.Left);
cdvMatGrp.Columns.Add("Group", 70, HorizontalAlignment.Left);
cdvMatGrp.SelectedSubItemIndex = 0;
RptListFunction.ViewMATGroupList(cdvMatGrp.GetListView, cdvFactory.Text, "GRP_MATERIAL");
}
private bool GetFlwSeqList(Control ctlList)
{
DataTable rtDataTable = new DataTable();
ListViewItem itmX = null;
string DinamicQuery = " ";
try
{
if (ctlList is ListView)
{
CmnInitFunction.InitListView((ListView)ctlList);
}
CmnFunction.oComm.SetUrl();
if (this.sFactory != "")
{
DinamicQuery += " WHERE FACTORY = '" + this.sFactory + "' ";
DinamicQuery += " AND MAT_ID = '" + this.ParentValue + "' AND MAT_VER = '" + this.ParentSubValue + "' ";
DinamicQuery += " AND FLOW = '" + cdvValue.Text + "' ";
}
else
{//Flow Seq는 MWIPMATFLW에서 가져오므로 MAT_ID,MAT_VER의 정보가 없으면 Seq데이터 조회 불가.(Flow Seq Control의 Visible이 False됨)
DinamicQuery += " WHERE MAT_ID = '" + this.ParentValue + "' AND MAT_VER = '" + this.ParentSubValue + "' ";
DinamicQuery += " AND FLOW = '" + cdvValue.Text + "' ";
}
DinamicQuery += " ORDER BY FLOW_SEQ_NUM";
rtDataTable = CmnFunction.oComm.FillData("MWIPFLWDEF", "3", DinamicQuery);
if (rtDataTable.Rows.Count > 0)
{
for (int i = 0; i < rtDataTable.Rows.Count; i++)
{
if (ctlList is ListView)
{
itmX = new ListViewItem(rtDataTable.Rows[i][0].ToString().TrimEnd());
((ListView)ctlList).Items.Add(itmX);
}
}
}
if (rtDataTable.Rows.Count > 0)
{
rtDataTable.Dispose();
}
return(true);
}
catch (Exception ex)
{
CmnFunction.ShowMsgBox(ex.ToString());
return(false);
}
}
private void cdvFactory_TextBoxTextChanged(object sender, System.EventArgs e)
{
try
{
CmnInitFunction.InitListView(lisResource);
}
catch (Exception ex)
{
CmnFunction.ShowMsgBox("frmFMBSetupResourceImage.cdvFactory_TextBoxTextChanged()" + "\r\n" + ex.Message, "FMB Client", MessageBoxButtons.OK, 1);
}
}
public static bool ViewFactoryList(System.Windows.Forms.Control ctlList, char cStep, string sType)
{
DataTable rtDataTable = new DataTable();
ListViewItem itmX = null;
string QueryCond = null;
try
{
if (ctlList is ListView)
{
CmnInitFunction.InitListView((ListView)ctlList);
}
CmnFunction.oComm.SetUrl();
QueryCond = FwxCmnFunction.PackCondition(QueryCond, sType);
rtDataTable = CmnFunction.oComm.FillData("MWIPFACDEF", cStep.ToString(), QueryCond);
if (rtDataTable.Rows.Count > 0)
{
for (int i = 0; i < rtDataTable.Rows.Count; i++)
{
if (ctlList is ListView)
{
itmX = new ListViewItem(rtDataTable.Rows[i]["FACTORY"].ToString().TrimEnd(), (int)SMALLICON_INDEX.IDX_SEC_GROUP);
if (((ListView)ctlList).Columns.Count > 1)
{
itmX.SubItems.Add(rtDataTable.Rows[i]["FAC_DESC"].ToString().TrimEnd());
}
((ListView)ctlList).Items.Add(itmX);
}
else if (ctlList is TreeView)
{
}
else if (ctlList is ComboBox)
{
}
}
}
if (rtDataTable.Rows.Count > 0)
{
rtDataTable.Dispose();
}
return(true);
}
catch (Exception ex)
{
CmnFunction.ShowMsgBox(ex.ToString());
return(false);
}
}
public udcCUSReportUpload002()
{
InitializeComponent();
//화면 오픈시 메뉴의 Desc값으로 Title변경. by John Seo. 2008.10.06.
if (GlobalVariable.gsSelFuncName != "")
{
this.lblTitle.Text = GlobalVariable.gsSelFuncName;
}
CmnInitFunction.InitListView(lisUploadData);
}
private bool GetFactoryList(Control ctlList)
{
DataTable rtDataTable = new DataTable();
ListViewItem itmX = null;
string QueryCond = null;
try
{
if (ctlList is ListView)
{
CmnInitFunction.InitListView((ListView)ctlList);
}
((ListView)ctlList).SmallImageList = imlSmallIcon;
CmnFunction.oComm.SetUrl();
rtDataTable = CmnFunction.oComm.FillData("MWIPFACDEF", "1", QueryCond);
if (rtDataTable.Rows.Count > 0)
{
for (int i = 0; i < rtDataTable.Rows.Count; i++)
{
if (ctlList is ListView)
{
itmX = new ListViewItem(rtDataTable.Rows[i]["FACTORY"].ToString().TrimEnd(), (int)SMALLICON_INDEX.IDX_FACTORY);
if (((ListView)ctlList).Columns.Count > 1)
{
itmX.SubItems.Add(rtDataTable.Rows[i]["FAC_DESC"].ToString().TrimEnd());
}
((ListView)ctlList).Items.Add(itmX);
}
else if (ctlList is TreeView)
{
}
else if (ctlList is ComboBox)
{
}
}
}
if (rtDataTable.Rows.Count > 0)
{
rtDataTable.Dispose();
}
return(true);
}
catch (Exception ex)
{
CmnFunction.ShowMsgBox(ex.ToString());
return(false);
}
}
private bool GetMatList(Control ctlList)
{
DataTable rtDataTable = new DataTable();
ListViewItem itmX = null;
string DinamicQuery = " ";
try
{
if (ctlList is ListView)
{
CmnInitFunction.InitListView((ListView)ctlList);
}
((ListView)ctlList).SmallImageList = imlSmallIcon;
CmnFunction.oComm.SetUrl();
if (this.sFactory != "")
{
DinamicQuery += " WHERE FACTORY = '" + this.sFactory + "'";
}
DinamicQuery += " ORDER BY MAT_ID";
rtDataTable = CmnFunction.oComm.FillData("MWIPMATDEF", "1", DinamicQuery);
if (rtDataTable.Rows.Count > 0)
{
for (int i = 0; i < rtDataTable.Rows.Count; i++)
{
if (ctlList is ListView)
{
itmX = new ListViewItem(rtDataTable.Rows[i][0].ToString().TrimEnd(), (int)SMALLICON_INDEX.IDX_MATERIAL);
if (((ListView)ctlList).Columns.Count > 1)
{
itmX.SubItems.Add(rtDataTable.Rows[i][1].ToString().TrimEnd());
}
((ListView)ctlList).Items.Add(itmX);
}
}
}
if (rtDataTable.Rows.Count > 0)
{
rtDataTable.Dispose();
}
return(true);
}
catch (Exception ex)
{
CmnFunction.ShowMsgBox(ex.ToString());
return(false);
}
}
public static bool View_Inquiry_List(System.Windows.Forms.Control ctlList, char cStep, string sFactory, string sGroup)
{
DataTable rtDataTable = new DataTable();
ListViewItem itmX = null;
string QueryCond = null;
try
{
if (ctlList is ListView)
{
CmnInitFunction.InitListView((ListView)ctlList);
}
QueryCond = FwxCmnFunction.PackCondition(QueryCond, sFactory);
QueryCond = FwxCmnFunction.PackCondition(QueryCond, sGroup);
rtDataTable = CmnFunction.oComm.FillData("RWEBFLXINQ", cStep.ToString(), QueryCond);
if (rtDataTable.Rows.Count > 0)
{
for (int i = 0; i < rtDataTable.Rows.Count; i++)
{
if (ctlList is ListView)
{
itmX = new ListViewItem(rtDataTable.Rows[i]["INQUIRY_NAME"].ToString().TrimEnd(), (int)SMALLICON_INDEX.IDX_FUNCTION);
itmX.SubItems.Add(rtDataTable.Rows[i]["INQUIRY_DESC"].ToString().TrimEnd());
((ListView)ctlList).Items.Add(itmX);
}
else if (ctlList is TreeView)
{
}
else if (ctlList is ComboBox)
{
}
}
}
if (rtDataTable.Rows.Count > 0)
{
rtDataTable.Dispose();
}
}
catch (Exception ex)
{
CmnFunction.ShowMsgBox(ex.ToString());
return(false);
}
return(true);
}
private void cdvFactory_SelectedItemChanged(object sender, Miracom.UI.MCCodeViewSelChanged_EventArgs e)
{
try
{
CmnInitFunction.InitListView(lisResource);
lisResource.SmallImageList = imlRes;
modListRoutine.ViewResourceImageList(lisResource, '1', cdvFactory.Text);
}
catch (Exception ex)
{
CmnFunction.ShowMsgBox("frmFMBSetupResourceImage.cdvFactory_SelectedItemChanged()" + "\r\n" + ex.Message, "FMB Client", MessageBoxButtons.OK, 1);
}
}
private void cdvFactory_SelectedItemChanged(object sender, Miracom.UI.MCCodeViewSelChanged_EventArgs e)
{
if (rbnOper.Checked)
{
CmnInitFunction.InitListView(lisOper);
GubunOprGrpList("OPR");
}
else
{
CmnInitFunction.InitListView(lisOper);
GubunOprGrpList("OPRGRP");
}
}
public static bool GetFlwList(Control ctlList, string sFactory)
{
DataTable rtDataTable = new DataTable();
ListViewItem itmX = null;
string DinamicQuery = " ";
try
{
if (ctlList is ListView)
{
CmnInitFunction.InitListView((ListView)ctlList);
}
CmnFunction.oComm.SetUrl();
if (sFactory != "")
{
DinamicQuery += " WHERE FACTORY = '" + sFactory + "'";
}
rtDataTable = CmnFunction.oComm.FillData("MWIPFLWDEF", "4", DinamicQuery);
if (rtDataTable.Rows.Count > 0)
{
for (int i = 0; i < rtDataTable.Rows.Count; i++)
{
if (ctlList is ListView)
{
itmX = new ListViewItem(rtDataTable.Rows[i][0].ToString().TrimEnd(), (int)SMALLICON_INDEX.IDX_FLOW);
if (((ListView)ctlList).Columns.Count > 1)
{
itmX.SubItems.Add(rtDataTable.Rows[i][1].ToString().TrimEnd());
}
((ListView)ctlList).Items.Add(itmX);
}
}
}
if (rtDataTable.Rows.Count > 0)
{
rtDataTable.Dispose();
}
return(true);
}
catch (Exception ex)
{
CmnFunction.ShowMsgBox(ex.ToString());
return(false);
}
}
private bool GetMatVerList(Control ctlList)
{
DataTable rtDataTable = new DataTable();
ListViewItem itmX = null;
string DinamicQuery = " ";
try
{
if (ctlList is ListView)
{
CmnInitFunction.InitListView((ListView)ctlList);
}
CmnFunction.oComm.SetUrl();
if (this.sFactory != "")
{
DinamicQuery += " WHERE FACTORY = '" + this.sFactory + "' AND MAT_ID = '" + cdvValue.Text + "' ";
}
else
{
DinamicQuery += " WHERE MAT_ID = '" + cdvValue.Text + "' ";
}
rtDataTable = CmnFunction.oComm.FillData("MWIPMATDEF", "2", DinamicQuery);
if (rtDataTable.Rows.Count > 0)
{
for (int i = 0; i < rtDataTable.Rows.Count; i++)
{
if (ctlList is ListView)
{
itmX = new ListViewItem(rtDataTable.Rows[i][0].ToString().TrimEnd());
((ListView)ctlList).Items.Add(itmX);
}
}
}
if (rtDataTable.Rows.Count > 0)
{
rtDataTable.Dispose();
}
return(true);
}
catch (Exception ex)
{
CmnFunction.ShowMsgBox(ex.ToString());
return(false);
}
}
private void udcFLXSetupInquiry_Load(object sender, EventArgs e)
{
CmnFunction.oComm.SetUrl();
CmnInitFunction.InitListView(lisInqList);
CmnInitFunction.InitListView(lisColList);
CmnInitFunction.InitListView(lisAttachCol);
InitCodeView();
cboPeriod.SelectedIndex = 0;
cboLogical.SelectedIndex = 0;
cboOperator.SelectedIndex = 0;
}
