actionent_record_transfering.java.svn-base

公司CRM部分原代码,采用的是java技术.

					// EnENT_CUSTOMER_PERSONAL
					EnENT_CUSTOMER_PERSONAL cEnENT_CUSTOMER_PERSONAL = (EnENT_CUSTOMER_PERSONAL) DAOBase
							.findByPK(new DbAccess(),
									EnENT_CUSTOMER_PERSONAL.class.getName(),
									index);
					// 获得原先收藏者的工号和姓名
					int iEnterpriseId = Integer.parseInt(index);
					String chEnterpriseName = cEnENT_CUSTOMER_PERSONAL
							.getChName();
					String chFromUserId = cEnENT_CUSTOMER_PERSONAL
							.getChCommit_Code();
					String chFromUserName = cEnENT_CUSTOMER_PERSONAL
							.getChCommit_Name();
					String chTransferUserId = userInfor.getId();
					String chTransferUserName = userInfor.getName();
					String dtTransferTime = timestamp;

					// 设置目前收藏者的工号和姓名,公共平台采用特殊字符串代替
					// cEnEnt_Official_Enterprise.setChCollectUserId(chToUserId);
					// cEnEnt_Official_Enterprise.setChCollectUserName(chToUserName);
					// cEnEnt_Official_Enterprise.setDtCollectTime(timestamp);

					//EnEnt_Record_Transfering cEnEnt_Record_Transfering = new EnEnt_Record_Transfering();
					cEnEnt_Record_Transfering.setIEnterpriseId(iEnterpriseId);
					cEnEnt_Record_Transfering
							.setChEnterpriseName(chEnterpriseName);
					cEnEnt_Record_Transfering.setChFromUserId(chFromUserId);
					cEnEnt_Record_Transfering.setChFromUserName(chFromUserName);
					cEnEnt_Record_Transfering.setChToUserId(chToUserId);
					cEnEnt_Record_Transfering.setChToUserName(chToUserName);
					cEnEnt_Record_Transfering
							.setChTransferUserId(chTransferUserId);
					cEnEnt_Record_Transfering
							.setChTransferUserName(chTransferUserName);		

					if (!cEnENT_CUSTOMER_PERSONAL.getDtBirthday().equals("")) {

						String year = cEnENT_CUSTOMER_PERSONAL.getDtBirthday()
								.substring(0, 4);
						String month = cEnENT_CUSTOMER_PERSONAL.getDtBirthday()
								.substring(5, 7);
						String day = cEnENT_CUSTOMER_PERSONAL.getDtBirthday()
								.substring(8, 10);
						cEnENT_CUSTOMER_PERSONAL.setDtBirthday(year + month
								+ day);

					}
					cEnENT_CUSTOMER_PERSONAL.setChCommit_Code(chToUserId);
					cEnENT_CUSTOMER_PERSONAL.setChCommit_Name(chToUserName);// 更新企业负责人
															// 还要更新联系人负责人
					try {
						db.beginTransaction();// 用触发
					DAOBase.update(db, cEnENT_CUSTOMER_PERSONAL);

					DAOBase.insert(new DbAccess(), cEnEnt_Record_Transfering);
					db.commit();
					}catch(Exception e) {
						db.rollback();
					}
				}
			}
			
		} catch (Exception ex) {
			
			throw ex;
		}
		levin.iMessage msg = levin.iMessage.getNewInstance("客户变更", "客户已变更.",
				//"closeWindow()");
				"openTop(\"GDPE.customer.EnterpriseTransfering.ActionEnt_Record_Transfering.do?doType=summary\");");
		msg.save(request);
		return this.getTargetPage("Message");

	}

	public String modifyQuery(HttpServletRequest request,
			HttpServletResponse response) throws Exception {
		String id = request.getParameter("id");
		EnEnt_Record_Transfering cEnEnt_Record_Transfering = (EnEnt_Record_Transfering) DAOBase
				.findByPK(new DbAccess(), EnEnt_Record_Transfering.class
						.getName(), id);
		request.setAttribute("cEnEnt_Record_Transfering",
				cEnEnt_Record_Transfering);
		request.setAttribute("doType", "modify");
		return this.getTargetPage("detail");
	}

	public String modify(HttpServletRequest request,
			HttpServletResponse response) throws Exception {
		EnEnt_Record_Transfering cEnEnt_Record_Transfering = (EnEnt_Record_Transfering) request
				.getAttribute("cEnEnt_Record_Transfering");
		DbAccess db = new DbAccess();
		try {
			db.beginTransaction();
			DAOBase.update(db, cEnEnt_Record_Transfering);
			db.commit();
		} catch (Exception ex) {
			db.rollback();
			throw ex;
		}
		levin.iMessage msg = levin.iMessage
				.getNewInstance(
						"客户变更",
						"修改成功.",
						"openTop(\"GDPE.customer.EnterpriseTransfering.ActionEnt_Record_Transfering.do?doType=summary\");");
		msg.save(request);
		return this.getTargetPage("Message");
	}

	public String view(HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		String id = request.getParameter("id");
		EnEnt_Record_Transfering cEnEnt_Record_Transfering = (EnEnt_Record_Transfering) DAOBase
				.findByPK(new DbAccess(), EnEnt_Record_Transfering.class
						.getName(), id);
		request.setAttribute("cEnEnt_Record_Transfering",
				cEnEnt_Record_Transfering);
		request.setAttribute("doType", "view");
		return this.getTargetPage("detail");
	}

	public String delete(HttpServletRequest request,
			HttpServletResponse response) throws Exception {
		String id = request.getParameter("id");
		DbAccess db = new DbAccess();
		try {
			db.beginTransaction();
			StringTokenizer st = new StringTokenizer(id, ",");
			while (st.hasMoreElements()) {
				String index = (String) st.nextElement();
				DAOBase.delete(db, EnEnt_Record_Transfering.class.getName(),
						index);
			}
			db.commit();
		} catch (Exception ex) {
			db.rollback();
			throw ex;
		}
		levin.iMessage msg = levin.iMessage.getNewInstance("客户变更", "删除成功.",
				"closeWindow()");
		// "删除成功.","openTop(\"GDPE.customer.EnterpriseTransfering.ActionEnt_Record_Transfering.do?doType=summary\");");
		msg.save(request);
		return this.getTargetPage("Message");
	}

	public String search(HttpServletRequest request,
			HttpServletResponse response) throws Exception {
		String chEnterpriseName = request.getParameter("chEnterpriseName");
		String chFromUserName = request.getParameter("chFromUserName");
		String chToUserName = request.getParameter("chToUserName");
		String chTransferUserName = request.getParameter("chTransferUserName");
		String dtTransferTime1 = request.getParameter("dtTransferTime1");
		String dtTransferTime2 = request.getParameter("dtTransferTime2");

		StringBuffer sb = new StringBuffer();
		if (chEnterpriseName != null && !chEnterpriseName.equals("")) {
			sb.append("chEnterpriseName like '%" + chEnterpriseName + "%' and");
		}
		if (chFromUserName != null && !chFromUserName.equals("")) {
			sb.append(" chFromUserName like '%" + chFromUserName + "%' and");
		}
		if (chToUserName != null && !chToUserName.equals("")) {
			sb.append(" chToUserName like '%" + chToUserName + "%' and");
		}
		if (chTransferUserName != null && !chTransferUserName.equals("")) {
			sb.append(" chTransferUserName like '%" + chTransferUserName
					+ "%' and");
		}

		if (dtTransferTime1 != null && !dtTransferTime1.equals("")) {
			sb.append(" dtTransferTime >= '" + dtTransferTime1 + "' and");
		}
		if (dtTransferTime2 != null && !dtTransferTime2.equals("")) {
			sb.append(" dtTransferTime <= '" + dtTransferTime2 + "' and");
		}

		String where = sb.substring(0, sb.length() - 3);
		String order = "dtTransferTime desc";
		EnEnt_Record_Transfering[] aEnEnt_Record_Transfering = (EnEnt_Record_Transfering[]) (DAOBase
				.findByCondition(new DbAccess(), EnEnt_Record_Transfering.class
						.getName(), where, order));
		for (int i = 0; i < aEnEnt_Record_Transfering.length; i++) {
			if (!aEnEnt_Record_Transfering[i].getDtTransferTime().equals(""))
				aEnEnt_Record_Transfering[i]
						.setDtTransferTime(aEnEnt_Record_Transfering[i]
								.getDtTransferTime().substring(0, 10));
		}

		request.setAttribute("aEnEnt_Record_Transfering",
				aEnEnt_Record_Transfering);
		request.setAttribute("doType", "summary");
		request.setAttribute("chooseType", "checkbox");
		return this.getTargetPage("summary");
	}

}