private void FormDataBaseSync_Load(object sender, EventArgs e)
{
CTool.CheckPathExistOrCreate(m_SerializeConnectsPath);
if (File.Exists(m_SerializeConnectsPath))
{
CSerialize ser = new CSerialize();
ser.FileName = m_SerializeConnectsPath;
m_db2Alias = (List <SDB2Connection>)ser.DeSerialize();
}
else
{
CDB2ConnectInfo db2Info = new CDB2ConnectInfo();
m_db2Alias = db2Info.m_conns;
}
/*初始化下拉框*/
{
this.comboBox_dDB.Items.Clear();
this.comboBox_sDB.Items.Clear();
foreach (SDB2Connection con in m_db2Alias)
{
this.comboBox_sDB.Items.Add(con.alias);
this.comboBox_dDB.Items.Add(con.alias);
}
}
}
public void createFilePath()
{
if (filePath.Length < 1)
{
return;
}
CTool.CheckPathExistOrCreate(filePath);
if (isNode)
{
return;
}
}
private void button_sync_Click(object sender, EventArgs e)
{
if (m_Schema.Length < 1)
{
MessageBox.Show("请选择Schema!");
return;
}
CGenDB2ExpImpBat batFile = new CGenDB2ExpImpBat();
getSourceDBAndDestDBInfo(out batFile.m_sDB2Info, out batFile.m_dDB2Info);
batFile.m_sDB2Info.user = textBox_sDBUser.Text;
batFile.m_sDB2Info.passwd = textBox_sDBPwd.Text;
batFile.m_dDB2Info.user = textBox_dDBUser.Text;
batFile.m_dDB2Info.passwd = textBox_dDBPwd.Text;
{
SDB2Connection sConn, dConn;
getSourceDBAndDestDBInfo(out sConn, out dConn);
CDB2Option opt = new CDB2Option(dConn);
//opt.TableSchema = m_Schema;
foreach (KeyValuePair <string, SDBTable> kv in m_SelTables)
{
batFile.m_tables.Add(kv.Value);
SDBTable stbl = kv.Value;
opt.TableSchema = stbl.schema;
if (stbl.delete_method == "delete")
{
opt.delete(stbl.name);
}
else if (stbl.delete_method == "truncate")
{
opt.truncate(stbl.name);
}
}
}
CTool.CheckPathExistOrCreate("./export_data/");
CTool.DeleteDirAllFiles("./export_data/");
batFile.m_TableSchema = m_Schema;
batFile.m_FileName = "./export_data/NJFKDJHSJFLSJFLS.bat";
batFile.GenFile();
CCmd cmd = new CCmd();
cmd.cmd("db2cmd " + batFile.m_FileName);
}
public void GenFile()
{
CTool.CheckPathExistOrCreate(m_ExportDataPath);
StreamWriter sWriter = new StreamWriter(m_FileName, false, Encoding.Default);
string line = "";
sWriter.WriteLine("@echo off");
line = String.Format("db2 connect to {0} user {1} using {2} \r\n call :PrintErrMsg %errorlevel% 连接{3}数据库 ", m_sDB2Info.alias, m_sDB2Info.user, m_sDB2Info.passwd, m_sDB2Info.alias);
sWriter.WriteLine(line);
foreach (SDBTable tbl in m_tables)
{
line = String.Format("db2 \"export to {0}/{1}.ixf of ixf SELECT * FROM {2}.{3} WITH UR \" ", m_ExportDataPath, tbl.name, tbl.schema, tbl.name);
sWriter.WriteLine(line);
line = String.Format("call :PrintErrMsg %errorlevel% 导出表{0}.{1} \r\n", tbl.schema, tbl.name);
sWriter.WriteLine(line);
}
sWriter.WriteLine("db2 connect reset\r\n");
line = String.Format("db2 connect to {0} user {1} using {2} \r\n call :PrintErrMsg %errorlevel% 连接{3}数据库 ", m_dDB2Info.alias, m_dDB2Info.user, m_dDB2Info.passwd, m_dDB2Info.alias);
sWriter.WriteLine(line);
foreach (SDBTable tbl in m_tables)
{
if (tbl.import_method == "replace")
{
line = String.Format("db2 \"import from {0}/{1}.ixf of ixf modified by compound=100 commitcount 10000 replace into {2}.{3} \" ", m_ExportDataPath, tbl.name, tbl.schema, tbl.name);
}
else if (tbl.import_method == "insert")
{
line = String.Format("db2 \"import from {0}/{1}.ixf of ixf commitcount 10000 insert into {2}.{3} \" ", m_ExportDataPath, tbl.name, tbl.schema, tbl.name);
}
else if (tbl.import_method == "insert_update")
{
line = String.Format("db2 \"import from {0}/{1}.ixf of ixf commitcount 10000 insert_update into {2}.{3} \" ", m_ExportDataPath, tbl.name, tbl.schema, tbl.name);
}
sWriter.WriteLine(line);
line = String.Format("call :PrintErrMsg %errorlevel% 导入表{0}.{1} \r\n", tbl.schema, tbl.name);
sWriter.WriteLine(line);
}
sWriter.WriteLine("db2 connect reset\n");
line = "echo 数据库同步成功完成！ \r\n pause \r\n exit 0 \r\n:PrintErrMsg\r\n if %1 equ 0 (goto SUCC) else (goto FAILD)\r\n\r\n :FAILD\r\n echo %2失败[%1]\r\n \r\n echo 数据库同步失败\r\n pause\r\nexit %1\r\n :SUCC\r\n echo %2成功[%1]\r\nGOTO:EOF ";
sWriter.WriteLine(line);
sWriter.Flush();
sWriter.Close();
}
private void button_SaveConfig_Click(object sender, EventArgs e)
{
SDB2Connection sConn, dConn;
getSourceDBAndDestDBInfo(out sConn, out dConn);
if (sConn != null)
{
sConn.user = textBox_sDBUser.Text;
sConn.passwd = textBox_sDBPwd.Text;
}
if (dConn != null)
{
dConn.user = textBox_dDBUser.Text;
dConn.passwd = textBox_dDBPwd.Text;
}
CTool.CheckPathExistOrCreate(m_SerializeConnectsPath);
CSerialize ser = new CSerialize();
ser.FileName = m_SerializeConnectsPath;
ser.Serialize(m_db2Alias);
}
private void FormKnowledgeBase_Load(object sender, EventArgs e)
{
CTool.CheckPathExistOrCreate(sTreeDir);
deserializeTree();
initTreeViewTable(this.treeView.Nodes, m_Tree);
}