/// <summary>
/// 取得实体
/// </summary>
/// <param name="userInfo">用户</param>
/// <param name="id">主键</param>
/// <returns>实体</returns>
public CiDbLinkDefineEntity GetEntity(UserInfo userInfo, string id)
{
CiDbLinkDefineEntity entity = null;
var parameter = ParameterUtil.CreateWithMessage(userInfo, MethodBase.GetCurrentMethod(), this.serviceName, string.Empty);
ServiceUtil.ProcessRDIReadDb(userInfo, parameter, dbProvider =>
{
var manager = new CiDbLinkDefineManager(dbProvider, userInfo);
entity = manager.GetEntity(id);
});
return(entity);
}
/// <summary>
/// 分页获取查询引擎定义列表
/// </summary>
/// <param name="userInfo">用户</param>
/// <param name="searchValue">查询关键字</param>
/// <param name="recordCount">记录数</param>
/// <param name="pageIndex">当前页</param>
/// <param name="pageSize">每页显示记录条数</param>
/// <param name="sortExpression">排序字段</param>
/// <returns>数据表</returns>
public DataTable GetQueryEngineDefineDTByPage(UserInfo userInfo, string searchValue, out int recordCount, int pageIndex = 1, int pageSize = 20, string sortExpression = null)
{
var dataTable = new DataTable(QueryEngineDefineTable.TableName);
var returnRecordCount = 0;
var parameter = ParameterUtil.CreateWithOutMessage(userInfo, MethodBase.GetCurrentMethod(), this.serviceName);
ServiceUtil.ProcessRDIReadDb(userInfo, parameter, dbProvider =>
{
var manager = new QueryEngineDefineManager(dbProvider, userInfo);
if (string.IsNullOrEmpty(searchValue))
{
searchValue = QueryEngineDefineTable.FieldDeleteMark + " = 0 ";
}
else
{
searchValue += " AND " + QueryEngineDefineTable.FieldDeleteMark + " = 0 ";
}
dataTable = manager.GetDTByPage(out returnRecordCount, pageIndex, pageSize, searchValue, sortExpression);
dataTable.TableName = QueryEngineDefineTable.TableName;
// 这里是获数据库连接名称中文显示
CiDbLinkDefineManager dbLinkManager = new CiDbLinkDefineManager(dbProvider, userInfo);
if (!dataTable.Columns.Contains("LINKNAME_CHS"))
{
dataTable.Columns.Add("LINKNAME_CHS");
}
foreach (DataRow dr in dataTable.Rows)
{
string dbLinkId = BusinessLogic.ConvertToString(dr[QueryEngineDefineTable.FieldDataBaseLinkName]);
if (!string.IsNullOrEmpty(dbLinkId))
{
dr["LINKNAME_CHS"] = dbLinkManager.GetEntity(dbLinkId).LinkName;
}
}
dataTable.AcceptChanges();
});
recordCount = returnRecordCount;
return(dataTable);
}