void BindPtAndReviewsAndReplys() { UserProductReviewAndReplyQuery query = new UserProductReviewAndReplyQuery(); query.PageIndex = this.pager.PageIndex; query.PageSize = this.pager.PageSize; int total = 0; DataSet userProductReviewsAndReplys = CommentsHelper.GetUserProductReviewsAndReplys(query, out total); this.dlstPts.DataSource = userProductReviewsAndReplys.Tables[0].DefaultView; this.dlstPts.DataBind(); this.pager.TotalRecords = total; }
static string BuildUserReviewsAndReplysQuery(UserProductReviewAndReplyQuery query) { StringBuilder builder = new StringBuilder(); builder.Append(" SELECT ProductId FROM Hishop_ProductReviews "); builder.AppendFormat(" AND ProductId IN (SELECT ProductId FROM Hishop_Products)", new object[0]); builder.Append(" GROUP BY ProductId"); return builder.ToString(); }
public override DataSet GetUserProductReviewsAndReplys(UserProductReviewAndReplyQuery query, out int total) { DbCommand storedProcCommand = database.GetStoredProcCommand("ac_Member_UserReviewsAndReplys_Get"); database.AddInParameter(storedProcCommand, "PageIndex", DbType.Int32, query.PageIndex); database.AddInParameter(storedProcCommand, "PageSize", DbType.Int32, query.PageSize); database.AddInParameter(storedProcCommand, "IsCount", DbType.Boolean, query.IsCount); database.AddInParameter(storedProcCommand, "UserId", DbType.Int32, HiContext.Current.User.UserId); database.AddInParameter(storedProcCommand, "sqlPopulate", DbType.String, BuildUserReviewsAndReplysQuery(query)); database.AddOutParameter(storedProcCommand, "Total", DbType.Int32, 4); DataSet set = database.ExecuteDataSet(storedProcCommand); set.Relations.Add("PtReviews", set.Tables[0].Columns["ProductId"], set.Tables[1].Columns["ProductId"], false); total = (int)database.GetParameterValue(storedProcCommand, "Total"); return set; }
public abstract DataSet GetUserProductReviewsAndReplys(UserProductReviewAndReplyQuery query, out int total);
static string BuildUserReviewsAndReplysQuery(UserProductReviewAndReplyQuery query) { StringBuilder builder = new StringBuilder(); builder.Append(" SELECT ProductId FROM distro_ProductReviews "); builder.AppendFormat(" WHERE UserId = {0} ", HiContext.Current.User.UserId); builder.AppendFormat(" AND ProductId IN (SELECT ProductId FROM distro_Products WHERE DistributorUserId={0} )", HiContext.Current.SiteSettings.UserId); builder.Append(" GROUP BY ProductId"); return builder.ToString(); }
public static DataSet GetUserProductReviewsAndReplys(UserProductReviewAndReplyQuery query, out int total) { return CommentDataProvider.Instance().GetUserProductReviewsAndReplys(query, out total); }