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 csb{
  private int ID;
  private String csbh;
  private String csname;
  private String csjc;
  private String name;
  private String zw;
  private String tybh;
  private String address;
  private String fp;
  private String tel;
  private String tax;
  private String email;
  private String memo;
  public void csb(){}
  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  getCsbh() {
    return csbh;
  }
  public void setCsbh(String anew) {
    this.csbh=anew;
  }
  public String  getCsname() {
    return csname;
  }
  public void setCsname(String anew) {
    this.csname=anew;
  }
  public String  getCsjc() {
    return csjc;
  }
  public void setCsjc(String anew) {
    this.csjc=anew;
  }
  public String  getName() {
    return name;
  }
  public void setName(String anew) {
    this.name=anew;
  }
  public String  getZw() {
    return zw;
  }
  public void setZw(String anew) {
    this.zw=anew;
  }
  public String  getTybh() {
    return tybh;
  }
  public void setTybh(String anew) {
    this.tybh=anew;
  }
  public String  getAddress() {
    return address;
  }
  public void setAddress(String anew) {
    this.address=anew;
  }
  public String  getFp() {
    return fp;
  }
  public void setFp(String anew) {
    this.fp=anew;
  }
  public String  getTel() {
    return tel;
  }
  public void setTel(String anew) {
    this.tel=anew;
  }
  public String  getTax() {
    return tax;
  }
  public void setTax(String anew) {
    this.tax=anew;
  }
  public String  getEmail() {
    return email;
  }
  public void setEmail(String anew) {
    this.email=anew;
  }
  public String  getMemo() {
    return memo;
  }
  public void setMemo(String anew) {
    this.memo=anew;
  }
  public boolean excute() throws Exception {
	   String Str="Select * From csb 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"); 
     csbh=rs.getString("csbh"); 
     csname=rs.getString("csname"); 
     csjc=rs.getString("csjc"); 
     name=rs.getString("name"); 
     zw=rs.getString("zw"); 
     tybh=rs.getString("tybh"); 
     address=rs.getString("address"); 
     fp=rs.getString("fp"); 
     tel=rs.getString("tel"); 
     tax=rs.getString("tax"); 
     email=rs.getString("email"); 
     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"); 
   csbh=StrFun.getString(request,"csbh"); 
   csname=StrFun.getString(request,"csname"); 
   csjc=StrFun.getString(request,"csjc"); 
   name=StrFun.getString(request,"name"); 
   zw=StrFun.getString(request,"zw"); 
   tybh=StrFun.getString(request,"tybh"); 
   address=StrFun.getString(request,"address"); 
   fp=StrFun.getString(request,"fp"); 
   tel=StrFun.getString(request,"tel"); 
   tax=StrFun.getString(request,"tax"); 
   email=StrFun.getString(request,"email"); 
   memo=StrFun.getString(request,"memo"); 
   String Str="Update csb set csbh='"+csbh+"' ,csname='"+csname+"' ,csjc='"+csjc+"' ,name='"+name+"' ,zw='"+zw+"' ,tybh='"+tybh+"' ,address='"+address+"' ,fp='"+fp+"' ,tel='"+tel+"' ,tax='"+tax+"' ,email='"+email+"' ,memo='"+memo+"'  where id="+ID;
   DBConnect dbc  = new DBConnect();
   dbc.executeUpdate(Str);
   dbc.close();
    }
  public void Add(HttpServletRequest request) throws Exception {
   csbh=StrFun.getString(request,"csbh"); 
   csname=StrFun.getString(request,"csname"); 
   csjc=StrFun.getString(request,"csjc"); 
   name=StrFun.getString(request,"name"); 
   zw=StrFun.getString(request,"zw"); 
   tybh=StrFun.getString(request,"tybh"); 
   address=StrFun.getString(request,"address"); 
   fp=StrFun.getString(request,"fp"); 
   tel=StrFun.getString(request,"tel"); 
   tax=StrFun.getString(request,"tax"); 
   email=StrFun.getString(request,"email"); 
   memo=StrFun.getString(request,"memo"); 
   String Str="Insert into csb(csbh,csname,csjc,name,zw,tybh,address,fp,tel,tax,email,memo) values('"+csbh+"','"+csname+"','"+csjc+"','"+name+"','"+zw+"','"+tybh+"','"+address+"','"+fp+"','"+tel+"','"+tax+"','"+email+"','"+memo+"')";
   DBConnect dbc  = new DBConnect();
   dbc.executeUpdate(Str);
   dbc.close();
    }
  public void Del() throws Exception {
    String Str="Delete From csb where Id="+ID;
    DBConnect dbc  = new DBConnect();
    dbc.executeUpdate(Str);
    dbc.close();
   }

  }