本帖最后由 lingling17 于 2021-2-22 20:46 编辑
- var sql1 = "select * from tlk_项目_单元 where COALESCE(item_INCODE,'') = '" + vINCODE + "'";
- var datas1 = queryBySQL(sql1);
- if (datas1 != null && datas1.size() > 0) {
- var docM = datas1.get(0);
- println(docM.getItemValueAsString("单元名称"));
- /* docM.findItem("单元名称").setValue(vDISPLAY_NAME);
- docM.findItem("所在楼层").setValue(vLOCATION);
- docM.findItem("bim编号").setValue(vDISPLAY_CODE);
- docM.findItem("TYPE").setValue(vTYPE);
- docM.findItem("isaudit").setValue(vSTATUS);
- docM.findItem("SPACE_LEVEL").setValue(vSPACE_LEVEL);
- docM.findItem("HEIGHT").setValue(vHEIGHT);
- docM.findItem("isaudit").setValue(vSTATUS);
- docM.findItem("CANVAS_ID").setValue(vCANVAS_ID);
- docM.findItem("LAYER_CODE").setValue(vLAYER_CODE);
- docM.findItem("LAYER_NAME").setValue(vLAYER_NAME);
- docM.findItem("VERTICES_JSON").setValue(vVERTICES_JSON);
- docM.findItem("TRUE_VERTICES_JSON").setValue(vTRUE_VERTICES_JSON);
- docM.findItem("楼层incode").setValue(vPARENT_INCODE);
- docM.findItem("图纸面积").setValue(vAREA);
- docM.findItem("FLOOR_HEIGHT").setValue(vFLOOR_HEIGHT);
- docM.findItem("单元状态").setValue(vgnlx);
- docM.findItem("功能类型").setValue(vTABLE13_INCODE);
- println(docM); */
- process.doUpdate(docM);
- }
复制代码 |