/**
* 指定した年月のデータを全て取得する
*
* @param uSid ユーザーSID
* @param frDate from日付
* @param toDate to日付
* @return List in Tcd010Model 結果を格納したListオブジェクト
* @throws SQLException SQL実行例外
*/
public HashMap<String, Tcd010Model> getTimeCardMap(int uSid, UDate frDate, UDate toDate)
throws SQLException {
// 休日関連追加済み
PreparedStatement pstmt = null;
ResultSet rs = null;
Connection con = null;
HashMap<String, Tcd010Model> ret = new HashMap<String, Tcd010Model>();
con = getCon();
try {
// SQL文
SqlBuffer sql = new SqlBuffer();
sql.addSql(" select ");
sql.addSql(" USR_SID,");
sql.addSql(" TCD_DATE,");
sql.addSql(" TCD_INTIME,");
sql.addSql(" TCD_OUTTIME,");
sql.addSql(" TCD_STRIKE_INTIME,");
sql.addSql(" TCD_STRIKE_OUTTIME,");
sql.addSql(" TCD_BIKO,");
sql.addSql(" TCD_STATUS,");
sql.addSql(" TCD_HOLKBN,");
sql.addSql(" TCD_HOLOTHER,");
sql.addSql(" TCD_HOLCNT,");
sql.addSql(" TCD_CHKKBN,");
sql.addSql(" TCD_SOUKBN,");
sql.addSql(" TCD_LOCK_FLG,");
sql.addSql(" TCD_AUID,");
sql.addSql(" TCD_ADATE,");
sql.addSql(" TCD_EUID,");
sql.addSql(" TCD_EDATE");
sql.addSql(" from ");
sql.addSql(" TCD_TCDATA");
sql.addSql(" where ");
sql.addSql(" USR_SID = ?");
sql.addSql(" and ");
sql.addSql(" TCD_DATE >= ?");
sql.addSql(" and");
sql.addSql(" TCD_DATE <= ?");
sql.addSql(" order by");
sql.addSql(" TCD_DATE");
pstmt = con.prepareStatement(sql.toSqlString());
sql.addIntValue(uSid);
sql.addDateValue(frDate);
sql.addDateValue(toDate);
log__.info(sql.toLogString());
sql.setParameter(pstmt);
rs = pstmt.executeQuery();
Tcd010Model model = null;
while (rs.next()) {
model = __getTcd010FromRs(rs);
ret.put(model.getTcdDate().getDateString(), model);
}
} catch (SQLException e) {
throw e;
} finally {
JDBCUtil.closeResultSet(rs);
JDBCUtil.closeStatement(pstmt);
}
return ret;
}
