Пример #1
0
        //查询
        public IEnumerable <CRMVehicle> GetCRMVehicleByConditionNoPaging(CRMVehicleSearchCondition SearchCondition)
        {
            string sqlWhere = this.GenGetCRMVehicleWhere(SearchCondition);

            DbParam[] dbParams = new DbParam[] {
                new DbParam("@Where", DbType.String, sqlWhere, ParameterDirection.Input)
            };

            return(this.ExecuteDataTable("Proc_GetCRMVehicleByConditionNoPaging", dbParams).ConvertToEntityCollection <CRMVehicle>());
        }
Пример #2
0
        //两个
        public IEnumerable <CRMVehicle> GetCRMVehicleByCondition(CRMVehicleSearchCondition Vehicle, int PageIndex, int PageSize, out int RowCount)
        {
            string sqlWhere     = this.GenGetCRMVehicleWhere(Vehicle);
            int    tempRowCount = 0;

            DbParam[] dbParams = new DbParam[] {
                new DbParam("@Where", DbType.String, sqlWhere, ParameterDirection.Input),
                new DbParam("@PageIndex", DbType.Int32, PageIndex, ParameterDirection.Input),
                new DbParam("@PageSize", DbType.Int32, PageSize, ParameterDirection.Input),
                new DbParam("@RowCount", DbType.Int32, tempRowCount, ParameterDirection.Output)
            };
            DataTable dt = this.ExecuteDataTable("Proc_GetCRMVehicleByCondition", dbParams);

            RowCount = (int)dbParams[3].Value;
            return(dt.ConvertToEntityCollection <CRMVehicle>());
        }
Пример #3
0
        private string GenGetCRMVehicleWhere(CRMVehicleSearchCondition SearchCondition)
        {
            StringBuilder sb = new StringBuilder();

            //车牌号
            if (!string.IsNullOrEmpty(SearchCondition.CarNo))
            {
                sb.Append(" AND CRM_Vehicle.CarNo like '%").Append(SearchCondition.CarNo).Append("%' ");
            }
            //车型编码
            if (!string.IsNullOrEmpty(SearchCondition.CarTypeNo))
            {
                sb.Append(" AND CRM_Vehicle.CarTypeNo like '%").Append(SearchCondition.CarTypeNo).Append("%' ");
            }
            //物流公司
            if (!string.IsNullOrEmpty(SearchCondition.LogisticCompany))
            {
                sb.Append(" AND CRM_Vehicle.LogisticCompany like '%").Append(SearchCondition.LogisticCompany).Append("%' ");
            }
            //已行驶公里数
            if (!string.IsNullOrEmpty(SearchCondition.DrivedJourney))
            {
                sb.Append(" AND CRM_Vehicle.DrivedJourney='").Append(SearchCondition.DrivedJourney).Append("' ");
            }
            //上牌日期
            if (!string.IsNullOrEmpty(SearchCondition.StartBoardlotTime))
            {
                sb.Append("and  CRM_Vehicle.BoardlotDate>='").Append(SearchCondition.StartBoardlotTime).Append("'");
                //sb.Append(" AND CRM_Vehicle.BoardlotDate='").Append(SearchCondition.BoardlotDate).Append("' ");
            }
            if (!string.IsNullOrEmpty(SearchCondition.EndBoardlotTime))
            {
                sb.Append("and  CRM_Vehicle.BoardlotDate<='").Append(SearchCondition.EndBoardlotTime).Append("'");
                //sb.Append(" AND CRM_Vehicle.BoardlotDate='").Append(SearchCondition.BoardlotDate).Append("' ");
            }
            //车龄
            if (!string.IsNullOrEmpty(SearchCondition.CarAge))
            {
                sb.Append(" AND CRM_Vehicle.CarAge like '%").Append(SearchCondition.CarAge).Append("%' ");
            }
            //号牌种类
            if (!string.IsNullOrEmpty(SearchCondition.CarNumType))
            {
                sb.Append(" AND CRM_Vehicle.CarNumType='").Append(SearchCondition.CarNumType).Append("' ");
            }
            //车身颜色
            if (!string.IsNullOrEmpty(SearchCondition.CarBodyColor))
            {
                sb.Append(" AND CRM_Vehicle.CarBodyColor like '%").Append(SearchCondition.CarBodyColor).Append("%' ");
            }
            //生产厂家
            if (!string.IsNullOrEmpty(SearchCondition.Manufacturer))
            {
                sb.Append(" AND CRM_Vehicle.Manufacturer like '%").Append(SearchCondition.Manufacturer).Append("%' ");
            }
            //整备质量
            if (!string.IsNullOrEmpty(SearchCondition.EntireCarWeight))
            {
                sb.Append(" AND CRM_Vehicle.EntireCarWeight='").Append(SearchCondition.EntireCarWeight).Append("' ");
            }
            //燃料种类
            if (!string.IsNullOrEmpty(SearchCondition.FuelType))
            {
                sb.Append(" AND CRM_Vehicle.FuelType='").Append(SearchCondition.FuelType).Append("' ");
            }
            //开始服务日期
            if (!string.IsNullOrEmpty(SearchCondition.StartServiceTime))
            {
                sb.Append("and  CRM_Vehicle.StartServiceDate>='").Append(SearchCondition.StartServiceTime).Append("'");
                //sb.Append(" AND CRM_Vehicle.StartServiceDate='").Append(SearchCondition.StartServiceDate).Append("' ");
            }
            if (!string.IsNullOrEmpty(SearchCondition.EndServiceTime))
            {
                sb.Append("and  CRM_Vehicle.StartServiceDate<='").Append(SearchCondition.EndServiceTime).Append("'");
                //sb.Append(" AND CRM_Vehicle.StartServiceDate='").Append(SearchCondition.StartServiceDate).Append("' ");
            }



            return(sb.ToString());
        }