/// <summary>
/// 发布图层
/// </summary>
/// <param name="layerId">图层编号</param>
/// <returns>true：发布成功，false：发布失败</returns>
public bool PublicLayer(string layerName, string title, ListResultOutput <LayerFieldDto> listDto, string layerType)
{
if (!_GeoServer.IsExsitWorkSpace(_GeoWorkSpace))
{
_GeoServer.AddWorkSpace(_GeoWorkSpace);
}
if (!_GeoServer.IsExsitDataStore(_GeoWorkSpace, _GeoDataStore))
{
_GeoServer.AddDataStore(_GeoWorkSpace, _GeoDataStore, _PostGisHost, _PostGisPort, _PostGisDB, _PostGisUser, _PostGisPwd);
}
Dictionary <string, string> filedAndType = new Dictionary <string, string>();
for (int i = 0; i < listDto.Items.Count; i++)
{
filedAndType.Add(listDto.Items[i].AttributeName, GetGeoFiledType(listDto.Items[i].AttributeTypeName));
}
filedAndType.Add("guid", GetGeoFiledType("VARCHAR"));
filedAndType.Add("geom", GetGeoFiledType(layerType));
if (!_GeoServer.IsExsitLayer(layerName, _GeoWorkSpace, _GeoDataStore))
{
_GeoServer.AddLayer(layerName, title, filedAndType, _GeoWorkSpace, _GeoDataStore, _epsg);
_GeoServer.ModifyLayerStyle(layerName, new List <string>(), GetDefaultStyle(layerType));
}
return(true);
}
/// <summary>
/// 根据MapID查询
/// </summary>
/// <param name="mapId"></param>
/// <returns></returns>
public ListResultOutput <MapReleationDto> GetAllListByMapId(string mapId)
{
try
{
var query = _IMapReleationRepository.GetAllList().Where(q => q.MapID == mapId).ToList().OrderBy(q => q.DataSort);
var list = new ListResultOutput <MapReleationDto>(query.MapTo <List <MapReleationDto> >());
if (list.Items.Count > 0)
{
for (int i = 0; i < list.Items.Count; i++)
{
if (!string.IsNullOrWhiteSpace(list.Items[i].DataConfigID))
{
var layer = _ILayerContentRepository.Get(list.Items[i].DataConfigID);
list.Items[i].DataConfigName = (layer != null) ? layer.LayerName : "";
}
if (!string.IsNullOrWhiteSpace(list.Items[i].DataStyleID))
{
var style = _IDataStyleRepository.Get(list.Items[i].DataStyleID);
list.Items[i].DataStyleName = (style != null) ? style.StyleName : "";
}
}
}
return(list);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
/// <summary>
/// 通过图层ID获取字段字典集合
/// </summary>
/// <param name="layerID"></param>
/// <returns></returns>
public ListResultOutput <LayerFieldDictDto> GetFieldDictByLayerID(string layerID)
{
try
{
List <LayerFieldDictDto> layerFieldDicts = new List <LayerFieldDictDto>();
var query = _ILayerFieldRepository.GetAll().Where(q => q.LayerID == layerID && q.AttributeDataType == "T").ToList();
foreach (var item in query)
{
string fieldId = item.Id;
var result = _ILayerFieldDictRepository.GetAll().Where(t => t.AttributeID == fieldId).ToList();
foreach (var detail in result)
{
LayerFieldDictDto dto = new LayerFieldDictDto();
dto.AttributeID = detail.AttributeID;
dto.FieldDictDesc = detail.FieldDictDesc;
dto.FieldDictName = detail.FieldDictName;
dto.Id = detail.Id;
layerFieldDicts.Add(dto);
}
}
var list = new ListResultOutput <LayerFieldDictDto>(layerFieldDicts);
return(list);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public async Task <List <ComboboxItemDto> > GetEditionComboboxItems(int?selectedEditionId = null)
{
var editions = await _editionManager.Editions.ToListAsync();
var editionItems = new ListResultOutput <ComboboxItemDto>(editions.Select(e => new ComboboxItemDto(e.Id.ToString(), e.DisplayName)).ToList()).Items.ToList();
var defaultItem = new ComboboxItemDto("null", L("NotAssigned"));
editionItems.Insert(0, defaultItem);
if (selectedEditionId.HasValue)
{
var selectedEdition = editionItems.FirstOrDefault(e => e.Value == selectedEditionId.Value.ToString());
if (selectedEdition != null)
{
selectedEdition.IsSelected = true;
}
}
else
{
defaultItem.IsSelected = true;
}
return(editionItems);
}
public async Task <List <NameValue> > GetCustomersAddresses(long customerId)
{
string str;
await this._customerRepository.GetAsync(customerId);
IRepository <Address, long> repository = this._addressRepository;
List <Address> allListAsync = await repository.GetAllListAsync((Address x) => x.OwnerId == customerId && x.OwnerType == "Customer");
List <NameValue> nameValues = new List <NameValue>();
foreach (Address address in allListAsync)
{
ListResultOutput <CountryRegionInCountryListDto> countryRegions = this._genericAppService.GetCountryRegions(address.CountryRegionId, null);
string[] primaryAddress = new string[] { address.PrimaryAddress, " ", address.City, null, null, null };
str = (countryRegions.Items.Count == 1 ? string.Concat(", ", countryRegions.Items[0].Code) : "");
primaryAddress[3] = str;
primaryAddress[4] = " ";
primaryAddress[5] = address.PostalCode;
string str1 = string.Concat(primaryAddress);
long id = address.Id;
nameValues.Add(new NameValue(id.ToString(), str1));
}
return(nameValues);
}
/// <summary>
/// 绑定下拉框 根据父ID查询
/// </summary>
/// <param name="pid"></param>
/// <returns></returns>
public async Task <ListResultOutput <LayerManagerDto> > GetLayerManagerByPID()
{
var result = _iLayerManagerRepository.GetAll().Where(q => q.PID == "0000");
var outputList = new ListResultOutput <LayerManagerDto>(result.MapTo <List <LayerManagerDto> >());
return(outputList);
}
/// <summary>
/// 通过外键获取附件列表
/// </summary>
/// <param name="fkid"></param>
/// <returns></returns>
public async Task <ListResultOutput <AttachmentDto> > GetAllList(string fkid)
{
var result = await _iAttachmentRepository.GetAllListAsync(q => q.FKey == fkid);
var outputList = new ListResultOutput <AttachmentDto>(result.MapTo <List <AttachmentDto> >());
return(outputList);
}
/// <summary>
/// 获取不带count的分页列表
/// </summary>
/// <param name="PageIndex"></param>
/// <param name="PageSize"></param>
/// <param name="input"></param>
/// <returns></returns>
public async Task <ListResultOutput <LayerManagerDto> > GetPageList(QueryLayerManagerInput input)
{
var result = await _iLayerManagerRepository.GetPageList(input.Name, input.PageIndex, input.PageSize);
var outputList = new ListResultOutput <LayerManagerDto>(result.MapTo <List <LayerManagerDto> >());
return(outputList);
}
public async Task <ListResultOutput <StudentEnabledExamTimeDto> > GetStudentCourseExamTimes(GetExamTimeEventInput input)
{
input.Start = input.Start.AddDays(-1);
input.End = input.End.AddDays(1);
var studentid = AbpSession.UserId ?? 0;
var student = await _studentRepository.FirstOrDefaultAsync(x => x.Id == studentid);
if (student == null)
{
throw new UserFriendlyException("用户不存在。");
}
var studentSubjects = await _studentSubjectTimeRepository.GetAllListAsync(x => x.StudentId == studentid);
var studentSubjectsIds = studentSubjects.Select(i => i.CourseId).ToList();
var studentCourses = await _courseRepository.GetAllListAsync(x => studentSubjectsIds.Contains(x.SubjectProjectId));
var studentCoursesIds = studentCourses.Select(i => i.Id).ToList();
var studentSelectedExamTime = await _studentCourseExamTimeRepository.GetAllListAsync(
x => x.StudentId == studentid &&
!x.ExamTime.TeacherCourse.IsDeleted &&
!x.ExamTime.TeacherCourse.Course.IsDeleted);
var studentSelectedExamTimeIds = studentSelectedExamTime.Select(x => x.ExamTimeId).ToList();
var query = _courseExamTimeRepository.GetAll();
var s = ((DateTime.Today.Year - student.EntryDate.Year) * 12 + (DateTime.Today.Month - student.EntryDate.Month)) / 12 + 1;
var studentGrade = $",{s},";
query = query.Where(x => x.FitGrade == null || x.FitGrade == "" || x.FitGrade.Contains(studentGrade));
query = query.Where(x => studentCoursesIds.Contains(x.TeacherCourse.CourseId) && x.Start > input.Start && x.Start < input.End);
var studentEnabledExamTimes = await Task.FromResult(query.Select(x => new
{
x.Id,
x.TeacherCourse,
x.Start,
x.Address,
x.Times,
x.End,
//EnabledSelecting = x.Times < x.TeacherCourse.Course.LimitNumbers,
EnabledEndTime = x.End >= DateTime.Today,
EnabledStartTime = x.Start <= DateTime.Now,
IsSelected = studentSelectedExamTimeIds.Contains(x.Id)
}).ToList());
var result = new ListResultOutput <StudentEnabledExamTimeDto>
(Mapper.DynamicMap <List <StudentEnabledExamTimeDto> >(studentEnabledExamTimes));
return(result);
}
public async Task <ListResultOutput <ComboboxItemDto> > GetEditionsForCombobox()
{
List <Edition> listAsync = await this._editionManager.Editions.ToListAsync <Edition>();
ListResultOutput <ComboboxItemDto> listResultOutput = new ListResultOutput <ComboboxItemDto>((
from e in listAsync
select new ComboboxItemDto(e.Id.ToString(), e.DisplayName)).ToList <ComboboxItemDto>());
return(listResultOutput);
}
/// <summary>
/// 获取分类管理(通过图层与地图类型区分)
/// </summary>
/// <param name="dataType">图层或地图基本代码</param>
/// <returns></returns>
public ListResultOutput <DataTypeDto> GetAllListByDataType(string dataType)
{
try
{
var query = _IDataTypeRepository.GetAll().Where(q => q.DictCodeID == dataType);
var list = new ListResultOutput <DataTypeDto>(query.MapTo <List <DataTypeDto> >());
return(list);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public ListResultOutput<UserDto> GetAllList()
{
string key = "userlist";
var cacheList = _cache.Get<ListResultOutput<UserDto>>(CacheCategoryUserInfo, key);
if (cacheList == null)
{
var user = _userRepository.GetAllList();
cacheList= new ListResultOutput<UserDto>(user.MapTo<List<UserDto>>());
_cache.Put(CacheCategoryUserInfo, key, cacheList);
}
return cacheList;
}
/// <summary>
/// 通过类别获取所有数据
/// </summary>
/// <param name="typeID"></param>
/// <returns></returns>
public ListResultOutput <DicDataCodeDto> GetDetailByTypeID(string typeID)
{
try
{
var query = _IDicDataCodeRepository.GetAll().Where(q => q.DataTypeID == typeID).ToList();
var list = new ListResultOutput <DicDataCodeDto>(query.MapTo <List <DicDataCodeDto> >());
return(list);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
/// <summary>
/// 根据通过名称获取数据
/// </summary>
public ListResultOutput <DataTypeDto> GetDetailByName(string name, string dataType)
{
try
{
var query = _IDataTypeRepository.GetAll().Where(q => q.TypeName == name && q.DictCodeID == dataType);
var result = new ListResultOutput <DataTypeDto>(query.MapTo <List <DataTypeDto> >());
return(result);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public async Task <ListResultOutput <HazardsTypeDto> > GetAllList()
{
try
{
var result = await _iHazardstypeRepository.GetAllListAsync();
var outputList = new ListResultOutput <HazardsTypeDto>(result.MapTo <List <HazardsTypeDto> >());
return(outputList);
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// 按条件分页查询
/// </summary>
/// <param name="querySlopeInput"></param>
/// <returns></returns>
public async Task <ListResultOutput <SlopeDto> > GetPageList(QuerySlopeInput querySlopeInput)
{
try
{
var slope = await _iSlopeRepository.GetPageList(querySlopeInput.PageIndex, querySlopeInput.PageSize, querySlopeInput.DISASTERUNITNAME, querySlopeInput.LOCATION);
var list = new ListResultOutput <SlopeDto>(slope.MapTo <List <SlopeDto> >());
return(list);
}
catch (Exception exception)
{
throw exception;
}
}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="queryDisasterDato"></param>
/// <returns></returns>
public async Task <ListResultOutput <DisasterDto> > GetPageList(QueryDisasterInput queryDto)
{
try
{
var disasterEntity = await _iDisasterRepository.GetPageList(queryDto.PageIndex, queryDto.PageSize);
var list = new ListResultOutput <DisasterDto>(disasterEntity.MapTo <List <DisasterDto> >());
return(list);
}
catch (Exception exception)
{
throw exception;
}
}
/// <summary>
/// 获取所有数据
/// </summary>
public async Task <ListResultOutput <DataTagDto> > GetAllList()
{
try
{
//var query = await _IDataTagRepository.GetAllListAsync();
var query = _IDataTagRepository.GetAllList();
var list = new ListResultOutput <DataTagDto>(query.MapTo <List <DataTagDto> >());
return(list);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
/// <summary>
/// 获取所有数据
/// </summary>
/// <returns></returns>
public async Task <ListResultOutput <DisasterDto> > GetAllList()
{
try
{
var disasterEntity = await _iDisasterRepository.GetAllListAsync();
var list = new ListResultOutput <DisasterDto>(disasterEntity.MapTo <List <DisasterDto> >());
return(list);
}
catch (Exception exception)
{
throw exception;
}
}
public async Task<List<ComboboxItemDto>> GetEditionComboboxItems(GetTimezoneComboboxItemsInput input)
{
var timeZones = await GetTimezoneInfos(input.DefaultTimezoneScope);
var timeZoneItems = new ListResultOutput<ComboboxItemDto>(timeZones.Select(e => new ComboboxItemDto(e.Value, e.Name)).ToList()).Items.ToList();
if (!string.IsNullOrEmpty(input.SelectedTimezoneId))
{
var selectedEdition = timeZoneItems.FirstOrDefault(e => e.Value == input.SelectedTimezoneId);
if (selectedEdition != null)
{
selectedEdition.IsSelected = true;
}
}
return timeZoneItems;
}
// private readonly IRepository<City> citiesRepository;
public int GetCity(GetAddressInput input)
{
var output = this.citiesRepository
.GetAll()
.WhereIf(
input.Filter != null,
p => p.Name.Contains(input.Filter)
)
.ToList()
;
ListResultOutput<StreetAddressListDto> list = new ListResultOutput<StreetAddressListDto>(output.MapTo<List<StreetAddressListDto>>());
return list.Items.ElementAt(0).Id;
}
public async Task <List <ComboboxItemDto> > GetTimezoneComboboxItems(GetTimezoneComboboxItemsInput input)
{
var timeZones = await GetTimezoneInfos(input.DefaultTimezoneScope);
var timeZoneItems = new ListResultOutput <ComboboxItemDto>(timeZones.Select(e => new ComboboxItemDto(e.Value, e.Name)).ToList()).Items.ToList();
if (!string.IsNullOrEmpty(input.SelectedTimezoneId))
{
var selectedEdition = timeZoneItems.FirstOrDefault(e => e.Value == input.SelectedTimezoneId);
if (selectedEdition != null)
{
selectedEdition.IsSelected = true;
}
}
return(timeZoneItems);
}
public async Task <ListResultOutput <OrganizationUnitDto> > GetOrganizationUnits()
{
var result = await(from ou in _organizationUnitRepository.GetAll()
join uou in _userOrganizationUnitRepository.GetAll() on ou.Id equals uou.OrganizationUnitId into g
select new
{
ou = ou,
memberCount = g.Count()
}).ToListAsync();
ListResultOutput <OrganizationUnitDto> listResultOutput = new ListResultOutput <OrganizationUnitDto>(result.Select((item) =>
{
OrganizationUnitDto organizationUnitDto = item.ou.MapTo <OrganizationUnitDto>();
organizationUnitDto.MemberCount = item.memberCount;
return(organizationUnitDto);
}).ToList());
return(listResultOutput);
}
/// <summary>
/// 根据帐号和图层ID获取通知
/// </summary>
public ListResultOutput <LayerReadLogOutputDto> GetDetailByLayer(LayerReadLogOutputDto input)
{
try
{
string layerID = input.LayerID, user = input.CreateBy;
ListResultOutput <LayerReadLogOutputDto> list;
var layer = _ILayerContentRepository.GetAll();
//var readLog = _ILayerReadLogRepository.GetAll().Where(q => (string.IsNullOrEmpty(layerID) ? true : q.LayerID.Contains(layerID)) && (string.IsNullOrEmpty(user) ? true : (q.CreateBy.Contains(user) && q.MsgStatus.Value.Equals(0))));
var readLog = _ILayerReadLogRepository.GetAll();
if (string.IsNullOrEmpty(layerID))
{
readLog = readLog.Where(q => (q.CreateBy.Contains(user) && q.MsgStatus == 1));
}
else
{
readLog = readLog.Where(q => q.LayerID.Contains(layerID) && (q.CreateBy.Contains(user) && q.MsgStatus == 1));
}
var query = (from r in readLog
join l in layer on r.LayerID equals l.Id into rl
from rre in rl.DefaultIfEmpty()
select new LayerReadLogOutputDto
{
Id = r.Id,
LayerID = r.LayerID,
LayerName = (rre == null) ? "" : rre.LayerName,
ShpFileName = r.ShpFileName,
ReadStatus = r.ReadStatus,
Message = r.Message,
CreateDT = r.CreateDT,
CreateBy = r.CreateBy,
ReadStartDT = r.ReadStartDT,
ReadEndDT = r.ReadEndDT,
MsgStatus = r.MsgStatus
}).OrderByDescending(x => x.CreateDT).ToList();
list = new ListResultOutput <LayerReadLogOutputDto>(query.MapTo <List <LayerReadLogOutputDto> >());
return(list);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
/// <summary>
/// 根据基本代码获取数据
/// </summary>
public ListResultOutput <DataTagDto> GetAllListByDataType(string dataType)
{
try
{
List <string> listTags = new List <string>();
//地图标签
//if (dataType == "ba5ab799-6acd-11e7-87f3-005056bb1c7e")
//{
// var listTag = _IMapRepository.GetAll().Where(t => !string.IsNullOrEmpty(t.MapTag)).Select(t => t.MapTag).ToList();
// listTag.ForEach(t =>
// {
// listTags.AddRange(t.Split(','));
// });
// listTags = listTags.Distinct().ToList();
//}
////图层标签
//else if (dataType == "a2faae61-6acd-11e7-87f3-005056bb1c7e")
//{
// var listTag = _ILayerContentRepository.GetAll().Where(t => !string.IsNullOrEmpty(t.LayerTag)).Select(t => t.LayerTag).ToList();
// listTag.ForEach(t =>
// {
// listTags.AddRange(t.Split(','));
// });
// listTags = listTags.Distinct().ToList();
//}
var listTagReleation = _ITagReleationRepository.GetAll().Select(t => t.DataTagID).ToList();
listTagReleation.ForEach(t =>
{
listTags.AddRange(t.Split(','));
});
listTags = listTags.Distinct().ToList();
var query = _IDataTagRepository.GetAll().Where(q => q.DictCodeID == dataType && listTags.Contains(q.Id));
var list = new ListResultOutput <DataTagDto>(query.MapTo <List <DataTagDto> >());
return(list);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
/// <summary>
/// 获取所有数据
/// </summary>
public async Task <ListResultOutput <MapDto> > GetAllList()
{
try
{
//var query = await _IMapRepository.GetAllListAsync();
var query = _IMapRepository.GetAllList();
var list = new ListResultOutput <MapDto>(query.MapTo <List <MapDto> >());
if (list.Items.Count > 0)
{
for (int i = 0; i < list.Items.Count; i++)
{
if (list.Items[i].MapScale != null)
{
list.Items[i].MapScaleName = GetDetailCodeName(list.Items[i].MapScale);
}
if (list.Items[i].SpatialRefence != null)
{
list.Items[i].SpatialRefenceName = GetDetailCodeName(list.Items[i].SpatialRefence);
}
if (list.Items[i].MapType != null)
{
try
{
var mapType = _IDataTypeRepository.Get(list.Items[i].MapType);
list.Items[i].MapType = mapType.TypeName;
}
catch (Exception ex)
{
list.Items[i].MapType = "";
}
}
list.Items[i].MapTag = GetMultiTagNameByMapID(list.Items[i].Id);
}
}
return(list);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
private async Task <List <ComboboxItemDto> > GetEditionComboboxItems(int?selectedEditionId = null)
{
ListResultOutput <ComboboxItemDto> editionsForCombobox = await this._lookupAppService.GetEditionsForCombobox();
List <ComboboxItemDto> list = editionsForCombobox.Items.ToList <ComboboxItemDto>();
ComboboxItemDto comboboxItemDto = new ComboboxItemDto("null", this.L("NotAssigned"));
list.Insert(0, comboboxItemDto);
if (!selectedEditionId.HasValue)
{
comboboxItemDto.IsSelected = true;
}
else
{
ComboboxItemDto comboboxItemDto1 = list.FirstOrDefault <ComboboxItemDto>((ComboboxItemDto e) => e.Value == selectedEditionId.Value.ToString());
if (comboboxItemDto1 != null)
{
comboboxItemDto1.IsSelected = true;
}
}
return(list);
}
public async Task<List<ComboboxItemDto>> GetEditionComboboxItems(int? selectedEditionId = null)
{
var editions = await _editionManager.Editions.ToListAsync();
var editionItems = new ListResultOutput<ComboboxItemDto>(editions.Select(e => new ComboboxItemDto(e.Id.ToString(), e.DisplayName)).ToList()).Items.ToList();
var defaultItem = new ComboboxItemDto("null", L("NotAssigned"));
editionItems.Insert(0, defaultItem);
if (selectedEditionId.HasValue)
{
var selectedEdition = editionItems.FirstOrDefault(e => e.Value == selectedEditionId.Value.ToString());
if (selectedEdition != null)
{
selectedEdition.IsSelected = true;
}
}
else
{
defaultItem.IsSelected = true;
}
return editionItems;
}
public async Task <HttpResponseMessage> GetCountryRegionsAsSelectListItems(int?countryRegionId = null, int?countryId = null, int?selectedCountryRegionId = null, bool jTable = false)
{
string text = string.Empty;
object cachedRegionsJson = await _cacheManager.GetCache("_WebAppExtendedCache").GetOrDefaultAsync("CountryRegions");
if (cachedRegionsJson == null)
{
ListResultOutput <CountryRegionInCountryListDto> countryRegions = this._genericAppService.GetCountryRegions(null, null);
if (countryRegions.Items.Count > 0)
{
text = JsonConvert.SerializeObject(countryRegions);
await _cacheManager.GetCache("_WebAppExtendedCache").SetAsync("CountryRegions", text, new TimeSpan?(TimeSpan.FromMinutes(2400.0)));
}
}
else
{
text = cachedRegionsJson.ToString();
}
HttpResponseMessage result;
if (text.Length > 0)
{
var deserializedListResult = JsonConvert.DeserializeObject <ListResultOutput <CountryRegionInCountryListDto> >(text);
var selectListItems = new List <GenericSelectListItemModel>(deserializedListResult.Items.Count);
bool selectedFlag = false;
if (countryRegionId.HasValue && countryRegionId > 0)
{
foreach (var item in deserializedListResult.Items)
{
if (item.Id == countryRegionId)
{
if (selectedCountryRegionId == item.Id)
{
selectedFlag = true;
}
selectListItems.Add(new GenericSelectListItemModel
{
Text = item.Name,
Value = item.Id.ToString(),
Selected = selectedFlag,
Group = "",
Disabled = false
});
break;
}
}
text = JsonConvert.SerializeObject(selectListItems);
}
else if (countryId.HasValue && countryId > 0)
{
foreach (var item in deserializedListResult.Items)
{
if (item.CountryId == countryId)
{
if (selectedCountryRegionId == item.Id)
{
selectedFlag = true;
}
selectListItems.Add(new GenericSelectListItemModel
{
Text = item.Name,
Value = item.Id.ToString(),
Selected = selectedFlag,
Group = "",
Disabled = false
});
}
selectedFlag = false;
}
text = JsonConvert.SerializeObject(selectListItems);
}
else
{
foreach (var item in deserializedListResult.Items)
{
if (selectedCountryRegionId == item.Id)
{
selectedFlag = true;
}
selectListItems.Add(new GenericSelectListItemModel
{
Text = item.Name,
Value = item.Id.ToString(),
Selected = selectedFlag,
Group = "",
Disabled = false
});
selectedFlag = false;
}
text = JsonConvert.SerializeObject(selectListItems);
}
if (jTable)
{
var deserializedList = JsonConvert.DeserializeObject <List <GenericSelectListItemModel> >(text);
List <JTableOption> listOfJTableOptions = deserializedList.Select(i => new JTableOption
{
DisplayText = i.Text,
Value = i.Value
}).ToList <JTableOption>();
string jTableOptionResponseJson = JsonConvert.SerializeObject(new JTableOptionResponse
{
Result = "OK",
Options = listOfJTableOptions
});
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK, "OK");
response.Content = new StringContent(jTableOptionResponseJson, Encoding.UTF8);
response.Content.Headers.ContentType = new MediaTypeHeaderValue("application/json");
response.Headers.CacheControl = new CacheControlHeaderValue
{
MaxAge = new TimeSpan?(TimeSpan.FromMinutes(240.0))
};
result = response;
}
else
{
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK, "value");
response.Content = new StringContent(text, Encoding.UTF8);
response.Content.Headers.ContentType = new MediaTypeHeaderValue("application/json");
response.Headers.CacheControl = new CacheControlHeaderValue
{
MaxAge = new TimeSpan?(TimeSpan.FromMinutes(240.0))
};
result = response;
}
}
else
{
result = null;
}
return(result);
}
/// <summary>
/// 获取地图列表(通过标签，类型，名称)
/// </summary>
/// <param name="input"></param>
/// <returns></returns>
public ListResultOutput <MapDto> GetAllListByName(MapInputDto input)
{
ListResultOutput <MapDto> list;
try
{
string mapType = input.MapType, tag = input.MapTag, name = input.MapName, mapID = "", type = "";
if (!string.IsNullOrEmpty(tag))
{
mapID = GetMultiLayerIDByTag(tag);
}
if (!string.IsNullOrEmpty(mapType))
{
type = GetMultiChildTypeByType(mapType);
}
if (string.IsNullOrWhiteSpace(input.CreateUserId))
{
return(null);
}
var mapUserData = GetDataByUserCodeAsync(input.CreateUserId, name, type, mapID).Result;
var listMapType = _IDataTypeRepository.GetAll();
var listMapRefence = _IDicDataCodeRepository.GetAll();
var listMapScale = _IDicDataCodeRepository.GetAll();
var query = (from l in mapUserData
join t in listMapType on l.MapType equals t.Id into tt
from de in tt.DefaultIfEmpty()
join r in listMapRefence on l.SpatialRefence equals r.Id into rr
from re in rr.DefaultIfEmpty()
join dt in listMapScale on l.MapScale equals dt.Id into dtt
from ldt in dtt.DefaultIfEmpty()
select new MapDto
{
Id = l.Id,
MapName = l.MapName,
MapEnName = l.MapEnName,
MapBBox = l.MapBBox,
MapPublishAddress = l.MapPublishAddress,
MapStatus = l.MapStatus,
MapDesc = l.MapDesc,
MapType = (de == null) ? "" : de.TypeName,
MapTag = l.MapTag,
PublishDT = l.PublishDT,
SortCode = l.SortCode,
EnabledMark = l.EnabledMark,
DeleteMark = l.DeleteMark,
CreateUserId = l.CreateUserId,
CreateUserName = l.CreateUserName,
CreateDT = l.CreateDT,
ModifyUserId = l.ModifyUserId,
ModifyUserName = l.ModifyUserName,
ModifyDate = l.ModifyDate,
MapScale = l.MapScale,
MapScaleName = (ldt == null) ? "" : ldt.CodeName,
SpatialRefence = l.SpatialRefence,
SpatialRefenceName = (re == null) ? "" : re.CodeName,
MaxY = l.MaxY,
MinY = l.MinY,
MinX = l.MinX,
MaxX = l.MaxX,
MapLegend = l.MapLegend,
MaxDegLat = "",
MinDegLat = "",
MinDegLon = "",
MaxDegLon = ""
}).OrderByDescending(x => x.CreateDT);
var result = query.ToList();
list = new ListResultOutput <MapDto>(result.MapTo <List <MapDto> >());
return(list);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public IndexViewModel(ListResultOutput <SupplierListDto> output, string filter = null)
{
output.MapTo <ListResultOutput <SupplierListDto>, IndexViewModel>(this);
this.Filter = filter;
}
public async Task <HttpResponseMessage> GetCountriesAsSelectListItems(int?countryId = -1, int?selectedCountryId = null, bool jTable = false)
{
HttpResponseMessage httpResponseMessage;
int? nullable;
bool flag;
string empty = string.Empty;
object orDefaultAsync = await this._cacheManager.GetCache("_WebAppExtendedCache").GetOrDefaultAsync("Countries");
object obj = orDefaultAsync;
if (obj != null)
{
empty = obj.ToString();
}
else
{
nullable = null;
ListResultOutput <CountriesListDto> countries = this._genericAppService.GetCountries(nullable);
if (countries.Items.Count > 0)
{
empty = JsonConvert.SerializeObject(countries);
await this._cacheManager.GetCache("_WebAppExtendedCache").SetAsync("Countries", empty, new TimeSpan?(TimeSpan.FromMinutes(2400)));
}
}
if (empty.Length <= 0)
{
httpResponseMessage = null;
}
else
{
ListResultOutput <CountriesListDto> listResultOutput = JsonConvert.DeserializeObject <ListResultOutput <CountriesListDto> >(empty);
List <GenericSelectListItemModel> genericSelectListItemModels = new List <GenericSelectListItemModel>(listResultOutput.Items.Count);
bool flag1 = false;
foreach (CountriesListDto item in listResultOutput.Items)
{
nullable = selectedCountryId;
int id = item.Id;
flag = (nullable.GetValueOrDefault() == id ? nullable.HasValue : false);
if (flag)
{
flag1 = true;
}
GenericSelectListItemModel genericSelectListItemModel = new GenericSelectListItemModel()
{
Text = item.Name,
Value = item.Id.ToString(),
Selected = flag1,
Group = "",
Disabled = false
};
genericSelectListItemModels.Add(genericSelectListItemModel);
flag1 = false;
}
empty = JsonConvert.SerializeObject(genericSelectListItemModels);
if (!jTable)
{
HttpResponseMessage stringContent = this.Request.CreateResponse <string>(HttpStatusCode.OK, "value");
stringContent.Content = new StringContent(empty, Encoding.UTF8);
stringContent.Content.Headers.ContentType = new MediaTypeHeaderValue("application/json");
HttpResponseHeaders headers = stringContent.Headers;
CacheControlHeaderValue cacheControlHeaderValue = new CacheControlHeaderValue()
{
MaxAge = new TimeSpan?(TimeSpan.FromMinutes(240))
};
headers.CacheControl = cacheControlHeaderValue;
httpResponseMessage = stringContent;
}
else
{
List <GenericSelectListItemModel> genericSelectListItemModels1 = JsonConvert.DeserializeObject <List <GenericSelectListItemModel> >(empty);
List <JTableOption> list = (
from x in genericSelectListItemModels1
select new JTableOption()
{
DisplayText = x.Text,
Value = x.Value
}).ToList <JTableOption>();
JTableOptionResponse jTableOptionResponse = new JTableOptionResponse()
{
Result = "OK",
Options = list
};
string str = JsonConvert.SerializeObject(jTableOptionResponse);
HttpResponseMessage mediaTypeHeaderValue = this.Request.CreateResponse <string>(HttpStatusCode.OK, "OK");
mediaTypeHeaderValue.Content = new StringContent(str, Encoding.UTF8);
mediaTypeHeaderValue.Content.Headers.ContentType = new MediaTypeHeaderValue("application/json");
HttpResponseHeaders httpResponseHeader = mediaTypeHeaderValue.Headers;
CacheControlHeaderValue cacheControlHeaderValue1 = new CacheControlHeaderValue()
{
MaxAge = new TimeSpan?(TimeSpan.FromMinutes(240))
};
httpResponseHeader.CacheControl = cacheControlHeaderValue1;
httpResponseMessage = mediaTypeHeaderValue;
}
}
return(httpResponseMessage);
}
public async Task <FileDto> GetCustomerWithAddressesToExcel()
{
string str;
string str1;
List <Customer> allListAsync = await this._customerRepository.GetAllListAsync();
List <CustomerWithAddressListDto> customerWithAddressListDtos = new List <CustomerWithAddressListDto>();
foreach (Customer customer in allListAsync)
{
IRepository <Address, long> repository = this._addressRepository;
List <Address> addresses = await repository.GetAllListAsync((Address m) => m.OwnerId == customer.Id && m.OwnerType == "Customer");
foreach (Address address in addresses)
{
CustomerWithAddressListDto customerWithAddressListDto = new CustomerWithAddressListDto()
{
CustomerId = customer.Id,
AllowBillPay = customer.AllowBillPay,
IsActive = customer.IsActive,
FirstName = customer.FirstName,
LastName = customer.LastName,
BusinessName = customer.BusinessName,
CreationTime = new DateTime?(customer.CreationTime)
};
CustomerWithAddressListDto primaryAddress = customerWithAddressListDto;
primaryAddress.PrimaryAddress = address.PrimaryAddress;
primaryAddress.SecondaryAddress = address.SecondaryAddress;
primaryAddress.City = address.City;
int?countryRegionId = address.CountryRegionId;
if (!countryRegionId.HasValue)
{
primaryAddress.CountryRegionCode = "";
}
else
{
IGenericAppService genericAppService = this._genericAppService;
countryRegionId = address.CountryRegionId;
int?nullable = new int?(countryRegionId.Value);
countryRegionId = null;
ListResultOutput <CountryRegionInCountryListDto> countryRegions = genericAppService.GetCountryRegions(nullable, countryRegionId);
CustomerWithAddressListDto customerWithAddressListDto1 = primaryAddress;
str1 = (countryRegions == null || countryRegions.Items.Count != 1 ? "" : countryRegions.Items[0].Code);
customerWithAddressListDto1.CountryRegionCode = str1;
}
if (address.CountryId <= 0)
{
primaryAddress.CountryCode = "";
}
else
{
ListResultOutput <CountriesListDto> countries = this._genericAppService.GetCountries(new int?(address.CountryId));
CustomerWithAddressListDto customerWithAddressListDto2 = primaryAddress;
str = (countries == null || countries.Items.Count != 1 ? "" : countries.Items[0].Code);
customerWithAddressListDto2.CountryCode = str;
}
primaryAddress.PostalCode = address.PostalCode;
primaryAddress.Latitude = address.Latitude;
primaryAddress.Longitude = address.Longitude;
primaryAddress.ContactName = address.ContactName;
primaryAddress.Type = address.Type;
primaryAddress.AddressId = address.Id;
primaryAddress.AddressIsActive = address.IsActive;
customerWithAddressListDtos.Add(primaryAddress);
}
}
return(this._customerListExcelExporter.ExportToFile(customerWithAddressListDtos));
}
