dbsourcedbdesconfig.cs

可以实现任意数据库之间的数据互导,可以实现任意数据库之间的数据互导

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Collections;

namespace LC_DataIO
{
    public partial class DbSourceDbDesConfig : Form
    {
        private ArrayList allrb = new ArrayList();
        public DbSourceDbDesConfig()
        {
            InitializeComponent();
        }

        private void DbSourceDbDesConfig_Load(object sender, EventArgs e)
        {
            init();
        }

        private void disendbleall(int p,int n)
        {
            if (p == 1)
            {

                this.dbsource_panel.Enabled = false;
                this.dbfiesource_panel.Enabled = false;
                this.dbstrsource_panel.Enabled = false;
            }
            if (n == 1)
            {
                this.dbstrdes_panel.Enabled = false;
                this.dbfiledes_panel.Enabled = false;
                this.dbdes_panel.Enabled = false;
            }
        }

        public void init()
        {
            disendbleall(1,1);
            this.s_rb1.Checked = true;
            this.dbsource_panel.Enabled = true;
            this.des_rb1.Checked = true;
            this.dbdes_panel.Enabled = true;

            this.allrb.Clear();
            this.allrb.Add(this.s_rb1);
            this.allrb.Add(this.src_rb2);
            this.allrb.Add(this.src_rb3);
            this.allrb.Add(this.des_rb1);
            this.allrb.Add(this.des_rb2);
            this.allrb.Add(this.des_rb3); 

        }
        #region 事件
        private void s_rb1_CheckedChanged(object sender, EventArgs e)
        {
            if (this.s_rb1.Checked)
            {
                disendbleall(1,0);
                this.dbsource_panel.Enabled = true;
            }

        }

        private void src_rb2_CheckedChanged(object sender, EventArgs e)
        {
            if (this.src_rb2.Checked)
            {
                disendbleall(1, 0);
                this.dbfiesource_panel.Enabled = true;
            }

        }

        private void src_rb3_CheckedChanged(object sender, EventArgs e)
        {
            if (this.src_rb3.Checked)
            {
                disendbleall(1, 0);
                this.dbstrsource_panel.Enabled = true;
            }
        }

        private void des_rb1_CheckedChanged(object sender, EventArgs e)
        {
            if (this.des_rb1.Checked)
            {
                disendbleall(0, 1);
                this.dbdes_panel.Enabled = true;
            }
        }

        private void des_rb2_CheckedChanged(object sender, EventArgs e)
        {
            if (this.des_rb2.Checked)
            {
                disendbleall(0, 1);
                this.dbfiledes_panel.Enabled = true;
            }
        }

        private void des_rb3_CheckedChanged(object sender, EventArgs e)
        {
            if (this.des_rb3.Checked)
            {
                disendbleall(0, 1);
                this.dbstrdes_panel.Enabled = true;
            }
        }

        private void pre_btn_Click(object sender, EventArgs e)
        {
            WizardFrm.wizard.choseWizard("转化方式编辑");
            WizardFrm.wizard.clearMe();
        }
        #endregion

        private int getIndex(int type)
        {
            if (type == 1)
            {
                for (int i = 0; i <=2; i++)
                {
                    if (((RadioButton)allrb[i]).Checked)
                    {
                        return i;
                    }
                }
            }
            if (type == 0)
            {
                for (int i = 3; i <= 5; i++)
                {
                    if (((RadioButton)allrb[i]).Checked)
                    {
                        return i;
                    }
                }
                
            }
            return -1;
        }

        private void next_btn_Click(object sender, EventArgs e)
        {
            switch (getIndex(1))
            {
                case 0:
                    if (this.dbip_tbxs.Text == "" || this.dbname_tbxs.Text == "" || this.dbpwd_tbxs.Text == "" || this.dbusers_tbxs.Text == "")
                    {
                        MessageBox.Show("请填写好相关信息");
                    }
                    else
                    {
                        string constr = this.dbip_tbxs.Text + "#" + this.dbname_tbxs.Text + "#" + this.dbusers_tbxs.Text + "#" + this.dbpwd_tbxs.Text;
                        HeadPage.ConverterXml.createSourceContenction(constr);
                        
                    }
                    break;
                case 1:
                    HeadPage.ConverterXml.createSourceContenction(filepath_s.Text);
                    HeadPage.ConverterXml.spliter = this.split_s.Text;
                    break;
                case 2:
                    break;
            }

            switch (getIndex(0))
            {
                case 3:
                    if (this.dbip_tbxe.Text == "" || this.dbname_tbxe.Text == "" || this.dbpwd_tbxe.Text == "" || this.dbusers_tbxe.Text == "")
                    {
                        MessageBox.Show("请填写好相关信息");
                    }
                    else
                    {
                        string constr = this.dbip_tbxe.Text + "#" + this.dbname_tbxe.Text + "#" + this.dbusers_tbxe.Text + "#" + this.dbpwd_tbxe.Text;
                        HeadPage.XmlConverter.createDesContentction(constr);

                    }
                    break;
                case 4:
                    HeadPage.XmlConverter.createDesContentction(filepath_e.Text);
                    HeadPage.XmlConverter.spliter = this.split_e.Text;
                    break;
                case 5:
                    break;
            }
            WizardFrm.wizard.tc.init();
            WizardFrm.wizard.choseWizard("表编辑");
            

        }

        private void button1_Click(object sender, EventArgs e)
        {
            OpenFileDialog ofd = new OpenFileDialog();
            if (ofd.ShowDialog() == DialogResult.OK)
            {
                this.filepath_s.Text = ofd.FileName.ToString();
            }
        }

        private void button2_Click(object sender, EventArgs e)
        {
            OpenFileDialog ofd = new OpenFileDialog();
            if (ofd.ShowDialog() == DialogResult.OK)
            {
                this.filepath_e.Text = ofd.FileName.ToString();
            }
        }



    }
}