printservice.java

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

							new ReportPrint(exSheetModel, list2, "", resp, req);

						} else {

							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 tempPart = part;
							tempPart = ToolKit.replace(part, "b.qua",
									"sum(b.qua) as qua");
							tempPart = ToolKit.replace(tempPart, "b.amo",
									"sum(b.amo) as amo");
							tempPart = tempPart + ",sum(b.ID) as ID ";
							String sql = "select "
									+ (exSheetModel.isHasCH(exSheetModel
											.getExSheetCode()) ? tempPart
											: part)
									+ " from exSheet a,exItems b,(select case b.brandName when '' then b.goodsID when null then b.goodsID else isNull((select top 1 goodsID from goods where gdsNo=b.brandName),b.goodsID) end as goodsID,b.ID as itemsID from exItems b ) t,goods c where  a.isRegLed=1 and b.exSheetCode=a.exSheetCode and t.itemsID=b.ID and c.goodsID=t.goodsID and a.exSheetCode='"
									+ exSheetModel.getExSheetCode()
									+ "'"
									+ (exSheetModel.isHasCH(exSheetModel
											.getExSheetCode()) ? " group by c.gdsNo,c.gdsName,c.unit,c.gdsStandard,c.salePrice,b.productNo,b.warehouseCode,b.price,b.discount,b.sheetSaleAmo,b.remark "
											: "")
									+ ToolKit.getOrderSort(loginInfo
											.getJndiName());
							printParam.setSql(sql);
							System.out.println("sql:" + sql);
							new SheetTemplet(printParam, sheetParse,
									exSheetModel, resp, req);
						}
					} catch (Exception ex) {
						ex.printStackTrace();

					}

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

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

			break;

		case EventCode.EX_SHEET_REPORT_PREVIEW:

			ReportPrintParam printParam = null;
			PrintCond printCond = null;
			String order = null;

			switch (adapter2.getStat()) {
			case 0:

				try {
					printParam = new ReportPrintParam(loginInfo.getJndiName(),
							intuitsoft.eclipse.table.common.DocPrefix.EX_SHEET);
					printCond = new PrintCond();
					printParam.setPrintMode(req.getParameter("print"));
					printParam.setOrient(req.getParameter("r"));
					printParam.setIsDetail(req.getParameter("isDetail"));
					printParam.setPageRows(req.getParameter("pageRows"));
					printCond.setCreateDate1(adapter2.getCreateDate1());
					printCond.setCreateDate3(adapter2.getCreateDate3());
					printParam.setTotallist(req.getParameter("totals"));
					printParam.initial(ToolKit
							.toCN(req.getParameter("columns")));
					order = printParam
							.getOrderColumns(req.getParameter("oldColumns"),
									listAdapter.getOrder());
					if (order == null) {
						order = "1";
					}

					String part = printParam.getColumnsToSql()
							.replace('`', ',');
					String sql = "select "
							+ part
							+ ",a.exSheetCode from customer d, exItems b, exSheet a,goods c  where a.custID=d.custID and a.exSheetCode=b.exSheetCode and a.isAcc=1 and b.goodsID=c.goodsID "
							+ listAdapter.getSqlCond() + " order by " + order
							+ " " + listAdapter.getSort();
					printParam.setSql(sql);
					System.out.println(sql);
					if ("xls".equals(ToolKit
							.toCN(req.getParameter("printType")))) {
						new ReportExcelListTemplet(printParam, printCond,
								listAdapter, resp, req);
					} else {
						new ReportListTemplet(
								printParam,
								listAdapter,
								printCond,
								intuitsoft.eclipse.table.common.DocPrefix.EX_SHEET,
								resp, req);
					}

				} catch (Exception e) {
					e.printStackTrace();
				}
				break;

			case 1:
				try {
					printParam = new ReportPrintParam(
							loginInfo.getJndiName(),
							intuitsoft.eclipse.table.common.DocPrefix.EB_SHEET_GOODS);
					printCond = new PrintCond();
					printParam.setPrintMode(req.getParameter("print"));
					printParam.setOrient(req.getParameter("r"));
					printParam.setIsDetail(req.getParameter("isDetail"));
					printParam.setPageRows(req.getParameter("pageRows"));
					printCond.setCreateDate1(adapter2.getCreateDate1());
					printCond.setCreateDate3(adapter2.getCreateDate3());
					printParam.setTotallist(req.getParameter("totals"));
					printParam.initial(ToolKit
							.toCN(req.getParameter("columns")));
					order = printParam
							.getOrderColumns(req.getParameter("oldColumns"),
									listAdapter.getOrder());
					if (order == null) {
						order = "1";
					}

					String part = printParam.getColumnsToSql()
							.replace('`', ',');
					String sql = "select "
							+ part
							+ ",c.goodsID from exItems b,exSheet a,goods c where a.exSheetCode=b.exSheetCode and a.isAcc=1 and b.goodsID=c.goodsID "
							+ listAdapter.getSqlCond()
							+ " group by c.gdsNo,c.gdsName,c.unit,c.goodsID,c.salePrice "
							+ " order by " + order + " "
							+ listAdapter.getSort();
					printParam.setSql(sql);
					if ("xls".equals(ToolKit
							.toCN(req.getParameter("printType")))) {
						new ReportExcelListTemplet(printParam, printCond,
								listAdapter, resp, req);
					} else {
						new ReportListTemplet(
								printParam,
								listAdapter,
								printCond,
								intuitsoft.eclipse.table.common.DocPrefix.EX_SHEET_GOODS,
								resp, req);
					}

				} catch (Exception e) {
					e.printStackTrace();
				}
				break;

			case 2:
				try {
					printParam = new ReportPrintParam(
							loginInfo.getJndiName(),
							intuitsoft.eclipse.table.common.DocPrefix.EX_SHEET_CUST);
					printCond = new PrintCond();
					printParam.setPrintMode(req.getParameter("print"));
					printParam.setOrient(req.getParameter("r"));
					printParam.setIsDetail(req.getParameter("isDetail"));
					printParam.setPageRows(req.getParameter("pageRows"));
					printCond.setCreateDate1(adapter2.getCreateDate1());
					printCond.setCreateDate3(adapter2.getCreateDate3());
					printParam.setTotallist(req.getParameter("totals"));
					printParam.initial(ToolKit
							.toCN(req.getParameter("columns")));
					order = printParam
							.getOrderColumns(req.getParameter("oldColumns"),
									listAdapter.getOrder());
					if (order == null) {
						order = "1";
					}

					String part = printParam.getColumnsToSql()
							.replace('`', ',');
					String sql = "select "
							+ part
							+ ",d.custID from customer d ,exSheet a,exItems b,goods c where  d.custID=a.custID and a.isAcc=1 and a.exSheetCode=b.exSheetCode and b.goodsID=c.goodsID "
							+ listAdapter.getSqlCond()
							+ "  group by d.custID,d.custNo,d.custName "
							+ " order by " + order + " "
							+ listAdapter.getSort();
					printParam.setSql(sql);
					if ("xls".equals(ToolKit
							.toCN(req.getParameter("printType")))) {
						new ReportExcelListTemplet(printParam, printCond,
								listAdapter, resp, req);
					} else {
						new ReportListTemplet(
								printParam,
								listAdapter,
								printCond,
								intuitsoft.eclipse.table.common.DocPrefix.EX_SHEET_CUST,
								resp, req);
					}

				} catch (Exception e) {
					e.printStackTrace();
				}
				break;

			}

		}
	}

	private void error(int type, String msg, HttpServletRequest req,

	HttpServletResponse resp) throws ServletException, IOException {
		MsgBean msgBean = new MsgBean();
		msgBean.setType(type);
		msgBean.setMsg(msg);
		req.setAttribute("MsgBean", msgBean);
		getServletContext().getRequestDispatcher("/common/prompt.jsp").forward(
				req, resp);
	}

}