using AutoMapper;
using Magicodes.ExporterAndImporter.Core;
using Magicodes.ExporterAndImporter.Excel;
using MailKit.Search;
using OfficeOpenXml.FormulaParsing.Excel.Functions.Text;
using SqlSugar;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Diagnostics.CodeAnalysis;
using System.Linq;
using System.Reflection;
using System.Reflection.Metadata;
using System.Text;
using System.Threading.Tasks;
using WIDESEA_Core;
using WIDESEA_Core.BaseRepository;
using WIDESEA_Core.BaseServices;
using WIDESEA_Core.Enums;
using WIDESEA_Core.Helper;
using WIDESEA_DTO.Inbound;
using WIDESEA_DTO.Stock;
using WIDESEA_IBasicRepository;
using WIDESEA_IBasicService;
using WIDESEA_IInboundService;
using WIDESEA_IOutboundRepository;
using WIDESEA_IOutboundService;
using WIDESEA_IRecordService;
using WIDESEA_IStockRepository;
using WIDESEA_IStockService;
using WIDESEA_ISystemRepository;
using WIDESEA_ITaskInfoRepository;
using WIDESEA_ITaskInfoService;
using WIDESEA_Model.Models;
using WIDESEA_TaskInfoRepository;
using OrderByType = SqlSugar.OrderByType;

namespace WIDESEA_TaskInfoService;

public class Sys_CreateTaskService : ServiceBase<Sys_CreateTask, ISys_CreateTaskRepository>, ISys_CreateTaskService
{
    public readonly ISys_UserRepository _UserRepository;
    public Sys_CreateTaskService(ISys_CreateTaskRepository BaseDal, ISys_UserRepository sys_User
                                    ) : base(BaseDal)
    {
        _UserRepository = sys_User;
    }


    public int QtCreatea(string statict)
    {
        var task = BaseDal.QueryData(x => x.CreateSta == statict).ToList();
        return task.Count;
    }

    public virtual PageGridData<Sys_CreateTask> GetPageData(PageDataOptions options)
    {
        string wheres = options.ValidatePageOptions(TProperties);
        int useriddep=_UserRepository.GetDeptId(App.User.UserName);
        if(useriddep == 0)
        {
            if (wheres != "")
            {
                wheres += $" and Creater={App.User.UserName}";
            }
            else
            {
                wheres += $"(Creater={App.User.UserName})";
            }
        }
        //获取排序字段
        Dictionary<string, OrderByType> orderbyDic = options.GetPageDataSort(TProperties);

        PageGridData<Sys_CreateTask> pageGridData = new PageGridData<Sys_CreateTask>();
        pageGridData = BaseDal.QueryPage(wheres, options.Page, options.Rows, orderbyDic);
        return pageGridData;
    }
}