public BasicResponse <List <AreaInfo> > GetPassiveAreaInfoByAssId(LongIdRequest request) { var req3 = new EmergencyLinkageConfigCacheGetAllRequest(); var res3 = _sysEmergencyLinkageCacheService.GetAllSysEmergencyLinkageCache(req3); var linkageInfo = res3.Data.FirstOrDefault(a => a.PassiveAreaAssId == request.Id.ToString()); var passiveAreaAss = linkageInfo == null ? new List <EmergencyLinkagePassiveAreaAssInfo>() : linkageInfo.PassiveAreas; var req = new AreaCacheGetAllRequest(); var res = _areaCacheService.GetAllAreaCache(req); if (res.Code != 100) { throw new Exception(res.Message); } var allArea = res.Data; //var allPassiveAreaAss = _emergencyLinkagePassiveAreaAssRepository.Datas.ToList(); var res2 = from a in passiveAreaAss join b in allArea on a.AreaId equals b.Areaid into temp from ab in temp.DefaultIfEmpty() //where a.PassiveAreaAssId == request.Id.ToString() select ab; var retLis = res2.ToList(); var ret = new BasicResponse <List <AreaInfo> >() { Data = retLis }; return(ret); }
public BasicResponse <List <EnumcodeInfo> > GetMasterTriDataStateByAssId(LongIdRequest request) { var req3 = new EmergencyLinkageConfigCacheGetAllRequest(); var res3 = _sysEmergencyLinkageCacheService.GetAllSysEmergencyLinkageCache(req3); var linkageInfo = res3.Data.FirstOrDefault(a => a.MasterTriDataStateAssId == request.Id.ToString()); var masterTriDataStateAss = linkageInfo == null ? new List <EmergencyLinkageMasterTriDataStateAssInfo>() : linkageInfo.MasterTriDataStates; var req = new EnumcodeGetByEnumTypeIDRequest() { EnumTypeId = 4.ToString() }; var res = _enumcodeService.GetEnumcodeByEnumTypeID(req); if (res.Code != 100) { throw new Exception(res.Message); } var allDataState = res.Data; //var allMasterTriDataStateAss = _emergencyLinkageMasterTriDataStateAssRepository.Datas.ToList(); var res2 = from a in masterTriDataStateAss join b in allDataState on a.DataStateId equals b.LngEnumValue.ToString() into temp from ab in temp.DefaultIfEmpty() //where a.MasterTriDataStateAssId == request.Id.ToString() select ab; var retLis = res2.ToList(); var ret = new BasicResponse <List <EnumcodeInfo> >() { Data = retLis }; return(ret); }
public BasicResponse <List <Jc_DevInfo> > GetMasterEquTypeInfoByAssId(LongIdRequest request) { var req3 = new EmergencyLinkageConfigCacheGetAllRequest(); var res3 = _sysEmergencyLinkageCacheService.GetAllSysEmergencyLinkageCache(req3); var linkageInfo = res3.Data.FirstOrDefault(a => a.MasterDevTypeAssId == request.Id.ToString()); var masterDevTypeAss = linkageInfo == null ? new List <EmergencyLinkageMasterDevTypeAssInfo>() : linkageInfo.MasterDevTypes; var req = new DeviceDefineCacheGetAllRequest(); var res = _deviceDefineCacheService.GetAllPointDefineCache(req); if (res.Code != 100) { throw new Exception(res.Message); } var allEquType = res.Data; //var allMasterDevTypeAss = _emergencyLinkageMasterDevTypeAssRepository.Datas.ToList(); var res2 = from a in masterDevTypeAss join b in allEquType on a.DevId equals b.Devid into temp from ab in temp.DefaultIfEmpty() //where a.MasterDevTypeAssId == request.Id.ToString() select ab; var retLis = res2.ToList(); var ret = new BasicResponse <List <Jc_DevInfo> >() { Data = retLis }; return(ret); }
public BasicResponse <List <SysEmergencyLinkageInfo> > GetAllSysEmergencyLinkageList() { //var res = _Repository.GetAllSysEmergencyLinkageList(); //var convert = ObjectConverter.CopyList<SysEmergencyLinkageModel, SysEmergencyLinkageInfo>(res).ToList(); //var ret = new BasicResponse<List<SysEmergencyLinkageInfo>>() //{ // Data = convert //}; //return ret; var req = new EmergencyLinkageConfigCacheGetAllRequest(); var res = _sysEmergencyLinkageCacheService.GetAllSysEmergencyLinkageCache(req); var ret = new BasicResponse <List <SysEmergencyLinkageInfo> >() { Data = res.Data }; return(ret); }
public BasicResponse <List <GetSysEmergencyLinkageListAndStatisticsResponse> > GetSysEmergencyLinkageListAndStatistics(StringRequest request) { var lis = new List <GetSysEmergencyLinkageListAndStatisticsResponse>(); var req2 = new LargeDataAnalysisConfigCacheGetAllRequest(); var res2 = _largeDataAnalysisConfigCacheService.GetAllLargeDataAnalysisConfigCache(req2); var allLargeDataConfig = res2.Data; var req = new EmergencyLinkageConfigCacheGetAllRequest(); var res = _sysEmergencyLinkageCacheService.GetAllSysEmergencyLinkageCache(req); var name = request.Str; List <SysEmergencyLinkageInfo> queryData; if (string.IsNullOrEmpty(name)) { queryData = res.Data.OrderByDescending(a => a.EditTime).ToList(); } else { queryData = res.Data.Where(a => a.Name == request.Str).OrderByDescending(a => a.EditTime).ToList(); } foreach (var item in queryData) { var largeDataConfig = allLargeDataConfig.FirstOrDefault(a => a.Id == item.MasterModelId); var largeDataConfigName = largeDataConfig == null ? "" : largeDataConfig.Name; var newItem = new GetSysEmergencyLinkageListAndStatisticsResponse() { DeletePerson = item.DeletePerson, DeleteTime = item.DeleteTime.ToString("yyyy-MM-dd HH:mm:ss"), EditPerson = item.EditPerson, EditTime = item.EditTime.ToString("yyyy-MM-dd HH:mm:ss"), Id = item.Id, MasterAreaAssId = item.MasterAreaAssId, MasterAreaNum = item.MasterAreas.Count.ToString(), MasterDevTypeAssId = item.MasterDevTypeAssId, MasterDevTypeNum = item.MasterDevTypes.Count.ToString(), MasterModelName = largeDataConfigName, MasterPointAssId = item.MasterPointAssId, MasterPointNum = item.MasterPoint.Count.ToString(), MasterTriDataStateAssId = item.MasterTriDataStateAssId, MasterTriDataStateNum = item.MasterTriDataStates.Count.ToString(), PassiveAreaAssId = item.PassiveAreaAssId, PassiveAreaNum = item.PassiveAreas.Count.ToString(), PassivePersonAssId = item.PassivePersonAssId, PassivePersonNum = item.PassivePersons.Count.ToString(), PassivePointAssId = item.PassivePointAssId, PassivePointNum = item.PassivePoints.Count.ToString(), Name = item.Name, Type = item.Type, TypeName = item.Type == 1 ? "普通联动" : "大数据分析联动", Duration = item.Duration }; lis.Add(newItem); } //var name = request.Str; //var dt = _Repository.QueryTable( // "global_SysEmergencyLinkageService_GetSysEmergencyLinkageListAndStatistics", name); //foreach (DataRow item in dt.Rows) //{ // var newItem = new GetSysEmergencyLinkageListAndStatisticsResponse() // { // DeletePerson = item["DeletePerson"].ToString(), // DeleteTime = item["DeleteTimeConvert"].ToString(), // EditPerson = item["EditPerson"].ToString(), // EditTime = item["EditTime"].ToString(), // Id = item["Id"].ToString(), // MasterAreaAssId = item["MasterAreaAssId"].ToString(), // MasterAreaNum = item["MasterAreaNum"].ToString(), // MasterDevTypeAssId = item["MasterDevTypeAssId"].ToString(), // MasterDevTypeNum = item["MasterDevTypeNum"].ToString(), // MasterModelName = item["MasterModelName"] == null ? "" : item["MasterModelName"].ToString(), // MasterPointAssId = item["MasterPointAssId"].ToString(), // MasterPointNum = item["MasterPointNum"].ToString(), // MasterTriDataStateAssId = item["MasterTriDataStateAssId"].ToString(), // MasterTriDataStateNum = item["MasterTriDataStateNum"].ToString(), // PassiveAreaAssId = item["PassiveAreaAssId"].ToString(), // PassiveAreaNum = item["PassiveAreaNum"].ToString(), // PassivePersonAssId = item["PassivePersonAssId"].ToString(), // PassivePersonNum = item["PassivePersonNum"].ToString(), // PassivePointAssId = item["PassivePointAssId"].ToString(), // PassivePointNum = item["PassivePointNum"].ToString(), // Name = item["Name"].ToString(), // Type = (int)item["Type"], // TypeName = (int)item["Type"] == 1 ? "普通联动" : "大数据分析联动", // Duration = Convert.ToInt32(item["Duration"]) // }; // lis.Add(newItem); //} var ret = new BasicResponse <List <GetSysEmergencyLinkageListAndStatisticsResponse> >() { Data = lis }; return(ret); }