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