using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using dccdc.Models;
using Dapper;

namespace dccdc.DAL
{
    public class JmmxDal
    {
        /// <summary>
        /// 根据减免申请ID获取减免项目列表
        /// </summary>
        /// <param name="jmid"></param>
        /// <returns></returns>
        public List<JmmxModel> GetJmmxList(string jmid)
        {
            StringBuilder u = new StringBuilder("select * from jmmx  where jmsqid = @jmid");
            using (IDbConnection conn = CommHelper.GetSqlConnection())
            {
                return conn.Query<JmmxModel>(u.ToString(), new { jmid }).ToList();
            }
        }
    }
}