using Dapper;
using Estsh.Core.Model.ExcelModel;
using Estsh.Core.Model.Result;
using Estsh.Core.Models;
using Estsh.Core.Repositories;
using System.Collections;

namespace Estsh.Core.Repository.IRepositories
{
    public interface IPullGroupRepository : IBaseRepository<WmsPullingGroup>
    {
        public List<WmsPullingGroup> getList(string ruid);
        public Hashtable getPullGroupListByPage(int PageSize, int PageIndex, string strWhere, string OrderBy);
        public Hashtable getPullGroupDetailListByPage(string strWhere);
        public List<WmsPullingGroupPart> getPullGroupDetailList(string strWhere);
        public List<SysPart> GetPartInfo(string part_no);
        public List<KeyValueResult> GetErpwarehouse();
        public List<KeyValueResult> getSelectFactory();
        public List<KeyValueResult> getSelectWarehouse();
        public List<SysWarehouse> getSelectWarehouse(string warehouseid);
        public List<SysZone> getSelectZone(string zoneid);
        public List<KeyValueResult> getSelectZone();
        public List<KeyValueResult> getSelectVendor();
        public List<SysVendor> getSelectVendor(string vendorId);
        public List<KeyValueResult> GetPart(int type);
        public List<KeyValueResult> GetOrderType();
        public List<SysPart> GetPart(int type,string PartNo);
        public List<SysPdline> GetPdlineByPdlineId(int pdlineId);
        public SysPdline GetPdlineByPdlineCode(string pdlineCode);
        public List<KeyValueResult> GetPdlineByKey();
        public bool saveHandPullGroup(string groupCode, string handPullQty);
        public List<SysPart> GetPartNoInfo(string part_no);
        public List<SysPart> GetPartSpecInfo(string partSpec);
        public int savePullGroup(WmsPullingGroup htParams, IList<WmsPullingGroupPart> htDetailParams);
        public int updatePullGroup(WmsPullingGroup htParams, IList<WmsPullingGroupPart> htDetailParams);
        public int EnableData(String ids);
        public int DisableData(String ids);
        public PullGroup ifExistsPullGroup(string groupCode);
        public PullGroup ifExistsPullGroupPart(string groupCode, string partNo);
        public List<PullGroup> getExportList(string strWhere, string orderBy);
        public bool InsertData(List<string> sqlStrings, List<DynamicParameters> parameterList);

    }
}