using Models;
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;

namespace DAL
{
    public class CGDEUService
    {
        /// <summary>
        /// 查询所有
        /// </summary>
        /// <param name="sql">sql语句</param>
        /// <param name="param">可变参数数组</param>
        /// <returns>返回集合</returns>
        List<CarGuideData_EU> excuteSql(string sql, params SqlParameter[] param)
        {
            return ServiceBase<CarGuideData_EU>.excuteSql(new CarGuideData_EU(), "CarGuideData_EU", sql, CommandType.Text, param);
        }

        /// <summary>
        /// 获取单个对象
        /// </summary>
        /// <param name="sql">sql语句</param>
        /// <param name="param">可变参数数组</param>
        /// <returns>返回空或者单个对象</returns>
        CarGuideData_EU excuteType(string sql, params SqlParameter[] param)
        {
            //查询结果放入对象集合
            List<CarGuideData_EU> hdList = excuteSql(sql, param);
            //判断集合是否为空
            if (hdList == null || hdList.Count == 0)
                //返回null
                return null;
            //返回单个对象
            return hdList[0];
        }

        /// <summary>
        /// 获取全部 - 分页
        /// </summary>
        /// <returns></returns>
        public List<CarGuideData_EU> GetALL(int pageIndex, out int sumPage, out int totalRecord, string Area)
        {
            string sqlwhere = "IsDel = 0";

            if (!string.IsNullOrEmpty(Area))
                sqlwhere += " and Area like '%" + Area + "%'";

            return PageBase<CarGuideData_EU>.excutePageSql(new CarGuideData_EU(), "CarGuideData_EU", "CarGuideData_EU", "*", "id asc", sqlwhere, 10, pageIndex, out sumPage, out totalRecord);
        }

        /// <summary>
        /// 获取全部
        /// </summary>
        /// <returns></returns>
        public List<CarGuideData_EU> GetALL()
        {
            return excuteSql("select * from CarGuideData_EU where IsDel=0");
        }

        /// <summary>
        /// 单个查询
        /// </summary>
        /// <returns></returns>
        public CarGuideData_EU GetALL(string area, string type, string cost)
        {
            return excuteType("select * from CarGuideData_EU where IsDel=0 and area like '%" + area + "%' " + "and CarType like '%" + type + "%' " + "and CarCost like '%" + cost + "%'");
        }

    }
}