account_ok.java

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

				debit=rs3.getDouble("debit_year_sum")+rs.getDouble("debit_subtotal");
				loan=rs3.getDouble("loan_year_sum")+rs.getDouble("loan_subtotal");
				current_balance_sum=rs3.getDouble("last_year_balance_sum")+loan-debit;
				sql1="update finance_gl set debit_year_sum='"+debit+"',loan_year_sum='"+loan+"',current_balance_sum='"+current_balance_sum+"' where file_id='"+file_id_group[i]+"' and account_period='"+rs.getString("account_period")+"'";
				financedb.executeUpdate(sql1);
				sql1="update finance_gl set last_year_balance_sum='"+current_balance_sum+"',current_balance_sum='"+current_balance_sum+"' where file_id='"+file_id_group[i]+"' and account_period>'"+rs.getString("account_period")+"'";
				financedb.executeUpdate(sql1);
			}
			}else{
				if(debit_or_loan.equals("借")&&corr_stock_tag.equals("是")){
				debit=rs.getDouble("debit_subtotal");
				loan=rs.getDouble("loan_subtotal");
				current_balance_sum=debit-loan;
				if(rs.getDouble("debit_subtotal")!=0){
					debit_amount=rs.getDouble("product_amount");
					loan_amount=0.0d;
				}else{
					debit_amount=0.0d;
					loan_amount=rs.getDouble("product_amount");
				}
				current_balance_amount=debit_amount-loan_amount;
				if(current_balance_sum<0){
					current_balance_amount=-current_balance_amount;
				}
				account_period=start;
				for(int j=0;j<12;j++){
					account_period=account_period+1;
					if(account_period==rs.getInt("account_period")) break;
					sql1="insert into finance_gl(file_ID,file_name,debit_or_loan,itema_name,itemb_name,itemd_name,last_year_balance_sum,debit_year_sum,loan_year_sum,current_balance_sum,last_year_balance_amount,debit_year_amount,loan_year_amount,current_balance_amount,account_period,corr_stock_tag) values('"+file_id_group[i]+"','"+name[0]+"','"+name[1]+"','"+name[2]+"','"+name[3]+"','"+name[4]+"','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','"+account_period+"','"+corr_stock_tag+"')";
					financedb.executeUpdate(sql1);
				}
				sql1="insert into finance_gl(file_ID,file_name,debit_or_loan,itema_name,itemb_name,itemd_name,last_year_balance_sum,debit_year_sum,loan_year_sum,current_balance_sum,last_year_balance_amount,debit_year_amount,loan_year_amount,current_balance_amount,account_period,corr_stock_tag) values('"+file_id_group[i]+"','"+name[0]+"','"+name[1]+"','"+name[2]+"','"+name[3]+"','"+name[4]+"','0.00','"+debit+"','"+loan+"','"+current_balance_sum+"','0.00','"+debit_amount+"','"+loan_amount+"','"+current_balance_amount+"','"+rs.getString("account_period")+"','"+corr_stock_tag+"')";
				financedb.executeUpdate(sql1);
				account_period=rs.getInt("account_period");
				for(int j=0;j<12;j++){
					account_period=account_period+1;
					if(account_period==end) break;
					sql1="insert into finance_gl(file_ID,file_name,debit_or_loan,itema_name,itemb_name,itemd_name,last_year_balance_sum,debit_year_sum,loan_year_sum,current_balance_sum,last_year_balance_amount,debit_year_amount,loan_year_amount,current_balance_amount,account_period,corr_stock_tag) values('"+file_id_group[i]+"','"+name[0]+"','"+name[1]+"','"+name[2]+"','"+name[3]+"','"+name[4]+"','"+current_balance_sum+"','0.00','0.00','"+current_balance_sum+"','"+current_balance_amount+"','0.00','0.00','"+current_balance_amount+"','"+account_period+"','"+corr_stock_tag+"')";
					financedb.executeUpdate(sql1);
				}
			}else if(debit_or_loan.equals("借")&&corr_stock_tag.equals("否")){
				debit=rs.getDouble("debit_subtotal");
				loan=rs.getDouble("loan_subtotal");
				current_balance_sum=debit-loan;
				account_period=start;
				for(int j=0;j<12;j++){
					account_period=account_period+1;
					if(account_period==rs.getInt("account_period")) break;
					sql1="insert into finance_gl(file_ID,file_name,debit_or_loan,itema_name,itemb_name,itemd_name,last_year_balance_sum,debit_year_sum,loan_year_sum,current_balance_sum,account_period,corr_stock_tag) values('"+file_id_group[i]+"','"+name[0]+"','"+name[1]+"','"+name[2]+"','"+name[3]+"','"+name[4]+"','0.00','0.00','0.00','0.00','"+account_period+"','"+corr_stock_tag+"')";
					financedb.executeUpdate(sql1);
				}
				sql1="insert into finance_gl(file_ID,file_name,debit_or_loan,itema_name,itemb_name,itemd_name,last_year_balance_sum,debit_year_sum,loan_year_sum,current_balance_sum,account_period,corr_stock_tag) values('"+file_id_group[i]+"','"+name[0]+"','"+name[1]+"','"+name[2]+"','"+name[3]+"','"+name[4]+"','0.00','"+debit+"','"+loan+"','"+current_balance_sum+"','"+rs.getString("account_period")+"','"+corr_stock_tag+"')";
				financedb.executeUpdate(sql1);
				account_period=rs.getInt("account_period");
				for(int j=0;j<12;j++){
					account_period=account_period+1;
					if(account_period==end) break;
					sql1="insert into finance_gl(file_ID,file_name,debit_or_loan,itema_name,itemb_name,itemd_name,last_year_balance_sum,debit_year_sum,loan_year_sum,current_balance_sum,account_period,corr_stock_tag) values('"+file_id_group[i]+"','"+name[0]+"','"+name[1]+"','"+name[2]+"','"+name[3]+"','"+name[4]+"','"+current_balance_sum+"','0.00','0.00','"+current_balance_sum+"','"+account_period+"','"+corr_stock_tag+"')";
					financedb.executeUpdate(sql1);
				}

			}else if(debit_or_loan.equals("贷")&&corr_stock_tag.equals("是")){
				debit=rs.getDouble("debit_subtotal");
				loan=rs.getDouble("loan_subtotal");
				current_balance_sum=loan-debit;
				if(rs.getDouble("debit_subtotal")!=0){
					debit_amount=rs.getDouble("product_amount");
					loan_amount=0.0d;
				}else{
					debit_amount=0.0d;
					loan_amount=rs.getDouble("product_amount");
				}
				current_balance_amount=loan_amount-debit_amount;
				if(current_balance_sum<0){
					current_balance_amount=-current_balance_amount;
				}
				account_period=start;
				for(int j=0;j<12;j++){
					account_period=account_period+1;
					if(account_period==rs.getInt("account_period")) break;
					sql1="insert into finance_gl(file_ID,file_name,debit_or_loan,itema_name,itemb_name,itemd_name,last_year_balance_sum,debit_year_sum,loan_year_sum,current_balance_sum,last_year_balance_amount,debit_year_amount,loan_year_amount,current_balance_amount,account_period,corr_stock_tag) values('"+file_id_group[i]+"','"+name[0]+"','"+name[1]+"','"+name[2]+"','"+name[3]+"','"+name[4]+"','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','"+account_period+"','"+corr_stock_tag+"')";
					financedb.executeUpdate(sql1);
				}
				sql1="insert into finance_gl(file_ID,file_name,debit_or_loan,itema_name,itemb_name,itemd_name,last_year_balance_sum,debit_year_sum,loan_year_sum,current_balance_sum,last_year_balance_amount,debit_year_amount,loan_year_amount,current_balance_amount,account_period,corr_stock_tag) values('"+file_id_group[i]+"','"+name[0]+"','"+name[1]+"','"+name[2]+"','"+name[3]+"','"+name[4]+"','0.00','"+debit+"','"+loan+"','"+current_balance_sum+"','0.00','"+debit_amount+"','"+loan_amount+"','"+current_balance_amount+"','"+rs.getString("account_period")+"','"+corr_stock_tag+"')";
				financedb.executeUpdate(sql1);
				account_period=rs.getInt("account_period");
				for(int j=0;j<12;j++){
					account_period=account_period+1;
					if(account_period==end) break;
					sql1="insert into finance_gl(file_ID,file_name,debit_or_loan,itema_name,itemb_name,itemd_name,last_year_balance_sum,debit_year_sum,loan_year_sum,current_balance_sum,last_year_balance_amount,debit_year_amount,loan_year_amount,current_balance_amount,account_period,corr_stock_tag) values('"+file_id_group[i]+"','"+name[0]+"','"+name[1]+"','"+name[2]+"','"+name[3]+"','"+name[4]+"','"+current_balance_sum+"','0.00','0.00','"+current_balance_sum+"','"+current_balance_amount+"','0.00','0.00','"+current_balance_amount+"','"+account_period+"','"+corr_stock_tag+"')";
					financedb.executeUpdate(sql1);
				}

			}else if(debit_or_loan.equals("贷")&&corr_stock_tag.equals("否")){
				debit=rs.getDouble("debit_subtotal");
				loan=rs.getDouble("loan_subtotal");
				current_balance_sum=loan-debit;
				account_period=start;
				for(int j=0;j<12;j++){
					account_period=account_period+1;
					if(account_period==rs.getInt("account_period")) break;
					sql1="insert into finance_gl(file_ID,file_name,debit_or_loan,itema_name,itemb_name,itemd_name,last_year_balance_sum,debit_year_sum,loan_year_sum,current_balance_sum,account_period,corr_stock_tag) values('"+file_id_group[i]+"','"+name[0]+"','"+name[1]+"','"+name[2]+"','"+name[3]+"','"+name[4]+"','0.00','0.00','0.00','0.00','"+account_period+"','"+corr_stock_tag+"')";
					financedb.executeUpdate(sql1);
				}
				sql1="insert into finance_gl(file_ID,file_name,debit_or_loan,itema_name,itemb_name,itemd_name,last_year_balance_sum,debit_year_sum,loan_year_sum,current_balance_sum,account_period,corr_stock_tag) values('"+file_id_group[i]+"','"+name[0]+"','"+name[1]+"','"+name[2]+"','"+name[3]+"','"+name[4]+"','0.00','"+debit+"','"+loan+"','"+current_balance_sum+"','"+rs.getString("account_period")+"','"+corr_stock_tag+"')";
				financedb.executeUpdate(sql1);
				account_period=rs.getInt("account_period");
				for(int j=0;j<12;j++){
					account_period=account_period+1;
					if(account_period==end) break;
					sql1="insert into finance_gl(file_ID,file_name,debit_or_loan,itema_name,itemb_name,itemd_name,last_year_balance_sum,debit_year_sum,loan_year_sum,current_balance_sum,account_period,corr_stock_tag) values('"+file_id_group[i]+"','"+name[0]+"','"+name[1]+"','"+name[2]+"','"+name[3]+"','"+name[4]+"','"+current_balance_sum+"','0.00','0.00','"+current_balance_sum+"','"+account_period+"','"+corr_stock_tag+"')";
					financedb.executeUpdate(sql1);
				}
			}
		}
	}
}

sql3 = "update finance_voucher set accounter='"+register+"',account_time='"+check_time+"',account_tag='1' where voucher_in_month_id='"+voucher_in_month_id+"' and register_time='"+register_time+"'" ;
	financedb.executeUpdate(sql3) ;
	sql3 = "update finance_cash_table set account_tag='1' where voucher_in_month_id='"+voucher_in_month_id+"' and register_time='"+register_time+"'" ;
	financedb.executeUpdate(sql3) ;

response.sendRedirect("finance/voucher/account_ok_a.jsp");
}else{
response.sendRedirect("finance/voucher/account_ok_b.jsp");
}
}else{
response.sendRedirect("finance/voucher/account_ok_c.jsp");
}

financedb.commit();
finance_db.commit();
finance_db.close();
financedb.close();
}else{
	response.sendRedirect("error_conn.htm");
}
}catch (Exception ex){
ex.printStackTrace();
}
}
}