示例#1
0
        public IEnumerable <Icsess> GetIcsessList(
            GetIcsessListRequestApi getIcsessListRequestApi)
        {
            var where = new StringBuilder();
            where.Append($"icsess.cono = {this.icsessRepository.Cono}");

            if (getIcsessListRequestApi.vendno != 0)
            {
                where.Append($" AND icsess.vendno = '{getIcsessListRequestApi.vendno}'");
            }
            if (!string.IsNullOrEmpty(getIcsessListRequestApi.rectype))
            {
                where.AppendFormatWithEscape(" AND icsess.rectype = '{0}'", getIcsessListRequestApi.rectype);
            }
            if (getIcsessListRequestApi.position != 0)
            {
                where.Append($" AND icsess.position = '{getIcsessListRequestApi.position}'");
            }
            if (!string.IsNullOrEmpty(getIcsessListRequestApi.data))
            {
                where.AppendFormatWithEscape(" AND icsess.data = '{0}'", getIcsessListRequestApi.data);
            }

            return(this.icsessRepository.GetList(
                       where.ToString(),
                       getIcsessListRequestApi.batchsize,
                       getIcsessListRequestApi.fldlist));
        }
示例#2
0
 public IEnumerable <Icsess> GetIcsessList(GetIcsessListRequestApi getIcsessListRequestApi)
 {
     return(this.icsessService.GetIcsessList(getIcsessListRequestApi));
 }