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