/// <summary> /// 获取或设置是否需要创建表 /// </summary> public void CreateTable() { String dataDir = DataCenter.GetUserPath() + "\\data"; if (!CFileA.IsDirectoryExist(dataDir)) { CFileA.CreateDirectory(dataDir); } String dataBasePath = dataDir + "\\" + DATABASENAME; m_connectStr = "Data Source = " + dataBasePath; if (!CFileA.IsFileExist(dataBasePath)) { //创建数据库文件 SQLiteConnection.CreateFile(dataBasePath); //创建表 SQLiteConnection conn = new SQLiteConnection(m_connectStr); conn.Open(); SQLiteCommand cmd = conn.CreateCommand(); cmd.CommandText = CREATETABLESQL; cmd.ExecuteNonQuery(); conn.Close(); CreateDefaultProxyInfos(); } }
/// <summary> /// 创建用户状态服务 /// </summary> public UserCookieService() { String dataDir = DataCenter.GetUserPath() + "\\data"; if (!CFileA.IsDirectoryExist(dataDir)) { CFileA.CreateDirectory(dataDir); } String dataBasePath = DataCenter.GetUserPath() + "\\data\\usercookies.db"; m_connectStr = "Data Source = " + dataBasePath; if (!CFileA.IsFileExist(dataBasePath)) { CreateTable(); } }
/// <summary> /// 获取用户目录 /// </summary> /// <returns>用户目录</returns> public static String GetUserPath() { String userPath = Environment.GetEnvironmentVariable("LOCALAPPDATA"); if (!CFileA.IsDirectoryExist(userPath)) { userPath = GetAppPath(); } else { userPath += "\\KLine"; if (!CFileA.IsDirectoryExist(userPath)) { CFileA.CreateDirectory(userPath); } } return(userPath); }
/// <summary> /// 获取或设置是否需要创建表 /// </summary> public void CreateTable() { String dataBasePath = DataCenter.GetUserPath() + "\\data\\" + DATABASENAME; if (!CFileA.IsFileExist(dataBasePath)) { //创建数据库文件 SQLiteConnection.CreateFile(dataBasePath); } //创建表 SQLiteConnection conn = new SQLiteConnection(m_connectStr); conn.Open(); SQLiteCommand cmd = conn.CreateCommand(); cmd.CommandText = CREATETABLESQL; cmd.ExecuteNonQuery(); conn.Close(); }
/// <summary> /// 加载图标 /// </summary> private void LoadIcons() { String dir = DataCenter.GetAppPath() + "\\config\\icons\\"; m_gridIcons.ResourcePath = dir; List <String> files = new List <String>(); CFileA.GetFiles(dir, files); int filesSize = files.Count; int columnsSize = m_gridIcons.GetColumns().Count; m_gridIcons.BeginUpdate(); GridRow row = null; for (int i = 0; i < filesSize; i++) { int col = i; if (i >= columnsSize) { col = i % columnsSize; } if (col == 0) { row = new GridRow(); row.Height = 64; m_gridIcons.AddRow(row); } String file = files[i]; file = file.Substring(file.LastIndexOf('\\') + 1); GridIconCell iconCell = new GridIconCell(); iconCell.SetString(file); row.AddCell(col, iconCell); } m_gridIcons.EndUpdate(); m_gridIcons.Invalidate(); }