| 순번 |
자료카테고리 |
첨부문서파일명 |
담당자 |
첨부일자 |
<%
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 = row_cnt + 1
other_kind_code_falg = false
End if
i = i + 1
other_kind_code_falg = true
Else
%>
| <%=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)%> |
<%
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 = row_cnt + 1
i = i + 1
End if
Loop
rsp.Close
%>
|
|