private void btnSynData_Click(object sender, EventArgs e)
{
string sourceDb = cboDbSource.SelectedValue.ToString();
string targerDb = cboDbTarger.SelectedValue.ToString();
AnalysisData ai = SqlTextHelper.Analysis(txtSqlText.Text,
cboDbSource.SelectedValue.ToString(), false, null);
IDictionary <string, IList <string> > sqlList = ai.SqlText;
txtResult.Text += string.Join("\r\n", sqlList["del"].ToArray()).Replace(sourceDb, targerDb);
txtResult.Text += string.Join("\r\n", sqlList["add"].ToArray()).Replace(sourceDb, targerDb);;
try
{
MessageBox.Show("" + MySqlHelper.ExecuteNonQuery(txtResult.Text));
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnResolve_Click(object sender, EventArgs e)
{
List <string> list = new List <string>();
list.Add(textBox1.Text);
AnalysisData ai = SqlTextHelper.Analysis(txtSqlText.Text, cboDataBase.SelectedValue.ToString(), chkIsOnly.Checked, list);
IDictionary <string, IList <string> > sqlList = ai.SqlText;
if (chkAdd.Checked)
{
txtResult.Text = string.Join("\r\n", sqlList["add"].ToArray());
txtResult.Text += "\r\n";
}
if (chkDel.Checked)
{
txtResult.Text += string.Join("\r\n", sqlList["del"].ToArray());
txtResult.Text += "\r\n";
}
if (chkUpd.Checked)
{
txtResult.Text += string.Join("\r\n", sqlList["upd"].ToArray());
txtResult.Text += "\r\n";
}
if (chkJson.Checked)
{
txtResult.Text += string.Join("\r\n", sqlList["json"].ToArray());
txtResult.Text += "\r\n";
}
txtLog.Text = LocalData.Logs.ToString();
if (!string.IsNullOrEmpty(LocalData.ErrLogs.ToString()))
{
txtLog.Text += LocalData.ErrLogs.ToString();
MessageBox.Show("生成有误！请查看执行日志最下面的错误信息！");
}
//json 字符串
}