/// <summary> /// 目标数据库测试连接 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnTestTarget_Click(object sender, EventArgs e) { string db_Target = cbxTargetDataBases.Text.Trim(); if (SQLServerDBHelper.TestResult(db_Target) == true) { labTarget.Text = "连接成功"; labTarget.ForeColor = System.Drawing.Color.Green; txbResult.AppendText("数据库“" + db_Target + "”连接测试成功\r\n\r\n"); } else { labTarget.Text = "连接失败"; labTarget.ForeColor = System.Drawing.Color.Red; txbResult.AppendText("数据库“" + db_Target + "”连接测试失败\r\n\r\n"); } }
/// <summary> /// DML的操作 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnCreateDML_Click(object sender, EventArgs e) { DataTable dt = new DataTable(); string source_DBName_f = cbxSourceDataBases.Text.Trim();//下拉列表选择的是数据库 string source_DBName = SQLServerDBHelper.IsLinkServer(source_DBName_f); string dest_DBName_f; string dest_DBName; if (dest_DBName_Top == "NotNull") { dest_DBName_f = cbxTargetDataBases.Text.Trim();//下拉列表选择的是数据库 dest_DBName = SQLServerDBHelper.IsLinkServer(dest_DBName_f); } else { dest_DBName_f = "空数据库"; dest_DBName = ""; } string generateScriptToStore_InsertData = "[SP_Dey_InsertDataScriptForTable]"; string operation_Type = "导入系统数据"; string fp = "d:\\SQL\\" + DateTime.Now.Year.ToString() + "年" + DateTime.Now.Month.ToString() + "月"; string str_Type = "D"; string str_FileName = "InsertData"; string select_Result = ""; bool flog = false; int select_Count = 0; Directory.CreateDirectory(fp); DirectoryInfo dir = new DirectoryInfo(fp); if (!File.Exists(fp)) { dir.Create(); } if (labSource.Text == "连接结果")//判断源数据库是否进行测试连通 { txbResult.AppendText("数据库“" + cbxSourceDataBases.Text.Trim() + "”未进行连通测试\r\n\r\n"); MessageBox.Show("请对“" + cbxSourceDataBases.Text.Trim() + "”进行连通测试"); } else if (labTarget.Text == "连接结果" && dest_DBName_Top == "NotNull")//判断目标数据库是否进行测试连通 { txbResult.AppendText("数据库“" + cbxTargetDataBases.Text.Trim() + "”未进行连通测试\r\n\r\n"); MessageBox.Show("请对“" + cbxTargetDataBases.Text.Trim() + "”进行连通测试"); } else if (labSource.Text == "连接失败")//源数据库连接失败,提示重新选择数据库 { txbResult.AppendText("源数据库无法连通,请选择正确的源数据库,并进行测试\r\n\r\n"); MessageBox.Show("源数据库无法连通,请选择正确的源数据库,并进行测试"); } else if (labTarget.Text == "连接失败" && dest_DBName_Top == "NotNull")//目标数据库连接失败,提示重新选择数据库 { txbResult.AppendText("目标数据库无法连通,请选择正确的目标数据库,并进行测试\r\n\r\n"); MessageBox.Show("目标数据库无法连通,请选择正确的目标数据库,并进行测试"); } else { if (SQLServerDBHelper.TestResult(cbxSourceDataBases.Text.Trim()) == false)//源数据库选择之后,没有进行测试,并且有不能连通,提示进行连接测试 { txbResult.AppendText("请点击“测试连接”按钮,确认源数据库" + cbxSourceDataBases.Text.Trim() + "是否能连通\r\n\r\n"); MessageBox.Show("请点击“测试连接”按钮,确认源数据库" + cbxSourceDataBases.Text.Trim() + "是否能连通"); } else if (SQLServerDBHelper.TestResult(cbxTargetDataBases.Text.Trim()) == false && dest_DBName_Top == "NotNull")//目标数据库选择之后,没有进行测试,并且有不能连通,提示进行连接测试 { txbResult.AppendText("请点击“测试连接”按钮,确认源数据库" + cbxTargetDataBases.Text.Trim() + "是否能连通\r\n\r\n"); MessageBox.Show("请点击“测试连接”按钮,确认源数据库" + cbxTargetDataBases.Text.Trim() + "是否能连通"); } else { flog = true; } } if (flog == true) { string tableName = ""; for (int t = 0; t < dgv_DataBaseName.Rows.Count; t++) { //int count = 0; //if (dgv_DataBaseName.Rows[t].Cells[0].EditedFormattedValue.ToString() == "true") //{ count++; } //if (count == 0) //{ // MessageBox.Show("请至少选择一条数据!", "提示"); // return; //} //else //{ // string tableName = dgv_DataBaseName.Rows[t].Cells["TableName"].Value.ToString().Trim(); // SQLServerDBHelper.GetDBInfoToStore(source_DBName, dest_DBName, tableName, generateScriptToStore_InsertData); //生成创建元数据的脚本 // txbResult.AppendText("导入系统数据:“" + source_DBName_f + "”中" + tableName + "表的脚本操作成功\r\n\r\n"); //} DataGridViewCheckBoxCell checkCell = (DataGridViewCheckBoxCell)dgv_DataBaseName.Rows[t].Cells[0]; bool flag = Convert.ToBoolean(checkCell.Value); if (flag == true) { tableName += "'" + dgv_DataBaseName.Rows[t].Cells["TableName"].Value.ToString().Trim() + "',"; txbResult.AppendText("导入系统数据:“" + source_DBName_f + "”中" + tableName + "表的脚本获取成功\r\n\r\n"); select_Count++; } } tableName = tableName.Remove(tableName.Length - 1, 1); SQLServerDBHelper.GetDBInfoToStore(source_DBName, dest_DBName, tableName, generateScriptToStore_InsertData); //生成创建元数据的脚本 txbResult.AppendText("导入系统数据:“" + source_DBName_f + "”中" + tableName + "表的脚本操作成功\r\n\r\n"); if (select_Count != 0) { dt.Clear(); dt = SQLServerDBHelper.GetInfoStoreFile(str_Type); txbResult.AppendText("" + operation_Type + ":获取数据库中的数据成功\r\n\r\n"); for (int i = 0; i < dt.Rows.Count; i++)//取出的数据连成字符串 { select_Result += dt.Rows[i][0].ToString(); } txbResult.AppendText("" + operation_Type + ":获取的数据转换成功\r\n\r\n"); string dateTime = DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Day.ToString() + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString(); string filePath = fp + @"\" + str_FileName + "_" + source_DBName_f + "_" + dateTime + ".sql";//定义文件名 LinkLabel link = new LinkLabel(); link.Text = filePath; link.Cursor = Cursors.Hand; link.LinkBehavior = LinkBehavior.HoverUnderline; link.Parent = this.txbResult; this.txbResult.Controls.Add(link); txbResult.AppendText("" + operation_Type + ":文件存储的完整路径:" + filePath + "\r\n\r\n"); FileStream fs = new FileStream(filePath, FileMode.CreateNew, FileAccess.Write, FileShare.Read); StreamWriter sw = new StreamWriter(fs);//写入文件中 fs.SetLength(0); sw.WriteLine(select_Result); sw.Close(); txbResult.AppendText("" + operation_Type + ":数据存储完成\r\n\r\n"); } else { MessageBox.Show("至少选择一个表"); } } }
private void btnCreate_Click(object sender, EventArgs e) { DataTable dt = new DataTable(); string select_Result = ""; int i; bool flog = false; string source_DBName_f = cbxSourceDataBases.Text.Trim();//下拉列表选择的是数据库 string source_DBName = SQLServerDBHelper.IsLinkServer(source_DBName_f); // source_DBName_f.Insert(0, "["); //source_DBName = source_DBName.Insert(source_DBName.Length, "]");//给数据库添加“[]” string dest_DBName_f;//下拉列表选择的是数据库 string dest_DBName; if (dest_DBName_Top == "NotNull") { dest_DBName_f = cbxTargetDataBases.Text.Trim();//下拉列表选择的是数据库 dest_DBName = SQLServerDBHelper.IsLinkServer(dest_DBName_f); // dest_DBName_f.Insert(0, "["); //dest_DBName = dest_DBName.Insert(dest_DBName.Length, "]");//给数据库添加“[]” } else { dest_DBName_f = "空数据库"; dest_DBName = ""; } if (labSource.Text == "连接结果")//判断源数据库是否进行测试连通 { txbResult.AppendText("数据库“" + cbxSourceDataBases.Text.Trim() + "”未进行连通测试\r\n\r\n"); MessageBox.Show("请对“" + cbxSourceDataBases.Text.Trim() + "”进行连通测试"); } else if (labTarget.Text == "连接结果" && dest_DBName_Top == "NotNull")//判断目标数据库是否进行测试连通 { txbResult.AppendText("数据库“" + cbxTargetDataBases.Text.Trim() + "”未进行连通测试\r\n\r\n"); MessageBox.Show("请对“" + cbxTargetDataBases.Text.Trim() + "”进行连通测试"); } else if (labSource.Text == "连接失败")//源数据库连接失败,提示重新选择数据库 { txbResult.AppendText("源数据库无法连通,请选择正确的源数据库,并进行测试\r\n\r\n"); MessageBox.Show("源数据库无法连通,请选择正确的源数据库,并进行测试"); } else if (labTarget.Text == "连接失败" && dest_DBName_Top == "NotNull")//目标数据库连接失败,提示重新选择数据库 { txbResult.AppendText("目标数据库无法连通,请选择正确的目标数据库,并进行测试\r\n\r\n"); MessageBox.Show("目标数据库无法连通,请选择正确的目标数据库,并进行测试"); } else { if (SQLServerDBHelper.TestResult(cbxSourceDataBases.Text.Trim()) == false)//源数据库选择之后,没有进行测试,并且有不能连通,提示进行连接测试 { txbResult.AppendText("请点击“测试连接”按钮,确认源数据库" + cbxSourceDataBases.Text.Trim() + "是否能连通\r\n\r\n"); MessageBox.Show("请点击“测试连接”按钮,确认源数据库" + cbxSourceDataBases.Text.Trim() + "是否能连通"); } else if (SQLServerDBHelper.TestResult(cbxTargetDataBases.Text.Trim()) == false && dest_DBName_Top == "NotNull")//目标数据库选择之后,没有进行测试,并且有不能连通,提示进行连接测试 { txbResult.AppendText("请点击“测试连接”按钮,确认源数据库" + cbxTargetDataBases.Text.Trim() + "是否能连通\r\n\r\n"); MessageBox.Show("请点击“测试连接”按钮,确认源数据库" + cbxTargetDataBases.Text.Trim() + "是否能连通"); } else { flog = true; } } if (flog == true) { //判断选择的复选框 //string str = ""; //string str_Type = ""; //string str_FileName = ""; if (cbx_DDL_Table.Checked) { //str = "表"; i = DDL_Operation_Table(ref dt, ref select_Result, source_DBName, dest_DBName, dest_DBName_f); } if (cbx_DDL_View.Checked) { //str = "视图"; i = DDL_Operation_View(ref dt, ref select_Result, source_DBName_f, source_DBName, dest_DBName_f, dest_DBName); } if (cbx_DDL_Procedure.Checked) { //str = "存储过程"; i = DDL_Operation_Procedure(ref dt, ref select_Result, source_DBName_f, source_DBName, dest_DBName_f, dest_DBName); } if (cbx_DDL_Function.Checked) { //str = "函数"; i = DDL_Operation_Function(ref dt, ref select_Result, source_DBName_f, source_DBName, dest_DBName_f, dest_DBName); } if (cbx_DDL_Type.Checked) { //str = "类型"; i = DDL_Operation_Type(ref dt, ref select_Result, source_DBName_f, source_DBName, dest_DBName, dest_DBName_f); } if (cbx_DDL_Job.Checked) { string getDBInfoToStore_Job = "[SP_Cfg_GetJobMain]"; string str_Type = "J"; string str_FileName = "Job"; string operation_Type = "作业"; if (source_DBName.Length > (source_DBName_f.Length + 2)) { source_DBName = source_DBName.Substring(0, source_DBName.IndexOf(".")); } else { source_DBName = ""; } if (dest_DBName != "") { dest_DBName = dest_DBName.Substring(0, dest_DBName.IndexOf(".")); } SQLServerDBHelper.GetDBInfoToStore(source_DBName, dest_DBName, getDBInfoToStore_Job);//获得定义的信息,存入配置库 txbResult.AppendText("作业:取“" + source_DBName_f + "”中存储过程的定义信息,并存入“" + dest_DBName_f + "”的操作成功\r\n\r\n"); i = ScriptToStore(ref dt, ref select_Result, str_Type, str_FileName, operation_Type, dest_DBName_f); } } }