public String goDelete(String[] sz_idxs, String memId, String route) {
String responseStr = null;
Vector<String> sqlBox = new Vector<String>();
for (int i = 0; i < sz_idxs.length; ++i) {
sqlBox.addElement(sz_idxs[i]);
}
sqlSetUp.backupZoneInfo(sqlBox);
Vector<Properties> detailInfos = new Vector<Properties>();
sqlSetUp.getZoneDetailInfo(sqlBox, detailInfos);
int delCnt = sqlSetUp.deleteZoneInfo(sqlBox);
if (delCnt > 0) {
for (int i = 0; i < detailInfos.size(); ++i) {
Properties detailRec = detailInfos.elementAt(i);
String useFlagDb = detailRec.getProperty("USEFLAG");
if (useFlagDb.equals("1")) {
Vector<String> condVec = new Vector<String>();
condVec.addElement(detailRec.getProperty("STDT") + detailRec.getProperty("STMM"));
condVec.addElement(detailRec.getProperty("ENDT") + detailRec.getProperty("ENMM"));
condVec.addElement("_" + detailRec.getProperty("STMM").substring(1));
if (sqlSetUp.updateCount(condVec, detailRec.getProperty("WEEKP"), false) == 0) {
logger.info("[_DEV_] 존 설정 업데이트 건수 : 0건 (확인 요망)");
}
}
NspKTSMS nspKTSMS = new NspKTSMS(memId, route, "order");
nspKTSMS.smsOrder(
UTILmgr.getDateTime(), detailRec.getProperty("CCODE"), "DEVICE", "2", CommonDef.DEVICE);
}
responseStr = xmlMgr.xmlBasic(1);
logger.info("[_OPR_] 존 설정 정보 삭제");
} else {
responseStr = xmlMgr.xmlBasic(0);
}
return responseStr;
}
