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