dataacess.cs

Symbol_MC3000_C#.条码扫码范例程序之2

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlServerCe;

namespace Fyfjm.Logic
{
    class DataAcess
    {
        private static SqlCeConnection _objConn = null;

        public static SqlCeConnection CreateConnection() //创建连接
        {
            if (_objConn == null)
            {
                _objConn = new SqlCeConnection("DataSource=" + WoodDirectory.GetCurPath() + @"\DataBase\Fyfjm.sdf");
                _objConn.Open();
            }
            else if (_objConn.State != System.Data.ConnectionState.Open)
            {
                _objConn.Open();
            }
            return _objConn;
        }

        public static void Close() //关闭连接
        {
            if (_objConn != null)
            {
                _objConn.Close();
                _objConn.Dispose();
                _objConn = null;
            }
        }

        internal static SqlCeConnection CreateConnection(string p)
        {
            throw new Exception("The method or operation is not implemented.");
        }
    }

    public static class WoodDirectory // 获取路径
    {
        public static string GetCurPath()
        {
            String CodePath = System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase;

            CodePath = CodePath.Substring(0, CodePath.LastIndexOf(@"\"));

            return CodePath;
        }
    }
}