/// <summary>
/// 获取实体及扩展数据的分页方法
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public List <dynamic> GetEntityInfoWithAttrValueListPaged(EntityInfoAttrQuery query, out int count)
{
List <dynamic> list = null;
try
{
var param = new DynamicParameters();
param.Add("@entityDefID", query.EntityDefID);
param.Add("@createdUserID", query.CreatedUserID);
param.Add("@entityInfoID", query.EntityID);
param.Add("@pageIndex", query.PageIndex);
param.Add("@pageSize", query.PageSize);
param.Add("@rowsCount", null, DbType.Int32, ParameterDirection.Output);
using (var conn = SessionFactory.CreateConnection())
{
list = QuickRepository.ExecProcQuery <dynamic>(conn, "pr_eav_EntityAttrValuePivotGetPaged", param).ToList <dynamic>();
}
//得到查询的总记录数目
count = param.Get <int>("@rowsCount");
return(list);
}
catch (System.Exception ex)
{
throw;
}
}
public ResponseResult <List <dynamic> > GetWithAttrValueList(EntityInfoAttrQuery query)
{
var result = ResponseResult <List <dynamic> > .Default();
try
{
var count = 0;
var list = FBDataService.GetEntityInfoWithAttrValueListPaged(query, out count);
if (list != null && list.Count == 0)
{
result = ResponseResult <List <dynamic> > .Success(null);
}
else
{
result = ResponseResult <List <dynamic> > .Success(list);
}
result.TotalRowsCount = count;
result.TotalPages = (count + query.PageSize - 1) / query.PageSize;
}
catch (System.Exception ex)
{
result = ResponseResult <List <dynamic> > .Error(
string.Format("获取基表单及扩展属性的分页数据失败，错误{0}", ex.Message)
);
}
return(result);
}
