CCN.Modules.Car.DataAccess.CarDataAccess.GetMaddenWhere C# (CSharp) Method

        public string GetMaddenWhere(CarMaddenQueryModel query)
        {
            #region 查询条件

            var sqlWhere = new StringBuilder("1=1"); //在售和已售车辆

            //是否删除
            if (query.isdeleted != null)
            {
                sqlWhere.Append($" and a.isdeleted={query.isdeleted}");
            }

            //状态
            if (query.status != null)
            {
                sqlWhere.Append($" and a.status={query.status}");
            }

            //省份
            if (query.provid != null)
            {
                sqlWhere.Append($" and a.provid={query.provid}");
            }

            //城市
            if (query.cityid != null)
            {
                sqlWhere.Append($" and a.cityid={query.cityid}");
            }

            //品牌
            if (query.brand_id != null && query.brand_id != 0)
            {
                sqlWhere.Append($" and a.brand_id={query.brand_id}");
            }

            //车系
            if (query.series_id != null && query.series_id != 0)
            {
                sqlWhere.Append($" and a.series_id={query.series_id}");
            }

            //车型
            if (query.model_id != null && query.model_id != 0)
            {
                sqlWhere.Append($" and a.model_id={query.model_id}");
            }

            sqlWhere.Append("");

            return sqlWhere.ToString();

            #endregion
        }