using Interface;
using Models;
using Models.Entity.LottomatBaseDB;
using Models.Views;
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;
using Services;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace Business.TK
{
    public static class Tk_GalleryBLL
    {
        static ZXInterface service;
        static Tk_GalleryBLL()
        {
            service = new ZXServic();
        }
        public static List<Tk_Gallery> GetPageList(int page, int rows, Dictionary<string, Object> queryParam, out int count, string order = null, bool isDesc = false)
        {

            List<EExpression> listexp = new List<EExpression>();
            if (queryParam.Keys.Count > 0)
            {
                if (queryParam.ContainsKey("ID"))
                {

                    string ID = queryParam["ID"].ToString();
                    listexp.Add(new EExpression("ID", "=", ID));
                }
                if (queryParam.ContainsKey("GalleryNumber"))
                {
                    int GalleryNumber = (int)queryParam["GalleryNumber"];
                    listexp.Add(new EExpression("GalleryNumber", "=", GalleryNumber));
                }
                if (queryParam.ContainsKey("GalleryName"))
                {
                    string GalleryName = queryParam["GalleryName"].ToString();
                    listexp.Add(new EExpression("GalleryName", "=", GalleryName));
                }
                if (queryParam.ContainsKey("CategoryId"))
                {
                    string CategoryId = queryParam["CategoryId"].ToString();
                    listexp.Add(new EExpression("CategoryId", "=", CategoryId));
                }
                if (queryParam.ContainsKey("SortCode"))
                {
                    int SortCode = (int)queryParam["SortCode"];
                    listexp.Add(new EExpression("SortCode", "=", SortCode));
                }
                if (queryParam.ContainsKey("IsPicZip"))
                {
                    int IsPicZip = (int)queryParam["IsPicZip"];
                    listexp.Add(new EExpression("IsPicZip", "=", IsPicZip));
                }
                if (queryParam.ContainsKey("Reamrk"))
                {
                    string Reamrk = queryParam["Reamrk"].ToString();

                    listexp.Add(new EExpression("Reamrk", EnumExpression.like, Reamrk));
                }
                if (queryParam.ContainsKey("SeoKey"))
                {
                    string SeoKey = "%" + queryParam["SeoKey"].ToString() + "%";
                    listexp.Add(new EExpression("SeoKey", EnumExpression.like, SeoKey));
                }
                if (queryParam.ContainsKey("CreateTime"))
                {
                    string CreateTime = queryParam["CreateTime"].ToString();
                    listexp.Add(new EExpression("CreateTime", "=", CreateTime));
                }
                if (queryParam.ContainsKey("HotNumber"))
                {
                    int HotNumber = (int)queryParam["HotNumber"];
                    listexp.Add(new EExpression("HotNumber", "=", HotNumber));
                }
                if (queryParam.ContainsKey("AreaCode"))
                {
                    string AreaCode = queryParam["AreaCode"].ToString();
                    listexp.Add(new EExpression("AreaCode", "=", AreaCode));
                }
            }
            var data = service.GetList<Tk_Gallery>(page, rows, order, listexp, isDesc);
            count = service.GetPageListCount<Tk_Gallery>(listexp);
            return data;

        }

        /// <summary>
        /// 获取数据最新期号
        /// </summary>
        /// <returns></returns>
        public static int NewPeriodsNumber()
        {
            string sql = string.Format(@" select  top 1 * from Tk_GalleryDetail   where
    GalleryId in (select ID from Tk_Gallery )  order by PeriodsNumber desc");
            List<Tk_GalleryDetail> list = service.ExSqlGetList<Tk_GalleryDetail>(sql);
            if (list != null)
            {
                return int.Parse(list[0].PeriodsNumber.ToString());
            }
            return 0;
        }
        public static List<string> GalleryNumberList()
        {
            string sql = string.Format(@"SELECT   DISTINCT  TOP 100   PeriodsNumber FROM (SELECT  TOP 100000  PeriodsNumber    FROM  Tk_GalleryDetail   ORDER BY addTime DESC)  	 AS a ");
            List<string> list = service.ExSqlGetstringList(sql);
            return list;
        }
        /// <summary>
        /// 获取此年份的最大期数
        /// </summary>
        /// <param name="year">年份</param>
        /// <returns></returns>
        public static string GetYearMaxPeridos(string year)
        {
            string sql= string.Format(@" select PeriodsNumber
                                          from Tk_GalleryDetail 
                                          where CreateTime =(select MAX(CreateTime) 
                                          from Tk_GalleryDetail 
                                          where CreateTime <='{0}-12-31 00:00:00')", year);
            string peridos = service.ExecuteScalar(sql).ToString();
            return peridos;
        }

        public static Tk_Gallery QueryItemByKey(object key)
        {
            return service.QueryItembyKey<Tk_Gallery>(key);
        }
    }
}