コード例 #1
0
        public IEnumerable <Sapb> GetSapbByConoReportFunctionAltReport(GetSapbByConoReportFunctionAltReportRequestApi getSapbByConoReportFunctionAltReportRequestApi)
        {
            var where = new StringBuilder();

            if (getSapbByConoReportFunctionAltReportRequestApi.cono > 0)
            {
                where.Append($"sapb.cono = {getSapbByConoReportFunctionAltReportRequestApi.cono}");
            }

            if (!string.IsNullOrWhiteSpace(getSapbByConoReportFunctionAltReportRequestApi.currproc))
            {
                if (where.ToString().Length > 0)
                {
                    where.AppendFormat(" AND ");
                }
                where.AppendFormatWithEscape("(sapb.currproc = '{0}'", getSapbByConoReportFunctionAltReportRequestApi.currproc);
                if (!string.IsNullOrWhiteSpace(getSapbByConoReportFunctionAltReportRequestApi.altproc))
                {
                    where.AppendFormatWithEscape(" OR sapb.currproc = '{0}'", getSapbByConoReportFunctionAltReportRequestApi.altproc);
                }
                where.Append(")");
            }
            return(this.sapbRepository.GetList(where.ToString(), getSapbByConoReportFunctionAltReportRequestApi.batchsize, getSapbByConoReportFunctionAltReportRequestApi.fldlist));
        }
コード例 #2
0
 public IEnumerable <Sapb> GetSapbByConoReportFunctionAltReport(GetSapbByConoReportFunctionAltReportRequestApi getSapbByConoReportFunctionAltReportRequestApi)
 {
     return(this.sapbService.GetSapbByConoReportFunctionAltReport(getSapbByConoReportFunctionAltReportRequestApi));
 }