コード例 #1
0
ファイル: IcslService.cs プロジェクト: arentlog/web-ui
        public IEnumerable <Icsl> GetIcslListByWhseVendNoProdLine(
            GetIcslListByWhseVendNoProdLineRequestApi getIcslListByWhseVendNoProdLineRequestApi)
        {
            var where = new StringBuilder();
            where.Append($"icsl.cono = {this.icslRepository.Cono}");

            if (!string.IsNullOrEmpty(getIcslListByWhseVendNoProdLineRequestApi.whse))
            {
                where.AppendFormatWithEscape(" and icsl.whse = '{0}'", getIcslListByWhseVendNoProdLineRequestApi.whse);
            }
            where.AppendFormatWithEscape(" and icsl.vendno = {0}", getIcslListByWhseVendNoProdLineRequestApi.vendno);

            if (!string.IsNullOrEmpty(getIcslListByWhseVendNoProdLineRequestApi.prodline))
            {
                where.AppendFormatWithEscape(" and icsl.prodline = '{0}'", getIcslListByWhseVendNoProdLineRequestApi.prodline);
            }

            return(this.icslRepository.GetList(
                       where.ToString(),
                       getIcslListByWhseVendNoProdLineRequestApi.batchsize,
                       getIcslListByWhseVendNoProdLineRequestApi.fldlist));
        }
コード例 #2
0
 public IEnumerable <Icsl> GetIcslListByWhseVendNoProdLine(GetIcslListByWhseVendNoProdLineRequestApi getIcslListByWhseVendNoProdLineRequestApi)
 {
     return(this.icslService.GetIcslListByWhseVendNoProdLine(getIcslListByWhseVendNoProdLineRequestApi));
 }