using Dapper;
using Estsh.Core.Base;
using Estsh.Core.Models;
using Estsh.Core.Repositories;
using Newtonsoft.Json.Linq;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Estsh.Core.Wms.IRepositories
{
    public interface ISplitCarrierRepository : IBaseRepository<BaseEntity>
    {
        public List<WmsRackPackage> GetCarrierByName(string rackNo);
        public List<SysStock> GetCarrierByStockRackNo(string rackNo);
        public List<SysStock> GetSysStockByNO(string cartonNo);
        public List<SysStock> GetSysStockBycartonNo(string rackNo, string cartonNo);
        public List<SysStock> GetSysStockBySumQty(string rackNo);
        public List<SysStock> GetSysStockByPartNoSumQty(string rackNo, string partNo);
        public List<SysStock> GetSysStockByPartInfo(string rackNo, string partNo);
        public List<WmsRackPackage> GetCarrierByPartNo(string partNo);
        public int UpdateStockByRackNo(string rackNo);
        public List<WmsRackPackage> GetCarrierByRackAndPartNo(string rackNo, string partNo);
        public List<SysLocate> CheckLocateStatus(string locateName);
        public string GetOrderNo(string stockOrder, string p);
        public int SQLTransaction(List<string> sqlStrings, List<DynamicParameters> parameterList);
    }
}