/// <summary>
 /// 根据晒单系统编号获取所属晒单图片
 /// </summary>
 /// <param name="commentSysNo">晒单系统编号</param>
 /// <param name="staus">晒单图片状态</param>
 /// <returns>晒单图片集合</returns>
 /// <remarks>2013-07-12 杨晗 创建</remarks>
 public IList <FeProductCommentImage> GetFeProductCommentImageByCommentSysNo(int commentSysNo, ForeStatus.晒单图片状态 staus)
 {
     return(IFeProductCommentImageDao.Instance.GetFeProductCommentImageByCommentSysNo(commentSysNo, staus));
 }
        /// <summary>
        /// 根据晒单系统编号获取所属晒单图片
        /// </summary>
        /// <param name="commentSysNo">晒单系统编号</param>
        /// <param name="staus">晒单图片状态</param>
        /// <returns>晒单图片集合</returns>
        /// <remarks>2013-07-12 杨晗 创建</remarks>
        public override IList <FeProductCommentImage> GetFeProductCommentImageByCommentSysNo(int commentSysNo,
                                                                                             ForeStatus.晒单图片状态
                                                                                             staus)
        {
            #region sql条件

            string sql = @"commentSysNo=@commentSysNo and Status=@Status";

            #endregion

            var countBuilder = Context.Select <FeProductCommentImage>("ft.*")
                               .From("FeProductCommentImage ft")
                               .Where(sql)
                               .Parameter("commentSysNo", commentSysNo)
                               .Parameter("Status", staus)
                               .QueryMany();
            return(countBuilder);
        }
Esempio n. 3
0
 /// <summary>
 /// 根据晒单系统编号获取所属晒单图片
 /// </summary>
 /// <param name="commentSysNo">晒单系统编号</param>
 /// <param name="staus">晒单图片状态</param>
 /// <returns>晒单图片集合</returns>
 /// <remarks>2013-07-12 杨晗 创建</remarks>
 public abstract IList <FeProductCommentImage> GetFeProductCommentImageByCommentSysNo(int commentSysNo,
                                                                                      ForeStatus.晒单图片状态 staus);