/**
 *  Title  pams
 *  @author: dzc
 *  Company: hust
 *  Copyright: Copyright (c) 2005
 *  @version 1.0
 *  Date  :   2006-04
 *  Filename:Asset.java
 **/

package pams.asset;

import pams.database.DBConnect;
import pams.system.Log;
import pams.util.*;

import java.sql.*;
import java.util.*;

public class Asset {

	public String AssetID, AssetName, Type, SubType, Manufacturer, UseDept,
			UseStatus, PutAddress, AddType, SafeKeeping, ClearType, Remark;

	public java.sql.Date ProductDate, AddDate, ClearDate;

	public int ForecastLife, AssetNum;

	public Asset() {
	};

	public String getAssetID() {
		return AssetID;
	}

	public void setAssetID(String s) {
		this.AssetID = s;
	}

	public String getAssetName() {
		return AssetName;
	}

	public void setAssetName(String s) {
		this.AssetName = s;
	}

	public String getType() {
		return Type;
	}

	public void setType(String s) {
		this.Type = s;
	}

	public String getSubType() {
		return SubType;
	}

	public void setSubType(String s) {
		this.SubType = s;
	}

	public String getManufacturer() {
		return Manufacturer;
	}

	public void setManufacturer(String s) {
		this.Manufacturer = s;
	}

	public String getUseDept() {
		return UseDept;
	}

	public void setUseDept(String s) {
		this.UseDept = s;
	}

	public String getUseStatus() {
		return UseStatus;
	}

	public void setUseStatus(String s) {
		this.UseStatus = s;
	}

	public String getPutAddress() {
		return PutAddress;
	}

	public void setPutAddress(String s) {
		this.PutAddress = s;
	}

	public String getAddType() {
		return AddType;
	}

	public void setAddType(String s) {
		this.AddType = s;
	}

	public String getSafeKeeping() {
		return SafeKeeping;
	}

	public void setSafeKeeping(String s) {
		this.SafeKeeping = s;
	}

	public String getClearType() {
		return ClearType;
	}

	public void setClearType(String s) {
		this.ClearType = s;
	}

	public String getRemark() {
		return Remark;
	}

	public void setRemark(String s) {
		this.Remark = s;
	}

	public String getProductDate() {
		if (this.ProductDate != null)
			return DataConvert.sqlDateToStr(ProductDate);
		else
			return "";
	}

	public void setProductDate(String strBir) {
		if (strBir != null)
			this.ProductDate = DataConvert.StrTosqlDate(strBir);
		else
			this.ProductDate = null;
	}

	public String getAddDate() {
		if (this.AddDate != null)
			return DataConvert.sqlDateToStr(AddDate);
		else
			return "";
	}

	public void setAddDate(String strBir) {
		if (strBir != null)
			this.AddDate = DataConvert.StrTosqlDate(strBir);
		else
			this.AddDate = null;
	}

	public String getClearDate() {
		if (this.ClearDate != null)
			return DataConvert.sqlDateToStr(ClearDate);
		else
			return "";
	}

	public void setClearDate(String strBir) {
		if (strBir != null)
			this.ClearDate = DataConvert.StrTosqlDate(strBir);
		else
			this.ClearDate = null;
	}

	public String getForecastLife() {
		return DataConvert.IntToStr(ForecastLife);
	}

	public void setForecastLife(int i) {
		this.ForecastLife = i;
	}

	public String getAssetNum() {
		return DataConvert.IntToStr(AssetNum);
	}

	public void setAssetNum(int i) {
		this.AssetNum = i;
	}

	/*
	 * Find Asset by ID
	 */
	public static Asset FindByID(String _AssetID) {
		DBConnect dbc = null;
		Asset asset = new Asset();
		try {
			dbc = new DBConnect();
			dbc.prepareStatement("SELECT * FROM asset WHERE AssetID = ?");
			dbc.setString(1, _AssetID);
			ResultSet rs = dbc.executeQuery();
			if (rs.next()) {
				asset.setAssetID(rs.getString("AssetID"));
				asset.setAssetName(rs.getString("AssetName"));
				asset.setType(rs.getString("Type"));
				asset.setSubType(rs.getString("SubType"));
				asset.setManufacturer(rs.getString("Manufacturer"));
				asset.setProductDate(rs.getString("ProductDate"));
				asset.setAddDate(rs.getString("AddDate"));
				asset.setForecastLife(rs.getInt("ForecastLife"));
				asset.setAssetNum(rs.getInt("AssetNum"));
				asset.setUseDept(rs.getString("UseDept"));
				asset.setUseStatus(rs.getString("UseStatus"));
				asset.setPutAddress(rs.getString("PutAddress"));
				asset.setAddType(rs.getString("AddType"));
				asset.setSafeKeeping(rs.getString("SafeKeeping"));
				asset.setClearDate(rs.getString("ClearDate"));
				asset.setClearType(rs.getString("ClearType"));
				asset.setRemark(rs.getString("Remark"));
			} else {
				asset = null;
			}
		} catch (Exception e) {
			System.err.println(e);
		} finally {
			try {
				dbc.close();
			} catch (Exception e) {
				e.printStackTrace();
				asset = null;
			}
		}
		return asset;
	}

	/*
	 * Add Asset
	 */
	public static String Add(String _AssetID, String _AssetName, String _Type,
			String _SubType, String _Manufacturer, String _ProductDate,
			String _AddDate, String _ForecastLife, String _AssetNum,
			String _UseDept, String _UseStatus, String _PutAddress,
			String _AddType, String _SafeKeeping, String _Remark,
			String _UserName) {
		DBConnect dbc = null;
		try {
			dbc = new DBConnect();
			dbc
					.prepareStatement("INSERT INTO asset (AssetID,AssetName,Type,SubType,Manufacturer,"
							+ "ProductDate,AddDate,ForecastLife,AssetNum,UseDept,UseStatus,PutAddress,AddType,"
							+ "SafeKeeping,Remark) VALUES "
							+ "(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
			dbc.setString(1, _AssetID);
			dbc.setString(2, _AssetName);
			dbc.setString(3, _Type);
			dbc.setString(4, _SubType);
			dbc.setString(5, _Manufacturer);
			dbc.setDate(6, DataConvert.StrTosqlDate(_ProductDate));
			dbc.setDate(7, DataConvert.StrTosqlDate(_AddDate));
			dbc.setInt(8, DataConvert.StrToInt(_ForecastLife));
			dbc.setInt(9, DataConvert.StrToInt(_AssetNum));
			dbc.setString(10, _UseDept);
			dbc.setString(11, _UseStatus);
			dbc.setString(12, _PutAddress);
			dbc.setString(13, _AddType);
			dbc.setString(14, _SafeKeeping);
			dbc.setString(15, _Remark);
			dbc.executeUpdate();
			Log.Add(_UserName, "asset", "Add");
			dbc.close();
			return "1";

		} catch (Exception e) {
			System.err.println(e);
			return e.toString();
		}
	}

	/*
	 * Modify Asset
	 */

	public static String Modify(String _AssetID, String _AssetName,
			String _Type, String _SubType, String _Manufacturer,
			String _ProductDate, String _AddDate, String _ForecastLife,
			String _AssetNum, String _UseDept, String _UseStatus,
			String _PutAddress, String _AddType, String _SafeKeeping,
			String _Remark, String _UserName) {
		DBConnect dbc = null;
		try {
			dbc = new DBConnect();
			dbc
					.prepareStatement("UPDATE asset SET AssetName=?,Type=?,SubType=?,Manufacturer=?,"
							+ "ProductDate=?,AddDate=?,ForecastLife=?,AssetNum=?,UseDept=?,UseStatus=?,PutAddress=?,AddType=?,"
							+ "SafeKeeping=?,Remark=? WHERE AssetID=?");
			dbc.setString(1, _AssetName);
			dbc.setString(2, _Type);
			dbc.setString(3, _SubType);
			dbc.setString(4, _Manufacturer);
			dbc.setDate(5, DataConvert.StrTosqlDate(_ProductDate));
			dbc.setDate(6, DataConvert.StrTosqlDate(_AddDate));
			dbc.setInt(7, DataConvert.StrToInt(_ForecastLife));
			dbc.setInt(8, DataConvert.StrToInt(_AssetNum));
			dbc.setString(9, _UseDept);
			dbc.setString(10, _UseStatus);
			dbc.setString(11, _PutAddress);
			dbc.setString(12, _AddType);
			dbc.setString(13, _SafeKeeping);
			dbc.setString(14, _Remark);
			dbc.setString(15, _AssetID);
			dbc.executeUpdate();
			Log.Add(_UserName, "asset", "Modify");
			dbc.close();
			return "1";
		} catch (Exception e) {
			e.printStackTrace();
			return e.toString();
		}
	}

	/*
	 * Delete Asset
	 */
	public static String Delete(String _AssetID,String _UserName) {
		try {
			DBConnect dbc = new DBConnect();
			dbc.prepareStatement("DELETE FROM asset WHERE AssetID=?");
			dbc.setString(1, _AssetID);
			dbc.executeUpdate();
			Log.Add(_UserName, "asset", "Delete");
			dbc.close();
			return "1";
		} catch (Exception e) {
			e.printStackTrace();
			return e.toString();
		}
	}

	/*
	 * the Asset exists?
	 */
	public static boolean IsExist(String _AssetID) throws Exception {
		DBConnect dbc = null;
		boolean IsExist = false;
		try {
			dbc = new DBConnect();
			dbc.prepareStatement("SELECT * FROM asset WHERE AssetID=?");
			dbc.setString(1, _AssetID);
			ResultSet rs = dbc.executeQuery();
			if (!rs.next()) {
				IsExist = false;
			} else {
				IsExist = true;
			}
		} catch (Exception e) {
			System.err.println(e);
		} finally {
			try {
				dbc.close();
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
		return IsExist;
	}

	/*
	 * List All Asset
	 */
	public static Vector ListAll() {
		DBConnect dbc = null;
		Vector AssetVector = new Vector();

		String strSQL = "SELECT * FROM asset ORDER BY AssetID ASC";

		try {
			dbc = new DBConnect();
			dbc.prepareStatement(strSQL);
			ResultSet rs = dbc.executeQuery();
			while (rs.next()) {
				Asset asset = new Asset();
				asset.setAssetID(rs.getString("AssetID"));
				asset.setAssetName(rs.getString("AssetName"));
				asset.setType(rs.getString("Type"));
				asset.setSubType(rs.getString("SubType"));
				asset.setManufacturer(rs.getString("Manufacturer"));
				asset.setProductDate(rs.getString("ProductDate"));
				asset.setAddDate(rs.getString("AddDate"));
				asset.setForecastLife(rs.getInt("ForecastLife"));
				asset.setAssetNum(rs.getInt("AssetNum"));
				asset.setUseDept(rs.getString("UseDept"));
				asset.setUseStatus(rs.getString("UseStatus"));
				asset.setPutAddress(rs.getString("PutAddress"));
				asset.setAddType(rs.getString("AddType"));
				asset.setSafeKeeping(rs.getString("SafeKeeping"));
				asset.setClearDate(rs.getString("ClearDate"));
				asset.setClearType(rs.getString("ClearType"));
				asset.setRemark(rs.getString("Remark"));
				AssetVector.add(asset);
			}
		} catch (Exception e) {
			System.err.println(e);
		} finally {
			try {
				dbc.close();
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
		return AssetVector;
	}

	/*
	 * Clear Asset
	 */
	public static String Clear(String _AssetID, String _ClearDate,String _ClearType,String _UserName) {
		DBConnect dbc = null;
		try {
			dbc = new DBConnect();
			dbc.prepareStatement("UPDATE asset SET ClearDate=?,ClearType=? WHERE AssetID=?");
			dbc.setDate(1, DataConvert.StrTosqlDate(_ClearDate));
			dbc.setString(2, _ClearType);
			dbc.setString(3, _AssetID);
			dbc.executeUpdate();
			Log.Add(_UserName, "asset", "Modify");
			dbc.close();
			return "1";
		} catch (Exception e) {
			e.printStackTrace();
			return e.toString();
		}
	}

}