36 lines
1.3 KiB
Plaintext
36 lines
1.3 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_no = r_call(request.getParameter("c_no"));
|
|
String c_name = r_call(request.getParameter("c_name"));
|
|
String c_field = r_call(request.getParameter("c_field"));
|
|
String o_field = r_call(request.getParameter("o_field"));
|
|
String o_order = r_call(request.getParameter("c_order"));
|
|
|
|
int c_order = 1;
|
|
|
|
if(c_field.equals(o_field)){
|
|
c_order = Integer.parseInt(o_order);
|
|
}else{
|
|
String sql1=" SELECT max(c_order) as max_order from tbl_project where c_field = " + session.getAttribute("manager_field_no") + " and c_relation = 0 and c_type = 0 and c_up_no = 0 and c_use = 0 ";
|
|
ResultSet rst = stmt.executeQuery(sql1);
|
|
if(rst.next()) {
|
|
c_order = c_order + rst.getInt("max_order");
|
|
}
|
|
rst.close();
|
|
}
|
|
String sql_ok = "";
|
|
sql_ok = "update tbl_project set c_field = "+ session.getAttribute("manager_field_no") +",c_name = '"+ c_name+"',c_order="+ c_order +" where c_no = " + c_no;
|
|
stmt2.execute(sql_ok);
|
|
%>
|
|
<script>
|
|
alert("Edit OK");
|
|
parent.location.href="list.jsp?c_field=<%=c_field%>"
|
|
</script>
|
|
<%
|
|
|
|
%>
|
|
<%@include file="/include/db/db_close.jsp"%> |