/// <summary>
        ///
        /// </summary>
        /// <param name="_UserCmtObj"></param>
        /// <returns></returns>
        public bool InsertToResCmt(OurResComment _UserCmtObj)
        {
            String Sql = "insert into OurResComment(UserID,CommentContent,RestaurantID,Rate,State)" +
                         "values(@UserID,@CommentContent,@RestaurantID,@Rate,@State)";

            SqlParameter[] Paras = new SqlParameter[]
            {
                //new SqlParameter("@CommentID",CommentID),
                new SqlParameter("@UserID", _UserCmtObj.UserID),
                new SqlParameter("@CommentContent", _UserCmtObj.CommentContent),
                //  new SqlParameter("@CommentTime",_UserCmtObj.CommentTime),
                new SqlParameter("@RestaurantID", _UserCmtObj.ResID),
                new SqlParameter("@Rate", _UserCmtObj.Rate),
                new SqlParameter("@State", _UserCmtObj.State),
            };

            if (SqlHelper.ExecuteNonQuery(Sql, Paras, CommandType.Text) > 0)
            {
                return(true);
            }
            return(false);
        }
Exemple #2
0
 public bool InsertToResCmt(OurResComment _UserCmtObj)
 {
     return(this._RestInfoDAL.InsertToResCmt(_UserCmtObj));
 }