Exemplo n.º 1
0
        private ISqlGen GetSQLProvider(string database)
        {
            var setting = ConfigurationManager.ConnectionStrings[database];

            if (setting == null)
            {
                throw new Exception("数据库连接未在web.config中配置!");
            }

            var SQLProvider = GenTables.GetGenProvider(setting.ProviderName);

            return(SQLProvider);
        }
Exemplo n.º 2
0
        public void Generate(string tableName)
        {
            this.CurrentTable = GenTables.GetTables(tableName, this.DbType, this.ConnectionString);

            var sModel = GenModel();
            var sIDAL  = GenIDAL();
            var sDAL   = GenDAL();
            var sIBLL  = GenIBLL();
            var sBLL   = GenBLL();

            string sPathModel = OutputPath + "\\Model";
            string sPathIDAL  = OutputPath + "\\IDAL";
            string sPathDAL   = OutputPath + "\\DAL";
            string sPathIBLL  = OutputPath + "\\IBLL";
            string sPathBLL   = OutputPath + "\\BLL";

            if (!Directory.Exists(sPathModel))
            {
                Directory.CreateDirectory(sPathModel);
            }
            if (!Directory.Exists(sPathIDAL))
            {
                Directory.CreateDirectory(sPathIDAL);
            }
            if (!Directory.Exists(sPathDAL))
            {
                Directory.CreateDirectory(sPathDAL);
            }
            if (!Directory.Exists(sPathIBLL))
            {
                Directory.CreateDirectory(sPathIBLL);
            }
            if (!Directory.Exists(sPathBLL))
            {
                Directory.CreateDirectory(sPathBLL);
            }

            //输出到文件中 model
            CreateFile(String.Format("{0}\\{1}.cs", sPathModel, this.CurrentTable.TableName), sModel);
            //输出到文件中 idal
            CreateFile(String.Format("{0}\\IDAL_{1}.cs", sPathIDAL, this.CurrentTable.TableName), sIDAL);
            //输出到文件中 dal
            CreateFile(String.Format("{0}\\DAL_{1}.cs", sPathDAL, this.CurrentTable.TableName), sDAL);
            //输出到文件中 ibll
            CreateFile(String.Format("{0}\\IBLL_{1}.cs", sPathIBLL, this.CurrentTable.TableName), sIBLL);
            //输出到文件中 bll
            CreateFile(String.Format("{0}\\BLL_{1}.cs", sPathBLL, this.CurrentTable.TableName), sBLL);
        }
Exemplo n.º 3
0
        private void btnJoin_Click(object sender, RoutedEventArgs e)
        {
            var provider = this.cbDbType.SelectionBoxItem;

            if (provider == null || string.IsNullOrEmpty(provider.ToString()))
            {
                return;
            }
            lastProvider   = provider.ToString();
            lastConnection = this.txtConnString.Text.Trim();

            this.btnJoin.IsEnabled = false;
            Task.Run(() =>
            {
                try
                {
                    _tables = GenTables.GetTables(this.lastProvider, this.lastConnection);
                }
                catch (Exception ex)
                {
                    this.lableStatus.Dispatcher.Invoke(() =>
                    {
                        this.lableStatus.Content = ex.Message;
                    });
                }
                finally
                {
                    this.btnJoin.Dispatcher.Invoke(() =>
                    {
                        this.btnJoin.IsEnabled = true;
                    });
                    if (_tables != null)
                    {
                        this.tableTreeView.Dispatcher.Invoke(() =>
                        {
                            this.tableTreeView.ItemsSource = _tables;
                        });
                    }
                }
            });
        }
Exemplo n.º 4
0
        /// <summary>
        /// 链接数据库
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnConnect_Click(object sender, EventArgs e)
        {
            lastProvider   = dbType.Text.Trim();
            lastConnection = ConString.Text.Trim();

            if (providers.IndexOf(lastProvider) < 0)
            {
                providers.Add(lastProvider);
            }

            if (connections.IndexOf(lastConnection) < 0)
            {
                connections.Add(lastConnection);
            }

            //var Tables = GenTables.GetTables(dbType.Text, ConString.Text);
            var Tables     = GenTables.GetTables(dbType.Text);
            var ParentNode = new TreeNode {
                Text = RootNodeText, Tag = RootNodeTag
            };

            foreach (var T in Tables)
            {
                var TN = new TreeNode {
                    Text = T.TableName, Tag = T, ForeColor = Color.Blue
                };
                foreach (var TS in T.TableSchemas)
                {
                    var TN2 = new TreeNode {
                        Text = string.Format("{0}[{1}]", TS.ColumnName, TS.SqlTypeName), Tag = TS
                    };
                    TN.Nodes.Add(TN2);
                }
                ParentNode.Nodes.Add(TN);
            }

            this.TableTreeView.Nodes.Clear();
            this.TableTreeView.Nodes.Add(ParentNode);
            this.TableTreeView.Nodes[0].Expand();
        }