Exemplo n.º 1
0
        /// <summary>
        /// 获取企业变动状况列表总数(注册资产排序)
        /// </summary>
        /// <param name="dto"></param>
        /// <returns></returns>
        public int GetEntZczjCount(EntZczbChangeDto dto)
        {
            return(SqlBaseOperation.Query <int>($@" 
select count(*)  from
( select REG_CAPITAL, NAT_ORG_CODE, ORG_NAME, ORG_ADDR, ORG_ADDR2,INDUSTRY_ID,CURR_TYPE_ID from org_info2 ) a,
( select * from ndic_industry ) b
where a.INDUSTRY_ID=b.Industry_Type4_Id(+) ").SingleOrDefault());
        }
Exemplo n.º 2
0
        /// <summary>
        /// 获取企业变动状况列表(注册资产排序)
        /// </summary>
        /// <param name="dto"></param>
        /// <returns></returns>
        public List <dynamic> GetEntZczjList(EntZczbChangeDto dto)
        {
            StringBuilder strsql = new StringBuilder($@" 
select * from (
select row_number() over(order by nvl(a.REG_CAPITAL,0) {dto.OrderBy}) r, round(nvl(REG_CAPITAL,0),2) REG_CAPITAL, NAT_ORG_CODE, ORG_NAME, ORG_ADDR, ORG_ADDR2, INDUSTRY_ID, X.CURR_NAME, b.industry_mtype_name from
( select CURR_TYPE_DM, CURR_NAME from dic_curr_type ) x,
( select REG_CAPITAL, NAT_ORG_CODE, ORG_NAME, ORG_ADDR, ORG_ADDR2,INDUSTRY_ID,CURR_TYPE_ID from org_info2 ) a,
( select * from ndic_industry ) b
where a.INDUSTRY_ID=b.Industry_Type4_Id(+) and a.curr_type_id=x.curr_type_dm(+)  
order by nvl(a.REG_CAPITAL,0) {dto.OrderBy}
) where r between {dto.BeginPagNum} and {dto.EndPagNum} ");

            return(SqlBaseOperation.Query(strsql.ToString()));
        }
Exemplo n.º 3
0
        public EntZdgzRepository(EntZczbChangeDto entZczbChangeDto)
        {
            EntZdgzFactoryBase entZdgzFactory = new EntZdgzFactory.EntZdgzFactory(entZczbChangeDto);

            _sqlBuildSubQuery = entZdgzFactory.GetSqlBuildSubQuery();
        }