public static void AddNewTopic(TopicInfo topic) { TransactionOptions options = new TransactionOptions(); options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted; options.Timeout = TransactionManager.DefaultTimeout; using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options)) { int topicSysNo = TopicDac.InsertTopic(topic); // 添加了新评论, // 同时更新 Product 表的 RemarkCount / RemarkScore 字段。 TopicDac.UpdateProductRemarkCountAndScore(topic.ReferenceSysNo); if (topic.ImageList != null && topic.ImageList.Count > 0) { foreach (TopicImageInfo info in topic.ImageList) { info.TopicSysNo = topicSysNo; TopicImageDac.InsertTopicImage(info); } } scope.Complete(); } }
public static DataSet SearchProductTopics(TopicSearchCondition SearchCondition) { return(TopicDac.SearchProductTopic(SearchCondition)); }
public static TopicInfo GetTopicById(int TopicId) { return(TopicDac.GetTopicByTopicId(TopicId)); }
public static List <TopicInfo> GetProductTopicList(int productSysNo, int pageSize, int pageIndex, out int totalCount, string type) { return(TopicDac.GetAllTopicByProductId(productSysNo, pageSize, pageIndex, out totalCount, type)); }
public static List <TopicInfo> GetProductTop3TopicList(int productSysNo) { int totalCount; return(TopicDac.GetAllTopicByProductId(productSysNo, 0, 0, out totalCount, "Top3")); }
public static void AddTopicReplyBySysUser(TopicReplyInfo reply, AppEnum.TopicStatus ts) { TopicReplyDac.InsertTopicReply(reply); TopicDac.ChangeTopicStstus(reply.TopicSysNo, AppEnum.TopicStatus.Replyed); }
public static void AddTopicReply(TopicReplyInfo reply) { TopicReplyDac.InsertTopicReply(reply); TopicDac.UpdateProductRemarkCountAndScoreByTopicSysNo(reply.TopicSysNo); }
/// <summary> /// 检查该用户的当天主题数量是否达到了上限 /// </summary> /// <param name="customerSysNo">Customer SysNo</param> /// <returns></returns> public static bool IsTopicCountLimitToday(int customerSysNo) { return(TopicDac.ReturnNumOfTopicByCustomerId(customerSysNo) >= AppConfig.Topic.PostTopic_Everyday_CountLimit); }
public static void TopicCancelDigset(int topicSysNo, int userSysNo) { TopicDac.UpdateTopicByType(topicSysNo, userSysNo, AppEnum.TopicUpdateType.TopicCancelDigset); }
public static void TopicSetTop(int topicSysNo, int userSysNo) { TopicDac.UpdateTopicByType(topicSysNo, userSysNo, AppEnum.TopicUpdateType.TopicSetTop); }
public static void UnConfirmTopic(int topicSysNo, int userSysNo) { TopicDac.UpdateTopicByType(topicSysNo, userSysNo, AppEnum.TopicUpdateType.UnConfirmTopic); }
public static void CancelAbandonTopic(int topicSysNo, int userSysNo) { TopicDac.UpdateTopicByType(topicSysNo, userSysNo, AppEnum.TopicUpdateType.CancelAbandonTopic); }