protected override void AttachChildControls() { int num; int num2; MemberInfo currentMember = MemberProcessor.GetCurrentMember(); this.rptProducts = (VshopTemplatedRepeater) this.FindControl("rptProducts"); this.txtTotal = (HtmlInputHidden) this.FindControl("txtTotal"); if (!int.TryParse(this.Page.Request.QueryString["page"], out num)) { num = 1; } if (!int.TryParse(this.Page.Request.QueryString["size"], out num2)) { num2 = 20; } ProductConsultationAndReplyQuery consultationQuery = new ProductConsultationAndReplyQuery { UserId = currentMember.UserId, IsCount = true, PageIndex = num, PageSize = num2, SortBy = "ConsultationId", SortOrder = SortAction.Desc }; DbQueryResult productConsultations = ProductBrowser.GetProductConsultations(consultationQuery); this.rptProducts.DataSource = productConsultations.Data; this.rptProducts.DataBind(); this.txtTotal.SetWhenIsNotNull(productConsultations.TotalRecords.ToString()); PageTitle.AddSiteNameTitle("商品咨询"); }
void BindPtConsultationReplyed() { ProductConsultationAndReplyQuery query = new ProductConsultationAndReplyQuery(); query.PageIndex = this.pagerConsultationReplyed.PageIndex; query.UserId = HiContext.Current.User.UserId; query.Type = ConsultationReplyType.Replyed; int total = 0; DataSet productConsultationsAndReplys = CommentsHelper.GetProductConsultationsAndReplys(query, out total); this.dlstPtConsultationReplyed.DataSource = productConsultationsAndReplys.Tables[0].DefaultView; this.dlstPtConsultationReplyed.DataBind(); this.pagerConsultationReplyed.TotalRecords = total; }
private void BindConsultation() { ProductConsultationAndReplyQuery entity = new ProductConsultationAndReplyQuery(); entity.Keywords = keywords; entity.CategoryId = categoryId; entity.ProductCode = productCode; entity.PageIndex = pager.PageIndex; entity.PageSize = pager.PageSize; entity.SortOrder = SortAction.Desc; entity.SortBy = "ReplyDate"; entity.Type = ConsultationReplyType.NoReply; Globals.EntityCoding(entity, true); DbQueryResult consultationProducts = ProductCommentHelper.GetConsultationProducts(entity); grdConsultation.DataSource = consultationProducts.Data; grdConsultation.DataBind(); pager.TotalRecords = consultationProducts.TotalRecords; pager1.TotalRecords = consultationProducts.TotalRecords; }
private void BindConsultation() { ProductConsultationAndReplyQuery query2 = new ProductConsultationAndReplyQuery(); query2.Keywords = this.keywords; query2.CategoryId = this.categoryId; query2.ProductCode = this.productCode; query2.PageIndex = this.pager.PageIndex; query2.PageSize = this.pager.PageSize; query2.SortOrder = SortAction.Desc; query2.SortBy = "ReplyDate"; query2.Type = ConsultationReplyType.NoReply; ProductConsultationAndReplyQuery entity = query2; Globals.EntityCoding(entity, true); DbQueryResult consultationProducts = SubsiteCommentsHelper.GetConsultationProducts(entity); this.grdConsultation.DataSource = consultationProducts.Data; this.grdConsultation.DataBind(); this.pager.TotalRecords = consultationProducts.TotalRecords; this.pager1.TotalRecords = consultationProducts.TotalRecords; }
private void BinddlstProductConsultation() { ProductConsultationAndReplyQuery entity = new ProductConsultationAndReplyQuery { Keywords = this.keywords, CategoryId = this.categoryId, ProductCode = this.productCode, PageIndex = this.pager.PageIndex, PageSize = this.pager.PageSize, SortOrder = SortAction.Desc, SortBy = "ReplyDate", Type = ConsultationReplyType.Replyed }; Globals.EntityCoding(entity, true); DbQueryResult consultationProducts = ProductCommentHelper.GetConsultationProducts(entity); this.grdConsultation.DataSource = consultationProducts.Data; this.grdConsultation.DataBind(); this.pager.TotalRecords = consultationProducts.TotalRecords; this.pager1.TotalRecords = consultationProducts.TotalRecords; }
protected override void AttachChildControls() { int num; int num2; if (!int.TryParse(this.Page.Request.QueryString["productId"], out this.productId)) { base.GotoResourceNotFound(""); } ProductConsultationAndReplyQuery consultationQuery = new ProductConsultationAndReplyQuery(); if (!int.TryParse(this.Page.Request.QueryString["page"], out num)) { num = 1; } if (!int.TryParse(this.Page.Request.QueryString["size"], out num2)) { num2 = 20; } consultationQuery.ProductId = this.productId; consultationQuery.IsCount = true; consultationQuery.PageIndex = num; consultationQuery.PageSize = num2; consultationQuery.SortBy = "ConsultationId"; consultationQuery.SortOrder = SortAction.Desc; consultationQuery.HasReplied = true; this.rptProducts = (VshopTemplatedRepeater) this.FindControl("rptProducts"); this.txtTotal = (HtmlInputHidden) this.FindControl("txtTotal"); DbQueryResult productConsultations = ProductBrowser.GetProductConsultations(consultationQuery); this.rptProducts.DataSource = productConsultations.Data; this.rptProducts.DataBind(); this.txtTotal.SetWhenIsNotNull(productConsultations.TotalRecords.ToString()); this.litProductTitle = (Literal) this.FindControl("litProductTitle"); this.litShortDescription = (Literal) this.FindControl("litShortDescription"); this.litSoldCount = (Literal) this.FindControl("litSoldCount"); this.litSalePrice = (Literal) this.FindControl("litSalePrice"); this.imgProductImage = (HtmlImage) this.FindControl("imgProductImage"); ProductInfo product = ProductBrowser.GetProduct(MemberProcessor.GetCurrentMember(), this.productId); this.litProductTitle.SetWhenIsNotNull(product.ProductName); this.litShortDescription.SetWhenIsNotNull(product.ShortDescription); this.litSoldCount.SetWhenIsNotNull(product.ShowSaleCounts.ToString()); this.litSalePrice.SetWhenIsNotNull(product.MinSalePrice.ToString("F2")); this.imgProductImage.Src = product.ThumbnailUrl60; PageTitle.AddSiteNameTitle("商品咨询"); }
public static DbQueryResult GetConsultationProducts(ProductConsultationAndReplyQuery consultationQuery) { return new ProductConsultationDao().GetConsultationProducts(consultationQuery); }
public static DbQueryResult GetConsultationProducts(ProductConsultationAndReplyQuery consultationQuery) { return CommentsProvider.Instance().GetConsultationProducts(consultationQuery); }
static string BuildProductConsultationQuery(ProductConsultationAndReplyQuery consultationQuery) { HiContext current = HiContext.Current; StringBuilder builder = new StringBuilder(); builder.Append("SELECT c.ConsultationId FROM Hishop_Products p inner join Hishop_ProductConsultations c on p.productId=c.ProductId WHERE 0 = 0"); if (consultationQuery.Type == ConsultationReplyType.NoReply) { builder.Append(" AND c.ReplyUserId IS NULL "); } else if (consultationQuery.Type == ConsultationReplyType.Replyed) { builder.Append(" AND c.ReplyUserId IS NOT NULL"); } if (consultationQuery.ProductId > 0) { builder.AppendFormat(" AND p.ProductId = {0}", consultationQuery.ProductId); return builder.ToString(); } if (!string.IsNullOrEmpty(consultationQuery.ProductCode)) { builder.AppendFormat(" AND p.ProductCode LIKE '%{0}%'", DataHelper.CleanSearchString(consultationQuery.ProductCode)); } if (!string.IsNullOrEmpty(consultationQuery.Keywords)) { builder.AppendFormat(" AND p.ProductName LIKE '%{0}%'", DataHelper.CleanSearchString(consultationQuery.Keywords)); } if (consultationQuery.CategoryId.HasValue) { builder.AppendFormat(" AND (p.CategoryId = {0}", consultationQuery.CategoryId.Value); builder.AppendFormat(" OR p.CategoryId IN (SELECT CategoryId FROM Hishop_Categories WHERE Path LIKE (SELECT Path FROM Hishop_Categories WHERE CategoryId = {0}) + '%'))", consultationQuery.CategoryId.Value); } if (!string.IsNullOrEmpty(consultationQuery.SortBy)) { builder.AppendFormat(" ORDER BY {0} {1}", DataHelper.CleanSearchString(consultationQuery.SortBy), consultationQuery.SortOrder.ToString()); } return builder.ToString(); }
static string BuildConsultationAndReplyQuery(ProductConsultationAndReplyQuery query) { StringBuilder builder = new StringBuilder(); builder.Append(" SELECT ConsultationId FROM Hishop_ProductConsultations "); builder.Append(" WHERE 1 = 1"); if (query.ProductId > 0) { builder.AppendFormat(" AND ProductId = {0} ", query.ProductId); } if (query.UserId > 0) { builder.AppendFormat(" AND UserId = {0} ", query.UserId); } if (query.Type == ConsultationReplyType.NoReply) { builder.Append(" AND ReplyUserId IS NULL"); } else if (query.Type == ConsultationReplyType.Replyed) { builder.Append(" AND ReplyUserId IS NOT NULL"); } builder.Append(" ORDER BY replydate DESC"); return builder.ToString(); }
public override DbQueryResult GetConsultationProducts(ProductConsultationAndReplyQuery consultationQuery) { DbQueryResult result = new DbQueryResult(); DbCommand storedProcCommand = database.GetStoredProcCommand("cp_ProductConsultation_Get"); database.AddInParameter(storedProcCommand, "PageIndex", DbType.Int32, consultationQuery.PageIndex); database.AddInParameter(storedProcCommand, "PageSize", DbType.Int32, consultationQuery.PageSize); database.AddInParameter(storedProcCommand, "IsCount", DbType.Boolean, consultationQuery.IsCount); if (consultationQuery.CategoryId.HasValue) { database.AddInParameter(storedProcCommand, "CategoryId", DbType.Int32, consultationQuery.CategoryId.Value); } database.AddInParameter(storedProcCommand, "SqlPopulate", DbType.String, BuildProductConsultationQuery(consultationQuery)); using (IDataReader reader = database.ExecuteReader(storedProcCommand)) { result.Data = DataHelper.ConverDataReaderToDataTable(reader); if (consultationQuery.IsCount && reader.NextResult()) { reader.Read(); result.TotalRecords = reader.GetInt32(0); } } return result; }
public override DataSet GetProductConsultationsAndReplys(ProductConsultationAndReplyQuery query, out int total) { DbCommand storedProcCommand = database.GetStoredProcCommand("ac_Member_ConsultationsAndReplys_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, "sqlPopulate", DbType.String, BuildConsultationAndReplyQuery(query)); database.AddOutParameter(storedProcCommand, "Total", DbType.Int32, 4); DataSet set = database.ExecuteDataSet(storedProcCommand); set.Relations.Add("ConsultationReplys", set.Tables[0].Columns["ConsultationId"], set.Tables[1].Columns["ConsultationId"], false); total = (int)database.GetParameterValue(storedProcCommand, "Total"); return set; }
public abstract DbQueryResult GetConsultationProducts(ProductConsultationAndReplyQuery consultationQuery);
public abstract DataSet GetProductConsultationsAndReplys(ProductConsultationAndReplyQuery query, out int total);
public static DataSet GetProductConsultationsAndReplys(ProductConsultationAndReplyQuery query, out int total) { return CommentDataProvider.Instance().GetProductConsultationsAndReplys(query, out total); }