object expected 错误 大家帮忙看看代码吧 我快倒下了 不知道怎么调试了
jsp新手做维护 数据库更新后这个页面出了bug 总是object expected错误 根据提示到行上缺发现毛都没有 也不知道哪个对象出错了 大家帮忙看看吧 100分送上了
<%@ page language="java" contentType="text/html;charset=big5"%>
<%@ include file="jsphead.inc"%>
<%@ page import="java.util.Calendar" %>
<%@ page import="com.ti.ffw.Libs.EMail.*" %>
<%!
private String getDefine() {
return "Style None;";
}
public int event(java.lang.String stylename, int step, ScriptLine line, PageCenter center) {
return 1 ;
}
%>
<%
String optionStr="";
boolean canddsame=false;
employee emp = (employee)session.getAttribute("Login_Employee");
int power = emp.getPower();
int level=0;
if(power<employee.CC_MANAGER||power==employee.POWER_USER1)
level=0;
else if(power==employee.CC_MANAGER)
level=1;
else if(power==employee.DEPT_MANAGER)
level= 2;
else if(power==employee.CNB_MANAGER)
level= 3;
else if(power==employee.HR_DIR)
level= 4;
else if(power==employee.SITE_MANAGER)
level= 5;
else if(power==employee.HR||power==employee.POWER_USER2)
level=9;
String saveResultStr = "",sql = "";
Connection con = getCon();
DataTable LEAVE_CODE_table = new DataTable();
LEAVE_CODE_table.load(con,"select CODE,DESP,UNIT from LEAVE_TYPE order by CODE");
DataTable Bonus_Item_table = new DataTable();
Bonus_Item_table.load(con,"select ITEM_ID,ITEM_VALUE,ITEM_DESC FROM NoCash_Item order by ITEM_ID");
String Q_PersonInfo = request.getParameter("Q_PersonInfo");
if(Q_PersonInfo==null) Q_PersonInfo = "";
//輸入員工工號完畢則查詢員工的資料
if(!Q_PersonInfo.equals("")){
Hashtable ht = new Hashtable();
String empno ="";
if(Q_PersonInfo.equals("1")){
empno = request.getParameter("EMP_NO");
ht.put("name_in_chinese","EMP_NAME");
ht.put("name_in_english","EMP_NAME_EN");
ht.put("dir_indir","DIR_INDIR");
ht.put("dept_code","DEPT_CODE");
ht.put("cost_center","COST_CENTER");
ht.put("cc","CC");
ht.put("country","COUNTRY");
ht.put("area_code","AREA_CODE");
}else if(Q_PersonInfo.equals("2")){
String index=request.getParameter("Q_PersonInfo_Index");
empno = request.getParameter("EMP_NO_"+index);
ht.put("name_in_chinese","NAME_"+index);
ht.put("name_in_english","EMP_NAME_EN_"+index);
ht.put("dept_code","DEPT_CODE_"+index);
ht.put("desp_chi","DEPT_NAME_"+index);
ht.put("cost_center","COST_CENTER_"+index);
ht.put("cc","CC_NAME_"+index);
ht.put("area_code","AREA_CODE_"+index);
}
Init_Ht.remove("RECORD_TABLE_INNERHTML");
Init_Ht.remove("Q_PERSONINFO");
QueryPersonInfo(con,empno,ht,Init_Ht);
}
//保存到資料庫
if(Q_PersonInfo.equals("")&&request.getParameter("REQ_DATE")!=null){
if(request.getParameter("CONFIRM_FLAG")!=null&&request.getParameter("CONFIRM_FLAG").equals("1")){
int MAX_Record_Count = Integer.parseInt(request.getParameter("MAX_Record_Count"));
String[] s=new String[2];
String empno="";
errorStr err = new errorStr();
for(int i=1;i<=MAX_Record_Count;i++){
empno = request.getParameter("EMP_NO_"+i);
if(empno!=null&&!empno.trim().equals("")){
saveResultStr += "<p align='center'>";
if(!isEmpExistNew(con,empno,emp,request.getParameter("REQ_DATE")))
saveResultStr += "Fail to save record EmpNO:"+empno+",Reason: emp no "+empno+" is not exist!<br>新增MERIT BONUS記錄 員工工號:"+empno+"失敗,失敗原因: 員工工號"+empno+"不存在!";
else {
String status="1";
String grade=""+level;
if(power==employee.HR_DIR&&request.getParameter("SITE_MGR_"+i)==null){
grade="Y";
status="2";
}
else if(power==employee.SITE_MANAGER) {
grade="Y";
status="2";
}
//else if(power==employee.HR||power==employee.POWER_USER1||power==employee.POWER_USER2){
// grade="Y";
// status="2";
//}
else if(power==employee.CC_MANAGER){
String ssql="select t.dept_mgr from dept t where code ="
+ "(select t.dept_code from personnel_basic t where t.no='"+empno+"')";
DataTable dt11=new DataTable();
dt11.load(con,ssql);
String deptMgrNo=dt11.outB(0,"dept_mgr");
if(deptMgrNo.equals(emp.getInfo("no"))) {
canddsame=true;
grade="2";
}
}
System.out.println("country="+request.getParameter("COUNTRY_"+i));
sql = "insert into MERIT_BONUS_APP(EMP_NO,COUNTRY,REQ_DATE,REQ_AMT,REQ_SUBJECT,APVA_STATUS,CURRENT_GRADE,REQUESTER,CASH_FLAG,REQ_REASON,DEPT_CODE,REMARK";
if(power==employee.HR_DIR&&request.getParameter("SITE_MGR_"+i)!=null) sql=sql+" ,APVA_MGR";
if(grade.equals("Y")) sql=sql+",APPR_DATE";
sql= sql+") values('"+request.getParameter("EMP_NO_"+i)+"','"+request.getParameter("COUNTRY_"+i)+"',to_date('"+request.getParameter("REQ_DATE")+"','MM-DD-YYYY'),"+
"'"+request.getParameter("REQ_AMOUNT_"+i)+"',"+"'"+request.getParameter("REQ_SUBJECT")+"',"+"'"+status+"','"+grade+"','"+
emp.getInfo("no")/*request.getParameter("EMP_NO")*/+"','"+request.getParameter("CASH_"+i)+"','"+request.getParameter("REQ_REASON")+"','"+
request.getParameter("DEPT_CODE_"+i)+"','"+request.getParameter("Bonus_Item_ID_"+i)+"'";
if(power==employee.HR_DIR&&request.getParameter("SITE_MGR_"+i)!=null) sql=sql+",'"+request.getParameter("SITE_MGR_"+i)+"'";
if(grade.equals("Y")) sql=sql+",to_date('"+request.getParameter("REQ_DATE")+"','MM-DD-YYYY')";
sql=sql+")";
if(UTIL.execUpdate(con,sql,err)<0){
if(err.m_errorStr.indexOf("ORA-00001")>-1)
saveResultStr += "新增MERIT BONUS記錄申請失敗 員工工號:"+empno+",申請日期:"+request.getParameter("REQ_DATE")+" 已有資料.";
else
saveResultStr += "Fail to save record EmpNO:"+empno+",Reason:"+err.m_errorStr+"<br>新增MERIT BONUS記錄申請 員工工號:"+empno+"失敗,失敗原因:"+err.m_errorStr+"!";
}
else
saveResultStr += "Success to save record EmpNO:"+empno+"!<br>新增MERIT BONUS記錄申請 員工工號:"+empno+"成功!";
/*
String emailSQL ="select t.email from personnel_basic t where t.no in "
+"("
+ "select distinct t.supr_mgr from line_shift t where cc_code ="
+ "("
+"select t.cost_center from personnel_basic t where t.no='"+empno+"'"
+ ")"
+")";
*/
String cc="select t.email from personnel_basic t where t.no in "
+"("
+ "select distinct t.cc_mgr from cost_center t where code ="
+ "("
+"select t.cost_center from personnel_basic t where t.no='"+empno+"'"
+ ")"
+")";