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 CGDUSService
    {
        /// <summary>
        /// 查询所有
        /// </summary>
        /// <param name="sql">sql语句</param>
        /// <param name="param">可变参数数组</param>
        /// <returns>返回集合</returns>
        List<CarGuideData_US> excuteSql(string sql, params SqlParameter[] param)
        {
            return ServiceBase<CarGuideData_US>.excuteSql(new CarGuideData_US(), "CarGuideData_US", sql, CommandType.Text, param);
        }

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

        /// <summary>
        /// 获取全部 - 分页
        /// </summary>
        /// <returns></returns>
        public List<CarGuideData_US> 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_US>.excutePageSql(new CarGuideData_US(), "CarGuideData_US", "CarGuideData_US", "*", "id asc", sqlwhere, 10, pageIndex, out sumPage, out totalRecord);
        }

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


    }
}