www.pudn.com > erp0.1.zip > CoreBusiness.java
package com.easyjf.asp.business;
import java.math.BigDecimal;
import java.text.DecimalFormat;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
import com.easyjf.dbo.DBObject;
import com.easyjf.dbo.EasyJDB;
import com.easyjf.dbo.EasyJDBEngine;
public class CoreBusiness {
private final static DecimalFormat df=new DecimalFormat("0.00");
public static List countMaterial(List list)
{
List ret=new ArrayList();
EasyJDB db=EasyJDB.getInstance();
for(int i=0;i='"+vdate1+"'";
}
if(!vdate2.equals("")){
whereSql+=(vdate1.equals("")? " ":" and ")+" vdate<'"+vdate2+"'";
}}
sql+=whereSql+")";
System.out.println(sql);
EasyJDBEngine db=EasyJDBEngine.getInstance();
try{
ret=db.execute(sql);
}
catch(Exception e)
{
System.out.println(sql);
}
return ret;
}
/**
* 计算将要生产产品
* @param vdate1
* @param vdate2
* @return
*/
public static List orderTotal(String vdate1,String vdate2)
{
List list=null,ret=new ArrayList();
EasyJDBEngine db=EasyJDBEngine.getInstance();
String sql="select productSn as sn,sum(num*cou) as num,sum(amount) as amount from OrderList where status=0 and orderSn IN(SELECT sn AS orderSn FROM orderinfo WHERE ";
String whereSql="";
if(vdate2==null)whereSql+="vdate = '"+vdate1+"'";
else
{if(!vdate1.equals(""))
{
whereSql+=" vdate>='"+vdate1+"'";
}
if(!vdate2.equals("")){
whereSql+=(vdate1.equals("")? " ":" and ")+" vdate<'"+vdate2+"'";
}}
sql+=whereSql+") group by productSn";
//if(productSn!=null && (!productSn.equals("")))sql+=" and productSn='"+productSn+"'";
//sql+=" group by productSn";
//System.out.println(sql);
list=db.query(sql);
if(list!=null)
{
BigDecimal totalAmount=new BigDecimal(0.00);
for(int i=0;i='"+vdate1+"'";
}
if(!vdate2.equals("")){
whereSql+=(vdate1.equals("")? " ":" and ")+" vdate<'"+vdate2+"'";
}}
sql+=whereSql+") ";
if(productSn!=null && (!productSn.equals("")))sql+=" and productSn='"+productSn+"'";
sql+=" group by productSn";
System.out.println(sql);
list=db.query(sql);
if(list!=null)
{
BigDecimal totalAmount=new BigDecimal(0.00);
for(int i=0;i