/// <summary>
/// 删除数据库中的指定表
/// </summary>
public void RemoveTable(string connStr, string tableName)
{
IADOBase adoBase = new SqlADOBase(connStr);
string deleteStr = string.Format("Drop Table {0}", tableName);
adoBase.DoCommand(deleteStr);
}
/// <summary>
/// 在数据库中创建指定表
/// </summary>
public void CreateTable(string connStr, DBTableDetail tableInfo)
{
//形成SQL语句
StringBuilder strBuilder = new StringBuilder();
string str_create = string.Format("Create Table {0}", tableInfo.TableName);
strBuilder.Append(str_create);
strBuilder.Append(" (");
int start = 0;
if (tableInfo.Columns[0].ColumnType == "int")
{
if (tableInfo.Columns[0].IsAutoID)
{
strBuilder.Append(string.Format("{0} int PRIMARY KEY IDENTITY ,", tableInfo.Columns[0].ColumnName));
start = 1;
}
}
for (int i = start; i < tableInfo.Columns.Length; i++)
{
bool length_fixed = DBSystemHelper.DBType_lengthFixed(tableInfo.Columns[i].ColumnType);
string item;
if (length_fixed)
{
item = string.Format("{0} {1} ", tableInfo.Columns[i].ColumnName, tableInfo.Columns[i].ColumnType);
}
else
{
item = string.Format("{0} {1}({2}) ", tableInfo.Columns[i].ColumnName, tableInfo.Columns[i].ColumnType);
}
if ((tableInfo.Columns[i].DefaultValue != null) && (tableInfo.Columns[i].DefaultValue != ""))
{
item += string.Format("DEFAULT {0}", tableInfo.Columns[i].DefaultValue);
}
if (tableInfo.Columns[i].IsPkey)
{
item += "PRIMARY KEY";
}
if (i != tableInfo.Columns.Length - 1)
{
item += " , ";
}
strBuilder.Append(item);
}
strBuilder.Append(" )");
//插入数据库
IADOBase adoBase = new SqlADOBase(connStr);
adoBase.DoCommand(strBuilder.ToString());
}
/// <summary>
/// 还原指定数据库
/// </summary>
public static void RestoreDb(string dbIP, string user, string pwd, string bakFilePath, string dbName)
{
string connStr = string.Format("Server = {0} ;User = {1} ;Pwd = {2}", dbIP, user, pwd);
IADOBase adoBase = new SqlADOBase(connStr);
string command = string.Format("use {0} restore database {0} from disk = '{1}'", dbName, bakFilePath);
adoBase.DoCommand(command);
}
/// <summary>
/// 删除指定数据库
/// </summary>
public static void RemoveDb(string dbIP, string user, string pwd, string dbName)
{
string connStr = string.Format("Server = {0} ;User = {1} ;Pwd = {2}", dbIP, user, pwd);
IADOBase adoBase = new SqlADOBase(connStr);
string command = string.Format("Drop database {0}", dbName);
adoBase.DoCommand(command);
}
