| | |
|---|
| | | * @return |
|---|
| | | */ |
|---|
| | | public boolean clearBudget(String projectUUID, String itemizeCode) { |
|---|
| | | //查询对应项目对应分项的出库数据 |
|---|
| | | DataTableEntity dtOutbound; |
|---|
| | | if(BaseUtil.strIsNull(itemizeCode)) { |
|---|
| | | dtOutbound = baseDao.listTable(Cmnconst.PRODUCT_PROJECT_OUTBOUND, "project_uuid=?", new Object[] {projectUUID}); |
|---|
| | | }else { |
|---|
| | | dtOutbound = baseDao.listTable(Cmnconst.PRODUCT_PROJECT_OUTBOUND, "project_uuid=? AND project_itemize IN (SELECT uuid FROM product_project_item WHERE project_uuid=? AND itemize_code LIKE ?)", new Object[] {projectUUID,projectUUID,itemizeCode+"%"}); |
|---|
| | | } |
|---|
| | | //判定出库数据是否存在 |
|---|
| | | if (!BaseUtil.dataTableIsEmpty(dtOutbound)) { |
|---|
| | | throw new BaseException(SystemCode.PROJeCT_BUDGET_CLEAR_FAIL_HAS_OUTBOUND.getValue(), SystemCode.PROJeCT_BUDGET_CLEAR_FAIL_HAS_OUTBOUND.getText()); |
|---|
| | | } |
|---|
| | | return false; |
|---|
| | | // if (BaseUtil.strIsNull(itemizeCode)) { |
|---|
| | | // return baseDao.executeUpdate("DELETE FROM product_project_budget WHERE project_itemize_uuid IN (SELECT uuid FROM product_project_item WHERE project_uuid=?)", new Object[] {projectUUID}); |
|---|
| | | // }else { |
|---|
| | | // return baseDao.executeUpdate("DELETE FROM product_project_budget WHERE project_itemize_uuid IN (SELECT uuid FROM product_project_item WHERE project_uuid=? AND itemize_code LIKE ?)", new Object[] {projectUUID,itemizeCode+"%"}); |
|---|
| | | // } |
|---|
| | | if (BaseUtil.strIsNull(itemizeCode)) { |
|---|
| | | return baseDao.executeUpdate("DELETE FROM product_project_budget WHERE project_itemize_uuid IN (SELECT uuid FROM product_project_item WHERE project_uuid=?)", new Object[] {projectUUID}); |
|---|
| | | }else { |
|---|
| | | return baseDao.executeUpdate("DELETE FROM product_project_budget WHERE project_itemize_uuid IN (SELECT uuid FROM product_project_item WHERE project_uuid=? AND itemize_code LIKE ?)", new Object[] {projectUUID,itemizeCode+"%"}); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | } |
|---|
