/*******************************************************************************
* All Rights reserved,Copyright (c) K-Opticom
********************************************************************************
*＜プログラム内容＞
* システム名 ：eo顧客基幹システム
* モジュール名 ：JSYejbEKK0011A010TPDA
* ソースファイル名：JSYejbEKK0011A010TPDA.java
* 作成者 ：EK918345
* 日付 ：2016年11月17日
*＜機能概要＞
* 申込一意照会テンプレートDBアクセス部品です。
*＜修正履歴＞
* バージョン 修正日 修正者 修正内容
* ｖ1.00.00
* ｖ29.00.00 2017/03/30 FJ)クウン 【ANK-3158-00-00_訪販申込情報の検索・取得API作成】
* ｖ33.00.00 2017/10/17 FJ)柳 【ANK-3307-00-00】訪販申込情報閲覧システム向けAPIへの工事進捗・キャンセル状況取得機能追加
* ｖ38.00.00 2018/07/04 FJ)大崎 【ANK-3436-00-00】eo光×eo電気×mineoセット割対応
* ｖ52.00.00 2021/01/14 FJ)星野 【ANK-3910-00-00】定額サービスリース品追加対応
* ｖ53.00.00 2021/04/19 FJ)西川 【ANK-4009-00-00】CX戦略WG方針対応
* ｖ73.00.00 2024/10/18 FJ)森下 【ANK-4427-00-00】NTT卸対応
********************************************************************************/
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.ejb.cbs.cbsmsg.EKK0011A010CBSMsg;
import eo.ejb.cbs.cbsmsg.EKK0011A010CBSMsg1List;
import eo.ejb.cbm.entity.KK0011ETMsg;
import eo.ejb.common.JKKModelCommon;
/**
*
* テンプレートDBアクセス部品 EKK0011A010_SQLF
* 入力された項目からSQL文を動的に組み立て、
* 検索結果をCBSMsgにセットします。
*/
public class JSYejbEKK0011A010TPDA extends CAANSQLFacility implements TemplateDBAccessHandler{
/**
* コンストラクタ
*/
public JSYejbEKK0011A010TPDA() {
}
/**
* EKK0011A010_SQLF
* @param inMsg 入力値の格納されたCBSMsg
* @return void
*/
public void invoke(CAANMsg inMsg,AgentDispatchContext inContext){
// コネクション
Connection con1 = null;
// プリペアステートメント
PreparedStatement pstmt = null;
// リザルトセット
ResultSet rsltQuery = null;
/********************
* SQL文の作成
********************/
try{
//コネクション取得
con1 = JSYejbConnection.getConnection(KK0011ETMsg.getTableName());
// SQL文_基本部1
StringBuffer sql_Buff = new StringBuffer();
sql_Buff.append(" SELECT ")
.append(" KK0011.MSKM_NO, ")
.append(" KK0011.GENE_ADD_DTM, ")
.append(" KK0011.MSKM_STAT, ")
.append(" (SELECT ")
.append(" ZM0171_01.CD_DIV_NM ")
.append(" FROM ")
.append(" ZM_M_CD_NM_KANRI ZM0171_01 ")
.append(" WHERE ")
.append(" ZM0171_01.CD_SBT_CD = 'CD00060' AND ")
.append(" ZM0171_01.CD_DIV = KK0011.MSKM_STAT AND ")
.append(" ZM0171_01.MK_FLG = '0' ")
.append(" ) AS MSKM_STAT_NM, ")
.append(" KK0011.SYSID, ")
.append(" (SELECT ")
.append(" CK0011.CUST_NM ")
.append(" FROM ")
.append(" CK_T_CUST CK0011 ")
.append(" WHERE ")
.append(" CK0011.SYSID = KK0011.SYSID AND ")
.append(" (CK0011.SYSID, CK0011.RSV_APLY_YMD || CK0011.GENE_ADD_DTM) = ")
.append(" (SELECT ")
.append(" CK0011_GENE.SYSID, MAX(CK0011_GENE.RSV_APLY_YMD || CK0011_GENE.GENE_ADD_DTM) AS MAX ")
.append(" FROM ")
.append(" CK_T_CUST CK0011_GENE ")
.append(" WHERE ")
.append(" CK0011_GENE.SYSID = CK0011.SYSID AND ")
.append(" CK0011_GENE.RSV_APLY_YMD <= ? AND ")
.append(" CK0011_GENE.RSV_APLY_CD = '2' AND ")
.append(" CK0011_GENE.MK_FLG = '0' ")
.append(" GROUP BY CK0011_GENE.SYSID ")
.append(" ) ")
.append(" )SYSID_NM, ")
.append(" KK0011.MSKM_SBT_CD, ")
.append(" (SELECT ")
.append(" KK0971.MSKM_SBT_NM ")
.append(" FROM ")
.append(" KK_M_MSKM_SBT KK0971 ")
.append(" WHERE ")
.append(" KK0971.MSKM_SBT_CD = KK0011.MSKM_SBT_CD AND ")
.append(" KK0971.MK_FLG = '0' ")
.append(" ) AS MSKM_SBT_CD_NM, ")
.append(" KK0011.MSKMSHO_ARIV_YMD, ")
.append(" KK0011.MSKM_UK_DTM, ")
.append(" KK0011.MSKM_UK_TNT_USER_ID, ")
.append(" KK0011.MSKM_YMD, ")
.append(" KK0011.TTL_BUSINESS_CENTER_UK_NO, ")
.append(" KK0011.TTL_BUSINESS_MSKM_OPT_CD, ")
.append(" KK0011.MSKM_RRKS_TELNO, ")
.append(" KK0011.MSKM_JSSIS_SBT_CD, ")
.append(" KK0011.CUST_YOBO_JIKO, ")
.append(" KK0011.TEL_RRK_KIBO_TIME_CD, ")
.append(" KK0011.TAKCHO_KIBO_TIME_CD, ")
.append(" KK0011.MSKM_PDING_DTM, ")
.append(" KK0011.MSKM_PDING_RSN_CD, ")
.append(" KK0011.MSKM_PDING_RLS_YMD, ")
.append(" KK0011.MSKM_RTRN_YMD, ")
.append(" KK0011.MSKM_RTRN_RSN_CD, ")
.append(" KK0011.KARI_MSKM_FLG, ")
.append(" KK0011.MSKM_NAIYO_CFM_FIN_YMD, ")
.append(" KK0011.MSKM_CANCEL_YMD, ")
.append(" KK0011.MSKM_CANCEL_RSN_CD, ")
.append(" KK0011.MSKM_CANCEL_CL_YMD, ")
.append(" KK0011.REFERER, ")
.append(" KK0011.LAST_SCREEN_ID, ")
.append(" KK0011.MSKM_NYO_SHONIN_SHIN_YMD, ")
.append(" KK0011.MSKM_NYO_SHONIN_YMD, ")
.append(" KK0011.KEPCO_CUSTINFO_JUJU_DOI_UM, ")
.append(" (SELECT ")
.append(" ZM0171_03.CD_DIV_NM ")
.append(" FROM ")
.append(" ZM_M_CD_NM_KANRI ZM0171_03 ")
.append(" WHERE ")
.append(" ZM0171_03.CD_SBT_CD = 'CD00002' AND ")
.append(" ZM0171_03.CD_DIV = KK0011.KEPCO_CUSTINFO_JUJU_DOI_UM AND ")
.append(" ZM0171_03.MK_FLG = '0' ")
.append(" ) AS KEPCO_CUSTINFO_JUJU_DOI_UM_NM, ")
.append(" KK0011.AGNT_SHUK_KMK_CD, ")
.append(" KK0011.ADD_DTM, ")
.append(" KK0011.ADD_OPEACNT, ")
.append(" KK0011.UPD_DTM, ")
.append(" KK0011.UPD_OPEACNT, ")
.append(" KK0011.DEL_DTM, ")
.append(" KK0011.DEL_OPEACNT, ")
.append(" KK0011.MK_FLG, ")
.append(" (SELECT ")
.append(" ZM0171_02.CD_DIV_NM ")
.append(" FROM ")
.append(" ZM_M_CD_NM_KANRI ZM0171_02 ")
.append(" WHERE ")
.append(" ZM0171_02.CD_SBT_CD = 'CD00016' AND ")
.append(" ZM0171_02.CD_DIV = KK0011.MK_FLG AND ")
.append(" ZM0171_02.MK_FLG = '0' ")
.append(" ) AS MK_FLG_NM, ")
.append(" (SELECT ")
.append(" MAX(KK0011_SUB.UPD_DTM) ")
.append(" FROM ")
.append(" KK_T_MSKM KK0011_SUB ")
.append(" WHERE ")
.append(" KK0011_SUB.MSKM_NO = KK0011.MSKM_NO ")
.append(" ) AS LAST_UPD_DTM, ")
.append(" KK0011.TEL_RRK_KIBOD_SBT_CD, ")
.append(" (SELECT ")
.append(" ZM0171_07.CD_DIV_NM ")
.append(" FROM ")
.append(" ZM_M_CD_NM_KANRI ZM0171_07 ")
.append(" WHERE ")
.append(" ZM0171_07.CD_SBT_CD = 'CD00708' AND ")
.append(" ZM0171_07.CD_DIV = KK0011.TEL_RRK_KIBOD_SBT_CD AND ")
.append(" ZM0171_07.MK_FLG = '0' ")
.append(" ) AS TEL_RRK_KIBOD_SBT_CD_NM, ")
.append(" KK0011.TAKCHO_KIBOD_SBT_CD, ")
.append(" (SELECT ")
.append(" ZM0171_08.CD_DIV_NM ")
.append(" FROM ")
.append(" ZM_M_CD_NM_KANRI ZM0171_08 ")
.append(" WHERE ")
.append(" ZM0171_08.CD_SBT_CD = 'CD00708' AND ")
.append(" ZM0171_08.CD_DIV = KK0011.TAKCHO_KIBOD_SBT_CD AND ")
.append(" ZM0171_08.MK_FLG = '0' ")
.append(" ) AS TAKCHO_KIBOD_SBT_CD_NM, ")
.append(" KK0011.SHOSA_BF_RRK_JIKO_YH, ")
.append(" (SELECT ")
.append(" ZM0171_09.CD_DIV_NM ")
.append(" FROM ")
.append(" ZM_M_CD_NM_KANRI ZM0171_09 ")
.append(" WHERE ")
.append(" ZM0171_09.CD_SBT_CD = 'CD00001' AND ")
.append(" ZM0171_09.CD_DIV = KK0011.SHOSA_BF_RRK_JIKO_YH AND ")
.append(" ZM0171_09.MK_FLG = '0' ")
.append(" ) AS SHOSA_BF_RRK_JIKO_YH_NM, ")
.append(" KK0011.SHOSA_BF_RRK_JIKO, ")
.append(" KK0011.USE_SVC_KEIZK_SBT_CD, ")
.append(" (SELECT ")
.append(" ZM0171_10.CD_DIV_NM ")
.append(" FROM ")
.append(" ZM_M_CD_NM_KANRI ZM0171_10 ")
.append(" WHERE ")
.append(" ZM0171_10.CD_SBT_CD = 'CD00758' AND ")
.append(" ZM0171_10.CD_DIV = KK0011.USE_SVC_KEIZK_SBT_CD AND ")
.append(" ZM0171_10.MK_FLG = '0' ")
.append(" ) AS USE_SVC_KEIZK_SBT_CD_NM, ")
.append(" KK0011.ANTENNA_RENT_KIBO_UM, ")
.append(" (SELECT ")
.append(" ZM0171_11.CD_DIV_NM ")
.append(" FROM ")
.append(" ZM_M_CD_NM_KANRI ZM0171_11 ")
.append(" WHERE ")
.append(" ZM0171_11.CD_SBT_CD = 'CD00002' AND ")
.append(" ZM0171_11.CD_DIV = KK0011.ANTENNA_RENT_KIBO_UM AND ")
.append(" ZM0171_11.MK_FLG = '0' ")
.append(" ) AS ANTENNA_RENT_KIBO_UM_NM, ")
.append(" KK0011.RTRN_CHU_MSKM_ABDMNT_DTM, ")
.append(" KK0011.CONSMBSN_MSKM_STAT_SKBT_CD, ")
.append(" (SELECT ")
.append(" ZM0171_12.CD_DIV_NM ")
.append(" FROM ")
.append(" ZM_M_CD_NM_KANRI ZM0171_12 ")
.append(" WHERE ")
.append(" ZM0171_12.CD_SBT_CD = 'CD00760' AND ")
.append(" ZM0171_12.CD_DIV = KK0011.CONSMBSN_MSKM_STAT_SKBT_CD AND ")
.append(" ZM0171_12.MK_FLG = '0' ")
.append(" ) AS CONSMBSN_MSKM_STAT_SKBT_CD_NM, ")
.append(" KK0011.UK_TNTSHA_SKBT_CD, ")
.append(" KK0011.KOJI_REQ_INFO_RRK_JIKO, ")
.append(" KK0011.MSKM_ROUTE_SKBT_CD, ")
.append(" (SELECT ")
.append(" ZM0171_13.CD_DIV_NM ")
.append(" FROM ")
.append(" ZM_M_CD_NM_KANRI ZM0171_13 ")
.append(" WHERE ")
.append(" ZM0171_13.CD_SBT_CD = 'CD00751' AND ")
.append(" ZM0171_13.CD_DIV = KK0011.MSKM_ROUTE_SKBT_CD AND ")
.append(" ZM0171_13.MK_FLG = '0' ")
.append(" ) AS MSKM_ROUTE_SKBT_CD_NM, ")
.append(" (SELECT ")
.append(" ZM0171_14.CD_DIV_NM ")
.append(" FROM ")
.append(" ZM_M_CD_NM_KANRI ZM0171_14 ")
.append(" WHERE ")
.append(" ZM0171_14.CD_SBT_CD = 'CD00709' AND ")
.append(" ZM0171_14.CD_DIV = KK0011.TEL_RRK_KIBO_TIME_CD AND ")
.append(" ZM0171_14.MK_FLG = '0' ")
.append(" ) AS TEL_RRK_KIBO_TIME_CD_NM ")
.append(" ,KK0011.AGNT_MSKM_TRTG_UM ")
.append(" ,(SELECT ")
.append(" ZM0171_15.CD_DIV_NM ")
.append(" FROM ")
.append(" ZM_M_CD_NM_KANRI ZM0171_15 ")
.append(" WHERE ")
.append(" ZM0171_15.CD_SBT_CD = 'CD00002' AND ")
.append(" ZM0171_15.CD_DIV = KK0011.AGNT_MSKM_TRTG_UM AND ")
.append(" ZM0171_15.MK_FLG = '0' ")
.append(" ) AS AGNT_MSKM_TRTG_UM_NM ")
.append(" ,KK0011.TKJCP_CD ")
.append(" ,KK0011.TKJCP_NM ")
.append(" ,KK0011.TKJCP_STNEGS_NM ")
.append(" ,KK0011.TKJCPTTS_NM ")
.append(" ,KK0011.TKJCPTTS_SHKSNM ")
.append(" ,KK0011.TKJCPTTS_TLN ")
.append(" ,KK0011.BUNJOCHI_NM ")
.append(" ,KK0011.BUNJOCHI_KKK_NO_MEMO ")
.append(" ,KK0011.NYUKYO_RSV_JK ")
.append(" ,KK0011.AGNT_MKM_UK_EOSTF_USER_ID ")
.append(" ,KK0011.AGNT_MKM_UK_RHSTF_KANA_SEI ")
//---------v29.00.00 ANK-3158 ADD START---------//
.append(" ,KK0011.THNX_CALL_JSSI_YMD ")
// ANK-3307-00-00 2017/10/17 DEL START
// .append(" ,KK0011.MSKM_CNCL_JGI_SNN_SHIN_YMD ")
// .append(" ,KK0011.MSKM_CNCL_JGI_SNN_YMD ")
// .append(" ,KK0011.MSKM_CNCL_JGI_HNN_YMD ")
// ANK-3307-00-00 2017/10/17 DEL END
//---------v29.00.00 ANK-3158 ADD END-----------//
// ANK-3436-00-00 2018/07/04 ADD START
.append(" ,KK0011.SET_WARI_MKM_SKBT_DIV ")
.append(" ,KK0011.SET_WARI_MKM_SKBT_NO ")
// ANK-3436-00-00 2018/07/04 ADD END
// ANK-3910-00-00対応 20210114 星野 ADD START
.append(" ,KK0011.TEGAK_SVC_MSKM_KIKI ")
// ANK-3910-00-00対応 20210114 星野 ADD END
.append(" ,KK0011.SKBT_KEY ")
// ANK-4427-00-00 ADD START
.append(" ,KK0011.ITENM_SVC_KEI_NO ")
// ANK-4427-00-00 ADD END
.append(" FROM ")
.append(" KK_T_MSKM KK0011 ");
// SQL文_個別部1
if ( "1".equals( inMsg.getObject(EKK0011A010CBSMsg.FUNC_CODE).toString() ) ) {
sql_Buff.append(" WHERE ")
.append(" KK0011.MSKM_NO = ? AND ")
.append(" KK0011.GENE_ADD_DTM = ? AND ")
.append(" KK0011.MK_FLG = '0' ");
}
if ( "2".equals( inMsg.getObject(EKK0011A010CBSMsg.FUNC_CODE).toString() ) ) {
sql_Buff.append(" WHERE ")
.append(" KK0011.MSKM_NO = ? AND ")
.append(" (KK0011.MSKM_NO, KK0011.GENE_ADD_DTM) = ")
.append(" (SELECT ")
.append(" KK0011_GENE.MSKM_NO, MAX(KK0011_GENE.GENE_ADD_DTM) AS KK0011_MAX ")
.append(" FROM ")
.append(" KK_T_MSKM KK0011_GENE ")
.append(" WHERE ")
.append(" KK0011_GENE.MSKM_NO = KK0011.MSKM_NO AND ")
.append(" KK0011_GENE.MK_FLG = '0' ")
.append(" GROUP BY KK0011_GENE.MSKM_NO ")
.append(" ) ");
}
//prepareStatementにSQL文をセット
pstmt = con1.prepareStatement(sql_Buff.toString());
//ログ出力(SQL文の出力)
JSYejbLog.outlog(inContext, JSYejbLog.DBACCESS, this.getClass(), sql_Buff);
// PreparedStatementの指定されたパラメータカラムに 指定された値を設定
if ( "1".equals( inMsg.getString(EKK0011A010CBSMsg.FUNC_CODE) ) ) {
// パラメータの設定(システム日付を指定)
CAANJDBCUtil.setParam(pstmt, 1, JKKModelCommon.getOpeDate(inMsg));
// パラメータの設定(ＫＥＹ＿申込番号を指定)
CAANJDBCUtil.setParam(pstmt, 2, inMsg.getObject(EKK0011A010CBSMsg.KEY_MSKM_NO));
// パラメータの設定(ＫＥＹ＿世代登録年月日時分秒を指定)
CAANJDBCUtil.setParam(pstmt, 3, inMsg.getObject(EKK0011A010CBSMsg.KEY_GENE_ADD_DTM));
}
if ( "2".equals( inMsg.getString(EKK0011A010CBSMsg.FUNC_CODE) ) ) {
// パラメータの設定(システム日付を指定)
CAANJDBCUtil.setParam(pstmt, 1, JKKModelCommon.getOpeDate(inMsg));
// パラメータの設定(ＫＥＹ＿申込番号を指定)
CAANJDBCUtil.setParam(pstmt, 2, inMsg.getObject(EKK0011A010CBSMsg.KEY_MSKM_NO));
}
// ResultSetの取得
rsltQuery = pstmt.executeQuery();
// EKK0011A010CBSMsgの明細にセットする項目
String[] msgKeyList1 = {
EKK0011A010CBSMsg1List.MSKM_NO
, EKK0011A010CBSMsg1List.GENE_ADD_DTM
, EKK0011A010CBSMsg1List.MSKM_STAT
, EKK0011A010CBSMsg1List.MSKM_STAT_NM
, EKK0011A010CBSMsg1List.SYSID
, EKK0011A010CBSMsg1List.SYSID_NM
, EKK0011A010CBSMsg1List.MSKM_SBT_CD
, EKK0011A010CBSMsg1List.MSKM_SBT_CD_NM
, EKK0011A010CBSMsg1List.MSKMSHO_ARIV_YMD
, EKK0011A010CBSMsg1List.MSKM_UK_DTM
, EKK0011A010CBSMsg1List.MSKM_UK_TNT_USER_ID
, EKK0011A010CBSMsg1List.MSKM_YMD
, EKK0011A010CBSMsg1List.TTL_BUSINESS_CENTER_UK_NO
, EKK0011A010CBSMsg1List.TTL_BUSINESS_MSKM_OPT_CD
, EKK0011A010CBSMsg1List.MSKM_RRKS_TELNO
, EKK0011A010CBSMsg1List.MSKM_JSSIS_SBT_CD
, EKK0011A010CBSMsg1List.CUST_YOBO_JIKO
, EKK0011A010CBSMsg1List.TEL_RRK_KIBO_TIME_CD
, EKK0011A010CBSMsg1List.TAKCHO_KIBO_TIME_CD
, EKK0011A010CBSMsg1List.MSKM_PDING_DTM
, EKK0011A010CBSMsg1List.MSKM_PDING_RSN_CD
, EKK0011A010CBSMsg1List.MSKM_PDING_RLS_YMD
, EKK0011A010CBSMsg1List.MSKM_RTRN_YMD
, EKK0011A010CBSMsg1List.MSKM_RTRN_RSN_CD
, EKK0011A010CBSMsg1List.KARI_MSKM_FLG
, EKK0011A010CBSMsg1List.MSKM_NAIYO_CFM_FIN_YMD
, EKK0011A010CBSMsg1List.MSKM_CANCEL_YMD
, EKK0011A010CBSMsg1List.MSKM_CANCEL_RSN_CD
, EKK0011A010CBSMsg1List.MSKM_CANCEL_CL_YMD
, EKK0011A010CBSMsg1List.REFERER
, EKK0011A010CBSMsg1List.LAST_SCREEN_ID
, EKK0011A010CBSMsg1List.MSKM_NYO_SHONIN_SHIN_YMD
, EKK0011A010CBSMsg1List.MSKM_NYO_SHONIN_YMD
, EKK0011A010CBSMsg1List.KEPCO_CUSTINFO_JUJU_DOI_UM
, EKK0011A010CBSMsg1List.KEPCO_CUSTINFO_JUJU_DOI_UM_NM
, EKK0011A010CBSMsg1List.AGNT_SHUK_KMK_CD
, EKK0011A010CBSMsg1List.ADD_DTM
, EKK0011A010CBSMsg1List.ADD_OPEACNT
, EKK0011A010CBSMsg1List.UPD_DTM
, EKK0011A010CBSMsg1List.UPD_OPEACNT
, EKK0011A010CBSMsg1List.DEL_DTM
, EKK0011A010CBSMsg1List.DEL_OPEACNT
, EKK0011A010CBSMsg1List.MK_FLG
, EKK0011A010CBSMsg1List.MK_FLG_NM
, EKK0011A010CBSMsg1List.LAST_UPD_DTM
, EKK0011A010CBSMsg1List.TEL_RRK_KIBOD_SBT_CD
, EKK0011A010CBSMsg1List.TEL_RRK_KIBOD_SBT_CD_NM
, EKK0011A010CBSMsg1List.TAKCHO_KIBOD_SBT_CD
, EKK0011A010CBSMsg1List.TAKCHO_KIBOD_SBT_CD_NM
, EKK0011A010CBSMsg1List.SHOSA_BF_RRK_JIKO_YH
, EKK0011A010CBSMsg1List.SHOSA_BF_RRK_JIKO_YH_NM
, EKK0011A010CBSMsg1List.SHOSA_BF_RRK_JIKO
, EKK0011A010CBSMsg1List.USE_SVC_KEIZK_SBT_CD
, EKK0011A010CBSMsg1List.USE_SVC_KEIZK_SBT_CD_NM
, EKK0011A010CBSMsg1List.ANTENNA_RENT_KIBO_UM
, EKK0011A010CBSMsg1List.ANTENNA_RENT_KIBO_UM_NM
, EKK0011A010CBSMsg1List.RTRN_CHU_MSKM_ABDMNT_DTM
, EKK0011A010CBSMsg1List.CONSMBSN_MSKM_STAT_SKBT_CD
, EKK0011A010CBSMsg1List.CONSMBSN_MSKM_STAT_SKBT_CD_NM
, EKK0011A010CBSMsg1List.UK_TNTSHA_SKBT_CD
, EKK0011A010CBSMsg1List.KOJI_REQ_INFO_RRK_JIKO
, EKK0011A010CBSMsg1List.MSKM_ROUTE_SKBT_CD
, EKK0011A010CBSMsg1List.MSKM_ROUTE_SKBT_CD_NM
, EKK0011A010CBSMsg1List.TEL_RRK_KIBO_TIME_CD_NM
, EKK0011A010CBSMsg1List.AGNT_MSKM_TRTG_UM
, EKK0011A010CBSMsg1List.AGNT_MSKM_TRTG_UM_NM
, EKK0011A010CBSMsg1List.TKJCP_CD
, EKK0011A010CBSMsg1List.TKJCP_NM
, EKK0011A010CBSMsg1List.TKJCP_STNEGS_NM
, EKK0011A010CBSMsg1List.TKJCPTTS_NM
, EKK0011A010CBSMsg1List.TKJCPTTS_SHKSNM
, EKK0011A010CBSMsg1List.TKJCPTTS_TLN
, EKK0011A010CBSMsg1List.BUNJOCHI_NM
, EKK0011A010CBSMsg1List.BUNJOCHI_KKK_NO_MEMO
, EKK0011A010CBSMsg1List.NYUKYO_RSV_JK
, EKK0011A010CBSMsg1List.AGNT_MKM_UK_EOSTF_USER_ID
, EKK0011A010CBSMsg1List.AGNT_MKM_UK_RHSTF_KANA_SEI
//---------v29.00.00 ANK-3158 ADD START---------//
, EKK0011A010CBSMsg1List.THNX_CALL_JSSI_YMD
// ANK-3307-00-00 2017/10/17 DEL START
// , EKK0011A010CBSMsg1List.MSKM_CNCL_JGI_SNN_SHIN_YMD
// , EKK0011A010CBSMsg1List.MSKM_CNCL_JGI_SNN_YMD
// , EKK0011A010CBSMsg1List.MSKM_CNCL_JGI_HNN_YMD
// ANK-3307-00-00 2017/10/17 DEL END
//---------v29.00.00 ANK-3158 ADD END-----------//
// ANK-3436-00-00 2018/07/04 ADD START
, EKK0011A010CBSMsg1List.SET_WARI_MKM_SKBT_DIV
, EKK0011A010CBSMsg1List.SET_WARI_MKM_SKBT_NO
// ANK-3436-00-00 2018/07/04 ADD END
// ANK-3910-00-00対応 20210114 星野 ADD START
, EKK0011A010CBSMsg1List.TEGAK_SVC_MSKM_KIKI
// ANK-3910-00-00対応 20210114 星野 ADD END
, EKK0011A010CBSMsg1List.SKBT_KEY
// ANK-4427-00-00 ADD START
,EKK0011A010CBSMsg1List.ITENM_SVC_KEI_NO
// ANK-4427-00-00 ADD END
};
// 明細に処理結果(ResultSet)をマッピング
CAANMsg[] outMsg1 = mapMessageList(rsltQuery,msgKeyList1,"eo.ejb.cbs.cbsmsg.EKK0011A010CBSMsg1List",0);
// inMsg(CBSMsg)に明細をセット
inMsg.set("EKK0011A010CBSMsg1List", outMsg1);
} catch(SQLException e) {
inMsg.set(EKK0011A010CBSMsg.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(EKK0011A010CBSMsg.STATUS, StatusCodes.FIND_DB_ERR);
throw new CAANRuntimeException(e);
}
}
}
}