using AutoMapper;
using DTO;
using IServices;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using zhengcaioa.Models;

namespace Services
{
    public class LiaotianService: ILiaotianService
    {
        private readonly zhengcaioaContext _context;
        private readonly IMapper _mapper;
        public LiaotianService(zhengcaioaContext context, IMapper mapper)
        {
            _context = context;
            _mapper = mapper;
        }

       public ResultEntity saveLiaotian(LiaotianDTO liaotiandto)
        {
            ResultEntity resultEntity = new ResultEntity();
            try
            {

                var checkUserSn = _context.Liaotians.Where(x => x.Question == liaotiandto.Question && x.RecStatus == "A" && x.Id != liaotiandto.Id).FirstOrDefault();
                if (checkUserSn != null && (string.IsNullOrWhiteSpace(liaotiandto.Id) || (!string.IsNullOrWhiteSpace(liaotiandto.Id) && checkUserSn.Id != liaotiandto.Id)))
                {
                    resultEntity.Result = false;
                    resultEntity.Message = "问题重复";
                    return resultEntity;
                }

                var liaotian = _mapper.Map<Liaotian>(liaotiandto);
                if (String.IsNullOrEmpty(liaotian.Id))
                {
                    liaotian.Id = Guid.NewGuid().ToString();
                    liaotiandto.Id = liaotian.Id;
                    _context.Liaotians.Add(liaotian);
                }
                else
                {
                  var updateliaotian  = _context.Liaotians.Find(liaotian.Id);
                    updateliaotian.Question = liaotian.Question;
                    updateliaotian.Anwser = liaotian.Anwser;
                    updateliaotian.RecStatus = liaotian.RecStatus;
                    updateliaotian.Clientid = liaotian.Clientid;
                   // updateliaotian.Creater = liaotian.Creater;
                    //updateliaotian.Createtime = liaotian.Createtime;
                    updateliaotian.Modifier = liaotian.Modifier;
                    updateliaotian.Modifytime = liaotian.Modifytime;
                    updateliaotian.Questiontype = liaotian.Questiontype;
                    updateliaotian.Problemtype = liaotian.Problemtype;
                    updateliaotian.Shiyongfatiao = liaotian.Shiyongfatiao;
                }

                _context.SaveChanges();
                resultEntity.ReturnID = liaotian.Id;
                resultEntity.Result = true;
            }
            catch (Exception ex)
            {
                resultEntity.Result = false;
                resultEntity.Message = "保存失败，请联系管理员";
               
            }
            return resultEntity;
        }

        public LiaotianDTO GetLiaotianEntity(string id)
        {


            Liaotian entity = _context.Liaotians.Find(id);

            if (entity.RecStatus != "A")
            {
                entity = new Liaotian();
            }
            var liaotiandto = _mapper.Map<LiaotianDTO>(entity);
            return liaotiandto;
        }

        public List<SysCodeDtl> GetSYScode(string code_table,string code_field)
        {


            List<SysCodeDtl> sysCodeDtls = (from e in _context.SysCodes
                                            join c in _context.SysCodeDtls
                                            on e.Id equals c.CodeId  
                                            where e.RecStatus == "A" 
                                            && c.RecStatus == "A"
                                            && e.CodeTable == code_table 
                                            && e.CodeField == code_field
                                            select c).OrderBy(x=>x.Sort).ToList();
                     
            
                                




            return sysCodeDtls;
        }

        public ResultDataEntity<LiaotianDTO> SearchByPaging(LiaotianDTOSearch searchEntity)
        {
            ResultDataEntity<LiaotianDTO> data = new ResultDataEntity<LiaotianDTO>();
            List<LiaotianDTO> list = new List<LiaotianDTO>();
            //筛选
            var query = _context.Liaotians
                .Where(b => b.RecStatus=="A")
                .ToList();

            if (!string.IsNullOrEmpty(searchEntity.Question))
            {
                query = query.Where(m => m.Question.Contains(searchEntity.Question)).ToList();
            }
            if (!string.IsNullOrEmpty(searchEntity.Questiontype))
            {
                query = query.Where(m => m.Questiontype == searchEntity.Questiontype).ToList();
            }
            if (!string.IsNullOrEmpty(searchEntity.Problemtype))
            {
                query = query.Where(m => m.Problemtype.Contains(searchEntity.Problemtype)).ToList();
            }
            if (!string.IsNullOrEmpty(searchEntity.Shifoushenhe))
            {
                query = query.Where(m => m.Clientid == searchEntity.Shifoushenhe ).ToList();
            }
            
            DateTime Createtimestart = DateTime.Now;
            DateTime Createtimeend = DateTime.Now;
            if (!string.IsNullOrWhiteSpace(searchEntity.Createtime))
            {
                string[] Createtimes = searchEntity.Createtime.Split("|");
                DateTime.TryParse(Createtimes[0], out Createtimestart);
                DateTime.TryParse(Createtimes[1], out Createtimeend);
                Createtimeend = Createtimeend.AddDays(1);
            }
            if (!string.IsNullOrEmpty(searchEntity.Createtime))
            {
                query = query.Where(m => m.Createtime >= Createtimestart).ToList();
            }
            if (!string.IsNullOrEmpty(searchEntity.Createtime))
            {
                query = query.Where(m => m.Createtime <= Createtimeend).ToList();
            }
            if (!string.IsNullOrEmpty(searchEntity.Creater))
            {
                query = query.Where(m => m.Creater == searchEntity.Creater).ToList();
            }

            if (!string.IsNullOrEmpty(searchEntity.Info))
            {
                var check = searchEntity.Info.Split(' ');
                List<Liaotian> liaotians = new List<Liaotian>();
                if(check!=null&& check.Length > 0)
                {
                    for(int i = 0;i< check.Length; i++)
                    {
                        if (!string.IsNullOrWhiteSpace(check[i])){
                            liaotians = liaotians.Union(query.Where(m => m.Question.Contains(check[i])).ToList()).Distinct().ToList();
                        }
                       
                    }
                    
                }

                query = liaotians;


            }
            else
            {
                query = query.OrderByDescending(x => x.Modifytime).ToList();
            }

            
            if (searchEntity.totalrows == 0)
                searchEntity.totalrows = query.Count();
            var lianlist = query.Skip((searchEntity.page - 1) * searchEntity.rows).Take(searchEntity.rows).ToList();
            list = _mapper.Map<List<LiaotianDTO>>(lianlist);
            data.LoadData(searchEntity, list);
            return data;
        }


        /// <summary>
        /// 修改主表状态
        /// </summary>
        /// <param name="id">主id</param>
        /// <param name="userid">用户</param>
        /// <returns></returns>
        public ResultEntity ModifyStatus(string id, string userid)
        {
            ResultEntity result = new ResultEntity();
            result.Result = true;

            var model = _context.Liaotians.Find(id);
            if (model != null)
            {
                model.RecStatus = "D";
                model.Modifier = userid;
                model.Modifytime = DateTime.Now;
                _context.SaveChanges();
            }

            return result;
        }


        /// <summary>
        /// 查询打印信息
        /// </summary>
        /// <param name="searchEntity">查询条件</param>
        /// <returns></returns>
        public List<LiaotianDTO> SearchForPrint(LiaotianDTOSearch searchEntity)
        {
           
            List<LiaotianDTO> list = new List<LiaotianDTO>();
            //筛选
            var query = _context.Liaotians
                .Where(b => b.RecStatus == "A")
                .ToList();

            if (!string.IsNullOrEmpty(searchEntity.Question))
            {
                query = query.Where(m => m.Question.Contains(searchEntity.Question)).ToList();
            }
            if (!string.IsNullOrEmpty(searchEntity.Questiontype))
            {
                query = query.Where(m => m.Questiontype == searchEntity.Questiontype).ToList();
            }
            if (!string.IsNullOrEmpty(searchEntity.Problemtype))
            {
                query = query.Where(m => m.Problemtype.Contains(searchEntity.Problemtype)).ToList();
            }
            if (!string.IsNullOrEmpty(searchEntity.Info))
            {
                var check = searchEntity.Info.Split(' ');
                List<Liaotian> liaotians = new List<Liaotian>();
                if (check != null && check.Length > 0)
                {
                    for (int i = 0; i < check.Length; i++)
                    {
                        if (!string.IsNullOrWhiteSpace(check[i]))
                        {
                            liaotians = liaotians.Union(query.Where(m => m.Question.Contains(check[i])).ToList()).Distinct().ToList();
                        }

                    }

                }

                query = liaotians;


            }


            query = query.OrderByDescending(x => x.Modifytime).ToList();
            
            list = _mapper.Map<List<LiaotianDTO>>(query);
           
            return list;
        }
    }
}