getoperation.java

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

package operation;

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

import dataBase.DataBase;

public class GetOperation
{
	private ResultSet rs;
	private DataBase db;
	public GetOperation()
	{
		db=new DataBase();
	}
	public String getGetID()
	{
		
			String GetID=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 GetList where GetID like '%"+Date+"%'";
			
			try
			{
			 rs=db.getResult(sql);
			 if(rs.next())
			 {	
			  rs.last();
			  int Row=rs.getRow();
			  String R=String.valueOf(Row+1);
			  GetID="G"+Date+"00"+R;             //生成收款编号
			 }
			 else
			  GetID="G"+Date+"001";             //若不存在当天的收款记录，记为001
			   
			}
			catch(SQLException e)
			{
				e.printStackTrace();
			}
			return GetID;
		
	}
	public int  CheckSum(String ShouldGetID,float GetSum)
	{
		int a=0;
		String sql="select *  from ShouldGetList where ShouldGetID='"+ShouldGetID+"'";
		try
		{
			rs=db.getResult(sql);
			rs.next();
			float leaveSum=rs.getFloat("leaveSum");
			if(leaveSum==GetSum)
			{
				a=1;
			}
			else if(leaveSum>GetSum)
			{
				a=0;
			}
			else if(leaveSum<GetSum)
			{
				a=2;
			}
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		return a;
	}
	public void GetInsert(int a,String GetID,String ShouldGetID,float GetSum,String Chargeman,Date PayDate,String PayNotice)
	{
		String v="是";
		if(a==1)
		{
			v="是";
		}
		else 
			v="否";
		String sql1="insert into GetList values('"+GetID+"','"+ShouldGetID+"',"+GetSum+",'"+Chargeman+"','"
		+PayDate+"','"+PayNotice+"')";
		String sql2="update ShouldGetList set LeaveSum=LeaveSum-"+GetSum+" where ShouldGetID='"+ShouldGetID+"'";
		String sql3="update ShouldGetList set ShouldGetFlag='"+v+"' where ShouldGetID='"+ShouldGetID+"'";
		try
		{
		db.ExeQuery(sql1, sql2, sql3);
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	}
	public void Close()
	{
		db.close();
	}

}