涉及到ERP系统数据分析:三个数据分析表,三个图形展示。前台EXT.NET1.5 +MSCHART
IQC来料情况表:
存储过程:
-- ============================================= -- Author:-- Create date:-- Description: -- ============================================= ALTER Proc [dbo].[UF_ZEIQCReport] ( @year as varchar(4) ) as begin --IQC检验情况 --创建临时表 create table #Tmp --创建临时表#Tmp ( Item varchar(20), Jan decimal(9,2), Feb decimal(9,2), Mar decimal(9,2), Apr decimal(9,2), May decimal(9,2), Jun decimal(9,2), J