using Estsh.Core.Dapper;
using Estsh.Core.IRepositories;
using Estsh.Core.Model.ExcelModel;
using Estsh.Core.Model.Result;
using Estsh.Core.Models;
using Estsh.Core.Repository.IRepositories;
using Estsh.Core.Services.IServices;
using Estsh.Core.Util;
using System.Collections;


/***************************************************************************************************
 *
 * 更新人：sitong.dong
 * 描述：打包信息查询
 * 修改时间：2022.06.22
 * 修改日志：系统迭代升级
 *
 **************************************************************************************************/
namespace Estsh.Core.Services
{
    public class ShippingInformationDefineService : BaseService<GMisco>, IShippingInformationDefineService
    {
        private readonly IShippingInformationDefineRepository repository;
        public ShippingInformationDefineService(IShippingInformationDefineRepository _repository) : base(_repository)
        {
            repository = _repository;
        }

        /// <summary>
        /// 客户产线集合
        /// </summary>
        /// <returns>数据集</returns>
        public List<KeyValueResult> GetCustPDLineName()
        {
            return repository.GetCustPDLineName();
        }

        /// <summary>
        /// 根据分页条件获取分页菜单数据
        /// </summary>
        /// <param name="PartMasterName"></param>
        /// <param name="pager"></param>
        /// <param name="direction"></param>
        /// <param name="sort"></param>
        /// <returns></returns>
        public Hashtable getShippingListByPage(String where, Pager pager)
        {
            return repository.getShippingListByPage(pager.pageSize, pager.pageNo, where);
        }

        public Hashtable getShippingListDetailByPage(String where, Pager pager)
        {
            return repository.getShippingListDetailByPage(pager.pageSize, pager.pageNo, where);
        }


        /// <summary>
        /// 
        /// </summary>
        /// <param name="aWhere"></param>
        /// <returns></returns>
        public List<GMisco> GetCountShipping(string aWhere)
        {
            return repository.GetCountShipping(aWhere);
        }
        public List<ShippingInformationDefine> getTableListByPage(string aWhere)
        {
            return repository.getTableListByPage(aWhere);
        }
        public List<GMiscoSn> GetCountShippingDetail(string aWhere)
        {
            return repository.GetCountShippingDetail(aWhere);
        }
    }
}