/// <summary> /// 获取基础参数映射列表 /// </summary> /// <param name="request"></param> /// <param name="total"></param> /// <returns>返回列表</returns> public List <BasicDataMap> GetBasicDataMapList(BasicDataMapRequest request, out int total) { try { StringBuilder _query = new StringBuilder(); _query.AppendFormat(@"(select a.Id as SortId, b.Id,c.SysDictValue as FromSystem,a.OneOrgName,a.DictTypeName,a.DictValue, CASE WHEN b.BasicDataMapGuid is null THEN '否' ELSE '是' END as IsMapping,a.BasicDataGuid,b.UpdateDate,b.CreatedDate,b.BasicDataMapGuid,b.FKDictGuid, (STUFF((SELECT '>'+ltrim(SysDictValue) FROM T_SYS_Dictionary where CAST(DictGuid as varchar(36)) in (select Code from [dbo].[f_split](b.SysCatalogTitle,',') ) FOR XML PATH(''),TYPE).value('.','nvarchar(max)'), 1, 1, '') +'|'+b.SysCatalogTitle) as SysCatalogTitle from T_EXT_BasicData a left join T_POC_BasicDataMap b on a.BasicDataGuid=b.FKBasicDataGuid inner join T_SYS_Dictionary c on cast(a.Pocsource as nvarchar)=c.SysDictKey where 1=1"); var _parameters = new DynamicParameters(); if (request.Source?.Count > 0) { _query.AppendFormat(" and a.Pocsource in @Pocsource"); _parameters.Add("@Pocsource", request.Source.ToArray()); } if (request.LevelOneOrgID?.Count > 0) { _query.AppendFormat(" and a.OneOrgId in @OneOrgId"); _parameters.Add("@OneOrgId", request.LevelOneOrgID.ToArray()); } if (request.IsMapping == "0") { _query.AppendFormat(" and b.BasicDataMapGuid is null"); } if (request.IsMapping == "1") { _query.AppendFormat(" and b.BasicDataMapGuid is not null"); } _query.AppendFormat(" ) h"); //总数 total = GetInfos <int>(EumDBName.POC, string.Format("SELECT COUNT(1) FROM {0} ", _query), _parameters).First(); //分页 var _queryPage = string.Format(@"select Id, FromSystem , OneOrgName , DictTypeName , DictValue , IsMapping,UpdateDate,CreatedDate,BasicDataMapGuid,FKDictGuid,BasicDataGuid, SysCatalogTitle from (select ROW_NUMBER() OVER(ORDER BY h.SortId desc) as RowNum,h.* from {0}) as RowNumberTable", _query); if (request.Pagination) { _queryPage += " where RowNum between @rowbegin and @rowend "; _parameters.Add("@rowbegin", (request.PageIndex - 1) * request.PageSize + 1); _parameters.Add("@rowend", request.PageIndex * request.PageSize); } var list = GetInfos <BasicDataMap>(EumDBName.POC, _queryPage.ToString(), _parameters).ToList(); return(list); } catch (Exception ex) { total = 0; _Log4Net.Error("T_POC_ProductTypeRepository下方法GetBasicDataMapList异常:" + ex.Message); return(null); } }
public BasicDataMapResponse GetBasicDataMapList(BasicDataMapRequest request) { int total = 0; BasicDataMapResponse response = new BasicDataMapResponse(); response.DataList = repository.GetBasicDataMapList(request, out total); response.Total = total; return(response); }
public BaseResponse GetBasicDataMapList(BasicDataMapRequest request) { try { BasicDataMapResponse response = basicDataDomainService.GetBasicDataMapList(request); return(ApiSuccessResult(response)); } catch (Exception ex) { return(ApiErrorResult(ex.Message)); } }