/// <summary>
/// �ж����ݿ���bbsmax/idmax��صı���Ѿ�����
/// </summary>
/// <returns></returns>
public static bool IsSqlLiteMaxExists()
{
int i = 0;
SQLiteConnection connection = new SQLiteConnection(Settings.Current.bbsMaxConnectionString);
try
{
if (ConnectionState.Closed == connection.State)
{
connection.Open();
}
SQLiteCommand cmd = new SQLiteCommand("SELECT COUNT(*) FROM bbsMax_Posts;", connection);//System_Max_Settings bbsMax_Posts
i = Globals.ToInt32(cmd.ExecuteScalar(), 0);
return(1 == i);
}
catch (Exception ex)
{
SetupManager.CreateLog("���ݿ��Ƿ����" + ex.Message + Settings.Current.bbsMaxConnectionString);
}
finally
{
connection.Close();
}
return(false);
}
/// <summary>
/// �ж����ݿ���bbsmax��صı���Ѿ�����
/// </summary>
/// <returns></returns>
public static bool IsMaxExists()
{
int i = 0;
SqlConnection connection = new SqlConnection(Settings.Current.IConnectionString + "Pooling=false;");
if (ConnectionState.Closed == connection.State)
{
connection.Open();
}
SqlCommand cmd = new SqlCommand();
cmd.Connection = connection;
cmd.CommandText = "SELECT COUNT(Db_ID('" + Settings.Current.IDatabase + "'));";
if (Globals.ToInt32(cmd.ExecuteScalar()) == 1)
{
connection.Close();
connection.ConnectionString = Settings.Current.IConnectionString;
connection.Open();
cmd.CommandText = "SELECT COUNT(*) FROM sysobjects WHERE id = OBJECT_ID('bbsMax_Posts') OR id = OBJECT_ID('bx_Posts');";
i = Globals.ToInt32(cmd.ExecuteScalar(), 0);
}
return(i > 0);
}
