/*******************************************************************************
* All Rights reserved,Copyright (c) K-Opticom
********************************************************************************
*＜プログラム内容＞
* システム名 ：eo顧客基幹システム
* モジュール名 ：JSYejbEDK0111B028TPDA
* ソースファイル名：JSYejbEDK0111B028TPDA.java
* 作成者 ：EK909134
* 日付 ：2011年09月07日
*＜機能概要＞
* 棚移動基本情報一覧照会テンプレートDBアクセス部品です。
*＜修正履歴＞
* バージョン 修正日 修正者 修正内容
* ｖ1.00.00
*
********************************************************************************/
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.EDK0111B028CBSMsg;
import eo.ejb.cbs.cbsmsg.EDK0111B028CBSMsg1List;
import eo.ejb.cbm.entity.DK0111ETMsg;
import static eo.ejb.common.JDKModelCommon.*;
import static eo.common.constant.JZM0171Constant.*;
/**
*
* テンプレートDBアクセス部品 EDK0111B028_SQLF
* 入力された項目からSQL文を動的に組み立て、
* 検索結果をCBSMsgにセットします。
*/
public class JSYejbEDK0111B028TPDA extends CAANSQLFacility implements TemplateDBAccessHandler{
/**
* コンストラクタ
*/
public JSYejbEDK0111B028TPDA() {
}
/**
* EDK0111B028_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(DK0111ETMsg.getTableName());
// SQL文_基本部1
StringBuffer sql_Buff = new StringBuffer();
sql_Buff.append(" SELECT DISTINCT ")
.append(" SOKODNA.SOKODNA_MOVE_ADD_YMD AS SJIYMD, ")
.append(" SOKODNA.SOKODNA_MOVE_STP_YMD AS STPYMD, ")
.append(" SOKODNA.SKDN_MV_TNT_USER_ID AS TNTID, ")
.append(" USR1.USER_NM AS TNTNM, ")
.append(" SOKODNA.SDNAMV_STP_TNT_USER_ID AS STPTNTID, ")
.append(" USR2.USER_NM AS STPTNTNM, ")
.append(" '' AS TELNO, ")
.append(" '' AS FAXNO, ")
.append(" SSK.ORG_NM AS SSKNM, ")
.append(" SOKO.SOKO_NM AS MTSOKONM, ")
.append(" SOKO.SOKO_CD AS MTSOKOCD, ")
.append(" KOJI.KOJI_COMP_NM AS MTKOJINM, ")
.append(" KOJI.KOJI_COMP_CD AS MTKOJICD, ")
.append(" OFC.YOTAKU_SAKI_OFFC_NM AS MTOFCNM, ")
.append(" OFC.YOTAKU_SAKI_OFFC_CD AS MTOFCCD, ")
.append(" SOKO.COMP_NM AS SKSOKONM, ")
.append(" SOKO.SOKO_CD AS SKSOKOCD, ")
.append(" KOJI.COMP_NM AS SKKOJINM, ")
.append(" KOJI.KOJI_COMP_CD AS SKKOJICD, ")
.append(" OFC.COMP_NM AS SKOFCNM, ")
.append(" OFC.YOTAKU_SAKI_OFFC_CD AS SKOFCCD, ")
.append( cd(CD00544, "SOKODNA.MOVE_MOTO_SHELF_CD", COMMA.RIGHT, "MTTANANM"))
.append(" SOKODNA.MOVE_MOTO_SHELF_CD AS MTTANACD, ")
.append( cd(CD00544, "SOKODNA.MOVE_SAKI_SHELF_CD", COMMA.RIGHT, "SKTANANM"))
.append(" SOKODNA.MOVE_SAKI_SHELF_CD AS SKTANACD, ")
.append(" '' AS SHKSAKI, ")
.append( cd(CD00334, "SOKODNA.SHITEI_WAY_CD", COMMA.RIGHT, "SHITEINM"))
.append( cd(CD00335, "SOKODNA.SOKODNA_MOVE_STAT", COMMA.RIGHT, "STATNM"))
.append(" '' AS SHITEIFLG, ")
.append(" SOKO.SOKO_PCD AS SOKOPCD, ")
.append(" SOKO.SOKO_STATE_NM AS SOKOSTATENM, ")
.append(" SOKO.SOKO_CITY_NM AS SOKOCITYNM, ")
.append(" SOKO.SOKO_OAZTSU_NM AS SOKOOAZTSUNM, ")
.append(" SOKO.SOKO_AZCHO_NM AS SOKOAZCHONM, ")
.append(" SOKO.SOKO_BNCHIGO AS SOKOBNCHIGO, ")
.append(" SOKO.SOKO_ADRTTM AS SOKOADRTTM, ")
.append(" SOKO.SOKO_ADRRM AS SOKOADRRM, ")
.append(" SOKO.SOKO_TELNO AS SOKOTELNO, ")
.append(" KOJI.KOJI_COMP_PCD AS KOJIPCD, ")
.append(" KOJI.KOJI_COMP_STATE_NM AS KOJISTATENM, ")
.append(" KOJI.KOJI_COMP_CITY_NM AS KOJICITYNM, ")
.append(" KOJI.KOJI_COMP_OAZTSU_NM AS KOJIOAZTSUNM, ")
.append(" KOJI.KOJI_COMP_AZCHO_NM AS KOJIAZCHONM, ")
.append(" KOJI.KOJI_COMP_BNCHIGO AS KOJIBNCHIGO, ")
.append(" KOJI.KOJI_COMP_ADRTTM AS KOJIADRTTM, ")
.append(" KOJI.KOJI_COMP_ADRRM AS KOJIADRRM, ")
.append(" KOJI.KOJI_COMP_TLN AS KOJITELNO, ")
.append(" OFC.OFFC_PCD AS OFCPCD, ")
.append(" OFC.OFFC_STATE_NM AS OFCSTATENM, ")
.append(" OFC.OFFC_CITY_NM AS OFCCITYNM, ")
.append(" OFC.OFFC_OAZTSU_NM AS OFCOAZTSUNM, ")
.append(" OFC.OFFC_AZCHO_NM AS OFCAZCHONM, ")
.append(" OFC.OFFC_BNCHIGO AS OFCBNCHIGO, ")
.append(" OFC.OFFC_ADRTTM AS OFCADRTTM, ")
.append(" OFC.OFFC_ADRRM AS OFCADRRM, ")
.append(" OFC.OFFC_TLN AS OFCTELNO, ")
.append(" '' AS SHKSKPCD, ")
.append(" '' AS SHKSKSTATENM, ")
.append(" '' AS SHKSKCITYNM, ")
.append(" '' AS SHKSKOAZTSUNM, ")
.append(" '' AS SHKSKAZCHONM, ")
.append(" '' AS SHKSKBNCHIGO, ")
.append(" '' AS SHKSKADRTTM, ")
.append(" '' AS SHKSKADRRM, ")
.append(" '' AS SHKSKNM1, ")
.append(" '' AS SHKSKNM2, ")
.append(" '' AS SHKSKNM3, ")
.append(" '' AS SHKSKTELNO, ")
.append( cd(CD00338, "SOKODNA.SOKODNA_MOVE_RSN_CD", COMMA.RIGHT, "RIYUNM"))
.append(" SOKODNA.SKDN_MV_BIKO AS BIKO, ")
.append(" SOKODNA.SHITEI_WAY_CD AS SHITEICD, ")
.append(" SOKODNA.SOKODNA_MOVE_STAT AS STATCD, ")
.append( cd(CD00274, "SOKODNA.GDS_STAT_CD", COMMA.RIGHT, "STATCD"))
.append(" '' AS STPCD, ")
.append(" '1' AS MVKBN, ")
.append(" COALESCE(KOJI.TNTSHA_NM, OFC.TNTSHA_NM, '') AS TNTNM, ")
.append(" COALESCE(KOJI.TNT_BUSHO_NM, OFC.TNT_BUSHO_NM, '') AS SSKNM ")
.append(" FROM DK_T_SOKODNA_MOVE SOKODNA ")
.append(" LEFT OUTER JOIN ZM_M_USER USR1 ")
.append(" ON (USR1.USER_ID = SOKODNA.SKDN_MV_TNT_USER_ID ")
.append(" AND USR1.MK_FLG = '0') ")
.append(" LEFT OUTER JOIN ZM_M_USER USR2 ")
.append(" ON (USR2.USER_ID = SOKODNA.SDNAMV_STP_TNT_USER_ID ")
.append(" AND USR2.MK_FLG = '0') ")
.append(" LEFT OUTER JOIN ZM_M_ORGANIZATION SSK ")
.append(" ON (SSK.ORG_CD = USR1.SHUMU_SHOZK_ORG_CD ")
.append(" AND SSK.MK_FLG = '0') ")
.append(" LEFT OUTER JOIN DK_M_SOKO SOKO ")
.append(" ON (SOKO.SOKO_CD = SOKODNA.SOKO_CD ")
.append(" AND SOKO.MK_FLG = '0') ")
.append(" LEFT OUTER JOIN ZM_M_KOJI_COMP KOJI ")
.append(" ON (KOJI.KOJI_COMP_CD = SOKODNA.KOJI_COMP_CD ")
.append(" AND KOJI.MK_FLG = '0') ")
.append(" LEFT OUTER JOIN ZM_M_YTK_SK_OFFC OFC ")
.append(" ON (OFC.YOTAKU_SAKI_OFFC_CD = SOKODNA.YOTAKU_SAKI_OFFC_CD ")
.append(" AND OFC.MK_FLG = '0') ")
.append(" WHERE SOKODNA.SHELF_MOVE_LOT_NO = ? ")
.append(" AND SOKODNA.MK_FLG='0' ")
.append(" UNION ALL ")
.append(" SELECT DISTINCT ")
.append(" YBK.YBKKHAI_UK_YMD AS SJIYMD, ")
.append(" YBK.YBKIKI_HAISO_STP_YMD AS STPYMD, ")
.append(" YBK.YBKKHAI_TNT_USER_ID AS TNTID, ")
.append(" USR1.USER_NM AS TNTNM, ")
.append(" YBK.YBKKHAI_STP_TNT_USER_ID AS STPTNTID, ")
.append(" USR2.USER_NM AS STPTNTNM, ")
.append(" '' AS TELNO, ")
.append(" '' AS FAXNO, ")
.append(" SSK.ORG_NM AS SSKNM, ")
.append(" SOKOMT.SOKO_NM AS MTSOKONM, ")
.append(" YBK.HAISO_MOTO_SOKO_CD AS MTSOKOCD, ")
.append(" KOJIMT.KOJI_COMP_NM AS MTKOJINM, ")
.append(" YBK.HISOM_KOCOMP_CD AS MTKOJICD, ")
.append(" OFCMT.YOTAKU_SAKI_OFFC_NM AS MTOFCNM, ")
.append(" YBK.HISOM_YOTAKU_SK_OFFC_CD AS MTOFCCD, ")
.append(" SOKOSK.COMP_NM AS SKSOKONM, ")
.append(" YBK.HISOS_SOKO_CD AS SKSOKOCD, ")
.append(" KOJISK.COMP_NM AS SKKOJINM, ")
.append(" YBK.HISOS_KOCOMP_CD AS SKKOJICD, ")
.append(" OFCSK.COMP_NM AS SKOFCNM, ")
.append(" YBK.HISOS_YOTAKU_SK_OFFC_CD AS SKOFCCD, ")
.append( cd(CD00544, "YBK.HISOM_SHELF_CD", COMMA.RIGHT, "MTTANANM"))
.append(" YBK.HISOM_SHELF_CD AS MTTANACD, ")
.append( cd(CD00544, "YBK.HISOS_SHELF_CD", COMMA.RIGHT, "SKTANANM"))
.append(" YBK.HISOS_SHELF_CD AS SKTANACD, ")
.append(" YBK.YBKIKI_HISOS_NM_1 AS SHKSAKI, ")
.append( cd(CD00334, "YBK.SHITEI_WAY_CD", COMMA.RIGHT, "SHITEINM"))
.append( cd(CD00337, "YBK.YBKIKI_HAISO_STAT", COMMA.RIGHT, "STATNM"))
.append(" YBK.YBKIKI_HISOS_KSITEI_FLG AS SHITEIFLG, ")
.append(" SOKOSK.SOKO_PCD AS SOKOPCD, ")
.append(" SOKOSK.SOKO_STATE_NM AS SOKOSTATENM, ")
.append(" SOKOSK.SOKO_CITY_NM AS SOKOCITYNM, ")
.append(" SOKOSK.SOKO_OAZTSU_NM AS SOKOOAZTSUNM, ")
.append(" SOKOSK.SOKO_AZCHO_NM AS SOKOAZCHONM, ")
.append(" SOKOSK.SOKO_BNCHIGO AS SOKOBNCHIGO, ")
.append(" SOKOSK.SOKO_ADRTTM AS SOKOADRTTM, ")
.append(" SOKOSK.SOKO_ADRRM AS SOKOADRRM, ")
.append(" SOKOSK.SOKO_TELNO AS SOKOTELNO, ")
.append(" KOJISK.KOJI_COMP_PCD AS KOJIPCD, ")
.append(" KOJISK.KOJI_COMP_STATE_NM AS KOJISTATENM, ")
.append(" KOJISK.KOJI_COMP_CITY_NM AS KOJICITYNM, ")
.append(" KOJISK.KOJI_COMP_OAZTSU_NM AS KOJIOAZTSUNM, ")
.append(" KOJISK.KOJI_COMP_AZCHO_NM AS KOJIAZCHONM, ")
.append(" KOJISK.KOJI_COMP_BNCHIGO AS KOJIBNCHIGO, ")
.append(" KOJISK.KOJI_COMP_ADRTTM AS KOJIADRTTM, ")
.append(" KOJISK.KOJI_COMP_ADRRM AS KOJIADRRM, ")
.append(" KOJISK.KOJI_COMP_TLN AS KOJITELNO, ")
.append(" OFCSK.OFFC_PCD AS OFCPCD, ")
.append(" OFCSK.OFFC_STATE_NM AS OFCSTATENM, ")
.append(" OFCSK.OFFC_CITY_NM AS OFCCITYNM, ")
.append(" OFCSK.OFFC_OAZTSU_NM AS OFCOAZTSUNM, ")
.append(" OFCSK.OFFC_AZCHO_NM AS OFCAZCHONM, ")
.append(" OFCSK.OFFC_BNCHIGO AS OFCBNCHIGO, ")
.append(" OFCSK.OFFC_ADRTTM AS OFCADRTTM, ")
.append(" OFCSK.OFFC_ADRRM AS OFCADRRM, ")
.append(" OFCSK.OFFC_TLN AS OFCTELNO, ")
.append(" YBK.YBKIKI_HISOS_PCD AS SHKSKPCD, ")
.append(" YBK.YBKIKI_HISOS_STATE_NM AS SHKSKSTATENM, ")
.append(" YBK.YBKIKI_HISOS_CITY_NM AS SHKSKCITYNM, ")
.append(" YBK.YBKIKI_HISOS_OAZTSU_NM AS SHKSKOAZTSUNM, ")
.append(" YBK.YBKIKI_HISOS_AZCHO_NM AS SHKSKAZCHONM, ")
.append(" YBK.YBKIKI_HISOS_BNCHIGO AS SHKSKBNCHIGO, ")
.append(" YBK.YBKIKI_HISOS_ADRTTM AS SHKSKADRTTM, ")
.append(" YBK.YBKIKI_HISOS_ADRRM AS SHKSKADRRM, ")
.append(" YBK.YBKIKI_HISOS_NM_1 AS SHKSKNM1, ")
.append(" YBK.YBKIKI_HISOS_NM_2 AS SHKSKNM2, ")
.append(" YBK.YBKIKI_HISOS_NM_3 AS SHKSKNM3, ")
.append(" YBK.YBKIKI_HISOS_TELNO AS SHKSKTELNO, ")
.append( cd(CD00338, "YBK.YBKKHAI_RSN_CD", COMMA.RIGHT, "RIYUNM"))
.append(" YBK.YBKKHAI_BIKO AS BIKO, ")
.append(" YBK.SHITEI_WAY_CD AS SHITEICD, ")
.append(" YBK.YBKIKI_HAISO_STAT AS STATCD, ")
.append( cd(CD00274, "YBK.GDS_STAT_CD", COMMA.RIGHT, "STATCD"))
.append(" YBK.YBKIKI_HAISO_STP_CD AS STPCD, ")
.append(" '2' AS MVKBN, ")
.append(" COALESCE(KOJISK.TNTSHA_NM, OFCSK.TNTSHA_NM, '') AS TNTNM, ")
.append(" COALESCE(KOJISK.TNT_BUSHO_NM, OFCSK.TNT_BUSHO_NM, '') AS SSKNM ")
.append(" FROM DK_T_YBKIKI_HAISO YBK ")
.append(" LEFT OUTER JOIN ZM_M_USER USR1 ")
.append(" ON (USR1.USER_ID = YBK.YBKKHAI_TNT_USER_ID ")
.append(" AND USR1.MK_FLG = '0') ")
.append(" LEFT OUTER JOIN ZM_M_USER USR2 ")
.append(" ON (USR2.USER_ID = YBK.YBKKHAI_STP_TNT_USER_ID ")
.append(" AND USR2.MK_FLG = '0') ")
.append(" LEFT OUTER JOIN ZM_M_ORGANIZATION SSK ")
.append(" ON (SSK.ORG_CD = USR1.SHUMU_SHOZK_ORG_CD ")
.append(" AND SSK.MK_FLG = '0') ")
.append(" LEFT OUTER JOIN DK_M_SOKO SOKOMT ")
.append(" ON (SOKOMT.SOKO_CD = YBK.HAISO_MOTO_SOKO_CD ")
.append(" AND SOKOMT.MK_FLG = '0') ")
.append(" LEFT OUTER JOIN ZM_M_KOJI_COMP KOJIMT ")
.append(" ON (KOJIMT.KOJI_COMP_CD = YBK.HISOM_KOCOMP_CD ")
.append(" AND KOJIMT.MK_FLG = '0') ")
.append(" LEFT OUTER JOIN ZM_M_YTK_SK_OFFC OFCMT ")
.append(" ON (OFCMT.YOTAKU_SAKI_OFFC_CD = YBK.HISOM_YOTAKU_SK_OFFC_CD ")
.append(" AND OFCMT.MK_FLG = '0') ")
.append(" LEFT OUTER JOIN DK_M_SOKO SOKOSK ")
.append(" ON (SOKOSK.SOKO_CD = YBK.HISOS_SOKO_CD ")
.append(" AND SOKOSK.MK_FLG = '0') ")
.append(" LEFT OUTER JOIN ZM_M_KOJI_COMP KOJISK ")
.append(" ON (KOJISK.KOJI_COMP_CD = YBK.HISOS_KOCOMP_CD ")
.append(" AND KOJISK.MK_FLG = '0') ")
.append(" LEFT OUTER JOIN ZM_M_YTK_SK_OFFC OFCSK ")
.append(" ON (OFCSK.YOTAKU_SAKI_OFFC_CD = YBK.HISOS_YOTAKU_SK_OFFC_CD ")
.append(" AND OFCSK.MK_FLG = '0') ");
// SQL文_個別部1
sql_Buff.append(" WHERE YBK.SHELF_MOVE_LOT_NO = ? ")
.append(" AND YBK.MK_FLG='0' ");
//prepareStatementにSQL文をセット
pstmt = con1.prepareStatement(sql_Buff.toString());
//ログ出力(SQL文の出力)
JSYejbLog.outlog(inContext, JSYejbLog.DBACCESS, this.getClass(), sql_Buff);
Object unyoYmd = inMsg.getObject(EDK0111B028CBSMsg.KEY_UNYO_YMD);
Object lotNo = inMsg.getObject(EDK0111B028CBSMsg.KEY_SHELF_MV_LOT_NO);
int index = 1;
// パラメータの設定(ＫＥＹ＿運用日付を指定) ※1〜6まで設定
for (int i = 1; i < 7; i++)
{
CAANJDBCUtil.setParam(pstmt, index++, unyoYmd);
}
// パラメータの設定(ＫＥＹ＿棚移動ロット番号を指定)
CAANJDBCUtil.setParam(pstmt, index++, lotNo);
// パラメータの設定(ＫＥＹ＿運用日付を指定) ※8〜13まで設定
for (int i = 1; i < 7; i++)
{
CAANJDBCUtil.setParam(pstmt, index++, unyoYmd);
}
// パラメータの設定(ＫＥＹ＿運用日付を指定)
CAANJDBCUtil.setParam(pstmt, index++, lotNo);
// ResultSetの取得
rsltQuery = pstmt.executeQuery();
// EDK0111B028CBSMsgの明細にセットする項目
String[] msgKeyList1 = {
EDK0111B028CBSMsg1List.SJI_YMD
, EDK0111B028CBSMsg1List.CL_YMD
, EDK0111B028CBSMsg1List.MV_TNT_USER_ID
, EDK0111B028CBSMsg1List.MV_TNT_USER_NM
, EDK0111B028CBSMsg1List.MV_STP_USER_ID
, EDK0111B028CBSMsg1List.MV_STP_USER_NM
, EDK0111B028CBSMsg1List.RRKS_TELNO
, EDK0111B028CBSMsg1List.RRKS_FAX
, EDK0111B028CBSMsg1List.BKM
, EDK0111B028CBSMsg1List.MV_MT_SOKO_NM
, EDK0111B028CBSMsg1List.MV_MT_SOKO_CD
, EDK0111B028CBSMsg1List.MV_MT_KOJI_NM
, EDK0111B028CBSMsg1List.MV_MT_KOJI_CD
, EDK0111B028CBSMsg1List.MV_MT_OFFICE_NM
, EDK0111B028CBSMsg1List.MV_MT_OFFICE_CD
, EDK0111B028CBSMsg1List.MV_SK_SOKO_NM
, EDK0111B028CBSMsg1List.MV_SK_SOKO_CD
, EDK0111B028CBSMsg1List.MV_SK_KOJI_NM
, EDK0111B028CBSMsg1List.MV_SK_KOJI_CD
, EDK0111B028CBSMsg1List.MV_SK_OFFICE_NM
, EDK0111B028CBSMsg1List.MV_SK_OFFICE_CD
, EDK0111B028CBSMsg1List.MV_MT_SHELF_NM
, EDK0111B028CBSMsg1List.MV_MT_SHELF_CD
, EDK0111B028CBSMsg1List.MV_SK_SHELF_NM
, EDK0111B028CBSMsg1List.MV_SK_SHELF_CD
, EDK0111B028CBSMsg1List.SHKA_SK
, EDK0111B028CBSMsg1List.SHITEI_WAY_NM
, EDK0111B028CBSMsg1List.STAT
, EDK0111B028CBSMsg1List.KSITEI_FLG
, EDK0111B028CBSMsg1List.SOKO_PCD
, EDK0111B028CBSMsg1List.SOKO_STATE_NM
, EDK0111B028CBSMsg1List.SOKO_CITY_NM
, EDK0111B028CBSMsg1List.SOKO_OAZTSU_NM
, EDK0111B028CBSMsg1List.SOKO_AZCHO_NM
, EDK0111B028CBSMsg1List.SOKO_BNCHIGO
, EDK0111B028CBSMsg1List.SOKO_ADRTTM
, EDK0111B028CBSMsg1List.SOKO_ADRRM
, EDK0111B028CBSMsg1List.SOKO_TELNO
, EDK0111B028CBSMsg1List.KOJI_PCD
, EDK0111B028CBSMsg1List.KOJI_STATE_NM
, EDK0111B028CBSMsg1List.KOJI_CITY_NM
, EDK0111B028CBSMsg1List.KOJI_OAZTSU_NM
, EDK0111B028CBSMsg1List.KOJI_AZCHO_NM
, EDK0111B028CBSMsg1List.KOJI_BNCHIGO
, EDK0111B028CBSMsg1List.KOJI_ADRTTM
, EDK0111B028CBSMsg1List.KOJI_ADRRM
, EDK0111B028CBSMsg1List.KOJI_TELNO
, EDK0111B028CBSMsg1List.OFFICE_PCD
, EDK0111B028CBSMsg1List.OFFICE_STATE_NM
, EDK0111B028CBSMsg1List.OFFICE_CITY_NM
, EDK0111B028CBSMsg1List.OFFICE_OAZTSU_NM
, EDK0111B028CBSMsg1List.OFFICE_AZCHO_NM
, EDK0111B028CBSMsg1List.OFFICE_BNCHIGO
, EDK0111B028CBSMsg1List.OFFICE_ADRTTM
, EDK0111B028CBSMsg1List.OFFICE_ADRRM
, EDK0111B028CBSMsg1List.OFFICE_TELNO
, EDK0111B028CBSMsg1List.YBKIKI_HISOS_PCD
, EDK0111B028CBSMsg1List.YBKIKI_HISOS_STATE_NM
, EDK0111B028CBSMsg1List.YBKIKI_HISOS_CITY_NM
, EDK0111B028CBSMsg1List.YBKIKI_HISOS_OAZTSU_NM
, EDK0111B028CBSMsg1List.YBKIKI_HISOS_AZCHO_NM
, EDK0111B028CBSMsg1List.YBKIKI_HISOS_BNCHIGO
, EDK0111B028CBSMsg1List.YBKIKI_HISOS_ADRTTM
, EDK0111B028CBSMsg1List.YBKIKI_HISOS_ADRRM
, EDK0111B028CBSMsg1List.YBKIKI_HISOS_NM_1
, EDK0111B028CBSMsg1List.YBKIKI_HISOS_NM_2
, EDK0111B028CBSMsg1List.YBKIKI_HISOS_NM_3
, EDK0111B028CBSMsg1List.YBKIKI_HISOS_TELNO
, EDK0111B028CBSMsg1List.RSN_NM
, EDK0111B028CBSMsg1List.BIKO
, EDK0111B028CBSMsg1List.SHITEI_WAY_CD
, EDK0111B028CBSMsg1List.MV_STAT_CD
, EDK0111B028CBSMsg1List.GDS_STAT_NM
, EDK0111B028CBSMsg1List.YBKIKI_HAISO_STP_CD
, EDK0111B028CBSMsg1List.MV_SBT
, EDK0111B028CBSMsg1List.HAISOS_TNT_BUSHO_NM
, EDK0111B028CBSMsg1List.HAISOS_TNTSHA_NM
};
// 明細に処理結果(ResultSet)をマッピング
CAANMsg[] outMsg1 = mapMessageList(rsltQuery,msgKeyList1,"eo.ejb.cbs.cbsmsg.EDK0111B028CBSMsg1List",0);
// inMsg(CBSMsg)に明細をセット
inMsg.set("EDK0111B028CBSMsg1List", outMsg1);
} catch(SQLException e) {
inMsg.set(EDK0111B028CBSMsg.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(EDK0111B028CBSMsg.STATUS, StatusCodes.FIND_DB_ERR);
throw new CAANRuntimeException(e);
}
}
}
}