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.
35 lines
1.5 KiB
C#
35 lines
1.5 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 IRecommendedInStockRepository : IBaseRepository<BaseEntity>
|
|
{
|
|
public List<SysStock> GetStockByCarton(string cartonNo);
|
|
public List<SysZonePart> GetZonePartByVendorId(int VendorId);
|
|
public List<SysStock> GetStockByGroupNo(string groupNo);
|
|
public List<SysStock> GetStockPartByGroupNo(string groupNo);
|
|
public List<SysZonePart> GetZonePartByPartNo(string partNo);
|
|
public List<SysLocate> GetLocateByZoneName(string zoneName);
|
|
public List<SysLocate> GetLocateByZoneNameAndPartNo(string zoneName,string partNo);
|
|
public SysStock GetStockByLocateName(string locateName);
|
|
public List<SysStock> GetStockByPartNoLocateName(string locateName);
|
|
public List<SysLocate> GetLocateInfoByLocateName(string locateName);
|
|
public List<SysStock> GetStockQtyByGroupNo(string groupNo);
|
|
public List<SysStock> GetStockInfoByGroupNo(string groupNo);
|
|
public List<SysStock> GetStockInfoByLocateName(string locateName);
|
|
public List<SysStock> GetStockInfoByInGroupNo(string groupNo);
|
|
public List<SysStock> GetStockInfoByInCartonNo(string cartonNo);
|
|
public int SQLTransaction(List<string> sqlStrings, List<DynamicParameters> parameterList);
|
|
|
|
}
|
|
}
|