exsheetserv.java

我的系在线考试系统我的系在线考试系统我的系在线考试系统我的系在线考试系统我的系在线考试系统我的系在线考试系统我的系在线考试系统我的系在线考试系统

					}

				}
				initialProductNo(exItemsBeans, exSheetAdapter);
				break;

			case EventCode.EX_SHEET_NEW:
				exItemsBeans.clear();
				exItemsStates.clear();
				CExSheetAdapter model = new CExSheetAdapter(loginInfo
						.getJndiName());
				model.setExSheetCode(exSheetAdapter.newExSheetCode());
				model.setCreateDate(DateUtilities.getCurDate("yyyy-MM-dd"));
				model.setOperator(loginInfo.getSysUserCode());
				// 区分不同用户
				sys = new ConcreteSysUserAdapter(loginInfo.getJndiName());
				model
						.setComputer(sys
								.getCreateBy(loginInfo.getSysUserCode())[2]);

				model.insert();
				exSheetAdapter = model;
				new SheetLog(loginInfo.getJndiName(), exSheetAdapter
						.getExSheetCode(), "新建", sys.getCreateBy(loginInfo
						.getSysUserCode())[0], Integer.parseInt(sys
						.getCreateBy(loginInfo.getSysUserCode())[2]), "");
				break;
			case EventCode.EX_SHEET_CONTENT:
			case EventCode.EX_SHEET_MODIFY:
				exItemsBeans.clear();
				exItemsStates.clear();
				exSheetAdapter.content();

				list = skMaterialOrder2.getItemsByExSheetCode(exSheetAdapter
						.getExSheetCode());
				for (int i = 0; i < list.size(); i++) {
					ExItemsAdapter skMaterialOrder = (ExItemsAdapter) list
							.get(i);
					exItemsBeans.add(i, skMaterialOrder);
					exItemsStates.add("O");
				}

				break;

			case EventCode.EX_SHEET_CUSTOMER_SELECT:
				CustomerBean tempCust = new CustomerBean(loginInfo
						.getJndiName());
				tempCust.setCustID(exSheetAdapter.getCustID());
				tempCust.content();
				if (tempCust.getPriceType() == 1) {
					exSheetAdapter.setDiscount(tempCust.getDiscount());
				} else {
					exSheetAdapter.setDiscount(1);
				}
				for (int i = 0; i < exItemsBeans.size(); i++) {
					ExItemsAdapter order = (ExItemsAdapter) exItemsBeans.get(i);
					spec(order, exSheetAdapter);
				}
				initialProductNo(exItemsBeans, exSheetAdapter);
				break;
			case EventCode.EX_SHEET_NEW_S:
			case EventCode.EX_SHEET_MODIFY_S:

				if (!ToolKit.allowOperator(loginInfo.getJndiName(),
						exSheetAdapter.getCreateDate())) {
					error(0, "单据日期在结存期限内，不允许在结存期限内进行操作！", req, resp);
					return;
				}
				orderModel = new CExSheetAdapter(loginInfo.getJndiName());
				orderModel.setExSheetCode(exSheetAdapter.getExSheetCode());
				if (orderModel.content()) {
					String canSave = Operation.canSave(orderModel, loginInfo
							.getSysUserCode(), perms, exSheetAdapter);
					if (canSave != null) {
						this.error(0, canSave, req, resp);
						return;
					}

				} else {
					this.error(0, MsgConstant.NO_CONTENT, req, resp);
					return;
				}
				b = true;

				try {
					trans.begin();
				} catch (Exception ex) {
					ex.printStackTrace();
					System.out.print("Cannot create transaction");
				}
				custVRecMsg = "";
				custVRecMsg = ToolKit.getCustVRecErrorMsg(loginInfo
						.getJndiName(), exSheetAdapter.getCustID());
				// 保存报价表头
				// 区分不同用户
				sys = new ConcreteSysUserAdapter(loginInfo.getJndiName());
				exSheetAdapter.setOperator(loginInfo.getSysUserCode());
				exSheetAdapter.setComputer(sys.getCreateBy(loginInfo
						.getSysUserCode())[2]);
				if (eventCode == EventCode.EX_SHEET_MODIFY_S) {
					exSheetAdapter.setUserName(0);
					exSheetAdapter.setIsVou(true);
				}
				exSheetAdapter.setUserName(req.getParameter("userName"));
				b = b && exSheetAdapter.modify();
				list = new LinkedList();
				a = Operation.saveitem(exSheetAdapter, exItemsBeans,
						exItemsStates);
				b = b && ((Boolean) a[0]).booleanValue();
				list = (List) a[1];
				new SheetLog(loginInfo.getJndiName(), exSheetAdapter
						.getExSheetCode(), "修改", sys.getCreateBy(loginInfo
						.getSysUserCode())[0], Integer.parseInt(sys
						.getCreateBy(loginInfo.getSysUserCode())[2]), "");
				try {
					if (b) {
						trans.commit();
						new WriteLog(loginInfo.getJndiName(), 2,
								EventCode.EX_SHEET_MODIFY_S, loginInfo
										.getName(), req.getRemoteAddr(),
								"增加：销售单：" + exSheetAdapter.getExSheetCode()
										+ " ：Y", getClass().getName()
										+ ":EX_SHEET_MODIFY_S", true, loginInfo
										.getSysUserCode());

					} else {
						trans.rollback();
						new WriteLog(loginInfo.getJndiName(), 3,
								EventCode.EX_SHEET_MODIFY_S, loginInfo
										.getName(), req.getRemoteAddr(),
								"增加：销售单：" + exSheetAdapter.getExSheetCode()
										+ " ：N", getClass().getName()
										+ ":EX_SHEET_MODIFY_S", true, loginInfo
										.getSysUserCode());

						// already.");
						error(0, MsgConstant.DAO_ERROR, req, resp);
						return;

					}
				} catch (Exception ex) {
					ex.printStackTrace();
				}

				break;
			case EventCode.EX_SHEET_CANCEL:
				if (exSheetAdapter.content()) {
					String canCancel = Operation.canCancel(exSheetAdapter,
							loginInfo.getSysUserCode(), perms);
					if (canCancel != null) {
						exSheetAdapter.setCheckRemark("");

						this.error(0, canCancel, req, resp);
						return;
					}
					// 新增2007-10-12
					ItemsTemp itemsTemp = new ItemsTemp(loginInfo.getJndiName());
					b = b
							&& itemsTemp.deleteBySheetCode(exSheetAdapter
									.getExSheetCode());
					//

					exSheetAdapter.setUserName(String.valueOf(loginInfo
							.getSysUserCode()));

					exSheetAdapter.setIsVou(false);
					exSheetAdapter.setIsAcc(false);
					exSheetAdapter.setIsChecked(true);
					exSheetAdapter.setCheckRemark(ToolKit.toCN(req
							.getParameter("checkRemark")));
					exSheetAdapter.modify2();

					intuitsoft.eclipse.table.system.checkedremark.CheckedRemark checkRemark = new intuitsoft.eclipse.table.system.checkedremark.CheckedRemark(
							loginInfo.getJndiName());
					b = b
							&& checkRemark.delBySheetCode(exSheetAdapter
									.getExSheetCode());
					checkRemark.setSheetCode(exSheetAdapter.getExSheetCode());
					checkRemark
							.setSheetType(intuitsoft.eclipse.table.common.SheetTypes.CN_EX);
					checkRemark
							.setDomainType(intuitsoft.eclipse.table.common.DomainTypes.CN_Sale);
					checkRemark
							.setUrl("/sale/accesscontrolservice?eventCode=203&exSheetCode="
									+ exSheetAdapter.getExSheetCode());
					checkRemark.setRemark(ToolKit.toCN(req
							.getParameter("checkRemark")));
					checkRemark.setCreateDate(exSheetAdapter.getCreateDate());

					checkRemark.setOperator(loginInfo.getSysUserCode());
					ConcreteSysUserAdapter sysC = new ConcreteSysUserAdapter(
							loginInfo.getJndiName());
					checkRemark.setComputer(sysC.getCreateBy(loginInfo
							.getSysUserCode())[2]);

					b = b && checkRemark.insert();

					sys = new ConcreteSysUserAdapter(loginInfo.getJndiName());
					new SheetLog(loginInfo.getJndiName(), exSheetAdapter
							.getExSheetCode(), "作废", sys.getCreateBy(loginInfo
							.getSysUserCode())[0], Integer.parseInt(sys
							.getCreateBy(loginInfo.getSysUserCode())[2]), "");
					new WriteLog(loginInfo.getJndiName(), 2,
							EventCode.EX_SHEET_CANCEL, loginInfo.getName(), req
									.getRemoteAddr(), "作废：销售单："
									+ exSheetAdapter.getExSheetCode() + " ：Y",
							getClass().getName() + ":EX_SHEET_CANCEL", true,
							loginInfo.getSysUserCode());

				}
				break;

			case EventCode.EX_SHEET_NEW_V2:
				exSheetAdapter.content();
			case EventCode.EX_SHEET_NEW_V:
			case EventCode.EX_SHEET_NEW_V_REC:

				// 月结存判断
				if (!ToolKit.allowOperator(loginInfo.getJndiName(),
						exSheetAdapter.getCreateDate())) {
					error(0, "单据日期在结存期限内，不允许在结存期限内进行操作！", req, resp);
					return;
				}
				if (eventCode == EventCode.EX_SHEET_NEW_V_REC) {
					RecSheet recSheet = new RecSheet(loginInfo.getJndiName());
					recSheet.setRecSheetCode(recSheet.newRecSheetCode());
					if (!recSheet.isFirst(recSheet.getRecSheetCode(), false,
							exSheetAdapter.getCustID())) {
						// this.error(0, "存在未记账收款单,必须先记账此收款单据！", req, resp);
						// return;
					}

				}

				orderModel = new CExSheetAdapter(loginInfo.getJndiName());
				orderModel.setExSheetCode(exSheetAdapter.getExSheetCode());
				if (orderModel.content()) {
					String canAud = Operation.canAud(orderModel, loginInfo
							.getSysUserCode(), perms, eventCode, exItemsBeans,
							exSheetAdapter.getWarehouseCode(), exSheetAdapter);
					if (canAud != null) {
						this.error(0, canAud, req, resp);
						return;
					}

				} else {
					this.error(0, MsgConstant.NO_CONTENT, req, resp);
					return;
				}

				b = true;
				try {
					trans.begin();
				} catch (Exception ex) {
					ex.printStackTrace();
					// transaction");
				}
				if (orderModel.getIsRegLed()) {
					exSheetAdapter.content();
				}
				custVRecMsg = "";
				custVRecMsg = ToolKit.getCustVRecErrorMsg(loginInfo
						.getJndiName(), exSheetAdapter.getCustID());

				// 保存报价表头
				// 区分不同用户
				sys = new ConcreteSysUserAdapter(loginInfo.getJndiName());
				CustomerAdapter custa = new CCustomerAdapter(loginInfo
						.getJndiName());
				double shortAmo = custa.getShortAmo(exSheetAdapter.getCustID());
				exSheetAdapter.setPreAmo(shortAmo);

				if (eventCode == EventCode.EX_SHEET_NEW_V_REC) {
					SettModeAdapter settle = new CSettModeAdapter(loginInfo
							.getJndiName());
					settle.setSettleID(settleID);
					settle.content();
					exSheetAdapter.setUserTel(settle.getSettMode());
				} else {
					exSheetAdapter.setUserTel("欠款");
				}
				exSheetAdapter.setIsRec(req.getParameter("isRec"));
				exSheetAdapter.setRecAmo(factAmo);
				exSheetAdapter.setMsAmo(msAmo);

				exSheetAdapter.setUserName(loginInfo.getSysUserCode());
				b = b && createExSheetAdapter(exSheetAdapter).modify2();

				if (!orderModel.getIsRegLed()) {
					list = new LinkedList();

					if (eventCode == EventCode.EX_SHEET_NEW_V2
							&& list.size() == 0) {
						list = skMaterialOrder2
								.getItemsByExSheetCode(exSheetAdapter
										.getExSheetCode());
					} else {

						a = Operation.saveitem(exSheetAdapter, exItemsBeans,
								exItemsStates);
						b = b && ((Boolean) a[0]).booleanValue();
						list = (List) a[1];

					}

					b = b
							&& Operation.auding(exSheetAdapter, list,
									loginInfo, eventCode, settleID,
									catalogCode, compID, factAmo, msAmo);
				} else {
					if (!orderModel.getIsAcc()
							&& eventCode != EventCode.EX_SHEET_NEW_V2) {
						exSheetAdapter.setAmo(req.getParameter("amo"));
						b = b
								&& ToolKit.newV(loginInfo.getJndiName(),
										SheetTypes.ExSheet, exItemsBeans,
										exSheetAdapter.getExSheetCode(),
										exSheetAdapter);
					}
				}

				if (!orderModel.getIsAcc()) {
					// ******************************************************************************************************************************************************************************************
					exSheetAdapter.content();
					CustMonthItems custMonthItems = new CustMonthItems(
							loginInfo.getJndiName());
					b = b
							&& custMonthItems.modify(
									exSheetAdapter.getCustID(), exSheetAdapter
											.getCreateDate(), exSheetAdapter
											.getAmo(), exSheetAdapter.getQua(),
									CustMonthItems.NORMAL);
					// ******************************************************************************************************************************************************************************************
				}
				if (eventCode == EventCode.EX_SHEET_NEW_V_REC) {
					b = b
							&& Operation.rec(exSheetAdapter, loginInfo,
									settleID, catalogCode, compID, factAmo,
									msAmo);
				}

				new SheetLog(loginInfo.getJndiName(), exSheetAdapter
						.getExSheetCode(), "记账", sys.getCreateBy(loginInfo
						.getSysUserCode())[0], Integer.parseInt(sys
						.getCreateBy(loginInfo.getSysUserCode())[2]), "");
				msgInfoSetup = new MsgInfoSetup(loginInfo.getJndiName());
				msgInfoSetup.doMsg(SheetTypes.ExSheet, exSheetAdapter
						.getExSheetCode(), EventCode.EX_SHEET_OUT_BALANCE_V,
						MsgInfoSetup.Del, "", loginInfo);
				try {
					if (b) {
						trans.commit();
						new WriteLog(loginInfo.getJndiName(), 2,
								EventCode.EX_SHEET_NEW_V, loginInfo.getName(),
								req.getRemoteAddr(), "记账：销售单："
										+ exSheetAdapter.getExSheetCode()
										+ " ：Y", getClass().getName()