| | |
|---|
| | | |
|---|
| | | //治疗单项目 |
|---|
| | | sql.setLength(0); |
|---|
| | | sql.append(" select tp.id, tp.projectName, tp.projectNo, tp.num, tp.isDeduct, tp.sdRemark, tp.itemMode ") |
|---|
| | | sql.append(" select tp.id, tp.projectName, tp.num, tp.isDeduct, tp.sdRemark, tp.itemMode ") |
|---|
| | | .append(" , tp.isUserPro, tp.deductNum ") |
|---|
| | | .append(" , p.specification as spec, p.unit, pi.doctorQualification, pi.bodyPartName as bodyPartsName ") |
|---|
| | | .append(" , p.coding as projectNo, p.specification as spec, p.unit, pi.doctorQualification, pi.bodyPartName as bodyPartsName ") |
|---|
| | | .append(" from treat_project tp ") |
|---|
| | | .append(" LEFT JOIN project p ON p.id = tp.goodsId ") |
|---|
| | | .append(" LEFT JOIN project_info pi ON p.id = pi.projectId ") |
|---|
