export/BLL/DBHelp.cs

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

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

using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.IO;
using export.Common;

using NPOI.HSSF.UserModel;
using NPOI.SS.UserModel;

namespace export.BLL
{
    /// <summary>
    ///     创建数据
    /// </summary>
    public class DBHelp
    {
        private string _connectionStr;

        private SqlConnection connection;

        private SqlCommand command;

        /// <summary>
        ///     初始化
        /// </summary>
        /// <param name="server"></param>
        /// <param name="database"></param>
        /// <param name="user"></param>
        /// <param name="pwd"></param>
        public DBHelp(string server, string database, string user, string pwd)
        {
            _connectionStr = SQLFormat.GetConnection(server, database, user, pwd);
        }

        /// <summary>
        ///     打开链接
        /// </summary>
        private void Open()
        {
            connection = new SqlConnection(_connectionStr);
            connection.Open();
        }

        /// <summary>
        ///     关闭
        /// </summary>
        private void Close()
        {
            if (connection.State == System.Data.ConnectionState.Open)
            {
                if (command != null)
                {
                    command.Dispose();
                }
                connection.Close();
                connection.Dispose();
            }
        }