MainWindow.xaml.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.CodeDom.Compiler;
using System.ComponentModel;
using System.Diagnostics;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Input;
using System.Windows.Markup;
using System.Windows.Media;
using ICSharpCode.AvalonEdit;
using ICSharpCode.AvalonEdit.Highlighting;
using System.Xml.Linq;
using System.Data;
using System.Text;
using System.Data.SqlClient;
/// <summary>
/// 文件名:MainWindow.xaml 的交互逻辑
/// 文件功能描述:主界实现根据数据库表生成插入语句
/// 版权所有:Create Family Wealth © Copyright 2011 .All Rights Reserved.
/// 创建标识:2013.08.02
/// </summary>
namespace SqlInsert
{
    /// <summary>
    /// MainWindow.xaml 的交互逻辑
    /// </summary>
    public partial class MainWindow : Window
    {
        private const string ConStr = "Data Source={0};Initial Catalog={1};uid={2};pwd={3};";
        private readonly string path = System.AppDomain.CurrentDomain.BaseDirectory + @"connstring.xml";
        private string cmdStr = "select * from {0}";
        public string ConnectionString
        {
            get
            {
                return string.Format(ConStr, txt_DbName.Text, txt_server.Text, txt_UId.Text,
                                                 txt_Pwd.Text);
            }
            private set { throw new NotImplementedException(); }
        }

        private readonly SQLHelper helper = new SQLHelper();
        private XDocument _doc;
        public XDocument Doc
        {
            get
            {
                if (_doc == null)
                    _doc = XDocument.Load(path);
                return _doc;
            }
        }

        private XElement ConfigNode
        {
            get
            {
                return Doc.Root;
            }
        }