Part/BOM的导入

/**
* 根据路径读取excel中的part信息并创建part
* @param filepath
* @throws Exception
*/
public static void uploadfile(String filepath) throws Exception{

List list = readExcel(new FileInputStream(filepath));
StringBuffer parts = new StringBuffer();
if(list != null){
HashMap map = new HashMap();
map = (HashMap) list.get(0);
Set tempset = map.keySet();
for (Object o : tempset) {
parts.append(o.toString()).append(",");
}
parts.append("------------");
for (int i = 0; i < list.size(); i++) {
map = (HashMap) list.get(i);
Set set = map.keySet();
String name = map.get("名称").toString();
String number = map.get("编号").toString();
String state = map.get("状态").toString();
String creator = map.get("创建者").toString();
String createtime = map.get("创建时间").toString();
String modifytime = map.get("修改时间").toString();
String productname = map.get("产品名称").toString();
for (Object so : set) {
parts.append(map.get(so.toString()).toString()).append(",");
}
HashMap needmap = new HashMap();

needmap.put("name", name);
needmap.put("number", number);
needmap.put("state", state);
needmap.put("creator", creator);
needmap.put("createtime", createtime);
needmap.put("modifytime", modifytime);
needmap.put("productname", productname);
createPart(needmap, thispartcontainer);

}



}

}

评论

4 楼 ba1du 2010-10-18  

private static final ReferenceFactory rf = new ReferenceFactory();
//指定文件夹路径、part对象、生命周期、容器
private static String UPLOAD_FILE_PATH="D:\\temp\\";
private static WTPart thispart;
private static LifeCycleState thispartstate;
private static WTContainer thispartcontainer;

//指定导入的part的生命周期、容器和当前part的一样
static{
try {
thispart= (WTPart) getObjectByOid("VR:wt.part.WTPart:311117");
thispartstate = thispart.getState();
thispartcontainer = thispart.getContainer();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}

/**
* 根据oid获取对象
* @param oid oid
* @return 对象
* @throws WTException
*/
public static Object getObjectByOid(String oid) throws WTException{

return rf.getReference(oid).getObject();
}
/**
* test
* @param args
* @throws Exception
*/
public static void main(String[] args) throws Exception {
// TODO Auto-generated method stub
System.out.println(thispartstate);
System.out.println(thispartcontainer);
//uploadfile("D:\\temp\\BOM-2.xls");

}

3 楼 ba1du 2010-09-30  

/**
* 根据part编号得到part
* @author xum 2010-9-30
* @param partNumber part编号
* @return part
* @throws Exception
*/
public static WTPart getPartByNumber(String partNumber) throws Exception{
QuerySpec qs = null;
QueryResult qr = null;
qs = new QuerySpec(WTPart.class);
qs.appendSearchCondition(new SearchCondition(WTPart.class,WTPart.NUMBER,SearchCondition.EQUAL,partNumber));
qr=PersistenceHelper.manager.find(qs);
if(qr.hasMoreElements()){
return (WTPart)qr.nextElement();
}
return null;
}

2 楼 ba1du 2010-09-30  

/**
* 根据excel中的part信息创建part
* @author xum 2010-9-30
* @param partmap part属性
* @param container part的容器
* @throws Exception
*/
public static void createPart(HashMap partmap,WTContainer container) throws Exception{
WTPart part=WTPart.newWTPart();
String name = partmap.get("name") == null ? "" : partmap.get("name").toString();
String number = partmap.get("number") == null ? "" : partmap.get("number").toString();
String state = partmap.get("state") == null ? "" : partmap.get("state").toString();
String creator = partmap.get("creator") == null ? "" : partmap.get("creator").toString();
String createtime = partmap.get("createtime") == null ? "" : partmap.get("createtime").toString();
String modifytime = partmap.get("modifytime") == null ? "" : partmap.get("modifytime").toString();
String productname = partmap.get("productname") ==null ? "" : partmap.get("productname").toString();


WTPart existpart = getPartByNumber(number);
if(existpart == null){
if(name.trim().length() > 0){
part.setName(name);
}
if(number.trim().length() > 0){
part.setNumber(number);
}
}
if(state.trim().length() > 0){
// State objstate = State.toState(state);
// LifeCycleState lcs = new LifeCycleState();
// lcs.setState(objstate);
// part.setState(lcs);
part.setState(thispartstate);
}

part.setContainer(container);
PersistenceHelper.manager.save(part);



}

1 楼 ba1du 2010-09-30  

/**
* 将excel中的part信息存到List中
* @author xum 2010-9-30
* @param is 文件流
* @return 存放excel中的part信息的list
* @throws Exception
*/
public static List readExcel(InputStream is) throws Exception{
HSSFWorkbook workbook = new HSSFWorkbook(is);
HSSFSheet sheet = workbook.getSheetAt(0);
List ldoc = new ArrayList();
HashMap hdoc = null;
HSSFRow row0 = sheet.getRow(0);
HSSFRow row = null;
for (int i = 1; i <= sheet.getLastRowNum(); i++) {
row = sheet.getRow(i);
if(row == null){
continue;
}
hdoc = new HashMap();
int celltype = 1;
for(int j = 0; j < row.getLastCellNum(); j ++){
if(row0.getCell((short)j) == null){
continue;
}
String cellvalue = "";
celltype = row.getCell((short)j) == null ? 5 : row.getCell((short)j).getCellType();
if(celltype==0){
cellvalue=String.valueOf(row.getCell((short)j).getNumericCellValue());
if(cellvalue.endsWith(".0")){
cellvalue = cellvalue.substring(0,cellvalue.length()-2);
}
}else if(celltype==1){
cellvalue=row.getCell((short)j).getStringCellValue();

}
hdoc.put(row0.getCell((short)j).getStringCellValue(), cellvalue);
}
ldoc.add(hdoc);
}
return ldoc;
}