📄 agtmngstaffaction.java
字号:
return (mapping.findForward("workadd"));
}
else if (operatorflag.equalsIgnoreCase("AGTMNG_ADD_WORK_NEXTEDU"))
{
//将staffno传递给页面
req.setAttribute("staffno",staffno);
//显示新增教育经历页面 EduAdd
return (mapping.findForward("eduadd"));
}
else if (operatorflag.equalsIgnoreCase("AGTMNG_ADD_WORK_NEXTBASE"))
{
((AgtmngStaffForm)form).setOperatorflag("AGTMNG_QUERY_BASE_NEXTMOD");
return queryBaseArchive(mapping, form, req, res);
}
else
{
req.setAttribute("errorId",ErrorCode.UNKNOW_ERROR);
return (mapping.findForward("error"));
}*/
req.setAttribute("successId",SuccessCode.AGTMNG_ADDWORK);
return (mapping.findForward("success"));
}
else
{
//定位到错误页面错误码为 errorcode.AGTMNG_ADDWORK
req.setAttribute("errorId",ErrorCode.AGTMNG_ADDWORK);
return (mapping.findForward("error"));
}
}
catch (SysDbException aple)
{
//捕获CommonService系统异常,定向到出错页面，错误码为ErrorCode.COMMONSERVICE_ERROR
aple.printStackTrace();
req.setAttribute("errorId",ErrorCode.COMMONSERVICE_ERROR);
return (mapping.findForward("error"));
}
catch(java.sql.SQLException sqle)
{
//捕获调用aplcoms异常,定向到出错页面，错误码为ErrorCode.DATABASE_ERROR
sqle.printStackTrace();
req.setAttribute("errorId",ErrorCode.DATABASE_ERROR);
return (mapping.findForward("error"));
}
catch(Exception e)
{
//捕获未知异常,定向到出错页面，错误码为ErrorCode.UNKNOW_ERROR
e.printStackTrace();
req.setAttribute("errorId",ErrorCode.UNKNOW_ERROR);
return (mapping.findForward("error"));
}
finally
//关闭连接实例
{
if(aplcoms != null)
{
aplcoms.close();
}
}
}
/*******************************
*修改基本档案
*******************************/
private ActionForward modBaseArchive (ActionMapping mapping,
ActionForm form, HttpServletRequest req,
HttpServletResponse res)
{
//得到操作标识和基本档案信息
String operatorflag = ((AgtmngStaffForm)form).getOperatorflag();
String staffno =((AgtmngStaffForm)form).getStaffno();
String dutyid =((AgtmngStaffForm)form).getDutyid();
String sex =((AgtmngStaffForm)form).getSex();
String birthday =((AgtmngStaffForm)form).getBirthday();
String idcardno =((AgtmngStaffForm)form).getIdcardno();
String clanid =((AgtmngStaffForm)form).getClanid();
String edulevelid =((AgtmngStaffForm)form).getEdulevelid();
String major =((AgtmngStaffForm)form).getMajor();
String graduatedate =((AgtmngStaffForm)form).getGraduatedate();
String college =((AgtmngStaffForm)form).getCollege();
String flanguage =((AgtmngStaffForm)form).getFlanguage();
String nation =((AgtmngStaffForm)form).getNation();
String province =((AgtmngStaffForm)form).getProvince();
String marriage =((AgtmngStaffForm)form).getMarriage();
String department =((AgtmngStaffForm)form).getDepartment();
String workphone =((AgtmngStaffForm)form).getWorkphone();
String homephone =((AgtmngStaffForm)form).getHomephone();
String mobilephone =((AgtmngStaffForm)form).getMobilephone();
String address =((AgtmngStaffForm)form).getAddress();
String postcode =((AgtmngStaffForm)form).getPostcode();
String email =((AgtmngStaffForm)form).getEmail();
String rela1name =((AgtmngStaffForm)form).getRela1name();
String rela2name =((AgtmngStaffForm)form).getRela2name();
String rela3name =((AgtmngStaffForm)form).getRela3name();
String rela4name =((AgtmngStaffForm)form).getRela4name();
String rela1 =((AgtmngStaffForm)form).getRela1();
String rela2 =((AgtmngStaffForm)form).getRela2();
String rela3 =((AgtmngStaffForm)form).getRela3();
String rela4 =((AgtmngStaffForm)form).getRela4();
String rela1co =((AgtmngStaffForm)form).getRela1co();
String rela2co =((AgtmngStaffForm)form).getRela2co();
String rela3co =((AgtmngStaffForm)form).getRela3co();
String rela4co =((AgtmngStaffForm)form).getRela4co();
String rela1pos =((AgtmngStaffForm)form).getRela1pos();
String rela2pos =((AgtmngStaffForm)form).getRela2pos();
String rela3pos =((AgtmngStaffForm)form).getRela3pos();
String rela4pos =((AgtmngStaffForm)form).getRela4pos();
String hobby =((AgtmngStaffForm)form).getHobby();
String specialty =((AgtmngStaffForm)form).getSpecialty();
String handlestaffno = req.getSession().getAttribute("staffno").toString();
String skillIds = ((AgtmngStaffForm)form).getSkillIds();
SysDbConn aplcoms = null;
try
{
//连接数据源
aplcoms = SysConnPool.getInstance().getAplComs();
aplcoms.preparedSP();
//获得输入参数
if (birthday != null)
{
birthday = birthday.replaceAll("-","");
}
if (graduatedate != null)
{
graduatedate = graduatedate.replaceAll("-","");
}
aplcoms.setString(1 ,staffno);
aplcoms.setString(2 ,dutyid);
aplcoms.setString(3 ,sex);
aplcoms.setString(4 ,birthday);
aplcoms.setString(5 ,idcardno);
aplcoms.setString(6 ,clanid);
aplcoms.setString(7 ,edulevelid);
aplcoms.setString(8 ,major);
aplcoms.setString(9 ,graduatedate);
aplcoms.setString(10 ,college);
aplcoms.setString(11 ,flanguage);
aplcoms.setString(12 ,nation);
aplcoms.setString(13 ,province);
aplcoms.setString(14 ,marriage);
aplcoms.setString(15 ,workphone);
aplcoms.setString(16 ,homephone);
aplcoms.setString(17 ,mobilephone);
aplcoms.setString(18 ,address);
aplcoms.setString(19 ,postcode);
aplcoms.setString(20 ,email);
aplcoms.setString(21 ,rela1);
aplcoms.setString(22 ,rela2);
aplcoms.setString(23 ,rela3);
aplcoms.setString(24 ,rela4);
aplcoms.setString(25 ,rela1name);
aplcoms.setString(26 ,rela2name);
aplcoms.setString(27 ,rela3name);
aplcoms.setString(28 ,rela4name);
aplcoms.setString(29 ,rela1co);
aplcoms.setString(30 ,rela2co);
aplcoms.setString(31 ,rela3co);
aplcoms.setString(32 ,rela4co);
aplcoms.setString(33 ,rela1pos);
aplcoms.setString(34 ,rela2pos);
aplcoms.setString(35 ,rela3pos);
aplcoms.setString(36 ,rela4pos);
aplcoms.setString(37 ,hobby);
aplcoms.setString(38 ,specialty);
aplcoms.setString(39 ,skillIds);
//if (调用存储过程 P_Agt_UpdateBaseArchive 修改基本档案记录成功)
SysDataSet ds1 = aplcoms.csCommonSP("P_Agt_UpdateBaseArchive");
SysRecord rc1 = ds1.getParamSet() ;
if (rc1!=null && rc1.getInt(0) ==0)
{
//记录档案操作日志
aplcoms.preparedSP();
aplcoms.setString(1 ,handlestaffno);
aplcoms.setString(2 ,"4"); //4表示修改基本档案操作
aplcoms.setString(3 ,staffno);
aplcoms.csCommonSP("P_Agt_AddArchiveLog");
/*
if (operatorflag.equalsIgnoreCase("AGTMNG_MOD_BASE"))
{
//将新增信息传递给页面
//显示修改基本档案信息页面 BaseModify
((AgtmngStaffForm) form).setOperatorflag("AGTMNG_QUERY_BASE_NEXTMOD");
return queryBaseArchive(mapping,form,req,res);
}
else if (operatorflag.equalsIgnoreCase("AGTMNG_MOD_BASE_NEXTEDU"))
{
//调用queryEduList方法查询教育经历表，查询得到结果集
return queryEduList(mapping,form,req,res);
}
else if (operatorflag.equalsIgnoreCase("AGTMNG_MOD_BASE_NEXTWORK"))
{
//调用 queryWorkList 方法查询工作经历表，得到结果集
return queryWorkList(mapping,form,req,res);
}
else
{
req.setAttribute("errorId",ErrorCode.UNKNOW_ERROR);
return (mapping.findForward("error"));
}*/
req.setAttribute("successId",SuccessCode.AGTMNG_MODBASE);
return (mapping.findForward("success"));
} else
{
//定位到错误页面错误码为 errorcode.AGTMNG_MODBASE
req.setAttribute("errorId",ErrorCode.AGTMNG_MODBASE);
return (mapping.findForward("error"));
}
}
catch (SysDbException aple)
{
//捕获CommonService系统异常,定向到出错页面，错误码为ErrorCode.COMMONSERVICE_ERROR
aple.printStackTrace();
req.setAttribute("errorId",ErrorCode.COMMONSERVICE_ERROR);
return (mapping.findForward("error"));
}
catch(java.sql.SQLException sqle)
{
//捕获调用aplcoms异常,定向到出错页面，错误码为ErrorCode.DATABASE_ERROR
sqle.printStackTrace();
req.setAttribute("errorId",ErrorCode.DATABASE_ERROR);
return (mapping.findForward("error"));
}
catch(Exception e)
{
//捕获未知异常,定向到出错页面，错误码为ErrorCode.UNKNOW_ERROR
e.printStackTrace();
req.setAttribute("errorId",ErrorCode.UNKNOW_ERROR);
return (mapping.findForward("error"));
}
finally
//关闭连接实例
{
if(aplcoms != null)
{
aplcoms.close();
}
}
}
/************************
* 修改教育经历信息
************************/
private ActionForward modEduArchive (ActionMapping mapping,
ActionForm form, HttpServletRequest req,
HttpServletResponse res)
{
//得到操作标识和教育经历信息
String operatorflag = ((AgtmngStaffForm)form).getOperatorflag();
String eduid = ((AgtmngStaffForm)form).getEduid();
String staffno =((AgtmngStaffForm)form).getStaffno();
String startdate =((AgtmngStaffForm)form).getEdustartdate();
String enddate =((AgtmngStaffForm)form).getEduenddate();
String school =((AgtmngStaffForm)form).getEduschool();
String duty =((AgtmngStaffForm)form).getEduduty();
String honor =((AgtmngStaffForm)form).getEduhonor();
String punish =((AgtmngStaffForm)form).getEdupunish();
String detail =((AgtmngStaffForm)form).getEdudetail();
String handlestaffno = req.getSession().getAttribute("staffno").toString();
SysDbConn aplcoms = null;
try
{
//连接数据源
aplcoms = SysConnPool.getInstance().getAplComs();
aplcoms.preparedSP();
if (startdate != null)
{
startdate = startdate.replaceAll("-","");
}
if (enddate != null)
{
enddate = enddate.replaceAll("-","");
}
//获得输入参数
aplcoms.setString(1 ,startdate);
aplcoms.setString(2 ,enddate);
aplcoms.setString(3 ,school);
aplcoms.setString(4 ,duty);
aplcoms.setString(5 ,honor);
aplcoms.setString(6 ,punish);
aplcoms.setString(7 ,detail);
aplcoms.setString(8 ,eduid);
//if (调用存储过程 P_Agt_UpdateEduArchive 修改教育经历记录成功)
SysDataSet ds1 = aplcoms.csCommonSP("P_Agt_UpdateEduArchive");
SysRecord rc1 = ds1.getParamSet() ;
if (rc1!=null && rc1.getInt(0) == 0)
{
//记录档案操作日志
aplcoms.setString(1 ,handlestaffno);
aplcoms.setString(2 ,"5"); //5表示修改教育经历档案操作
aplcoms.setString(3 ,staffno);
SysDataSet ds2 = aplcoms.csCommonSP("P_Agt_AddArchiveLog");
SysRecord rc2 = ds2.getParamSet() ;
if(rc2!=null && rc2.getInt(0) == 0)
{//记录错误日志
}
//显示教育经历修改页面
/*((AgtmngStaffForm) form).setOperatorflag("AGTMNG_QUERY_EDU_NEXTMOD");
((AgtmngStaffForm) form).setEduid(eduid);
return queryEduArchive(mapping, form, req, res);
*/
req.setAttribute("successId",SuccessCode.AGTMNG_MODEDU);
return(mapping.findForward("success"));
}
else
{
//定位到错误页面错误码为 errorcode.AGTMNG_MODEDU
req.setAttribute("errorId",ErrorCode.AGTMNG_MODEDU);
return(mapping.findForward("error"));
}
}
catch (SysDbException aple)
{
//捕⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -