109 lines
5.7 KiB
Plaintext
109 lines
5.7 KiB
Plaintext
<!-- #include virtual = "lib/config.asp" -->
|
|
<link rel="stylesheet" type="text/css" href="/css/basic.css">
|
|
<%
|
|
|
|
set rsp = server.CreateObject("ADODB.RECORDSET")
|
|
|
|
p_no = request("p_no")
|
|
p_child_sn = request("p_child_sn")
|
|
p_subject = request("p_subject")
|
|
full_info = request("full_info")
|
|
%>
|
|
|
|
<script language="javascript">
|
|
|
|
|
|
function openit(p_child_sn, p_subject) {
|
|
var targ_p_child_sn = document.pms.p_child_sn.value;
|
|
var targ_p_subject = document.pms.p_subject.value;
|
|
var targ_full_info = document.pms.full_info.value;
|
|
if (targ_p_child_sn != "") {
|
|
opener.document.getElementById(targ_p_child_sn).value = p_child_sn;
|
|
}
|
|
if (targ_p_subject != "") {
|
|
opener.document.getElementById(targ_p_subject).value = p_subject;
|
|
}
|
|
if (targ_full_info != "") {
|
|
opener.document.getElementById(targ_full_info).value = "[" + p_child_sn + "] " + p_subject;
|
|
}
|
|
self.close();
|
|
}
|
|
|
|
</script>
|
|
|
|
<script src="/lib/function.js" type="text/javascript1.3"></script>
|
|
|
|
<form name="pms" method="post">
|
|
<table width="100%" cellpadding="0" cellspacing="0" border="0">
|
|
<tr>
|
|
<td colspan="2" style="padding:10;">
|
|
<table width="100%" cellpadding="0" cellspacing="0" border="0">
|
|
<tr>
|
|
<td style="padding:10 0 0 0">
|
|
<input type="hidden" name="p_child_sn" id="p_child_sn" value="<%=p_child_sn %>" />
|
|
<input type="hidden" name="p_subject" id="p_subject" value="<%=p_subject %>" />
|
|
<input type="hidden" name="full_info" id="full_info" value="<%=full_info %>" />
|
|
|
|
<table width="100%" cellpadding="3" cellspacing="0" border="0" style="border-collapse:collapse;">
|
|
<tr>
|
|
<td align="center" style="width: 10%">프로젝트 코드 </td>
|
|
<td align="center" style="width: 35%">프로젝트 명</td>
|
|
<td align="center" style="width: 20%">조사방법</td>
|
|
<td align="center" style="width: 25%">조사내용</td>
|
|
<td align="center" style="width: 10%">담당연구팀</td>
|
|
</tr>
|
|
<%
|
|
Query = " SELECT p_child_sn, p_subject, p_method_nm, p_intention, ISNULL(D.T_name, '') as d_name "
|
|
Query = Query & " FROM V_PROJECT_METHOD VPM LEFT OUTER JOIN v_Department D "
|
|
Query = Query & " ON VPM.p_rsch_dept = D.before_t_cd1 "
|
|
Query = Query & " WHERE ISNULL(p_child_sn, '') <> '' "
|
|
Query = Query & " AND p_progress_status >= '006' "
|
|
Query = Query & " AND p_research_complete is null "
|
|
Query = Query & " AND p_field_complete is null "
|
|
Query = Query & " AND p_dp_complete is null "
|
|
Query = Query & " AND p_support_complete is null "
|
|
Query = Query & " AND ( "
|
|
Query = Query & " p_rsch_1_a = '" & p_no & "' OR p_rsch_2_a = '" & p_no & "' OR p_rsch_3_a = '" & p_no & "' OR p_rsch_4_a = '" & p_no & "' OR "
|
|
Query = Query & " p_rsch_1_b = '" & p_no & "' OR p_rsch_2_b = '" & p_no & "' OR p_rsch_3_b = '" & p_no & "' OR p_rsch_4_b = '" & p_no & "' OR "
|
|
Query = Query & " p_rsch_1_c = '" & p_no & "' OR p_rsch_2_c = '" & p_no & "' OR p_rsch_3_c = '" & p_no & "' OR p_rsch_4_c = '" & p_no & "' OR "
|
|
Query = Query & " p_sv_1 = '" & p_no & "' OR p_sv_2 = '" & p_no & "' OR p_sv_3 = '" & p_no & "' OR p_sv_4 = '" & p_no & "' OR "
|
|
Query = Query & " p_code_1 = '" & p_no & "' OR p_code_2 = '" & p_no & "' OR p_code_3 = '" & p_no & "' OR p_code_4 = '" & p_no & "' OR "
|
|
Query = Query & " p_verify_1 = '" & p_no & "' OR p_verify_2 = '" & p_no & "' OR p_verify_3 = '" & p_no & "' OR p_verify_4 = '" & p_no & "' OR "
|
|
Query = Query & " p_dp_1 = '" & p_no & "' OR p_dp_2 = '" & p_no & "' OR p_dp_3 = '" & p_no & "' OR p_dp_4 = '" & p_no & "' OR "
|
|
Query = Query & " p_it_1 = '" & p_no & "' OR p_it_2 = '" & p_no & "' OR p_it_3 = '" & p_no & "' OR p_it_4 = '" & p_no & "' OR "
|
|
Query = Query & " p_supp_1 = '" & p_no & "' OR p_supp_2 = '" & p_no & "' OR p_supp_3 = '" & p_no & "' OR p_supp_4 = '" & p_no & "' "
|
|
Query = Query & " ) "
|
|
Query = Query & " ORDER BY p_child_sn "
|
|
|
|
|
|
rsc.Open Query, adoConn, 1
|
|
for i = 1 to rsc.RecordCount
|
|
if i mod 2 = 0 then
|
|
tmp_bgcolor = "#dbe9f2"
|
|
else
|
|
tmp_bgcolor = "#ffffff"
|
|
end if
|
|
%>
|
|
<tr bgcolor="<%=tmp_bgcolor%>">
|
|
<td align="center"><%=rsc("p_child_sn")%></td>
|
|
<td align="left"> <a href="javascript:openit('<%=rsc("p_child_sn")%>','<%=rsc("p_subject")%>')" class="blue"><%=rsc("p_subject")%></a></td>
|
|
<td align="center"><%=rsc("p_method_nm")%></td>
|
|
<td align="center"><%=rsc("p_intention")%></td>
|
|
<td class="center" align="center"><%=rsc("d_name")%></td>
|
|
</tr>
|
|
<%
|
|
rsc.MoveNext
|
|
next
|
|
rsc.Close
|
|
%>
|
|
<tr>
|
|
<td colspan="6" bgcolor="#d5d5d5" height="1"></td>
|
|
</tr>
|
|
</table>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
</form> |