Example #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();
            }
        }
Example #2
0
 public static int AddTopicImageCount(int SysNo)
 {
     return(TopicImageDac.AddTopicImageCount(SysNo));
 }
Example #3
0
 public static TopicImageInfo GetTopicImage(int SysNo)
 {
     return(TopicImageDac.GetTopicImageBySysNo(SysNo));
 }
Example #4
0
 public static List <TopicImageInfo> GetValidTopicImageByTopicId(int topicSysNo)
 {
     return(TopicImageDac.GetValidTopicImageByTopicId(topicSysNo));
 }
Example #5
0
 public static List <TopicImageInfo> GetTopicImageList(int topicSysNo)
 {
     return(TopicImageDac.GetTopicImagesByTopicId(topicSysNo));
 }
Example #6
0
 public static void CancelAbandonTopicImage(int topicImageSysNo)
 {
     TopicImageDac.AbandTopicImage(topicImageSysNo, AppEnum.TopicImageStatus.Normal);
 }
Example #7
0
 public static void AbandonTopicImage(int topicImageSysNo)
 {
     TopicImageDac.AbandTopicImage(topicImageSysNo, AppEnum.TopicImageStatus.Abandon);
 }