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; }