exsheetserv.java

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

package net.intuitsoft.xeon.table.sale.ex;

import intuitsoft.eclipse.table.common.ConcreteListAdapter;
import intuitsoft.eclipse.table.common.DatabaseConnection;
import intuitsoft.eclipse.table.common.DateUtilities;
import intuitsoft.eclipse.table.common.FindTransaction;
import intuitsoft.eclipse.table.common.ListAdapter;
import intuitsoft.eclipse.table.common.MsgBean;
import intuitsoft.eclipse.table.common.MsgConstant;
import intuitsoft.eclipse.table.common.NumericUtilities;
import intuitsoft.eclipse.table.common.SheetGoods;
import intuitsoft.eclipse.table.common.SheetGoodsItems;
import intuitsoft.eclipse.table.common.SheetGoodsSheet;
import intuitsoft.eclipse.table.common.SheetLog;
import intuitsoft.eclipse.table.common.SheetTypes;
import intuitsoft.eclipse.table.common.StatusBean;
import intuitsoft.eclipse.table.common.ToolKit;
import intuitsoft.eclipse.table.common.WriteLog;
import intuitsoft.eclipse.table.system.acquisitiondata.ItemsTemp;
import intuitsoft.eclipse.table.system.perm.Perm;
import intuitsoft.eclipse.table.system.user.ConcreteSysUserAdapter;
import intuitsoft.eclipse.table.system.user.LoginInfo;
import intuitsoft.eclipse.table.system.user.SysUserAdapter;

import java.io.IOException;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.LinkedHashMap;
import java.util.LinkedList;
import java.util.List;
import java.util.Map;
import java.util.StringTokenizer;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import javax.transaction.UserTransaction;

import net.intuitsoft.xeon.table.basic.customer.CCustGoodsAdapter;
import net.intuitsoft.xeon.table.basic.customer.CCustomerAdapter;
import net.intuitsoft.xeon.table.basic.customer.CustBar;
import net.intuitsoft.xeon.table.basic.customer.CustGoodsAdapter;
import net.intuitsoft.xeon.table.basic.customer.CustomerAdapter;
import net.intuitsoft.xeon.table.basic.customer.CustomerBean;
import net.intuitsoft.xeon.table.basic.goods.CGoodsAdapter;
import net.intuitsoft.xeon.table.basic.goods.GoodsAdapter;
import net.intuitsoft.xeon.table.basic.goods.GoodsBean;
import net.intuitsoft.xeon.table.basic.goods.GoodsModel;
import net.intuitsoft.xeon.table.basic.settlement.CSettModeAdapter;
import net.intuitsoft.xeon.table.basic.settlement.SettModeAdapter;
import net.intuitsoft.xeon.table.common.ItemActionBean;
import net.intuitsoft.xeon.table.decision.auditing.Auditing;
import net.intuitsoft.xeon.table.fin.rec.RecSheet;
import net.intuitsoft.xeon.table.fin.settle.customer.CustMonthItems;
import net.intuitsoft.xeon.table.msg.setup.MsgInfoSetup;
import net.intuitsoft.xeon.table.sale.EventCode;
import net.intuitsoft.xeon.table.sale.spec.CMarketSpecItemsAdapter;
import net.intuitsoft.xeon.table.sale.spec.MarketSpecItemsAdapter;
import net.intuitsoft.xeon.table.warehouse.balance.CBalanceAdapter;

/**
 * <p>
 * Title: 零售连锁管理系统
 * </p>
 * <p>
 * Description: 零售业最佳应用
 * </p>
 * <p>
 * Copyright: Copyright (c) 1999 - 2004
 * </p>
 * <p>
 * Company: 直觉软件科技
 * </p>
 * 
 * @author: KENT
 * @version 1.0 Since 2004-03-22 04-10
 */

public class ExSheetServ extends HttpServlet {
	UserTransaction trans = null;

	private Map perms = null;

	private static Map logins = null;

	public void init() throws ServletException {
		logins = new LinkedHashMap();

	}

	public synchronized void service(HttpServletRequest req,
			HttpServletResponse resp) throws ServletException, IOException {
		CExSheetAdapter exSheetAdapter = null;
		ExItemsAdapter skMaterialOrder2 = null;
		List list = null;
		StatusBean statusBean = null;

		statusBean = new StatusBean();

		HttpSession session = req.getSession();
		LoginInfo loginInfo = (LoginInfo) session.getAttribute("LoginInfo");
		// Test use

		if (loginInfo == null) {
			loginInfo = new LoginInfo();
		}

		try {
			if (logins.get(loginInfo.getJndiName()) == null) {
				logins.put(loginInfo.getJndiName(), new Boolean(true));
			} else {

				int i = 0;
				while (((Boolean) logins.get(loginInfo.getJndiName()))
						.booleanValue()) {
					if (i > DatabaseConnection.times) {
						error(0, MsgConstant.HAS_USE, req, resp);
						return;
					}
					i++;
					try {
						Thread.sleep(DatabaseConnection.time);
					} catch (Exception ex) {
						ex.printStackTrace();
					}
				}
				logins.put(loginInfo.getJndiName(), new Boolean(true));
			}

			try {
				FindTransaction find = new FindTransaction(loginInfo
						.getJndiName());
				trans = find.getTransaction();
			} catch (Exception ex) {
				ex.printStackTrace();
			}

			perms = loginInfo.getPerms();
			// 赋值

			exSheetAdapter = new CExSheetAdapter(loginInfo.getJndiName());
			skMaterialOrder2 = new CExItemsAdapter(loginInfo.getJndiName());
			exSheetAdapter.setExSheetCode(req.getParameter("exSheetCode"));
			exSheetAdapter.setCustID(req.getParameter("custID"));
			exSheetAdapter.setEmplID(req.getParameter("emplID"));
			exSheetAdapter.setDepID(req.getParameter("depID"));
			exSheetAdapter.setWarehouseCode(req.getParameter("warehouseCode"));

			exSheetAdapter.setBrandID(req.getParameter("brandID"));

			exSheetAdapter.setRemark(ToolKit.toCN(req.getParameter("remark")));

			exSheetAdapter.setQua(req.getParameter("qua"));
			exSheetAdapter.setAmo(req.getParameter("amo"));
			exSheetAdapter.setAuditingName(ToolKit.toCN(req
					.getParameter("auditingName")));
			exSheetAdapter
					.setFinName(ToolKit.toCN(req.getParameter("finName")));

			exSheetAdapter.setMarketName(ToolKit.toCN(req
					.getParameter("marketName")));

			exSheetAdapter
					.setRegName(ToolKit.toCN(req.getParameter("regName")));
			exSheetAdapter.setCreateDate(req.getParameter("createDate"));

			exSheetAdapter.setType(req.getParameter("type"));
			exSheetAdapter.setOrderID(req.getParameter("orderID"));
			exSheetAdapter.setIsFill(req.getParameter("isFill"));
			exSheetAdapter.setOperator(req.getParameter("operator"));
			exSheetAdapter.setComputer(req.getParameter("computer"));
			exSheetAdapter.setIsReg(req.getParameter("isReg"));
			exSheetAdapter.setIsRegLed(req.getParameter("isRegLed"));
			exSheetAdapter.setIsAcc(req.getParameter("isAcc"));
			exSheetAdapter.setIsBack(req.getParameter("isBack"));
			exSheetAdapter.setIsExt(req.getParameter("isExt"));
			exSheetAdapter.setIsVou(req.getParameter("isVou"));
			exSheetAdapter.setRealAmo(req.getParameter("realAmo"));

			exSheetAdapter.setCRate(req.getParameter("cRate"));
			exSheetAdapter.setDiscount(req.getParameter("discount"));
			exSheetAdapter.setCostAmo(req.getParameter("costAmo"));
			exSheetAdapter.setPayAmo(req.getParameter("payAmo"));

			exSheetAdapter.setSettleID(req.getParameter("settleID"));
			exSheetAdapter.setOrderID(req.getParameter("orderID"));
			exSheetAdapter.setBackRemark(ToolKit.toCN(req
					.getParameter("backRemark")));
			exSheetAdapter.setCheckRemark(ToolKit.toCN(req
					.getParameter("checkRemark")));

			exSheetAdapter.setNoteSheetCode(req.getParameter("noteSheetCode"));
			exSheetAdapter.setNotifySheetCode(req
					.getParameter("notifySheetCode"));
			exSheetAdapter.setOrderMySheetCode(req
					.getParameter("orderMySheetCode"));

			exSheetAdapter
					.setSheetPriceType(req.getParameter("sheetPriceType"));
			exSheetAdapter.setSheetOrderType(ToolKit.toCN(req
					.getParameter("sheetOrderType")));

			// 产品明细 item
			ItemActionBean exItemsActionBean = new ItemActionBean(loginInfo
					.getJndiName(),
					"net.intuitsoft.xeon.table.sale.ex.CExItemsAdapter");
			exItemsActionBean.setEventCode(EventCode.EX_ITEMS_NEW);
			ArrayList exItemsActionBeans = exItemsActionBean.getItems(req,
					resp, true);

			ArrayList exItemsBeans = (ArrayList) exItemsActionBeans.get(0);
			ArrayList exItemsStates = (ArrayList) exItemsActionBeans.get(1);

			String itemAction = req.getParameter("CExItemsAdapterItemAction");
			String itemIndex = req.getParameter("CExItemsAdapterItemIndex");
			String brandPerm = intuitsoft.eclipse.table.system.perm.Perm
					.brandPerm(loginInfo.getJndiName(), loginInfo
							.getSysRoleCode());
			if (!"".equals(brandPerm))
				brandPerm = " and a.brandID in " + brandPerm;
			if (("CExItemsAdapterITEMFIND").equals(itemAction)) {

				ExItemsAdapter adapter = (ExItemsAdapter) exItemsBeans
						.get(Integer.parseInt(itemIndex));
				adapter = impart(adapter, Integer.parseInt(itemIndex),
						statusBean, exSheetAdapter, brandPerm);
				exItemsBeans.set(Integer.parseInt(itemIndex), adapter);
				if ("O".equals((String) exItemsStates.get(Integer
						.parseInt(itemIndex)))) {
					exItemsStates.set(Integer.parseInt(itemIndex), "M");
				}
				statusBean.setEventCode(EventCode.EX_ITEMS_NEW); //
			} else if (("CExItemsAdapterITEMADD").equals(itemAction)) {
				System.out.println("itemAction:" + itemAction);
				int index = exItemsBeans.size() - 1;
				ExItemsAdapter adapter = (ExItemsAdapter) exItemsBeans
						.get(index);
				adapter.setWarehouseCode(exSheetAdapter.getWarehouseCode());
				exItemsBeans.set(index, adapter);
			} else {
			}

			Auditing audAdapter = new Auditing(loginInfo.getJndiName());
			audAdapter.setDocPrefix(req.getParameter("docPrefix2"));
			audAdapter.setSheetCode(req.getParameter("sheetCode2"));
			audAdapter.setEmplID(req.getParameter("emplID2"));
			audAdapter.setOperator(req.getParameter("operator2"));
			audAdapter.setCreateDate1(req.getParameter("createDate1"));
			audAdapter.setCreateDate3(req.getParameter("createDate3"));
			audAdapter.setIsAcc(req.getParameter("isAcc2"));
			req.setAttribute("AuditingAdapter", audAdapter);

			// 条件适配器
			ExSheetAdapter adapter2 = new CExSheetAdapter(loginInfo
					.getJndiName());
			adapter2.setExSheetCode(req.getParameter("exSheetCode2"));

			adapter2.setEmplID(req.getParameter("emplID2"));

			adapter2.setCustID(req.getParameter("custID2"));

			adapter2.setWarehouseCode(req.getParameter("warehouseCode2"));
			adapter2.setBrandID(req.getParameter("brandID2"));
			adapter2.setOperator(req.getParameter("operator2"));
			adapter2.setRemark(ToolKit.toCN(req.getParameter("remark2")));

			adapter2.setCreateDate1(req.getParameter("createDate1"));
			adapter2.setCreateDate3(req.getParameter("createDate3"));

			adapter2.setIsRegLed(req.getParameter("isRegLed2"));
			adapter2.setIsReg(req.getParameter("isReg2"));
			adapter2.setIsFin(req.getParameter("isFin2"));
			adapter2.setIsAcc(req.getParameter("isAcc2"));
			adapter2.setIsExtAcc(req.getParameter("isExtAcc2"));
			adapter2.setIsEnd(req.getParameter("isEnd2"));

			adapter2.setStat(req.getParameter("stat"));
			adapter2.setBrandID(req.getParameter("brandID2"));
			adapter2.setClassID(req.getParameter("classID2"));
			adapter2.setCode(ToolKit.toCN(req.getParameter("code2")));
			adapter2.setRegionID(req.getParameter("regionID2"));
			adapter2.setBackRemark(ToolKit
					.toCN(req.getParameter("backRemark2")));
			adapter2.setCheckRemark(ToolKit.toCN(req
					.getParameter("checkRemark2")));
			adapter2.setNoteSheetCode(req.getParameter("noteSheetCode2"));
			adapter2.setNotifySheetCode(req.getParameter("notifySheetCode2"));
			adapter2.setOrderMySheetCode(req.getParameter("orderMySheetCode2"));
			adapter2.setSheetPriceType(req.getParameter("sheetPriceType2"));
			adapter2.setSheetOrderType(ToolKit.toCN(req
					.getParameter("sheetOrderType2")));
			adapter2.setDiscount1(req.getParameter("discount1"));
			adapter2.setDiscount3(req.getParameter("discount3"));

			String goodsID = req.getParameter("goodsIDs");

			String sqlCond = ToolKit.toCN(req.getParameter("sqlCond"));

			String eventCodeStr = req.getParameter("eventCode");

			if (!NumericUtilities.isInteger(eventCodeStr)) {

				error(0, MsgConstant.NO_ASSIGN_EVENTCODE, req, resp);
				return;
			}
			int eventCode = Integer.parseInt(eventCodeStr);
			String custVRecMsg = "";
			boolean b = true;
			Object[] a = null;
			ConcreteSysUserAdapter sys = null;
			ExSheetAdapter orderModel = null;
			String settleID = req.getParameter("settleID");
			String catalogCode = req.getParameter("catalogCode");
			String compID = req.getParameter("compID");
			String factAmo = req.getParameter("factAmo");
			String msAmo = req.getParameter("msAmo");
			if ("".equals(factAmo)) {
				factAmo = "0";
			}
			if ("".equals(msAmo)) {
				msAmo = "0";
			}
			exSheetAdapter.setIsRec(req.getParameter("isRec"));
			exSheetAdapter.setRecAmo(factAmo);
			exSheetAdapter.setMsAmo(msAmo);
			switch (eventCode) {

			case EventCode.EX_SHEET_FORM_OTHERS:
				b = true;

				try {
					trans.begin();
				} catch (Exception ex) {
					ex.printStackTrace();
					System.out.print("Cannot create transaction");
				}
				StringTokenizer goodsIDsConvert = null;
				String goodsIDListConvert = null;
				goodsIDsConvert = new StringTokenizer(goodsID, ",");
				goodsIDListConvert = "";
				while (goodsIDsConvert.hasMoreElements()) {
					GoodsModel goodsConvert = new GoodsBean(loginInfo
							.getJndiName());
					goodsConvert.setGoodsID(goodsIDsConvert.nextElement()
							.toString());
					if (goodsConvert.content()) {
						goodsIDListConvert = goodsIDListConvert
								+ goodsConvert.getGoodsID() + ",";
					}
				}
				if (!goodsIDListConvert.equals("")) {
					goodsIDListConvert = goodsIDListConvert.substring(0,
							goodsIDListConvert.length() - 1);
				} else {
					goodsIDListConvert = "0";