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

namespace GasolineBlend.DAL
{
    /// <summary>
    /// 信托
    /// </summary>
   public class MkTrustTableDAL:BaseZdwDAL
    {
        /// <summary>
        /// 获取前一百条
        /// </summary>
        /// <returns></returns>
        public List<MkTrustTable> GetMkTrustTableList()
        {
            var sql = "select * from TrustTableTemp  ";
            return Conn.Query<MkTrustTable>(sql).ToList();
        }
        /// <summary>
        /// 获取总数
        /// </summary>
        /// <returns></returns>
        public int GetTotalCount()
        {
            var sql = "select TotalCount from TotalCountTemp where TableName='TrustTableTemp'";
            return Conn.ExecuteScalar<int>(sql);
        }
        /// <summary>
        /// 查询信息获取信托融资数据Count
        /// </summary>
        /// <param name="name"></param>
        /// <returns></returns>
        public int GetMkTrustTableCount(string name)
        {
            var sql = $"select COUNT(*) from TrustTable where Contains(Financier,'{name}') OR Contains(TrustCompany,'{name}')";
            return Conn.ExecuteScalar<int>(sql);
        }
    }
}