public ContentPanel()
{
InitializeComponent();
service = new cndroidService(GetDB());
CurrentConfig = service.GetConfig();
}
/// <summary>
/// 取得所有文章的名字
/// </summary>
/// <param name="cfgs"></param>
/// <returns></returns>
public AutoCompleteStringCollection GetAllName(PlugConfig cfg)
{
AutoCompleteStringCollection result = new AutoCompleteStringCollection();
List<string> names = new List<string>();
int preCount = result.Count;
SQLiteDataReader sdr = SqliteHelper.ExecuteReader(DB, "SELECT name FROM tree");
while (sdr.Read())
{
string name = SqliteHelper.DBToString(sdr[0]);
if (!string.IsNullOrEmpty(name))
names.Add(name);
}
sdr.Close();
cfg.ArticleNames = names;
result.AddRange(names.ToArray());
return result;
}
/// <summary>
/// 获取配置信息
/// </summary>
/// <returns></returns>
public PlugConfig GetConfig()
{
PlugConfig cfg = new PlugConfig();
SQLiteDataReader sdr = SqliteHelper.ExecuteReader(DB, "SELECT key,value FROM config");
while (sdr.Read())
{
string key = SqliteHelper.DBToString(sdr.GetString(0));
string value = SqliteHelper.DBToString(sdr.GetString(1));
if (string.IsNullOrEmpty(key) || string.IsNullOrEmpty(value))
continue;
switch (key)
{
case "Name":
cfg.Name = value;
break;
case "HtmlRoot":
cfg.HtmlRoot = value;
break;
case "Index":
cfg.Index = value;
break;
case "ServerDatabase":
cfg.ServerDatabase = value;
break;
}
}
sdr.Close();
return cfg;
}
/// <summary>
/// 获取所有文件
/// </summary>
/// <param name="cfg"></param>
/// <returns></returns>
public IDictionary<string, string> GetAllPath(PlugConfig cfg)
{
IDictionary<string, string> result = new Dictionary<string, string>();
SQLiteDataReader sdr = SqliteHelper.ExecuteReader(DB, "SELECT content_url,name FROM tree");
while (sdr.Read())
{
result.Add(SqliteHelper.DBToString(sdr.GetString(0)), SqliteHelper.DBToString(sdr.GetString(1)));
}
sdr.Close();
return result;
}
public UpdateContent(PlugConfig cfg)
{
this.cfg = cfg;
}
