public bool Insert(ProductCommentInfo productCommentInfo)
        {
            StringBuilder sql=new StringBuilder();
            sql.Append("INSERT INTO");
            sql.Append(" [Tbl_ProductComment](");
            sql.Append("[ProductNO],");
            sql.Append("[Title],");
            sql.Append("[Merits],");
            sql.Append("[Demerits],");
            sql.Append("[Summary],");
            sql.Append("[Star],");
            sql.Append("[ReplyCount]");
            sql.Append(") VALUES(");
            sql.Append("@ProductNO,");
            sql.Append("@Title,");
            sql.Append("@Merits,");
            sql.Append("@Demerits,");
            sql.Append("@Summary,");
            sql.Append("@Star,");
            sql.Append("@ReplyCount");
            sql.Append(");SELECT @@IDENTITY;");

            using(NetShopHelper dbhelper=new NetShopHelper())
            {
                IDbDataParameter[] p_Parms=new IDbDataParameter[]{
                    dbhelper.CreateParameter("@ProductNO",productCommentInfo.ProductNO),
                    dbhelper.CreateParameter("@Title",productCommentInfo.Title),
                    dbhelper.CreateParameter("@Merits",productCommentInfo.Merits),
                    dbhelper.CreateParameter("@Demerits",productCommentInfo.Demerits),
                    dbhelper.CreateParameter("@Summary",productCommentInfo.Summary),
                    dbhelper.CreateParameter("@Star",productCommentInfo.Star),
                    dbhelper.CreateParameter("@ReplyCount",productCommentInfo.ReplyCount)
                };
            int ret=(int)dbhelper.ExecuteScalar(sql.ToString(),p_Parms);
            productCommentInfo.Id=ret;
            return true;
            }
        }
 public bool Update(ProductCommentInfo productCommentInfo)
 {
     StringBuilder sql = new StringBuilder();
     sql.Append("UPDATE");
     sql.Append(" [Tbl_ProductComment]");
     sql.Append(" SET");
     sql.Append(" [ProductNO]=@ProductNO,");
     sql.Append(" [Title]=@Title,");
     sql.Append(" [Merits]=@Merits,");
     sql.Append(" [Demerits]=@Demerits,");
     sql.Append(" [Summary]=@Summary,");
     sql.Append(" [Star]=@Star,");
     sql.Append(" [ReplyCount]=@ReplyCount");
     sql.Append(" WHERE");
     sql.Append(" [ID]=@ID");
     using(NetShopHelper dbhelper=new NetShopHelper())
     {
       IDbDataParameter[] p_Parms = new IDbDataParameter[]{
         dbhelper.CreateParameter("@ID",productCommentInfo.Id)
       };
      return 0 < dbhelper.ExecuteNonQuery(sql.ToString(),p_Parms);
     }
 }
        /// <summary>
        /// Convert IDataReader To ProductCommentInfo
        /// </summary>
        /// <param name="reader"></param>
        /// <returns></returns>
        public static ProductCommentInfo SetValue(IDataReader reader)
        {
            ProductCommentInfo info = new ProductCommentInfo();

            int idIndex = reader.GetOrdinal("ID");
            int productNOIndex = reader.GetOrdinal("ProductNO");
            int titleIndex = reader.GetOrdinal("Title");
            int meritsIndex = reader.GetOrdinal("Merits");
            int demeritsIndex = reader.GetOrdinal("Demerits");
            int summaryIndex = reader.GetOrdinal("Summary");
            int starIndex = reader.GetOrdinal("Star");
            int replyCountIndex = reader.GetOrdinal("ReplyCount");

            info.Id = reader.GetInt32(idIndex);
            info.ProductNO = reader.GetString(productNOIndex);
            info.Title = reader.GetString(titleIndex);
            info.Merits = reader.GetString(meritsIndex);
            info.Demerits = reader.GetString(demeritsIndex);
            info.Summary = reader.GetString(summaryIndex);
            info.Star = reader.GetInt32(starIndex);
            info.ReplyCount = reader.GetInt32(replyCountIndex);

            return info;
        }