Sunji-posv-net/pos/POSV.WindowsServiceManager/Program.cs

using System;
using System.Collections.Generic;
using System.Data.SQLite;
using System.IO;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace POSV.WindowsServiceManager
{
    class Program
    {
        /// <summary>
        /// 应用程序的主入口点。
        /// </summary>
        [STAThread]
        static void Main(string[] args)
        {
            Application.EnableVisualStyles();
            Application.EnableVisualStyles();
            //数据库去密码
            try
            {
                ChangePwd("");
                NLog.LogManager.GetCurrentClassLogger().Info("sqliteNoP success");
            }
            catch (Exception)
            {
                NLog.LogManager.GetCurrentClassLogger().Info("sqliteNoP error, already success!");
            }
            Application.Run(new MainForm());
        }

        public static void ChangePwd(string pwd)
        {
            SQLiteConnectionStringBuilder builder = new SQLiteConnectionStringBuilder();
            builder.DataSource = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, @"data\msc.s3db");
            builder.Password = "passwd";
            builder.Version = 3;
            builder.CacheSize = 10000;
            builder.DefaultTimeout = 5000;
            builder.PageSize = 4096;
            builder.FailIfMissing = true;
            builder.Pooling = true;
            builder.DefaultIsolationLevel = System.Data.IsolationLevel.ReadCommitted;
            builder.SyncMode = SynchronizationModes.Off;
            builder.JournalMode = SQLiteJournalModeEnum.Truncate;
            builder.UseUTF16Encoding = false;

            using (SQLiteConnection connection = new SQLiteConnection(builder.ToString()))
            {
                try
                {
                    connection.Open();
                    connection.ChangePassword(pwd);
                }
                catch (SQLiteException ex)
                {
                    throw new Exception(ex.Message);
                }
                finally
                {
                    connection.Close();
                }
            }
        }
    }
}