uperbackoperation.java

该源代码实现了系统的进货

package operation;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Calendar;
import java.sql.Date;

import dataBase.DataBase;

public class UperBackOperation
{
	private ResultSet rs;
	private DataBase db;
	public UperBackOperation()
	{
	 db=new DataBase();
	}
	public String getUperBackID()
	{
		
			String UperBackID=null;
			Calendar cal=Calendar.getInstance();
			String Year=String.valueOf(cal.get(Calendar.YEAR));
			int m=Integer.parseInt(String.valueOf(cal.get(Calendar.MONTH)+1));
			String Month=null;
			if(m<10)
			{
				Month="0"+String.valueOf(m);
			}
			else
				Month=String.valueOf(m);
			String Day=null;
			int f=cal.get(Calendar.DAY_OF_MONTH);
			if(f<10)
			{
				Day="0"+String.valueOf(f);
			}
			else
				Day=String.valueOf(f);
			String Date=Year+Month+Day;
	        //查询是否存在当天的退货记录  
			
			String sql="select * from UperBackList where UperBackID like '%"+Date+"%'";
			
			try
			{
			  rs=db.getResult(sql);
			 if(rs.next())
			 {	
			  rs.last();
			  int Row=rs.getRow();
			  String R=String.valueOf(Row+1);
			  UperBackID="U"+Date+"00"+R;             //生成退货编号
			 }
			 else
			  UperBackID="U"+Date+"001";             //若不存在当天的退货记录，记为001
			   
			}
			catch(SQLException e)
			{
				e.printStackTrace();
			}
			return UperBackID;
		
	}
	
	//得到相对应进货编号的产品编号
	public String getProductID(String EnterID)                             
	{
		String ProductID=null;
		String sql="select * from EnterInfo where EnterID='"+EnterID+"'";
		try
		{
			rs=db.getResult(sql);
			rs.next();
			ProductID=rs.getString("ProductID");
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		return ProductID;
	}
	
	//得到相应进货的单价
	public float getPrice(String EnterID)
	{
		float EnterPrice=0;
		String sql="select * from EnterInfo where EnterID='"+EnterID+"'";
		try
		{
			rs=db.getResult(sql);
			rs.next();
			EnterPrice=rs.getFloat("EnterPrice");
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		return EnterPrice;
	}
	
	//检查进货量是否小于退货量
	public int checkEnterQuantity(String EnterID,int BackQuantity)
	{
		int a=0;
		String sql="select * from EnterInfo where EnterID='"+EnterID+"'";
		try
		{
			rs=db.getResult(sql);
			rs.next();
			int EnterQuantity=rs.getInt("EnterQuantity");
			if(EnterQuantity<BackQuantity)
			{
				a=0;
			}
			else
				a=1;
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		return a;
		
	}
	
	//得到库存量是否小于退货量
	public int checkProductQuantity(String ProductID,int BackQuantity)
	{
		int a=0;
		String sql="select * from StockRecord where ProductID='"+ProductID+"'";
		try
		{
			rs=db.getResult(sql);
			rs.next();
			int ProductQuantity=rs.getInt("ProductQuantity");
			if(ProductQuantity<BackQuantity)
			{
				a=0;
			}
			else
				a=1;
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		return a;
	}
	
	//检查相关金额
	public int checkSum(String EnterID,float BackSum)
	{
		int a=0;
		String sql="select * from ShouldPayList where EnterID='"+EnterID+"'";
		try
		{
			rs=db.getResult(sql);
			rs.next();
			float ShouldPaySum=rs.getFloat("ShouldPaySum");
			float LeaveSum=rs.getFloat("LeaveSum");
			if(ShouldPaySum<BackSum)
			{
				a=-1;
			}
			else if(ShouldPaySum-BackSum<LeaveSum)
			{
				a=0;
			}
			else if(ShouldPaySum-BackSum>LeaveSum&&ShouldPaySum!=0)
			{
				a=1;
			}
			else if(ShouldPaySum==0)
			{
				a=2;
			}
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		return a;
	}

	public void UperBackInsert(int a,String UperBackID,String EnterID,int BackQuantity,float BackPrice,float BackSum,
			Date BackDate,String Chargeman,String BackNotice,String ProductID)
	{
		
		float ShouldPaySum=0;
		float MinerSum=0;
		String sql1="insert into UperBackList values('"+UperBackID+"','"+EnterID+"',"+BackQuantity+","+BackPrice+","
		+BackSum+",'"+BackDate+"','"+Chargeman+"','"+BackNotice+"')";
		String sql2=null;
		String sql3="update StockRecord set ProductQuantity=ProductQuantity-"+BackQuantity+" where ProductID='"+ProductID+"'";
		String sql="select * from ShouldPayList where EnterID='"+EnterID+"'";
		try
		{
			rs=db.getResult(sql);
			rs.next();
			ShouldPaySum=rs.getFloat("ShouldPaySum");
			
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		MinerSum=ShouldPaySum-BackSum;
		if(a==0)
		{
		  sql2="update ShouldPayList set ShouldPaySum="+MinerSum+",LeaveSum ="+MinerSum+" where EnterID='"+EnterID+"'";
		}
		else if(a==1)
		{
		 sql2="update ShouldPayList set ShouldPaySum="+MinerSum+" where EnterID='"+EnterID+"'";
		}
		else if(a==2)
		{
			sql2="update ShouldPayList set ShouldPaySum=0,ShouldPayFlag='是',leaveSum=0 where EnterID='"+EnterID+"'";
		}
		try
		{
			db.ExeQuery(sql1, sql2, sql3);
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		
	}
	public void close()
	{
		db.close();
	}
}