package JXC.web;
import JXC.Com.DBConnect;
import java.lang.String;
import JXC.util.StrFun;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
/**
 * Title:       明細單信息
 * Description:
 * Copyright:    Copyright (c) 2003
 * Company:      torch
 * @author:		 wind
 * @version 1.0
 */
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 void spthmxb(){}
  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 wpkcb where wpbh="+wpbh+" and ckbh="+ckid;
	DBConnect dbc  = new DBConnect();
	ResultSet rs=dbc.executeQuery(Str);
	int x=0;
	int y=0;
	if (rs.next()){
	  x=rs.getInt("Num");
	  Str="Select Sum(num)  From spthmxb where id="+ID;
      rs=dbc.executeQuery(Str);
      if (rs.next()){
	    y=rs.getInt(1);	
	    int z= x+y-num; 
	    if (z<0) {
   	      isError=true;
   	      StrError=StrError+"輸入的數量大于庫存的數量！  <br>";	  	
	    }	
	  }  
	} 
	je=dj*num;   
   if (!isError) {	
     Str="Update spthmxb set djbh="+djbh+",num="+num+",dj="+dj+",je="+je+"  where id="+ID;
     dbc.executeUpdate(Str);
     num=x+y-num;
     Str="Update wpkcb set Num="+num+" where wpbh="+wpbh+" and ckbh="+ckid;
	 dbc.executeUpdate(Str);    
   }
  // rs.close();  
   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 wpkcb 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(djbh,wpbh,num,dj,je) values("+djbh+","+wpbh+","+num+","+dj+","+je+")";
     dbc.executeUpdate(Str);
  
     Str="Update wpkcb set Num=Num-"+num+" 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");
	  wpbh=rs.getInt("wpbh");
      Str="Select * From wpkcb where wpbh="+wpbh+" and ckbh="+ckid;
	  rs=dbc.executeQuery(Str);	
	  if (rs.next()){  
	    num=rs.getInt("num");
	    num=num+x;
	    if (num<0) {
   	      isError=true;
   	      StrError=StrError+"庫存中的數量不夠！ <br>";	  	
	    }
	  }  	  
	} 
	 
	if (!isError){    	
      Str="Delete From spthmxb where Id="+ID;
      dbc.executeUpdate(Str);
    
      Str="Update wpkcb set Num="+num+" where wpbh="+wpbh+" and ckbh="+ckid;
	  dbc.executeUpdate(Str);
    }
	
	dbc.close();  
   }

  }