储运投资

最新推荐文章于 2024-10-20 00:00:34 发布

iteye_14624

最新推荐文章于 2024-10-20 00:00:34 发布

阅读量100

点赞数

分类专栏： New_Platform 文章标签： C C++ C#

New_Platform 专栏收录该内容

2 篇文章

订阅专栏

本文提供了一种从数据库中查询投资建设项目详细信息的方法，包括本月、本年累计、去年累计及自开工以来的投资完成情况和计划余额等关键数据。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

本月:

select i.DISPNAME,s.NAME,ROUND(d.FINISHED_INFO) FINISHED_INFO,
ROUND(d.PLAN_BALANCE) PLAN_BALANCE,d.PLAN_NO,
d.START_DATE,ROUND(d.TOTAL_INVEST) TOTAL_INVEST,ROUND(d.THISYEAR_INVEST) THISYEAR_INVEST,
ROUND(d.STR_CONSTRUCTION) STR_CONSTRUCTION,
ROUND(d.STR_EQUIPMENT) STR_EQUIPMENT,ROUND(d.STR_FIX) STR_FIX,
ROUND(d.STR_OTHER) STR_OTHER
from DT_INVEST_INFO_DETAIL d,DT_INVEST_INFO r,DT_INVEST_ITEM i,SYS_DICTIONARY s
WHERE d.DT_INVEST_INFO = r.ID
and s.TYPE = i.ITEMTYPE
and i.INVESTTYPE = s.ID
and i.ID = d.PROJECT_NAME
and r.AUDIT_STATUS = '1'
and r.ORG_TYPE = ?
and r.YEAR_MONTH = ?
and r.PROJECT_TYPE = 'TZXM-CYXM' ORDER BY i.DISPNO asc

分类:

select s.NAME
from SYS_DICTIONARY s,SYS_DICTIONARYCONFIG c
where c.ID = s.TYPE
and c.CODE = 'TZXM-CYXM'
order by s.ID asc

本年累计:

select i.DISPNAME,ROUND(d.FINISHED_INFO) FINISHED_INFO,
ROUND(d.PLAN_BALANCE) PLAN_BALANCE,d.PLAN_NO,d.PROJECT_NAME,
d.START_DATE,ROUND(d.TOTAL_INVEST) TOTAL_INVEST,ROUND(d.THISYEAR_INVEST) THISYEAR_INVEST,
ROUND(d.STR_CONSTRUCTION) STR_CONSTRUCTION,
ROUND(d.STR_EQUIPMENT) STR_EQUIPMENT,ROUND(d.STR_FIX) STR_FIX,
ROUND(d.STR_OTHER) STR_OTHER
from DT_INVEST_INFO_DETAIL d,DT_INVEST_INFO r,DT_INVEST_ITEM i,SYS_DICTIONARY s
where d.DT_INVEST_INFO = r.ID
and s.TYPE = i.ITEMTYPE
and i.INVESTTYPE = s.ID
and i.ID = d.PROJECT_NAME
and r.AUDIT_STATUS = '1'
and r.ORG_TYPE = ?
and r.YEAR_MONTH between ? and ?
and r.PROJECT_TYPE = 'TZXM-CYXM'  
order by i.DISPNO asc

去年累计:

select i.DISPNAME,ROUND(d.FINISHED_INFO) FINISHED_INFO,
ROUND(d.PLAN_BALANCE) PLAN_BALANCE,d.PLAN_NO,d.PROJECT_NAME,
d.START_DATE,ROUND(d.TOTAL_INVEST) TOTAL_INVEST,ROUND(d.THISYEAR_INVEST) THISYEAR_INVEST,
ROUND(d.STR_CONSTRUCTION) STR_CONSTRUCTION,
ROUND(d.STR_EQUIPMENT) STR_EQUIPMENT,ROUND(d.STR_FIX) STR_FIX,
ROUND(d.STR_OTHER) STR_OTHER
from DT_INVEST_INFO_DETAIL d,DT_INVEST_INFO r,DT_INVEST_ITEM i,SYS_DICTIONARY s
where d.DT_INVEST_INFO = r.ID
and s.TYPE = i.ITEMTYPE
and i.INVESTTYPE = s.ID
and i.ID = d.PROJECT_NAME
and r.AUDIT_STATUS = '1'
and r.ORG_TYPE = ?
and r.YEAR_MONTH between ? and ?
and r.PROJECT_TYPE = 'TZXM-CYXM'  
order by i.DISPNO asc

自开工累计:

select i.DISPNAME,ROUND(d.FINISHED_INFO) FINISHED_INFO,
ROUND(d.PLAN_BALANCE) PLAN_BALANCE,d.PLAN_NO,d.PROJECT_NAME,
d.START_DATE,ROUND(d.TOTAL_INVEST) TOTAL_INVEST,ROUND(d.THISYEAR_INVEST) THISYEAR_INVEST,
ROUND(d.STR_CONSTRUCTION) STR_CONSTRUCTION,
ROUND(d.STR_EQUIPMENT) STR_EQUIPMENT,ROUND(d.STR_FIX) STR_FIX,
ROUND(d.STR_OTHER) STR_OTHER
from DT_INVEST_INFO_DETAIL d,DT_INVEST_INFO r,DT_INVEST_ITEM i,SYS_DICTIONARY s
where d.DT_INVEST_INFO = r.ID
and s.TYPE = i.ITEMTYPE
and i.INVESTTYPE = s.ID
and i.ID = d.PROJECT_NAME
and r.AUDIT_STATUS = '1'
and r.ORG_TYPE = ?
and d.START_DATE between ? and ?
and r.PROJECT_TYPE = 'TZXM-CYXM'  
ORDER BY i.DISPNO asc