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("文件保存完成...."); }
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("数据字典导出完成...."); }
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("文件保存完成...."); }
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(); }