学习笔记

在工作中整理的一些东西方便以后的查看
//实现功能在前台实现复合查询
//zk代码

<zk>
	<window border="normal" id="window" contentStyle="padding:0px"  
		apply="view.board.composer.BoComposer" width="100%" height="100%">
		<panel title="查看报销费用" >
			<panelchildren>
				<window id="windo"
					apply="view.login.composer.UserComoper">
					<hbox>
						<listbox id="operType" mold="select"
							forward="onSelect=onChangeList">
							<listitem label="操作员" selected="true"></listitem>
							<listitem label="项目"></listitem>
							<listitem label="费用发生时间" />
						</listbox>
						<listbox width="50px" mold="select" id="caozuofu">
							<listitem label="=" selected="true"/>
							<listitem label=">" />
							<listitem label=">=" />
							<listitem label="&lt;" />
							<listitem label="&lt;=" />
						</listbox>
						<listbox id="combo1" mold="select">
							<listitem forEach="${list}" value="${each}"
								label="${each.username}" selected="${forEachStatus.index==0 }" />
						</listbox>
						<label value="金额:"/>
						<listbox width="50px" mold="select" id="fuhao">
							<listitem label="=" selected="true"/>
							<listitem label=">" />
							<listitem label=">=" />
							<listitem label="&lt;" />
							<listitem label="&lt;=" />
						</listbox>
						<listbox mold="select" id="jinlistbox">
						   <listitem label="10000" selected="true"/>
						   <listitem label="50000"/>
						   <listitem label="100000"/>
						   <listitem label="200000"/>
						</listbox>
						<button label="确定" forward="onOpenPage">
						</button>
					</hbox>
					<include id="inc" 
						src="/page/joumanage/bumenlist.zul" />
				</window>
			</panelchildren>
		</panel>
	</window>
</zk>

 public void onOpenPage(ForwardEvent event){
		inc.setSrc("");
		String seletedType = operType.getSelectedItem().getLabel();
		//String seletedfuhao = fuhao.getSelectedItem().getLabel();
		Object obj=null;
		String seletedfuhao = fuhao.getSelectedItem().getLabel();
		if (seletedType.equals("操作员")) {
//			inc.setSrc("/page/joumanage/userselelist.zul?username="
//					+ combo1.getSelectedItem().getLabel());
			
			obj=loginDAO.SQLQueryfindAllusername(combo1.getSelectedItem().getLabel(),seletedfuhao,jinlistbox.getSelectedItem().getLabel());
			inc.setSrc(null);
			inc.setDynamicProperty("account", obj);
			inc.setSrc("/page/joumanage/userselelist.zul");
		} else if (seletedType.equals("项目")) {
			List boardList = (List) Executions.getCurrent().getDesktop().getSession().getAttribute("board");
//			inc.setSrc("/page/joumanage/itemlist.zul?itemId="
//					+ combo1.getSelectedItem().getValue());
			obj=loginDAO.findAllitemlist((Integer) combo1.getSelectedItem().getValue(),seletedfuhao,jinlistbox.getSelectedItem().getLabel(),boardList);
			inc.setSrc(null);
			inc.setDynamicProperty("account", obj);
			inc.setSrc("/page/joumanage/itemlist.zul");
		}
		else if(seletedType.equals("费用发生时间")){
			String selectcao=caozuofu.getSelectedItem().getLabel();
//			inc.setSrc("/page/joumanage/feiyongtime.zul?creaTime="
//					+combo1.getSelectedItem().getLabel());
			List boardList = (List) Executions.getCurrent().getDesktop().getSession().getAttribute("board");
			obj=loginDAO.findAlldeiyongtime(combo1.getSelectedItem().getLabel(),selectcao,seletedfuhao,jinlistbox.getSelectedItem().getLabel(),boardList);
			System.out.println(boardlist);
			System.out.println(obj);
			inc.setSrc(null);
			inc.setDynamicProperty("account", obj);
			inc.setSrc("/page/joumanage/feiyongtime.zul");
		}
		
	}
    public void onChangeList(ForwardEvent event){
		Listbox box = (Listbox) event.getOrigin().getTarget();
		String label = box.getSelectedItem().getLabel();
		List dataList = null;
		if(label.equals("操作员")){
			dataList = loginDAO.findAllUser(null);
		}else if(label.equals("项目")){
			dataList = loginDAO.findAllItem();
			
		}
		else if(label.equals("费用发生时间")){
			dataList=loginDAO.findAllCreaTime();
			combo1.setSelectedIndex(0);
		}
		combo1.setModel((ListModel)null);
		combo1.setModel(new SimpleListModel(dataList));{
		combo1.setItemRenderer(new MyListitemRender());
		if(dataList!=null&&!dataList.isEmpty()){
			combo1.setSelectedIndex(0);
		}
	}
}
private class MyListitemRender implements ListitemRenderer{
	
	public MyListitemRender(){}
	@Override
	public void render(Listitem item, Object data) throws Exception {
		// TODO Auto-generated method stub
		if(data instanceof Login){
			Login login = (Login)data;
			item.setLabel(login.getUsername());
			item.setValue(login.getUsername());
		}else if(data instanceof Item){
			Item ite = (Item)data;
			item.setLabel(ite.getItemname());
			item.setValue(ite.getItemId());
		}
		else if(data instanceof Account){
			Account account=(Account)data;
			item.setLabel(account.getCreaTime());
			item.setValue(account.getCreaTime());
		}
	}
	
}

//传值

Object account =  Executions.getCurrent().getAttribute("account");
		System.out.println(account);
			comp.setVariable("list", account, true);

//chart

CategoryModel model = new SimpleCategoryModel();
		for(Iterator iter = list.iterator();iter.hasNext();)
		{
			Object[] obj = (Object[]) iter.next();
			model.setValue(obj[0].toString(), obj[1].toString(), Double.parseDouble(obj[2].toString()));
		}
		MyChartEngine engine=new MyChartEngine();
		mychart.setEngine(engine);
		mychart.setModel(model);

//init方法

private void initKehu(){
		feiyong.setModel(new SimpleListModel(kehu.querykehu()));
		feiyong.setItemRenderer(new ListitemRenderer(){
			public void render(Listitem item,Object data){
				KeHu kehu=(KeHu)data;
				item.setLabel(kehu.getKename());
				item.setValue(kehu.getKeId());
			}
		});
		if(feiyong.getSelectedCount()==0)
			feiyong.setSelectedIndex(0);
	}