| | |
|---|
| | | List<Object> params = new ArrayList<>(); |
|---|
| | | String projectItem = autoCreateFilter(params, fseParseData); |
|---|
| | | |
|---|
| | | //根据模板项目分项查询数据库项目分项 |
|---|
| | | FieldSetEntity fseProjectItem = baseDao.getFieldSetEntityByFilter(Cmnconst.PRODUCT_PROJECT_ITEM, "project_uuid IN (SELECT uuid FROM product_project_qxlw WHERE project_name=?) AND itemize_full_name=?", params.toArray(), false); |
|---|
| | | if(fseProjectItem==null) { |
|---|
| | | sbError.append(String.format("第 %s 行项目分项 '%s' 不存在于系统中。", fseParseData.getString("~row~"), projectItem)); |
|---|
| | | continue; |
|---|
| | | } |
|---|
| | | //设置关联项目分项 |
|---|
| | | fseParseData.setValue("project_itemize_uuid", fseProjectItem.getUUID()); |
|---|
| | | |
|---|
| | | //获取编码生成材料类型 |
|---|
| | | String budgetCode = fseParseData.getString(Cmnconst.BUDGET_CODE); |
|---|
| | | Integer materialType = 0; |
|---|
| | | if("架立筋".equals(budgetCode)) { |
|---|
| | | materialType = 1; |
|---|
| | | }else if("声测管".equals(budgetCode)) { |
|---|
| | | materialType = 2; |
|---|
| | | }else { |
|---|
| | | //网片 |
|---|
| | | FieldSetEntity materialInfo = baseDao.getFieldSetEntityByFilter(Cmnconst.PRODUCT_PROJECT_BASE_MATERIAL, "material_type=3 AND material_name like ?", new Object[] {fseParseData.getString(Cmnconst.MATERIAL_CODE)+"%"}, false); |
|---|
| | | if (materialInfo!=null) { |
|---|
| | | materialType = 3; |
|---|
| | | } |
|---|
| | | } |
|---|
| | | fseParseData.setValue(Cmnconst.MATERIAL_TYPE, materialType); |
|---|
| | | } |
|---|
| | | //判断是否包含错误信息 |
|---|
| | | if (!BaseUtil.strIsNull(sbError.toString())) { |
|---|
| | | throw new BaseException(SystemCode.PROJECT_BUDGET_IMPORT_FAIL.getValue(), sbError.toString()); |
|---|
| | | } |
|---|
| | | // baseDao.add(dtParseData); |
|---|
| | | return dtParseData; |
|---|
| | | } |
|---|
| | | |
|---|
