📄 doarchives.jsp
字号:
<%--
模块名称：待归档处理
模块功能：归档处理
版 本：V1.0
著 作 人：SIMM
著作日期：2001-10-24
使用说明：
主要技术说明：
参考文献：法律事务设计书
修改历史：
= = = = = = = = = = = = = = = = = = = = = = = = = =
修改日期：
修 改 人：
修改理由：
修改出处：
= = = = = = = = = = = = = = = = = = = = = = = = = =
--%>
<%@ page contentType= "text/html; charset=gb2312" %>
<%@ page language="java" %>
<%@ page import="java.sql.*" %>
<jsp:useBean id="db" class="dbconnection.DbConnection" scope="page" />
<%@ page import="system.*" %>
<%
Security auth = new Security();
String scu_employee_id = (String)session.getAttribute("employee_id");
if(scu_employee_id == null || scu_employee_id.equals(""))
{
response.sendRedirect(response.encodeRedirectURL("../Error/nonlogin.htm"));
}
String modelid = "Ach012"; // 待归档案件归档
int authflag = auth.popedom(scu_employee_id, modelid);
if(authflag == 0 || authflag == 2 || authflag == -1)
{%>
<jsp:forward page="../inc/noauth.jsp" >
</jsp:forward>
<%}%>
<html>
<head>
<title>归档处理</title>
</head>
<body>
<form name="myForm" method="post" >
<%
String sql;
ResultSet rs = null;
boolean flag = false;
int i,j=0;
String caseStr = "", tempStr = "";
String case_ids = request.getParameter("case_ids");
ExtendString es = new ExtendString();
String toDate = es.getNowDate(0);
toDate = toDate.substring(0,4) + "-" +
toDate.substring(4,6) + "-" +
toDate.substring(6,8);
String toTime = es.getNowTime();
toTime = toDate + " " + toTime;
String[] case_id = new String[10];
case_id = es.Split(",",case_ids);
for (i=0; i<es.length; i++) {
rs = db.executeQuery("select archive_id from t_caseinfo where case_id='" + case_id[i] + "'");
if(rs.next())
tempStr = rs.getString("archive_id");
if((tempStr == null) || (tempStr.equals(""))) {
caseStr = caseStr + case_id[i] + ".";
continue;
}
sql = "update t_caseinfo set case_state = 'gdzt'"; //gdzt----归档状态
sql = sql + " ,archive_date = '" + toTime + "'";
sql = sql + " where case_id='" + case_id[i] + "'";
j = db.executeUpdate(sql);
} /**/
%>
<input type="hidden" name="txtCaseStr" value=<%=caseStr%>>
<% if(!caseStr.equals(""))
{
%>
<script language=JavaScript>
alert("归档不成功！编码" + document.myForm.txtCaseStr.value +"的案件没有档案编号!" );
self.location = "StayArchives.jsp";
</script>
<%} else {%>
<script language=JavaScript>
self.location = "StayArchives.jsp";
</script>
<%}%>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -