Models/SQLiteHelper.cs

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

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SQLite;
using System.IO;
using System.Linq;
using System.Web;

namespace XXX公司积分评比系统.Models
{
      /// <summary>
      /// 访问 SQLite文件的基类
      /// </summary>
        public class SQLiteHelper
        {

            //创建数据库文件
            public static void CreateDBFile(string fileName)
            {
                string path = System.Environment.CurrentDirectory + @"/Data/";
                if (!Directory.Exists(path))
                {
                    Directory.CreateDirectory(path);
                }
                string databaseFileName = path + fileName;
                if (!File.Exists(databaseFileName))
                {
                    SQLiteConnection.CreateFile(databaseFileName);
                }
            }

            //生成连接字符串
            private static string CreateConnectionString()
            {
                //SQLiteConnectionStringBuilder connectionString = new SQLiteConnectionStringBuilder();
                //var dir = System.IO.Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "App_Data");

                ////connectionString.DataSource = @"data/ScriptHelper.db";
                //connectionString.DataSource = dir + "\\" + "kpdb.db;Version=3;";
                //string conStr = connectionString.ToString();
                string conStr = System.Configuration.ConfigurationManager.ConnectionStrings["sqlite"].ConnectionString;
                return conStr;
            }

            /// <summary>
            /// 对插入到数据库中的空值进行处理
            /// </summary>
            /// <param name="value"></param>
            /// <returns></returns>
            public static object ToDbValue(object value)
            {
                if (value == null)
                {
                    return DBNull.Value;
                }
                else
                {
                    return value;
                }
            }