c-innovacion2/resoft/field_manager/process/project/plan/time_set.jsp

36 lines
1.5 KiB
Plaintext

<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
<%@include file="/include/db/db_connect.jsp"%>
<%@include file="/include/function/function.jsp"%>
<%request.setCharacterEncoding("utf-8");%>
<%
String c_project_no = r_call(request.getParameter("c_project_no"));
String c_mode = r_call(request.getParameter("c_mode"));
String c_value = r_call(request.getParameter("c_value"));
String c_propse_s_date = r_call(request.getParameter("c_propse_s_date"));
String c_propse_e_date = r_call(request.getParameter("c_propse_e_date"));
String c_propse_s_time1 = r_call(request.getParameter("c_propse_s_time1"));
String c_propse_s_time2 = r_call(request.getParameter("c_propse_s_time2"));
String c_propse_e_time1 = r_call(request.getParameter("c_propse_e_time1"));
String c_propse_e_time2 = r_call(request.getParameter("c_propse_e_time2"));
c_propse_s_date = c_propse_s_date + " " + c_propse_s_time1 + ":" + c_propse_s_time2;
c_propse_e_date = c_propse_e_date + " " + c_propse_e_time1 + ":" + c_propse_e_time2;
if(c_project_no.equals("")){
%>
<script>
alert("Wrong Connection.");
location.href="/"
</script>
<%
}else{
String sql_ok = "update tbl_project_plan set c_propose_s_date = '"+ c_propse_s_date +"', c_propose_e_date = '"+ c_propse_e_date +"' where c_relation=0 and c_project_no = "+ c_project_no;
stmt.execute(sql_ok);
%>
<script>
alert("Edit OK")
location.href="list.jsp?c_project_no=<%=c_project_no%>"
</script>
<%
}
%>
<%@include file="/include/db/db_close.jsp"%>