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);
}
}
