📄 savewsjy.java
字号:
package com.stsc.archive.jygl;
import java.io.*;
import javax.sql.DataSource;
import javax.naming.*;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.*;
import org.apache.struts.action.*;
import org.apache.struts.util.MessageResources;
import com.stsc.archive.jygl.*;
import com.stsc.archive.manage.* ;
import java.util.*;
import com.stsc.util.*;
/*
保存，删除，编辑类
*/
public final class SaveWsjy extends Action {
public ActionForward perform(ActionMapping mapping,
ActionForm form,
HttpServletRequest request,
HttpServletResponse response)
throws IOException, ServletException {
Locale locale = getLocale(request);
MessageResources messages = getResources();
HttpSession session = request.getSession();
JyForm JyForm = (JyForm)form;
ActionErrors errors = new ActionErrors();
User userInfo = (User)(session.getAttribute(Constants.CURRENT_USER_KEY));
String action = request.getParameter("action");
if (action==null) action="Create";
Properties dbBase = new Properties();
System.out.println("&&&&&&&&&&&&&&&&"+Constants.DATABASE_KEY);
dbBase.setProperty("dsJndiName",Constants.DATABASE_KEY);
STPoolDataSet data = new STPoolDataSet();
STResultSet rs;
JycxList jycxlist = new JycxList(); //定义显示列表
String serialno = ""; // 文件流水号
String title = ""; // 文件（案卷）题名
String archivalcode = ""; // 存址号
String applicant = ""; // 申请人
String applytime = ""; // 申请借阅时间
String reason = ""; // 申请理由
String approver = ""; // 审批人
String approvetime = ""; // 审批时间
String approvesuggest = ""; // 审批意见
String replier = ""; // 答复人
String replytime = ""; // 答复时间
String replysuggest = ""; // 答复意见
String applystatus = ""; // 申请的状态
int borrowapplyid = 0 ;
String submit_name = "";
String sql = "";
String todayStr = "";
// 分页显示数据
int total = 0;
int totalPage = 0;
int curPage=0;
int page_num=10;
int perpage = 0;
int gopage=1;
int j=1;
java.text.SimpleDateFormat sdf = new java.text.SimpleDateFormat(Constants.DATEFORMAT);
todayStr = sdf.format(new java.util.Date());
try
{
page_num = userInfo.getRowsPerPage();
System.out.println("########## page_num="+page_num);
}
catch (Exception e)
{
page_num = 10;
System.out.println("########## 8888888888 page_num="+page_num);
}
submit_name =request.getParameter("sb");
if(submit_name!=null&&!submit_name.equals("")&&!submit_name.equals("null")){
//删除借阅记录
if(submit_name.equals("删除所选借阅申请")){
String []temp =request.getParameterValues("borrowapplyid");
Vector vecSql = new Vector();
gopage= Integer.parseInt(request.getParameter("goPage"));
if(temp!=null){
for( int i=0;i<temp.length;i++){
int temp_int=Integer.parseInt(temp[i]);
sql = " DELETE FROM fReadApply WHERE BorrowApplyId="+temp_int;
vecSql.addElement(sql);
sql = " DELETE FROM fApproveList WHERE BorrowApplyId="+temp_int;
vecSql.addElement(sql);
}
}
data.executeSQL(vecSql,dbBase);
}
//提交所选借阅申请
if(submit_name.equals("提交所选借阅申请")){
String []temp =request.getParameterValues("borrowapplyid");
Vector vecSql = new Vector();
if(temp!=null){
for( int i=0;i<temp.length;i++){
sql = " UPDATE fReadApply SET ApplyStatus='未处理' WHERE BorrowApplyId="+Integer.parseInt(temp[i]);
vecSql.addElement(sql);
}
}
data.executeSQL(vecSql,dbBase);
}
if(submit_name.equals("转到")){
gopage= Integer.parseInt(request.getParameter("goPage"));
}
}else{
submit_name="no";
}
//网上借阅批量申请
if(action.equals("plsq")){
Vector vecSql = new Vector();
String []temp_serialno =request.getParameterValues("serialno");
String []temp_approver =request.getParameterValues("approver");
reason=request.getParameter("comment");
if(reason==null){
reason="";
}
if(temp_serialno!=null){
for(int i=0;i<temp_serialno.length;i++){
//由于在fArchive中的流水号变为FlowNo使用以下sql，若改回来则将sql中select FlowNo,Title, ArchivalCode中的FlowNo改为SerialNo
sql = "insert into fReadApply(SerialNo,Title,ArchivalCode,Applicant,Reason,ApplyTime,ApplyStatus) select FlowNo,Title, ArchivalCode,'"
+userInfo.getUserName()+"','"+reason +"','"+todayStr+"','未提交' from fArchive where SerialNo="+Integer.parseInt(temp_serialno[i]);
vecSql.addElement(sql);
if(temp_approver!=null){
//申请选定的处理人员
if(temp_approver[0].equals("all")){
// sql="INSERT INTO fApproveList (EnterName,BorrowApplyID,SerialNo,RoleID) SELECT EnterName,(select max(BorrowApplyId) from fReadApply) ,'"+temp_serialno[i]+"',2 FROM fUserRole where RoleID=2" ;
//由于在fArchive中的流水号变为FlowNo使用以下sql，若改回来则用以上sql
// sql="INSERT INTO fApproveList (EnterName,BorrowApplyID,SerialNo,RoleID) SELECT EnterName,(select max(BorrowApplyId) from fReadApply) ,(Select FlowNo from fArchive Where SerialNo="+temp_serialno[i]+ "),2 FROM fUserRole where RoleID=2" ;
sql="INSERT INTO fApproveList (EnterName,BorrowApplyID,SerialNo,RoleID) SELECT fUserName.UserName,(select max(BorrowApplyId) from fReadApply) ,(Select FlowNo from fArchive Where SerialNo="+temp_serialno[i]+ "),2 from fUserName ,fUserRole where fUserRole.EnterName = fUserName.EnterName and fUserRole.RoleID=2" ;
vecSql.addElement(sql);
}else{
for( int k=0;k<temp_approver.length;k++){
// sql="INSERT INTO fApproveList (EnterName,BorrowApplyID,SerialNO,RoleID) SELECT '"+temp_approver[k]+"',max(BorrowApplyId),'"+temp_serialno[i]+"',2 from fReadApply" ;
//由于在fArchive中的流水号变为FlowNo使用以下sql，若改回来则用以上sql
sql="INSERT INTO fApproveList (EnterName,BorrowApplyID,SerialNo,RoleID) SELECT '"+temp_approver[k]+"',max(BorrowApplyId),(Select FlowNo from fArchive Where SerialNo="+temp_serialno[i]+ ") ,2 from fReadApply" ;
System.out.println("#################% 333 sql==="+sql);
vecSql.addElement(sql);
}
}
}
// data.executeSQL(sql,dbBase);
}
data.executeSQL(vecSql,dbBase);
}
}
//网上答复
if(action.equals("wsdf")){
if(submit_name!=null&&!submit_name.equals("")){
if(submit_name.equals("不同意")){
Vector vecSql = new Vector();
submit_name =request.getParameter("sb");
borrowapplyid =Integer.parseInt(request.getParameter("borrowapplyid"));
replier = request.getParameter("replier");
replytime = request.getParameter("replytime");
replysuggest = request.getParameter("replysuggest");
sql="UPDATE fReadApply SET Replier ='"+replier+"',ReplyTime=cdate('"
+replytime+"'),ReplySuggest='"+replysuggest+"',ApplyStatus='审批完成' WHERE BorrowApplyId="+borrowapplyid;
vecSql.addElement(sql);
sql="DELETE from fApproveList WHERE RoleID=8 and BorrowApplyId="+borrowapplyid;;
vecSql.addElement(sql);
data.executeSQL( vecSql,dbBase);
}else if(submit_name.equals("同意")){
Vector vecSql = new Vector();
submit_name =request.getParameter("sb");
borrowapplyid =Integer.parseInt(request.getParameter("borrowapplyid"));
replier = request.getParameter("replier");
replytime = request.getParameter("replytime");
replysuggest = request.getParameter("replysuggest");
sql="UPDATE fReadApply SET Replier ='"+replier+"',ReplyTime=cdate('"
+replytime+"'),ReplySuggest='"+replysuggest+"',ApplyStatus='审批完成' WHERE BorrowApplyId="+borrowapplyid;
vecSql.addElement(sql);
sql="DELETE from fApproveList WHERE RoleID=8 and BorrowApplyId="+borrowapplyid;;
vecSql.addElement(sql);
data.executeSQL( vecSql,dbBase); }
//答复所选借阅申请
if(submit_name.equals("答复")){
System.out.println(" 这是在批量答复中");
String []temp =request.getParameterValues("borrowapplyid");
Vector vecSql = new Vector();
if(temp!=null){
replysuggest =request.getParameter("comment");
for( int i=0;i<temp.length;i++){
sql="UPDATE fReadApply SET Replier ='"+userInfo.getUserName()+"',ReplyTime=cdate('"
+todayStr+"'),ReplySuggest='"+replysuggest+"',ApplyStatus='审批完成' WHERE BorrowApplyId="+Integer.parseInt(temp[i]);
vecSql.addElement(sql);
sql="DELETE from fApproveList WHERE RoleID=8 and BorrowApplyId="+Integer.parseInt(temp[i]);
vecSql.addElement(sql);
}
}
data.executeSQL(vecSql,dbBase);
}
}
}
//提交给二次审批
if(action.equals("ecsp")){
if(submit_name.equals("提交给二次审批")){
Vector vecSql = new Vector();
String []temp =request.getParameterValues("borrowapplyid");
String []temp_replier =request.getParameterValues("replier");
approvesuggest =request.getParameter("comment");
if(temp_replier!=null){
//申请选定的二次审批人员
for(int i=0;i<temp.length;i++){
if(temp_replier[0].equals("all")){
// sql="INSERT INTO fApproveList (EnterName,BorrowApplyID,SerialNo,RoleID ) SELECT EnterName,"+borrowapplyid+",'"+serialno+"',8 FROM fUserRole where RoleID=8 " ;
sql="INSERT INTO fApproveList (EnterName,BorrowApplyID,SerialNo,RoleID ) SELECT fUserName.UserName,"+Integer.parseInt(temp[i])+",(select SerialNo from fReadApply Where BorrowApplyID="+Integer.parseInt(temp[i]) +"),8 from fUserName ,fUserRole where fUserRole.EnterName = fUserName.EnterName and fUserRole.RoleID=8" ;
System.out.println("$$$$$$$$$$ sql==="+sql);
vecSql.addElement(sql);
}else{
for( int k=0;k<temp_replier.length;k++){
// sql="INSERT INTO fApproveList (EnterName,BorrowApplyID,SerialNO,RoleID) VALUES('"+temp_replier[k]+"',"+Integer.parseInt(temp[i])+",'"+serialno+"',8)";
sql="INSERT INTO fApproveList (EnterName,BorrowApplyID,SerialNO,RoleID) select '"+temp_replier[k]+"',BorrowApplyID,SerialNo,8 from fReadApply Where BorrowApplyID="+Integer.parseInt(temp[i]) ;
System.out.println("$$$$$$$$$$%%%%%55 sql==="+sql);
vecSql.addElement(sql);
}
}
sql="UPDATE fReadApply SET Approver ='"+userInfo.getUserName()+"',ApproveTime=cdate('"
+todayStr+"'),Approvesuggest='"+approvesuggest+"',ApplyStatus='二次审批' WHERE BorrowApplyId="+Integer.parseInt(temp[i]);
vecSql.addElement(sql);
}
}
data.executeSQL(vecSql,dbBase);
} else if(submit_name.equals("同意借阅")){
Vector vecSql = new Vector();
String []temp =request.getParameterValues("borrowapplyid");
approvesuggest =request.getParameter("comment");
for(int i=0;i<temp.length;i++){
sql="UPDATE fReadApply SET Approver ='"+userInfo.getUserName()+"',ApproveTime=cdate('"
+todayStr+"'),Approvesuggest='"+approvesuggest+"',ApplyStatus='已处理' WHERE BorrowApplyId="+Integer.parseInt(temp[i]);
vecSql.addElement(sql);
}
data.executeSQL(vecSql,dbBase);
}else if(submit_name.equals("不同意借阅")){
Vector vecSql = new Vector();
String []temp =request.getParameterValues("borrowapplyid");
approvesuggest =request.getParameter("comment");
for(int i=0;i<temp.length;i++){
sql="UPDATE fReadApply SET Approver ='"+userInfo.getUserName()+"',ApproveTime=cdate('"
+todayStr+"'),Approvesuggest='"+approvesuggest+"',ApplyStatus='未通过' WHERE BorrowApplyId="+Integer.parseInt(temp[i]);
vecSql.addElement(sql);
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -