public override System.Data.DataSet GetUserProductReviewsAndReplys(UserProductReviewAndReplyQuery query, out int total)
{
System.Data.Common.DbCommand storedProcCommand = this.database.GetStoredProcCommand("ac_Member_UserReviewsAndReplys_Get");
this.database.AddInParameter(storedProcCommand, "PageIndex", System.Data.DbType.Int32, query.PageIndex);
this.database.AddInParameter(storedProcCommand, "PageSize", System.Data.DbType.Int32, query.PageSize);
this.database.AddInParameter(storedProcCommand, "IsCount", System.Data.DbType.Boolean, query.IsCount);
this.database.AddInParameter(storedProcCommand, "UserId", System.Data.DbType.Int32, HiContext.Current.User.UserId);
this.database.AddInParameter(storedProcCommand, "sqlPopulate", System.Data.DbType.String, CommentData.BuildUserReviewsAndReplysQuery(query));
this.database.AddOutParameter(storedProcCommand, "Total", System.Data.DbType.Int32, 4);
System.Data.DataSet dataSet = this.database.ExecuteDataSet(storedProcCommand);
dataSet.Relations.Add("PtReviews", dataSet.Tables[0].Columns["ProductId"], dataSet.Tables[1].Columns["ProductId"], false);
total = (int)this.database.GetParameterValue(storedProcCommand, "Total");
return(dataSet);
}
public override DataSet GetUserProductReviewsAndReplys(UserProductReviewAndReplyQuery query, out int total)
{
DbCommand storedProcCommand = database.GetStoredProcCommand("ac_Underling_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.AddInParameter(storedProcCommand, "DistributorUserId", DbType.Int32, HiContext.Current.SiteSettings.UserId);
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);
public static DataSet GetUserProductReviewsAndReplys(UserProductReviewAndReplyQuery query, out int total)
{
return(CommentDataProvider.Instance().GetUserProductReviewsAndReplys(query, out total));
}
public static DataSet GetUserProductReviewsAndReplys(UserProductReviewAndReplyQuery query, out int total)
{
return(new ProductReviewDao().GetUserProductReviewsAndReplys(query, out total));
}
