public void UpdateDisplayResultHistory(string strCellID) { var pDocument = CDocument.GetDocument; var pFormCommon = CFormCommon.GetFormCommon; do { string strQuery = null; // History Align CManagerTable objManagerTableHistoryAlign = pDocument.m_objProcessDatabase.m_objProcessDatabaseHistory.m_objManagerTableHistoryAlign; try { strQuery = string.Format("select * from {0} ", objManagerTableHistoryAlign.HLGetTableName()); strQuery += string.Format("where {0} = '{1}'", objManagerTableHistoryAlign.HLGetTableSchemaName()[( int )CDatabaseDefine.enumHistoryAlign.CELL_ID], strCellID); DataTable objDataTable = new DataTable(); pDocument.m_objProcessDatabase.m_objProcessDatabaseHistory.m_objSQLite.HLReload(strQuery, ref objDataTable); DataRow[] objDataRow = objDataTable.Select("", objManagerTableHistoryAlign.HLGetTableSchemaName()[( int )CDatabaseDefine.enumHistoryAlign.CELL_ID] + " " + CDatabaseDefine.DEF_ASC); for (int iLoopCount = 0; iLoopCount < objDataRow.Length; iLoopCount++) { UpdateDisplay(objDataRow[iLoopCount]); } } catch (Exception ex) { Trace.WriteLine(ex.Message); } } while(false); }
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// //생성 : //추가 : //목적 : 히스토리 삭제 쿼리 날려줌 //설명 : ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// private void SetDeleteHistory(CManagerTable objManagerTable, int iIndex, int iDeletePeriod) { // 금일을 기준으로 특정일을 계산해야함 DateTime objDate = DateTime.Today; string strQuery = string.Format("delete from {0} where {1} < datetime('{2}')", objManagerTable.HLGetTableName(), objManagerTable.HLGetTableSchemaName()[iIndex], string.Format("{0} 23:59:59", objDate.AddDays(-1 * Math.Abs(iDeletePeriod)).ToString(CDatabaseDefine.DEF_DATE_FORMAT))); m_objSQLite.HLExecute(strQuery); }
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// //생성 : //추가 : //목적 : 폼 초기화 //설명 : ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// public bool InitializeForm() { var pDocument = CDocument.GetDocument; bool bReturn = false; do { // 폼 중앙에서 생성 this.CenterToParent(); // 폼 가장 위로 this.TopMost = true; // 텍스트 박스's 초기화 if (false == InitializeTextBox(this.TextBoxTitleAlarmType, m_strFontName, m_dFontSizeTitleAlarmType)) { break; } if (false == InitializeTextBox(this.TextBoxTitleAlarmTime, m_strFontName, m_dFontSizeTitleAlarmEtc)) { break; } if (false == InitializeTextBox(this.TextBoxTitleAlarmCode, m_strFontName, m_dFontSizeTitleAlarmEtc)) { break; } if (false == InitializeTextBox(this.TextBoxTitleAlarmObject, m_strFontName, m_dFontSizeTitleAlarmEtc)) { break; } if (false == InitializeTextBox(this.TextBoxTitleAlarmPosition, m_strFontName, m_dFontSizeTitleAlarmEtc)) { break; } if (false == InitializeTextBox(this.TextBoxAlarmTime, m_strFontName, m_dFontSizeTitleAlarmEtc)) { break; } if (false == InitializeTextBox(this.TextBoxAlarmCode, m_strFontName, m_dFontSizeTitleAlarmEtc)) { break; } if (false == InitializeTextBox(this.TextBoxAlarmObject, m_strFontName, m_dFontSizeTitleAlarmEtc)) { break; } if (false == InitializeTextBox(this.TextBoxAlarmPosition, m_strFontName, m_dFontSizeTitleAlarmEtc)) { break; } if (false == InitializeTextBox(this.TextBoxTitleAlarmDescription, m_strFontName, m_dFontSizeTitleAlarmEtc)) { break; } // 텍스트 박스 설정 초기화 if (false == InitializeRichTextBox(this.RichTextBoxAlarmDescriptionKorea)) { break; } if (false == InitializeRichTextBox(this.RichTextBoxAlarmDescriptionVietnam)) { break; } // 알람 시간 this.TextBoxAlarmTime.Text = DateTime.Now.ToString(CDatabaseDefine.DEF_DATE_TIME_FORMAT); // 알람 코드 this.TextBoxAlarmCode.Text = string.Format("{0}", m_objAlarmInformation.iAlarmCode); // 알람 오브젝트 this.TextBoxAlarmObject.Text = m_objAlarmInformation.strAlarmObject; // 알람 위치 this.TextBoxAlarmPosition.Text = m_objAlarmInformation.strAlarmFunction; // Key if (enumKeyString.KEY == m_eKeyString) { // 유저 메세지 데이터 테이블에서 언어 Row값 뽑아옴 CManagerTable objManagerTable = pDocument.m_objProcessDatabase.m_objProcessDatabaseInformation.m_objManagerTableInformationUserMessage; try { DataTable objDataTable = objManagerTable.HLGetDataTable(); DataRow[] objDataRow = objDataTable.Select(string.Format("{0} = '{1}'", objManagerTable.HLGetTableSchemaName()[( int )CDatabaseDefine.enumInformationUserMessage.ID], m_objAlarmInformation.iAlarmCode)); // 한국어 뿌려줌 this.RichTextBoxAlarmDescriptionKorea.Text = objDataRow[0].ItemArray[( int )CDatabaseDefine.enumInformationUserMessage.TEXT_KOREA].ToString(); // 언어에 따른 코드뿌려줌 CConfig.CSystemParameter objOptionParameter = pDocument.m_objConfig.GetSystemParameter(); this.RichTextBoxAlarmDescriptionVietnam.Text = objDataRow[0].ItemArray[(( int )objOptionParameter.eLanguage) + 1].ToString(); // 로그 pDocument.SetUpdateLog(CDefine.enumLogType.LOG_SYSTEM, objDataRow[0].ItemArray[( int )CDatabaseDefine.enumInformationUserMessage.TEXT_KOREA].ToString()); } catch (Exception ex) { Trace.WriteLine(ex.Message); } } // String else if (enumKeyString.STRING == m_eKeyString) { // 입력 받은 문자열 뿌려줌 this.RichTextBoxAlarmDescriptionKorea.Text = m_objAlarmInformation.strAlarmDescription; // 로그 pDocument.SetUpdateLog(CDefine.enumLogType.LOG_SYSTEM, m_objAlarmInformation.strAlarmDescription); } // 버튼 색상 정의 SetButtonColor(); // 버튼 언어 변경 SetChangeLanguage(); bReturn = true; } while(false); return(bReturn); }