www.pudn.com > BeiJie.rar > DownerBackOperation.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 DownerBackOperation 
{ 
	private Statement stmt; 
	private ResultSet rs; 
	private Connection conn; 
	private DataBase db; 
	public DownerBackOperation() 
	{ 
	 db=new DataBase(); 
	} 
	public String getDownerBackID() 
	{ 
		 
			String DownerBackID=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 DownerBackList where DownerBackID like '%"+Date+"%'"; 
			 
			try 
			{ 
			  rs=db.getResult(sql); 
			 if(rs.next()) 
			 {	 
			  rs.last(); 
			  int Row=rs.getRow(); 
			  String R=String.valueOf(Row+1); 
			  DownerBackID="D"+Date+"00"+R;             //生成退货编号 
			 } 
			 else 
			  DownerBackID="D"+Date+"001";             //若不存在当天的退货记录，记为001 
			    
			} 
			catch(SQLException e) 
			{ 
				e.printStackTrace(); 
			} 
			return DownerBackID; 
		 
	} 
	 
	//得到相对应进货编号的产品编号 
	public String getProductID(String SaleID)                              
	{ 
		String ProductID=null; 
		String sql="select * from SaleInfo where SaleID='"+SaleID+"'"; 
		try 
		{ 
			rs=db.getResult(sql); 
			rs.next(); 
			ProductID=rs.getString("ProductID"); 
		} 
		catch(Exception e) 
		{ 
			e.printStackTrace(); 
		} 
		return ProductID; 
	} 
	 
	//得到相应进货的单价 
	public float getPrice(String SaleID) 
	{ 
		float SalePrice=0; 
		String sql="select * from SaleInfo where SaleID='"+SaleID+"'"; 
		try 
		{ 
			rs=db.getResult(sql); 
			rs.next(); 
			SalePrice=rs.getFloat("SalePrice"); 
		} 
		catch(Exception e) 
		{ 
			e.printStackTrace(); 
		} 
		return SalePrice; 
	} 
	 
	//检查进货量是否小于退货量 
	public int checkSaleQuantity(String SaleID,int BackQuantity) 
	{ 
		int a=0; 
		String sql="select * from SaleInfo where SaleID='"+SaleID+"'"; 
		try 
		{ 
			rs=db.getResult(sql); 
			rs.next(); 
			int SaleQuantity=rs.getInt("SaleQuantity"); 
			if(SaleQuantityLeaveSum) 
			{ 
				a=1; 
			} 
			else if(ShouldGetSum-BackSum==0) 
			{ 
				a=2; 
			} 
		} 
		catch(Exception e) 
		{ 
			e.printStackTrace(); 
		} 
		return a; 
	} 
 
	public void DownerBackInsert(int a,String DownerBackID,String SaleID,int BackQuantity,float BackSum, 
			Date BackDate,String Chargeman,String BackNotice,String ProductID) 
	{ 
		float ShouldGetSum=0; 
		float MinerSum=0; 
		String sql1="insert into DownerBackList values('"+DownerBackID+"','"+SaleID+"',"+BackQuantity+"," 
		+BackSum+",'"+BackDate+"','"+Chargeman+"','"+BackNotice+"')"; 
		String sql2=null; 
		String sql3="update StockRecord set ProductQuantity=ProductQuantity+"+BackQuantity+" where ProductID='"+ProductID+"'"; 
		String sql="select * from ShouldGetList where SaleID='"+SaleID+"'"; 
		try 
		{ 
			rs=db.getResult(sql); 
			rs.next(); 
			ShouldGetSum=rs.getFloat("ShouldGetSum"); 
			 
		} 
		catch(Exception e) 
		{ 
			e.printStackTrace(); 
		} 
		MinerSum=ShouldGetSum-BackSum; 
		if(a==0) 
		{ 
		  sql2="update ShouldGetList set ShouldGetSum="+MinerSum+",LeaveSum ="+MinerSum+" where SaleID='"+SaleID+"'"; 
		} 
		else if(a==1) 
		{ 
			sql2= sql2="update ShouldGetList set ShouldGetSum="+MinerSum+" where SaleID='"+SaleID+"'"; 
		} 
		else if(a==2) 
		{ 
			sql2="update ShouldGetList set ShouldGetSum=0,ShouldGetFlag='是',leaveSum=0 where SaleID='"+SaleID+"'"; 
		} 
		try 
		{ 
			db.ExeQuery(sql1, sql2, sql3); 
		} 
		catch(Exception e) 
		{ 
			e.printStackTrace(); 
		} 
		 
	} 
	public void close() 
	{ 
		db.close(); 
	} 
}