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(); try { HttpSession session = request.getSession(); PrintWriter out = response.getWriter(); businessComment demo = new businessComment(); demo.setPath(request); Email mail = new Email(); nseer_db_backup1 design_db = new nseer_db_backup1(dbApplication); nseer_db_backup1 intrmanufacture_db = new nseer_db_backup1(dbApplication); if (design_db.conn((String) dbSession.getAttribute("unit_db_name")) && intrmanufacture_db.conn((String) dbSession.getAttribute("unit_db_name"))) { String kind_chain = request.getParameter("kind_chain"); String chain_id = Divide1.getId(kind_chain); String chain_name = Divide1.getName(kind_chain); String provider_ID = NseerId.getId("intrmanufacture/file", (String) dbSession.getAttribute("unit_db_name")); String intrmanufacturer = request.getParameter("intrmanufacturer"); String intrmanufacturer_ID = request.getParameter("intrmanufacturer_ID"); String provider_name = request.getParameter("provider_name"); String provider_address = request.getParameter("provider_address"); String type = request.getParameter("type"); String provider_class = request.getParameter("class1"); String used_provider_name = request.getParameter("used_provider_name"); String provider_bank = request.getParameter("provider_bank"); String provider_account = request.getParameter("provider_account"); String provider_web = request.getParameter("provider_web"); String provider_tel1 = request.getParameter("provider_tel1"); String provider_fax = request.getParameter("provider_fax"); String provider_postcode = request.getParameter("provider_postcode"); String contact_person1 = request.getParameter("contact_person1"); String contact_person1_department = request.getParameter("contact_person1_department"); String contact_person1_duty = request.getParameter("contact_person1_duty"); String contact_person1_sex = request.getParameter("contact_person1_sex"); String contact_person1_office_tel = request.getParameter("contact_person1_office_tel"); String contact_person1_home_tel = request.getParameter("contact_person1_home_tel"); String contact_person1_mobile = request.getParameter("contact_person1_mobile"); String contact_person1_email = request.getParameter("contact_person1_email"); String contact_person2 = request.getParameter("contact_person2"); String contact_person2_department = request.getParameter("contact_person2_department"); String contact_person2_duty = request.getParameter("contact_person2_duty"); String contact_person2_sex = request.getParameter("contact_person2_sex"); String contact_person2_office_tel = request.getParameter("contact_person2_office_tel"); String contact_person2_home_tel = request.getParameter("contact_person2_home_tel"); String contact_person2_mobile = request.getParameter("contact_person2_mobile"); String contact_person2_email = request.getParameter("contact_person2_email"); String register = request.getParameter("register"); String register_time = request.getParameter("register_time"); String bodyc = new String(request.getParameter("invoice_info").getBytes("UTF-8"), "UTF-8"); String invoice_info = exchange.toHtml(bodyc); String bodya = new String(request.getParameter("demand_products").getBytes("UTF-8"), "UTF-8"); String demand_products = exchange.toHtml(bodya); try { if (!chain_id.equals("")) { String sqll = "select * from intrmanufacture_file where provider_ID='" + provider_ID + "' and provider_name='" + provider_name + "'"; ResultSet rset = intrmanufacture_db.executeQuery(sqll); if (rset.next()) { response.sendRedirect("portal/oem/register1_ok_a.jsp"); } else { String sql = "insert into intrmanufacture_file(chain_id,chain_name,provider_ID,provider_name,provider_address,provider_class,type,provider_bank,provider_account,provider_web,provider_tel1,provider_fax,provider_postcode,used_provider_name,contact_person1,contact_person1_department,contact_person1_duty,contact_person1_sex,contact_person1_office_tel,contact_person1_home_tel,contact_person1_mobile,contact_person1_email,contact_person2,contact_person2_department,contact_person2_duty,contact_person2_sex,contact_person2_office_tel,contact_person2_home_tel,contact_person2_mobile,contact_person2_email,register,register_time,invoice_info,demand_products,check_tag,modify_tag,excel_tag,intrmanufacturer,intrmanufacturer_ID) values ('" + chain_id + "','" + chain_name + "','" + provider_ID + "','" + provider_name + "','" + provider_address + "','" + provider_class + "','" + type + "','" + provider_bank + "','" + provider_account + "','" + provider_web + "','" + provider_tel1 + "','" + provider_fax + "','" + provider_postcode + "','" + used_provider_name + "','" + contact_person1 + "','" + contact_person1_department + "','" + contact_person1_duty + "','" + contact_person1_sex + "','" + contact_person1_office_tel + "','" + contact_person1_home_tel + "','" + contact_person1_mobile + "','" + contact_person1_email + "','" + contact_person2 + "','" + contact_person2_department + "','" + contact_person2_duty + "','" + contact_person2_sex + "','" + contact_person2_office_tel + "','" + contact_person2_home_tel + "','" + contact_person2_mobile + "','" + contact_person2_email + "','" + register + "','" + register_time + "','" + invoice_info + "','" + demand_products + "','0','0','1','" + intrmanufacturer + "','" + intrmanufacturer_ID + "')"; intrmanufacture_db.executeUpdate(sql); String[] email_box = {contact_person1_email}; mail.send( email_box, "smtp.sina.com.cn", "*****@*****.**", "123456", demo.getLang("erp", "注册信息"), "欢迎您注册成为我们的委外厂商,您的档案编号是:" + provider_ID); CdefineUpdate CdefineUpdate = new CdefineUpdate(); sql = CdefineUpdate.update("intrmanufacture_file", "provider_ID", provider_ID, request); intrmanufacture_db.executeUpdate(sql); /** ************************************************** */ List rsList = (List) new java.util.ArrayList(); String[] elem = new String[3]; sql = "select id,describe1,describe2 from intrmanufacture_config_workflow where type_id='01'"; rset = intrmanufacture_db.executeQuery(sql); while (rset.next()) { elem = new String[3]; elem[0] = rset.getString("id"); elem[1] = rset.getString("describe1"); elem[2] = rset.getString("describe2"); rsList.add(elem); } if (rsList.size() == 0) { sql = "update intrmanufacture_file set check_tag='1' where provider_ID='" + provider_ID + "'"; intrmanufacture_db.executeUpdate(sql); } else { Iterator ite = rsList.iterator(); while (ite.hasNext()) { elem = (String[]) ite.next(); sql = "insert into intrmanufacture_workflow(config_id,object_ID,describe1,describe2) values ('" + elem[0] + "','" + provider_ID + "','" + elem[1] + "','" + elem[2] + "')"; intrmanufacture_db.executeUpdate(sql); } } response.sendRedirect( "portal/oem/register1_choose_attachment.jsp?provider_ID=" + provider_ID + ""); } } else { response.sendRedirect("portal/oem/register1_ok_b.jsp"); } } catch (Exception ex) { out.println("error" + ex); } intrmanufacture_db.commit(); design_db.commit(); intrmanufacture_db.close(); design_db.close(); } else { response.sendRedirect("error_conn.htm"); } } catch (Exception ex) { ex.printStackTrace(); } }
public synchronized void doPost(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(); try { PrintWriter out = response.getWriter(); nseer_db_backup1 stock_db = new nseer_db_backup1(dbApplication); nseer_db_backup1 crm_db = new nseer_db_backup1(dbApplication); if (stock_db.conn((String) dbSession.getAttribute("unit_db_name")) && crm_db.conn((String) dbSession.getAttribute("unit_db_name"))) { FileKind FileKind = new FileKind(); ValidataNumber validata = new ValidataNumber(); ValidataRecord vr = new ValidataRecord(); counter count = new counter(dbApplication); ValidataTag vt = new ValidataTag(); String register_ID = (String) dbSession.getAttribute("human_IDD"); String config_id = request.getParameter("config_id"); String pay_ID = request.getParameter("pay_ID"); String product_amount = request.getParameter("product_amount"); int num = Integer.parseInt(product_amount); String payer_name = request.getParameter("payer_name"); String payer_ID = request.getParameter("payer_ID"); String reason = request.getParameter("reason"); String not_return_tag = request.getParameter("not_return_tag"); String register = request.getParameter("register"); String register_time = request.getParameter("register_time"); String demand_return_time = request.getParameter("demand_return_time"); String sales_name = request.getParameter("sales_name"); String sales_ID = request.getParameter("sales_ID"); String bodyc = new String(request.getParameter("remark").getBytes("UTF-8"), "UTF-8"); String remark = exchange.toHtml(bodyc); String time = ""; java.util.Date now = new java.util.Date(); SimpleDateFormat formatter = new SimpleDateFormat("yyyyMMdd"); time = formatter.format(now); String[] product_IDn = request.getParameterValues("product_ID"); String[] amountn = request.getParameterValues("amount"); if (num == 0 && product_IDn.length == 1) { response.sendRedirect("draft/crm/credit_ok_a.jsp?pay_ID=" + pay_ID); } else { int p = 0; for (int i = 1; i <= num; i++) { String tem_amount = "amount" + i; String amount = request.getParameter(tem_amount); if (amount.equals("")) amount = "0"; if (!validata.validata(amount)) { p++; } } int n = 0; String product_ID_group = ""; for (int j = 1; j < product_IDn.length; j++) { product_ID_group += product_IDn[j] + ","; if (amountn[j].equals("")) amountn[j] = "0"; if (!validata.validata(amountn[j])) { p++; } } for (int i = 1; i <= num; i++) { String tem_product_ID = "product_ID" + i; String product_ID = request.getParameter(tem_product_ID); if (product_ID_group.indexOf(product_ID) != -1) n++; } if (vt.validata( (String) dbSession.getAttribute("unit_db_name"), "stock_apply_pay", "pay_ID", pay_ID, "check_tag") .equals("9") || vt.validata( (String) dbSession.getAttribute("unit_db_name"), "stock_apply_pay", "pay_ID", pay_ID, "check_tag") .equals("5")) { if (p == 0) { try { if (n == 0) { boolean flag = false; List rsList = GetWorkflow.getList(crm_db, "crm_config_workflow", "05"); String[] elem = new String[3]; if (rsList.size() == 0) { flag = true; } String sqll = ""; String[] aaa1 = FileKind.getKind( (String) dbSession.getAttribute("unit_db_name"), "crm_file", "customer_ID", payer_ID); String stock_pay_ID = NseerId.getId("stock/pay", (String) dbSession.getAttribute("unit_db_name")); double demand_amount = 0.0d; double list_price_sum = 0.0d; double cost_price_sum = 0.0d; for (int i = 1; i <= num; i++) { String tem_product_name = "product_name" + i; String tem_product_ID = "product_ID" + i; String tem_available_amount = "available_amount" + i; String tem_amount = "amount" + i; String tem_list_price = "list_price" + i; String tem_cost_price = "cost_price" + i; String tem_type = "type" + i; String tem_amount_unit = "amount_unit" + i; String product_name = request.getParameter(tem_product_name); String product_ID = request.getParameter(tem_product_ID); String available_amount = request.getParameter(tem_available_amount); String amount = request.getParameter(tem_amount); if (amount.equals("")) amount = "0"; String list_price2 = request.getParameter(tem_list_price); String cost_price = request.getParameter(tem_cost_price); String type = request.getParameter(tem_type); StringTokenizer tokenTO3 = new StringTokenizer(list_price2, ","); String list_price = ""; while (tokenTO3.hasMoreTokens()) { String list_price1 = tokenTO3.nextToken(); list_price += list_price1; } String amount_unit = request.getParameter(tem_amount_unit); double list_price_subtotal = Double.parseDouble(list_price) * Double.parseDouble(amount); list_price_sum += list_price_subtotal; double cost_price_subtotal = Double.parseDouble(cost_price) * Double.parseDouble(amount); cost_price_sum += cost_price_subtotal; demand_amount += Double.parseDouble(amount); String sql1 = "update stock_apply_pay_details set amount='" + amount + "',list_price='" + list_price + "',list_price_subtotal='" + list_price_subtotal + "',cost_price='" + cost_price + "',subtotal='" + cost_price_subtotal + "' where pay_ID='" + pay_ID + "' and details_number='" + i + "'"; stock_db.executeUpdate(sql1); if (flag) { if (type.equals("物料") || type.equals("外购商品")) { String sql2 = "insert into stock_pay_details(pay_ID,details_number,product_ID,product_name,type,list_price,list_price_subtotal,cost_price,subtotal,amount,unpay_amount,apply_manufacture_amount,apply_purchase_amount) values('" + stock_pay_ID + "','" + i + "','" + product_ID + "','" + product_name + "','" + type + "','" + list_price + "','" + list_price_subtotal + "','" + cost_price + "','" + cost_price_subtotal + "','" + amount + "','" + amount + "','0','" + amount + "')"; stock_db.executeUpdate(sql2); } else if (type.equals("商品") || type.equals("部件") || type.equals("委外部件")) { String sql2 = "insert into stock_pay_details(pay_ID,details_number,product_ID,product_name,type,list_price,list_price_subtotal,cost_price,subtotal,amount,unpay_amount,apply_manufacture_amount,apply_purchase_amount) values('" + stock_pay_ID + "','" + i + "','" + product_ID + "','" + product_name + "','" + type + "','" + list_price + "','" + list_price_subtotal + "','" + cost_price + "','" + cost_price_subtotal + "','" + amount + "','" + amount + "','" + amount + "','0')"; stock_db.executeUpdate(sql2); } String sql97 = "select * from crm_salecredit_balance_details where crediter_ID='" + payer_ID + "' and product_ID='" + product_ID + "'"; ResultSet rs97 = crm_db.executeQuery(sql97); if (rs97.next()) { double balance_amount = rs97.getDouble("amount") + Double.parseDouble(amount); double balance_cost_price_subtotal = rs97.getDouble("subtotal") + cost_price_subtotal; double balance_list_price_subtotal = rs97.getDouble("list_price_subtotal") + list_price_subtotal; String sql96 = "update crm_salecredit_balance_details set amount='" + balance_amount + "',check_tag='1',subtotal='" + balance_cost_price_subtotal + "',list_price_subtotal='" + balance_list_price_subtotal + "' where crediter_ID='" + payer_ID + "' and product_ID='" + product_ID + "'"; crm_db.executeUpdate(sql96); } else { String[] aaa = FileKind.getKind( (String) dbSession.getAttribute("unit_db_name"), "design_file", "product_ID", product_ID); String sql95 = "insert into crm_salecredit_balance_details(chain_ID,chain_name,crediter_chain_ID,crediter_chain_name,product_ID,product_name,list_price,list_price_subtotal,cost_price,subtotal,amount,crediter_ID,crediter_name) values('" + aaa[0] + "','" + aaa[1] + "','" + aaa1[0] + "','" + aaa1[1] + "','" + product_ID + "','" + product_name + "','" + list_price + "','" + list_price_subtotal + "','" + cost_price + "','" + cost_price_subtotal + "','" + amount + "','" + payer_ID + "','" + payer_name + "')"; crm_db.executeUpdate(sql95); } } } String[] cost_pricen = request.getParameterValues("cost_price"); String[] list_pricen = request.getParameterValues("list_price"); String[] product_namen = request.getParameterValues("product_name"); String[] product_describen = request.getParameterValues("product_describe"); String[] amount_unitn = request.getParameterValues("amount_unit"); String[] typen = request.getParameterValues("type"); for (int i = 1; i < product_IDn.length; i++) { StringTokenizer tokenTO3 = new StringTokenizer(list_pricen[i], ","); String list_price = ""; while (tokenTO3.hasMoreTokens()) { String list_price1 = tokenTO3.nextToken(); list_price += list_price1; } if (!amountn[i].equals("") && Double.parseDouble(amountn[i]) != 0) { double list_price_subtotal = Double.parseDouble(list_price) * Double.parseDouble(amountn[i]); list_price_sum += list_price_subtotal; double subtotal = Double.parseDouble(cost_pricen[i]) * Double.parseDouble(amountn[i]); cost_price_sum += subtotal; demand_amount += Double.parseDouble(amountn[i]); num++; String sql1 = "insert into stock_apply_pay_details(payer_chain_ID,payer_chain_name,sales_ID,sales_name,payer_ID,payer_name,payer_type,pay_ID,details_number,product_ID,product_name,product_describe,amount,amount_unit,list_price,list_price_subtotal,cost_price,subtotal,type) values ('" + aaa1[0] + "','" + aaa1[1] + "','" + sales_ID + "','" + sales_name + "','" + payer_ID + "','" + payer_name + "','销售赊货','" + pay_ID + "','" + num + "','" + product_IDn[i] + "','" + product_namen[i] + "','" + product_describen[i] + "','" + amountn[i] + "','" + amount_unitn[i] + "','" + list_price + "','" + list_price_subtotal + "','" + cost_pricen[i] + "','" + subtotal + "','" + typen[i] + "')"; stock_db.executeUpdate(sql1); // ********************** if (rsList.size() == 0) { if (typen[i].equals("物料") || typen[i].equals("外购商品")) { String sql2 = "insert into stock_pay_details(pay_ID,details_number,product_ID,product_name,type,list_price,list_price_subtotal,cost_price,subtotal,amount,unpay_amount,apply_manufacture_amount,apply_purchase_amount) values('" + stock_pay_ID + "','" + num + "','" + product_IDn[i] + "','" + product_namen[i] + "','" + typen[i] + "','" + list_price + "','" + list_price_subtotal + "','" + cost_pricen[i] + "','" + subtotal + "','" + amountn[i] + "','" + amountn[i] + "','0','" + amountn[i] + "')"; stock_db.executeUpdate(sql2); } else if (typen[i].equals("商品") || typen[i].equals("部件") || typen[i].equals("委外部件")) { String sql2 = "insert into stock_pay_details(pay_ID,details_number,product_ID,product_name,type,list_price,list_price_subtotal,cost_price,subtotal,amount,unpay_amount,apply_manufacture_amount,apply_purchase_amount) values('" + stock_pay_ID + "','" + num + "','" + product_IDn[i] + "','" + product_namen[i] + "','" + typen[i] + "','" + list_price + "','" + list_price_subtotal + "','" + cost_pricen[i] + "','" + subtotal + "','" + amountn[i] + "','" + amountn[i] + "','" + amountn[i] + "','0')"; stock_db.executeUpdate(sql2); } String sql97 = "select * from crm_salecredit_balance_details where crediter_ID='" + payer_ID + "' and product_ID='" + product_IDn[i] + "'"; ResultSet rs97 = crm_db.executeQuery(sql97); if (rs97.next()) { double balance_amount = rs97.getDouble("amount") + Double.parseDouble(amountn[i]); double balance_cost_price_subtotal = rs97.getDouble("subtotal") + subtotal; double balance_list_price_subtotal = rs97.getDouble("list_price_subtotal") + list_price_subtotal; String sql96 = "update crm_salecredit_balance_details set amount='" + balance_amount + "',check_tag='1',subtotal='" + balance_cost_price_subtotal + "',list_price_subtotal='" + balance_list_price_subtotal + "' where crediter_ID='" + payer_ID + "' and product_ID='" + product_IDn[i] + "'"; crm_db.executeUpdate(sql96); } else { String[] aaa = FileKind.getKind( (String) dbSession.getAttribute("unit_db_name"), "design_file", "product_ID", product_IDn[i]); String sql95 = "insert into crm_salecredit_balance_details(chain_ID,chain_name,crediter_chain_ID,crediter_chain_name,product_ID,product_name,list_price,list_price_subtotal,cost_price,subtotal,amount,crediter_ID,crediter_name) values('" + aaa[0] + "','" + aaa[1] + "','" + aaa1[0] + "','" + aaa1[1] + "','" + product_IDn[i] + "','" + product_namen[i] + "','" + list_price + "','" + list_price_subtotal + "','" + cost_pricen[i] + "','" + subtotal + "','" + amountn[i] + "','" + payer_ID + "','" + payer_name + "')"; crm_db.executeUpdate(sql95); } } // *************************** } } String sql = "update stock_apply_pay set reason='" + reason + "',register='" + register + "',register_time='" + register_time + "',demand_return_time='" + demand_return_time + "',register_time='" + register_time + "',register='" + register + "',remark='" + remark + "',demand_amount='" + demand_amount + "',list_price_sum='" + list_price_sum + "',cost_price_sum='" + cost_price_sum + "',not_return_tag='" + not_return_tag + "' where pay_ID='" + pay_ID + "'"; stock_db.executeUpdate(sql); if (flag) { sql = "update stock_apply_pay set check_tag='1' where pay_ID='" + pay_ID + "'"; stock_db.executeUpdate(sql); if (!vr.validata( (String) dbSession.getAttribute("unit_db_name"), "stock_pay", "reasonexact", pay_ID)) { String sql4 = "insert into stock_pay(pay_ID,reason,reasonexact,reasonexact_details,demand_amount,list_price_sum,cost_price_sum,register,register_time) values('" + stock_pay_ID + "','" + reason + "','" + pay_ID + "','" + payer_name + "','" + demand_amount + "','" + list_price_sum + "','" + cost_price_sum + "','" + register + "','" + register_time + "')"; stock_db.executeUpdate(sql4); } String sql98 = "select * from crm_file where customer_ID='" + payer_ID + "'"; ResultSet rs98 = crm_db.executeQuery(sql98); if (rs98.next()) { double salecredit_list_price_sum = rs98.getDouble("salecredit_list_price_sum") + list_price_sum; double salecredit_cost_price_sum = rs98.getDouble("salecredit_cost_price_sum") + cost_price_sum; String sql99 = "update crm_file set credit_yes_or_not_tag='1',salecredit_list_price_sum='" + salecredit_list_price_sum + "',salecredit_cost_price_sum='" + salecredit_cost_price_sum + "' where customer_ID='" + payer_ID + "' "; crm_db.executeUpdate(sql99); } } else { sql = "update stock_apply_pay set check_tag='0' where pay_ID='" + pay_ID + "'"; stock_db.executeUpdate(sql); Iterator ite = rsList.iterator(); while (ite.hasNext()) { elem = (String[]) ite.next(); sql = "insert into crm_workflow(config_id,object_ID,describe1,describe2) values ('" + elem[0] + "','" + pay_ID + "','" + elem[1] + "','" + elem[2] + "')"; crm_db.executeUpdate(sql); } } response.sendRedirect("draft/crm/credit_ok.jsp?finished_tag=8"); } else { response.sendRedirect( "draft/crm/credit_ok.jsp?finished_tag=7&pay_ID=" + pay_ID + ""); } } catch (Exception ex) { ex.printStackTrace(); } } else { response.sendRedirect("draft/crm/credit_ok.jsp?finished_tag=6&pay_ID=" + pay_ID + ""); } } else { response.sendRedirect("draft/crm/credit_ok.jsp?finished_tag=9"); } } stock_db.commit(); crm_db.commit(); stock_db.close(); crm_db.close(); } else { response.sendRedirect("error_conn.htm"); } } catch (Exception ex) { ex.printStackTrace(); } }
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(); nseer_db_backup1 finance_db = new nseer_db_backup1(dbApplication); getNameFromID getNameFromID = new getNameFromID(); PrintWriter out = response.getWriter(); try { if (finance_db.conn((String) dbSession.getAttribute("unit_db_name"))) { SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd"); counter count = new counter(dbApplication); ValidataNumber validata = new ValidataNumber(); String file_id = request.getParameter("file_id"); String file_name = request.getParameter("file_name"); String start_time = request.getParameter("start_time"); String specification = request.getParameter("specification"); String cb_status = request.getParameter("cb_status"); String ca_status = request.getParameter("ca_status"); String change_reason = request.getParameter("change_reason"); String change_time = request.getParameter("change_date"); String changer = request.getParameter("changer"); String sql = ""; ResultSet rs = null; String changebill_id = NseerId.getId( getClass().getResource("").toString(), (String) dbSession.getAttribute("unit_db_name")); sql = "insert into finance_fa_change(changebill_id,file_id,file_name,start_time,specification,cb_status_id,ca_status_id,change_reason,change_time,changer,change_kind) values('" + changebill_id + "','" + file_id + "','" + file_name + "','" + start_time + "','" + specification + "','" + cb_status + "','" + ca_status + "','" + change_reason + "','" + change_time + "','" + changer + "','使用状态变动')"; finance_db.executeUpdate(sql); sql = "select * from finance_fa_file where file_id='" + file_id + "'"; rs = finance_db.executeQuery(sql); if (rs.next()) { sql = "insert into finance_fa_file_dig(card_id,type_id,type_name,file_id,file_name,addway_id,addway_name,department_id,department_name,specification,deposit_place,status_id,calway_id,start_time,lifecycle,currency,original_value,remnant_value,remnant_value_rate,caled_month,caled_sum,cal_subtotal,cal_subtotal_rate,net_value,cal_file_name,work_total,work_sum,work_unit,unit_cal,project,sum_presub,sum_re_presub,caled_time,change_time,exchange_rate,reduceway_id,reduceway_name,reduce_time,clear_income,clear_expense,clear_reason,lately_change_time) values('" + rs.getString("card_id") + "','" + rs.getString("type_id") + "','" + rs.getString("type_name") + "','" + rs.getString("file_id") + "','" + rs.getString("file_name") + "','" + rs.getString("addway_id") + "','" + rs.getString("addway_name") + "','" + rs.getString("department_id") + "','" + rs.getString("department_name") + "','" + rs.getString("specification") + "','" + rs.getString("deposit_place") + "','" + rs.getString("status_id") + "','" + rs.getString("calway_id") + "','" + rs.getString("start_time") + "','" + rs.getString("lifecycle") + "','" + rs.getString("currency") + "','" + rs.getString("original_value") + "','" + rs.getString("remnant_value") + "','" + rs.getString("remnant_value_rate") + "','" + rs.getString("caled_month") + "','" + rs.getString("caled_sum") + "','" + rs.getString("cal_subtotal") + "','" + rs.getString("cal_subtotal_rate") + "','" + rs.getString("net_value") + "','" + rs.getString("cal_file_name") + "','" + rs.getString("work_total") + "','" + rs.getString("work_sum") + "','" + rs.getString("work_unit") + "','" + rs.getString("unit_cal") + "','" + rs.getString("project") + "','" + rs.getString("sum_presub") + "','" + rs.getString("sum_re_presub") + "','" + rs.getString("caled_time") + "','" + rs.getString("change_time") + "','" + rs.getString("exchange_rate") + "','" + rs.getString("reduceway_id") + "','" + rs.getString("reduceway_name") + "','" + rs.getString("reduce_time") + "','" + rs.getString("clear_income") + "','" + rs.getString("clear_expense") + "','" + rs.getString("clear_reason") + "','" + change_time + "')"; finance_db.executeUpdate(sql); sql = "update finance_fa_file set status_id='" + ca_status + "',change_time='" + change_time + "' where file_id='" + file_id + "'"; finance_db.executeUpdate(sql); } finance_db.commit(); finance_db.close(); out.println("提交成功"); } } catch (Exception ex) { ex.printStackTrace(); } }