using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Dapper;
using GasolineBlend.Entity;

namespace GasolineBlend.DAL
{
    public class ProjStateDAL:BaseDAL
    {
        public List<ProjState> GetProjStateList()
        {
            //var sql = $"select * from sysProjState order by StateId asc";
            var sql = $"select * from sysProjState order by SortNum asc";
            return Conn.Query<ProjState>(sql).ToList();
        }
    }
}