using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using FineAdmin.IRepository;
using FineAdmin.Model;
using Dapper;

namespace FineAdmin.Repository
{
    public class OrganizeRepository : BaseRepository<OrganizeModel>, IOrganizeRepository
    {
        public IEnumerable<OrganizeModel> GetOrganizeList()
        {
            using (var conn=OracleHelper.OracleConnection())
            {
                string sql = @"SELECT a.Id,a.ParentId,a.EnCode,a.FullName,a.SortCode,b.ItemName as CategoryName,a.CreateTime FROM dbsys_organize a
                               INNER JOIN dbsys_itemsdetail b ON a.CategoryId=b.Id ORDER BY SortCode ASC";
                return conn.Query<OrganizeModel>(sql);
            }
        }
    }
}