//调试修改添加
private void GetAllDbLinks()
{
UserConfigHelper.GetConfig();
//RDIFramework.Utilities.UserInfo user = new RDIFramework.Utilities.UserInfo();
this.UserInfo.OpenId = "7d46323d-0091-4bf5-8a13-67fef63a4cd4";
this.UserInfo.Id = "26F43BC9-AE6D-42D2-BAC9-F4237A949484";
this.UserInfo.Code = "Administrator";
this.UserInfo.RealName = "Administrator";
this.UserInfo.IsAdministrator = true;
DataTable dtDbLinks = RDIFrameworkService.Instance.DbLinkDefineService.GetDT(this.UserInfo);
if (dtDbLinks != null && dtDbLinks.Rows.Count > 0)
{
foreach (DataRow dataRow in dtDbLinks.Rows)
{
ConnectString connStr = new ConnectString
{
LinkName = dataRow[CiDbLinkDefineTable.FieldLinkName].ToString()
};
string dbType = dataRow[CiDbLinkDefineTable.FieldLinkType].ToString();
switch (dbType.ToUpper())
{
case "ACCESS":
connStr.DbType = CurrentDbType.Access;
break;
case "ORACLE":
connStr.DbType = CurrentDbType.Oracle;
break;
case "MYSQL":
connStr.DbType = CurrentDbType.MySql;
break;
case "SQLLITE":
connStr.DbType = CurrentDbType.SQLite;
break;
case "DB2":
connStr.DbType = CurrentDbType.DB2;
break;
default:
connStr.DbType = CurrentDbType.SqlServer;
break;
}
connStr.DbLink = dataRow[CiDbLinkDefineTable.FieldLinkData].ToString();
DbLinks.Add(connStr);
}
}
}
private void GetAllDbLinks()
{
var dtDbLinks = RDIFrameworkService.Instance.DbLinkDefineService.GetDT(this.UserInfo);
if (dtDbLinks == null || dtDbLinks.Rows.Count <= 0)
{
return;
}
foreach (DataRow dataRow in dtDbLinks.Rows)
{
var connStr = new ConnectString
{
LinkName = dataRow[CiDbLinkDefineTable.FieldLinkName].ToString(),
DbLink = dataRow[CiDbLinkDefineTable.FieldLinkData].ToString()
};
string dbType = dataRow[CiDbLinkDefineTable.FieldLinkType].ToString();
switch (dbType.ToUpper())
{
case "ACCESS":
connStr.DbType = CurrentDbType.Access;
break;
case "ORACLE":
connStr.DbType = CurrentDbType.Oracle;
break;
case "MYSQL":
connStr.DbType = CurrentDbType.MySql;
break;
case "SQLLITE":
connStr.DbType = CurrentDbType.SQLite;
break;
case "DB2":
connStr.DbType = CurrentDbType.DB2;
break;
default:
connStr.DbType = CurrentDbType.SqlServer;
break;
}
DbLinks.Add(connStr);
}
}
