using System.Collections.Generic;
using System.Linq;
using CommonHelper;
using CommonHelper.Format;
using GasolineBlend.Entity;
using Pissa.Service.Extend;
using SqlSugar;

namespace Pissa.Service.DbService
{
    public class SysService:Repository<SysCountry>
    {

        /// <summary>
        /// 获取字典信息
        /// </summary>
        /// <param name="dictCode"></param>
        /// <returns></returns>
        public List<SysDictItem> GetDictItems(string dictCode)
        {
            var res =  Context.Queryable<SysDictItem>()
                .Where(a => a.DictId == SqlFunc.Subqueryable<SysDict>().Where(b => b.DictCode == dictCode)
                    .Select(b => b.Id))
                .OrderBy(a=>a.SortOrder)
                .ToList();
            return res;
        }

        /// <summary>
        /// 获取ipc
        /// </summary>
        /// <param name="year">年份</param>
        /// <param name="parentCode">父编码</param>
        /// <returns></returns>
        public List<SysIpcClass> GetIpcClass(int year, string parentCode = "")
        {
            var res = Context.Queryable<SysIpcClass>()
                .Where(a => a.Year == year)
                .Where(a => a.ParentCode == parentCode)
                .OrderBy(a => a.Sort1).OrderBy(a => a.Sort2)
                .ToList();
            return res;
        }

        /// <summary>
        /// 获取cpc
        /// </summary>
        /// <param name="parentCode">父编码</param>
        /// <returns></returns>
        public List<SysCpcClass> GetCpcClass( string parentCode = "")
        {
            var res = Context.Queryable<SysCpcClass>()
                .Where(a => a.ParentCode == parentCode)
                .WhereIF(parentCode.IsNullOrEmpty(), a=>a.Code.Length ==1)
                .OrderBy(a=>a.Sort1).OrderBy(a => a.Sort2)
                .ToList();
            return res;
        }
        /// <summary>
        /// 获取产业分类
        /// </summary>
        /// <returns></returns>
        public List<IviewTree> GetStraindustryTree()
        {
            var data = Context.Queryable<SysStraindustry>().OrderBy(a => a.Code).ToList();
            var tree = TreeHelper.GenerateIviewTree(data, a => a.Code,
                a => a.Code.Contains(".") ? a.Code.Substring(0, a.Code.IndexOf(".")) : null,
                a => a.Code,
                a=>a.Name
            ).ToList();
            return tree;
        }

        /// <summary>
        /// 获取国民经济行业分类
        /// </summary>
        /// <returns></returns>
        public List<IviewTree> GetEcoindustryTree()
        {
            var data = Context.Queryable<SysEcoindustry>().OrderBy(a=>a.Code).ToList();
            var tree = TreeHelper.GenerateIviewTree(data, a => a.Code,
                a =>a.Code.Length>3?a.Code.Substring(0,a.Code.Length-1):(a.Code.Length==3?a.Code.Substring(0,1): null),
                a => a.Code,
                a => a.Name).ToList();
            return tree;
        }

        /// <summary>
        /// 插入搜索记录
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool AddPatentSearchLog(SysPatentSearchLog model)
        {
            var id = Context.Insertable<SysPatentSearchLog>(model).ExecuteReturnIdentity();
            return true;
        }
        /// <summary>
        /// 获取搜索记录分页
        /// </summary>
        /// <param name="userId"></param>
        /// <param name="pageIndex"></param>
        /// <param name="pageSize"></param>
        /// <returns></returns>
        public Page<SysPatentSearchLog> GetPatentSearchLog(string userId, int pageIndex, int pageSize,string searchType)
        {
            if (pageIndex <= 0)
                pageIndex = 1;
            if (pageSize <= 0)
                pageSize = 20;

            var page = Context.Queryable<SysPatentSearchLog>()
                .Where(a => a.UserId == userId)
                .WhereIF(!string.IsNullOrWhiteSpace(searchType),a=>a.SearchType == searchType)
                .OrderBy(a => a.SearchTime, OrderByType.Desc)
                .ToPage(pageIndex, pageSize);
            return page;
        }
        /// <summary>
        /// 洛迦诺分类
        /// </summary>
        /// <returns></returns>
        public List<IviewTree> GetLoccn()
        {
            var data = Context.Queryable<SysLoccn>().OrderBy(a => a.Sort1).OrderBy(a=>a.Sort2).ToList();
            var tree = TreeHelper.GenerateIviewTree(data, a => a.Code,
                a => a.ParentCode,
                a => a.Code,
                a => a.Desc).ToList();
            return tree;
        }

    }
}