choiceaction.java

用jsp写的学生管理系统

package com.easyjf.asp.action;

import java.util.ArrayList;
import java.util.Collection;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import com.easyjf.asp.business.ActiveUser;
import com.easyjf.asp.business.CoreBusiness;
import com.easyjf.asp.business.Customer;
import com.easyjf.asp.business.Material;
import com.easyjf.asp.business.Product;
import com.easyjf.asp.business.SystemBasicDataDetail;
import com.easyjf.asp.business.SystemRegion;
import com.easyjf.asp.business.SystemUser;
import com.easyjf.dbo.EasyJDB;
import com.easyjf.util.CommUtil;
import com.easyjf.web.ActionContext;
import com.easyjf.web.IWebAction;
import com.easyjf.web.Module;
import com.easyjf.web.Page;
import com.easyjf.web.WebForm;
import com.easyjf.web.tools.DbPageList;
/**
 * 执行选择客户、产品、原材料、系统用户的窗口
 * @author 蔡世友
 *
 */
public class ChoiceAction implements IWebAction {
	public Page execute(WebForm form, Module module) {
		String method=CommUtil.null2String(form.get("easyJWebCommand"));		
		ActiveUser user=(ActiveUser)ActionContext.getContext().getSession().getAttribute("user");
		String xmlChoice=CommUtil.null2String(form.get("xmlChoice"));
		if("".equals(method)||"customer".equals(method))//查询客户
		{					
			doChoiceCustomer(form,module,user);	
			initCustomer(form);
			if(!xmlChoice.equals(""))return new Page("xmlChoice","/xmlChoice.xml","template");
		}
		else if("deliveryDept".equals(method))
		{
			doChoiceDeliveryDept(form,module,user);
			initCustomer(form);
			if(!xmlChoice.equals(""))return new Page("xmlChoice","/xmlChoice.xml","template");
		}
		else if("product".equals(method))//查询产品
		{					
			doChoiceProduct(form,module,user);	
			initProduct(form);
			if(!xmlChoice.equals(""))return new Page("xmlChoice","/xmlChoice.xml","template");
		}
		else if("sysuser".equals(method))//查询操作用户
		{
			doChoiceSystemUser(form,module,user);	
		}
		else if("material".equals(method))//查询原材料
		{
			doChoiceMaterial(form,module,user);			
		}
		else if("orderProduct".equals(method))//查询原材料
		{
			doChoiceOrderProduct(form,module,user);	
			initProduct(form);
			if(!xmlChoice.equals(""))return new Page("xmlChoice","/xmlChoice.xml","template");
		}
		else if("unit".equals(method))
		{
			doChoiceUnit(form,module,user);
		}
		else if("productDetail".equals(method))//查询原材料
		{
			doChoiceProductDetail(form,module,user);
			return new Page("xmlMsg","/xmlMsg.xml","template");
		}		
		else if("region".equals(method))
		{
			doChoiceRegion(form,module,user);
			return new Page("xmlChoice","/xmlChoice.xml","template");
		}		
		return module.findPage(module.getDefaultPage());
	}
	private void initCustomer(WebForm form)
	{
		List provinceList=SystemRegion.query("lev=1");			
		form.addResult("provinceList",provinceList);
		form.addResult("choiceCustomer","true");
	}
	private void initProduct(WebForm form)
	{
		form.addResult("choiceProduct","true");
		form.addResult("productTypesList",CoreBusiness.getProductTypes());
	}
	private void doChoiceCustomer(WebForm form, Module module,ActiveUser user)
	{
		String scope="belongDept=?";
		Collection paras=new ArrayList();
		paras.add(user.getDept());
		String province=CommUtil.null2String(form.get("queryProvince"));
		String city=CommUtil.null2String(form.get("queryCity"));
		String title=CommUtil.null2String(form.get("title"));
		if(!province.equals(""))
		{
		    scope+=" and province=?";
		    paras.add(province);
		}
		if(!city.equals(""))
		{
			scope+=" and city=?";
			paras.add(city);
		}	
		if(!title.equals(""))
		{
			scope+=" and (title like ? or linkMan like ?)";
			paras.add("%"+title+"%");
			paras.add("%"+title+"%");
		}
		DbPageList pList=new DbPageList(Customer.class,scope,paras);
		pList.doList(1,-1);
		List list=pList.getResult();
		List ret=new ArrayList();
		if(list!=null)
		{
			for(int i=0;i<list.size();i++)
			{
				Map map=new HashMap();					
				Customer obj=(Customer)list.get(i);
				map.put("title",obj.getTitle());
				map.put("value",obj.getTitle()+";"+obj.getSn()+";"+obj.getLinkMan()+";"+obj.getTel());
				ret.add(map);
			}
		}
		form.addResult("list",ret);
	}
	private void doChoiceDeliveryDept(WebForm form, Module module,ActiveUser user)
	{
		String scope="belongDept=? and types='10'";
		Collection paras=new ArrayList();
		paras.add(user.getDept());
		String province=CommUtil.null2String(form.get("queryProvince"));
		String city=CommUtil.null2String(form.get("queryCity"));
		String title=CommUtil.null2String(form.get("title"));
		if(!province.equals(""))
		{
		    scope+=" and province=?";
		    paras.add(province);
		}
		if(!city.equals(""))
		{
			scope+=" and city=?";
			paras.add(city);
		}	
		if(!title.equals(""))
		{
			scope+=" and title like ?";
			paras.add("%"+title+"%");
		}
		DbPageList pList=new DbPageList(Customer.class,scope,paras);
		if(pList==null)return;
		pList.doList(1,-1);			
		List list=pList.getResult();
		List ret=new ArrayList();
		if(list!=null)
		{
			for(int i=0;i<list.size();i++)
			{
				Map map=new HashMap();					
				Customer obj=(Customer)list.get(i);
				map.put("title",obj.getTitle());
				map.put("value",obj.getTitle()+";"+obj.getSn()+";"+obj.getLinkMan()+";"+obj.getTel());
				ret.add(map);
			}
		}
		form.addResult("list",ret);
	
	}
	private void doChoiceProduct(WebForm form, Module module,ActiveUser user)
	{
		String scope="belongDept=?";
		Collection paras=new ArrayList();
		paras.add(user.getDept());
		String types=CommUtil.null2String(form.get("types"));
		String title=CommUtil.null2String(form.get("title"));
		if(!types.equals(""))
		{
			scope+=" and types=?";
			paras.add(types);
		}	
		if(!title.equals(""))
		{
			scope+=" and (title like ? or sn like ?) ";
			paras.add("%"+title+"%");
			paras.add("%"+title+"%");
		}	
		DbPageList pList=new DbPageList(Product.class,scope,paras);
		pList.doList(1,-1);
		List list=pList.getResult();
		List ret=new ArrayList();
		if(list!=null)
		{
			for(int i=0;i<list.size();i++)
			{
				Map map=new HashMap();					
				Product obj=(Product)list.get(i);
				map.put("title",obj.getTitle());
				map.put("value",obj.getTitle()+";"+obj.getSn());
				ret.add(map);
			}
		}
		form.addResult("list",ret);
	}
	private void doChoiceMaterial(WebForm form, Module module,ActiveUser user)
	{
		String scope="belongDept=?";
		Collection paras=new ArrayList();
		paras.add(user.getDept());
		DbPageList pList=new DbPageList(Material.class,scope,paras);
		pList.doList(1,-1);
		List list=pList.getResult();
		List ret=new ArrayList();
		if(list!=null)
		{
			for(int i=0;i<list.size();i++)
			{
				Map map=new HashMap();					
				Material obj=(Material)list.get(i);
				map.put("title",obj.getTitle());
				map.put("value",obj.getTitle()+";"+obj.getCid());
				ret.add(map);
			}
		}
		form.addResult("list",ret);
	}
	private void doChoiceSystemUser(WebForm form, Module module,ActiveUser user)
	{
		String scope="belongDept=?";
		Collection paras=new ArrayList();
		paras.add(user.getDept());
		DbPageList pList=new DbPageList(SystemUser.class,scope,paras);
		pList.doList(1,-1);
		List list=pList.getResult();
		List ret=new ArrayList();
		if(list!=null)
		{
			for(int i=0;i<list.size();i++)
			{
				Map map=new HashMap();					
				SystemUser obj=(SystemUser)list.get(i);
				map.put("title",obj.getTrueName());
				map.put("value",obj.getTrueName()+";"+obj.getCid());
				ret.add(map);
			}
		}
		form.addResult("list",ret);
	}
	private void doChoiceOrderProduct(WebForm form, Module module,ActiveUser user)
	{
		String customerSn=CommUtil.null2String(form.get("customerSn"));
		String scope="belongDept=?";
		Collection paras=new ArrayList();
		paras.add(user.getDept());
		String types=CommUtil.null2String(form.get("types"));
		if(!types.equals(""))
		{
			scope+=" and types=?";
			paras.add(types);
		}
		DbPageList pList=new DbPageList(Product.class,scope,paras);
		pList.doList(1,-1);
		List list=pList.getResult();
		List ret=new ArrayList();
		if(list!=null)
		{
			for(int i=0;i<list.size();i++)
			{
				Map map=new HashMap();					
				Product obj=(Product)list.get(i);
				map.put("title",obj.getTitle());
				//传到外面的值为title;sn;types;dir;unit;unitBase;price
				String value=obj.getTitle()+";"+obj.getSn()+";"+obj.getTypes()+";"+obj.getDir()+";"+obj.getUnit();
				String sql="select tvalue from SystemBasicDataDetail where parentSn='SystemUnit' and title='"+obj.getUnit()+"'";				
				Object unitBase=EasyJDB.getInstance().uniqueResult(sql);
				if(unitBase!=null)
				{
					value+=";"+unitBase;
				}
				else
				{
					value+=";1";//默认为1个单位
				}
				//sql="select price from CustomerPrice where belongDept='"+user.getDept()+"' and productSn='"+obj.getSn()+"' and customerSn='"+customerSn+"' and unit='"+obj.getUnit()+"'";
				sql="select price from OrderList where  productSn='"+obj.getSn()+"' and  unit='"+obj.getUnit()+"' and orderSn in(select sn as orderSn from OrderInfo where customerSn='"+customerSn+"')";
				//System.out.println(sql);
				Object defaultPrice=null;//EasyJDB.getInstance().uniqueResult(sql);					
				if(defaultPrice!=null)
				{
					value+=";"+defaultPrice;
				}
				else
				{
					value+=";"+obj.getSalePrice();
				}						
				map.put("value",value);
				ret.add(map);
			}
		}
		form.addResult("list",ret);
	}
	private void doChoiceProductDetail(WebForm form, Module module,ActiveUser user)
	{
		String customerSn=CommUtil.null2String(form.get("customerSn"));
		String productSn=CommUtil.null2String(form.get("productSn"));
		
				Map map=new HashMap();					
				Product obj=Product.readBySn(productSn);
				map.put("title",obj.getTitle());
				//传到外面的值为title;sn;types;dir;unit;unitBase;price
				String value=obj.getTitle()+";"+obj.getSn()+";"+obj.getTypes()+";"+obj.getDir()+";"+obj.getUnit();
				String sql="select tvalue from SystemBasicDataDetail where parentSn='SystemUnit' and title='"+obj.getUnit()+"'";				
				Object unitBase=EasyJDB.getInstance().uniqueResult(sql);
				if(unitBase!=null)
				{
					value+=";"+unitBase;
				}
				else
				{
					value+=";1";//默认为1个单位
				}
				//sql="select price from CustomerPrice where belongDept='"+user.getDept()+"' and productSn='"+obj.getSn()+"' and customerSn='"+customerSn+"' and unit='"+obj.getUnit()+"'";
				sql="select price from OrderList where  productSn='"+obj.getSn()+"' and  unit='"+obj.getUnit()+"' and orderSn in(select top 1 sn as orderSn from OrderInfo where customerSn='"+customerSn+"' order by inputTime desc)";
				//System.out.println(sql);
				Object defaultPrice=EasyJDB.getInstance().uniqueResult(sql);					
				if(defaultPrice!=null)
				{
					value+=";"+defaultPrice;
				}
				else
				{
					value+=";"+obj.getSalePrice();
				}						
				map.put("value",value);
				
			
		form.addResult("msg",value);
	}
	private void doChoiceUnit(WebForm form, Module module,ActiveUser user)
	{
		String scope="parentSn='SystemUnit'";
		DbPageList pList=new DbPageList(SystemBasicDataDetail.class,scope);
		pList.doList(1,-1);
		List list=pList.getResult();
		List ret=new ArrayList();
		if(list!=null)
		{
			for(int i=0;i<list.size();i++)
			{
				Map map=new HashMap();					
				SystemBasicDataDetail obj=(SystemBasicDataDetail)list.get(i);
				map.put("title",obj.getTitle());
				map.put("value",obj.getTitle()+";"+obj.getTvalue());
				ret.add(map);
			}
		}
		form.addResult("list",ret);
	}
	private void doChoiceRegion(WebForm form, Module module,ActiveUser user)
	{
		String pSn=CommUtil.null2String(form.get("sn"));
		String scope="parentSn='"+pSn+"'";
		DbPageList pList=new DbPageList(SystemRegion.class,scope);
		pList.doList(1,-1);
		List list=pList.getResult();
		/*
		List ret=new ArrayList();
		if(list!=null)
		{
			for(int i=0;i<list.size();i++)
			{
				Map map=new HashMap();					
				SystemBasicDataDetail obj=(SystemBasicDataDetail)list.get(i);
				map.put("title",obj.getTitle());
				map.put("value",obj.getTitle()+";"+obj.getTvalue());
				ret.add(map);
			}
		}*/
		form.addResult("list",list);
	}
}