printservice.java

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

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

import intuitsoft.eclipse.table.common.ConcreteListAdapter;
import intuitsoft.eclipse.table.common.ListAdapter;
import intuitsoft.eclipse.table.common.MsgBean;
import intuitsoft.eclipse.table.common.MsgConstant;
import intuitsoft.eclipse.table.common.ToolKit;
import intuitsoft.eclipse.table.system.print.PrintSet;
import intuitsoft.eclipse.table.system.print.PrintSetTop;
import intuitsoft.eclipse.table.system.user.LoginInfo;

import java.io.File;
import java.io.IOException;
import java.util.LinkedList;
import java.util.List;

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 net.intuitsoft.xeon.table.basic.brand.BrandBean;
import net.intuitsoft.xeon.table.basic.brand.BrandModel;
import net.intuitsoft.xeon.table.basic.customer.CCustomerAdapter;
import net.intuitsoft.xeon.table.basic.employee.EmplBean;
import net.intuitsoft.xeon.table.basic.employee.EmplModel;
import net.intuitsoft.xeon.table.basic.settlement.SettModeBean;
import net.intuitsoft.xeon.table.basic.warehouse.WarehouseBean;
import net.intuitsoft.xeon.table.basic.warehouse.WarehouseModel;
import net.intuitsoft.xeon.table.preview.PrintCond;
import net.intuitsoft.xeon.table.preview.PrintParam;
import net.intuitsoft.xeon.table.preview.ReportExcelListTemplet;
import net.intuitsoft.xeon.table.preview.ReportListTemplet;
import net.intuitsoft.xeon.table.preview.ReportPrint;
import net.intuitsoft.xeon.table.preview.ReportPrintParam;
import net.intuitsoft.xeon.table.preview.SheetParse;
import net.intuitsoft.xeon.table.preview.SheetTemplet;
import net.intuitsoft.xeon.table.sale.EventCode;

/**
 * <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-8
 */

public class PrintService extends HttpServlet {

	public synchronized void service(HttpServletRequest req,
			HttpServletResponse resp) throws ServletException, IOException {
		HttpSession session = req.getSession();
		LoginInfo loginInfo = (LoginInfo) session.getAttribute("LoginInfo");
		if (loginInfo == null) {
			loginInfo = new LoginInfo();
		}// 条件适配器
		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.setCreateDate1(req.getParameter("createDate1"));
		adapter2.setCreateDate3(req.getParameter("createDate3"));
		adapter2.setStat(req.getParameter("stat"));

		int eventCode = 0;

		try {
			eventCode = Integer.parseInt(req.getParameter("eventCode"));
		} catch (Exception ex) {
			ex.printStackTrace();
		}

		ListAdapter listAdapter = new ConcreteListAdapter(loginInfo
				.getJndiName());
		listAdapter.setOrder(req.getParameter("order"));
		listAdapter.setSort(req.getParameter("sort"));
		listAdapter.setPage(req.getParameter("page"));
		listAdapter.setPageSize(req.getParameter("pageSize"));
		listAdapter.setSqlCond(ToolKit.toCN(req.getParameter("sqlCond")));
		listAdapter.setSql(ToolKit.toCN(req.getParameter("sql")));
		switch (eventCode) {
		case EventCode.EX_SHEET_PREVIEW_ZX:

			try {

				ExSheetAdapter exSheetModel = new CExSheetAdapter(loginInfo
						.getJndiName());

				exSheetModel.setExSheetCode(req.getParameter("exSheetCode"));
				if (exSheetModel.content()) {
					if (!exSheetModel.getIsRegLed()) {
						error(0, "销售单还没出库不能打印", req, resp);
						return;
					}
					WarehouseModel wm = new WarehouseBean(loginInfo
							.getJndiName());
					wm.setWarehouseCode(exSheetModel.getWarehouseCode());
					wm.content();

					EmplModel empl = new EmplBean(loginInfo.getJndiName());
					empl.setEmplID(exSheetModel.getEmplID());
					empl.content();
					CCustomerAdapter cust = new CCustomerAdapter(loginInfo
							.getJndiName());
					cust.setCustID(exSheetModel.getCustID());
					cust.content();
					BrandModel bm = new BrandBean(loginInfo.getJndiName());
					bm.setID(exSheetModel.getBrandID());
					bm.content();

					SettModeBean settle = new SettModeBean(loginInfo
							.getJndiName());
					settle.setSettleID(exSheetModel.getSettleID());
					settle.content();

					exSheetModel.setLinkman(cust.getLinkman());
					exSheetModel.setTel(cust.getTel());
					exSheetModel.setAddress(cust.getAddress());
					exSheetModel.setSettMode(settle.getSettMode());
					exSheetModel.setWarehouseName(wm.getName());
					exSheetModel.setEmplName(empl.getName());
					exSheetModel.setCustName(cust.getCustName());
					exSheetModel.setCustNo(cust.getCustNo());
					exSheetModel.setBrandName(bm.getBrandName());
					exSheetModel.setShortAmo(cust.getShortAmo(exSheetModel
							.getCustID()));
					exSheetModel.setPrevShortAmo(exSheetModel.getShortAmo()
							- exSheetModel.getAmo());

					PrintSet printSet = new PrintSet(loginInfo.getJndiName());
					printSet.setPrintSetCode(req.getParameter("printSetCode"));
					printSet.content();

					PrintParam printParam = new PrintParam(loginInfo
							.getJndiName(), printSet.getPrintSetCode());
					printParam
							.setTitle(ToolKit.toCN(req.getParameter("title")));
					printParam.setIsDetail(req.getParameter("isDetail"));
					printParam.setOrient(req.getParameter("r"));
					PrintSetTop printSetTop = new PrintSetTop(loginInfo
							.getJndiName());
					List list = printSetTop
							.getItems(printSet.getPrintSetCode());
					String[] cells = null;
					List c = new LinkedList();

					for (int i = 0; i < list.size(); i++) {
						printSetTop = (PrintSetTop) list.get(i);
						if (printSetTop.getIsDispCol()) {
							c.add(printSetTop.getDispColName());
						}
					}
					cells = (String[]) c.toArray(new String[] {});

					SheetParse sheetParse = new SheetParse(loginInfo
							.getJndiName(), exSheetModel, cells, printSet
							.getPrintSetCode());
					sheetParse.setHasItems(true);
					sheetParse.setHasSize(false);

					// 参数初始化
					printParam.initial(ToolKit
							.toCN(req.getParameter("columns")));

					String part = printParam.getColumnsToSql();
					String sql = "select "
							+ part
							+ ",b.ID from exSheet a,exItems b,goods c where  a.isRegLed=1 and  c.goodsID=b.goodsID and b.exSheetCode=a.exSheetCode  and  a.exSheetCode='"
							+ exSheetModel.getExSheetCode() + "'"
							+ ToolKit.getOrderSort(loginInfo.getJndiName());
					printParam.setSql(sql);
					new SheetTemplet(printParam, sheetParse, exSheetModel,
							resp, req);

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

			} catch (Exception e) {
				e.printStackTrace();
			}
			break;
		case EventCode.EX_SHEET_PREVIEW:

			try {

				ExSheetAdapter exSheetModel = new CExSheetAdapter(loginInfo
						.getJndiName());

				exSheetModel.setExSheetCode(req.getParameter("exSheetCode"));
				if (exSheetModel.content()) {
					if (!exSheetModel.getIsRegLed()) {
						error(0, "销售单还没出库不能打印", req, resp);
						return;
					}
					WarehouseModel wm = new WarehouseBean(loginInfo
							.getJndiName());
					wm.setWarehouseCode(exSheetModel.getWarehouseCode());
					wm.content();

					EmplModel empl = new EmplBean(loginInfo.getJndiName());
					empl.setEmplID(exSheetModel.getEmplID());
					empl.content();
					CCustomerAdapter cust = new CCustomerAdapter(loginInfo
							.getJndiName());
					cust.setCustID(exSheetModel.getCustID());
					cust.content();
					BrandModel bm = new BrandBean(loginInfo.getJndiName());
					bm.setID(exSheetModel.getBrandID());
					bm.content();

					SettModeBean settle = new SettModeBean(loginInfo
							.getJndiName());
					settle.setSettleID(exSheetModel.getSettleID());
					settle.content();

					exSheetModel.setLinkman(cust.getLinkman());
					exSheetModel.setTel(cust.getTel());
					exSheetModel.setAddress(cust.getAddress());
					exSheetModel.setSettMode(settle.getSettMode());
					exSheetModel.setWarehouseName(wm.getName());
					exSheetModel.setEmplName(empl.getName());
					exSheetModel.setCustName(cust.getCustName());
					exSheetModel.setCustNo(cust.getCustNo());
					exSheetModel.setBrandName(bm.getBrandName());
					exSheetModel.setShortAmo(cust.getShortAmo(exSheetModel
							.getCustID()));
					exSheetModel.setPrevShortAmo(exSheetModel.getShortAmo()
							- exSheetModel.getAmo());

					try {
						File testFile = new File(
								"C:\\bea\\ext\\mingfeng\\ExSheet.jrxml");
						if (testFile.exists()) {

							ExItemsAdapter orderItemAdapter = new CExItemsAdapter(
									loginInfo.getJndiName());

							List list2 = orderItemAdapter
									.getItemsByExSheetCode(exSheetModel
											.getExSheetCode());