public WebTags(_DbHelper c) { conn = c; SettingData setData = new SettingData(conn); this._setting = setData.GetSetting(); this._theme = setData.GetTheme; }
/// <summary> /// 取得配置 /// </summary> /// <returns>配置信息对象</returns> public SettingItem GetSetting() { SettingItem item = new SettingItem(); using (IDataReader reader = conn.ExecuteReader("SELECT [Name], [URL], [ICP], [Language], [Intro], [Keywords], [Affiche], [Filter], [UploadExt], [Mail], [MailFrom], [MailHost], [MailPort], [MailUID], [MailPWD], [WatermarkSeat], [ParArticleNum], [ParCommentNum], [ParAppendFineArticleNum], [ParAppendRandomArticleNum], [ParAppendHotArticleNum], [ParAppendHotTagNum], [ParAppendNewCommentNum], [RssNum], [RssMode], [WatermarkPath], [Key] FROM [Setting]", 1)) { while (reader.Read()) { //主干配置部分 item.Basic.Name = reader.GetString(0); item.Basic.URL = reader.GetString(1); item.Basic.ICP = reader.GetString(2); item.Basic.Language = reader.GetString(3); item.Basic.Intro = reader.GetString(4); item.Basic.Keywords = reader.GetString(5); item.Basic.Affiche = reader.GetString(6); item.Basic.Filter = reader.GetString(7); item.Basic.UploadExt = reader.GetString(8); item.Basic.Mail = reader.GetString(9); item.Basic.MailFrom = reader.GetString(10); item.Basic.MailHost = reader.GetString(11); item.Basic.MailPort = reader.GetInt32(12); item.Basic.MailUserID = reader.GetString(13); item.Basic.MailPassword = reader.GetString(14); //参数部分 item.Parameter.WatermarkSeat = reader.GetInt32(15); item.Parameter.ArticleNum = reader.GetInt32(16); item.Parameter.CommentNum = reader.GetInt32(17); item.Parameter.AppendFineArticleNum = reader.GetInt32(18); item.Parameter.AppendRandomArticleNum = reader.GetInt32(19); item.Parameter.AppendHotArticleNum = reader.GetInt32(20); item.Parameter.AppendHotTagNum = reader.GetInt32(21); item.Parameter.AppendNewCommentNum = reader.GetInt32(22); item.Parameter.RssNum = reader.GetInt32(23); item.Parameter.RssMode = reader.GetInt32(24); item.Parameter.WatermarkPath = reader.GetString(25); item.Parameter.Key = reader.GetString(26); } } return item; }