📄 savewsjy.java
字号:
}
data.executeSQL(vecSql,dbBase);
}else if(!submit_name.equals("转到")){
String []temp_replier =request.getParameterValues("replier");
borrowapplyid =Integer.parseInt(request.getParameter("borrowapplyid"));
approver = request.getParameter("approver");
approvetime = request.getParameter("approvetime");
approvesuggest = request.getParameter("approvesuggest");
serialno = request.getParameter("serialno");
if(temp_replier!=null){
//申请选定的二次审批人员
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,"+borrowapplyid+",'"+serialno+"',8 from fUserName ,fUserRole where fUserRole.EnterName = fUserName.EnterName and fUserRole.RoleID=8" ;
data.executeSQL(sql,dbBase);
}else{
for( int k=0;k<temp_replier.length;k++){
sql="INSERT INTO fApproveList (EnterName,BorrowApplyID,SerialNO,RoleID) VALUES('"+temp_replier[k]+"',"+borrowapplyid+",'"+serialno+"',8)";
data.executeSQL(sql,dbBase);
}
}
}
sql="UPDATE fReadApply SET Approver ='"+approver+"',ApproveTime=cdate('"
+approvetime+"'),Approvesuggest='"+approvesuggest+"',ApplyStatus='二次审批' WHERE BorrowApplyId="+borrowapplyid;
data.executeSQL(sql,dbBase);
}
}
//申请处理操作
if(action.equals("Sqcl")){
submit_name =request.getParameter("sb");
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);
}
data.executeSQL(vecSql,dbBase);
} else{
if(!submit_name.equals("转到")){
borrowapplyid =Integer.parseInt(request.getParameter("borrowapplyid"));
approver = request.getParameter("approver");
approvetime = request.getParameter("approvetime");
approvesuggest = request.getParameter("approvesuggest");
if(submit_name.equals("不同意")){
sql="UPDATE fReadApply SET Approver ='"+approver+"',ApproveTime=cdate('"
+approvetime+"'),Approvesuggest='"+approvesuggest+"',ApplyStatus='未通过' WHERE BorrowApplyId="+borrowapplyid;
}else {
sql="UPDATE fReadApply SET Approver ='"+approver+"',ApproveTime=cdate('"
+approvetime+"'),Approvesuggest='"+approvesuggest+"',ApplyStatus='已处理' WHERE BorrowApplyId="+borrowapplyid;
}
data.executeSQL(sql,dbBase);
}
}
}
//修改借阅申请记录
if(action.equals("Edit")&&!submit_name.equals("删除所选借阅申请")&&!submit_name.equals("提交所选借阅申请")){
if(!submit_name.equals("转到")){
borrowapplyid =Integer.parseInt(request.getParameter("borrowapplyid"));
serialno = request.getParameter("serialno");
title = request.getParameter("title") ;
archivalcode = request.getParameter("archivalcode");
applicant = request.getParameter("applicant");
applytime = request.getParameter("applytime");
reason = request.getParameter("reason");
submit_name =request.getParameter("sb");
if(submit_name.equals("提交")){
sql="UPDATE fReadApply SET Title ='"+title+"',SerialNo='"+serialno+"',Applicant='"
+applicant+"',ApplyTime='"+ applytime+"',Reason='"+reason +"',ArchivalCode='"+archivalcode
+"',ApplyStatus='未处理' WHERE BorrowApplyId="+borrowapplyid;
}else {
sql="UPDATE fReadApply SET Title ='"+title+"',SerialNo='"+serialno+"',Applicant='"
+applicant+"',ApplyTime='"+ applytime+"',Reason='"+reason +"',ArchivalCode='"+archivalcode
+"' WHERE BorrowApplyId="+borrowapplyid;
}
data.executeSQL(sql,dbBase);
}
}
//删除借阅申请记录
if(action.equals("Delete")){
String []temp =request.getParameterValues("borrowapplyid");
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;
data.executeSQL(sql,dbBase);
}
}
}
//建立新的借阅记录
/*
if(action.equals("Create")&&!submit_name.equals("删除所选借阅申请")&&!submit_name.equals("提交所选借阅申请")){
borrowapplyid =Integer.parseInt(request.getParameter("borrowapplyid"));
serialno = request.getParameter("serialno");
title = request.getParameter("title") ;
archivalcode = request.getParameter("archivalcode");
applicant = request.getParameter("applicant");
applytime = request.getParameter("applytime");
reason = request.getParameter("reason");
sql="INSERT INTO fReadApply(SerialNo,Title,Applicant,Reason,ArchivalCode,ApplyTime,ApplyStatus) VALUES('"+serialno+"','"+title+"','"+applicant+"','"+reason+"','"+archivalcode+"',cdate('"+applytime+"'),' ')";
data.executeSQL(sql,dbBase);
}
*/
//借阅申请登记
if(action.equals("Jysq")){
Vector vecSql = new Vector();
String []temp_approver =request.getParameterValues("approver");
if(!submit_name.equals("转到")){
borrowapplyid =Integer.parseInt(request.getParameter("borrowapplyid"));
serialno = request.getParameter("serialno");
title = request.getParameter("title") ;
archivalcode = request.getParameter("archivalcode");
applicant = request.getParameter("applicant");
applytime = request.getParameter("applytime");
reason = request.getParameter("reason");
sql="INSERT INTO fReadApply(SerialNo,Title,Applicant,Reason,ArchivalCode,ApplyTime,ApplyStatus) VALUES('"+serialno+"','"+title+"','"+applicant+"','"+reason+"','"+archivalcode+"',cdate('"+applytime+"'),'未提交')";
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) ,'"+serialno+"',2 FROM fUserRole where RoleID=2" ;
sql="INSERT INTO fApproveList (EnterName,BorrowApplyID,SerialNo,RoleID) SELECT fUserName.UserName,(select max(BorrowApplyId) from fReadApply) ,'"+serialno+ "',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),'"+serialno+"',2 from fReadApply" ;
System.out.println("#################% 333 sql==="+sql);
vecSql.addElement(sql);
}
}
}
data.executeSQL(vecSql,dbBase);
}
}
//初始化页面的sql
if(action.equals("Sqcl")){
// sql="select fReadApply.* from fReadApply,fApproveList Where fReadApply.ApplyStatus ='未处理' or fReadApply.ApplyStatus ='不同意' or fReadApply.ApplyStatus ='同意' and fReadApply.BorrowApplyID=fApproveList.BorrowApplyID and fApproveList.EnterName='"+userInfo.getUserName()+"' and fApproveList.RoleID=2 order by fReadApply.BorrowApplyId ";
sql="select fReadApply.* from fReadApply,fApproveList Where (fReadApply.ApplyStatus ='未处理' or fReadApply.ApplyStatus ='审批完成') and fReadApply.BorrowApplyID=fApproveList.BorrowApplyID and fApproveList.EnterName='"+userInfo.getUserName()+"' and fApproveList.RoleID=2 order by fReadApply.BorrowApplyId ";
}else if(action.equals("wsdf")){
sql="select fReadApply.* from fReadApply,fApproveList Where fReadApply.ApplyStatus ='二次审批' and fReadApply.BorrowApplyID=fApproveList.BorrowApplyID and fApproveList.EnterName='"+userInfo.getUserName()+"' and fApproveList.RoleID=8 order by fReadApply.BorrowApplyId ";
}else if(action.equals("ecsp")){
sql="select fReadApply.* from fReadApply,fApproveList Where (fReadApply.ApplyStatus ='未处理' or fReadApply.ApplyStatus ='审批完成') and fReadApply.BorrowApplyID=fApproveList.BorrowApplyID and fApproveList.EnterName='"+userInfo.getUserName()+"' and fApproveList.RoleID=2 order by fReadApply.BorrowApplyId ";
}else if(action.equals("clwjysp")){
sql="select * from fReadApply Where (ApplyStatus ='已处理' or ApplyStatus ='未通过') and Applicant='"+userInfo.getUserName() +"' order by BorrowApplyId ";
}else {
sql="select * from fReadApply Where ApplyStatus ='未提交' and Applicant='"+userInfo.getUserName() +"' order by BorrowApplyId ";
}
//未转向页面置数据
rs = data.getSTResult(sql, dbBase);
total = rs.getRecCount();
if((total%page_num)!=0){
totalPage=total/page_num+1;
}else{
totalPage=total/page_num;
}
if(totalPage==0){
gopage=0;
}else{
if(gopage==0){
gopage=1;
}
if(gopage > totalPage){
gopage=1;
}
}
while (rs!=null && rs.next())
{
if( j>=((gopage-1)*page_num+1)&&j<=(gopage*page_num)){
JyForm jyform = new JyForm();
jyform.setborrowapplyid(rs.getInt("BorrowApplyid"));
jyform.setserialno(rs.getString("SerialNo"));
jyform.settitle(rs.getString("Title"));
jyform.setarchivalcode(rs.getString("ArchivalCode"));
jyform.setapplicant(rs.getString("Applicant"));
jyform.setreason(rs.getString("Reason"));
jyform.setapplytime(String.valueOf(rs.getDate("ApplyTime")));
jyform.setapplystatus(rs.getString("ApplyStatus"));
jyform.setAction(action);
//分页显示
jycxlist.setGoPage(gopage);
jycxlist.setTotal(total);
jycxlist.setCurPage(gopage);
jycxlist.setTotalPage(totalPage);
jycxlist.addwsjyArchive(jyform);
}
j++;
}
// Report any errors we have discovered back to the original form
if (!errors.empty()) {
saveErrors(request, errors);
return (new ActionForward(mapping.getInput()));
}
session.setAttribute(Constants.JYCXLIST_KEY, jycxlist);
// Forward control to the specified success URI
return (mapping.findForward("success"));
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -