dealwith_ok.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 qcs.other;

import javax.servlet.http.*;
import javax.servlet.jsp.*;
import javax.servlet.*;
import java.sql.*;
import java.text.SimpleDateFormat;

import include.get_rate_from_ID.getRateFromID;
import include.nseer_db.*;
import include.nseer_cookie.*;
import java.io.*;
import java.util.*;
import validata.ValidataRecord;
import com.jspsmart.upload.*;


import include.nseer_cookie.counter;

public class dealwith_ok extends HttpServlet{

public synchronized void service(HttpServletRequest request,HttpServletResponse response) throws IOException,ServletException{
HttpSession dbSession=request.getSession();
JspFactory _jspxFactory=JspFactory.getDefaultFactory();
PageContext pageContext = _jspxFactory.getPageContext(this,request,response,"",true,8192,true);
ServletContext dbApplication=dbSession.getServletContext();
ValidataRecord vr = new ValidataRecord();
getRateFromID getRateFromID= new getRateFromID();

try{
//实例化

HttpSession session=request.getSession();
ServletContext context=session.getServletContext();
String path=context.getRealPath("/");
counter count=new counter(dbApplication);
nseer_db_backup crm_db = new nseer_db_backup(dbApplication);
nseer_db_backup stock_db = new nseer_db_backup(dbApplication);
nseer_db_backup qcs_db = new nseer_db_backup(dbApplication);
java.util.Date now1 = new java.util.Date();
SimpleDateFormat formatter1 = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
SimpleDateFormat formatter = new SimpleDateFormat("yyyyMMdd");
String time=formatter1.format(now1);
String time1=formatter.format(now1);
if(qcs_db.conn((String)dbSession.getAttribute("unit_db_name"))&&crm_db.conn((String)dbSession.getAttribute("unit_db_name"))&&stock_db.conn((String)dbSession.getAttribute("unit_db_name"))){
try{
String qcs_id = request.getParameter("qcs_id");
String product_id = request.getParameter("product_id");
String product_name = request.getParameter("product_name");
String dealwith_type = request.getParameter("dealwith_type");
String provider = request.getParameter("provider");
String dealwith_tag = request.getParameter("dealwith_tag");
String amount = request.getParameter("qcs_amount");
int num=1;
String sqlq="update qcs_other set dealwith_tag='"+dealwith_tag+"' where qcs_id='"+qcs_id+"'";
qcs_db.executeUpdate(sqlq);
if(provider!=null&&!provider.equals("")){
String provider_id =Divide.getId(provider);
String provider_name =Divide.getName(provider);

if(dealwith_type.split("/")[0].equals("01")){
	String sql="select * from purchase_file where provider_id='"+provider_id+"'";
	ResultSet rs=qcs_db.executeQuery(sql);
	if(rs.next()){
		String chain_id=rs.getString("chain_id");
		String chain_name=rs.getString("chain_name");
		String provider_class=rs.getString("provider_class");
		String provider_tel1=rs.getString("provider_tel1");
		String provider_web=rs.getString("provider_web");
		String type=rs.getString("type");
		String contact_person1=rs.getString("contact_person1");
		sql="select product_providers_recommend_id from purchase_product_providers_recommend where product_id='"+product_id+"' and (check_tag='1' or check_tag='0')";
		List rsList = GetWorkflow.getList(qcs_db, "purchase_config_workflow", "03");
		rs=qcs_db.executeQuery(sql);
		if(rs.next()){
			String product_providers_recommend_id=rs.getString("product_providers_recommend_id");
			sql="select id from purchase_product_providers_recommend_details where product_providers_recommend_id='"+product_providers_recommend_id+"' and provider_id='"+provider_id+"'";
			rs=qcs_db.executeQuery(sql);
			if(!rs.next()){
				sql="select details_number from purchase_product_providers_recommend_details where product_providers_recommend_id='"+product_providers_recommend_id+"' order by details_number desc";
				rs=qcs_db.executeQuery(sql);
				if(rs.next()){
					int details_number=rs.getInt("details_number")+1;
					sql = "insert into purchase_product_providers_recommend_details(product_providers_recommend_id,details_number,provider_id,provider_name,provider_class,provider_tel,provider_web,type,contact_person) values ('"+product_providers_recommend_id+"','"+details_number+"','"+provider_id+"','"+provider_name+"','"+provider_class+"','"+provider_tel1+"','"+provider_web+"','"+type+"','"+contact_person1+"')" ;
					qcs_db.executeUpdate(sql);			
				}
				sql="update purchase_product_providers_recommend set check_tag='0' where product_providers_recommend_id='"+product_providers_recommend_id+"'";
				qcs_db.executeUpdate(sql);				
				if(rsList.size()==0){
					sql="update purchase_product_providers_recommend set check_tag='1' where product_providers_recommend_ID='"+product_providers_recommend_id+"'";
					qcs_db.executeUpdate(sql);
				}else{
					sql="delete from purchase_workflow where object_ID='"+product_providers_recommend_id+"'";
					qcs_db.executeUpdate(sql) ;
					sql="update purchase_product_providers_recommend set check_tag='0' where product_providers_recommend_ID='"+product_providers_recommend_id+"'";
					qcs_db.executeUpdate(sql) ;
					Iterator ite=rsList.iterator();
					while(ite.hasNext()){
						String[] elem=(String[])ite.next();
						sql = "insert into purchase_workflow(config_id,object_ID,describe1,describe2) values ('"+elem[0]+"','"+product_providers_recommend_id+"','"+elem[1]+"','"+elem[2]+"')" ;
						qcs_db.executeUpdate(sql) ;
					}
				}
			}	
		}else{
			String product_providers_recommend_id=NseerId.getId("purchase/product_providers",(String)dbSession.getAttribute("unit_db_name"));
			String sqla="update design_file set recommend_provider_tag='1' where product_id='"+product_id+"'";
			qcs_db.executeUpdate(sqla);
			String sqlb = "insert into purchase_product_providers_recommend(product_providers_recommend_id,chain_id,chain_name,product_id,product_name,recommend_describe,register_time,recommender,register,check_tag,excel_tag) values ('"+product_providers_recommend_id+"','"+chain_id+"','"+chain_name+"','"+product_id+"','"+product_name+"','','"+time+"','','','0','2')" ;
			qcs_db.executeUpdate(sqlb) ;
			sqlb = "insert into purchase_product_providers_recommend_details(product_providers_recommend_id,details_number,provider_id,provider_name,provider_class,provider_tel,provider_web,type,contact_person) values ('"+product_providers_recommend_id+"','1','"+provider_id+"','"+provider_name+"','"+provider_class+"','"+provider_tel1+"','"+provider_web+"','"+type+"','"+contact_person1+"')" ;
			qcs_db.executeUpdate(sqlb);
			if(rsList.size()==0){
				sql="update purchase_product_providers_recommend set check_tag='1' where product_providers_recommend_ID='"+product_providers_recommend_id+"'";
				qcs_db.executeUpdate(sql) ;
			}else{
				Iterator ite=rsList.iterator();
				while(ite.hasNext()){
					String[] elem=(String[])ite.next();
					sql = "insert into purchase_workflow(config_id,object_ID,describe1,describe2) values ('"+elem[0]+"','"+product_providers_recommend_id+"','"+elem[1]+"','"+elem[2]+"')" ;
					qcs_db.executeUpdate(sql);
				}
			}
		}
	}
}else if(dealwith_type.split("/")[0].equals("02")){
String chain_id="";
String chain_name="";
String product_describe="";
	String customer_id =Divide.getId(provider);
	String customer_name =Divide.getName(provider);
	String order_id=NseerId.getId("crm/order",(String)dbSession.getAttribute("unit_db_name"));
	String sql3="select * from crm_file where customer_id='"+customer_id+"'";
	ResultSet rs=qcs_db.executeQuery(sql3);
	if(rs.next()){
		chain_id=rs.getString("chain_id");
		chain_name=rs.getString("chain_name");
	String sql = "insert into crm_order(order_id,chain_ID,chain_name,customer_id,customer_name,demand_contact_person_tel,demand_pay_time,register_time,sales_name,sales_ID,register,type,remark,check_tag,excel_tag) values ('"+order_id+"','"+chain_id+"','"+chain_name+"','"+customer_id+"','"+customer_name+"','"+rs.getString("contact_person1_office_tel")+"','','"+time+"','"+rs.getString("sales_name")+"','"+rs.getString("sales_ID")+"','','','','0','2')" ;
	qcs_db.executeUpdate(sql) ;
	}

	String id="";
	String sqlb="select id from crm_order where order_id='"+order_id+"'";
	rs=qcs_db.executeQuery(sqlb);