进销存/财务系统.war

package com.jtonsoft.storage.operator; import java.sql.Connection; import java.sql.Date; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.Hashtable; import java.util.Iterator; import java.util.List; import java.util.Set; import org.hibernate.Query; import org.hibernate.Session; import org.hibernate.Transaction; import com.jtonsoft.common.DBConection; import com.jtonsoft.hibernate.*; import com.jtonsoft.storage.dto.ListReceive; import com.jtonsoft.storage.dto.Receiver; import com.jtonsoft.storage.dto.ReceiverNum; /**@description 用于处理仓库管理的存货收发汇总,存货单据汇总,存货存量比较 * @author 张隆斌 * @Modify Date 2007-11-19 * */ public class ReceiveOperator { //构造一个函数 /** * @exception 用于处理业务逻辑 */ private Session session;//定义Session private Transaction tran;//定义事务的提交 private List list=null; DBConection db; Connection conn; public ReceiveOperator(){ db=new DBConection(); conn=db.conn; session=HibernateSessionFactory.getSession(); tran=null; } //关闭SESSION public void close(){ session.close(); } //得到收入数量,查询的单据有：盘盈单，调拨单据中仓库为调入仓库（但是调拨单不参与成本核算），入库单据（外购入库，外购退货－红字，自制收货，其他收货） @SuppressWarnings("unchecked") public Hashtable Query(String month1,String month2,String storage,String chdm) throws SQLException{ String aa=null; //当存货代码确定,仓库为全部仓库时候,进行查询 String sql=null; String sql2=null; if(storage.equals("*")&&chdm!=""&&chdm!=null){ System.out.println("当存货代码确定,仓库为全部仓库时候,进行查询"); sql="select Sum(StorageInDetail.realNum)as number ,merchandiseID as merchandiseID from StorageInDetail,StorageInDraw where StorageInDetail.StorageInDrawID=StorageInDraw.id and DATEPART(month ,billDate) between'"+month1+"' and '"+month2+"' and merchandiseID='"+chdm+"' group by merchandiseID"; //sql2="select Sum(StorageOutDetail.realNum)as number2 ,merchandiseID as merchandiseID2 from StorageOutDetail,StorageOutDraw where StorageOutDetail.StorageOutDrawID=StorageOutDraw.id and DATEPART(month ,billDate) between'"+month1+"' and '"+month2+"' and merchandiseID='"+chdm+"' group by merchandiseID"; aa="1"; } System.out.println("****************************/"); //当存货代码确定,仓库确定的时候的查询 if(!storage.equals("*")&&chdm!=""&&chdm!=null){ System.out.println("当存货代码确定,仓库确定的时候的查询"); sql="select Sum(StorageInDetail.realNum) as number,merchandiseID as merchandiseID ,storageAddressID as storageAddressID from StorageInDetail,StorageInDraw where StorageInDetail.StorageInDrawID=StorageInDraw.id and datepart(mm,billdate) between '"+month1+"'and '"+month2+"' and merchandiseID='"+chdm+"' and storageAddressID='"+storage+"' group by merchandiseID ,storageAddressID"; // sql2="select Sum(StorageOutDetail.realNum)as number2 ,merchandiseID as merchandiseID2 ,storageAddressID as storageAddressID2 from StorageOutDetail,StorageOutDraw where StorageOutDetail.StorageOutDrawID=StorageOutDraw.id and DATEPART(month ,billDate) between'"+month1+"' and '"+month2+"' and merchandiseID='"+chdm+"' and storageAddressID='"+storage+"' group by merchandiseID,storageAddressID"; aa="2"; } //当存货代码为空,仓库为全部仓库时候进行的查询 if(storage.equals("*")&&chdm.length()==0){ System.out.println("当存货代码为空,仓库为全部仓库时候进行的查询"); sql="select Sum(StorageInDetail.realNum) as number ,merchandiseID as merchandiseID from StorageInDetail,StorageInDraw where StorageInDetail.StorageInDrawID=StorageInDraw.id and datepart(mm,billdate)between '"+month1+"' and '"+month2+"' group by merchandiseID"; //sql2="select Sum(StorageOutDetail.realNum)as number2 ,merchandiseID as merchandiseID2 from StorageOutDetail,StorageOutDraw where StorageOutDetail.StorageOutDrawID=StorageOutDraw.id and DATEPART(month ,billDate) between'"+month1+"' and '"+month2+"' group by merchandiseID"; aa="3"; } //当存货代码为空,仓库确定时候进行的查询 if(!storage.equals("*")&&chdm.length()==0){ System.out.println("当存货代码为空,仓库确定时候进行的查询"); sql="select Sum(StorageInDetail.realNum) as number ,merchandiseID as merchandiseID,storageAddressID as storageAddressID from StorageInDetail,StorageInDraw where StorageInDetail.StorageInDrawID=StorageInDraw.id and datepart(mm,billdate) between '"+month1+"'and '"+month2+"' and storageAddressID='"+storage+"' group by merchandiseID,storageAddressID"; //sql2="select Sum(StorageOutDetail.realNum)as number2 ,merchandiseID as merchandiseID2 ,storageAddressID as storageAddressID2 from StorageOutDetail,StorageOutDraw where StorageOutDetail.StorageOutDrawID=StorageOutDraw.id and DATEPART(month ,billDate) between'"+month1+"' and '"+month2+"' and storageAddressID='"+storage+"' group by merchandiseID,storageAddressID"; aa="4"; } PreparedStatement pStat = conn.prepareStatement(sql); ResultSet rs = pStat.executeQuery(); Hashtable ht=new Hashtable(); if(aa.equals("1")||aa.equals("3")){ while(rs.next()){ System.out.println("收到数量的1和3"); System.out.println("收到数量"+rs.getString("number"));//收到数量 System.out.println("受到的ID"+rs.getInt("merchandiseID")); int merchandiseID=rs.getInt("merchandiseID");//收到的ID String number=rs.getString("number");//受到的数量 ht.put(merchandiseID, number); } }else{ while(rs.next()){ System.out.println("收到数量的2和4"); System.out.println("//收到数量"+rs.getString("number"));//收到数量 System.out.println("//收到数量DEID"+rs.getString("merchandiseID")); int merchandiseID=rs.getInt("merchandiseID");//收到的ID String number=rs.getString("number");//受到的数量 ht.put(merchandiseID, number); } }return ht; } // 得到发出的数量，查询的单据有：盘亏单，调拨单据中仓库为调出仓库（但是调拨单不参与成本核算），出库（销售发货，销售退回，其他发货） @SuppressWarnings("unchecked") public Hashtable QuerySend(String month1,String month2,String storage,String chdm) throws SQLException{ System.out.println(month1); System.out.println(month2); System.out.println(storage); System.out.println(chdm); String aa=null; //DBConection db=new DBConection(); //Connection conn=db.conn; String sql2=null; if(storage.equals("*")&&chdm!=""&&chdm!=null){ System.out.println("当存货代码确定,仓库为全部仓库时候,进行查询"); //sql="select Sum(StorageInDetail.realNum)as number ,merchandiseID as merchandiseID from StorageInDetail,StorageInDraw where StorageInDetail.StorageInDrawID=StorageInDraw.id and DATEPART(month ,billDate) between'"+month1+"' and '"+month2+"' and merchandiseID='"+chdm+"' group by merchandiseID"; sql2="select Sum(StorageOutDetail.realNum)as number2 ,merchandiseID as merchandiseID2 from StorageOutDetail,StorageOutDraw where StorageOutDetail.StorageOutDrawID=StorageOutDraw.id and DATEPART(month ,billDate) between'"+month1+"' and '"+month2+"' and merchandiseID='"+chdm+"' group by merchandiseID"; aa="1"; } System.out.println("****************************/"); //当存货代码确定,仓库确定的时候的查询 if(!storage.equals("*")&&chdm!=""&&chdm!=null){ System.out.println("当存货代码确定,仓库确定的时候的查询"); //sql="select Sum(StorageInDetail.realNum) as number,merchandiseID as merchandiseID ,storageAddressID as storageAddressID from StorageInDetail,StorageInDraw where StorageInDetail.StorageInDrawID=StorageInDraw.id and datepart(mm,billdate) between '"+month1+"'and '"+month2+"' and merchandiseID='"+chdm+"' and storageAddressID='"+storage+"' group by merchandiseID ,storageAddressID"; sql2="select Sum(StorageOutDetail.realNum)as number2 ,merchandiseID as merchandiseID2 ,storageAddressID as storageAddressID2 from StorageOutDetail,StorageOutDraw where StorageOutDetail.StorageOutDrawID=StorageOutDraw.id and DATEPART(month