<%=GNB_TITLE%> <% p_sn = Request("p_sn") %>
"/> "/>
첨부문서
<% query = " SELECT f_id, f_kind, f_p_sn, f_file_name, f_save_name, f_input_dt, f_input_user, p_name " query = query & " FROM T_SYSTEM_ATTACH as TSA " query = query & " LEFT OUTER JOIN person as P " query = query & " ON TSA.f_input_user = P.p_no " query = query & " WHERE f_p_sn = '"&p_sn& "' " query = query & " AND f_use_yn = 'Y' " query = query & " AND f_work_type = '001' and f_kind <> '099' " query = query & " order by f_kind, f_id " rsp.Open query, adoConn, 1 attach_file_count = rsp.recordCount 'If attach_file_count < 4 Then ' attach_file_count = 3 'End if dim f_attach_info() redim f_attach_info(attach_file_count, 6) Dim f_attach_index f_attach_index = 1 select_kind_code_flag = True other_kind_code_falg = True default_kind_code_flag = false kind_code = "" 'response.write "query : " & query & "
" i = 1 row_cnt = 1 Do While i < 10 kind_code = "00" & CStr(i) If attach_file_count > 0 then ''' response.write "i : " & i & ", kind_code : " & kind_code & ", rsp('f_kind') : " & rsp("f_kind") & "
" If default_kind_code_flag Then select_kind_code_flag = true Else If kind_code = rsp("f_kind") Then select_kind_code_flag = False other_kind_code_falg = False f_attach_info(f_attach_index, 0) = rsp("f_id") f_attach_info(f_attach_index, 1) = rsp("f_kind") f_attach_info(f_attach_index, 2) = rsp("f_file_name") f_attach_info(f_attach_index, 3) = rsp("p_name") f_attach_info(f_attach_index, 4) = rsp("f_input_dt") f_attach_info(f_attach_index, 5) = rsp("f_input_user") Else select_kind_code_flag = True End If End If If select_kind_code_flag Then If other_kind_code_falg then %> <% row_cnt = row_cnt + 1 other_kind_code_falg = false End if i = i + 1 other_kind_code_falg = true Else %> <% f_attach_index = f_attach_index + 1 row_cnt = row_cnt + 1 If f_attach_index <= attach_file_count Then rsp.MoveNext Else If kind_code <> "009" Then default_kind_code_flag = true else Exit do End if End if End If Else %> <% row_cnt = row_cnt + 1 i = i + 1 End if Loop rsp.Close %>
순번 자료카테고리 첨부문서파일명 담당자 첨부일자
<%=row_cnt%>
<%=row_cnt%> <% query = "select c_common_code, c_code_name from T_COMMON_CODE_DETAIL where c_kind_code = '001' and c_common_code <> '099' " rsa.Open query, adoConn, 1 if rsa.RecordCount > 0 then for j = 1 to rsa.RecordCount if rsa("c_common_code") = kind_code Then %> "/> " readonly style="border: 0px none0; text-align: center;"/> <% end if rsa.MoveNext next end if rsa.Close %> <%=f_attach_info(f_attach_index, 3)%> <%=f_attach_info(f_attach_index, 4)%>
<%=row_cnt%>