newprojectdb.cs

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

            base.Icon = (Icon) manager.GetObject("$this.Icon");
            base.MaximizeBox = false;
            base.MinimizeBox = false;
            base.Name = "NewProjectDB";
            base.ShowIcon = false;
            base.StartPosition = FormStartPosition.CenterScreen;
            this.Text = "选择要生成的数据表，输出代码文件";
            base.TopMost = true;
            base.Load += new EventHandler(this.NewProjectDB_Load);
            this.groupBox2.ResumeLayout(false);
            this.groupBox1.ResumeLayout(false);
            this.groupBox1.PerformLayout();
            this.groupBox4.ResumeLayout(false);
            this.groupBox4.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_Export.Enabled = true;
            }
            else
            {
                this.btn_Del.Enabled = false;
                this.btn_Dellist.Enabled = false;
                this.btn_Export.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();
            }
        }

        private void NewProjectDB_Load(object sender, EventArgs e)
        {
            string str5;
            string dbName = "master";
            string dbType = this.dbobj.DbType;
            if (dbType != null)
            {
                if (!(dbType == "SQL2000") && !(dbType == "SQL2005"))
                {
                    if ((dbType == "Oracle") || (dbType == "OleDb"))
                    {
                        dbName = this.dbset.DbName;
                    }
                    else if (dbType == "MySQL")
                    {
                        dbName = "mysql";
                    }
                }
                else
                {
                    dbName = "master";
                }
            }
            if ((this.dbset.DbName == "") || (this.dbset.DbName == dbName))
            {
                List<string> dBList = this.dbobj.GetDBList();
                if ((dBList != null) && (dBList.Count > 0))
                {
                    foreach (string str2 in dBList)
                    {
                        this.cmbDB.Items.Add(str2);
                    }
                }
            }
            else
            {
                this.cmbDB.Items.Add(this.dbset.DbName);
            }
            if (this.cmbDB.Items.Count > 0)
            {
                this.cmbDB.SelectedIndex = 0;
            }
            else
            {
                List<string> tables = this.dbobj.GetTables("");
                this.listTable1.Items.Clear();
                this.listTable2.Items.Clear();
                if (tables.Count > 0)
                {
                    foreach (string str3 in tables)
                    {
                        this.listTable1.Items.Add(str3);
                    }
                }
            }
            this.IsHasItem();
            this.btn_Export.Enabled = false;
            this.setting = ModuleConfig.GetSettings();
            this.cm_blltype = new DALTypeAddIn("LTP.IBuilder.IBuilderBLL");
            this.cm_blltype.Title = "BLL";
            this.groupBox5.Controls.Add(this.cm_blltype);
            this.cm_blltype.Location = new Point(30, 0x10);
            this.cm_blltype.SetSelectedDALType(this.setting.BLLType.Trim());
            this.cm_daltype = new DALTypeAddIn("LTP.IBuilder.IBuilderDAL");
            this.cm_daltype.Title = "DAL";
            this.groupBox5.Controls.Add(this.cm_daltype);
            this.cm_daltype.Location = new Point(30, 40);
            this.cm_daltype.SetSelectedDALType(this.setting.DALType);
            this.txtDbHelper.Text = this.setting.DbHelperName;
            if ((this.setting.DbHelperName == "DbHelperSQL") && ((str5 = this.dbobj.DbType) != null))
            {
                if (!(str5 == "SQL2000") && !(str5 == "SQL2005"))
                {
                    if (str5 == "Oracle")
                    {
                        this.txtDbHelper.Text = "DbHelperOra";
                    }
                    else if (str5 == "MySQL")
                    {
                        this.txtDbHelper.Text = "DbHelperMySQL";
                    }
                    else if (str5 == "OleDb")
                    {
                        this.txtDbHelper.Text = "DbHelperOleDb";
                    }
                }
                else
                {
                    this.txtDbHelper.Text = "DbHelperSQL";
                }
            }
            this.txtFolder.Text = this.setting.Folder;
            this.txtNamespace.Text = this.setting.Namepace;
        }

        private void ReplaceNamespace(string filename, string spacename)
        {
            StreamReader reader = new StreamReader(filename, Encoding.Default);
            string str = reader.ReadToEnd();
            reader.Close();
            str = str.Replace("<$$namespace$$>", spacename);
            StreamWriter writer = new StreamWriter(filename, false, Encoding.Default);
            writer.Write(str);
            writer.Flush();
            writer.Close();
        }

        private void ReplaceNamespaceProj(string filename, string spacename)
        {
            StreamReader reader = new StreamReader(filename, Encoding.Default);
            string str = reader.ReadToEnd();
            reader.Close();
            str = str.Replace("<AssemblyName>Maticsoft.", "<AssemblyName>" + spacename + ".").Replace("<RootNamespace>Maticsoft.", "<RootNamespace>" + spacename + ".");
            StreamWriter writer = new StreamWriter(filename, false, Encoding.Default);
            writer.Write(str);
            writer.Flush();
            writer.Close();
        }

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

        public void SetBtnEnable()
        {
            if (this.btn_Export.InvokeRequired)
            {
                SetBtnEnableCallback method = new SetBtnEnableCallback(this.SetBtnEnable);
                base.Invoke(method, null);
            }
            else
            {
                this.btn_Export.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()
        {
            this.SetBtnDisable();
            string str = this.txtNamespace.Text.Trim();
            string str2 = this.txtFolder.Text.Trim();
            int count = this.listTable2.Items.Count;
            this.SetprogressBar1Max(count);
            this.SetprogressBar1Val(1);
            this.SetlblStatuText("0");
            this.cb.DbName = this.dbname;
            if (str != "")
            {
                this.cb.NameSpace = str;
            }
            this.cb.Folder = str2;
            this.cb.ProcPrefix = this.setting.ProcPrefix;
            this.cb.DbHelperName = this.txtDbHelper.Text.Trim();
            for (int i = 0; i < count; i++)
            {
                string tableName = this.listTable2.Items[i].ToString();
                this.cb.TableName = tableName;
                this.cb.ModelName = tableName;
                string str4 = this.txtTabNamepre.Text.Trim();
                if ((str4 != "") && tableName.StartsWith(str4))
                {
                    this.cb.ModelName = tableName.Substring(str4.Length);
                }
                this.cb.ModelName = this.namerule.GetModelClass(this.cb.ModelName);
                this.cb.BLLName = this.namerule.GetBLLClass(this.cb.ModelName);
                this.cb.DALName = this.namerule.GetDALClass(this.cb.ModelName);
                DataTable keyName = this.dbobj.GetKeyName(this.dbname, tableName);
                List<LTP.CodeHelper.ColumnInfo> columnInfoList = this.dbobj.GetColumnInfoList(this.dbname, tableName);
                this.cb.Fieldlist = columnInfoList;
                this.cb.Keys = CodeCommon.GetColumnInfos(keyName);
                this.CreatCS();
                this.SetprogressBar1Val(i + 1);
                this.SetlblStatuText((i + 1).ToString());
            }
            this.SetBtnEnable();
            MessageBox.Show(this, "项目工程生成成功！", "完成", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
            new Process();
            Process.Start("explorer.exe", this.ProOutPath);
            base.Close();
        }

        private void WriteFile(string Filename, string strCode)
        {
            StreamWriter writer = new StreamWriter(Filename, false, Encoding.Default);
            writer.Write(strCode);
            writer.Flush();
            writer.Close();
        }

        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);
    }
}