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);
|
}
|
}
|
}
|
}
|
