fieldsconfig.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 FieldsConfig : Form
    {
        public FieldsConfig()
        {
            InitializeComponent();
        }
        public static ArrayList sourcereadyfield = new ArrayList();
        public static ArrayList deseadyfield = new ArrayList();
        private void FieldsConfig_Load(object sender, EventArgs e)
        {
            init();
        }
        public void init()
        {
            sourcfields_lbx.Items.Clear();
            desfields_lbx.Items.Clear();
            sourcereadyfield.Clear();
            sreadyfield_lbx.Items.Clear();
            deseadyfield.Clear();
            desreadyfield_lbx.Items.Clear();
            ArrayList temp = HeadPage.ConverterXml.getAllSourceField(TableConfig.SourceReadyTable);
            for (int i = 0; i < temp.Count; i++)
            {
                this.sourcfields_lbx.Items.Add(temp[i].ToString());
            }

            temp = HeadPage.XmlConverter.getAllDesField(TableConfig.DesReadyTable);
            for (int i = 0; i < temp.Count; i++)
            {
                this.desfields_lbx.Items.Add(temp[i].ToString());
            }
        }
        private void sourcefieldselect_btn_Click(object sender, EventArgs e)
        {
            if (this.sourcfields_lbx.SelectedIndex != -1)
            {
                this.sreadyfield_lbx.Items.Add(this.sourcfields_lbx.SelectedItem.ToString());
                
                sourcereadyfield.Add(this.sourcfields_lbx.SelectedItem.ToString());
                this.sourcfields_lbx.Items.Remove(this.sourcfields_lbx.SelectedItem.ToString());
            }
            else
            {
                MessageBox.Show("请选择项");
            }
        }

        private void deseslecttable_Click(object sender, EventArgs e)
        {
            if (this.desfields_lbx.SelectedIndex != -1)
            {
                this.desreadyfield_lbx.Items.Add(this.desfields_lbx.SelectedItem.ToString());
                deseadyfield.Add(this.desfields_lbx.SelectedItem.ToString());
                this.desfields_lbx.Items.Remove(this.desfields_lbx.SelectedItem.ToString());
            }
            else
            {
                MessageBox.Show("请选择项");
            }
        }

        private void removes_btn_Click(object sender, EventArgs e)
        {
            if (this.sreadyfield_lbx.SelectedIndex != -1)
            {
                this.sourcfields_lbx.Items.Add(this.sreadyfield_lbx.SelectedItem.ToString());
                sourcereadyfield.RemoveAt(this.sreadyfield_lbx.SelectedIndex);
                this.sreadyfield_lbx.Items.Remove(this.sreadyfield_lbx.SelectedItem.ToString());
            }
            else
            {
                MessageBox.Show("请选择项");
            }
        }

        private void removed_btn_Click(object sender, EventArgs e)
        {
            if (this.desreadyfield_lbx.SelectedIndex != -1)
            {
                
                deseadyfield.Remove(this.desreadyfield_lbx.SelectedItem.ToString());
                this.desfields_lbx.Items.Add(this.desreadyfield_lbx.SelectedItem.ToString());
                this.desreadyfield_lbx.Items.RemoveAt(this.desreadyfield_lbx.SelectedIndex);
            }
            else
            {
                MessageBox.Show("请选择项");
            }
        }

        private void pre_btn_Click(object sender, EventArgs e)
        {
              WizardFrm.wizard.choseWizard("表编辑");
        }

        private void next_btn_Click(object sender, EventArgs e)
        {
            if (this.sreadyfield_lbx.Items.Count == this.desreadyfield_lbx.Items.Count)
            {
                WizardFrm.wizard.choseWizard("字段属性编辑");
                WizardFrm.wizard.fec.init();
            }
            else
            {
                MessageBox.Show("源表的转化字段要与目的表的转化字段相等");
            }
        }

        
    }
}