yearbegin_ok.java

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

ResultSet rs7=finance_db.executeQuery(sql7);
while(rs7.next()){

	String sql8="insert into finance_history_voucher_details(VOUCHER_ID,FIRST_KIND_ID,FIRST_KIND_NAME,SECOND_KIND_ID,SECOND_KIND_NAME,THIRD_KIND_ID,THIRD_KIND_NAME,SUMMARY_TYPE,SUMMARY_CONTENT,VOUCHER_IN_MONTH_ID,ATTACHMENT_ID,PRODUCT_AMOUNT,PRODUCT_PRICE,DEBIT_SUBTOTAL,LOAN_SUBTOTAL,REMARK,GROUP_NAME,DEBIT_OR_LOAN,ITEMA_NAME,ITEMB_NAME,ITEMC_NAME,BALANCE_SUM,BALANCE_AMOUNT,DEBIT_AMOUNT,LOAN_AMOUNT,REGISTER_TIME,CHECK_TIME,DEBIT_PRICE,LOAN_PRICE,NUMBER_IN_CASH_TABLE,CHAIN_KIND_ID,CHAIN_KIND_NAME ) values('"+rs7.getString("VOUCHER_ID")+"','"+rs7.getString("FIRST_KIND_ID")+"','"+rs7.getString("FIRST_KIND_NAME")+"','"+rs7.getString("SECOND_KIND_ID")+"','"+rs7.getString("SECOND_KIND_NAME")+"','"+rs7.getString("THIRD_KIND_ID")+"','"+rs7.getString("THIRD_KIND_NAME")+"','"+rs7.getString("SUMMARY_TYPE")+"','"+rs7.getString("SUMMARY_CONTENT")+"','"+rs7.getString("VOUCHER_IN_MONTH_ID")+"','"+rs7.getString("ATTACHMENT_ID")+"','"+rs7.getString("PRODUCT_AMOUNT")+"','"+rs7.getString("PRODUCT_PRICE")+"','"+rs7.getString("DEBIT_SUBTOTAL")+"','"+rs7.getString("LOAN_SUBTOTAL")+"','"+rs7.getString("REMARK")+"','"+rs7.getString("GROUP_NAME")+"','"+rs7.getString("DEBIT_OR_LOAN")+"','"+rs7.getString("ITEMA_NAME")+"','"+rs7.getString("ITEMB_NAME")+"','"+rs7.getString("ITEMC_NAME")+"','"+rs7.getString("BALANCE_SUM")+"','"+rs7.getString("BALANCE_AMOUNT")+"','"+rs7.getString("DEBIT_AMOUNT")+"','"+rs7.getString("LOAN_AMOUNT")+"','"+rs7.getString("REGISTER_TIME")+"','"+rs7.getString("CHECK_TIME")+"','"+rs7.getString("DEBIT_PRICE")+"','"+rs7.getString("LOAN_PRICE")+"','"+rs7.getString("NUMBER_IN_CASH_TABLE")+"','"+rs7.getString("CHAIN_KIND_ID")+"','"+rs7.getString("CHAIN_KIND_NAME")+"' )";
	financedb.executeUpdate(sql8);
}
String sql9="delete from finance_account";
financedb.executeUpdate(sql9);
String sql10="delete from finance_account_details";
financedb.executeUpdate(sql10);

String sql11="delete from finance_voucher";
financedb.executeUpdate(sql11);

String sql12="delete from finance_voucher_details";
financedb.executeUpdate(sql12);

String sql13="select * from finance_account_finished order by id desc";
ResultSet rs13=financedb.executeQuery(sql13);
rs13.next();
String account_finished_finance_time=rs13.getString("account_finished_finance_time");
String year=(Integer.parseInt(account_finished_finance_time.substring(0,4))+1)+"";
String month="-01";
String day="-01"; 
String finance_time11=year+month+day;
String finance_time22=year+month;

	String ssql="select * from finance_history_account_details where newest_tag='1' ";	

	ResultSet rrs=financedb.executeQuery(ssql);
	while(rrs.next()){

String ssql4="insert into finance_account_details(voucher_in_month_ID,first_kind_ID,first_kind_name,second_kind_ID,second_kind_name,third_kind_ID,third_kind_name,group_name,itema_name,itemb_name,itemc_name,debit_or_loan,summary_content,debit_month_sum,loan_month_sum,last_year_balance_sum,current_balance_sum,debit_month_amount,loan_month_amount,last_year_balance_amount,current_balance_amount,current_balance_price,debit_price,loan_price,register,finance_time,number_in_cash_table,chain_kind_ID,chain_kind_name,profit_or_cost,newest_tag,debit_month_sum_sum,debit_month_amount_sum,debit_year_sum,debit_year_amount,loan_month_sum_sum,loan_month_amount_sum,loan_year_sum,loan_year_amount) values('','"+rrs.getString("first_kind_ID")+"','"+rrs.getString("first_kind_name")+"','"+rrs.getString("second_kind_ID")+"','"+rrs.getString("second_kind_name")+"','"+rrs.getString("third_kind_ID")+"','"+rrs.getString("third_kind_name")+"','"+rrs.getString("group_name")+"','"+rrs.getString("itema_name")+"','"+rrs.getString("itemb_name")+"','"+rrs.getString("itemc_name")+"','"+rrs.getString("debit_or_loan")+"','上年结转','0','0','"+rrs.getDouble("current_balance_sum")+"','"+rrs.getDouble("current_balance_sum")+"','0','0','"+rrs.getDouble("current_balance_amount")+"','"+rrs.getDouble("current_balance_amount")+"','"+rrs.getDouble("current_balance_price")+"','0','0','','"+finance_time11+"','"+rrs.getString("number_in_cash_table")+"','"+rrs.getString("chain_kind_ID")+"','"+rrs.getString("chain_kind_name")+"','"+rrs.getString("profit_or_cost")+"','1','0','0','0','0','0','0','0','0')";
				finance_db.executeUpdate(ssql4);
	
}


String ssql5="select * from finance_history_account where finance_time='"+account_finished_finance_time+"' order by first_kind_ID";
ResultSet rrs5=financedb.executeQuery(ssql5);
while(rrs5.next()){

String ssql6 = "insert into finance_account(first_kind_ID,first_kind_name,second_kind_ID,second_kind_name,third_kind_ID,third_kind_name,group_name,debit_or_loan,itema_name,itemb_name,itemc_name,last_year_balance_sum,last_month_balance_sum,debit_year_sum,loan_year_sum,debit_month_sum,loan_month_sum,current_balance_sum,finance_time) values('"+rrs5.getString("first_kind_ID")+"','"+rrs5.getString("first_kind_name")+"','"+rrs5.getString("second_kind_ID")+"','"+rrs5.getString("second_kind_name")+"','"+rrs5.getString("third_kind_ID")+"','"+rrs5.getString("third_kind_name")+"','"+rrs5.getString("group_name")+"','"+rrs5.getString("debit_or_loan")+"','"+rrs5.getString("itema_name")+"','"+rrs5.getString("itemb_name")+"','"+rrs5.getString("itemc_name")+"','"+rrs5.getDouble("current_balance_sum")+"','0','0','0','0','0','"+rs5.getDouble("current_balance_sum")+"','"+finance_time22+"')" ;
    	finance_db.executeUpdate(ssql6) ;


}


String ssql8="insert into finance_account_finished(account_finished_finance_time,account_finished_tag) values('"+finance_time11+"','0')";
finance_db.executeUpdate(ssql8);
financedb.commit();
finance_db.commit();
financedb.close();
finance_db.close();
response.sendRedirect("finance/account/yearBegin_ok_a.jsp");
}else{
	response.sendRedirect("error_conn.htm");
}
}
catch (Exception ex){
ex.printStackTrace();
}
}
}