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 qydb{
  private int ID;
  private String djbh;
  private int yck;
  private int mck;
  private String Fdate;
  private int ygbh;
  private String memo;
  private boolean isError=false;
  private String StrError="";
  public void qydb(){}
  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 String  getDjbh() {
    return djbh;
  }
  public void setDjbh(String anew) {
    this.djbh=anew;
  }
  public int  getYck() {
    return yck;
  }
  public void setYck(int anew) {
    this.yck=anew;
  }
  public int  getMck() {
    return mck;
  }
  public void setMck(int anew) {
    this.mck=anew;
  }
  public String  getFdate() {
    return Fdate;
  }
  public void setFdate(String anew) {
    this.Fdate=anew;
  }
  public int  getYgbh() {
    return ygbh;
  }
  public void setYgbh(int anew) {
    this.ygbh=anew;
  }
  public String  getMemo() {
    return memo;
  }
  public void setMemo(String anew) {
    this.memo=anew;
  }

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

  public boolean excute() throws Exception {
	   String Str="Select * From qydb 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.getString("djbh"); 
     yck=rs.getInt("yck"); 
     mck=rs.getInt("mck"); 
     Fdate=rs.getString("Fdate"); 
     ygbh=rs.getInt("ygbh"); 
     memo=rs.getString("memo"); 
	  }
    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.getString(request,"djbh"); 
   yck=StrFun.getInt(request,"yck"); 
   mck=StrFun.getInt(request,"mck"); 
   Fdate=StrFun.getString(request,"Fdate"); 
   ygbh=StrFun.getInt(request,"ygbh"); 
   memo=StrFun.getString(request,"memo"); 
   if (yck!=mck){ 
	   String Str="Select * From qydb where djbh='"+djbh+"'";
	   DBConnect dbc  = new DBConnect();
	   ResultSet rs=dbc.executeQuery(Str);
	   if (rs.next()){
	      isError=true;
	      StrError=StrError+"已有相同單據號，請重新編號！  <br>";	  	
	   }
	   else{
       Str="Update qydb set djbh='"+djbh+"' ,yck="+yck+" ,mck="+mck+" ,Fdate='"+Fdate+"' ,ygbh="+ygbh+" ,memo='"+memo+"'  where id="+ID;
	   dbc.executeUpdate(Str);
	   }
	  // rs.close();
	   dbc.close();}
	else{
	  isError=true;
	  StrError=StrError+"源倉庫與目的倉庫相同，不能進行調撥！  <br>";	  	
		}   
   } 
   
  public void Add(HttpServletRequest request) throws Exception {
   djbh=StrFun.getString(request,"djbh"); 
   yck=StrFun.getInt(request,"yck"); 
   mck=StrFun.getInt(request,"mck"); 
   Fdate=StrFun.getString(request,"Fdate"); 
   ygbh=StrFun.getInt(request,"ygbh"); 
   memo=StrFun.getString(request,"memo");
   if (yck!=mck){ 
	   String Str="Select * From qydb where djbh='"+djbh+"'";
	   DBConnect dbc  = new DBConnect();
	   ResultSet rs=dbc.executeQuery(Str);
	   if (rs.next()){
	      isError=true;
	      StrError=StrError+"已有相同單據號，請重新編號！  <br>";	  	
	   }
	   else{
	   Str="Insert into qydb(djbh,yck,mck,Fdate,ygbh,memo) values('"+djbh+"',"+yck+","+mck+",'"+Fdate+"',"+ygbh+",'"+memo+"')";
	   dbc.executeUpdate(Str);
	   }
	  // rs.close();
	   dbc.close();}
	else{
	  isError=true;
	  StrError=StrError+"源倉庫與目的倉庫相同，不能進行調撥！  <br>";	  	
		}   
   } 
    
  public void Del(HttpServletRequest request) throws Exception {
    ID=StrFun.getInt(request,"id"); 
    String Str="Select * From qydbmxb where djbh="+ID;
    DBConnect dbc  = new DBConnect();
	ResultSet rs=dbc.executeQuery(Str);
	if (rs.next()){
   	      isError=true;
   	      StrError=StrError+"需先將明細表中數據刪除后方可進行該項操作！ <br>";	  	
	    }
	else{    
    Str="Delete From qydb where Id="+ID;
    dbc.executeUpdate(Str);}
    dbc.close();
   }

  }