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