<%@ page contentType="text/html; charset=utf-8" pageEncoding="utf-8"%> <%@include file="/include/include.jsp"%> <% String c_project_no = r_call(request.getParameter("c_project_no")); String c_team_no = r_call(request.getParameter("c_team_no")); int c_now_propose = 0; if(c_project_no.equals("")){ %> <% }else{ String slq_chekc = "select * from tbl_apply_team where c_project_no = "+ c_project_no + " and c_no = " + c_team_no + " and c_use = 0 "; ResultSet rs_check = stmt.executeQuery(slq_chekc); if (rs_check.next()) { String sql_up = " SELECT c.*, a.c_name as u_name, b.c_name as f_name "; sql_up = sql_up + " , (select c_now_propose from tbl_project_plan where c_relation = 0 and c_project_no = c.c_no) as c_now_propose " ; sql_up = sql_up + " from tbl_project c "; sql_up = sql_up + " inner join tbl_project a on a.c_no = c.c_up_no "; sql_up = sql_up + " inner join tbl_field b on b.c_no = a.c_field "; sql_up = sql_up + " where c.c_no = " + c_project_no; ResultSet rs_up = stmt.executeQuery(sql_up); if (rs_up.next()) { c_now_propose = rs_up.getInt("c_now_propose"); %>

Información del equipo de solicitud del proyecto Campo principal <%=rs_up.getString("f_name")%> Categoría <%=rs_up.getString("u_name")%> Nombre del proyecto <%=rs_up.getString("c_name")%> <% } rs_up.close(); %> * Información del equipo de aplicación <% int i = 0; int stu_check = 1; String sql_field = " SELECT * from tbl_apply_field where c_project_no = " + c_project_no +" order by c_order asc "; ResultSet rs_field = stmt.executeQuery(sql_field); while (rs_field.next()) { if(rs_field.getString("c_use_field").equals("c_grade")){ stu_check = 0; } i = i + 1; %> <% } rs_field.close(); %> Artículo Contenido <%=rs_field.getString("c_name")%> <%if(rs_field.getInt("c_type") == 1){%> <%=rs_check.getString(rs_field.getString("c_use_field"))%> <%}%> <%if(rs_field.getInt("c_type") == 2){ %> <%=rs_check.getString(rs_field.getString("c_use_field"))%> <%}%> <%if(rs_field.getInt("c_type") == 3){%> <%=rs_check.getString(rs_field.getString("c_use_field"))%> <%}%> <%if(rs_field.getInt("c_type") == 4){%> Archivo de registro : "><%=rs_check.getString(rs_field.getString("c_use_field"))%> <%}%> <% String major_t = "Departamento"; String grade_t = "calificación"; if( stu_check == 1){ major_t = "Departamento"; grade_t = "rango"; } %> * Información de los miembros del equipo <% String slq_t = "select * from tbl_apply_team_member where c_project_no = "+ c_project_no + " and c_team_no = " + c_team_no + " and c_use = 0 order by c_type desc "; ResultSet rs_t = stmt2.executeQuery(slq_t); while(rs_t.next()) { %> <%} rs_t.close(); %> Jefe de equipo. Email nombre teléfono <%=major_t%> <%=grade_t%> <%if(rs_t.getInt("c_type") == 1){%> Jefe de equipo <%}else{%> Miembros del equipo <%}%> <%=rs_t.getString("c_email")%> <%=rs_t.getString("c_name")%> <%=rs_t.getString("c_phone")%> <%=rs_t.getString("c_major")%> <%=rs_t.getString("c_grade")%>

<%}else{%> <%} rs_check.close(); %> <%}%> <%@include file="/include/include_b.jsp"%>