Exemple #1
0
        protected EntRankFactoryBase(EntRankingRepository.EntRankingDto entRankingDto)
        {
            switch (entRankingDto.EnumTargetField)
            {
            case EnumTargetField.Tax:
                EntRankFieldTypeBase = new EntRankFieldTypeTax(entRankingDto);
                break;

            case EnumTargetField.Qjsr:
                EntRankFieldTypeBase = new EntRankFieldTypeQjsr(entRankingDto);
                break;

            case EnumTargetField.Gdp:
                EntRankFieldTypeBase = new EntRankFieldTypeGdp(entRankingDto);
                break;

            case EnumTargetField.Pl:
                throw new Exception("社会消费品零售额指标暂无");

            case EnumTargetField.Gdzc:
                throw new Exception("全社会固定资产投资指标暂无");

            case EnumTargetField.Cyry:
                EntRankFieldTypeBase = new EntRankFieldTypeCyry(entRankingDto);
                break;

            case EnumTargetField.Yysr:
                EntRankFieldTypeBase = new EntRankFieldTypeYysr(entRankingDto);
                break;

            case EnumTargetField.Zczj:
                EntRankFieldTypeBase = new EntRankFieldTypeZczj(entRankingDto);
                break;

            case EnumTargetField.Lrze:
                EntRankFieldTypeBase = new EntRankFieldTypeLrze(entRankingDto);
                break;

            case EnumTargetField.Nh:
                EntRankFieldTypeBase = new EntRankFieldTypeNh(entRankingDto);
                break;

            case EnumTargetField.Sh:
                EntRankFieldTypeBase = new EntRankFieldTypeSh(entRankingDto);
                break;

            default:
                throw new Exception("未知指标查询指令");
            }
        }
Exemple #2
0
        protected EntRankFieldTypeBase(EntRankingRepository.EntRankingDto entRankingDto)
        {
            EntRankingDto = entRankingDto;

            switch (EntRankingDto.Strategy)
            {
            case EnumStrategy.Targetsum:
                SqlBuildSubQuery.SelectColumn = " nvl(A.TARGETFIELD,0) ";
                break;

            case EnumStrategy.Zs:
                SqlBuildSubQuery.SelectColumn = " DECODE(NVL(B.TARGETFIELD,0),0,0,ROUND(((NVL(A.TARGETFIELD,0)-B.TARGETFIELD)/NVL(B.TARGETFIELD,0))*100,2)) ";
                break;

            case EnumStrategy.Zl:
                SqlBuildSubQuery.SelectColumn = " (NVL(A.TARGETFIELD,0)-NVL(B.TARGETFIELD,0))  ";
                break;

            default:
                throw new Exception("企业排名未知查询策略命令");
            }
        }
Exemple #3
0
 public EntRankFieldTypeZczj(EntRankingRepository.EntRankingDto entRankingDto) : base(entRankingDto)
 {
 }
Exemple #4
0
 public EntRankFactory(EntRankingRepository.EntRankingDto entRankingDto) : base(entRankingDto)
 {
 }