/// <summary> /// 根据cmt_uid获得评论 /// </summary> /// <param name="cmt_uid"></param> /// <returns></returns> public static CommentInfo Comments_Selectbycmt_uid(string cmt_uid) { using (var access = new DataAccess_QzNews(Constants.QZNewSite_News_Db_Key)) { return(access.Comments_Selectbycmt_uid(cmt_uid)); } }
/// <summary> /// 插入热门评论 /// </summary> /// <param name="obj"></param> /// <returns></returns> public static int RecommendComments_Insert(RecommendCommentInfo obj) { using (var access = new DataAccess_QzNews(Constants.QZNewSite_News_Db_Key)) { return(access.RecommendComments_Insert(obj)); } }
/// <summary> /// 获得评论 /// </summary> /// <param name="cmt_sourceId"></param> /// <param name="cmt_uids"></param> /// <returns></returns> public static List <CommentInfo> Comments_Selectbycmt_uidStrs(string cmt_sourceId, string[] cmt_uids) { using (var access = new DataAccess_QzNews(Constants.QZNewSite_News_Db_Key)) { return(access.Comments_Selectbycmt_uidStrs(cmt_sourceId, cmt_uids.ToArray())); } }
/// <summary> /// 插入评论 /// </summary> /// <param name="cmt"></param> /// <param name="cmt_parentUid"></param> /// <param name="cmt_sourceUrl"></param> /// <returns></returns> public static int Comments_Insert(CommentInfo cmt, string cmt_parentUid, string cmt_sourceUrl) { using (var access = new DataAccess_QzNews(Constants.QZNewSite_News_Db_Key)) { return(access.Comments_Insert(cmt, cmt_parentUid, cmt_sourceUrl)); } }
/// <summary> /// 插入浏览记录 /// </summary> /// <param name="vlog"></param> /// <param name="tableName"></param> /// <returns></returns> public static int VisitLog_Insert(VisitLogInfo vlog, string tableName) { using (var logAccess = new DataAccess_QzNews(Constants.SysLog_App_Db_Key)) { return(logAccess.VisitLog_Insert(vlog, tableName)); } }
/// <summary> /// 根据文章ID获得文章摘要信息 /// </summary> /// <param name="n_gid"></param> /// <param name="tableName"></param> /// <returns></returns> public static NewsInfo News_Selectbyn_gid(string n_gid, string tableName) { using (var access = new DataAccess_QzNews(Constants.QZNewSite_News_Db_Key)) { return(access.News_Selectbyn_gid(n_gid, tableName)); } }
/// <summary> /// 根据cat_ctrl,cat_id获得新闻列表 /// </summary> /// <returns></returns> public static List <NewsInfo> News_SelectPaged(string cat_ctrl, string cat_id, string page, string pagesize) { page = (int.Parse(page) < 1) ? "1" : page; pagesize = (int.Parse(pagesize) > 30) ? "30" : pagesize; NewsCateInfo cate = CacheMarker.GetNewsCatesBycat_id(cat_id); NewsSearchInfo search = new NewsSearchInfo(); int rowcount = 0; using (var access = new DataAccess_QzNews(Constants.QZNewSite_News_Db_Key)) { search.n_state = 1; if (cate != null && cate.cat_inheritAll && !cate.cat_isLast) { search.cat_inheritPath = cate.cat_path; } else { search.n_cat_id = cate.cat_id; } string whereString = search.ToWhereString(); // 图集 if ("photo" == cat_ctrl) { whereString += " and n_type='images'"; } return(access.News_SelectPaged(GetNewsTable(cate.cat_tableIndex), "*", whereString, search.DefOrder, int.Parse(page), int.Parse(pagesize), out rowcount)); } }
public static List <CommentInfo> Comments_SelectPaged(string column, string where, string order, int pg_index, int pg_size, bool only4Ids, out int count) { using (var access = new DataAccess_QzNews(Constants.QZNewSite_News_Db_Key)) { return(access.Comments_SelectPaged(column, where, order, pg_index, pg_size, only4Ids, out count)); } }
/// <summary> /// 选择信息分类 /// </summary> /// <param name="cat_id">The cat_id.</param> /// <returns></returns> public static NewsCateInfo NewsCates_Selectbycat_id(int cat_id) { using (var access = new DataAccess_QzNews(Constants.QZNewSite_News_Db_Key)) { return(access.NewsCates_Selectbycat_id(cat_id)); } }
/// <summary> /// 评论“顶”操作 /// </summary> /// <param name="cmtId"></param> /// <returns></returns> public static int Comments_AddAccept(string cmtId) { using (var access = new DataAccess_QzNews(Constants.QZNewSite_News_Db_Key)) { // 评论数据加1 return(access.Comments_AddAccept(cmtId, 1)); } }
/// <summary> /// 获得某条新闻的详细内容 /// </summary> /// <param name="n_gid"></param> /// <returns></returns> public static List <NewsContentInfo> GetNewsContent(string n_gid) { using (var access = new DataAccess_QzNews(Constants.QZNewSite_News_Db_Key)) { List <NewsContentInfo> list = new List <NewsContentInfo>(); return(access.NewsContent_Selectbync_n_gid(n_gid)); } }
/// <summary> /// 根据cmt_uid获得热评 /// </summary> /// <param name="cmt_uid"></param> /// <returns></returns> public static List <CommentInfo> RecommendComments_Selectbycmt_uid(string cmt_uid) { int rowcount = 0; using (var access = new DataAccess_QzNews(Constants.QZNewSite_News_Db_Key)) { return(access.RecommendComments_SelectPaged("*", string.Format("where cmt_uid = '{0}'", cmt_uid), "", 1, 1, out rowcount)); } }
/// <summary> /// 根据文章ID获得该文章的热门评论 /// </summary> /// <param name="sourceId"></param> /// <param name="page"></param> /// <param name="limit"></param> /// <param name="rowcount"></param> /// <returns></returns> public static List <CommentInfo> RecommendComments_SelectPaged(string sourceId, string page, string limit, out int rowcount) { using (var access = new DataAccess_QzNews(Constants.QZNewSite_News_Db_Key)) { page = (int.Parse(page) < 1) ? "1" : page; limit = (int.Parse(limit) > 30) ? "30" : limit; return(access.RecommendComments_SelectPaged("*", string.Format("where cmt_sourceId = '{0}'", sourceId), "cmt_id desc", int.Parse(page), int.Parse(limit), out rowcount)); } }
/// <summary> /// 根据cat_ctrl获得新闻列表 /// 指定某一个新闻分类,然后获取这个分类下的处于正常状态的新闻列表 /// </summary> /// <returns></returns> public static List <NewsInfo> News_SelectPaged(string cat_ctrl, string page, string pagesize) { page = (int.Parse(page) < 1) ? "1" : page; pagesize = (int.Parse(pagesize) > 30) ? "30" : pagesize; // 根据指定的cat_ctrl获取某一新闻分类信息 NewsCateInfo cate = CacheMarker.GetNewsCateByCtrl(cat_ctrl); if (cate == null) { return(new List <NewsInfo>()); } NewsSearchInfo search = new NewsSearchInfo(); int rowcount = 0; using (var access = new DataAccess_QzNews(Constants.QZNewSite_News_Db_Key)) { try { search.n_state = 1; if (cate.cat_inheritAll && !cate.cat_isLast) { search.cat_inheritPath = cate.cat_path; } else { search.n_cat_id = cate.cat_id; } string whereString = search.ToWhereString(); // 图集 if ("photo" == cat_ctrl) { whereString += " and n_type='images'"; } return(access.News_SelectPaged(GetNewsTable(cate.cat_tableIndex), "*", whereString, search.DefOrder, int.Parse(page), int.Parse(pagesize), out rowcount)); } catch (Exception e) { #region debug Util.Log_Info(nameof(News_SelectPaged), Location.Internal, e.Message, "database error"); #endregion return(new List <NewsInfo>()); } } }
/// <summary> /// 获得新闻分类 /// </summary> /// <returns></returns> public static List <NewsCateInfo> NewsCates_SelectPaged(bool isLen = true) { NewsCateSearchInfo search = new NewsCateSearchInfo(); if (isLen) { search.cat_path_len = 2; } int rowcount = 0; using (var access = new DataAccess_QzNews(Constants.QZNewSite_News_Db_Key)) { return(access.NewsCates_SelectPaged("*", search.ToWhereString(), search.DefOrder, 1, UInt16.MaxValue, out rowcount)); } }
public static List <NewsInfo> News_Page_Select(string catId, string page, string pagesize) { page = (int.Parse(page) < 1) ? "1" : page; pagesize = (int.Parse(pagesize) > 30) ? "30" : pagesize; // 根据指定的cat_ctrl获取某一新闻分类信息 NewsCateInfo cate = CacheMarker.NewsCates_FromId_Get(catId); if (cate == null) { return(new List <NewsInfo>()); } NewsSearchInfo search = new NewsSearchInfo(); int rowcount = 0; using (var access = new DataAccess_QzNews(Constants.QZNewSite_News_Db_Key)) { try { search.n_state = 1; if (cate.cat_inheritAll && !cate.cat_isLast) { search.cat_inheritPath = cate.cat_path; } else { search.n_cat_id = cate.cat_id; } string whereString = search.ToWhereString(); //// 图集 //if ("photo" == cat_ctrl) //{ // whereString += " and n_type='images'"; //} var res = access.News_SelectPaged(GetNewsTable(cate.cat_tableIndex), "*", whereString, search.DefOrder, int.Parse(page), int.Parse(pagesize), out rowcount); return(res); } catch (Exception e) { return(new List <NewsInfo>()); } } }
/// <summary> /// 获得App头部导航条或者获得CMS推送的图片新闻(获得发布过的前topn条数据) /// </summary> /// <param name="blk_id"></param> /// <param name="topn"></param> /// <returns></returns> public static List <CMSItemsInfo> CMSItems_SelectTopN2(int blk_id, int topn, string andThere = "") { using (var access = new DataAccess_QzNews(Constants.QZNewSite_Db_Key)) { try { // 获得发布过的前topn条数据 return(access.CMSItems_SelectTopN(blk_id, topn, "n_status = 1" + andThere)); } catch (Exception e) { #region debug Util.Log_Info(nameof(CMSItems_SelectTopN2), Location.Internal, e.Message, "database error"); #endregion return(new List <CMSItemsInfo>()); } } }
/// <summary> /// 获得某文章的最新评论 /// </summary> /// <param name="sourceId"></param> /// <param name="page"></param> /// <param name="limit"></param> /// <param name="rowcount"></param> /// <returns></returns> public static List <CommentInfo> Comments_SelectPaged(string sourceId, string page, string limit, out int rowcount) { page = (int.Parse(page) < 1) ? "1" : page; limit = (int.Parse(limit) > 30) ? "30" : limit; CommentsSearchInfo search = new CommentsSearchInfo(); search.cmt_sourceId = sourceId.ToSafetyStr(); search.cmt_status = 1; search.page = int.Parse(page); search.pagesize = Int32.Parse(limit); using (var access = new DataAccess_QzNews(Constants.QZNewSite_News_Db_Key)) { return(access.Comments_SelectPaged(search.columns, search.ToWhereString(), search.DefOrder, search.page, search.pagesize, true, out rowcount)); } }
/// <summary> /// 获得某文章的评论数 /// </summary> /// <param name="n_gid"></param> /// <returns></returns> public static int GetCommentCount(string n_gid) {/* * CommentsSourceUrlInfo comments = null; * * using (var access = new DataAccess_QzNews(Constants.QZNewSite_News_Db_Key)) * { * comments = access.CommentsSourceUrls_SelectbysourceId(StringExtension.ToSafetyStr(n_gid)); * } * * if (comments != null) * { * return comments.cmt_total; * } */ using (var access = new DataAccess_QzNews(Constants.QZNewSite_News_Db_Key)) { return(access.Comments_CountbysourceId(n_gid)); } }
/// <summary> /// 获取某一分类下最新新闻 /// </summary> /// <param name="cat_ctrl"></param> /// <returns></returns> public static NewsInfo LastNews_Select(string cat_ctrl) { // 根据指定的cat_ctrl获取某一新闻分类信息 NewsCateInfo cate = CacheMarker.GetNewsCateByCtrl(cat_ctrl); if (cate == null) { return(null); } NewsSearchInfo search = new NewsSearchInfo(); int rowcount = 0; using (var access = new DataAccess_QzNews(Constants.QZNewSite_News_Db_Key)) { search.n_state = 1; if (cate.cat_inheritAll && !cate.cat_isLast) { search.cat_inheritPath = cate.cat_path; } else { search.n_cat_id = cate.cat_id; } string whereString = search.ToWhereString(); // 图集 if ("photo" == cat_ctrl) { whereString += " and n_type='images'"; } var list = access.News_SelectPaged(GetNewsTable(cate.cat_tableIndex), "*", whereString, search.DefOrder, 1, 1, out rowcount); if (list != null && list.Count > 0) { return(list[0]); } return(null); } }
/// <summary> /// 将评论“顶”日志插入数据库 /// </summary> /// <param name="cmtId"></param> /// <returns></returns> public static int FavorLog_Insert(string cmtId) { string objType = "CMTAgree"; string objId = cmtId + "," + DateTime.Now.ToString("yyMMddHH"); OperationContext context = OperationContext.Current; MessageProperties messageProperties = context.IncomingMessageProperties; RemoteEndpointMessageProperty endpointProperty = messageProperties[RemoteEndpointMessageProperty.Name] as RemoteEndpointMessageProperty; string ip = endpointProperty.Address; string clientId = string.Empty; string uid = Cipher_Md5.Md5_16_1(string.Join(",", new string[] { DateTime.Today.ToString("yyyy-MM-dd"), objType, objId, clientId })); int week = Util.GetWeekOfYear(DateTime.Today); string tblName = string.Format("FavorLog_{0}{1}{2}", DateTime.Today.Year, week < 10 ? "0" : "", week); using (var access = new DataAccess_QzNews(Constants.SysLog_Db_Key)) { // 将日志插入到数据库 return(access.FavorLog_Insert(uid, objType, objId, string.Empty, string.Empty, clientId, ip, string.Empty, tblName)); } }
/// <summary> /// 加载个人评论 /// </summary> /// <param name="userId"></param> /// <param name="page"></param> /// <param name="pagesize"></param> /// <returns></returns> public static List <CommentInfo> Comments_SelectPaged(string userId, string page, string pagesize) { page = (int.Parse(page) < 1) ? "1" : page; pagesize = (int.Parse(pagesize) > 30) ? "30" : pagesize; // 设置获取条件 CommentsSearchInfo search = new CommentsSearchInfo(); search.cmt_status = 1; search.page = int.Parse(page); search.pagesize = int.Parse(pagesize); search.cmt_createUserID = int.Parse(userId); // 根据条件获得评论 int rowcount = 0; using (var access = new DataAccess_QzNews(Constants.QZNewSite_News_Db_Key)) { // 获得评论 return(access.Comments_SelectPaged(search.columns, search.ToWhereString(), search.DefOrder, search.page, search.pagesize, false, out rowcount)); } }