/**
* ﾒｿｯﾄﾞ概要 ・ﾃﾞｰﾀ（精算情報表示用）の読み込みｺﾝﾄﾛｰﾙ
*
* @param ・なし
* @return ・なし
*/
public void fEtexExecuteRecognitionReadCtl() {
/* DB接続ﾊﾝﾄﾞﾙ */
CEtexGeneralDbHandle clsParamDbHandle = null;
/* ﾃﾞｰﾀ情報 */
CEtexRecognitionDataBean clsDataBean = null;
/* ﾃﾞｰﾀ情報格納ﾘｽﾄ */
ArrayList arraData = null;
/* 編集ﾊﾞｯﾌｧ */
String stgbuf = null;
/* DB接続ﾊﾝﾄﾞﾙ生成 */
clsParamDbHandle = new CEtexGeneralDbHandle();
/* ﾘｽﾄﾃﾞｰﾀ生成 */
arraData = new ArrayList();
/* DBｵｰﾌﾟﾝ */
fEtexGeneralDbUtilOpen(clsParamDbHandle);
/* DBのExceptionｴﾗｰ用のtry */
try {
/* DB検索 */
fEtexGeneralDbUtilSelect(
clsParamDbHandle,
fEtexExecuteRecognitionPublishSql(ETEX_RECOGNITION_DB_SELECT_EITD100, null));
/* ﾃﾞｰﾀ読み込み */
for (int intCnt = 0; fEtexGeneralDbUtilSeek(clsParamDbHandle); intCnt++) {
clsDataBean = new CEtexRecognitionDataBean();
/* 承認ﾁｪｯｸﾎﾞｯｸｽ */
clsDataBean.setRecognitionDark_1(
fEtexExecuteRecognitionGetDark_1(
fEtexGeneralDbUtilGetDataString(clsParamDbHandle, "TD100170C")));
/* 解除ﾁｪｯｸﾎﾞｯｸｽ */
clsDataBean.setRecognitionDark_2(
fEtexExecuteRecognitionGetDark_2(
fEtexGeneralDbUtilGetDataString(clsParamDbHandle, "TD100170C")));
/* 社員ｺｰﾄﾞ */
clsDataBean.setRecognitionDataStaff(
fEtexGeneralDbUtilGetDataString(clsParamDbHandle, "MD010010V"));
/* 社員名 */
clsDataBean.setRecognitionDataName(
fEtexGeneralDbUtilGetDataString(clsParamDbHandle, "MD010110V"));
/* 年／月／日（yyyy/mm/dd） */
stgbuf =
fEtexGeneralStringUtilFormatChk(
ETEX_RECOGNITION_FORMAT_YYYYMMDD,
fEtexGeneralDbUtilGetDataString(clsParamDbHandle, "TD100020V"),
ETEX_RECOGNITION_STRING_EMPTY_YYYYMMDD);
clsDataBean.setRecognitionDataDate(stgbuf);
/* 月／日（mm/dd） */
stgbuf =
fEtexGeneralStringUtilFormatChk(
ETEX_RECOGNITION_FORMAT_MMDD,
fEtexGeneralDbUtilGetDataString(clsParamDbHandle, "TD100020V").substring(5, 10),
ETEX_RECOGNITION_STRING_EMPTY_MMDD);
clsDataBean.setRecognitionDataMMDD(
fEtexGeneralStringUtilReplace(
stgbuf, 2, ETEX_RECOGNITION_STRING_SLASH, ETEX_RECOGNITION_STRING_EMPTY_MMDD));
/* 曜日（d） */
stgbuf =
fEtexGeneralStringUtilFormatChk(
ETEX_RECOGNITION_FORMAT_YYYYMMDD,
fEtexGeneralDbUtilGetDataString(clsParamDbHandle, "TD100020V"),
ETEX_RECOGNITION_STRING_EMPTY_YYYYMMDD);
clsDataBean.setRecognitionDataToday("(" + fEtexGeneralDbUtilGetDayOfWeek(stgbuf) + ")");
/* 曜日（ｶﾗｰ）*/
clsDataBean.setRecognitionDataTodayColor(fEtexGeneralDbUtilGetDayOfWeekColor(stgbuf));
/* index */
clsDataBean.setRecognitionDataIndex(
ETEX_GENERAL_STRING_EMPTY
+ fEtexGeneralDbUtilGetDataInt(clsParamDbHandle, "TD100030I"));
/* 精算区分 */
clsDataBean.setRecognitionDataClassify(
fEtexExecuteRecognitionGetClassify(
fEtexGeneralDbUtilGetDataString(clsParamDbHandle, "TD100170C")));
/* 訪問先 */
clsDataBean.setRecognitionDataVisit(
fEtexGeneralDbUtilGetDataString(clsParamDbHandle, "TD100100V"));
/* 用件 */
clsDataBean.setRecognitionDataMatter(
fEtexGeneralDbUtilGetDataString(clsParamDbHandle, "TD100110V"));
/* from */
clsDataBean.setRecognitionDataFrom(
fEtexGeneralDbUtilGetDataString(clsParamDbHandle, "TD100120V"));
/* きごう*/
clsDataBean.setRecognitionDataArrow(
fEtexExecuteRecognitionGetArrow(
fEtexGeneralDbUtilGetDataString(clsParamDbHandle, "TD100130C")));
/* to */
clsDataBean.setRecognitionDataTo(
fEtexGeneralDbUtilGetDataString(clsParamDbHandle, "TD100140V"));
/* 機関 */
clsDataBean.setRecognitionDataFacility(
fEtexGeneralDbUtilGetFacility(
fEtexGeneralDbUtilGetDataString(clsParamDbHandle, "MD120010C")));
/* 金額*/
clsDataBean.setRecognitionDataMoney(
fEexGeneralNumericalUtilCnvStringMoney(
fEtexGeneralDbUtilGetDataInt(clsParamDbHandle, "TD100150N")));
/* ﾘｽﾄ追加 */
arraData.add(clsDataBean);
}
} catch (Exception e) {
/* DBのExceptionｴﾗｰをCatchする為のcatch */
/* 例外情報設定 */
fEtexGeneralExceptionUtilSetRequest(clsRecognitionCtlBean.getRecognitionRequest(), e);
/* 例外情報表示 */
System.err.println("CEtexRecognitionExecute：fEtexExecuteRecognitionReadCtl：" + e.toString());
}
/* DBｸﾛｰｽﾞ */
fEtexGeneralDbUtilClose(clsParamDbHandle);
/* ﾘｽﾄﾃﾞｰﾀ格納 */
clsRecognitionCtlBean.setRecognitionArrayDataBean(arraData);
/* 次ﾌｪｰｽﾞの設定 */
clsRecognitionCtlBean.setRecognitionPhase(ETEX_RECOGNITION_PHASE_SCREEN_ADJUST);
}
