?? choiceaction.java
字號:
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;
/**
* 執(zhí)行選擇客戶、產(chǎn)品、原材料、系統(tǒng)用戶的窗口
* @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))//查詢產(chǎn)品
{
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";//默認(rèn)為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";//默認(rèn)為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);
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -