protected void Page_Load(object sender, EventArgs e) { DbHelper.ResetDbProvider(); DbHelper.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + HttpContext.Current.Server.MapPath("~/App_Data/db.mdb"); DbHelper.Dbtype = "Access"; DataTable dt = DbHelper.ExecuteDataset(CommandType.Text, "SELECT * FROM i_news").Tables[0]; gvPreData.DataSource = dt; gvPreData.DataBind(); TinyCache cache = new TinyCache(); cache.AddObject("dt", dt, 0); }
/// <summary> /// ȡ����Ŀ�б� /// </summary> /// <returns></returns> public static List<ColumnInfo> GetColumnCollection() { List<ColumnInfo> coll; TinyCache cache = new TinyCache(); coll = cache.RetrieveObject("ColumnList") as List<ColumnInfo>; if (coll == null) { coll = new List<ColumnInfo>(); IDataReader reader = DatabaseProvider.GetInstance().GetArticleColumnList(); while (reader.Read()) { coll.Add(DataReader2ColumnInfo(reader)); } reader.Close(); cache.AddObject("ColumnList", coll, MainConfigs.GetConfig().Globalcachetimeout); } return coll; }
protected void btnStart_Click(object sender, EventArgs e) { DbHelper.ResetDbProvider(); DbHelper.ConnectionString = @"Data Source=D:\Documents\DotNet\CvsPlace\itca\LiteCMS.Web\config\db.config"; DbHelper.Dbtype = "Sqlite"; TinyCache cache = new TinyCache(); DataTable dt = cache.RetrieveObject("dt") as DataTable; foreach (DataRow dr in dt.Rows) { int newid = 23; int newaid = newid + Convert.ToInt32(dr["n_id"]); int cid; switch (dr["n_class"].ToString().Trim()) { case "Э������": cid = 2; break; case "У����": cid = 3; break; case "ҵ������": cid = 4; break; default: cid = 100; break; } DbParameter[] prams = { DbHelper.MakeInParam("@articleid", DbType.Int32, 4,newaid), DbHelper.MakeInParam("@title", DbType.String, 100,dr["n_title"]), DbHelper.MakeInParam("@columnid", DbType.Int32, 4,cid), DbHelper.MakeInParam("@content", DbType.String, 100,dr["n_content"]), DbHelper.MakeInParam("@postdate", DbType.DateTime, 8,dr["n_date"]), DbHelper.MakeInParam("@uid", DbType.Int32, 4,1), DbHelper.MakeInParam("@username", DbType.String, 20,dr["n_user"]) }; DbHelper.ExecuteNonQuery(CommandType.Text, "INSERT INTO wy_articles(articleid,columnid,title,uid,username,postdate,content) VALUES(@articleid,@columnid,@title,@uid,@username,@postdate,@content)", prams); } Response.Write("OK~"); }
protected override void Page_Show() { int pageid = 1; TinyCache cache = new TinyCache(); mainarticlelist = cache.RetrieveObject("articlelist_indexmain") as List<ArticleInfo>; if (mainarticlelist == null) { mainarticlelist = Articles.GetRecommendArticles(15, 1); cache.AddObject("articlelist_indexmain", mainarticlelist, config.Globalcachetimeout); } TinyCache cache_pagecount = new TinyCache(); object o_pagecount = cache_pagecount.RetrieveObject("pagecount_articlelist_indexmain"); if (o_pagecount != null) { pagecount = Convert.ToInt32(o_pagecount); } else { pagecount = Articles.GetRecommendArticleCollectionPageCount(15); cache.AddObject("pagecount_articlelist_indexmain", pagecount, config.Globalcachetimeout); } pagecounthtml = config.Urlrewrite == 1 ? Utils.GetStaticPageNumbersHtml(pageid, pagecount, "showcolumn-recommend", ".aspx", 8) : Utils.GetPageNumbersHtml(pageid, pagecount, "showcolumn.aspx?type=recommend", 8, "pageid", ""); }
private static void RemoveColumnListCache() { TinyCache cache = new TinyCache(); cache.RemoveObject("ColumnList"); }
void InitHotArticleList() { TinyCache cache = new TinyCache(); hotarticlelist = cache.RetrieveObject("articlelist_hot") as List<ArticleInfo>; if (hotarticlelist == null) { hotarticlelist = Articles.GetHotArticles(6, 1); cache.AddObject("articlelist_hot", hotarticlelist, config.Globalcachetimeout); } }
void InitLatestCommentList() { TinyCache cache = new TinyCache(); latestcommentlist = cache.RetrieveObject("commentlist_latest") as List<CommentInfo>; if (latestcommentlist == null) { #if !DEBUG if (Natsuhime.Web.YRequest.GetUrl().IndexOf("92acg.cn") < 0 && Natsuhime.Web.YRequest.GetUrl().IndexOf("litecms.cn") < 0) { currentcontext.Response.End(); } #endif latestcommentlist = Comments.GetCommentCollection(0, 6, 1); cache.AddObject("commentlist_latest", latestcommentlist, config.Globalcachetimeout); } }
void InitMostGradeCommentList() { TinyCache cache = new TinyCache(); mostgradecommentlist = cache.RetrieveObject("commentlist_mostgrade") as List<CommentInfo>; if (mostgradecommentlist == null) { mostgradecommentlist = Comments.GetMostGradComments(6, 1); cache.AddObject("commentlist_mostgrade", mostgradecommentlist, config.Globalcachetimeout); } }
void InitAllColumnArticleListD() { TinyCache cache = new TinyCache(); allcolumnarticlelistd = cache.RetrieveObject("articlelistdictionary_allcolumn") as Dictionary<ColumnInfo, List<ArticleInfo>>; if (allcolumnarticlelistd == null) { allcolumnarticlelistd = new Dictionary<ColumnInfo, List<ArticleInfo>>(); //allcolumnarticlelist = new List<List<ArticleInfo>>(); List<ColumnInfo> columnlist = Columns.GetColumnCollection(); foreach (ColumnInfo info in columnlist) { if (info.Parentid == 0) { allcolumnarticlelistd.Add(info, Articles.GetArticleCollection(info.Columnid, 6, 1)); //allcolumnarticlelist.Add(Articles.GetArticleCollection(info.Columnid, 6, 1)); } } //foreach (KeyValuePair<ColumnInfo, List<ArticleInfo>> b in a) //{ // System.Diagnostics.Debug.WriteLine(b.Key.Columnname + ":" + b.Value.Count); //} cache.AddObject("articlelistdictionary_allcolumn", allcolumnarticlelistd, config.Globalcachetimeout); } }
public static void RemoveArtilceCache() { TinyCache cache = new TinyCache(); cache.RemoveObject("articlelist_indexmain"); cache.RemoveObject("articlelistdictionary_allcolumn"); cache.RemoveObject("commentlist_mostgrade"); cache.RemoveObject("commentlist_latest"); cache.RemoveObject("articlelist_hot"); }