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 cgb{
  private int ID;
  private String djbh;
  private int csbh;
  private int ygbh;
  private int ckbh;
  private String Fdate;
  private float je;
  private int fkfs;
  private String memo;
  public void cgb(){}
  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  getCsbh() {
    return csbh;
  }
  public void setCsbh(int anew) {
    this.csbh=anew;
  }
  public int  getYgbh() {
    return ygbh;
  }
  public void setYgbh(int anew) {
    this.ygbh=anew;
  }
  public int  getCkbh() {
    return ckbh;
  }
  public void setCkbh(int anew) {
    this.ckbh=anew;
  }
  public String  getFdate() {
    return Fdate;
  }
  public void setFdate(String anew) {
    this.Fdate=anew;
  }
  public float  getJe() {
    return je;
  }
  public void setJe(float anew) {
    this.je=anew;
  }
  public int  getFkfs() {
    return fkfs;
  }
  public void setFkfs(int anew) {
    this.fkfs=anew;
  }
  public String  getMemo() {
    return memo;
  }
  public void setMemo(String anew) {
    this.memo=anew;
  }
  public boolean excute() throws Exception {
	   String Str="Select * From cgb 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"); 
     csbh=rs.getInt("csbh"); 
     ygbh=rs.getInt("ygbh"); 
     ckbh=rs.getInt("ckbh"); 
     Fdate=rs.getString("Fdate"); 
     je=rs.getFloat("je"); 
     fkfs=rs.getInt("fkfs"); 
     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"); 
   csbh=StrFun.getInt(request,"csbh"); 
   ygbh=StrFun.getInt(request,"ygbh"); 
   ckbh=StrFun.getInt(request,"ckbh"); 
   Fdate=StrFun.getString(request,"Fdate"); 
   je=0; 
   fkfs=StrFun.getInt(request,"fkfs"); 
   memo=StrFun.getString(request,"memo"); 
   String Str="Update cgb set djbh='"+djbh+"' ,csbh="+csbh+" ,ygbh="+ygbh+" ,ckbh="+ckbh+" ,Fdate='"+Fdate+"' ,je="+je+" ,fkfs="+fkfs+" ,memo='"+memo+"'  where id="+ID;
   DBConnect dbc  = new DBConnect();
   dbc.executeUpdate(Str);
   dbc.close();
    }
  public void Add(HttpServletRequest request) throws Exception {
   djbh=StrFun.getString(request,"djbh"); 
   csbh=StrFun.getInt(request,"csbh"); 
   ygbh=StrFun.getInt(request,"ygbh"); 
   ckbh=StrFun.getInt(request,"ckbh"); 
   Fdate=StrFun.getString(request,"Fdate"); 
   je=0; 
   fkfs=StrFun.getInt(request,"fkfs"); 
   memo=StrFun.getString(request,"memo"); 
   String Str="Insert into cgb(djbh,csbh,ygbh,ckbh,Fdate,je,fkfs,memo) values('"+djbh+"',"+csbh+","+ygbh+","+ckbh+",'"+Fdate+"',"+je+","+fkfs+",'"+memo+"')";
   DBConnect dbc  = new DBConnect();
   dbc.executeUpdate(Str);
   dbc.close();
    }
  public void Del() throws Exception {
    String Str="Delete From cgb where Id="+ID;
    DBConnect dbc  = new DBConnect();
    dbc.executeUpdate(Str);
    dbc.close();
   }

  }