public void QueryData() { var queryItem = new ResourceQueryDTO { ResourceTypes = string.IsNullOrEmpty(this.QResourceType.Text) ? new List <string>() : this.QResourceType.Text.Split(',').ToList(), DateType = this.QDateType.Text, BeginDate = this.QBeginDate.Value, EndDate = this.QEndDate.Value, UserId = this.QUserId.Text, UserName = this.QUserId.Text, EquipmentNo = this.QEquipmentNo.Text }; this._dataSource = Assembler <IResourceService> .Create().GetResourcesByQuery(queryItem); this.ManageGridPage.AutoGenerateColumns = false; this.ManageGridPage.DataSource = this._dataSource; }
/// <summary> /// 根据管理界面查询资源 /// </summary> /// <param name="queryItem"></param> /// <returns></returns> public List <ResourcesDTO> GetResourcesByQuery(ResourceQueryDTO queryItem) { using (var db = new EFDbContext()) { var list = db.Resources.Where(x => 1 == 1); if (queryItem.ResourceTypes != null && queryItem.ResourceTypes.Count > 0) { var resourceTypes = new List <int>(); queryItem.ResourceTypes.ForEach(x => { resourceTypes.Add(EnumHelper.GetByDescription <DAMS.Common.EnumData.ResourceType>(x).Value); }); list = list.Where(x => resourceTypes.Contains(x.ResourceType)); } if (queryItem.DateType == "拍摄时间") { if (queryItem.BeginDate != null) { list = list.Where(x => x.UploadTime >= queryItem.BeginDate); } if (queryItem.EndDate != null) { var endDate = queryItem.EndDate.AddDays(1); list = list.Where(x => x.UploadTime < endDate); } } else if (queryItem.DateType == "上传时间") { if (queryItem.BeginDate != null) { list = list.Where(x => x.CreatedTime >= queryItem.BeginDate); } if (queryItem.EndDate != null) { var endDate = queryItem.EndDate.AddDays(1); list = list.Where(x => x.CreatedTime < endDate); } } if (!string.IsNullOrEmpty(queryItem.UserId)) { list = list.Where(x => x.UserId.Contains(queryItem.UserId)); } if (!string.IsNullOrEmpty(queryItem.UserName)) { list = list.Where(x => x.UserName.Contains(queryItem.UserName)); } if (!string.IsNullOrEmpty(queryItem.EquipmentNo)) { list = list.Where(x => x.EquipmentNo.Contains(queryItem.EquipmentNo)); } var data = list.ToList(); var result = new List <ResourcesDTO>(); var equipments = equipmentService.GetEquipments(); foreach (var temp in data) { var equipment = equipments.FirstOrDefault(x => x.EquipmentNo == temp.DeviceInfo); result.Add(new ResourcesDTO { ResourceName = EnumHelper.GetByValue <DAMS.Common.EnumData.ResourceType>(temp.ResourceType).Description, ResourceId = temp.ResourceId, ResourceType = temp.ResourceType, UserId = (equipment == null ? string.Empty : equipment.Name),//temp.UserId, EquipmentNo = temp.EquipmentNo, UserName = temp.UserName, DepartId = temp.DepartId, UploadTime = temp.UploadTime, FilePath = temp.FilePath, FileName = temp.FileName, Alias = temp.Alias, Extension = temp.Extension, DeviceInfo = temp.DeviceInfo }); } return(result); } }