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"))
			{