/// <summary> /// 针对不同数据库 创建不同的连接对象 /// </summary> public static void findConn(string strDBType,ConnectionInfo connInfo) { if (strDBType == "SQL Server2005/2008") { if (sqlCon == null) { sqlCon = getMssqlConn(connInfo); } } else if (strDBType == "MySql") { IConnection<MySqlConnection> con = DBFactory.CreateConnnection<MySqlConnection>(); mysqlCon = con.CreateConn(connInfo); con.OpenConn(mysqlCon); } else { return; } }
public override void DeleteObject(ConnectionInfo conn, string objName) { SqlConnection sqlCon = Provider.getMssqlConn(conn); IDatabaseManage<SqlConnection> dbManage = DBFactory.CreateDatabaseManage<SqlConnection>(); dbManage.DelDatabase(sqlCon, objName ); }
public void CreateObject(ConnectionInfo conn, string dbName, string tableName, ColumnInfo column) { SqlConnection sqlCon = Provider.getMssqlConn(conn); IColumnManage<SqlConnection> columnManage = DBFactory.CreateColumnManage<SqlConnection>(); columnManage.AddColumn(sqlCon, dbName, tableName, column); }
//数据库备份 public void BackupDataBase(string dbName,ConnectionInfo conn,string fileFullName) { SqlConnection sqlCon = Provider.getMssqlConn(conn); IDatabaseManage<SqlConnection> dbManage = DBFactory.CreateDatabaseManage<SqlConnection>(); dbManage .BackupDatabase(sqlCon ,dbName ,fileFullName); }
public ConnectionInfo getConnInfo() { ConnectionInfo connInfo = new ConnectionInfo(); connInfo.Server = Session["Server"].ToString(); connInfo.UserName = Session["UserName"].ToString(); connInfo.Pwd = Session["Pwd"].ToString(); return connInfo; }
public bool DeleteObject(ConnectionInfo conn, string objType, string dbName, string tableName, string objName) { if (objType == "folder_col") { SqlConnection sqlCon = Provider.getMssqlConn(conn); IColumnManage<SqlConnection> colManage = DBFactory.CreateColumnManage<SqlConnection>(); DataTable dt=colManage.GetAllColumns(sqlCon, dbName, tableName); if (dt.Rows.Count > 1) { colManage.DelColumn(sqlCon, dbName, tableName, objName); return true; } } return false; }
public override void DeleteObject(ConnectionInfo conn, string objType, string dbName, string objName) { if (objType == "folder_table") { SqlConnection sqlCon = Provider.getMssqlConn(conn); ITableManage<SqlConnection> tableManage = DBFactory.CreateTableManage<SqlConnection>(); tableManage.DelTable(sqlCon, dbName, objName); } else if (objType == "folder_view") { SqlConnection sqlCon = Provider.getMssqlConn(conn); IViewManage<SqlConnection> viewManage = DBFactory.CreateViewManage<SqlConnection>(); viewManage.DelView(sqlCon, dbName, objName); } }
/// <summary> /// 获得数据库资源信息列表 /// </summary> /// <param name="strDBType">数据库类型</param> /// <param name="connInfo">连接实体</param> /// <returns></returns> public static IList<DataBaseInfo> findDBManage(string strDBType, ConnectionInfo connInfo) { if (sqlCon == null) { findConn(strDBType, connInfo); } if (strDBType == "SQL Server2005/2008") { return findDBManage_Mssql(); } else if (strDBType == "MySql") { return findDBManage_Mysql(); } else { return null; } }
/// <summary> /// 获得数据库名称 /// </summary> /// <param name="strDBType">数据库类型:SqlServer2005/2008、Mysql</param> /// <param name="connInfo">连接实体</param> /// <returns>数据集</returns> public static DataSet getDBList(string strDBType,ConnectionInfo connInfo) { DataSet ds = null; try { if (sqlCon == null) { findConn(strDBType, connInfo); } ds = new DataSet(); if (strDBType == "SQL Server2005/2008") { IDatabaseManage<SqlConnection> dbManage = DBFactory.CreateDatabaseManage<SqlConnection>(); ds = dbManage.GetAllDatabase(sqlCon); } else if (strDBType == "MySql") { IDatabaseManage<MySqlConnection> dbManage = DBFactory.CreateDatabaseManage<MySqlConnection>(); ds = dbManage.GetAllDatabase(mysqlCon); } } catch (Exception ex) { throw ex; } return ds; }
public virtual void RenameObject(ConnectionInfo connInfo, string oldName, string newName) { throw new NotImplementedException(); }
public void RenameObject(ConnectionInfo conn, string objName, string newName, string dbName, string tableName) { SqlConnection sqlCon = Provider.getMssqlConn(conn); IColumnManage<SqlConnection> columnManage = DBFactory.CreateColumnManage<SqlConnection>(); columnManage.RenameColumn(sqlCon, dbName, tableName, objName, newName); }
public override void RenameObject(ConnectionInfo conn, string objName, string newName, string dbName) { SqlConnection sqlCon = Provider.getMssqlConn(conn); ITableManage<SqlConnection> tableManage = DBFactory.CreateTableManage<SqlConnection>(); tableManage.RenameTable(sqlCon, dbName, objName, newName); }
//数据库是否存在 public bool IsExistDataBase(string dbName,ConnectionInfo conn) { SqlConnection sqlCon = Provider.getMssqlConn(conn); IDatabaseManage<SqlConnection> dbManage = DBFactory.CreateDatabaseManage<SqlConnection>(); return dbManage.IsExist(sqlCon, dbName); }
/// <summary> /// 获得Mysql数据库的连接对象 /// </summary> /// <param name="connInfo"></param> /// <returns></returns> internal static MySqlConnection getMysqlConn(ConnectionInfo connInfo) { IConnection<MySqlConnection> con = DBFactory.CreateConnnection<MySqlConnection>(); mysqlCon = con.CreateConn(connInfo); con.OpenConn(mysqlCon); return mysqlCon; }
/// <summary> /// 获得Sql Server数据库的连接对象 /// </summary> /// <param name="strDBType">数据库类型</param> /// <param name="connInfo">连接实体</param> /// <returns></returns> internal static SqlConnection getMssqlConn(ConnectionInfo connInfo) { IConnection<SqlConnection> con = DBFactory.CreateConnnection<SqlConnection>(); sqlCon = con.CreateConn(connInfo); con.OpenConn(sqlCon); return sqlCon; }
public virtual void CreateObject(ConnectionInfo connInfo, string nodeName) { throw new NotImplementedException(); }
public virtual void DeleteObject(ConnectionInfo connInfo, string nodeType, string parentNodeName, string nodeName) { throw new NotImplementedException(); }
//查看脚本 public override string ShowScript(string dbName, ConnectionInfo conn, string name) { SqlConnection sqlCon = Provider.getMssqlConn(conn); IViewManage<SqlConnection> tableManage = DBFactory.CreateViewManage<SqlConnection>(); string str= tableManage.ShowView(sqlCon, dbName, name); //对str进行/r/n处理 str =str.Replace("\r\n", " "); return str; }
public virtual string ShowScript(string dbName, ConnectionInfo connInfo, string name) { throw new NotImplementedException(); }
//查看表数据 public DataTable ShowTableData(string dbName, ConnectionInfo conn, string table) { SqlConnection sqlCon = Provider.getMssqlConn(conn); ITableManage<SqlConnection> tableManage = DBFactory.CreateTableManage<SqlConnection>(); return tableManage.ShowTableData(sqlCon, dbName, table); }