configaction.java

基于Sturts+Spring+Hibernate的一个高级销售管理系统。内容丰富

		int objectId = value1.getFieldList().getConfigTree().getParentId();
		logger.debug("所属模块实体ID＝" + objectId);
		String tableName = configTreeMgr.getById(objectId).getTableName();
		logger.debug("要修改的实体表 " + tableName);
		logger.debug("这个字段名所属模块实体表 " + tableName + " 字段为 " + fieldName
				+ " 值为 '" + deleteValue + "' 都将被修改为 '" + value1.getListValue()
				+ "'");
		// 更新对应实表内容
		configTreeMgr.updateTable(tableName, fieldName, deleteValue, value1
				.getListValue());
		logger.debug("删除成功了");

		// 修改选项值表
		delevalue.setListValue(value1.getListValue());
		delevalue.setFlag(2);// 把被删除的值设为无效值
		delevalue.setInterrelater(value1.getInterrelater());// 修改对应的相关值
		valueListMgr.update(delevalue);
		// valueListMgr.update(value1);

		List valueList = valueListMgr.getByField(value1.getFieldList());

		request.setAttribute("fields", value1.getFieldList());
		request.setAttribute("valueList", valueList);
		return mapping.findForward("editField");
	}

	public ActionForward newValueList(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws ApplicationException {

		User user = SessionMgr.getCustSession(request);

		String fieldId = request.getParameter("id");// 字段ID
		String isMoreValue = request.getParameter("isMoreValue");// 是否有多值
		String values = request.getParameter("values");// 新建选项值
		String[] value = values.split("\n");// 新建的选项值以回车符隔开

		for (int i = 0; i < value.length; i++) {
			ValueList valueList = new ValueList();
			logger.debug("新建选项值value=" + value[i]);

			if (!isMoreValue.equals("1")) {
				valueList.setListValue(value[i].trim());
				valueList.setFieldList(fieldListMgr.getById(Integer
						.parseInt(fieldId)));
				valueList.setOperation(12);// 设置操作类型 1编辑2删除3替换
				valueList.setCreateTime(new Date());
				valueList.setLastModifyTime(new Date());
				valueList
						.setOrderNO(valueListMgr
								.getByField(
										fieldListMgr.getById(Integer
												.parseInt(fieldId))).size() + 1);// 设置排序序列号
				logger.debug("orderNO===" + valueList.getOrderNO());
				valueList.setCreater(user);
				valueList.setLastModifier(user);
				logger.debug("creater=" + user.getUserName());
				valueListMgr.save(valueList);
			} else {
				valueList.setListValue(values);
				valueList.setFieldList(fieldListMgr.getById(Integer
						.parseInt(fieldId)));
				valueList.setOperation(12);// 设置操作类型 1编辑2删除3替换
				valueList.setCreateTime(new Date());
				valueList.setLastModifyTime(new Date());
				// 设置排序
				valueList
						.setOrderNO(valueListMgr
								.getByField(
										fieldListMgr.getById(Integer
												.parseInt(fieldId))).size() + 1);
				logger.debug("orderNO===" + valueList.getOrderNO());
				valueList.setListValueState(request
						.getParameter("listValueState"));
				valueList.setCreater(user);
				valueList.setLastModifier(user);
				logger.debug("creater=" + user.getUserName());

				// 新建的相关值并与之字段对应
				Interrelater interrelater = new Interrelater();
				interrelater.setInterrelaterValue(request
						.getParameter("interrelaterValue"));
				// interrelater.setFieldList(fieldListMgr.getById(Integer.parseInt(fieldId)));
				interrelater.setFieldList(fieldListMgr.getById(55));// 相关值对应字段ID(可能性)
				interrelater.setValues(valueList);

				interrelaterMgr.save(interrelater);
			}
		}

		request.setAttribute("fields", fieldListMgr.getById(Integer
				.parseInt(fieldId)));
		request.setAttribute("valueList", valueListMgr.getByField(fieldListMgr
				.getById(Integer.parseInt(fieldId))));
		// return gotoEditField(mapping,form,request,response);
		return mapping.findForward("editField");
	}

	// 获得选项列表值进行排序
	public ActionForward getListValue(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws ApplicationException {

		String forward = "orderValueList";
		String id = request.getParameter("id");// 字段ID
		FieldList fieldList = fieldListMgr.getById(Integer.parseInt(id));

		request.setAttribute("fields", fieldList);

		List valueList = valueListMgr.getByField(fieldList);
		request.setAttribute("valueList", valueList);
		return mapping.findForward(forward);
	}

	// 排序
	public ActionForward orderValueList(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws ApplicationException {
		String items = request.getParameter("items");
		String[] item = items.split(" ");

		String ids = request.getParameter("ids");// 排序后对应的ID组
		String[] valueListId = ids.split(" ");// 每个选项值ID

		logger.debug("" + valueListId.length + "  ===== " + item.length);
		for (int i = 0; i < valueListId.length; i++) {
			ValueList values1 = valueListMgr.getById(Integer
					.parseInt(valueListId[i]));
			values1.setOrderNO(i + 1);
			valueListMgr.update(values1);
		}
		return view(mapping, form, request, response);
	}

	// 封装所需选项值，进入选项值替换
	public ActionForward replaceValue(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws ApplicationException {

		String id = request.getParameter("id");// 字段ID

		FieldList fields = fieldListMgr.getById(Integer.parseInt(id));
		List valueList = valueListMgr.getByField(fields);

		request.setAttribute("valueList", valueList);
		request.setAttribute("fields", fields);
		return mapping.findForward("replaceValue");
	}

	public ActionForward replace(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws ApplicationException {

		String id = request.getParameter("id");// 字段ID
		String replaceValue = request.getParameter("replaceValue");// 将被替换的值
		String value = request.getParameter("value");// 替换的目标值
		FieldList fields = fieldListMgr.getById(Integer.parseInt(id));

		String fieldName = fields.getFieldName();

		List fieldList = fieldListMgr.getByConfigTree(fields.getConfigTree());

		// 判断该字段是否为标准字段
		if (fields.getIsStandardField() != 2) {// 2为不是标准字段

			int parentId = fields.getConfigTree().getParentId();

			if (fields.getIsMoreValue() == 1) {
				ValueList FormerlyValueList = valueListMgr
						.getByListValue(replaceValue);
				if (FormerlyValueList == null) {
					request.setAttribute("fieldList", fieldList);
					request.setAttribute("configTree", configTreeMgr
							.getById(fields.getConfigTree().getParentId()));
					request.setAttribute("message", "已有0条数据 " + replaceValue
							+ " 被替换为 " + value + " !");
					return mapping.findForward("fieldList");
				}
				String FormerlyInterrelaterValue = FormerlyValueList
						.getInterrelater().getInterrelaterValue();
				ValueList valueList = valueListMgr.getByListValue(value);
				String InterrelaterValue = valueList.getInterrelater()
						.getInterrelaterValue();
				String InterrelaterTableName = configTreeMgr.getById(parentId)
						.getTableName();
				logger.debug("可能性"
						+ valueList.getInterrelater().getFieldList()
								.getFieldName());
				configTreeMgr.updateTable(InterrelaterTableName, valueList
						.getInterrelater().getFieldList().getFieldName(),
						FormerlyInterrelaterValue, InterrelaterValue);
				logger.debug("有没有到这里了!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!1");
			}

			String tableName = configTreeMgr.getById(parentId).getTableName();
			logger.debug("被修改的表格tableName==" + tableName);
			int i = configTreeMgr.lockUpTableDate(tableName, fieldName,
					replaceValue);

			if (i != 0) {
				logger.debug("这个字段名所属模块实体表 " + tableName + " 字段为 " + fieldName
						+ " 值为 '" + replaceValue + "' 都将被替换为 '" + value + "'");
				configTreeMgr.updateTable(tableName, fieldName, replaceValue,
						value);
				logger.debug("数据库替换成功");
			}

			request.setAttribute("fieldList", fieldList);
			request.setAttribute("configTree", configTreeMgr.getById(fields
					.getConfigTree().getParentId()));
			request.setAttribute("message", "已有" + i + "条数据 " + replaceValue
					+ " 被替换为 " + value + " !");
		} else {
			ValueList valueList = valueListMgr.getByListValue(replaceValue);
			if (valueList != null) {
				valueList.setListValue(value);
				valueListMgr.update(valueList);
			}

			request.setAttribute("fieldList", fieldListMgr
					.getByConfigTree(fields.getConfigTree()));
			request.setAttribute("configTree", configTreeMgr.getById(fields
					.getConfigTree().getParentId()));
			request.setAttribute("message", "数据 " + replaceValue + " 被替换为 "
					+ value + " !");
		}
		return mapping.findForward("fieldList");
	}

	// newField新建字段
	public ActionForward newField(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws ApplicationException {
		String id = request.getParameter("id");// 实例模块ID
		String dataType = request.getParameter("dataType");
		String fieldLable = request.getParameter("fieldLable");
		String fieldName = request.getParameter("fieldName");
		String remark = request.getParameter("remark");
		String helpText = request.getParameter("helpText");
		String values = request.getParameter("values");

		logger.debug(values);
		logger.debug("开始增加…………………………");
		User user = SessionMgr.getCustSession(request);
		ConfigTree configTree = configTreeMgr.getById(Integer.parseInt(id));
		FieldList fieldList = new FieldList();
		fieldList.setConfigTree(configTree);
		fieldList.setDataType(dataType);
		fieldList.setFieldLable(fieldLable);
		fieldList.setFieldName(fieldName);
		fieldList.setRemark(remark);
		fieldList.setHelpText(helpText);
		fieldList.setCreater(user);
		fieldList.setCreateTime(new Date());
		fieldList.setIsStandardField(2);// 注释此字段为自定义字段

		fieldList.setIsMoreValue(2);// 设置该字段没有多值
		fieldList.setLastModifier(user);
		fieldList.setLastModifyTime(new Date());
		logger.debug("第二阶段安全");
		if ("1".equals(dataType)) {
			fieldList.setOperation(123);// 自定义字段类型为选项列表可以进行编辑删除替换
			fieldListMgr.save(fieldList);
			logger.debug("这个最关键");
			String[] value = values.split("\n");
			for (int i = 0; i < value.length; i++) {
				ValueList valueList = new ValueList();
				valueList.setCreater(user);
				valueList.setCreateTime(new Date());
				valueList.setLastModifier(user);
				valueList.setLastModifyTime(new Date());

				valueList.setFieldList(fieldList);
				valueList.setListValue(value[i].trim());
				valueList.setOrderNO(i + 1);// 新建字段所以排序1开始
				valueList.setOperation(12);// 自定义列表值可以进行编辑删除替换
				valueListMgr.save(valueList);
			}
		} else {
			fieldList.setOperation(12);// 自定义字段类型不是选项列表可以进行编辑删除
			logger.debug("类型不是选项列表");
			fieldListMgr.save(fieldList);
		}
		return getField(mapping, form, request, response);
	}

	// 接口类
	public ActionForward getCustomerField(ActionMapping mapping,
			ActionForm form, HttpServletRequest request,
			HttpServletResponse response) throws ApplicationException {

		List bizType = valueListMgr.getByField(fieldListMgr.getBizType());
		List industryType = valueListMgr.getByField(fieldListMgr
				.getIndustryType());
		List employee_Num = valueListMgr.getByField(fieldListMgr
				.getEmployee_Num());
		List regionOf = valueListMgr.getByField(fieldListMgr.getRegionOf());
		List province = valueListMgr.getByField(fieldListMgr.getProvince());
		List city = valueListMgr.getByField(fieldListMgr.getCity());
		List county = valueListMgr.getByField(fieldListMgr.getCounty());
		List manger_Level = valueListMgr.getByField(fieldListMgr
				.getManager_Level());
		List customerState = valueListMgr.getByField(fieldListMgr
				.getCustomerState());
		List honestGrade = valueListMgr.getByField(fieldListMgr
				.getHonestGrade());
		List cuscomerSource = valueListMgr.getByField(fieldListMgr
				.getCustomerSource());
		request.setAttribute("bizType", bizType);
		request.setAttribute("industryType", industryType);
		request.setAttribute("employee_Num", employee_Num);
		request.setAttribute("regionOf", regionOf);
		request.setAttribute("province", province);
		request.setAttribute("city", city);
		request.setAttribute("county", county);
		request.setAttribute("manger_Level", manger_Level);
		request.setAttribute("customerState", customerState);
		request.setAttribute("honestGrade", honestGrade);
		request.setAttribute("cuscomerSource", cuscomerSource);
		return mapping.findForward("newCustomer");
	}

	public ActionForward getContactField(ActionMapping mapping,
			ActionForm form, HttpServletRequest request,
			HttpServletResponse response) throws ApplicationException {

		List satulation = valueListMgr.getByField(fieldListMgr.getSatulation());
		List education = valueListMgr.getByField(fieldListMgr.getEducation());
		request.setAttribute("satulation", satulation);
		request.setAttribute("education", education);
		return mapping.findForward("newContact");
	}

	public ActionForward getBusiOpportField(ActionMapping mapping,
			ActionForm form, HttpServletRequest request,
			HttpServletResponse response) throws ApplicationException {

		List stageOf = valueListMgr.getByField(fieldListMgr.getStageOf());
		request.setAttribute("stageOf", stageOf);
		return mapping.findForward("busiOpport");
	}

	// dwr
	public String getInterrelaterValue(String idStr, HttpServletRequest request) {
		int id = Integer.parseInt(idStr);
		if (id == 0) {
			return "0.0";
		}
		Interrelater interrelater = interrelaterMgr.getByValue(valueListMgr
				.getById(id));
		String interralaterValue = interrelater.getInterrelaterValue();
		return interralaterValue;
	}
}