private void btnGenerateSql_Click(object sender, EventArgs e)
{
string filePath = txtFilePath.Text;
if (string.IsNullOrWhiteSpace(filePath))
{
MessageBox.Show("请选择doc文档!", "提示");
return;
}
string text = this.cbGenerateWay.SelectedItem.ToString();
if (string.IsNullOrWhiteSpace(text))
{
MessageBox.Show("请选择生成方式!", "提示");
return;
}
string dbConnectionStr = this.txtDbConnectionStr.Text;
string dbType = this.txtDbType.Text;
switch (text)
{
case "创建数据表":
break;
case "同步数据表":
if (string.IsNullOrWhiteSpace(dbConnectionStr))
{
MessageBox.Show("请填写数据库连接字符串", "提示");
return;
}
if (string.IsNullOrWhiteSpace(dbType))
{
MessageBox.Show("请填写数据库类型", "提示");
return;
}
break;
default:
MessageBox.Show("未知生成方式!", "警告");
return;
}
DbComparedHelper comparedHelper = new DbComparedHelper();
comparedHelper.FilePath = filePath;
if (text == "同步数据表")
{
comparedHelper.SetConfig(config =>
{
config.DbConnection = dbConnectionStr;
config.ProviderName = dbType;
});
}
var result = comparedHelper.Create();
this.rtbSql.Text = result;
}
public void Test_GenerateDoc()
{
DbComparedHelper compared = new DbComparedHelper();
compared.FilePath = @"";
compared.SetConfig(config =>
{
config.DbConnection = "";
config.DbName = "";
config.ProviderName = "";
});
var result = compared.Create();
Console.WriteLine(result);
}
