stock.java

进销存的库存处理类,继承此类,可以保证库存情况的调理正确性

package wp;


import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Hashtable;
import java.util.Vector;
import util.ShiWoConnection;


/**
 * 库存管理类
 *
 * @author huaxin
 */
public class Stock {

	private static Hashtable	gs	= null;

	public static Vector getStockInfos(Hashtable ht) {
		gs = ht;
		Vector vec = new Vector();
		String sql = "";
		try {
			{
				if (ht.size()>0) {
					sql = "select *,(lastvalue*realynum) lasttotalvalue,(beforevalue*realynum) beforetotalvalue   from stock "
							+ "  where  name like '%"
							+ ht.get("name")
							+ "%' "
							+ " 	 and   category like '%"
							+ ht.get("category") + "%' " + " 	 and   supplier like '%" + ht.get("supplier") + "%'  ";
					if ((!ht.get("startdate").equals("")) && (!ht.get("enddate").equals(""))) {
						sql += " 	 and   (buydate   BETWEEN '" + ht.get("startdate") + " 00:00:00' AND '"
								+ ht.get("enddate") + " 23:59:59') ";
					}
					if (!ht.get("code").equals("")) {
						sql += "     and code like '%" + ht.get("code") + "%' ";
					}
					if(!ht.get("numtotal").equals("")){
						sql += "     and numtotal =" + ht.get("numtotal");
					}
					if(!ht.get("lastvalue").equals("")){
						sql += "     and lastvalue =" + ht.get("lastvalue");
					}
					sql += "  order by buydate desc ";
				} else {
					sql = "select *,(lastvalue*realynum) lasttotalvalue,(beforevalue*realynum) beforetotalvalue  from stock order by buydate desc";
				}
			}
			// "编号", "商品名称", "数量", "售价", "类别", "供货商", "销售时间", "备注"
			Statement stmt = ShiWoConnection.getConnection().createStatement();
			ResultSet rs = stmt.executeQuery(sql);
			int index = 0;
			float beforetotalvalue = 0.0f;
			float lasttotalvalue = 0.0f;
			int totalcount = 0;
			while (rs.next()) {
				beforetotalvalue += Float.parseFloat(rs.getString("beforetotalvalue"));
				lasttotalvalue += Float.parseFloat(rs.getString("lasttotalvalue"));
				totalcount += Integer.parseInt(rs.getString("realynum"));
				Vector rec_vector = new Vector();
				rec_vector.addElement("  " + (++index) + "");
				if (rs.getString("code") != null)
					rec_vector.addElement(rs.getString("code"));
				else
					rec_vector.addElement("");
				if (rs.getString("name") != null)
					rec_vector.addElement(rs.getString("name"));
				else
					rec_vector.addElement("");
				if (rs.getString("numtotal") != null)
					rec_vector.addElement(rs.getString("numtotal"));
				else
					rec_vector.addElement("");
				if (rs.getString("realynum") != null)
					rec_vector.addElement(rs.getString("realynum"));
				else
					rec_vector.addElement("");
				if (rs.getString("beforevalue") != null)
					rec_vector.addElement(rs.getString("beforevalue"));
				else
					rec_vector.addElement("");
				if (rs.getString("lastvalue") != null)
					rec_vector.addElement(rs.getString("lastvalue"));
				else
					rec_vector.addElement("");
				if (rs.getString("category") != null)
					rec_vector.addElement(rs.getString("category"));
				else
					rec_vector.addElement("");
				if (rs.getString("supplier") != null)
					rec_vector.addElement(rs.getString("supplier"));
				else
					rec_vector.addElement("");
				if (rs.getString("buydate") != null)
					rec_vector.addElement(rs.getString("buydate"));
				else
					rec_vector.addElement("");
				if (rs.getString("remark") != null)
					rec_vector.addElement(rs.getString("remark"));
				else
					rec_vector.addElement("");
				if (rs.getString("id") != null)
					rec_vector.addElement(rs.getString("id"));
				else
					rec_vector.addElement("");
				vec.addElement(rec_vector);
				// 向量rec_vector加入向量vect中
			}
			if (vec.size() > 0) {
				Vector rec_vec = new Vector();
				rec_vec.addElement(" 统计");
				rec_vec.addElement("");
				rec_vec.addElement("");
				rec_vec.addElement("");
				rec_vec.addElement("总数:" + totalcount);
				rec_vec.addElement("进货金额:" + beforetotalvalue);
				rec_vec.addElement("销售金额:" + lasttotalvalue);
				rec_vec.addElement("");
				rec_vec.addElement("");
				rec_vec.addElement("");
				rec_vec.addElement("");
				rec_vec.addElement("");
				vec.addElement(rec_vec);// 向量rec_vec加入向量vect中,合计
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return vec;
	}

	public static Hashtable getHT() {
		return gs;
	}

	public static boolean deleteStock(String id) {
		try {
			Statement stmt = ShiWoConnection.getConnection().createStatement();
			stmt.execute("delete from stock where id='" + id + "'");
			return true;
		} catch (Exception e) {
			return false;
		}
	}
}