public void LoadDatabaseSchema(DatabaseLink dbLink, ServerInfo srvInfo)
{
this.DBLink = dbLink;
this.SrvInfo = srvInfo;
this.DBName = dbLink.DatabaseName;
this.Database = srvInfo.GetDatabase(this.DBName);
LoadDbSchema(false);
}
private static void BuildDBDoc()
{
//string dbConnStr = @"Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password=pass@word1;Initial Catalog=ENTERPRISES_SUPERWORKFLOW;Data Source=.\SQL2008R2";
string dbname = "ENTERPRISES_SUPERWORKFLOW";
DatabaseLink link = new DatabaseLink(DatabaseType.MSSQLServer, @".\SQL2008R2", dbname, "sa", "pass@word1");
ServerInfo serverInfo = new ServerInfo(link);
IDatabaseInfo database = serverInfo.GetDatabase(dbname);
DBDocBuilder builder = new DBDocBuilder(database);
builder.Build();
}
public static void Add(DatabaseLink link)
{
var oldLink = (from p in Connections
where p.ServerName == link.ServerName
select p).FirstOrDefault();
if (oldLink != null)
{
Connections.Remove(oldLink);
}
Connections.Insert(0, link);
Save();
}
static ConnectionSetting()
{
string filePath = Path.Combine(Environment.CurrentDirectory, "Settings\\" + FileName);
if (File.Exists(filePath))
{
string txt = File.ReadAllText(filePath);
XElement config = XElement.Parse(txt);
foreach (XElement el in config.Elements())
{
DatabaseLink link = new DatabaseLink(
EnumHelper.ParseEnum<DatabaseType>(el.Attribute("Type").Value),
el.Attribute("ServerName").Value,
el.Attribute("LoginName").Value,
el.Attribute("LoginPassword").Value,
(bool)el.Attribute("IsWindowsLogin"));
link.SetDatabaseName(el.Attribute("DatabaseName").Value);
Connections.Add(link);
}
}
}
private void btnLogin_Click(object sender, EventArgs e)
{
this.cbServerType.Enabled = false;
this.cbServerName.Enabled = false;
this.rbWindows.Enabled = false;
this.rbSQLServer.Enabled = false;
this.txtLoginName.Enabled = false;
this.txtPassword.Enabled = false;
this.btnLogin.Enabled = false;
this.btnOK.Enabled = false;
this.cbDatabases.Enabled = false;
var link = new DatabaseLink((DatabaseType)this.cbServerType.SelectedValue, this.cbServerName.Text, this.txtLoginName.Text, this.txtPassword.Text, rbWindows.Checked);
this.DBLink = link;
BackgroundWorker worker = new BackgroundWorker();
worker.DoWork += new DoWorkEventHandler(worker_DoWork);
worker.RunWorkerCompleted += new RunWorkerCompletedEventHandler(worker_RunWorkerCompleted);
worker.RunWorkerAsync();
}
private static void BuildDBAccess()
{
//Console.WriteLine("正在生成...");
var watch1 = Stopwatch.StartNew();
//string dbConnStr = @"Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password=pass@word1;Initial Catalog=ENTERPRISES_SUPERWORKFLOW;Data Source=.\SQL2008R2";
string solutionName = "CK";
string dbname = "ENTERPRISES_SUPERWORKFLOW";
DatabaseLink link = new DatabaseLink(DatabaseType.MSSQLServer, @".\SQL2008R2", dbname, "sa", "pass@word1");
ServerInfo serverInfo = new ServerInfo(link);
IDatabaseInfo database = serverInfo.GetDatabase(dbname);
SolutionBuilder sb = new SolutionBuilder(database, solutionName, dbname, link.ConnectionString);
string errorStr = "";
if (!sb.Build(ref errorStr))
{
Console.Write(errorStr);
}
Console.WriteLine("over!");
Console.WriteLine("{0} ", watch1.Elapsed);
Console.ReadKey();
}
private static void TestAspnetForm(string tableName)
{
//string dbConnStr = @"Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password=pass@word1;Initial Catalog=DBTest;Data Source=.\SQL2008R2";
string dbname = "DBTest";
//string tableName = "SampleInt";
//string connStr2 = @"Data Source=.\SQL2008R2;Initial Catalog=DBTest;User ID=sa;Password=pass@word1;Persist Security Info=False;";
DatabaseLink link = new DatabaseLink(DatabaseType.MSSQLServer, @".\SQL2008R2", dbname, "sa", "pass@word1");
ServerInfo serverInfo = new ServerInfo(link);
IDatabaseInfo database = serverInfo.GetDatabase(dbname);
ITableInfo tbInfo = null;
foreach (ITableInfo tInfo in database.Tables)
{
if (tInfo.LowerName == tableName.ToLower())
{
tbInfo = tInfo;
break;
}
}
PageFormCodeGen builder = new PageFormCodeGen();
PageFormModel model = new PageFormModel(tbInfo);
string folder = builder.Build(model);
Process.Start(folder);
}
private static void BuildProj()
{
//string dbConnStr = @"Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password=pass@word1;Initial Catalog=NGB_ONLINE;Data Source=192.168.0.98";
string dbname = "NGB_ONLINE";
string tableName = "CoursePlan";
//string connStr2 = @"Data Source=192.168.0.98;Initial Catalog=NGB_ONLINE;User ID=sa;Password=pass@word1;Persist Security Info=False;";
DatabaseLink link = new DatabaseLink(DatabaseType.MSSQLServer, @"192.168.0.98", dbname, "sa", "pass@word1");
ServerInfo serverInfo = new ServerInfo(link);
IDatabaseInfo database = serverInfo.GetDatabase(dbname);
List<ITableInfo> selTables = new List<ITableInfo>();
foreach (ITableInfo tInfo in database.Tables)
{
if (tInfo.LowerName == tableName.ToLower())
{
selTables.Add(tInfo);
break;
}
}
List<IViewInfo> selViews = new List<IViewInfo>();
DbConsoleProjectBuilder builder = new DbConsoleProjectBuilder();
string folder = builder.Build(selTables, selViews, link.ConnectionString, "TestApp");
Process.Start(folder);
}
private static void BuildTableAccess()
{
//string dbConnStr = @"Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password=pass@word1;Initial Catalog=DBTest;Data Source=.\SQL2008R2";
string dbname = "DBTest";
string tableName = "df_TestUser";
DatabaseLink link = new DatabaseLink(DatabaseType.MSSQLServer, @".\SQL2008R2", dbname, "sa", "pass@word1");
ServerInfo serverInfo = new ServerInfo(link);
IDatabaseInfo database = serverInfo.GetDatabase(dbname);
ITableInfo tbInfo = null;
foreach (ITableInfo tInfo in database.Tables)
{
if (tInfo.LowerName == tableName.ToLower())
{
tbInfo = tInfo;
break;
}
}
DbTableCodeGen gen = new DbTableCodeGen();
//string code = CodeGen.GenForTable("Model.cshtml", tbInfo);
string code = gen.GenDataAccessCode("TestApp", tbInfo);
string fileName = System.IO.Path.GetTempFileName();
System.IO.File.WriteAllText(fileName, code);
Process.Start("notepad.exe", fileName);
}
/// <summary>
/// 连接数据库
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnLink_Click(object sender, EventArgs e)
{
this.cbType.Enabled = false;
this.txtDBName.Enabled = false;
this.txtLoginName.Enabled = false;
this.txtPassword.Enabled = false;
this.btnLink.Enabled = false;
this.DBLink = new DatabaseLink((DatabaseType)this.cbType.SelectedValue, this.txtDBName.Text, this.txtLoginName.Text, this.txtPassword.Text, false);
BackgroundWorker worker = new BackgroundWorker();
worker.DoWork += new DoWorkEventHandler(worker_DoWork);
worker.RunWorkerCompleted += new RunWorkerCompletedEventHandler(worker_RunWorkerCompleted);
worker.RunWorkerAsync();
}
