repair.java

jsp开发的固定资产管理系统

/**
 *  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 Repair {

	public String AssetID, FailureReason, RepairStatus, Remark;

	public java.sql.Date RepairDate;

	public int RepairNO, AssetNum, RepairMoney;

	public Repair() {
	};

	public String getAssetID() {
		return AssetID;
	}

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

	public String getFailureReason() {
		return FailureReason;
	}

	public void setFailureReason(String s) {
		this.FailureReason = s;
	}

	public String getRepairStatus() {
		return RepairStatus;
	}

	public void setRepairStatus(String s) {
		this.RepairStatus = s;
	}

	public String getRemark() {
		return Remark;
	}

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

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

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

	public String getRepairNO() {
		return DataConvert.IntToStr(RepairNO);
	}

	public void setRepairNO(int i) {
		this.RepairNO = i;
	}

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

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

	public String getRepairMoney() {
		return DataConvert.IntToStr(RepairMoney);
	}

	public void setRepairMoney(int i) {
		this.RepairMoney = i;
	}

	/*
	 * Find repair by No
	 */
	public static Repair FindByNO(String _RepairNO) {
		DBConnect dbc = null;
		Repair repair = new Repair();
		try {
			dbc = new DBConnect();
			dbc.prepareStatement("SELECT * FROM repair WHERE RepairNO = ?");
			dbc.setInt(1, DataConvert.StrToInt(_RepairNO));
			ResultSet rs = dbc.executeQuery();
			if (rs.next()) {
				repair.setRepairNO(rs.getInt("RepairNO"));
				repair.setAssetID(rs.getString("AssetID"));
				repair.setAssetNum(rs.getInt("AssetNum"));
				repair.setRepairDate(rs.getString("RepairDate"));
				repair.setFailureReason(rs.getString("FailureReason"));
				repair.setRepairStatus(rs.getString("RepairStatus"));
				repair.setRepairMoney(rs.getInt("RepairMoney"));
				repair.setRemark(rs.getString("Remark"));
			} else {
				repair = null;
			}
		} catch (Exception e) {
			System.err.println(e);
		} finally {
			try {
				dbc.close();
			} catch (Exception e) {
				e.printStackTrace();
				repair = null;
			}
		}
		return repair;
	}

	/*
	 * Add repair
	 */
	public static String Add(String _AssetID, String _AssetNum,
			String _RepairDate, String _FailureReason, String _RepairStatus,
			String _RepairMoney, String _Remark, String _UserName) {
		DBConnect dbc = null;
		try {
			dbc = new DBConnect();
			dbc
					.prepareStatement("INSERT INTO repair (AssetID,AssetNum,RepairDate,FailureReason,RepairStatus,"
							+ "RepairMoney,Remark) VALUES (?,?,?,?,?,?,?)");
			dbc.setString(1, _AssetID);
			dbc.setInt(2, DataConvert.StrToInt(_AssetNum));
			dbc.setDate(3, DataConvert.StrTosqlDate(_RepairDate));
			dbc.setString(4, _FailureReason);
			dbc.setString(5, _RepairStatus);
			dbc.setInt(6, DataConvert.StrToInt(_RepairMoney));
			dbc.setString(7, _Remark);
			dbc.executeUpdate();
			Log.Add(_UserName, "repair", "Add");
			dbc.close();
			return "1";
		} catch (Exception e) {
			System.err.println(e);
			return e.toString();
		}
	}

	/*
	 * Modify repair
	 */
	public static String Modify(String _RepairNO, String _AssetID,
			String _AssetNum, String _RepairDate, String _FailureReason,
			String _RepairStatus, String _RepairMoney, String _Remark,
			String _UserName) {
		DBConnect dbc = null;
		try {
			dbc = new DBConnect();
			dbc
					.prepareStatement("UPDATE repair SET AssetID=?,AssetNum=?,RepairDate=?,FailureReason=?,RepairStatus=?,RepairMoney=?,Remark=? WHERE RepairNO=?");
			dbc.setString(1, _AssetID);
			dbc.setInt(2, DataConvert.StrToInt(_AssetNum));
			dbc.setDate(3, DataConvert.StrTosqlDate(_RepairDate));
			dbc.setString(4, _FailureReason);
			dbc.setString(5, _RepairStatus);
			dbc.setInt(6, DataConvert.StrToInt(_RepairMoney));
			dbc.setString(7, _Remark);
			dbc.setInt(8, DataConvert.StrToInt(_RepairNO));
			dbc.executeUpdate();
			
			Log.Add(_UserName, "repair", "Modify");
			dbc.close();
			return "1";
		} catch (Exception e) {
			e.printStackTrace();
			return e.toString();
		}
	}

	/*
	 * Delete repair
	 */
	public static String Delete(String _RepairNO, String _UserName) {
		try {
			DBConnect dbc = new DBConnect();
			dbc.prepareStatement("DELETE FROM repair WHERE RepairNO=?");
			dbc.setInt(1, DataConvert.StrToInt(_RepairNO));
			dbc.executeUpdate();
			Log.Add(_UserName, "repair", "Delete");
			dbc.close();
			return "1";
		} catch (Exception e) {
			e.printStackTrace();
			return e.toString();
		}
	}

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

		String strSQL = "SELECT * FROM repair ORDER BY AssetID,RepairDate ASC";

		try {
			dbc = new DBConnect();
			dbc.prepareStatement(strSQL);
			ResultSet rs = dbc.executeQuery();
			while (rs.next()) {
				Repair repair = new Repair();
				repair.setRepairNO(rs.getInt("RepairNO"));
				repair.setAssetID(rs.getString("AssetID"));
				repair.setAssetNum(rs.getInt("AssetNum"));
				repair.setRepairDate(rs.getString("RepairDate"));
				repair.setFailureReason(rs.getString("FailureReason"));
				repair.setRepairStatus(rs.getString("RepairStatus"));
				repair.setRepairMoney(rs.getInt("RepairMoney"));
				repair.setRemark(rs.getString("Remark"));
				RepairVector.add(repair);
			}
		} catch (Exception e) {
			System.err.println(e);
		} finally {
			try {
				dbc.close();
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
		return RepairVector;
	}

}