/// <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();
}
