Beispiel #1
0
        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();
            }
        }
Beispiel #2
0
 public static DataSet SearchProductTopics(TopicSearchCondition SearchCondition)
 {
     return(TopicDac.SearchProductTopic(SearchCondition));
 }
Beispiel #3
0
 public static TopicInfo GetTopicById(int TopicId)
 {
     return(TopicDac.GetTopicByTopicId(TopicId));
 }
Beispiel #4
0
 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));
 }
Beispiel #5
0
        public static List <TopicInfo> GetProductTop3TopicList(int productSysNo)
        {
            int totalCount;

            return(TopicDac.GetAllTopicByProductId(productSysNo, 0, 0, out totalCount, "Top3"));
        }
Beispiel #6
0
        public static void AddTopicReplyBySysUser(TopicReplyInfo reply, AppEnum.TopicStatus ts)
        {
            TopicReplyDac.InsertTopicReply(reply);

            TopicDac.ChangeTopicStstus(reply.TopicSysNo, AppEnum.TopicStatus.Replyed);
        }
Beispiel #7
0
 public static void AddTopicReply(TopicReplyInfo reply)
 {
     TopicReplyDac.InsertTopicReply(reply);
     TopicDac.UpdateProductRemarkCountAndScoreByTopicSysNo(reply.TopicSysNo);
 }
Beispiel #8
0
 /// <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);
 }
Beispiel #9
0
 public static void TopicCancelDigset(int topicSysNo, int userSysNo)
 {
     TopicDac.UpdateTopicByType(topicSysNo, userSysNo, AppEnum.TopicUpdateType.TopicCancelDigset);
 }
Beispiel #10
0
 public static void TopicSetTop(int topicSysNo, int userSysNo)
 {
     TopicDac.UpdateTopicByType(topicSysNo, userSysNo, AppEnum.TopicUpdateType.TopicSetTop);
 }
Beispiel #11
0
 public static void UnConfirmTopic(int topicSysNo, int userSysNo)
 {
     TopicDac.UpdateTopicByType(topicSysNo, userSysNo, AppEnum.TopicUpdateType.UnConfirmTopic);
 }
Beispiel #12
0
 public static void CancelAbandonTopic(int topicSysNo, int userSysNo)
 {
     TopicDac.UpdateTopicByType(topicSysNo, userSysNo, AppEnum.TopicUpdateType.CancelAbandonTopic);
 }