/// <summary> /// 먹스 인포가 변경되었을 때 /// </summary> void optionForm_evtMUXInfoChanged() { //0. 오라클 접속 변수 얻어오기 odec = DbConn.GetDbConn(); try { // MUX 인포를 DB에서 읽어 와 세팅한다. StringBuilder sBuilder = new StringBuilder(100); sBuilder.Append(" SELECT useflag , muxid, muxdesc, status, ip "); sBuilder.Append(" FROM muxInfo "); DataTable dTable = new DataTable(); if (odec.openDb()) { dTable = odec.getDataTable(sBuilder.ToString(), "muxInfo"); } if (dTable.Rows.Count > 0) { //초기화 this.mainviewform.lvMUXInfos.Items.Clear(); int i = 0; string strUse = "사용"; string strStatus = "정상"; foreach (DataRow dRow in dTable.Rows) { if (dRow[0].ToString().Equals(0)) { strUse = "미사용"; } if (dRow[3].ToString().Equals(0)) { strStatus = "이상"; } ListViewItem lvItem = new ListViewItem(new string[] { strUse , dRow[1].ToString() , dRow[2].ToString() , strStatus , dRow[4].ToString() }); this.mainviewform.lvMUXInfos.Items.Insert(i, lvItem); i++; } } } catch (Exception ex) { Debug.WriteLine("EWSSystem.MainForm.optionForm_evtMUXInfoChanged()| " + ex.Message); Log.WriteLog("EWSSystem.MainForm.optionForm_evtMUXInfoChanged()| " + ex.Message); } }
/// <summary> /// 폼이 로드될 때 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void HistoryForm_Load(object sender, EventArgs e) { //0. 오라클 접속 변수 얻어오기 odec = DbConn.GetDbConn(); //1. 일반, 특수 기본값 채워주기 //일반으로 기본값 잡음. //2. 날짜 세팅 this.dtStartTime.Value = DateTime.Now.Date; this.dtEndTime.Value = DateTime.Now.Date.AddMinutes(1439); //3. 상태 드랍박스 채워주기 this.cbStatus.Items.Add("선택없음"); this.cbStatus.Items.Add("대기"); this.cbStatus.Items.Add("전송중"); this.cbStatus.Items.Add("종료"); this.cbStatus.SelectedIndex = 0; // "선택없음" 을 선택 }
/// <summary> /// 폼이 로드될 때 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void OptionForm_Load(object sender, EventArgs e) { //0. 오라클 접속 변수 얻어오기 odec = DbConn.GetDbConn(); //1. 설정창 //TCP Server this.txtPort.Text = ConfigurationManager.AppSettings["TCPPort"]; //MUX 기본 this.txtMUXTcId.Text = ConfigurationManager.AppSettings["MUXTcId"]; this.txtMUXRetry.Text = ConfigurationManager.AppSettings["MUXRetry"]; //특수메세지 this.txtSpcMaxId.Text = ConfigurationManager.AppSettings["SpcMaxId"]; this.txtSpcRepeatNum.Text = ConfigurationManager.AppSettings["SpcRepeatNum"]; this.txtSpcWaitTime.Text = ConfigurationManager.AppSettings["SpcWaitTime"]; this.txtSpcCycle.Text = ConfigurationManager.AppSettings["SpcCycle"]; //일반메세지 this.txtNorMaxId.Text = ConfigurationManager.AppSettings["NorMaxId"]; this.txtNorProcNum.Text = ConfigurationManager.AppSettings["NorProcNum"]; this.txtNorRepeatNum.Text = ConfigurationManager.AppSettings["NorRepeatNum"]; this.txtNorCycle.Text = ConfigurationManager.AppSettings["NorCycle"]; this.txtNorTransTime.Text = ConfigurationManager.AppSettings["NorTransTime"]; this.txtNorWaitTime.Text = ConfigurationManager.AppSettings["NorWaitTime"]; //2. 먹스 관리 창 // 먹스 정보 DB 로드 StringBuilder sBuilder = new StringBuilder(100); sBuilder.Append(" SELECT muxid, useflag , ip, muxdesc "); sBuilder.Append(" FROM muxInfo "); DataTable dTable = new DataTable(); try { if (odec.openDb()) { dTable = odec.getDataTable(sBuilder.ToString(), "muxInfo"); } } catch (Exception ex) { Debug.WriteLine("EWSSystem.OptionDialog.OptionForm_Load()| " + ex.Message); Log.WriteLog("EWSSystem.OptionDialog.OptionForm_Load()| " + ex.Message); } if (dTable.Rows.Count > 0) { this.lvMUXList.Items.Clear(); int num = 1; string strUse = "사용"; foreach (DataRow dRow in dTable.Rows) { if (dRow[1].ToString().Equals(0)) { strUse = "미사용"; } ListViewItem lvItem = new ListViewItem(new string[] { dRow[0].ToString() , num.ToString() , strUse , dRow[2].ToString() , dRow[3].ToString() }); this.lvMUXList.Items.Add(lvItem); num++; } } }