当前位置: 首页>>代码示例>>C#>>正文


C# Generator.GenerateTableInsert方法代码示例

本文整理汇总了C#中Generator.GenerateTableInsert方法的典型用法代码示例。如果您正苦于以下问题:C# Generator.GenerateTableInsert方法的具体用法?C# Generator.GenerateTableInsert怎么用?C# Generator.GenerateTableInsert使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在Generator的用法示例。


在下文中一共展示了Generator.GenerateTableInsert方法的2个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。

示例1: item_Click

        void item_Click(object sender, EventArgs e)
        {

            ToolStripMenuItem item = (ToolStripMenuItem)sender;

            string fileName = string.Empty;

            Action action = (Action)item.OwnerItem.Tag;
            Output output = (Output)item.Tag;
            try
            {
                string connectionString = Helper.FixConnectionString(this.Parent.Connection.ConnectionString, this.Parent.Connection.ConnectionTimeout);
                
                using (IRepository repository = new DBRepository(connectionString))
                {
                    var generator = new Generator(repository);

                    using (ImportOptions imo = new ImportOptions(this.Parent.Name))
                    {
                        imo.SampleHeader = generator.GenerateTableColumns(this.Parent.Name);
                        imo.Separator = System.Globalization.CultureInfo.CurrentCulture.TextInfo.ListSeparator.ToCharArray()[0];
                        
                        if (imo.ShowDialog() == DialogResult.OK)
                        {
                            switch (output)
                            {
                                case Output.Editor:
                                    // create new document
                                    ServiceCache.ScriptFactory.CreateNewBlankScript(Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ScriptType.SqlCe);
                                    break;
                                case Output.File:
                                    SaveFileDialog fd = new SaveFileDialog();
                                    fd.AutoUpgradeEnabled = true;
                                    fd.Title = "Save generated database script as";
                                    fd.Filter = "SQL Server Compact Script (*.sqlce)|*.sqlce|SQL Server Script (*.sql)|*.sql|All Files(*.*)|";
                                    fd.OverwritePrompt = true;
                                    fd.ValidateNames = true;
                                    if (fd.ShowDialog() == DialogResult.OK)
                                    {
                                        fileName = fd.FileName;
                                    }
                                    break;
                                default:
                                    break;
                            }

                            switch (action)
                            {
                                case Action.Csv:
                                    using (var reader = new CsvReader(imo.FileName))
                                    {
                                        reader.ValueSeparator = imo.Separator;
                                        HeaderRecord hr = reader.ReadHeaderRecord();
                                        if (generator.ValidColumns(this.Parent.Name, hr.Values))
                                        {
                                            foreach (DataRecord record in reader.DataRecords)
                                            {
                                                generator.GenerateTableInsert(this.Parent.Name, hr.Values, record.Values);
                                            }
                                        }
                                    }                                
                                    break;
                                default:
                                    break;
                            }
                            switch (output)
                            {
                                case Output.Editor:
                                    // insert SQL script to document
                                    EnvDTE.TextDocument doc = (EnvDTE.TextDocument)ServiceCache.ExtensibilityModel.Application.ActiveDocument.Object(null);
                                    doc.EndPoint.CreateEditPoint().Insert(generator.GeneratedScript);
                                    doc.DTE.ActiveDocument.Saved = true;
                                    break;
                                case Output.File:
                                    if (!string.IsNullOrEmpty(fileName))
                                    {
                                        System.IO.File.WriteAllText(fileName, generator.GeneratedScript);
                                    }
                                    break;
                                case Output.Clipboard:
                                    Clipboard.Clear();
                                    Clipboard.SetText(generator.GeneratedScript, TextDataFormat.UnicodeText);
                                    break;
                                default:
                                    break;
                            }
                        }
                    }
                }

            }

            catch (System.Data.SqlServerCe.SqlCeException sqlCe)
            {
                Connect.ShowErrors(sqlCe);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
//.........这里部分代码省略.........
开发者ID:herohut,项目名称:elab,代码行数:101,代码来源:ImportTableMenuItem.cs

示例2: item_Click

        void item_Click(object sender, EventArgs e)
        {
            ToolStripMenuItem item = (ToolStripMenuItem)sender;

            string fileName = string.Empty;

            Action action = (Action)item.OwnerItem.Tag;
            Output output = (Output)item.Tag;

            try
            {
                string connectionString = Helper.FixConnectionString(this.Parent.Connection.ConnectionString, this.Parent.Connection.ConnectionTimeout);
                using (IRepository repository = new DBRepository(connectionString))
                {
                    var generator = new Generator(repository);

                    switch (output)
                    {
                        case Output.Editor:
                            // create new document
                            ServiceCache.ScriptFactory.CreateNewBlankScript(Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ScriptType.SqlCe);
                            break;
                        case Output.File:
                            SaveFileDialog fd = new SaveFileDialog();
                            fd.AutoUpgradeEnabled = true;
                            fd.Title = "Save generated database script as";
                            fd.Filter = "SQL Server Compact Script (*.sqlce)|*.sqlce|SQL Server Script (*.sql)|*.sql|All Files(*.*)|";
                            fd.OverwritePrompt = true;
                            fd.ValidateNames = true;
                            if (fd.ShowDialog() == DialogResult.OK)
                            {
                                fileName = fd.FileName;
                            }
                            break;
                        default:
                            break;
                    }

                    switch (action)
                    {
                        case Action.Create:
                            generator.GenerateTableScript(this.Parent.Name);
                            break;
                        case Action.Drop:
                            generator.GenerateTableDrop(this.Parent.Name);
                            break;
                        case Action.DropAndCreate:
                            generator.GenerateTableDrop(this.Parent.Name);
                            generator.GenerateTableScript(this.Parent.Name);
                            break;
                        case Action.Select:
                            generator.GenerateTableSelect(this.Parent.Name);
                            break;
                        case Action.Insert:
                            generator.GenerateTableInsert(this.Parent.Name);
                            break;
                        case Action.Update:
                            generator.GenerateTableUpdate(this.Parent.Name);
                            break;
                        case Action.Delete:
                            generator.GenerateTableDelete(this.Parent.Name);
                            break;
                        case Action.Data:
                            generator.GenerateTableData(this.Parent.Name, false);
                            break;
                        default:
                            break;
                    }
                    switch (output)
                    {
                        case Output.Editor:
                            // insert SQL script to document
                            EnvDTE.TextDocument doc = (EnvDTE.TextDocument)ServiceCache.ExtensibilityModel.Application.ActiveDocument.Object(null);
                            doc.EndPoint.CreateEditPoint().Insert(generator.GeneratedScript);
                            doc.DTE.ActiveDocument.Saved = true;
                            break;
                        case Output.File:
                            if (!string.IsNullOrEmpty(fileName))
                            {
                                System.IO.File.WriteAllText(fileName, generator.GeneratedScript);
                            }
                            break;
                        case Output.Clipboard:
                            Clipboard.Clear();
                            Clipboard.SetText(generator.GeneratedScript, TextDataFormat.UnicodeText);
                            break;
                        default:
                            break;
                    }
                }

            }
            catch (System.Data.SqlServerCe.SqlCeException sqlCe)
            {
                Connect.ShowErrors(sqlCe);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
//.........这里部分代码省略.........
开发者ID:inickvel,项目名称:SqlCeToolbox,代码行数:101,代码来源:ScriptTableMenuItem.cs


注:本文中的Generator.GenerateTableInsert方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。