pricelimit.java

ERO系统.针对生产型、分销型、服务型企业等不同的行业特点

/*
 *this file is part of nseer erp
 *Copyright (C)2006-2010 Nseer(Beijing) Technology co.LTD/http://www.nseer.com 
 *
 *This program is free software; you can redistribute it and/or
 *modify it under the terms of the GNU General Public License
 *as published by the Free Software Foundation; either
 *version 2 of the License, or (at your option) any later version.
 */
package include.auto_execute;

import java.sql.*;
import include.nseer_db.*;
import javax.servlet.*;

public class PriceLimit{

    private nseer_db_backup nseer_db;
	private nseer_db_backup nseer_db1;
    private ResultSet rs=null;
    public void price(ServletContext dbApplication) {
		try{
			nseer_db_backup db=new nseer_db_backup(dbApplication);
			if(db.conn("mysql")){
		String sqldb="show databases";
		ResultSet rsdb=db.executeQuery(sqldb);
		while(rsdb.next()){
			if(rsdb.getString("database").equals("ondemand1")){
			nseer_db=new nseer_db_backup(dbApplication);
			nseer_db1=new nseer_db_backup(dbApplication);
		if(nseer_db.conn(rsdb.getString("database"))&&nseer_db1.conn(rsdb.getString("database"))){
		String sql3 = "update design_file set price_alarm_tag='0'";
 		nseer_db.executeUpdate(sql3);
		String sql4 = "select * from design_config_public_char where kind='priceAlarm'";
 		ResultSet rs4=nseer_db.executeQuery(sql4);
		
 		double rate=0.0d;
 		if(rs4.next()){
			rate=Double.parseDouble(rs4.getString("type_name"))/100;
			
		}
		
 		String sql = "select * from design_file where check_tag='1'";
 		rs=nseer_db1.executeQuery(sql);
 		while(rs.next()){
		 double price_odds=rs.getDouble("cost_price")-rs.getDouble("real_cost_price");
		 if(Math.abs(price_odds/rs.getDouble("cost_price"))>=rate){
 		String sql2 = "update design_file set price_alarm_tag='1' where id='"+rs.getString("id")+"'";
 		nseer_db.executeUpdate(sql2);
			}
					}
	nseer_db.close();
	nseer_db1.close();
	} else {
				System.out.println("i am sorry!");
 		}
			}
		}
		db.close();
		} else {
				System.out.println("i am sorry!");
 		}
	 		} catch (Exception ex) {
				ex.printStackTrace();
 		}
	}
}