示例#1
0
        /// <summary>
        /// '表和视图列表框'的选择改变事件.
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void clbTablesAndView_SelectedIndexChanged(object sender, EventArgs e)
        {
            string name = this.clbTablesAndView
                          .Items[this.clbTablesAndView.SelectedIndex].ToString();
            string tabName = this.GetTableOrViewName(name);

            if (name.StartsWith("@"))
            {
                this.lblTabStructure.Text = "视图" + tabName + "相关实体类结构:";
            }
            else
            {
                this.lblTabStructure.Text = "表" + tabName + "相关实体类结构:";
            }
            if (!this._clasInfo.Contains(tabName))
            {
                DataTable tabStructure = null;
                ConnectOracle.OpenConnection();
                tabStructure = ConnectOracle.ConvertTableOrViewStructure
                                   (ConnectOracle.GetTableOrViewStructure(tabName));
                ConnectOracle.CloseConnection();
                this._clasInfo.Add(tabName, tabStructure);
                DataTable tabNameDt = ConnectOracle.GetDataTable(String.Format(@"select COMMENTS from user_tab_comments WHERE TABLE_NAME = '{0}'", tabName));
                if (tabNameDt.Rows.Count > 0)
                {
                    this._clasRemarkInfo.Add(tabName, tabNameDt.Rows[0]["COMMENTS"].ToString());
                }
                else
                {
                    this._clasRemarkInfo.Add(tabName, "");
                }
            }
            DataTable data = (DataTable)this._clasInfo[tabName];

            this.dgvTableOrViewStructure.DataSource = data;

            //决定是否保存类注释.
            if (this._saveClassRemark)
            {
                this._clasRemarkInfo[this._tabName] = this.txtTabControlOneClassRemark.Text;
                this._saveClassRemark = false;
            }

            //决定是否保存字段注释.
            if (this._saveFieldRemark)
            {
                DataTable data2 = (DataTable)this._clasInfo[this._tabName2];
                data2.Rows[this._index][2] = this.txtTabControlOneFieldInfo.Text;
                this._saveFieldRemark      = false;
            }

            this.txtTabControlOneClassRemark.Text = this._clasRemarkInfo[tabName].ToString();
            int index = this.dgvTableOrViewStructure.CurrentRow.Index;

            if (data.Rows.Count > 0)
            {
                this.txtTabControlOneFieldInfo.Text = data.Rows[index][2].ToString();
            }

            //更改类注释标签文本.
            string className = GeneratorTool.CapFirstLetter(tabName)
                               + ToolSetting.Postfix;

            this.lblClassRemark.Text = className + "类注释:";
        }
示例#2
0
        /// <summary>
        /// Oracle'连接数据库'按钮的事件处理.
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnOracleConnectDb_Click(object sender, EventArgs e)
        {
            string server = this.txtOracleServer.Text.Trim();
            string uid    = this.txtOracleUserID.Text.Trim();
            string pwd    = this.txtOraclePwd.Text.Trim();

            //ToolSetting.Language = ".Net";
            //ToolSetting.Postfix = this.txtDotNetPostfix.Text.Trim();

            //ToolSetting.TabSize = Convert.ToInt32(this.txtTabSize.Text.Trim());
            //ToolSetting.SavePath = this.txtSavePath.Text.Trim();
            //ToolSetting.References = ToolSetting.FormatStringArray(
            //        Regex.Split(this.rtbReferencesList.Text.Trim(), "\n+", RegexOptions.None));
            //ToolSetting.OracleDataMapping = (DataTable)this.dgvOracleMapping.DataSource;
            ToolSetting.ServiceName  = server;
            ToolSetting.UserName     = uid;
            ToolSetting.UserPassWord = pwd;

            /*
             * 保存用户设置信息
             * ***/
            ToolSetting.SaveUserSetting();
            //得到数据库参数.


            //相关验证.
            if (server.Equals("") || uid.Equals(""))
            {
                MessageBox.Show("服务名和用户名均不能为空!"
                                , "警告"
                                , MessageBoxButtons.OK
                                , MessageBoxIcon.Warning);
                return;
            }

            //得到连接字符串.
            string conStr = ConnectOracle.GetConnectionStr(server, uid, pwd);

            //访问数据库.
            ConnectOracle.OpenConnection(conStr);
            DataTable tabs = ConnectOracle.GetAllTableAndViewName();

            ConnectOracle.CloseConnection();

            //必要的验证.
            if (tabs == null)
            {
                return;
            }

            //得到所有表和视图的结构信息.
            //this.GetOracleTablesStructure(tabs);

            //显示所有的表和视图的名称.
            if (tabs != null)
            {
                this.clbTablesAndView.Items.Clear();
                for (int i = 0; i < tabs.Rows.Count; i++)
                {
                    string type = tabs.Rows[i][1].ToString().Trim().ToUpper();
                    string temp = null;
                    if (type.Equals("VIEW"))
                    {
                        temp = "@ ";
                    }
                    else
                    {
                        temp = "";
                    }
                    this.clbTablesAndView.Items
                    .Add(temp + tabs.Rows[i][0].ToString(), false);
                }
            }

            //显示第一个表或视图的结构信息.
            if (this.clbTablesAndView.Items.Count > 0)
            {
                this.clbTablesAndView.SelectedIndex = 0;
                string tabName = this.GetTableOrViewName
                                     (this.clbTablesAndView.Items[0].ToString());
                this.lblTabStructure.Text = "表" + tabName + "相关实体类结构:";
                this.FormatDgvTableStructure();
            }
            this.lblTabList.Text = "Oracle表/视图:";
        }