/// <summary>
/// 连接数据库是否成功
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool ConnResult(SqlConnConfigEntity model)
{
StringBuilder strSql = new StringBuilder( );
strSql.AppendFormat("Data Source={0};", model.Ip);
strSql.Append("Initial Catalog=master;");
strSql.AppendFormat("User Id={0};", model.Name);
strSql.AppendFormat("Password={0};", model.Password);
return(SqlHelper.connectionTest(strSql.ToString( )));
}
/// <summary>
/// 获取数据列表
/// </summary>
/// <returns></returns>
public DataTable GetDataTable(SqlConnConfigEntity model)
{
StringBuilder conn = new StringBuilder( );
conn.AppendFormat("Data Source={0};", model.Ip);
conn.Append("Initial Catalog=master;");
conn.AppendFormat("User Id={0};", model.Name);
conn.AppendFormat("Password={0};", model.Password);
StringBuilder strSql = new StringBuilder( );
strSql.Append("SELECT name FROM master..sysdatabases ORDER BY name ");
return(SqlHelper.ExecuteDataTable(conn.ToString( ), strSql.ToString( )));
}
/// <summary>
/// 获取数据列表
/// </summary>
/// <param name="connstr"></param>
/// <returns></returns>
public DataTable GetDataTable(SqlConnConfigEntity model)
{
return(dal.GetDataTable(model));
}
/// <summary>
/// 连接数据库是否成功
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool ConnResult(SqlConnConfigEntity model)
{
return(dal.ConnResult(model));
}
