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


namespace Estsh.Core.Repository.IRepositories
{
    public interface IZonePartRepository : IBaseRepository<SysZonePart>
    {
        public List<SysZonePart> getList(string strWhere);
        public Hashtable getListByPage(int PageSize, int PageIndex, string strWhere, string OrderBy);
        public List<KeyValueResult> getSelectZone(string warehouseId);
        public List<SysZone> getSelectZoneInfo(string zone_name);
        public List<SysZone> GetZoneInfo(string zoneName);
        public List<SysZonePart> getSelectZonePartInfo(string zone_name, string partNo);
        public List<SysVendor> getSelectVendorInfo(string vendorCode);
        public int saveZonePart(SysZonePart ht);
        public int updateZonePart(SysZonePart ht);
        public int deleteZonePart(String locate_id);
        public List<SysPart> GetPartInfo(string part_no);
        public List<SysLocate> GetLocateInfo(string locateName);
        public List<SysVendor> GetVendorInfo(string vendorCode);
        public List<KeyValueResult> GetpartInfo();
        public int EnableLocatePart(String locate_id);
        public int DisableLocatePart(String locate_id);
        public SysVendor GetVendorInfoByvendorCode(string vendorCode);
        public ZonePart ifExistsZonePart(string zoneName, string vendorCode, string partNo);
        public List<ZonePart> getExportList(string strWhere, string orderBy);
        public bool InsertData(List<string> sqlStrings, List<DynamicParameters> parameterList);
    }
}