/******************************************************************************* * All Rights reserved,Copyright (c) K-Opticom ******************************************************************************** *＜プログラム内容＞ * システム名 ：eo顧客基幹システム * モジュール名 ：JSYejbETU0011A010TPDA * ソースファイル名：JSYejbETU0011A010TPDA.java * 作成者 ：EK908590 * 日付 ：2012年02月21日 *＜機能概要＞ * 番ポ工事一意照会テンプレートDBアクセス部品です。 *＜修正履歴＞ * バージョン 修正日 修正者 修正内容 * v3.00.00 2012/03/17 FJ)楠神 新規作成 * v3.00.00 2012/03/17 FJ)楠神 ANK-0045-01-00 * v4.00.00 2012/05/30 FJ)宮本 ANK-0398-00-00 * v5.00.00 2013/02/11 FJ)楠神 ANK-1175-00-00 * v5.00.01 2013/09/06 FJ)高橋 OM-2013-0001648 * v6.00.00 2013/12/20 FJ)黒田 ANK-1765-00-00 * v72.00.00 2024/03/11 FJ)黒田 ANK-4494-00-00:【eo定期】 双方向番ポ対応 * ********************************************************************************/ package eo.ejb.cbs.sqlf; import com.fujitsu.futurity.model.base.CAANMsg; import com.fujitsu.futurity.model.base.CAANSQLFacility; import com.fujitsu.futurity.model.base.CAANRuntimeException; import com.fujitsu.futurity.model.base.CAANJDBCUtil; import com.fujitsu.futurity.model.ejb.common.JSYejbConnection; import com.fujitsu.futurity.model.ejb.common.JSYejbLog; import com.fujitsu.futurity.model.ejb.common.StatusCodes; import com.fujitsu.futurity.model.ejb.common.fw.TemplateDBAccessHandler; import com.fujitsu.futurity.model.ejb.common.fw.AgentDispatchContext; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import eo.common.constant.JPCModelConstant; import eo.ejb.cbs.cbsmsg.ETU0011A010CBSMsg; import eo.ejb.cbs.cbsmsg.ETU0011A010CBSMsg1List; import eo.ejb.cbm.entity.TU0011ETMsg; /** * * テンプレートDBアクセス部品　ETU0011A010_SQLF
* 入力された項目からSQL文を動的に組み立て、
* 検索結果をCBSMsgにセットします。
* @author FJ */ public class JSYejbETU0011A010TPDA extends CAANSQLFacility implements TemplateDBAccessHandler { /** * コンストラクタ */ public JSYejbETU0011A010TPDA() { } /** * ETU0011A010_SQLF
* @param inMsg 入力値の格納されたCBSMsg
* @param inContext * @return void */ public void invoke(CAANMsg inMsg, AgentDispatchContext inContext) { // コネクション Connection con1 = null; // プリペアステートメント PreparedStatement pstmt = null; // リザルトセット ResultSet rsltQuery = null; /******************** * SQL文の作成 ********************/ try { //コネクション取得 con1 = JSYejbConnection.getConnection(TU0011ETMsg.getTableName()); // SQL文_基本部1 StringBuffer sql_Buff = new StringBuffer(); sql_Buff.append(" SELECT ") .append(" TU0011.BMP_KOJI_NO, ") .append(" TU0011.GENE_ADD_DTM, ") .append(" TU0011.BMP_KOJI_STAT, ") .append(" TU0011.SVC_KEI_UCWK_NO, ") .append(" TU0011.HOJIN_SVC_KEI_UK_NO, ") .append(" TU0011.HJIN_EO_YKAE_SVKEI_NO, ") .append(" TU0011.HOJIN_KOJIN_CD, ") .append(" TU0011.CUST_MSKM_YMD, ") .append(" TU0011.BMP_MSKMSHO_TYPE_CD, ") .append(" TU0011.DOJI_KOJI_UM, ") .append(" TU0011.DOBANITEN_UM, ") .append(" TU0011.NTT_KEI_TEL_KAISEN_NO, ") .append(" TU0011.TA_JGYOSHA_UR_NO, ") .append(" TU0011.ROUTING_NO, ") .append(" TU0011.NTT_KEISHA_NM, ") .append(" TU0011.NTT_KSH_KANA, ") .append(" TU0011.NTT_KEISHA_AD_CD, ") .append(" TU0011.NTT_KEISHA_PCD, ") .append(" TU0011.NTT_KEISHA_STATE_NM, ") .append(" TU0011.NTT_KEISHA_CITY_NM, ") .append(" TU0011.NTT_KEISHA_OAZTSU_NM, ") .append(" TU0011.NTT_KEISHA_AZCHO_NM, ") .append(" TU0011.NTT_KEISHA_BNCHIGO, ") .append(" TU0011.NTT_KEISHA_ADRTTM, ") .append(" TU0011.NTT_KEISHA_ADRRM, ") .append(" TU0011.RRKS_TELNO, ") .append(" TU0011.SETPLACE_AD_CD, ") .append(" TU0011.SETPLACE_PCD, ") .append(" TU0011.SETPLACE_STATE_NM, ") .append(" TU0011.SETPLACE_CITY_NM, ") .append(" TU0011.SETPLACE_OAZTSU_NM, ") .append(" TU0011.SETPLACE_AZCHO_NM, ") .append(" TU0011.SETPLACE_BNCHIGO, ") .append(" TU0011.SETPLACE_ADRTTM, ") .append(" TU0011.SETPLACE_ADRRM, ") .append(" TU0011.BMP_KOJI_UK_YMD, ") .append(" TU0011.BMP_KOJI_KIBO_YMDH, ") .append(" TU0011.BMPKJ_KIBO_TIME_CD, ") .append(" TU0011.BMPKJ_KIBO_YMD_PDING_FLG, ") .append(" TU0011.BMP_UK_TNT_USER_ID, ") .append(" TU0011.BMPKJ_TNT_USER_ID, ") .append(" TU0011.TEL_KNKN_TRAT_CD, ") .append(" TU0011.TEL_KNKN_TRAT_OTR_MEMO, ") .append(" TU0011.KANYKN_ITENS_AD_CD, ") .append(" TU0011.KANYKN_ITENS_PCD, ") .append(" TU0011.KANYKN_ITENS_STATE_NM, ") .append(" TU0011.KANYKN_ITENS_CITY_NM, ") .append(" TU0011.KANYKN_ITENS_OAZTSU_NM, ") .append(" TU0011.KANYKN_ITENS_AZCHO_NM, ") .append(" TU0011.KANYKN_ITENS_BNCHIGO, ") .append(" TU0011.KANYKN_ITENS_ADRTTM, ") .append(" TU0011.KANYKN_ITENS_ADRRM, ") .append(" TU0011.ITNM_TSJGS_CD, ") .append(" TU0011.ITNM_TSJGS_KTN_CD, ") .append(" TU0011.MSKMJIG_USE_CD, ") .append(" TU0011.BMPKJ_MSKM_MT_TSJGS_CD, ") .append(" TU0011.HUKUSU_KAISEN_BMP_UM, ") .append(" TU0011.HUKUSU_KAISEN_BMP_CNT, ") .append(" TU0011.HUKUSU_KAISEN_GRP_ID, ") .append(" TU0011.MSKMJIG_SNAI_KOJI_UM, ") .append(" TU0011.MSKMJIG_SGAI_KOJI_UM, ") .append(" TU0011.MSKMJIG_KIJIRAN_1, ") .append(" TU0011.MSKMJIG_KIJIRAN_2, ") .append(" TU0011.MSKMJIG_MSKM_YMDHM, ") .append(" TU0011.BMP_KOJI_CHOSA_REQYMD, ") .append(" TU0011.TAJGS_RNKI_SEND_DTM, ") .append(" TU0011.TA_JGS_REQ_CNT, ") .append(" TU0011.TA_JGYOSHA_RNKI_WAY_CD, ") .append(" TU0011.JGSHAK_RTRN_ADJ_SKBT_NO, ") .append(" TU0011.NTT_RNKI_SEND_DTM, ") .append(" TU0011.NTT_REQ_CNT, ") .append(" TU0011.NTT_RNKI_WAY_CD, ") .append(" TU0011.NTT_REQ_SKBT_NO, ") .append(" TU0011.CHGE_MOTO_ORDER_SKBT_NO, ") .append(" TU0011.NTT_REQ_ORDER_CHGRE_MEMO, ") .append(" TU0011.TK_KH_ANS_YMD, ") .append(" TU0011.BMP_KOJI_KH, ") .append(" TU0011.BMP_KOJI_FIX_YMDH, ") .append(" TU0011.BMPKJ_FIX_TIME_CD, ") .append(" TU0011.TK_FAIL_RSN_CD, ") .append(" TU0011.TK_FAIL_RSN_MEMO, ") .append(" TU0011.TA_JIGYOSHA_MI_CFM_FLG, ") .append(" TU0011.BMP_KOJI_REQYMD, ") .append(" TU0011.BMP_KOJI_REQ_RSLT_CD, ") .append(" TU0011.TAJGS_UK_NO, ") .append(" TU0011.TAJGS_TNTSHA_NM, ") .append(" TU0011.TAJGS_TELNO, ") .append(" TU0011.TAJGS_FAX_NO, ") .append(" TU0011.TAJGS_KIJIRAN, ") .append(" TU0011.TAJGS_UK_YMD, ") .append(" TU0011.TA_JIGYOSHA_ODR_SBT_CD, ") .append(" TU0011.TA_JIGYOSHA_ORG_NM, ") .append(" TU0011.NTT_UK_NO, ") .append(" TU0011.NTT_TNTSHA_NM, ") .append(" TU0011.NTT_TELNO, ") .append(" TU0011.NTT_FAX_NO, ") .append(" TU0011.NTT_SNAI_KOJI_UM, ") .append(" TU0011.NTT_SGAI_KOJI_UM, ") .append(" TU0011.NTT_KIJIRAN, ") .append(" TU0011.NTT_UK_YMD, ") .append(" TU0011.BMP_KOJI_FIN_YMD, ") .append(" TU0011.BMP_MSKM_JIGSHO_NO, ") .append(" TU0011.BMP_KOJI_MSKM_JIGSHO_NO, ") .append(" TU0011.BMP_KOJI_STP_CD, ") .append(" TU0011.BMP_KOJI_STP_YMD, ") .append(" TU0011.HOJIN_RSLT_OPUT_ZUMI_FLG, ") .append(" TU0011.ADD_DTM, ") .append(" TU0011.ADD_OPEACNT, ") .append(" TU0011.UPD_DTM, ") .append(" TU0011.UPD_OPEACNT, ") .append(" TU0011.DEL_DTM, ") .append(" TU0011.DEL_OPEACNT, ") .append(" TU0011.MK_FLG, ") .append(" (SELECT ZM0171_BMP_KOJI_STAT.CD_DIV_ALI ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_BMP_KOJI_STAT ") .append(" WHERE ZM0171_BMP_KOJI_STAT.CD_SBT_CD = 'CD00194' ") .append(" AND TU0011.BMP_KOJI_STAT = ZM0171_BMP_KOJI_STAT.CD_DIV ") .append(" AND ZM0171_BMP_KOJI_STAT.MK_FLG = '0') AS BMP_KOJI_STAT_NM, ") .append(" (SELECT ZM0171_HOJIN_KOJIN.CD_DIV_ALI ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_HOJIN_KOJIN ") .append(" WHERE ZM0171_HOJIN_KOJIN.CD_SBT_CD = 'CD00004' ") .append(" AND TU0011.HOJIN_KOJIN_CD = ZM0171_HOJIN_KOJIN.CD_DIV ") .append(" AND ZM0171_HOJIN_KOJIN.MK_FLG = '0') AS HOJIN_KOJIN_CD_NM, ") .append(" (SELECT ZM0171_BMP_MSKMSHO_TYPE.CD_DIV_ALI ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_BMP_MSKMSHO_TYPE ") .append(" WHERE ZM0171_BMP_MSKMSHO_TYPE.CD_SBT_CD = 'CD00524' ") .append(" AND TU0011.BMP_MSKMSHO_TYPE_CD = ZM0171_BMP_MSKMSHO_TYPE.CD_DIV ") .append(" AND ZM0171_BMP_MSKMSHO_TYPE.MK_FLG = '0') AS BMP_MSKMSHO_TYPE_CD_NM, ") .append(" (SELECT ZM0171_DOJI_KOJI_UM.CD_DIV_ALI ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_DOJI_KOJI_UM ") .append(" WHERE ZM0171_DOJI_KOJI_UM.CD_SBT_CD = 'CD00002' ") .append(" AND TU0011.DOJI_KOJI_UM = ZM0171_DOJI_KOJI_UM.CD_DIV ") .append(" AND ZM0171_DOJI_KOJI_UM.MK_FLG = '0') AS DOJI_KOJI_UM_NM, ") .append(" (SELECT ZM0171_DOBANITEN_UM.CD_DIV_ALI ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_DOBANITEN_UM ") .append(" WHERE ZM0171_DOBANITEN_UM.CD_SBT_CD = 'CD00002' ") .append(" AND TU0011.DOBANITEN_UM = ZM0171_DOBANITEN_UM.CD_DIV ") .append(" AND ZM0171_DOBANITEN_UM.MK_FLG = '0') AS DOBANITEN_UM_NM, ") .append(" (SELECT ZM0171_BMPKJ_KIBO_TIME.CD_DIV_ALI ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_BMPKJ_KIBO_TIME ") .append(" WHERE ZM0171_BMPKJ_KIBO_TIME.CD_SBT_CD = 'CD00008' ") .append(" AND TU0011.BMPKJ_KIBO_TIME_CD = ZM0171_BMPKJ_KIBO_TIME.CD_DIV ") .append(" AND ZM0171_BMPKJ_KIBO_TIME.MK_FLG = '0') AS BMPKJ_KIBO_TIME_CD_NM, ") .append(" (SELECT ZM0171_BMPKJ_KIBO_YMD_PDING.CD_DIV_ALI ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_BMPKJ_KIBO_YMD_PDING ") .append(" WHERE ZM0171_BMPKJ_KIBO_YMD_PDING.CD_SBT_CD = 'CD00426' ") .append(" AND TU0011.BMPKJ_KIBO_YMD_PDING_FLG = ZM0171_BMPKJ_KIBO_YMD_PDING.CD_DIV ") .append(" AND ZM0171_BMPKJ_KIBO_YMD_PDING.MK_FLG = '0') AS BMPKJ_KIBO_YMD_PDING_FLG_NM, ") .append(" (SELECT ZM0051_UK_TNTSHA.USER_NM ") .append(" FROM ZM_M_USER ZM0051_UK_TNTSHA ") .append(" WHERE TU0011.BMP_UK_TNT_USER_ID = ZM0051_UK_TNTSHA.USER_ID ") .append(" AND ZM0051_UK_TNTSHA.MK_FLG = '0') AS BMP_UK_TNT_USER_ID_NM, ") .append(" (SELECT ZM0051_TNT_TNTSHA.USER_NM ") .append(" FROM ZM_M_USER ZM0051_TNT_TNTSHA ") .append(" WHERE TU0011.BMPKJ_TNT_USER_ID = ZM0051_TNT_TNTSHA.USER_ID ") .append(" AND ZM0051_TNT_TNTSHA.MK_FLG = '0') AS BMPKJ_TNT_USER_ID_NM, ") .append(" (SELECT ZM0171_TEL_KNKN_TRAT.CD_DIV_ALI ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_TEL_KNKN_TRAT ") .append(" WHERE ZM0171_TEL_KNKN_TRAT.CD_SBT_CD = 'CD00006' ") .append(" AND TU0011.TEL_KNKN_TRAT_CD = ZM0171_TEL_KNKN_TRAT.CD_DIV ") .append(" AND ZM0171_TEL_KNKN_TRAT.MK_FLG = '0') AS TEL_KNKN_TRAT_CD_NM, ") .append(" TU0051_ITNM_TSJGS.TSJGS_NM AS ITNM_TSJGS_CD_NM, ") .append(" TU0131_ITNM_TSJGS.TSJGS_KTN_NM AS ITNM_TSJGS_KTN_CD_NM, ") .append(" TU0051_BMPKJ_MSKM_MT_TSJGS.TSJGS_NM AS BMPKJ_MSKM_MT_TSJGS_CD_NM, ") .append(" (SELECT ZM0171_MSKMJIG_SNAI_KOJI_UM.CD_DIV_ALI ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_MSKMJIG_SNAI_KOJI_UM ") // 2024/03/11 ANK-4494-00-00 MOD START // .append(" WHERE ZM0171_MSKMJIG_SNAI_KOJI_UM.CD_SBT_CD = 'CD00002' ") .append(" WHERE ZM0171_MSKMJIG_SNAI_KOJI_UM.CD_SBT_CD = 'CD01839' ") // 2024/03/11 ANK-4494-00-00 MOD END .append(" AND TU0011.MSKMJIG_SNAI_KOJI_UM = ZM0171_MSKMJIG_SNAI_KOJI_UM.CD_DIV ") .append(" AND ZM0171_MSKMJIG_SNAI_KOJI_UM.MK_FLG = '0') AS MSKMJIG_SNAI_KOJI_UM_NM, ") .append(" (SELECT ZM0171_MSKMJIG_SGAI_KOJI_UM.CD_DIV_ALI ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_MSKMJIG_SGAI_KOJI_UM ") // 2024/03/11 ANK-4494-00-00 MOD START // .append(" WHERE ZM0171_MSKMJIG_SGAI_KOJI_UM.CD_SBT_CD = 'CD00002' ") .append(" WHERE ZM0171_MSKMJIG_SGAI_KOJI_UM.CD_SBT_CD = 'CD01839' ") // 2024/03/11 ANK-4494-00-00 MOD END .append(" AND TU0011.MSKMJIG_SGAI_KOJI_UM = ZM0171_MSKMJIG_SGAI_KOJI_UM.CD_DIV ") .append(" AND ZM0171_MSKMJIG_SGAI_KOJI_UM.MK_FLG = '0') AS MSKMJIG_SGAI_KOJI_UM_NM, ") .append(" (SELECT ZM0171_BMPKJ_FIX_TIME.CD_DIV_ALI ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_BMPKJ_FIX_TIME ") .append(" WHERE ZM0171_BMPKJ_FIX_TIME.CD_SBT_CD = 'CD00008' ") .append(" AND TU0011.BMPKJ_FIX_TIME_CD = ZM0171_BMPKJ_FIX_TIME.CD_DIV ") .append(" AND ZM0171_BMPKJ_FIX_TIME.MK_FLG = '0') AS BMPKJ_FIX_TIME_CD_NM, ") .append(" (SELECT ZM0171_TA_JIGYOSHA_MI_CFM.CD_DIV_ALI ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_TA_JIGYOSHA_MI_CFM ") .append(" WHERE ZM0171_TA_JIGYOSHA_MI_CFM.CD_SBT_CD = 'CD00191' ") .append(" AND TU0011.TA_JIGYOSHA_MI_CFM_FLG = ZM0171_TA_JIGYOSHA_MI_CFM.CD_DIV ") .append(" AND ZM0171_TA_JIGYOSHA_MI_CFM.MK_FLG = '0') AS TA_JIGYOSHA_MI_CFM_FLG_NM, ") .append(" (SELECT ZM0171_TA_JIGYOSHA_ODR_SBT.CD_DIV_ALI ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_TA_JIGYOSHA_ODR_SBT ") .append(" WHERE ZM0171_TA_JIGYOSHA_ODR_SBT.CD_SBT_CD = 'CD00453' ") .append(" AND TU0011.TA_JIGYOSHA_ODR_SBT_CD = ZM0171_TA_JIGYOSHA_ODR_SBT.CD_DIV ") .append(" AND ZM0171_TA_JIGYOSHA_ODR_SBT.MK_FLG = '0') AS TA_JIGYOSHA_ODR_SBT_CD_NM, ") .append(" TU0041_BMP_MSKM_JIGSHO.MSKM_JIGSHONM AS BMP_MSKM_JIGSHO_NO_NM, ") .append(" TU0041_BMP_KOJI_MSKM_JIGSHO.MSKM_JIGSHONM AS BMP_KOJI_MSKM_JIGSHO_NO_NM, ") .append(" (SELECT ZM0171_HOJIN_RSLT_OPUT_ZUMI.CD_DIV_ALI ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_HOJIN_RSLT_OPUT_ZUMI ") .append(" WHERE ZM0171_HOJIN_RSLT_OPUT_ZUMI.CD_SBT_CD = 'CD00581' ") .append(" AND TU0011.HOJIN_RSLT_OPUT_ZUMI_FLG = ZM0171_HOJIN_RSLT_OPUT_ZUMI.CD_DIV ") .append(" AND ZM0171_HOJIN_RSLT_OPUT_ZUMI.MK_FLG = '0') AS HOJIN_RSLT_OPUT_ZUMI_FLG_NM, ") .append(" (SELECT ZM0051_ADD.USER_NM ") .append(" FROM ZM_M_USER ZM0051_ADD ") .append(" WHERE TU0011.ADD_OPEACNT = ZM0051_ADD.USER_ID ") .append(" AND ZM0051_ADD.MK_FLG = '0') AS ADD_USER_NM, ") .append(" (SELECT ZM0051_UPD.USER_NM ") .append(" FROM ZM_M_USER ZM0051_UPD ") .append(" WHERE TU0011.UPD_OPEACNT = ZM0051_UPD.USER_ID ") .append(" AND ZM0051_UPD.MK_FLG = '0') AS UPD_USER_NM, ") .append(" (SELECT ZM0051_DEL.USER_NM ") .append(" FROM ZM_M_USER ZM0051_DEL ") .append(" WHERE TU0011.DEL_OPEACNT = ZM0051_DEL.USER_ID ") .append(" AND ZM0051_DEL.MK_FLG = '0') AS DEL_USER_NM, ") .append(" TU0041_BMP_MSKM_JIGSHO.KOPT_RRK_MDGC_TELNO AS BMP_MSKM_TNTSHA_TELNO, ") .append(" TU0041_BMP_MSKM_JIGSHO.KOPT_RRK_MDGC_FAX_NO AS BMP_MSKM_TNTSHA_FAX_NO, ") .append(" TU0041_BMP_KOJI_MSKM_JIGSHO.KOPT_RRK_MDGC_TELNO AS BMP_KOJI_MSKM_TNTSHA_TELNO, ") .append(" TU0041_BMP_KOJI_MSKM_JIGSHO.KOPT_RRK_MDGC_FAX_NO AS BMP_KOJI_MSKM_TNTSHA_FAX_NO, ") .append(" TU0011.PAUSE_HYO_SOHUS_CD, ") .append(" TU0011.TIOKR_RNK_INF_SKSI_ZM_FLG, ") .append(" (SELECT ZM0171_PAUSE_HYO_SOHUS_CD.CD_DIV_ALI ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_PAUSE_HYO_SOHUS_CD ") .append(" WHERE ZM0171_PAUSE_HYO_SOHUS_CD.CD_SBT_CD = 'CD01249' ") .append(" AND TU0011.PAUSE_HYO_SOHUS_CD = ZM0171_PAUSE_HYO_SOHUS_CD.CD_DIV ") .append(" AND ZM0171_PAUSE_HYO_SOHUS_CD.MK_FLG = '0') AS PAUSE_HYO_SOHUS_CD_NM, ") .append(" (SELECT ZM0171_TIOKR_RNK_INF_SKSIZMFLG.CD_DIV_ALI ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_TIOKR_RNK_INF_SKSIZMFLG ") .append(" WHERE ZM0171_TIOKR_RNK_INF_SKSIZMFLG.CD_SBT_CD = 'CD00581' ") .append(" AND TU0011.TIOKR_RNK_INF_SKSI_ZM_FLG = ZM0171_TIOKR_RNK_INF_SKSIZMFLG.CD_DIV ") .append(" AND ZM0171_TIOKR_RNK_INF_SKSIZMFLG.MK_FLG = '0') AS TIOKR_RNK_INF_SKSI_ZM_FLG_NM, ") .append(" TU0011.NKYS_AD_MAN_INPUT_FLG, ") .append(" TU0011.SETPLACE_AD_MAN_INPUT_FLG, ") .append(" TU0011.KNKN_ITNSAD_MAN_INPUT_FLG, ") .append(" (SELECT ZM0171_NKYS_MANINPUT.CD_DIV_ALI ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_NKYS_MANINPUT ") .append(" WHERE ZM0171_NKYS_MANINPUT.CD_SBT_CD = 'CD01239' ") .append(" AND TU0011.NKYS_AD_MAN_INPUT_FLG = ZM0171_NKYS_MANINPUT.CD_DIV ") .append(" AND ZM0171_NKYS_MANINPUT.MK_FLG = '0') AS NKYS_AD_MAN_INPUT_FLG_NM, ") .append(" (SELECT ZM0171_SETPLACE_MANINPUT.CD_DIV_ALI ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_SETPLACE_MANINPUT ") .append(" WHERE ZM0171_SETPLACE_MANINPUT.CD_SBT_CD = 'CD01239' ") .append(" AND TU0011.SETPLACE_AD_MAN_INPUT_FLG = ZM0171_SETPLACE_MANINPUT.CD_DIV ") .append(" AND ZM0171_SETPLACE_MANINPUT.MK_FLG = '0') AS SETPLACE_AD_MAN_INPUT_FLG_NM, ") .append(" (SELECT ZM0171_KNKN_ITNS_MANINPUT.CD_DIV_ALI ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_KNKN_ITNS_MANINPUT ") .append(" WHERE ZM0171_KNKN_ITNS_MANINPUT.CD_SBT_CD = 'CD01239' ") .append(" AND TU0011.KNKN_ITNSAD_MAN_INPUT_FLG = ZM0171_KNKN_ITNS_MANINPUT.CD_DIV ") .append(" AND ZM0171_KNKN_ITNS_MANINPUT.MK_FLG = '0') AS KNKN_ITNSAD_MAN_INPUT_FLG_NM, ") .append(" TU0011.DOJI_KOJI_JDG_CD, ") .append(" TU0011.TNKJ_RSVD_HANEI_YMD, ") .append(" TU0011.TNKJ_RSVD_HANEI_ZM_FLG, ") .append(" (SELECT ZM0171_DOJI_KOJI_JDG_CD.CD_DIV_ALI ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_DOJI_KOJI_JDG_CD ") .append(" WHERE ZM0171_DOJI_KOJI_JDG_CD.CD_SBT_CD = 'CD01578' ") .append(" AND TU0011.DOJI_KOJI_JDG_CD = ZM0171_DOJI_KOJI_JDG_CD.CD_DIV ") .append(" AND ZM0171_DOJI_KOJI_JDG_CD.MK_FLG = '0') AS DOJI_KOJI_JDG_CD_NM, ") .append(" (SELECT ZM0171_TNKJ_RSVD_HANEI_ZM_FLG.CD_DIV_ALI ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_TNKJ_RSVD_HANEI_ZM_FLG ") .append(" WHERE ZM0171_TNKJ_RSVD_HANEI_ZM_FLG.CD_SBT_CD = 'CD00581' ") .append(" AND TU0011.TNKJ_RSVD_HANEI_ZM_FLG = ZM0171_TNKJ_RSVD_HANEI_ZM_FLG.CD_DIV ") .append(" AND ZM0171_TNKJ_RSVD_HANEI_ZM_FLG.MK_FLG = '0') AS TNKJ_RSVD_HANEI_ZM_FLG_NM, ") .append(" TU0011.JGSK_ADJ_RSLT_TRKM_YMD, ") .append(" TU0011.BMP_KJ_MSKM_RSLT_TRKM_YMD, ") .append(" TU0011.JGSK_ADJ_RSLT_TRKM_DTM, ") // 2024/03/11 ANK-4494-00-00 MOD START // .append(" TU0011.BMP_KJ_MSKM_RSLT_TRKM_DTM ") .append(" TU0011.BMP_KJ_MSKM_RSLT_TRKM_DTM, ") .append(" TU0011.AUTO_HAISHI_RYSHZM_NO_NUM, ") .append(" TU0011.ITENS_JIGYOSHA_DOMAIN, ") .append(" TU0011.ITENS_JIGYOSHA_TELNO, ") .append(" TU0011.KIJIRAN_1_ITNM_JGSMK, ") .append(" TU0011.KIJIRAN_2_ITNM_JGSMK, ") .append(" TU0011.KIJIRAN_1_NOSK_JGSMK, ") .append(" TU0011.KIJIRAN_2_NOSK_JGSMK, ") .append(" TU0011.JI_SHANAI_KIJIRAN, ") .append(" TU0011.SETPLACE_AD_CHGE_UM, ") .append(" TU0011.SETPLC_HTNY_SKBT_CITY_NM, ") .append(" TU0011.SETPLC_HTNY_SKBT_OAZTSU_NM, ") .append(" TU0011.SETPLC_HTNY_SKBT_AZCHO_NM, ") .append(" TU0011.KOJI_JSSI_WAY, ") .append(" TU0011.SOTEI_SWITCH_TIMEZ, ") .append(" TU0011.BMP_PSTN_DRYCOPPER_USE_UM, ") .append(" TU0011.TOGO_ODR_ID, ") .append(" TU0011.ITENS_MSKM_DAY, ") .append(" TU0011.BMP_ORDER_NO, ") .append(" TU0011.CHUMN_KIND, ") .append(" TU0011.ITNM_ODKH_JDGTK_KH_KTDT, ") .append(" TU0011.ITNM_KIJIRAN_ITENS_JGSMK, ") .append(" TU0011.ITNM_ODKH_JDGTK_KH, ") .append(" TU0011.ITNM_ODKH_JDGTK_FRSN, ") .append(" TU0011.ITNM_ODKH_JDGTK_FRSN_OTR, ") .append(" TU0011.ITNM_UK_TNT_NM, ") .append(" TU0011.ITNM_UK_TNT_TELNO, ") .append(" TU0011.ITNM_KOJI_TNT_NM, ") .append(" TU0011.ITNM_KOJI_TNT_TELNO, ") .append(" TU0011.NOSK_ODKH_JDGTK_KH_KTDT, ") .append(" TU0011.NOSK_KIJIRAN_ITENS_JGSMK, ") .append(" TU0011.NOSK_ODKH_JDGTK_KH, ") .append(" TU0011.NOSK_ODKH_JDGTK_FRSN, ") .append(" TU0011.NOSK_ODKH_JDGTK_FRSN_OTR, ") .append(" TU0011.NOSK_UK_TNT_NM, ") .append(" TU0011.NOSK_UK_TNT_TELNO, ") .append(" TU0011.NOSK_KOJI_TNT_NM, ") .append(" TU0011.NOSK_KOJI_TNT_TELNO, ") .append(" TU0011.ITNM_ANS_WAY_SKBT, ") .append(" TU0011.NOSK_ANS_WAY_SKBT, ") .append(" TU0011.NAIBU_SKBT_NO, ") .append(" TU0011.ITNM_TK_KH_KTDT, ") .append(" TU0011.ITNM_TK_KH, ") .append(" TU0011.ITNM_TK_FRSN, ") .append(" TU0011.ITNM_TK_FRSN_OTR_RSN, ") .append(" TU0011.NOSK_TK_KH_KTDT, ") .append(" TU0011.NOSK_TK_KH, ") .append(" TU0011.NOSK_TK_FRSN, ") .append(" TU0011.NOSK_TK_FRSN_OTR_RSN, ") .append(" TU0011.TLN_STKU_TSJGS_CD, ") .append(" TU0011.SWITCH_SOD_HAKKO_DTM, ") .append(" TU0011.HBI_LIST_OPUTZM_FLG, ") .append(" (SELECT ZM0171_SETPLACE_AD_CHGE_UM.CD_DIV_ALI ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_SETPLACE_AD_CHGE_UM ") .append(" WHERE ZM0171_SETPLACE_AD_CHGE_UM.CD_SBT_CD = 'CD00002' ") .append(" AND TU0011.SETPLACE_AD_CHGE_UM = ZM0171_SETPLACE_AD_CHGE_UM.CD_DIV ") .append(" AND ZM0171_SETPLACE_AD_CHGE_UM.MK_FLG = '0') AS SETPLACE_AD_CHGE_UM_NM, ") .append(" (SELECT ZM0171_SETPLC_HTNY_SKBT_CITY.CD_DIV_ALI ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_SETPLC_HTNY_SKBT_CITY ") .append(" WHERE ZM0171_SETPLC_HTNY_SKBT_CITY.CD_SBT_CD = 'CD00002' ") .append(" AND TU0011.SETPLC_HTNY_SKBT_CITY_NM = ZM0171_SETPLC_HTNY_SKBT_CITY.CD_DIV ") .append(" AND ZM0171_SETPLC_HTNY_SKBT_CITY.MK_FLG = '0') AS SETPLC_HTNY_SKBT_CITY_NM_NM, ") .append(" (SELECT ZM0171_SETPLC_HTNY_SKBT_OAZTSU.CD_DIV_ALI ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_SETPLC_HTNY_SKBT_OAZTSU ") .append(" WHERE ZM0171_SETPLC_HTNY_SKBT_OAZTSU.CD_SBT_CD = 'CD00002' ") .append(" AND TU0011.SETPLC_HTNY_SKBT_OAZTSU_NM = ZM0171_SETPLC_HTNY_SKBT_OAZTSU.CD_DIV ") .append(" AND ZM0171_SETPLC_HTNY_SKBT_OAZTSU.MK_FLG = '0') AS SETPLC_HTNY_SKBT_OAZTSU_NM_NM, ") .append(" (SELECT ZM0171_SETPLC_HTNY_SKBT_AZCHO.CD_DIV_ALI ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_SETPLC_HTNY_SKBT_AZCHO ") .append(" WHERE ZM0171_SETPLC_HTNY_SKBT_AZCHO.CD_SBT_CD = 'CD00002' ") .append(" AND TU0011.SETPLC_HTNY_SKBT_AZCHO_NM = ZM0171_SETPLC_HTNY_SKBT_AZCHO.CD_DIV ") .append(" AND ZM0171_SETPLC_HTNY_SKBT_AZCHO.MK_FLG = '0') AS SETPLC_HTNY_SKBT_AZCHO_NM_NM, ") .append(" (SELECT ZM0171_KOJI_JSSI_WAY.CD_DIV_ALI ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_KOJI_JSSI_WAY ") .append(" WHERE ZM0171_KOJI_JSSI_WAY.CD_SBT_CD = 'CD01832' ") .append(" AND TU0011.KOJI_JSSI_WAY = ZM0171_KOJI_JSSI_WAY.CD_DIV ") .append(" AND ZM0171_KOJI_JSSI_WAY.MK_FLG = '0') AS KOJI_JSSI_WAY_NM, ") .append(" (SELECT ZM0171_SOTEI_SWITCH_TIMEZ.CD_DIV_ALI ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_SOTEI_SWITCH_TIMEZ ") .append(" WHERE ZM0171_SOTEI_SWITCH_TIMEZ.CD_SBT_CD in ('CD01833','CD01837') ") .append(" AND TU0011.SOTEI_SWITCH_TIMEZ = ZM0171_SOTEI_SWITCH_TIMEZ.CD_DIV ") .append(" AND ZM0171_SOTEI_SWITCH_TIMEZ.MK_FLG = '0') AS SOTEI_SWITCH_TIMEZ_NM, ") .append(" (SELECT ZM0171_BMP_PSTN_DRYCOPPER_UM.CD_DIV_ALI ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_BMP_PSTN_DRYCOPPER_UM ") .append(" WHERE ZM0171_BMP_PSTN_DRYCOPPER_UM.CD_SBT_CD = 'CD00002' ") .append(" AND TU0011.BMP_PSTN_DRYCOPPER_USE_UM = ZM0171_BMP_PSTN_DRYCOPPER_UM.CD_DIV ") .append(" AND ZM0171_BMP_PSTN_DRYCOPPER_UM.MK_FLG = '0') AS BMP_PSTN_DRYCOPPER_USE_UM_NM, ") .append(" (SELECT ZM0171_CHUMN_KIND.CD_DIV_ALI ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_CHUMN_KIND ") .append(" WHERE ZM0171_CHUMN_KIND.CD_SBT_CD = 'CD01838' ") .append(" AND TU0011.CHUMN_KIND = ZM0171_CHUMN_KIND.CD_DIV ") .append(" AND ZM0171_CHUMN_KIND.MK_FLG = '0') AS CHUMN_KIND_NM, ") .append(" (SELECT ZM0171_ITNM_ODKH_JDGTK_KH.CD_DIV_ALI ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_ITNM_ODKH_JDGTK_KH ") .append(" WHERE ZM0171_ITNM_ODKH_JDGTK_KH.CD_SBT_CD = 'CD01834' ") .append(" AND TU0011.ITNM_ODKH_JDGTK_KH = ZM0171_ITNM_ODKH_JDGTK_KH.CD_DIV ") .append(" AND ZM0171_ITNM_ODKH_JDGTK_KH.MK_FLG = '0') AS ITNM_ODKH_JDGTK_KH_NM, ") .append(" (SELECT ZM0171_NOSK_ODKH_JDGTK_KH.CD_DIV_ALI ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_NOSK_ODKH_JDGTK_KH ") .append(" WHERE ZM0171_NOSK_ODKH_JDGTK_KH.CD_SBT_CD = 'CD01834' ") .append(" AND TU0011.NOSK_ODKH_JDGTK_KH = ZM0171_NOSK_ODKH_JDGTK_KH.CD_DIV ") .append(" AND ZM0171_NOSK_ODKH_JDGTK_KH.MK_FLG = '0') AS NOSK_ODKH_JDGTK_KH_NM, ") .append(" (SELECT ZM0171_ITNM_TK_KH.CD_DIV_ALI ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_ITNM_TK_KH ") .append(" WHERE ZM0171_ITNM_TK_KH.CD_SBT_CD = 'CD01834' ") .append(" AND TU0011.ITNM_TK_KH = ZM0171_ITNM_TK_KH.CD_DIV ") .append(" AND ZM0171_ITNM_TK_KH.MK_FLG = '0') AS ITNM_TK_KH_NM, ") .append(" (SELECT ZM0171_NOSK_TK_KH.CD_DIV_ALI ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_NOSK_TK_KH ") .append(" WHERE ZM0171_NOSK_TK_KH.CD_SBT_CD = 'CD01834' ") .append(" AND TU0011.NOSK_TK_KH = ZM0171_NOSK_TK_KH.CD_DIV ") .append(" AND ZM0171_NOSK_TK_KH.MK_FLG = '0') AS NOSK_TK_KH_NM, ") .append(" TU0051_TLN_STKU_TSJGS.TSJGS_NM AS TLN_STKU_TSJGS_CD_NM, ") .append(" (SELECT ZM0171_HBI_LIST_OPUTZM_FLG.CD_DIV_ALI ") .append(" FROM ZM_M_CD_NM_KANRI ZM0171_HBI_LIST_OPUTZM_FLG ") .append(" WHERE ZM0171_HBI_LIST_OPUTZM_FLG.CD_SBT_CD = 'CD00581' ") .append(" AND TU0011.HBI_LIST_OPUTZM_FLG = ZM0171_HBI_LIST_OPUTZM_FLG.CD_DIV ") .append(" AND ZM0171_HBI_LIST_OPUTZM_FLG.MK_FLG = '0') AS HBI_LIST_OPUTZM_FLG_NM ") // 2024/03/11 ANK-4494-00-00 MOD END .append(" FROM ") .append(" TU_T_BMP_KOJI TU0011 ") .append(" LEFT OUTER JOIN TU_M_TUSHIN_JGYOSHA TU0051_ITNM_TSJGS ") .append(" ON TU0011.ITNM_TSJGS_CD = TU0051_ITNM_TSJGS.TSJGS_CD ") .append(" AND TU0051_ITNM_TSJGS.MK_FLG = '0' ") .append(" LEFT OUTER JOIN TU_M_TUSHIN_JGS_KTN TU0131_ITNM_TSJGS ") .append(" ON TU0011.ITNM_TSJGS_CD = TU0131_ITNM_TSJGS.TSJGS_CD ") .append(" AND TU0011.ITNM_TSJGS_KTN_CD = TU0131_ITNM_TSJGS.TSJGS_KTN_CD ") .append(" AND TU0131_ITNM_TSJGS.MK_FLG = '0' ") .append(" LEFT OUTER JOIN TU_M_TUSHIN_JGYOSHA TU0051_BMPKJ_MSKM_MT_TSJGS ") .append(" ON TU0011.BMPKJ_MSKM_MT_TSJGS_CD = TU0051_BMPKJ_MSKM_MT_TSJGS.TSJGS_CD ") .append(" AND TU0051_BMPKJ_MSKM_MT_TSJGS.MK_FLG = '0' ") .append(" LEFT OUTER JOIN TU_M_MSKM_JIGSHO TU0041_BMP_MSKM_JIGSHO ") .append(" ON TU0011.BMP_MSKM_JIGSHO_NO = TU0041_BMP_MSKM_JIGSHO.MSKM_JIGSHO_NO ") .append(" AND TU0041_BMP_MSKM_JIGSHO.MK_FLG = '0' ") .append(" LEFT OUTER JOIN TU_M_MSKM_JIGSHO TU0041_BMP_KOJI_MSKM_JIGSHO ") .append(" ON TU0011.BMP_KOJI_MSKM_JIGSHO_NO = TU0041_BMP_KOJI_MSKM_JIGSHO.MSKM_JIGSHO_NO ") // 2024/03/11 ANK-4494-00-00 MOD START // .append(" AND TU0041_BMP_KOJI_MSKM_JIGSHO.MK_FLG = '0' "); .append(" AND TU0041_BMP_KOJI_MSKM_JIGSHO.MK_FLG = '0' ") .append(" LEFT OUTER JOIN TU_M_TUSHIN_JGYOSHA TU0051_TLN_STKU_TSJGS ") .append(" ON TU0011.TLN_STKU_TSJGS_CD = TU0051_TLN_STKU_TSJGS.TSJGS_CD ") .append(" AND TU0051_TLN_STKU_TSJGS.MK_FLG = '0' "); // 2024/03/11 ANK-4494-00-00 MOD END // SQL文_個別部1 if("1".equals(inMsg.getObject(ETU0011A010CBSMsg.FUNC_CODE).toString())) { sql_Buff.append(" WHERE ") .append(" TU0011.BMP_KOJI_NO = ? ") .append(" AND TU0011.GENE_ADD_DTM = ? ") .append(" AND TU0011.MK_FLG = '0' "); } if("2".equals(inMsg.getObject(ETU0011A010CBSMsg.FUNC_CODE).toString())) { sql_Buff.append(" WHERE ") .append(" TU0011.MK_FLG = '0' ") .append(" AND TU0011.BMP_KOJI_NO = ? ") .append(" AND TU0011.GENE_ADD_DTM = ") .append(" (SELECT ") .append(" MAX(TU0011_GENE.GENE_ADD_DTM) ") .append(" FROM ") .append(" TU_T_BMP_KOJI TU0011_GENE ") .append(" WHERE TU0011_GENE.BMP_KOJI_NO = TU0011.BMP_KOJI_NO ") .append(" AND TU0011_GENE.MK_FLG = '0') "); } //prepareStatementにSQL文をセット pstmt = con1.prepareStatement(sql_Buff.toString()); //ログ出力(SQL文の出力) JSYejbLog.outlog(inContext, JSYejbLog.DBACCESS, this.getClass(), sql_Buff); // PreparedStatementの指定されたパラメータカラムに 指定された値を設定 if("1".equals(inMsg.getString(ETU0011A010CBSMsg.FUNC_CODE))) { // パラメータの設定(ＫＥＹ＿番ポ工事番号を指定) CAANJDBCUtil.setParam(pstmt, 1, inMsg.getObject(ETU0011A010CBSMsg.KEY_BMP_KOJI_NO)); // パラメータの設定(ＫＥＹ＿世代登録年月日時分秒を指定) CAANJDBCUtil.setParam(pstmt, 2, inMsg.getObject(ETU0011A010CBSMsg.KEY_GENE_ADD_DTM)); } if("2".equals(inMsg.getString(ETU0011A010CBSMsg.FUNC_CODE))) { // パラメータの設定(ＫＥＹ＿番ポ工事番号を指定) CAANJDBCUtil.setParam(pstmt, 1, inMsg.getObject(ETU0011A010CBSMsg.KEY_BMP_KOJI_NO)); } // ResultSetの取得 rsltQuery = pstmt.executeQuery(); // ETU0011A010CBSMsgの明細にセットする項目 String[] msgKeyList1 = { ETU0011A010CBSMsg1List.BMP_KOJI_NO , ETU0011A010CBSMsg1List.GENE_ADD_DTM , ETU0011A010CBSMsg1List.BMP_KOJI_STAT , ETU0011A010CBSMsg1List.SVC_KEI_UCWK_NO , ETU0011A010CBSMsg1List.HOJIN_SVC_KEI_UK_NO , ETU0011A010CBSMsg1List.HJIN_EO_YKAE_SVKEI_NO , ETU0011A010CBSMsg1List.HOJIN_KOJIN_CD , ETU0011A010CBSMsg1List.CUST_MSKM_YMD , ETU0011A010CBSMsg1List.BMP_MSKMSHO_TYPE_CD , ETU0011A010CBSMsg1List.DOJI_KOJI_UM , ETU0011A010CBSMsg1List.DOBANITEN_UM , ETU0011A010CBSMsg1List.NTT_KEI_TEL_KAISEN_NO , ETU0011A010CBSMsg1List.TA_JGYOSHA_UR_NO , ETU0011A010CBSMsg1List.ROUTING_NO , ETU0011A010CBSMsg1List.NTT_KEISHA_NM , ETU0011A010CBSMsg1List.NTT_KSH_KANA , ETU0011A010CBSMsg1List.NTT_KEISHA_AD_CD , ETU0011A010CBSMsg1List.NTT_KEISHA_PCD , ETU0011A010CBSMsg1List.NTT_KEISHA_STATE_NM , ETU0011A010CBSMsg1List.NTT_KEISHA_CITY_NM , ETU0011A010CBSMsg1List.NTT_KEISHA_OAZTSU_NM , ETU0011A010CBSMsg1List.NTT_KEISHA_AZCHO_NM , ETU0011A010CBSMsg1List.NTT_KEISHA_BNCHIGO , ETU0011A010CBSMsg1List.NTT_KEISHA_ADRTTM , ETU0011A010CBSMsg1List.NTT_KEISHA_ADRRM , ETU0011A010CBSMsg1List.RRKS_TELNO , ETU0011A010CBSMsg1List.SETPLACE_AD_CD , ETU0011A010CBSMsg1List.SETPLACE_PCD , ETU0011A010CBSMsg1List.SETPLACE_STATE_NM , ETU0011A010CBSMsg1List.SETPLACE_CITY_NM , ETU0011A010CBSMsg1List.SETPLACE_OAZTSU_NM , ETU0011A010CBSMsg1List.SETPLACE_AZCHO_NM , ETU0011A010CBSMsg1List.SETPLACE_BNCHIGO , ETU0011A010CBSMsg1List.SETPLACE_ADRTTM , ETU0011A010CBSMsg1List.SETPLACE_ADRRM , ETU0011A010CBSMsg1List.BMP_KOJI_UK_YMD , ETU0011A010CBSMsg1List.BMP_KOJI_KIBO_YMDH , ETU0011A010CBSMsg1List.BMPKJ_KIBO_TIME_CD , ETU0011A010CBSMsg1List.BMPKJ_KIBO_YMD_PDING_FLG , ETU0011A010CBSMsg1List.BMP_UK_TNT_USER_ID , ETU0011A010CBSMsg1List.BMPKJ_TNT_USER_ID , ETU0011A010CBSMsg1List.TEL_KNKN_TRAT_CD , ETU0011A010CBSMsg1List.TEL_KNKN_TRAT_OTR_MEMO , ETU0011A010CBSMsg1List.KANYKN_ITENS_AD_CD , ETU0011A010CBSMsg1List.KANYKN_ITENS_PCD , ETU0011A010CBSMsg1List.KANYKN_ITENS_STATE_NM , ETU0011A010CBSMsg1List.KANYKN_ITENS_CITY_NM , ETU0011A010CBSMsg1List.KANYKN_ITENS_OAZTSU_NM , ETU0011A010CBSMsg1List.KANYKN_ITENS_AZCHO_NM , ETU0011A010CBSMsg1List.KANYKN_ITENS_BNCHIGO , ETU0011A010CBSMsg1List.KANYKN_ITENS_ADRTTM , ETU0011A010CBSMsg1List.KANYKN_ITENS_ADRRM , ETU0011A010CBSMsg1List.ITNM_TSJGS_CD , ETU0011A010CBSMsg1List.ITNM_TSJGS_KTN_CD , ETU0011A010CBSMsg1List.MSKMJIG_USE_CD , ETU0011A010CBSMsg1List.BMPKJ_MSKM_MT_TSJGS_CD , ETU0011A010CBSMsg1List.HUKUSU_KAISEN_BMP_UM , ETU0011A010CBSMsg1List.HUKUSU_KAISEN_BMP_CNT , ETU0011A010CBSMsg1List.HUKUSU_KAISEN_GRP_ID , ETU0011A010CBSMsg1List.MSKMJIG_SNAI_KOJI_UM , ETU0011A010CBSMsg1List.MSKMJIG_SGAI_KOJI_UM , ETU0011A010CBSMsg1List.MSKMJIG_KIJIRAN_1 , ETU0011A010CBSMsg1List.MSKMJIG_KIJIRAN_2 , ETU0011A010CBSMsg1List.MSKMJIG_MSKM_YMDHM , ETU0011A010CBSMsg1List.BMP_KOJI_CHOSA_REQYMD , ETU0011A010CBSMsg1List.TAJGS_RNKI_SEND_DTM , ETU0011A010CBSMsg1List.TA_JGS_REQ_CNT , ETU0011A010CBSMsg1List.TA_JGYOSHA_RNKI_WAY_CD , ETU0011A010CBSMsg1List.JGSHAK_RTRN_ADJ_SKBT_NO , ETU0011A010CBSMsg1List.NTT_RNKI_SEND_DTM , ETU0011A010CBSMsg1List.NTT_REQ_CNT , ETU0011A010CBSMsg1List.NTT_RNKI_WAY_CD , ETU0011A010CBSMsg1List.NTT_REQ_SKBT_NO , ETU0011A010CBSMsg1List.CHGE_MOTO_ORDER_SKBT_NO , ETU0011A010CBSMsg1List.NTT_REQ_ORDER_CHGRE_MEMO , ETU0011A010CBSMsg1List.TK_KH_ANS_YMD , ETU0011A010CBSMsg1List.BMP_KOJI_KH , ETU0011A010CBSMsg1List.BMP_KOJI_FIX_YMDH , ETU0011A010CBSMsg1List.BMPKJ_FIX_TIME_CD , ETU0011A010CBSMsg1List.TK_FAIL_RSN_CD , ETU0011A010CBSMsg1List.TK_FAIL_RSN_MEMO , ETU0011A010CBSMsg1List.TA_JIGYOSHA_MI_CFM_FLG , ETU0011A010CBSMsg1List.BMP_KOJI_REQYMD , ETU0011A010CBSMsg1List.BMP_KOJI_REQ_RSLT_CD , ETU0011A010CBSMsg1List.TAJGS_UK_NO , ETU0011A010CBSMsg1List.TAJGS_TNTSHA_NM , ETU0011A010CBSMsg1List.TAJGS_TELNO , ETU0011A010CBSMsg1List.TAJGS_FAX_NO , ETU0011A010CBSMsg1List.TAJGS_KIJIRAN , ETU0011A010CBSMsg1List.TAJGS_UK_YMD , ETU0011A010CBSMsg1List.TA_JIGYOSHA_ODR_SBT_CD , ETU0011A010CBSMsg1List.TA_JIGYOSHA_ORG_NM , ETU0011A010CBSMsg1List.NTT_UK_NO , ETU0011A010CBSMsg1List.NTT_TNTSHA_NM , ETU0011A010CBSMsg1List.NTT_TELNO , ETU0011A010CBSMsg1List.NTT_FAX_NO , ETU0011A010CBSMsg1List.NTT_SNAI_KOJI_UM , ETU0011A010CBSMsg1List.NTT_SGAI_KOJI_UM , ETU0011A010CBSMsg1List.NTT_KIJIRAN , ETU0011A010CBSMsg1List.NTT_UK_YMD , ETU0011A010CBSMsg1List.BMP_KOJI_FIN_YMD , ETU0011A010CBSMsg1List.BMP_MSKM_JIGSHO_NO , ETU0011A010CBSMsg1List.BMP_KOJI_MSKM_JIGSHO_NO , ETU0011A010CBSMsg1List.BMP_KOJI_STP_CD , ETU0011A010CBSMsg1List.BMP_KOJI_STP_YMD , ETU0011A010CBSMsg1List.HOJIN_RSLT_OPUT_ZUMI_FLG , ETU0011A010CBSMsg1List.ADD_DTM , ETU0011A010CBSMsg1List.ADD_OPEACNT , ETU0011A010CBSMsg1List.UPD_DTM , ETU0011A010CBSMsg1List.UPD_OPEACNT , ETU0011A010CBSMsg1List.DEL_DTM , ETU0011A010CBSMsg1List.DEL_OPEACNT , ETU0011A010CBSMsg1List.MK_FLG , ETU0011A010CBSMsg1List.BMP_KOJI_STAT_NM , ETU0011A010CBSMsg1List.HOJIN_KOJIN_CD_NM , ETU0011A010CBSMsg1List.BMP_MSKMSHO_TYPE_CD_NM , ETU0011A010CBSMsg1List.DOJI_KOJI_UM_NM , ETU0011A010CBSMsg1List.DOBANITEN_UM_NM , ETU0011A010CBSMsg1List.BMPKJ_KIBO_TIME_CD_NM , ETU0011A010CBSMsg1List.BMPKJ_KIBO_YMD_PDING_FLG_NM , ETU0011A010CBSMsg1List.BMP_UK_TNT_USER_ID_NM , ETU0011A010CBSMsg1List.BMPKJ_TNT_USER_ID_NM , ETU0011A010CBSMsg1List.TEL_KNKN_TRAT_CD_NM , ETU0011A010CBSMsg1List.ITNM_TSJGS_CD_NM , ETU0011A010CBSMsg1List.ITNM_TSJGS_KTN_CD_NM , ETU0011A010CBSMsg1List.BMPKJ_MSKM_MT_TSJGS_CD_NM , ETU0011A010CBSMsg1List.MSKMJIG_SNAI_KOJI_UM_NM , ETU0011A010CBSMsg1List.MSKMJIG_SGAI_KOJI_UM_NM , ETU0011A010CBSMsg1List.BMPKJ_FIX_TIME_CD_NM , ETU0011A010CBSMsg1List.TA_JIGYOSHA_MI_CFM_FLG_NM , ETU0011A010CBSMsg1List.TA_JIGYOSHA_ODR_SBT_CD_NM , ETU0011A010CBSMsg1List.BMP_MSKM_JIGSHO_NM , ETU0011A010CBSMsg1List.BMP_KOJI_MSKM_JIGSHO_NM , ETU0011A010CBSMsg1List.HOJIN_RSLT_OPUT_ZUMI_FLG_NM , ETU0011A010CBSMsg1List.ADD_OPEACNT_NM , ETU0011A010CBSMsg1List.UPD_OPEACNT_NM , ETU0011A010CBSMsg1List.DEL_OPEACNT_NM , ETU0011A010CBSMsg1List.BMP_MSKM_TNTSHA_TELNO , ETU0011A010CBSMsg1List.BMP_MSKM_TNTSHA_FAX_NO , ETU0011A010CBSMsg1List.BMP_KOJI_MSKM_TNTSHA_TELNO , ETU0011A010CBSMsg1List.BMP_KOJI_MSKM_TNTSHA_FAX_NO , ETU0011A010CBSMsg1List.PAUSE_HYO_SOHUS_CD , ETU0011A010CBSMsg1List.TIOKR_RNK_INF_SKSI_ZM_FLG , ETU0011A010CBSMsg1List.PAUSE_HYO_SOHUS_CD_NM , ETU0011A010CBSMsg1List.TIOKR_RNK_INF_SKSI_ZM_FLG_NM , ETU0011A010CBSMsg1List.NKYS_AD_MAN_INPUT_FLG , ETU0011A010CBSMsg1List.SETPLACE_AD_MAN_INPUT_FLG , ETU0011A010CBSMsg1List.KNKN_ITNSAD_MAN_INPUT_FLG , ETU0011A010CBSMsg1List.NKYS_AD_MAN_INPUT_FLG_NM , ETU0011A010CBSMsg1List.SETPLACE_AD_MAN_INPUT_FLG_NM , ETU0011A010CBSMsg1List.KNKN_ITNSAD_MAN_INPUT_FLG_NM , ETU0011A010CBSMsg1List.DOJI_KOJI_JDG_CD , ETU0011A010CBSMsg1List.TNKJ_RSVD_HANEI_YMD , ETU0011A010CBSMsg1List.TNKJ_RSVD_HANEI_ZM_FLG , ETU0011A010CBSMsg1List.DOJI_KOJI_JDG_CD_NM , ETU0011A010CBSMsg1List.TNKJ_RSVD_HANEI_ZM_FLG_NM , ETU0011A010CBSMsg1List.JGSK_ADJ_RSLT_TRKM_YMD , ETU0011A010CBSMsg1List.BMP_KJ_MSKM_RSLT_TRKM_YMD , ETU0011A010CBSMsg1List.JGSK_ADJ_RSLT_TRKM_DTM , ETU0011A010CBSMsg1List.BMP_KJ_MSKM_RSLT_TRKM_DTM // 2024/03/11 ANK-4494-00-00 ADD START , ETU0011A010CBSMsg1List.AUTO_HAISHI_RYSHZM_NO_NUM , ETU0011A010CBSMsg1List.ITENS_JIGYOSHA_DOMAIN , ETU0011A010CBSMsg1List.ITENS_JIGYOSHA_TELNO , ETU0011A010CBSMsg1List.KIJIRAN_1_ITNM_JGSMK , ETU0011A010CBSMsg1List.KIJIRAN_2_ITNM_JGSMK , ETU0011A010CBSMsg1List.KIJIRAN_1_NOSK_JGSMK , ETU0011A010CBSMsg1List.KIJIRAN_2_NOSK_JGSMK , ETU0011A010CBSMsg1List.JI_SHANAI_KIJIRAN , ETU0011A010CBSMsg1List.SETPLACE_AD_CHGE_UM , ETU0011A010CBSMsg1List.SETPLC_HTNY_SKBT_CITY_NM , ETU0011A010CBSMsg1List.SETPLC_HTNY_SKBT_OAZTSU_NM , ETU0011A010CBSMsg1List.SETPLC_HTNY_SKBT_AZCHO_NM , ETU0011A010CBSMsg1List.KOJI_JSSI_WAY , ETU0011A010CBSMsg1List.SOTEI_SWITCH_TIMEZ , ETU0011A010CBSMsg1List.BMP_PSTN_DRYCOPPER_USE_UM , ETU0011A010CBSMsg1List.TOGO_ODR_ID , ETU0011A010CBSMsg1List.ITENS_MSKM_DAY , ETU0011A010CBSMsg1List.BMP_ORDER_NO , ETU0011A010CBSMsg1List.CHUMN_KIND , ETU0011A010CBSMsg1List.ITNM_ODKH_JDGTK_KH_KTDT , ETU0011A010CBSMsg1List.ITNM_KIJIRAN_ITENS_JGSMK , ETU0011A010CBSMsg1List.ITNM_ODKH_JDGTK_KH , ETU0011A010CBSMsg1List.ITNM_ODKH_JDGTK_FRSN , ETU0011A010CBSMsg1List.ITNM_ODKH_JDGTK_FRSN_OTR , ETU0011A010CBSMsg1List.ITNM_UK_TNT_NM , ETU0011A010CBSMsg1List.ITNM_UK_TNT_TELNO , ETU0011A010CBSMsg1List.ITNM_KOJI_TNT_NM , ETU0011A010CBSMsg1List.ITNM_KOJI_TNT_TELNO , ETU0011A010CBSMsg1List.NOSK_ODKH_JDGTK_KH_KTDT , ETU0011A010CBSMsg1List.NOSK_KIJIRAN_ITENS_JGSMK , ETU0011A010CBSMsg1List.NOSK_ODKH_JDGTK_KH , ETU0011A010CBSMsg1List.NOSK_ODKH_JDGTK_FRSN , ETU0011A010CBSMsg1List.NOSK_ODKH_JDGTK_FRSN_OTR , ETU0011A010CBSMsg1List.NOSK_UK_TNT_NM , ETU0011A010CBSMsg1List.NOSK_UK_TNT_TELNO , ETU0011A010CBSMsg1List.NOSK_KOJI_TNT_NM , ETU0011A010CBSMsg1List.NOSK_KOJI_TNT_TELNO , ETU0011A010CBSMsg1List.ITNM_ANS_WAY_SKBT , ETU0011A010CBSMsg1List.NOSK_ANS_WAY_SKBT , ETU0011A010CBSMsg1List.NAIBU_SKBT_NO , ETU0011A010CBSMsg1List.ITNM_TK_KH_KTDT , ETU0011A010CBSMsg1List.ITNM_TK_KH , ETU0011A010CBSMsg1List.ITNM_TK_FRSN , ETU0011A010CBSMsg1List.ITNM_TK_FRSN_OTR_RSN , ETU0011A010CBSMsg1List.NOSK_TK_KH_KTDT , ETU0011A010CBSMsg1List.NOSK_TK_KH , ETU0011A010CBSMsg1List.NOSK_TK_FRSN , ETU0011A010CBSMsg1List.NOSK_TK_FRSN_OTR_RSN , ETU0011A010CBSMsg1List.TLN_STKU_TSJGS_CD , ETU0011A010CBSMsg1List.SWITCH_SOD_HAKKO_DTM , ETU0011A010CBSMsg1List.HBI_LIST_OPUTZM_FLG , ETU0011A010CBSMsg1List.SETPLACE_AD_CHGE_UM_NM , ETU0011A010CBSMsg1List.SETPLC_HTNY_SKBT_CITY_NM_NM , ETU0011A010CBSMsg1List.SETPLC_HTNY_SKBT_OAZTSU_NM_NM , ETU0011A010CBSMsg1List.SETPLC_HTNY_SKBT_AZCHO_NM_NM , ETU0011A010CBSMsg1List.KOJI_JSSI_WAY_NM , ETU0011A010CBSMsg1List.SOTEI_SWITCH_TIMEZ_NM , ETU0011A010CBSMsg1List.BMP_PSTN_DRYCOPPER_USE_UM_NM , ETU0011A010CBSMsg1List.CHUMN_KIND_NM , ETU0011A010CBSMsg1List.ITNM_ODKH_JDGTK_KH_NM , ETU0011A010CBSMsg1List.NOSK_ODKH_JDGTK_KH_NM , ETU0011A010CBSMsg1List.ITNM_TK_KH_NM , ETU0011A010CBSMsg1List.NOSK_TK_KH_NM , ETU0011A010CBSMsg1List.TLN_STKU_TSJGS_CD_NM , ETU0011A010CBSMsg1List.HBI_LIST_OPUTZM_FLG_NM // 2024/03/11 ANK-4494-00-00 ADD END }; // 明細に処理結果(ResultSet)をマッピング CAANMsg[] outMsg1 = mapMessageList(rsltQuery, msgKeyList1, "eo.ejb.cbs.cbsmsg.ETU0011A010CBSMsg1List", 0); // inMsg(CBSMsg)に明細をセット inMsg.set("ETU0011A010CBSMsg1List", outMsg1); // 検索件数が0件の場合、エラーフラグに"1"を設定して処理終了 if (0 == outMsg1.length) { inMsg.set(ETU0011A010CBSMsg.SEARCH_ERR_FLG, JPCModelConstant.SEARCH_ERR_FLG_ZERO); return; } } catch(SQLException e) { inMsg.set(ETU0011A010CBSMsg.STATUS, StatusCodes.FIND_DB_ERR); throw new CAANRuntimeException(e); } finally { // 資源の解放 try { if(rsltQuery != null) { rsltQuery.close(); } if(pstmt != null) { pstmt.close(); } if(con1 != null) { closeConnection(con1); } } catch(SQLException e) { inMsg.set(ETU0011A010CBSMsg.STATUS, StatusCodes.FIND_DB_ERR); throw new CAANRuntimeException(e); } } } }