everlight.eap/backend/DllEapDal/StandardStatusDal.cs

using Cksoft.Data;
using DllEapEntity.Dtos;
using System;
using System.Collections.Generic;
using System.Text;

namespace DllEapDal
{
    public class StandardStatusDal
    {
        private IDatabase CurrDb;
        public StandardStatusDal(IDatabase db)
        {
            CurrDb = db;
        }

        public IEnumerable<SelectDto<int?>> GetAll(string filter = "")
        {
            var sql = $"select StatusVal as value,FName as label from standardstatus " +
                $"where 1=1 {filter}";
            return CurrDb.FindList<SelectDto<int?>>(sql);
        }
    }
}