spthmxb.java

web版的进销存系统

package jxc.web;
import jxc.com.DBConnect;
import java.lang.String;
import jxc.util.StrFun;
import java.sql.*;

import javax.servlet.http.*;

public class Spthmxb{
	private int ID;
	private int djbh;
	private int wpbh;
	private int num;
	private float dj;
	private float je;
	private boolean isError=false;
	private String StrError="";
	public int  getID() {
		return ID;
	}
	public void setID(int anew) {
		this.ID=anew;
	}
	public void setID(String anew) {
		if (anew!=null)
			this.ID=Integer.parseInt(anew);
	}
	public int  getDjbh() {
		return djbh;
	}
	public void setDjbh(int anew) {
		this.djbh=anew;
	}
	public int  getWpbh() {
		return wpbh;
	}
	public void setWpbh(int anew) {
		this.wpbh=anew;
	}
	public int  getNum() {
		return num;
	}
	public void setNum(int anew) {
		this.num=anew;
	}
	public float  getDj() {
		return dj;
	}
	public void setDj(float anew) {
		this.dj=anew;
	}
	public float  getJe() {
		return je;
	}
	public void setJe(float anew) {
		this.je=anew;
	}

	public boolean getIsError(){
		return this.isError;
	}
	public String getStrError(){
		return this.StrError;
	}

	public boolean excute() throws Exception {
		String Str="Select * From spthmxb where Id="+ID;
		try {
			DBConnect dbc  = new DBConnect(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
			ResultSet rs = dbc.executeQuery(Str);
			if (rs.next()){
				ID=rs.getInt("ID"); 
				djbh=rs.getInt("djbh"); 
				wpbh=rs.getInt("wpbh"); 
				num=rs.getInt("num"); 
				dj=rs.getFloat("dj"); 
				je=rs.getFloat("je"); 
			}
			rs.close();
			dbc.close();
			return true;
		}
		catch (SQLException sqle){
			return false;
		}
	} 
	public void Edit(HttpServletRequest request) throws Exception {
		ID=StrFun.getInt(request,"id"); 
		djbh=StrFun.getInt(request,"djbh"); 
		num=StrFun.getInt(request,"num"); 
		dj=StrFun.getFloat(request,"dj"); 
		wpbh=StrFun.getInt(request,"wpbh"); 

		if (num<=0){
			isError=true;
			StrError=StrError+"数量错误!!!   <br>";
		} 
		String ckid=request.getParameter("ckid");
		String Str="Select * From kcb where wpbh="+wpbh+" and ckbh="+ckid;
		DBConnect dbc  = new DBConnect();
		ResultSet rs=dbc.executeQuery(Str);
		int x=0;
		int y=0;
		Float k=null;
		Float s=null;
		if (rs.next()){
			x=rs.getInt("Num");
			k=rs.getFloat("Je");
			Str="Select Sum(num)  From spthmxb where id="+ID;
			rs=dbc.executeQuery(Str);
			if (rs.next()){
				y=rs.getInt(1);	
				s=rs.getFloat(1);
				int z= x+y-num; 
				if (z<0) {
					isError=true;
					StrError=StrError+"数量错误!!! ！  <br>";	  	
				}	
			}  
		} 
		Str="Select Sum(je)  From spthmxb where id="+ID;
		rs=dbc.executeQuery(Str);
		if (rs.next()){
			s=rs.getFloat(1);
		}
		je=dj*num;   
		if (!isError) {	
			Str="Update spthmxb set djbh="+djbh+",num="+num+",dj="+dj+",je="+je+"  where id="+ID;
			dbc.executeUpdate(Str);
			je=k+s-dj*num;
			num=x+y-num;

			Str="Update kcb set Num="+num+" ,Je="+je+" where wpbh="+wpbh+" and ckbh="+ckid;
			dbc.executeUpdate(Str);    
		}
		dbc.close();
	}

	public void Add(HttpServletRequest request) throws Exception {
		djbh=StrFun.getInt(request,"djbh"); 
		wpbh=StrFun.getInt(request,"wpbh"); 
		num=StrFun.getInt(request,"num"); 
		dj=StrFun.getFloat(request,"dj"); 
		je=dj*num; 

		if (num<=0){
			isError=true;
			StrError=StrError+"数量错误!!!  <br>";
		}
		String ckid=request.getParameter("ckid");
		String Str="Select * From kcb where wpbh="+wpbh+" and ckbh="+ckid;
		DBConnect dbc  = new DBConnect();
		ResultSet rs=dbc.executeQuery(Str);
		if (rs.next()){
			int x=rs.getInt("Num");
			if (num>x) {
				isError=true;
				StrError=StrError+ "数量太大！  <br>";	  	
			}
		}else{
			isError=true;
			StrError=StrError+ "库中没有此物品！  <br>";		
		}	
		if (!isError) {
			Str="Insert into spthmxb(Tdate,djbh,wpbh,num,dj,je) values(now(),"+djbh+","+wpbh+","+num+","+dj+","+je+")";
			dbc.executeUpdate(Str);

			Str="Update kcb set Num=Num-"+num+",je=je-"+je+" where wpbh="+wpbh+" and ckbh="+ckid;
			dbc.executeUpdate(Str);

		}
		dbc.close();  
	}

	public void Del(HttpServletRequest request) throws Exception {
		ID=StrFun.getInt(request,"del"); 
		int ckid=StrFun.getInt(request,"ckid"); 
		DBConnect dbc  = new DBConnect();
		String Str="Select * From spthmxb where id="+ID;
		ResultSet rs=dbc.executeQuery(Str);
		if (rs.next()){
			int x=rs.getInt("num");
			Float y=rs.getFloat("je");
			wpbh=rs.getInt("wpbh");
			Str="Select * From kcb where wpbh="+wpbh+" and ckbh="+ckid;
			rs=dbc.executeQuery(Str);	
			if (rs.next()){  
				num=rs.getInt("num");
				je=rs.getFloat("je");
				num=num+x;
				je=je+y;
				if (num<0) {
					isError=true;
					StrError=StrError+"库存中的数量不够！ <br>";	  	
				}
			}  	  
		} 		 
		if (!isError){    	
			Str="Delete From spthmxb  where id="+ID;
			dbc.executeUpdate(Str);

			Str="Update kcb set Num="+num+",Je="+je+" where wpbh="+wpbh+" and ckbh="+ckid;
			dbc.executeUpdate(Str);
		}

		dbc.close();  

	}
}