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 cgmxb{
  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 cgmxb(){}
  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 cgmxb 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"); 
   wpbh=StrFun.getInt(request,"wpbh"); 
   num=StrFun.getInt(request,"num"); 
   dj=StrFun.getFloat(request,"dj"); 

    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 cgmxb 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 cgmxb 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();
   /*
   String Str="Update cgmxb set djbh="+djbh+",num="+num+" ,dj="+dj+" ,je="+je+"  where id="+ID;
   DBConnect dbc  = new DBConnect();
   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"); 
   
    if (num<=0){
   	  isError=true;
   	  StrError=StrError+"數量輸入錯誤  <br>";
   } 

    if (wpbh<=0){
   	  isError=true;
   	  StrError=StrError+"商品信息輸入錯誤  <br>";
   } 
   if (!isError){      
      je=dj*num; 
      String ckid=request.getParameter("ckid");
	  String Str="Insert into cgmxb(djbh,wpbh,num,dj,je) values("+djbh+","+wpbh+","+num+","+dj+","+je+")";
	  DBConnect dbc  = new DBConnect();
	  dbc.executeUpdate(Str);
	  Str="Select * From wpkcb where wpbh="+wpbh+" and ckbh="+ckid;
	  ResultSet rs=dbc.executeQuery(Str);
	  if (rs.next())
	  Str="Update wpkcb set Num=Num+"+num+" where wpbh="+wpbh+" and ckbh="+ckid;
	  else 
	  Str="insert into wpkcb (ckbh,wpbh,num) values("+ckid+","+wpbh+","+num+")";	
	  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 cgmxb 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 cgmxb  where Id="+ID;
      dbc.executeUpdate(Str);
    
      Str="Update wpkcb set Num="+num+" where wpbh="+wpbh+" and ckbh="+ckid;
	  dbc.executeUpdate(Str);
    }
	
	dbc.close();  
   
   /* String Str="Delete From cgmxb where Id="+ID;
    DBConnect dbc  = new DBConnect();
    dbc.executeUpdate(Str);
    dbc.close();*/
   }

  }