/// <summary> /// 使用缓存查询信息 /// </summary> /// <param name="info">查询主体</param> /// <param name="totalcnt">返回条目数</param> /// <returns></returns> public DataTable QueryData(ActivitySearchEntity info, out int totalcnt) { if (info.UseDBPagination) { string key = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(info.ToJson(info), "MD5"); DataTableRSCacheEntity rsobj = MyCache <DataTableRSCacheEntity> .Get(key); if (rsobj == null) { DataTable dt = dao.QueryData(info, out totalcnt); if (dt != null && dt.Rows.Count > 0) { rsobj = new DataTableRSCacheEntity() { Source = dt, TotalCnt = totalcnt }; MyCache <DataTableRSCacheEntity> .Insert(key, rsobj, 60); } else { rsobj = new DataTableRSCacheEntity(); } } totalcnt = rsobj.TotalCnt; return(rsobj.Source); } else { return(dao.QueryData(info, out totalcnt)); } }
/// <summary> /// 获取展会所有展商地址 /// </summary> /// <param name="exhibitionID"></param> /// <returns></returns> public DataTable GetExhibitorLocation(int exhibitionID) { string key = string.Format(WebKeys.ExhibitorLocationConsoleCacheKey, exhibitionID.ToString()); DataTableRSCacheEntity rsobj = MyCache <DataTableRSCacheEntity> .Get(key); if (rsobj == null) { DataTable dt = dao.GetExhibitorLocation(exhibitionID); if (dt != null && dt.Rows.Count > 0) { rsobj = new DataTableRSCacheEntity() { Source = dt, TotalCnt = dt.Rows.Count }; MyCache <DataTableRSCacheEntity> .Insert(key, rsobj, 60); } else { rsobj = new DataTableRSCacheEntity(); } } return(rsobj.Source); //return dao.GetExhibitorLocation(exhibitionID); }