public static void Program(string mdbfilePath)
{
var _connectionString = string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0}", mdbfilePath);
using (var connection = new OleDbConnection(_connectionString))
{
connection.Open();
var structure = new TableStructure();
Console.WriteLine(string.Format("开始检查{0}", structure.Name));
structure.Check(connection);
var list = MdbClass.GetFields(connection, "GYYD");
connection.Close();
}
}
public void Check()
{
var existTables = MdbClass.GetTables(ParameterManager2.Connection);
var requireTables = ParameterManager2.Tables.Select(e => e.Name).ToList();
var messages = new List <string>();
foreach (var table in requireTables)
{
if (existTables.Contains(table) == false)
{
messages.Add(table);
}
}
if (messages.Count > 0)
{
QuestionManager2.Add(new Question2 {
Code = ID, Name = RuleName, CheckProject = CheckProject2.图层完整性, Description = string.Format("缺少表：{0}", string.Join("、", messages.ToArray()))
});
}
}
public void Ready(OleDbConnection connection)
{
_requireTables = XmlClass.GetRequireTables();
_acquireTables = MdbClass.GetTables(connection);
}
