registerthird_batch_init_ok.java

来自「一个ERP强大系统的源码」· Java 代码 · 共 276 行 · 第 1/2 页

String sql11="update finance_account set last_year_balance_sum='"+last_year_balance_sum+"',last_month_balance_sum='"+last_year_balance_sum+"',debit_year_sum='"+debit_year_sum+"',loan_year_sum='"+loan_year_sum+"',debit_month_sum='"+debit_month_sum+"',loan_month_sum='"+loan_month_sum+"',current_balance_sum='"+current_balance_sum+"' where first_kind_ID='"+first_kind_ID+"' and  second_kind_ID='' and third_kind_ID=''";
finance_db.executeUpdate(sql11);
}



String sql2="select * from finance_account where first_kind_ID='"+first_kind_ID+"' and  second_kind_ID='"+second_kind_ID+"' and third_kind_ID=''";
ResultSet rs2=finance_db.executeQuery(sql2);


if(rs2.next()){

double last_year_balance_sum=rs2.getDouble("last_year_balance_sum")-rs.getDouble("last_year_balance_sum")+Double.parseDouble(last_year_balance_sum1);
double debit_year_sum=rs2.getDouble("debit_year_sum")-rs.getDouble("debit_year_sum")+Double.parseDouble(debit_year_sum1);
double loan_year_sum=rs2.getDouble("loan_year_sum")-rs.getDouble("loan_year_sum")+Double.parseDouble(loan_year_sum1);
double current_balance_sum=rs2.getDouble("current_balance_sum")-rs.getDouble("current_balance_sum")+Double.parseDouble(current_balance_sum1);

double debit_month_sum=rs1.getDouble("debit_month_sum")-rs.getDouble("debit_month_sum")+Double.parseDouble(debit_year_sum1);
double loan_month_sum=rs1.getDouble("loan_month_sum")-rs.getDouble("loan_month_sum")+Double.parseDouble(loan_year_sum1);


String sql22="update finance_account set last_year_balance_sum='"+last_year_balance_sum+"',last_month_balance_sum='"+last_year_balance_sum+"',debit_year_sum='"+debit_year_sum+"',loan_year_sum='"+loan_year_sum+"',debit_month_sum='"+debit_month_sum+"',loan_month_sum='"+loan_month_sum+"',current_balance_sum='"+current_balance_sum+"' where first_kind_ID='"+first_kind_ID+"' and  second_kind_ID='"+second_kind_ID+"' and third_kind_ID=''";
finance_db.executeUpdate(sql22);
}

String sql3="select * from finance_account where first_kind_ID='"+first_kind_ID+"' and  second_kind_ID='"+second_kind_ID+"' and  third_kind_ID='"+third_kind_ID+"'";
ResultSet rs3=finance_db.executeQuery(sql3);


if(rs3.next()){

double last_year_balance_sum=rs3.getDouble("last_year_balance_sum")-rs.getDouble("last_year_balance_sum")+Double.parseDouble(last_year_balance_sum1);
double debit_year_sum=rs3.getDouble("debit_year_sum")-rs.getDouble("debit_year_sum")+Double.parseDouble(debit_year_sum1);
double loan_year_sum=rs3.getDouble("loan_year_sum")-rs.getDouble("loan_year_sum")+Double.parseDouble(loan_year_sum1);
double current_balance_sum=rs3.getDouble("current_balance_sum")-rs.getDouble("current_balance_sum")+Double.parseDouble(current_balance_sum1);
double debit_month_sum=rs3.getDouble("debit_month_sum")-rs.getDouble("debit_month_sum")+Double.parseDouble(debit_year_sum1);
double loan_month_sum=rs3.getDouble("loan_month_sum")-rs.getDouble("loan_month_sum")+Double.parseDouble(loan_year_sum1);


String sql33="update finance_account set last_year_balance_sum='"+last_year_balance_sum+"',last_month_balance_sum='"+last_year_balance_sum+"',debit_year_sum='"+debit_year_sum+"',loan_year_sum='"+loan_year_sum+"',debit_month_sum='"+debit_month_sum+"',loan_month_sum='"+loan_month_sum+"',current_balance_sum='"+current_balance_sum+"' where first_kind_ID='"+first_kind_ID+"' and  second_kind_ID='"+second_kind_ID+"' and third_kind_ID='"+third_kind_ID+"'";
finance_db.executeUpdate(sql33);
}
//对于有数量的科目处理如下

if(!first_kind_name.equals("库存商品")&&!first_kind_name.equals("固定资产")&&!first_kind_name.equals("主营业务收入")&&!first_kind_name.equals("主营业务成本")){

	String sql4="update finance_account_details set last_year_balance_sum='"+last_year_balance_sum1+"','"+last_year_balance_sum1+"',debit_year_sum='"+debit_year_sum1+"',loan_year_sum='"+loan_year_sum1+"',current_balance_sum='"+current_balance_sum1+"' where first_kind_ID='"+first_kind_ID+"' and  second_kind_ID='"+second_kind_ID+"' and third_kind_ID='"+third_kind_ID+"'";
finance_db.executeUpdate(sql4);
}else{
	double current_balance_price=0.0d;
	if(Double.parseDouble(current_balance_amount)!=0){
		current_balance_price=Double.parseDouble(current_balance_sum1)/Double.parseDouble(current_balance_amount);
	}
String sql44="update finance_account_details set last_year_balance_sum='"+last_year_balance_sum1+"','"+last_year_balance_sum1+"',debit_year_sum='"+debit_year_sum1+"',loan_year_sum='"+loan_year_sum1+"',current_balance_sum='"+current_balance_sum1+"',last_year_balance_amount='"+last_year_balance_amount+"',debit_year_amount='"+debit_year_amount+"',loan_year_amount='"+loan_year_amount+"',current_balance_amount='"+current_balance_amount+"',current_balance_price='"+current_balance_price+"' where first_kind_ID='"+first_kind_ID+"' and  second_kind_ID='"+second_kind_ID+"' and third_kind_ID='"+third_kind_ID+"'";
finance_db.executeUpdate(sql44);

}

//如果明细账里没有记录，处理如下
}else{

		String[] name=getNameFromID.getNameFromID((String)dbSession.getAttribute("unit_db_name"),first_kind_ID);



String sql1="select * from finance_account where first_kind_ID='"+first_kind_ID+"' and second_kind_ID='' and third_kind_ID=''";
ResultSet rs1=finance_db.executeQuery(sql1);
if(rs1.next()){

double last_year_balance_sum=rs1.getDouble("last_year_balance_sum")+Double.parseDouble(last_year_balance_sum1);
double debit_year_sum=rs1.getDouble("debit_year_sum")+Double.parseDouble(debit_year_sum1);
double loan_year_sum=rs1.getDouble("loan_year_sum")+Double.parseDouble(loan_year_sum1);
double current_balance_sum=rs1.getDouble("current_balance_sum")+Double.parseDouble(current_balance_sum1);
double debit_month_sum=rs1.getDouble("debit_month_sum")+Double.parseDouble(debit_year_sum1);
double loan_month_sum=rs1.getDouble("loan_month_sum")+Double.parseDouble(loan_year_sum1);


String sql11="update finance_account set last_year_balance_sum='"+last_year_balance_sum+"',last_month_balance_sum='"+last_year_balance_sum+"',debit_year_sum='"+debit_year_sum+"',loan_year_sum='"+loan_year_sum+"',debit_month_sum='"+debit_month_sum+"',loan_month_sum='"+loan_month_sum+"',current_balance_sum='"+current_balance_sum+"' where first_kind_ID='"+first_kind_ID+"' and  second_kind_ID='' and third_kind_ID=''";
finance_db.executeUpdate(sql11);

}else{
String sql5 = "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('"+first_kind_ID+"','"+first_kind_name+"','','','','','"+name[0]+"','"+name[1]+"','"+name[2]+"','"+name[3]+"','"+name[4]+"','"+last_year_balance_sum1+"','"+last_year_balance_sum1+"','"+debit_year_sum1+"','"+loan_year_sum1+"','"+debit_year_sum1+"','"+loan_year_sum1+"','"+current_balance_sum1+"','"+finance_time1+"')" ;
    	finance_db.executeUpdate(sql5) ;


}



String sql2="select * from finance_account where first_kind_ID='"+first_kind_ID+"' and  second_kind_ID='"+second_kind_ID+"' and third_kind_ID=''";
ResultSet rs2=finance_db.executeQuery(sql2);


if(rs2.next()){

double last_year_balance_sum=rs2.getDouble("last_year_balance_sum")+Double.parseDouble(last_year_balance_sum1);
double debit_year_sum=rs2.getDouble("debit_year_sum")+Double.parseDouble(debit_year_sum1);
double loan_year_sum=rs2.getDouble("loan_year_sum")+Double.parseDouble(loan_year_sum1);
double current_balance_sum=rs2.getDouble("current_balance_sum")+Double.parseDouble(current_balance_sum1);
double debit_month_sum=rs2.getDouble("debit_month_sum")+Double.parseDouble(debit_year_sum1);
double loan_month_sum=rs2.getDouble("loan_month_sum")+Double.parseDouble(loan_year_sum1);

String sql22="update finance_account set last_year_balance_sum='"+last_year_balance_sum+"',last_month_balance_sum='"+last_year_balance_sum+"',debit_year_sum='"+debit_year_sum+"',loan_year_sum='"+loan_year_sum+"',debit_month_sum='"+debit_month_sum+"',loan_month_sum='"+loan_month_sum+"',current_balance_sum='"+current_balance_sum+"' where first_kind_ID='"+first_kind_ID+"' and  second_kind_ID='"+second_kind_ID+"' and third_kind_ID=''";
finance_db.executeUpdate(sql22);
}else{
String sql5 = "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('"+first_kind_ID+"','"+first_kind_name+"','"+second_kind_ID+"','"+second_kind_name+"','','','"+name[0]+"','"+name[1]+"','"+name[2]+"','"+name[3]+"','"+name[4]+"','"+last_year_balance_sum1+"','"+last_year_balance_sum1+"','"+debit_year_sum1+"','"+loan_year_sum1+"','"+debit_year_sum1+"','"+loan_year_sum1+"','"+current_balance_sum1+"','"+finance_time1+"')" ;
    	finance_db.executeUpdate(sql5) ;
}
String sql5 = "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('"+first_kind_ID+"','"+first_kind_name+"','"+second_kind_ID+"','"+second_kind_name+"','"+third_kind_ID+"','"+third_kind_name+"','"+name[0]+"','"+name[1]+"','"+name[2]+"','"+name[3]+"','"+name[4]+"','"+last_year_balance_sum1+"','"+last_year_balance_sum1+"','"+debit_year_sum1+"','"+loan_year_sum1+"','"+debit_year_sum1+"','"+loan_year_sum1+"','"+current_balance_sum1+"','"+finance_time1+"')" ;
    	finance_db.executeUpdate(sql5) ;
if(!first_kind_name.equals("库存商品")&&!first_kind_name.equals("固定资产")&&!first_kind_name.equals("主营业务收入")&&!first_kind_name.equals("主营业务成本")){
String sql6 = "insert into finance_account_details(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,current_balance_sum,finance_time) values('"+first_kind_ID+"','"+first_kind_name+"','"+second_kind_ID+"','"+second_kind_name+"','"+third_kind_ID+"','"+third_kind_name+"','"+name[0]+"','"+name[1]+"','"+name[2]+"','"+name[3]+"','"+name[4]+"','"+last_year_balance_sum1+"','"+last_year_balance_sum1+"','"+debit_year_sum1+"','"+loan_year_sum1+"','"+current_balance_sum1+"','"+finance_time+"')" ;
    	finance_db.executeUpdate(sql6) ;
}else{
	double current_balance_price=0.0d;
	if(Double.parseDouble(current_balance_amount)!=0){
		current_balance_price=Double.parseDouble(current_balance_sum1)/Double.parseDouble(current_balance_amount);
	}
String sql7 = "insert into finance_account_details(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,current_balance_sum,last_year_balance_amount,debit_year_amount,loan_year_amount,current_balance_amount,current_balance_price,finance_time) values('"+first_kind_ID+"','"+first_kind_name+"','"+second_kind_ID+"','"+second_kind_name+"','"+third_kind_ID+"','"+third_kind_name+"','"+name[0]+"','"+name[1]+"','"+name[2]+"','"+name[3]+"','"+name[4]+"','"+last_year_balance_sum1+"','"+last_year_balance_sum1+"','"+debit_year_sum1+"','"+loan_year_sum1+"','"+current_balance_sum1+"','"+last_year_balance_amount+"','"+debit_year_amount+"','"+loan_year_amount+"','"+current_balance_amount+"','"+current_balance_price+"','"+finance_time+"')" ;
    	finance_db.executeUpdate(sql7) ;
}
}
}
finance_db1.commit();
finance_db.commit();
finance_db.close();
finance_db1.close();
response.sendRedirect("finance/config/account_init/registerThird_batch_init_ok_a.jsp");
}else{
	response.sendRedirect("error_conn.htm");
}
}
	catch (Exception e) {
		e.printStackTrace();
	}
}
}