final static int PAGE_NUMBER = 200;
int size = pts.size();
int loop = size / PAGE_NUMBER;
if(size % PAGE_NUMBER > 0){
loop ++;
}
for(int k =0 ; k < loop ; k++){
int toIdnex = ((k+1) * PAGE_NUMBER);
if(toIdnex > size){
toIdnex = size;
}
List<Long> list = pts.subList((k * PAGE_NUMBER), toIdnex);
String pics = list.toString().substring(1, list.toString().indexOf("]", 1));
String sql = "UPDATE wms_pick_ticket p SET p.ele_status = 'DISTRIBUTION',p.elec_date = p.order_date"+" WHERE p.ID IN ("+pics+")";
dh.query(sql);
}
final int PAGE_NUMBER = 100;
int size = legs.size();
int j = JavaTools.getSize(size,PAGE_NUMBER);
for(int k = 0; k < j ; k++){
int toIdnex = JavaTools.getIndex(k,size,PAGE_NUMBER);
List<Object> ret = JavaTools.getList(legs, k, toIdnex,PAGE_NUMBER);
monitorService.manualSetMonitorRecord(ret, node, date);
}
//--------------
public static int getSize(int size,int PAGE_NUMBER){
int j = size / PAGE_NUMBER;
if((size % PAGE_NUMBER) > 0){
j += 1;
}
return j;
}
public static int getIndex(int k,int size,int PAGE_NUMBER){
int toIndex = ((k + 1) * PAGE_NUMBER);
if(toIndex > size){
toIndex = size;
}
return toIndex;
}
public static List<Object> getList(List<Object> list,int k,int toIdnex,int PAGE_NUMBER){
List<Object> ret = list.subList((k * PAGE_NUMBER), toIdnex);
return ret;
}