dbtoscript.cs

通过数据库结构自动 生成三层结构代码,相当不错的一款软件

            this.progressBar2.Size = new Size(0x1ac, 10);
            this.progressBar2.TabIndex = 11;
            this.progressBar1.Location = new Point(0x10, 0xc0);
            this.progressBar1.Name = "progressBar1";
            this.progressBar1.Size = new Size(0x1ac, 20);
            this.progressBar1.TabIndex = 10;
            this.labelNum.Location = new Point(450, 0xbf);
            this.labelNum.Name = "labelNum";
            this.labelNum.Size = new Size(0x23, 0x16);
            this.labelNum.TabIndex = 9;
            this.labelNum.TextAlign = ContentAlignment.MiddleCenter;
            this.btn_Addlist.Enabled = false;
            this.btn_Addlist.FlatStyle = FlatStyle.Popup;
            this.btn_Addlist.Location = new Point(240, 0x1f);
            this.btn_Addlist.Name = "btn_Addlist";
            this.btn_Addlist.Size = new Size(40, 0x17);
            this.btn_Addlist.TabIndex = 7;
            this.btn_Addlist.Text = ">>";
            this.btn_Addlist.Click += new EventHandler(this.btn_Addlist_Click);
            this.btn_Add.Enabled = false;
            this.btn_Add.FlatStyle = FlatStyle.Popup;
            this.btn_Add.Location = new Point(240, 0x3d);
            this.btn_Add.Name = "btn_Add";
            this.btn_Add.Size = new Size(40, 0x17);
            this.btn_Add.TabIndex = 8;
            this.btn_Add.Text = ">";
            this.btn_Add.Click += new EventHandler(this.btn_Add_Click);
            this.btn_Del.Enabled = false;
            this.btn_Del.FlatStyle = FlatStyle.Popup;
            this.btn_Del.Location = new Point(240, 0x5b);
            this.btn_Del.Name = "btn_Del";
            this.btn_Del.Size = new Size(40, 0x17);
            this.btn_Del.TabIndex = 5;
            this.btn_Del.Text = "<";
            this.btn_Del.Click += new EventHandler(this.btn_Del_Click);
            this.btn_Dellist.Enabled = false;
            this.btn_Dellist.FlatStyle = FlatStyle.Popup;
            this.btn_Dellist.Location = new Point(240, 0x79);
            this.btn_Dellist.Name = "btn_Dellist";
            this.btn_Dellist.Size = new Size(40, 0x17);
            this.btn_Dellist.TabIndex = 6;
            this.btn_Dellist.Text = "<<";
            this.btn_Dellist.Click += new EventHandler(this.btn_Dellist_Click);
            this.listTable2.ItemHeight = 12;
            this.listTable2.Location = new Point(0x13a, 0x15);
            this.listTable2.Name = "listTable2";
            this.listTable2.Size = new Size(0xac, 0x94);
            this.listTable2.TabIndex = 1;
            this.listTable2.DoubleClick += new EventHandler(this.listTable2_DoubleClick);
            this.listTable1.ItemHeight = 12;
            this.listTable1.Location = new Point(0x10, 0x15);
            this.listTable1.Name = "listTable1";
            this.listTable1.SelectionMode = SelectionMode.MultiExtended;
            this.listTable1.Size = new Size(0xb7, 0x94);
            this.listTable1.TabIndex = 0;
            this.listTable1.DoubleClick += new EventHandler(this.listTable1_DoubleClick);
            this.btn_Creat._Image = null;
            this.btn_Creat.BackColor = Color.FromArgb(0, 0xec, 0xe9, 0xd8);
            this.btn_Creat.DefaultScheme = false;
            this.btn_Creat.DialogResult = DialogResult.None;
            this.btn_Creat.Image = null;
            this.btn_Creat.Location = new Point(0x134, 0x158);
            this.btn_Creat.Name = "btn_Creat";
            this.btn_Creat.Scheme = ButtonXP.Schemes.Blue;
            this.btn_Creat.Size = new Size(0x4b, 0x1a);
            this.btn_Creat.TabIndex = 0x2a;
            this.btn_Creat.Text = "生  成";
            this.btn_Creat.Click += new EventHandler(this.btn_Creat_Click);
            this.btn_Cancle._Image = null;
            this.btn_Cancle.BackColor = Color.FromArgb(0, 0xec, 0xe9, 0xd8);
            this.btn_Cancle.DefaultScheme = false;
            this.btn_Cancle.DialogResult = DialogResult.None;
            this.btn_Cancle.Image = null;
            this.btn_Cancle.Location = new Point(0x19c, 0x158);
            this.btn_Cancle.Name = "btn_Cancle";
            this.btn_Cancle.Scheme = ButtonXP.Schemes.Blue;
            this.btn_Cancle.Size = new Size(0x4b, 0x1a);
            this.btn_Cancle.TabIndex = 0x2a;
            this.btn_Cancle.Text = "取  消";
            this.btn_Cancle.Click += new EventHandler(this.btn_Cancle_Click);
            this.groupBox3.Controls.Add(this.txtTargetFolder);
            this.groupBox3.Controls.Add(this.btn_TargetFold);
            this.groupBox3.Controls.Add(this.label2);
            this.groupBox3.Location = new Point(8, 0x40);
            this.groupBox3.Name = "groupBox3";
            this.groupBox3.Size = new Size(0x1f7, 0x30);
            this.groupBox3.TabIndex = 0x2b;
            this.groupBox3.TabStop = false;
            this.groupBox3.Text = "保存";
            this.txtTargetFolder.BorderStyle = BorderStyle.FixedSingle;
            this.txtTargetFolder.Location = new Point(0x48, 0x10);
            this.txtTargetFolder.Name = "txtTargetFolder";
            this.txtTargetFolder.Size = new Size(0x15f, 0x15);
            this.txtTargetFolder.TabIndex = 0x2f;
            this.btn_TargetFold._Image = null;
            this.btn_TargetFold.BackColor = Color.FromArgb(0, 0xec, 0xe9, 0xd8);
            this.btn_TargetFold.DefaultScheme = false;
            this.btn_TargetFold.DialogResult = DialogResult.None;
            this.btn_TargetFold.Image = null;
            this.btn_TargetFold.Location = new Point(0x1ad, 14);
            this.btn_TargetFold.Name = "btn_TargetFold";
            this.btn_TargetFold.Scheme = ButtonXP.Schemes.Blue;
            this.btn_TargetFold.Size = new Size(0x39, 0x17);
            this.btn_TargetFold.TabIndex = 0x30;
            this.btn_TargetFold.Text = "选择...";
            this.btn_TargetFold.Click += new EventHandler(this.btn_TargetFold_Click);
            this.label2.AutoSize = true;
            this.label2.Location = new Point(0x10, 0x12);
            this.label2.Name = "label2";
            this.label2.Size = new Size(0x35, 12);
            this.label2.TabIndex = 0x31;
            this.label2.Text = "文件名：";
            this.pictureBox1.Image = Resources.Control;
            this.pictureBox1.Location = new Point(0xf6, 0x93);
            this.pictureBox1.Name = "pictureBox1";
            this.pictureBox1.Size = new Size(0x1c, 0x1c);
            this.pictureBox1.SizeMode = PictureBoxSizeMode.Zoom;
            this.pictureBox1.TabIndex = 0x35;
            this.pictureBox1.TabStop = false;
            this.pictureBox1.Visible = false;
            this.AutoScaleBaseSize = new Size(6, 14);
            base.ClientSize = new Size(0x20b, 0x17e);
            base.Controls.Add(this.groupBox3);
            base.Controls.Add(this.btn_Creat);
            base.Controls.Add(this.groupBox2);
            base.Controls.Add(this.groupBox1);
            base.Controls.Add(this.btn_Cancle);
            base.Icon = (Icon) manager.GetObject("$this.Icon");
            base.MaximizeBox = false;
            base.MinimizeBox = false;
            base.Name = "DbToScript";
            base.StartPosition = FormStartPosition.CenterScreen;
            this.Text = "生成SQL数据库脚本";
            base.Load += new EventHandler(this.DbToWord_Load);
            this.groupBox1.ResumeLayout(false);
            this.groupBox1.PerformLayout();
            this.groupBox2.ResumeLayout(false);
            this.groupBox3.ResumeLayout(false);
            this.groupBox3.PerformLayout();
            ((ISupportInitialize) this.pictureBox1).EndInit();
            base.ResumeLayout(false);
        }

        private void IsHasItem()
        {
            if (this.listTable1.Items.Count > 0)
            {
                this.btn_Add.Enabled = true;
                this.btn_Addlist.Enabled = true;
            }
            else
            {
                this.btn_Add.Enabled = false;
                this.btn_Addlist.Enabled = false;
            }
            if (this.listTable2.Items.Count > 0)
            {
                this.btn_Del.Enabled = true;
                this.btn_Dellist.Enabled = true;
                this.btn_Creat.Enabled = true;
            }
            else
            {
                this.btn_Del.Enabled = false;
                this.btn_Dellist.Enabled = false;
                this.btn_Creat.Enabled = false;
            }
        }

        private void listTable1_DoubleClick(object sender, EventArgs e)
        {
            if (this.listTable1.SelectedItem != null)
            {
                this.listTable2.Items.Add(this.listTable1.SelectedItem);
                this.listTable1.Items.Remove(this.listTable1.SelectedItem);
                this.IsHasItem();
            }
        }

        private void listTable2_DoubleClick(object sender, EventArgs e)
        {
            if (this.listTable2.SelectedItem != null)
            {
                this.listTable1.Items.Add(this.listTable2.SelectedItem);
                this.listTable2.Items.Remove(this.listTable2.SelectedItem);
                this.IsHasItem();
            }
        }

        public void SetBtnDisable()
        {
            if (this.btn_Creat.InvokeRequired)
            {
                SetBtnDisableCallback method = new SetBtnDisableCallback(this.SetBtnDisable);
                base.Invoke(method, null);
            }
            else
            {
                this.btn_Creat.Enabled = false;
                this.btn_Cancle.Enabled = false;
            }
        }

        public void SetBtnEnable()
        {
            if (this.btn_Creat.InvokeRequired)
            {
                SetBtnEnableCallback method = new SetBtnEnableCallback(this.SetBtnEnable);
                base.Invoke(method, null);
            }
            else
            {
                this.btn_Creat.Enabled = true;
                this.btn_Cancle.Enabled = true;
            }
        }

        public void SetlblStatuText(string text)
        {
            if (this.labelNum.InvokeRequired)
            {
                SetlblStatuCallback method = new SetlblStatuCallback(this.SetlblStatuText);
                base.Invoke(method, new object[] { text });
            }
            else
            {
                this.labelNum.Text = text;
            }
        }

        public void SetprogressBar1Max(int val)
        {
            if (this.progressBar1.InvokeRequired)
            {
                SetProBar1MaxCallback method = new SetProBar1MaxCallback(this.SetprogressBar1Max);
                base.Invoke(method, new object[] { val });
            }
            else
            {
                this.progressBar1.Maximum = val;
            }
        }

        public void SetprogressBar1Val(int val)
        {
            if (this.progressBar1.InvokeRequired)
            {
                SetProBar1ValCallback method = new SetProBar1ValCallback(this.SetprogressBar1Val);
                base.Invoke(method, new object[] { val });
            }
            else
            {
                this.progressBar1.Value = val;
            }
        }

        private void ThreadWork()
        {
            try
            {
                this.SetBtnDisable();
                int count = this.listTable2.Items.Count;
                string text = this.txtTargetFolder.Text;
                this.SetprogressBar1Max(count);
                this.SetprogressBar1Val(1);
                this.SetlblStatuText("0");
                for (int i = 0; i < count; i++)
                {
                    string tablename = this.listTable2.Items[i].ToString();
                    this.dsb.Fieldlist = new List<ColumnInfo>();
                    this.dsb.CreateTabScript(this.DbName, tablename, text, this.progressBar2);
                    this.SetprogressBar1Val(i + 1);
                    this.SetlblStatuText((i + 1).ToString());
                }
                this.SetBtnEnable();
                MessageBox.Show("脚本全部生成成功！", "完成", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
            }
            catch (Exception exception)
            {
                LogInfo.WriteLog(exception);
                this.SetBtnEnable();
                MessageBox.Show("脚本生成失败！请检查表名是否规范或其他问题导致。(" + exception.Message + ")", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
            }
        }

        private delegate void SetBtnDisableCallback();

        private delegate void SetBtnEnableCallback();

        private delegate void SetlblStatuCallback(string text);

        private delegate void SetProBar1MaxCallback(int val);

        private delegate void SetProBar1ValCallback(int val);
    }
}