select dbo.get_pro_projectcatory_and_elementsname_sum1(projectid,'其他费用','建设单位管理费') jiansheguanliwanchengshu2,
				dbo.get_pro_projectcatory_and_elementsname_sum1(projectid,'其他费用','造价咨询费') zaojiazixunwanchengshu2,
			* from project_info


		select	dbo.get_pro_projectcatory_and_elementsname_sum1('1722A0051020010306','其他费用','建设单位管理费') jiansheguanliwanchengshu2


		select * from [dbo].[project_cost_calcrule_main]
		select costcatory,projectcatory,elementsno,elementsname from [dbo].[project_cost_calcrule_detail]
		select * from [dbo].[project_cost_calcrule_detail] where projectname = '秋林202-H1'


		 
		select sum(isnull(catorygaisuan,0.00)) from project_info_zonggaisuan_catory where projectid = ''

		--项目总概算
		select dbo.get_pro_gaisuan_all_2023(projectid),* from project_info 
		
		--某一个项目，某大类，某小类的概算
        select dbo.get_pro_gaisuan_projectcatory_elementsname_2023(projectid,projectcatory,elementsname)
		,projectid,projectname,projectcatory,elementsname
		from [dbo].[project_cost_calcrule_detail] where projectid = '1718A00140200102'  
        group by projectid,projectname,projectcatory,elementsname,projectcatoryindex,elementsindex
		order by  projectcatoryindex,elementsindex