Esempio n. 1
0
        public IEnumerable <Icseh> GetIcsehListAllByMSDSSheetNoAndLangcd(
            GetIcsehListAllByMSDSSheetNoAndLangcdRequestApi getGetIcsehListAllByMSDSSheetNoAndLangcdRequestApi)
        {
            var where = new StringBuilder();

            if (!string.IsNullOrEmpty(getGetIcsehListAllByMSDSSheetNoAndLangcdRequestApi.msdssheetno))
            {
                where.AppendFormatWithEscape("icseh.msdssheetno begins '{0}'", getGetIcsehListAllByMSDSSheetNoAndLangcdRequestApi.msdssheetno);
            }
            if (!string.IsNullOrEmpty(getGetIcsehListAllByMSDSSheetNoAndLangcdRequestApi.langcd))
            {
                if (!string.IsNullOrEmpty(getGetIcsehListAllByMSDSSheetNoAndLangcdRequestApi.msdssheetno))
                {
                    where.AppendFormat(" AND ");
                }
                where.AppendFormatWithEscape("icseh.langcd begins '{0}'", getGetIcsehListAllByMSDSSheetNoAndLangcdRequestApi.langcd);
            }

            return(this.icsehRepository.GetList(
                       where.ToString(),
                       getGetIcsehListAllByMSDSSheetNoAndLangcdRequestApi.batchsize,
                       getGetIcsehListAllByMSDSSheetNoAndLangcdRequestApi.fldlist));
        }
Esempio n. 2
0
 public IEnumerable <Icseh> GetIcsehListAllByMSDSSheetNoAndLangcd(GetIcsehListAllByMSDSSheetNoAndLangcdRequestApi getIcsehListAllByMSDSSheetNoAndLangcdRequestApi)
 {
     return(this.icsehService.GetIcsehListAllByMSDSSheetNoAndLangcd(getIcsehListAllByMSDSSheetNoAndLangcdRequestApi));
 }