string.IsNullOrEmpty(category)

string.IsNullOrEmpty(category)) //字符串空值判断

var query = from t in await _breakdownRepository.GetQueryableAsync() join t2 in await _productionLineRepository.GetQueryableAsync() on t.LineId equals t2.Id into t2Join from t2 in t2Join.DefaultIfEmpty() join t3 in await _equipmentRepository.GetQueryableAsync() on t.EquipmentId equals t3.Id into t3Join from t3 in t3Join.DefaultIfEmpty() join t4 in await _errorCodeRepository.GetQueryableAsync() on t.ErrrorCodeId equals t4.Id into t4Join from t4 in t4Join.DefaultIfEmpty() join category in await _breakdownCategoryRepository.GetQueryableAsync() on t.BreakdownCategoryId equals category.Id into categoryGroup from category in categoryGroup.DefaultIfEmpty() join org in await _organizationRepository.GetQueryableAsync() on t2.Organization equals org.Id.ToString() into orgGroup from org in orgGroup.DefaultIfEmpty() where !t.IsDeleted && ((!input.IsClosed.HasValue) || (t.IsClosed == input.IsClosed)) && (string.IsNullOrEmpty(personId) || t.OperatorId.Contains(personId)) && (string.IsNullOrEmpty(input.BreakdownCategoryMajor) || t.BreakdownCategoryMajor == input.BreakdownCategoryMajor) && (string.IsNullOrEmpty(input.FunctionalLocation) || t2.FunctionalLocation == input.FunctionalLocation) && (string.IsNullOrEmpty(input.Site) || t2.Site == input.Site) && (string.IsNullOrEmpty(input.Organization) || t2.Organization == input.Organization) && (string.IsNullOrEmpty(input.Building) || t2.Building == input.Building) && (string.IsNullOrEmpty(input.Classification) || t3.Classification.ToString() == input.Classification) && (!string.IsNullOrEmpty(input.BreakdownStartTimeStrStart) && !string.IsNullOrEmpty(input.BreakdownStartTimeStrEnd) ? t.BreakdownStartTime >= DateTimeUtil.ParseDateTime(input.BreakdownStartTimeStrStart, “Short”) && t.BreakdownStartTime <= DateTimeUtil.ParseDateTime(input.BreakdownStartTimeStrEnd, “Short”).Value.AddDays(1).AddTicks(-1) : true) select new { t, LineCode = t2.Code, LineName = t2.Name, LineClassification = (t2.Classification == ‘\0’ ? (char?)null : t2.Classification), EquipmentCode = t3.Code, EquipmentName = t3.Name, Classification = t3.Classification, ErrorCode = t4.ErrorCode, ErrorMessage = t4.ErrorMessage, Site = t2.Site, Building = t2.Building, BreakdownCategoryCode = category.Code, BreakdownCategoryName = category.DisplayName, BreakdownStartTimeStr = DateTimeUtil.FormatDateTime(t.BreakdownStartTime, “Medium”), BreakdownEndTimeStr = DateTimeUtil.FormatDateTime(t.BreakdownEndTime, “Medium”), CreationTimeStr = t.CreationTime.ToString(“yyyy-MM-dd HH:mm”), StartTimeStr = DateTimeUtil.FormatDateTime(t.StartTime, “Medium”), EndTimeStr = DateTimeUtil.FormatDateTime(t.EndTime, “Medium”), OrganizationId = org.Id, OrganizationCode = org.Code, OrganizationName = org.DisplayName }; 优化此段代码 ABP框架
03-18
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值