public IEnumerable <Binmst> GetTWLBinLocations(string coNum, string whNum, int batchsize = 0, string fldlist = "")
{
var getTWLBinLocationsApi = new GetTWLBinLocationsApi()
{
coNum = coNum,
whNum = whNum,
batchsize = batchsize,
fldlist = fldlist
};
return(this.binmstService.GetTWLBinLocations(getTWLBinLocationsApi));
}
public IEnumerable <Binmst> GetTWLBinLocations(GetTWLBinLocationsApi getTWLBinLocationsApi)
{
var sb = new StringBuilder();
if (!string.IsNullOrWhiteSpace(getTWLBinLocationsApi.coNum))
{
sb.AppendFormatWithEscape("binmst.co_num = '{0}'", getTWLBinLocationsApi.coNum);
if (!string.IsNullOrWhiteSpace(getTWLBinLocationsApi.whNum))
{
sb.AppendFormatWithEscape(" AND binmst.wh_num = '{0}'", getTWLBinLocationsApi.whNum);
}
if (!string.IsNullOrWhiteSpace(getTWLBinLocationsApi.binNum))
{
sb.AppendFormatWithEscape(" AND binmst.bin_num begins '{0}'", getTWLBinLocationsApi.binNum);
}
}
var where = sb.ToString();
return(this.binmstRepository.GetList(where, getTWLBinLocationsApi.batchsize, getTWLBinLocationsApi.fldlist));
}
public IEnumerable <Binmst> GetTWLBinLocations(GetTWLBinLocationsApi getTWLBinLocationsApi)
{
return(this.binmstService.GetTWLBinLocations(getTWLBinLocationsApi));
}
