?? orgservlet.java
字號:
package oa.servlet;
import java.io.*;
import java.text.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import oa.bean.*;
import oa.main.*;
public class OrgServlet extends HttpServlet
{
public void doGet(HttpServletRequest request ,HttpServletResponse response)throws IOException, ServletException
{
//創建實例
DepartmentBean dbean = null;
DutyBean dutybn = null;
PersonBean psbean = null;
PersonDutyBean psdbn = null;
dailyArragement dabean = null;
MakeNews mnbean = null;
OrgMenuBean omb = null;
int errcode = 0;
try{
dbean = new DepartmentBean();
DealString ds = new DealString();
dutybn = new DutyBean();
psbean = new PersonBean();
psdbn = new PersonDutyBean();
dabean = new dailyArragement();
mnbean = new MakeNews();
//取得菜單類別1.部門表2.職務表
String strType = ds.toString((String)request.getParameter("txt_type"));
//組織機構編號
String strOrgNO = ds.toString((String)request.getParameter("txt_orgno"));
//職務編號
String strDutyNO = ds.toString((String)request.getParameter("txt_dutyno"));
//增刪改類型1.增2.改3.刪
String strEdit = ds.toString((String)request.getParameter("txt_edit"));
//職工編號
String strPersonNO= ds.toString((String)request.getParameter("txt_personno"));
//第幾頁
String strPage = ds.toString((String)request.getParameter("txt_page"));
//刪除部門deptree1.jsp傳參數給servlet hidden傳
if(strType!=null && strType.equals("1") && strEdit.equals("3")){
dbean.setID(strOrgNO);
errcode = dbean.delRec();
response.sendRedirect("oa/organization/index.jsp?txt_type=1&errcode="+errcode);
}
//刪除職務duty1.jsp傳參數給servlet hidden傳
if(strType!=null && strType.equals("2") && strEdit.equals("3"))
{
dutybn.setOrgNO(strOrgNO);
dutybn.setDutyNO(strDutyNO);
errcode = dutybn.delDBDuty();
response.sendRedirect("oa/organization/index.jsp?txt_type=2&txt_orgno="+strOrgNO+"&errcode="+errcode);
}
//index.jsp控制從deptree1.jsp頁面跳到deptree—_edit.jsp增、改部門
//新增部門傳參數給servlet hidden傳
if(strType!=null && strType.equals("1") && strEdit.equals("1")){
String bmNo = strOrgNO;//上級部門編號hidden值
String bmName = ds.toGBK(request.getParameter("txt_bmname"));//新增時所需的部門名稱
String bossNo = ds.toGBK(request.getParameter("txt_bmboss")); //頭職務編號
// String admin = ds.toGBK(request.getParameter("txt_bmadmin")); //管理員
// String ws = ds.toGBK(request.getParameter("txt_bmmiss")); //文書
String jbNo = ds.toGBK(request.getParameter("txt_viewno"));//級別序號
//String ckqx = ds.toGBK(request.getParameter("txt_ckqx"));//出口權限
if(jbNo.equals("") || jbNo==null)
{
dbean.setID(bmNo);
jbNo = dbean.getJBNo();
}
Hashtable ht = new Hashtable();
ht.put("BMFBH",bmNo);
ht.put("BMMC",bmName);
ht.put("TZWBH",bossNo);
// ht.put("GLYZWBH",admin);
// ht.put("WSZWBH",ws);
ht.put("JBXH",jbNo);
//ht.put("CKQX",ckqx);
errcode = dbean.addRec(ht);
response.sendRedirect("oa/organization/index.jsp?txt_type=1&errcode="+errcode);
}
//修改部門傳參數給servlet hidden傳
if(strType.equals("1") && strEdit.equals("2")){
//修改部門時原來的上級部門編號
dbean.setID(strOrgNO);
if(strOrgNO.equals("00000000000000000000"))//修改總公司根節點
{
String rootbmname = ds.toGBK(request.getParameter("txt_bmname"));
//修改部門時原來的頭職務編號
String oldbossNo = dbean.getDutyNo();
String newbossname = ds.toGBK(request.getParameter("txt_bmboss"));
String newbossNo = "";
if(!newbossname.equals(""))
newbossNo = dbean.getBossDutyNo(newbossname);
//管理員和文書
String admin = ds.toGBK(request.getParameter("txt_bmadminbh"));
String ws = ds.toGBK(request.getParameter("txt_bmmissbh"));
String ckqx = ds.toGBK(request.getParameter("txt_ckqxbh"));//出口權限
Hashtable ht = new Hashtable();
ht.put("BMBH",strOrgNO);
ht.put("BMMC",rootbmname);
if(newbossNo.equals(oldbossNo)){
ht.put("TZWBH",oldbossNo);
}
if(!newbossNo.equals(oldbossNo)){
ht.put("TZWBH",newbossNo);
}
ht.put("JBXH","0");
ht.put("GLYZWBH",admin);
ht.put("WSZWBH",ws);
ht.put("CKQX",ckqx);
errcode = dbean.modRec(ht,"0");
}
else
{
String oldfuNo = dbean.getFatherNo();
//修改部門時重新選擇的上級部門值
String newfuName = ds.toGBK(request.getParameter("txt_lastbm"));
String newfuNo = ds.toGBK(request.getParameter("hid_bmno"));//hidden值
//String newfuNo = dbean.getBmNo(newfuName);
//被修改的部門的原編號hidden值
String bmNo = strOrgNO;
//修改后的部門的部門名稱
String bmName = ds.toGBK(request.getParameter("txt_bmname"));
//修改部門時原來的頭職務編號
String oldbossNo = dbean.getDutyNo();
//修改部門時重新選擇的頭職務編號值
String newbossName = ds.toGBK(request.getParameter("txt_bmboss"));
String newbossNo = "";
if(!newbossName.equals(""))
newbossNo = dbean.getBossDutyNo(newbossName);
//管理員和文書
String admin = ds.toGBK(request.getParameter("txt_bmadminbh"));
String ws = ds.toGBK(request.getParameter("txt_bmmissbh"));
String jbNo = ds.toGBK(request.getParameter("txt_viewno")); //級別序號
String ckqx = ds.toGBK(request.getParameter("txt_ckqxbh"));//出口權限
if(jbNo.equals("") || jbNo==null)
{
dbean.setID(bmNo);
jbNo = dbean.getJBNo();
}
Hashtable ht = new Hashtable();
//父部門沒變，修改紀錄
if(newfuNo.equals("") || newfuNo.equals(oldfuNo))
{
ht.put("BMBH",bmNo);
ht.put("BMMC",bmName);
if(newbossNo.equals(oldbossNo)){
ht.put("TZWBH",oldbossNo);
}
if(!newbossNo.equals(oldbossNo)){
ht.put("TZWBH",newbossNo);
}
ht.put("JBXH",jbNo);
ht.put("GLYZWBH",admin);
ht.put("WSZWBH",ws);
ht.put("CKQX",ckqx);
errcode = dbean.modRec(ht,"0");
}
//父部門變了，此條部門紀錄"掛起"，重新新增一條
if(!newfuNo.equals("") && !newfuNo.equals(oldfuNo))
{
ht.put("BMFBH",newfuNo);
ht.put("BMBH",bmNo);
ht.put("BMMC",bmName);
if(newbossNo.equals("") || newbossNo.equals(oldbossNo)){
ht.put("TZWBH",oldbossNo);
}
if(!newbossNo.equals("") && !newbossNo.equals(oldbossNo)){
ht.put("TZWBH",newbossNo);
}
ht.put("JBXH",jbNo);
ht.put("CKQX",ckqx);
if(dbean.modRec(ht,"1")==0)
errcode = dbean.addRec(ht);
}
}
response.sendRedirect("oa/organization/index.jsp?txt_type=1&errcode="+errcode);
}
//新增職務界面duty_edit.jsp傳參數給servlet hidden傳
if(strType!=null && strType.equals("2") && strEdit.equals("1")){
String bmNo = strOrgNO;//部門編號
String zwName = ds.toGBK(request.getParameter("txt_dutyname"));//新增時所需的職務名稱
String zwczRight = ds.toGBK(request.getParameter("txt_doright"));//職務操作權限
String zwlcRight = ds.toGBK(request.getParameter("txt_roadright")); //職務流程權限
String zwpzPara = ds.toGBK(request.getParameter("txt_confpara")); //職務配置參數
String jbNo = ds.toGBK(request.getParameter("txt_jbNo")); //級別序號
String sfjc = ds.toGBK(request.getParameter("txt_sfjc")); //是否繼承
if(zwczRight == null) zwczRight = "";
if(zwlcRight == null) zwlcRight = "";
if(zwpzPara == null) zwpzPara = "";
if(jbNo == null) jbNo = "";
if(sfjc.equals("不可繼承"))
sfjc = "1";
else
sfjc = "0";
//zwczRight = dutybn.toOperNo(zwczRight);
zwlcRight = dutybn.toFlowNo(zwlcRight);
//zwpzPara = dutybn.toConfNo(zwpzPara);
Hashtable ht = new Hashtable();
ht.put("BMBH",bmNo);
ht.put("ZWMC",zwName);
ht.put("CZQX",zwczRight);
ht.put("LCQX",zwlcRight);
//ht.put("PZCS",zwpzPara);
if(jbNo.equals("") || jbNo==null)
{
dutybn.setOrgNO(strOrgNO);
dutybn.setDutyNO(strDutyNO);
jbNo = dutybn.getJBNo();
}
ht.put("JBXH",jbNo);
ht.put("ZWZT","0");
ht.put("SFJC",sfjc);
errcode = dutybn.addDuty(ht);
response.sendRedirect("oa/organization/index.jsp?txt_type=2&txt_orgno="+strOrgNO+"&errcode="+errcode);
}
//修改職務界面duty_edit.jsp傳參數給servlet hidden傳
if(strType!=null && strType.equals("2") && strEdit.equals("2")){
dutybn.setOrgNO(strOrgNO);
dutybn.setDutyNO(strDutyNO);
String zwName = ds.toGBK(request.getParameter("txt_dutyname"));//新增時所需的職務名稱
String zwczRight = ds.toGBK(request.getParameter("txt_doright"));//職務操作權限
String zwlcRight = ds.toGBK(request.getParameter("txt_roadright")); //職務流程權限
String zwpzPara = ds.toGBK(request.getParameter("txt_confpara")); //職務配置參數
String jbNo = ds.toGBK(request.getParameter("txt_jbNo")); //級別序號
String zwStatus = ds.toGBK(request.getParameter("txt_zwStatus")); //職務狀態
String sfjc = ds.toGBK(request.getParameter("txt_sfjc")); //是否繼承
//zwczRight = dutybn.toOperNo(zwczRight);
zwlcRight = dutybn.toFlowNo(zwlcRight);
//zwpzPara = dutybn.toConfNo(zwpzPara);
if(zwStatus.equals("正常"))
zwStatus = "0";
if(zwStatus.equals("掛起"))
zwStatus = "1";
if(sfjc.equals("不可繼承"))
sfjc = "1";
else
sfjc = "0";
if(zwczRight == null) zwczRight = "";
if(zwlcRight == null) zwlcRight = "";
if(zwpzPara == null) zwpzPara = "";
if(jbNo == null) jbNo = "";
Hashtable ht = new Hashtable();
//ht.put("BMBH",bmNo);
ht.put("ZWMC",zwName);
ht.put("CZQX",zwczRight);
ht.put("LCQX",zwlcRight);
ht.put("PZCS",zwpzPara);
if(jbNo.equals("") || jbNo==null)
{
jbNo = dutybn.getJBNo();//dbean
}
ht.put("JBXH",jbNo);
ht.put("ZWZT",zwStatus);
ht.put("SFJC",sfjc);
errcode = dutybn.modDuty(ht);
response.sendRedirect("oa/organization/index.jsp?txt_type=2&txt_orgno="+strOrgNO+"&errcode="+errcode);
}
//...........................可添加其他頁面操作....................................//
//新增人員信息
if(strType!=null && strType.equals("3") && strEdit.equals("1") && strPage.equals("1"))
{
//psbean.setOrgNO(strOrgNO);
String bmNo = strOrgNO;
String zzZt = "0";
String zgNo = psbean.getMaxzgNo();
String zgName = ds.toGBK(request.getParameter("txt_xm"));
String zgGH = ds.toGBK(request.getParameter("txt_gh"));
String psWord = ds.toGBK(request.getParameter("password_check"));
String pswQuestion = ds.toGBK(request.getParameter("txt_mmwt"));
String pswKey = ds.toGBK(request.getParameter("txt_mmda"));
String Sex = ds.toGBK(request.getParameter("txt_xb"));
String birthDay = ds.toGBK(request.getParameter("txt_csny"));
String mz = ds.toGBK(request.getParameter("txt_mz"));
String zzmm = ds.toGBK(request.getParameter("txt_zzmm"));
String xli = ds.toGBK(request.getParameter("txt_xl"));
String zhich = ds.toGBK(request.getParameter("txt_zc"));
String bgphone = ds.toGBK(request.getParameter("txt_bgdh"));
String fjphone = ds.toGBK(request.getParameter("txt_fjdh"));
String jtphone = ds.toGBK(request.getParameter("txt_jtdh"));
String mobile = ds.toGBK(request.getParameter("txt_mobile"));
String address = ds.toGBK(request.getParameter("txt_address"));
String code = ds.toGBK(request.getParameter("txt_yzbm"));
String qqNo = ds.toGBK(request.getParameter("txt_qq"));
String email = ds.toGBK(request.getParameter("txt_email"));
String username = ds.toGBK(request.getParameter("txt_username")).toLowerCase();
String regdate = ds.toGBK(request.getParameter("txt_regdate"));
String grjj = ds.toGBK(request.getParameter("txt_grjj"));
String confPara = ds.toString(request.getParameter("txt_confpara"));
String znyh = ds.toString(request.getParameter("txt_znyh"));
if(confPara == null) confPara = "";
Hashtable ht = new Hashtable();
ht.put("BMBH",bmNo);
ht.put("ZGBH",zgNo);
ht.put("XM",zgName);
ht.put("GH",zgGH);
ht.put("PZCS",confPara);
ht.put("MMWT",pswQuestion);
ht.put("MMDA",pswKey);
ht.put("MM",psWord);
ht.put("XB",Sex);
ht.put("CSNY",birthDay);
ht.put("MZ",mz);
ht.put("ZZMM",zzmm);
ht.put("XL",xli);
ht.put("ZC",zhich);
ht.put("QQ",qqNo);
ht.put("BGDH",bgphone);
ht.put("FJDH",fjphone);
ht.put("YZBM",code);
ht.put("JTDZ",address);
ht.put("JTDH",jtphone);
ht.put("YDDH",mobile);
ht.put("EMAIL",email);
ht.put("ZZZT",zzZt);
ht.put("YHM",username);
ht.put("ZCRQ",regdate);
// ht.put("DJGL",);
// ht.put("FBWZ","0");
// ht.put("GLYH","1");
ht.put("GRJJ",grjj);
ht.put("ZNYH",znyh);
errcode = psbean.addPerson(ht);
/* //給新增人員分配職務
String bmNo = ds.toGBK(request.getParameter("hid_dutybmno"));
String zwname = ds.toGBK(request.getParameter("txt_dutyName"));
if(!bmNo.equals("") && !zwname.equals(""))
{
psdbn.setDutyOrgNo(bmNo);
String zwno = psdbn.getDutyNo(zwname);
psdbn.addRec(zgNo,bmNo,zwno);
}//返回到查看某部門人員列表的界面
*/
//給新增人員分配一般員工的職務
String zwNo = dutybn.getOrdinaryZWBH(bmNo,"一般員工");
if(zwNo.equals("")){
Hashtable dutyhash = new Hashtable();
dutyhash.put("BMBH",bmNo);
dutyhash.put("ZWMC","一般員工");
dutyhash.put("CZQX","");
dutyhash.put("LCQX","");
dutyhash.put("PZCS","");
dutyhash.put("JBXH","");
dutyhash.put("ZWZT","0");
dutybn.addDuty(dutyhash);
zwNo = dutybn.getOrdinaryZWBH(bmNo,"一般員工");
}
psdbn.addRec(zgNo,bmNo,zwNo,"","");//addRec(String personno,String dutyOrgno,String dutyno,String czqx,String lcqx)
response.sendRedirect("oa/organization/index.jsp?txt_type=3&txt_edit="+strEdit+"&txt_page=2&txt_personno="+zgNo+"&txt_orgno="+strOrgNO+"&errcode="+errcode);
}
//修改人員信息
if(strType!=null && strType.equals("3") && strEdit.equals("2"))
{
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -