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 ICycleCountRepository : IBaseRepository<BaseEntity>
    {
        public List<WmsCheckStock> GetCycleCountOrderList(string orderNo);
        public List<WmsCheckStock> GetCycleCountOrderListByOrderNo(string orderNo);
        public SysLocate GetLocateByLocateName(string locateName);
        public WmsCheckStockRange GetWmsCheckStockRangeByLocateName(string orderNo, string locateName, string zoneName);
        public List<WmsCheckStock> GetWmsCheckStockQtyFactByLocateName(string orderNo, string locateName);
        public List<WmsCheckStock> GetFinishCycleCountData(string orderNo);
        public SysPart GetPartNOInfoByPartNo(string partNo);
        public List<WmsRack> GetRackInfo(string cartonNo);
        public List<SysStock> GetStockByCaronNoTro(string cartonNo);
        public List<SysStock> GetStockByCaronNoTroList(string cartonNo);
        public List<SysStock> GetStockByTrayNo(string trayNo);
        public List<SysStock> GetStockByCaronNo(string cartonNo);
        public List<WmsCheckStockRange> GetWmsCheckStockRangeByIsExsistPartNo(string orderNo, string locateName, string zoneName, string partNo);
        public List<WmsCheckStockList> GetWmsCheckStockListByRackNoExist(string orderNo, string rackNo);
        public List<WmsCheckStockList> GetWmsCheckStockListByRackNo(string orderNo, string rackNo);
        public List<WmsCheckStock> GetWmsCheckStockByCartonNo(string orderNo, string cartonNo);
        public List<WmsCheckStock> GetWmsCheckStockByCartonNo(string orderNo);
        public int InsertCheckStockListInfo(WmsCheckStockList checkStockList);
        public int UpdateCheckStockOrderStatus(string orderNo, string loginId);
        public List<WmsCheckStockList> GetCheckStockListByRackPartNo(string orderNo,string trolleyNo, string partNo);
        public List<SysStock> CheckCartonNoByRackNo(string cartonNo);
        public List<WmsCheckStockList> CheckRackListByCartonNo(string orderNo, string cartonNo);
        public List<SysStock> GetStockByRackNo(string rackNo);
        public string GetOrderNo(string stockOrder, string p);
        public int SQLTransaction(List<string> sqlStrings, List<DynamicParameters> parameterList);
    }
}