📄 taffair.java
字号:
sql = "select a.rqid,a.rtitle,a.rgrade,a.rnexttime,a.rdetail,b.utruename ,a.rmemo";
sql = sql +" from transreq a inner join tuser b on a.uno = b.uno where a.rqid = ";
sql = sql +rqid ;
rs = stmt.executeQuery(sql);
if (rs.next()) {
req = new HashMap();
req.put("rqid",rs.getString("rqid"));
req.put("rtitle",rs.getString("rtitle"));
req.put("rgrade",rs.getString("rgrade"));
req.put("rnexttime",rs.getString("rnexttime"));
req.put("rdetail",rs.getString("rdetail"));
req.put("utruename",rs.getString("utruename"));
req.put("rmemo",rs.getString("rmemo"));
}
sql = "select c.rqid,c.scurrentid,e.utruename,c.scurrenttime,c.snexttime,c.sname,c.spath "
+ " from transstep c "
+ " inner join transreq d on c.rqid = d.rqid "
+ " inner join tuser e on d.uno = e.uno"
+ " where c.sstatus='1' and c.rqid = ";
sql = sql +rqid +" order by c.scurrentid";
rs = stmt.executeQuery(sql);
while (rs.next()) {
Map steps = new HashMap();
steps.put("rqid",rs.getString("rqid"));
steps.put("scurrentid",rs.getString("scurrentid"));
steps.put("utruename",rs.getString("utruename"));
steps.put("scurrenttime",rs.getString("scurrenttime"));
steps.put("snexttime",rs.getString("snexttime"));
steps.put("sname",rs.getString("sname"));
steps.put("spath",rs.getString("spath"));
list.add(steps);
}
request.setAttribute("req", req);
request.setAttribute("affair", affair);
} catch (SQLException e) {
e.printStackTrace();
list = null;
}finally{
session.close();
sf.close();
}
return list;
}
public void setread(String rqid) {
Connection conn = null;
Statement st = null;
String sql = "";
sql = "update transstep set sstatus ='1' where rqid =" + rqid;
session = sf.openSession();
conn =session.connection();
try {
conn.setAutoCommit(false);//设置不自动提交
st = conn.createStatement();
st.execute(sql);
conn.commit();//提交事务
} catch (SQLException e) {
try {
conn.rollback();//事务回顾
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
e.printStackTrace();
}finally{
try {
st.close();
conn.close();
} catch (SQLException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
}
}
public boolean affairPass(String tag, HttpServletRequest request, AffairReqForm affairReqForm) {
Connection conn = null;
Statement st = null;
Statement st2 = null;
Transstep affairstep = new Transstep();
String sql = "";
String StepSql = "";
String sid = request.getParameter("sid");
String rqid = request.getParameter("rqid");
String stepid = request.getParameter("stepid");
String nstepid = String.valueOf(Integer.parseInt(stepid)+1);
session = sf.openSession();
conn =session.connection();
//审核通过
if (tag.equals("noend")) {
// 当前环节实际完成时间
String date = ToolUtil.getDate();
//先把上一环节的数据插入完整 ,并更改状态
sql = "update transstep set scurrenttime ='"+date+"',";
sql = sql +" snextuno='"+request.getParameter("userid")+"',";
sql = sql +" snexttime='"+request.getParameter("snexttime")+"',";
sql = sql +" sresult='3',";//0:待办,1：审核中，2：未通过，3：通过
sql = sql +" sdetail='"+request.getParameter("memo")+"',";
sql = sql +" sname='"+affairReqForm.getSname()+"',";
sql = sql +" spath='"+affairReqForm.getSpath()+"'";
sql = sql + " where sid =" + sid;
affairstep.setUno(request.getParameter("userid"));
affairstep.setSstatus("0");//当前状态
affairstep.setSresult("1");
StepSql ="insert into TRANSSTEP (SID, RQID, SCURRENTID, UNO, SSTATUS, SPRESTEP, SNEXTUNO, SCURRENTTIME, SNEXTTIME, SRESULT, SDETAIL, SNAME, SPATH)";
StepSql = StepSql+ "values ( SEQ_T_RANSSTEP.nextval,";
StepSql = StepSql +rqid+",";
StepSql = StepSql +nstepid+",'";
StepSql = StepSql +affairstep.getUno()+"','";
StepSql = StepSql +affairstep.getSstatus()+"',";
StepSql = StepSql +stepid+",'";
StepSql = StepSql +affairstep.getSnextuno()+"','";
StepSql = StepSql +affairstep.getScurrenttime()+"','";
StepSql = StepSql +affairstep.getSnexttime()+"','";
StepSql = StepSql +affairstep.getSresult()+"','";
StepSql = StepSql +affairstep.getSdetail()+"','";
StepSql = StepSql +affairstep.getSname()+"','";
StepSql = StepSql +affairstep.getSpath()+"')";
try {
conn.setAutoCommit(false);//设置不自动提交
st = conn.createStatement();
st2 = conn.createStatement();
st.execute(sql);
st2.execute(StepSql);
conn.commit();//提交事务
return true;
} catch (SQLException e) {
try {
conn.rollback();//事务回顾
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
e.printStackTrace();
}finally{
try {
st.close();
st2.close();
conn.close();
} catch (SQLException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
}
//插入下一环节的数据
}
//审核通过并完结该事务
if (tag.equals("end")) {
String date = ToolUtil.getDate();
//插入发起表 的事务结束时间
String seqSql = "";
seqSql =" update transreq set rendtime = '"+date+"',RSTATUS ='3' where rqid='"+rqid+"'";
//先把上一环节的数据插入完整 ,并更改状态
sql = "update transstep set scurrenttime ='"+date+"',";
sql = sql +" snextuno='"+request.getParameter("userid")+"',";
sql = sql +" snexttime='"+request.getParameter("snexttime")+"',";
sql = sql +" sresult='3',";//0:待办，1：审核中，2：未通过，3：通过
sql = sql +" sdetail='"+request.getParameter("memo")+"',";
sql = sql +" sname='"+affairReqForm.getSname()+"',";
sql = sql +" spath='"+affairReqForm.getSpath()+"'";
sql = sql + " where sid =" + sid;
try {
conn.setAutoCommit(false);//设置不自动提交
st = conn.createStatement();
st2 = conn.createStatement();
st.execute(sql);
st2.execute(seqSql);
conn.commit();//提交事务
return true;
} catch (SQLException e) {
try {
conn.rollback();//事务回顾
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
e.printStackTrace();
}finally{
try {
st.close();
st2.close();
conn.close();
} catch (SQLException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
}
}
//审核不通过返回上一环节
if (tag.equals("back")) {
//如果是第一环节，要把
int id = Integer.parseInt(stepid);
String tmpid = "";
String seqSql = "";
if(id>1){
tmpid = String.valueOf(id-1);
sql = "delete from transstep where rqid = '"+ rqid +"'";
seqSql =" update transstep set sstatus ='0' where rqid ='"+tmpid+"'";
}else{
sql = "update transstep set sstatus ='0' where rqid =" + rqid;
}
try {
conn.setAutoCommit(false);//设置不自动提交
st = conn.createStatement();
st2 = conn.createStatement();
st.execute(sql);
st2.execute(seqSql);
conn.commit();//提交事务
return true;
} catch (SQLException e) {
try {
conn.rollback();//事务回顾
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
e.printStackTrace();
}finally{
try {
st.close();
st2.close();
conn.close();
} catch (SQLException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
}
}
// 审核不通过并完结该事务
if (tag.equals("nopass")) {
String date = ToolUtil.getDate();
//插入发起表 的事务结束时间
String seqSql = "";
seqSql =" update transreq set rendtime = '"+date+"' and RSTATUS ='1' where rqid='"+rqid+"'";
//先把上一环节的数据插入完整 ,并更改状态
sql = "update transstep set scurrenttime ='"+date+"',";
sql = sql +" snextuno='"+request.getParameter("userid")+"',";
sql = sql +" snexttime='"+request.getParameter("snexttime")+"',";
sql = sql +" sresult='2',";//0:待办，1：审核中，2：未通过，3：通过
sql = sql +" sdetail='"+request.getParameter("memo")+"',";
sql = sql +" sname='"+affairReqForm.getSname()+"',";
sql = sql +" spath='"+affairReqForm.getSpath()+"'";
sql = sql + " where sid =" + sid;
try {
conn.setAutoCommit(false);//设置不自动提交
st = conn.createStatement();
st2 = conn.createStatement();
st.execute(sql);
st2.execute(seqSql);
conn.commit();//提交事务
return true;
} catch (SQLException e) {
try {
conn.rollback();//事务回顾
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
e.printStackTrace();
}finally{
try {
st.close();
st2.close();
conn.close();
} catch (SQLException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
}
}
return false;
}
public List mydealList(AffairReqForm affairReqForm, HttpServletRequest request) {
// TODO 自动生成方法存根
return null;
}
public List mysendList(AffairReqForm affairReqForm, HttpServletRequest request) {
// TODO 自动生成方法存根
return null;
}
public List myreqList(int currentPage, int count, Transreq reqbean, HttpServletRequest request) {
String uno = (String) request.getAttribute("uno");
StringBuffer sql = new StringBuffer();
StringBuffer centent = new StringBuffer();
String rgrade = request.getParameter("rgrade");
if(reqbean.getReqUsername()!=null&&!reqbean.getReqUsername().trim().equals("")){
centent.append(" and c.utruename like '%").append(reqbean.getReqUsername().trim()).append("%'");
}
if(rgrade !=null && !rgrade.trim().equals("")){
centent.append("and b.rgrade =").append(rgrade.trim()).append("");
}
if(reqbean.getRstarttime()!=null &&!reqbean.getRstarttime().trim().equals("")){
centent.append(" and b.rlasttime between'").append(reqbean.getRstarttime().trim()).append("'");
centent.append(" and '").append(reqbean.getRendtime().trim()).append("'");
}
sql.append("SELECT * FROM(")
.append("select a.SCURRENTID,b.rqid , c.utruename,b.rtitle,b.rgrade,a.scurrenttime,d.tname,a.sresult,ROWNUM as num from transstep a ")
.append(" left join transreq b on a.rqid = b.rqid ")
.append(" left join tuser c on b.uno = c.uno")
.append(" left join transtype d on d.rtid = b.tno where a.sstatus<>'0' and c.uno = '").append(uno).append("'")
.append(centent)
.append(")t WHERE ");
sql.append(" t.num<=").append(currentPage*count);
sql.append(" AND t.num>").append((currentPage-1)*count);
Connection conn = null;
Statement st = null;
ResultSet rs = null;
session = sf.openSession();
conn = session.connection();
List list = null;
Transreq reqbeans = null;
try {
int i = 0 ;
st = conn.createStatement();
rs = st.executeQuery(sql.toString());
list = new ArrayList();
while (rs.next()) {
i = i +1;
reqbeans = new Transreq();
reqbeans.setRqid(rs.getInt("RQID"));
reqbeans.setCurrentid(rs.getString("SCURRENTID"));
reqbeans.setRtitle(rs.getString("RTITLE"));
reqbeans.setTname(rs.getString("TNAME"));
reqbeans.setRresult(rs.getString("sresult"));
reqbeans.setReqUsername(rs.getString("utruename"));
reqbeans.setRgrade(rs.getString("rgrade"));
reqbeans.setRlasttime(rs.getString("scurrenttime"));
list.add(reqbeans);
}
// request.setAttribute("currentid",);
if (i == 0 ){
list = null;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
session.close();
sf.close();
}
return list;
}
public List myarrairList(int currentPage, int count, Transreq reqbean, HttpServletRequest request) {
String uno = (String) request.getAttribute("uno");
StringBuffer sql = new StringBuffer();
StringBuffer centent = new StringBuffer();
String rgrade = request.getParameter("rgrade");
if(rgrade !=null && !rgrade.trim().equals("")){
centent.append("and a.rgrade =").append(rgrade.trim()).append("");
}
if(reqbean.getRstarttime()!=null &&!reqbean.getRstarttime().trim().equals("")){
centent.append(" and a.rlasttime between'").append(reqbean.getRstarttime().trim()).append("'");
centent.append(" and '").append(reqbean.getRendtime().trim()).append("'");
}
sql.append("SELECT * FROM(")
.append("select a.rqid,a.rtitle,a.rgrade,b.tname,a.rstatus, a.rlasttime, ")
.append(" ROWNUM as num from transreq a left join transtype b on b.rtid = a.tno ")
.append(" left join tuser c on c.uno = a.uno where 1= 1 and c.uno = '").append(uno).append("'")
.append(centent)
.append(")t WHERE ");
sql.append(" t.num<=").append(currentPage*count);
sql.append(" AND t.num>").append((currentPage-1)*count);
Connection conn = null;
Statement st = null;
ResultSet rs = null;
session = sf.openSession();
conn = session.connection();
List list = null;
Transreq reqbeans = null;
try {
int i = 0 ;
st = conn.createStatement();
rs = st.executeQuery(sql.toString());
list = new ArrayList();
while (rs.next()) {
i = i +1;
reqbeans = new Transreq();
reqbeans.setRqid(rs.getInt("RQID"));
reqbeans.setRtitle(rs.getString("RTITLE"));
reqbeans.setTname(rs.getString("TNAME"));
reqbeans.setRresult(rs.getString("rstatus"));
reqbeans.setRgrade(rs.getString("rgrade"));
reqbeans.setRlasttime(rs.getString("rlasttime"));
list.add(reqbeans);
}
if (i == 0 ){
list = null;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
session.close();
sf.close();
}
return list;
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -