/// <summary>
/// 通过连接名称得到数据库连接定义
/// </summary>
/// <param name="userInfo">用户</param>
/// <param name="linkName">数据库连接定义名称</param>
/// <returns>数据库连接定义实体</returns>
public CiDbLinkDefineEntity GetEntityByLinkName(UserInfo userInfo, string linkName)
{
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);
var names = new string[3];
var values = new object[3];
names[0] = CiDbLinkDefineTable.FieldLinkName;
names[1] = CiDbLinkDefineTable.FieldEnabled;
names[2] = CiDbLinkDefineTable.FieldDeleteMark;
values[0] = linkName;
values[1] = 1;
values[2] = 0;
var dtTemp = manager.GetDT(names, values);
if (dtTemp != null && dtTemp.Rows.Count > 0)
{
entity = BaseEntity.Create <CiDbLinkDefineEntity>(dtTemp);
}
});
return(entity);
}
/// <summary>
/// 根据主键值取得数据库连接定义
/// </summary>
/// <param name="userInfo">用户</param>
/// <param name="ids">主键</param>
/// <returns>数据表</returns>
public DataTable GetDTByIds(UserInfo userInfo, string[] ids)
{
var dataTable = new DataTable(CiDbLinkDefineTable.TableName);
var parameter = ParameterUtil.CreateWithMessage(userInfo, MethodBase.GetCurrentMethod(), this.serviceName, string.Empty);
ServiceUtil.ProcessRDIReadDb(userInfo, parameter, dbProvider =>
{
var manager = new CiDbLinkDefineManager(dbProvider, userInfo);
dataTable = manager.GetDT(CiDbLinkDefineTable.FieldId, ids, CiDbLinkDefineTable.FieldSortCode);
dataTable.TableName = CiDbLinkDefineTable.TableName;
});
return(dataTable);
}