//查询 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>()); }
//两个 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>()); }
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()); }