public string List(BoardParam tParam) { StringBuilder sb = new StringBuilder(); sb.Append(" select (ROW_NUMBER() OVER()) AS rownum, Z.* "); sb.Append(" FROM( "); sb.Append(" select A.idx, A.title, C.admnm, "); sb.Append(" substring(A.dtinsert, 1, 4) || '-' || substring(A.dtinsert, 5, 2) || '-' || substring(A.dtinsert, 7, 2) AS dtinsert "); sb.Append(" from tbl_board_info A, tbl_admmgr C, "); sb.Append(" (select * from tbl_board_dept a left join tbl_user_info b ON a.dept_seq = b.dept_seq and b.user_id = '" + tParam.UserID + "') B "); sb.Append(" WHERE A.idx = B.idx AND A.loc in ('0', '1') AND A.useyn = '1' "); sb.Append(" AND A.dtstart <= to_char(NOW(), 'yyyyMMdd010101') AND A.dtend >= to_char(NOW(), 'yyyyMMdd235959') "); sb.Append(" AND A.writer = C.admcd "); sb.Append(" UNION "); sb.Append(" select A.idx, A.title, C.admnm, "); sb.Append(" substring(A.dtinsert, 1, 4) || '-' || substring(A.dtinsert, 5, 2) || '-' || substring(A.dtinsert, 7, 2) AS dtinsert "); sb.Append(" from tbl_board_info A, tbl_admmgr C, tbl_board_dept B "); sb.Append(" WHERE A.loc in ('0', '1') AND A.useyn = '1' AND A.idx = B.idx "); sb.Append(" AND A.dtstart <= to_char(NOW(), 'yyyyMMdd010101') AND A.dtend >= to_char(NOW(), 'yyyyMMdd235959') "); sb.Append(" AND B.dept_seq = 0 "); sb.Append(" AND A.writer = C.admcd "); sb.Append(" ) Z "); sb.Append(" ORDER BY Z.dtinsert DESC "); sb.Append(" limit " + tParam.PageListCount + " offset (" + tParam.ViewPageNo + "-1) * " + tParam.PageListCount); return(sb.ToString()); }
public string TotalCount(BoardParam tParam) { StringBuilder sb = new StringBuilder(); sb.Append(" select COUNT(Z.*) AS totalCount "); sb.Append(" FROM( "); sb.Append(" select A.idx, A.title, C.admnm, "); sb.Append(" substring(A.dtinsert, 1, 4) || '-' || substring(A.dtinsert, 5, 2) || '-' || substring(A.dtinsert, 7, 2) AS dtinsert "); sb.Append(" from tbl_board_info A, tbl_admmgr C, "); sb.Append(" (select * from tbl_board_dept a left join tbl_user_info b ON a.dept_seq = b.dept_seq and b.user_id = '" + tParam.UserID + "') B "); sb.Append(" WHERE A.idx = B.idx AND A.loc in ('0', '1') AND A.useyn = '1' "); sb.Append(" AND A.dtstart <= to_char(NOW(), 'yyyyMMdd010101') AND A.dtend >= to_char(NOW(), 'yyyyMMdd235959') "); sb.Append(" AND A.writer = C.admcd "); sb.Append(" UNION "); sb.Append(" select A.idx, A.title, C.admnm, "); sb.Append(" substring(A.dtinsert, 1, 4) || '-' || substring(A.dtinsert, 5, 2) || '-' || substring(A.dtinsert, 7, 2) AS dtinsert "); sb.Append(" from tbl_board_info A, tbl_admmgr C, tbl_board_dept B "); sb.Append(" WHERE A.loc in ('0', '1') AND A.useyn = '1' AND A.idx = B.idx "); sb.Append(" AND A.dtstart <= to_char(NOW(), 'yyyyMMdd010101') AND A.dtend >= to_char(NOW(), 'yyyyMMdd235959') "); sb.Append(" AND B.dept_seq = 0 "); sb.Append(" AND A.writer = C.admcd "); sb.Append(" ) Z "); return(sb.ToString()); }