www.pudn.com > BeiJie.rar > PayOperation.java, change:2008-01-04,size:2541b

package operation; 
 
 
import java.sql.ResultSet; 
import java.sql.SQLException; 
import java.util.Calendar; 
import java.sql.Date; 
 
import dataBase.DataBase; 
 
public class PayOperation 
{ 
	private ResultSet rs; 
	private DataBase db; 
	public PayOperation() 
	{ 
		db=new DataBase(); 
	} 
	public String getPayID() 
	{ 
		 
			String PayID=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 PayList where PayID like '%"+Date+"%'"; 
			 
			try 
			{ 
			  rs=db.getResult(sql); 
			 if(rs.next()) 
			 {	 
			  rs.last(); 
			  int Row=rs.getRow(); 
			  String R=String.valueOf(Row+1); 
			  PayID="P"+Date+"00"+R;             //生成销售编号 
			 } 
			 else 
			  PayID="P"+Date+"001";             //若不存在当天的销售记录，记为001 
			    
			} 
			catch(SQLException e) 
			{ 
				e.printStackTrace(); 
			} 
			return PayID; 
		 
	} 
	public int  CheckSum(String ShouldPayID,float PaySum) 
	{ 
		int a=0; 
		String sql="select *  from ShouldPayList where ShouldPayID='"+ShouldPayID+"'"; 
		try 
		{ 
			rs=db.getResult(sql); 
			rs.next(); 
			float leaveSum=rs.getFloat("leaveSum"); 
			if(leaveSum==PaySum) 
			{ 
				a=1; 
			} 
			else if(leaveSum>PaySum) 
			{ 
				a=0; 
			} 
			else if(leaveSum