示例#1
0
 public WebTags(_DbHelper c)
 {
     conn = c;
     SettingData setData = new SettingData(conn);
     this._setting = setData.GetSetting();
     this._theme = setData.GetTheme;
 }
示例#2
0
 /// <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;
 }