dataaccess.cs

来自「Symbol_MC3000_C#.条码扫码范例程序之2」· CS 代码 · 共 66 行

using System;
using System.Collections.Generic;
using System.Text;

using System.Data.SqlServerCe;

namespace Fyfjm
{
    public static class DataAccess
    {
        private static SqlCeConnection Conn = null;

        public static SqlCeConnection CreateConnection(string strConn)
        {
            if (Conn == null)
            {
                Conn = new SqlCeConnection(@"DataSource=" + strConn);
                Conn.Open();
            }
            else if (Conn.State != System.Data.ConnectionState.Open)
            {
                Conn.Open();
            }

            return Conn;
        }

        public static void Open()
        {
            if (Conn.State != System.Data.ConnectionState.Open)
            {
                Conn.Open();
            }
        }

        public static void Close()
        {
            if (Conn != null)
            {
                Conn.Close();
                Conn.Dispose();
                Conn = null;
            }
        }

        public static void Dispose()
        {
            if (Conn != null)
            {
                Conn.Close();
                Conn.Dispose();
                Conn = null;
            }
        }

        public static void DisConnection()
        {
            if (Conn != null && Conn.State != System.Data.ConnectionState.Closed)
            {
                Conn.Close();
            }
        }
    }
}