You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
43 lines
2.4 KiB
C#
43 lines
2.4 KiB
C#
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);
|
|
}
|
|
}
|