Ejemplo n.º 1
0
        private void CreateCSFiles(int _dbtype = 1)
        {
            string _tableViewShowStr = string.Empty;

            if (_dbtype == 1)
            {
                _tableViewShowStr = "表";
            }
            if (_dbtype == 2)
            {
                _tableViewShowStr = "视图";
            }
            if (_CurrentSelectNode == null)
            {
                MsgBox.Infor("请先选中需要生成的'" + _tableViewShowStr + "'节点");
                return;
            }
            DevExpress.XtraTreeList.Nodes.TreeListNode _ParantNode = _CurrentSelectNode.ParentNode;
            if (_ParantNode == null)
            {
                MsgBox.Warning("'" + _tableViewShowStr + "'节点无父节点....");
                return;
            }
            DbLoginFor _DbLoginFor = _ParantNode.Tag as DbLoginFor;

            if (_DbLoginFor == null)
            {
                MsgBox.Warning("'" + _tableViewShowStr + "'节点的连接信息错误....");
                return;
            }
            if (this.comboBox1.SelectedIndex == 0)
            {
                MsgBox.Warning("您选中的模板有问题,请前去确认.......");
                return;
            }
            CodeTemplet __CodeTemplet = this.comboBox1.SelectedItem as CodeTemplet;

            if (null == __CodeTemplet)
            {
                MsgBox.Warning("您选中的模板有问题,请前去确认.......");
                return;
            }
            string _FolderName = DialogUnitity.DialogFolderBrowser();

            if (string.IsNullOrEmpty(_FolderName.Trim()))
            {
                MsgBox.Infor("没有您选中的文件夹....");
                return;
            }

            string _Conn = _DbLoginFor.ConnString;

            CreateCSFileOneByOne(_DbLoginFor, __CodeTemplet, _FolderName, _dbtype);
            MsgBox.Infor("文件保存完成....");
        }
Ejemplo n.º 2
0
        private void CreateColumInfoToWord(DbLoginFor _DbLoginFor, bool _isTable = true)
        {
            IFrameWorkDb _IFrameWorkDb = null;

            _IFrameWorkDb = FrameWorkDbFactory.CreateNewFrameWorkDb(_DbLoginFor.ConnString, _DbLoginFor.Db_Type);
            if (_IFrameWorkDb == null)
            {
                MsgBox.Warning("您选中的表或者视图节点数据类型存在问题,请前去确认.......");
                return;
            }

            List <DbTableInfo> _tableList = _IFrameWorkDb.GetTables();//获取所的表

            Document        doc       = new Document();
            DocumentBuilder builder   = new DocumentBuilder(doc);
            bool            _isSqlite = _DbLoginFor.Db_Type == 1 ? true : false;

            if (_isTable)//生成表的数据字典
            {
                CreateCellStyle(builder);
                for (int i = 0; i < _tableList.Count; i++)
                {
                    CreateTitleCell(builder, _tableList[i].Name);
                    List <ColumnInfo> _columList = _IFrameWorkDb.GetColumsFromTable(_tableList[i].Name);
                    CreateCell(builder, _columList, _isSqlite);
                }
            }
            else//生成视图的数据字典
            {
                //下面加载视图
                List <DbTableInfo> _viewList = _IFrameWorkDb.GetViews();//获取所有的视图
                CreateCellStyle(builder);
                for (int i = 0; i < _viewList.Count; i++)
                {
                    CreateTitleCell(builder, _tableList[i].Name, 2);
                    //获取视图的每列信息
                    List <ColumnInfo> _columList = _IFrameWorkDb.GetColumsFromView(_viewList[i].Name);
                    CreateCell(builder, _columList, _isSqlite);
                }
            }

            string _name = DialogUnitity.DialogSaveWordFile(ConstKeyUnitity.CAPTIONTEXT);

            if (string.IsNullOrEmpty(_name))
            {
                MsgBox.Warning("保存文件名不可以为空...");
                return;
            }
            doc.Save(_name);
            MsgBox.Infor("数据字典导出完成....");
        }
Ejemplo n.º 3
0
        private void simpleButton3_Click(object sender, EventArgs e)
        {
            string _FileName = DialogUnitity.DialogFolderBrowser();

            if (string.IsNullOrEmpty(_FileName.Trim()))
            {
                MsgBox.Infor("没有您选中的文件夹....");
                return;
            }
            _FileName += @"\" + _CodeClassPref + _CodeClassName + ".cs";
            FileUnitity.StringToNewFile(_FileName, this.fastColoredTextBox1.Text, System.Text.Encoding.UTF8);

            MsgBox.Infor("文件保存完成....");
        }
Ejemplo n.º 4
0
        private void simpleButton2_Click(object sender, EventArgs e)
        {
            string fileName = DialogUnitity.DialogTextFile(ConstKeyUnitity.CAPTIONTEXT);

            if (string.IsNullOrEmpty(fileName))
            {
                MsgBox.Infor("未选中文件.....");
                return;
            }
            if (!FileUnitity.FileExist(fileName))
            {
                MsgBox.Warning("你选择的文件不存在....");
                return;
            }
            this.fastColoredTextBox1.Text = FileUnitity.FileToString(fileName);
            SaveFunctionText();
        }