//构建新工单查询sql语句,按照工单号查找
sql_new="select instruct_id,childinstruct_id,instruct_text from "+new_instrctname+" where workorder_no='"+TempOrder+"' order by instruct_id";
rs_new=stmt_new.executeQuery(sql_new);
rs_new.next();
int new_rs_count=rs_new.getRow();
if(new_rs_count<=0){
int insold_id=1;
while(!rs_old.isAfterLast()){
out_log.println("The "+insold_id+"'s instruct 'iCmdID' is(old):"+rs_old.getString("iCmdID").trim());
out_log.println("The "+insold_id+"'s instruct 'iChildCmdID' is(old):"+rs_old.getString("iChildCmdID").trim());
out_log.println("The "+insold_id+"'s instruct is(old):"+rs_old.getString("szCmd").trim());
rs_old.next();
insold_id=insold_id+1;
}
out_log.println(Contrast_result1);
out_log.println("------------------------------");
out.println("Old workorder unique No is:"+i);
out.println("Workorder No is:"+TempOrder);
out.println("New workorder's content is:"+woc.converse(oldOrder,"1"));
out.println("Old workorder's content is:"+oldOrder);
out.println(Contrast_result1);
out.println("------------------------------");
}
else{
boolean isTrue=true;
int ins_id=1;
while(!rs_old.isAfterLast()){
out_log.println("The "+ins_id+"'s instruct 'iCmdID' is(old):"+rs_old.getString("iCmdID").trim());
out_log.println("The "+ins_id+"'s instruct 'iChildCmdID' is(old):"+rs_old.getString("iChildCmdID").trim());
out_log.println("The "+ins_id+"'s instruct is(old):"+rs_old.getString("szCmd").trim());
if(rs_new.isAfterLast()){
out_log.println("The "+ins_id+"'s instruct is empty(new)!");
isTrue=false;
//继续输出旧指令
rs_old.next();
ins_id=ins_id+1;
while(!rs_old.isAfterLast()){
out_log.println("The "+ins_id+"'s instruct 'iCmdID' is(old):"+rs_old.getString("iCmdID").trim());
out_log.println("The "+ins_id+"'s instruct 'iChildCmdID' is(old):"+rs_old.getString("iChildCmdID").trim());
out_log.println("The "+ins_id+"'s instruct is(old):"+rs_old.getString("szCmd").trim());
rs_old.next();
ins_id=ins_id+1;
}
break;
}
else{
out_log.println("The "+ins_id+"'s instruct 'instruct_id' is(new):"+rs_new.getString("instruct_id").trim());
out_log.println("The "+ins_id+"'s instruct 'childinstruct_id' is(new):"+rs_new.getString("childinstruct_id").trim());
out_log.println("The "+ins_id+"'s instruct is(new):"+rs_new.getString("instruct_text").trim());
if(contrastType.equals("id")){
//指令对比方式
if (!rs_old.getString("iCmdID").trim().equals(rs_new.getString("instruct_id").trim()) || (!rs_old.getString("iChildCmdID").trim().equals(rs_new.getString("childinstruct_id").trim()))){
//if (!rs_old.getString("szCmd").trim().equals(rs_new.getString("instruct_text").trim())){
isTrue=false;
//break;
}
}else{
//内容对比方式
if (!rs_old.getString("szCmd").trim().equals(rs_new.getString("instruct_text").trim())){
isTrue=false;
}
}
ins_id=ins_id+1;
rs_old.next();
rs_new.next();
}
}
out_log.println("Instuct's contrasting result is:"+isTrue);
out_log.println("------------------------------");
if(isTrue){
CouTrue=CouTrue+1;
out.println("------------------------------");
out_true.println(woc.converse(oldOrder,"1"));
//2006.04.29增加,为生产环境对比而增加
str_Tips="insert into t_Contrast_Instuct values"+
"('"+TempOrder+"',"+office_id_tmp+","+officegrp_id_tmp+","+product_id_tmp+","+business_id_tmp+",1,convert(datetime,'"+date_tmp+"'))";
//System.out.println(str_Tips);
stmt_Tips.executeUpdate(str_Tips);
}
else{
out.println("Old workorder unique No is:"+i);
out.println("Workorder No is:"+TempOrder);
out.println("New workorder's content is:"+woc.converse(oldOrder,"1"));
out.println("Old workorder's content is:"+oldOrder);
out.println(Contrast_result2);
out.println("------------------------------");
//2006.04.29增加,为生产环境对比而增加
str_Tips="insert into t_Contrast_Instuct values"+
"('"+TempOrder+"',"+office_id_tmp+","+officegrp_id_tmp+","+product_id_tmp+","+business_id_tmp+
",0,convert(datetime,'"+date_tmp+"'))";
stmt_Tips.executeUpdate(str_Tips);
}
}
rs_temp.next();
CountOrder2=CountOrder2+1;
}
//-------------------------
DecimalFormat df = new DecimalFormat();
df.applyPattern("#.0000%");
//-------------------------
out_log.println("The number which instruct's contrasting is ture is:"+CouTrue);
EndTime=new Date();
out_log.println("Contrasting end time is:"+EndTime);
out_log.println("It has "+CountOrder1+" old workorder instructs is empty,so it can not contrast the instructs!");
out_log.println("Have been contrasted "+CountOrder2+" workorders!");
out_log.println("-----------------------------------------------------------------");
out_log.println("The right percent is :"+df.format((double)CouTrue /(double)CountOrder2));
out_log.println("----------------------");
System.out.println("The number which instruct's contrasting is ture is:"+CouTrue);
System.out.println("Contrasting end time is:"+EndTime);
System.out.println("It has "+CountOrder1+" old workorder instructs is empty,so it can not contrast the instructs!");
System.out.println("Have been contrasted "+CountOrder2+" workorders!");
System.out.println("The right percent is :"+df.format((double)CouTrue /(double)CountOrder2));
}catch(java.io.IOException ex){
System.out.println("File not found!");
}