public ActionResult ModifyConsultReply([DataSourceRequest] DataSourceRequest request, ProductConsultModel model) { var service = new ProductConsultService(); service.ModifyConsultReply(DataTransfer.Transfer<Product_Consult>(model, typeof(ProductConsultModel))); return Json(new[] { model }.ToDataSourceResult(request, ModelState)); }
public ActionResult GetProductBrandByCategoryId(string CategoryId) { List<SelectListItem> items = new List<SelectListItem>(); var service = new ProductConsultService(); var listCategories = service.QueryProductBrandByCategoryId(Convert.ToInt32(CategoryId)); if (listCategories == null) return Json(null,JsonRequestBehavior.AllowGet); foreach (var productCategory in listCategories) { var item = new SelectListItem() { Text = productCategory.BrandName, Value = productCategory.ID.ToString() }; items.Add(item); } return Json(items, JsonRequestBehavior.AllowGet); }
public ActionResult QueryConsultReplies([DataSourceRequest] DataSourceRequest request, ProductConsultSearchModel searchModel, string fromDateTime, string toDateTime) { var service = new ProductConsultService(); string searchStr = this.BuildConsultSearchString(searchModel, fromDateTime, toDateTime); int rowCount = 0, pageCount = 0; var paging = new Paging(searchStr, request.Page, request.PageSize); var list = service.QueryConsultReplies(paging, out pageCount, out rowCount); if (list != null) { var modelList = new List<ProductConsultModel>(); foreach (var consult in list) { modelList.Add(DataTransfer.Transfer<ProductConsultModel>(consult, typeof(Product_Consult))); } var dataSource = new DataSource() { Data = modelList, Total = rowCount, TotalPages = pageCount }; return Json(dataSource, JsonRequestBehavior.AllowGet); } return Json(null); }
public ActionResult GetParentProductCategories() { var service = new ProductConsultService(); var listCategories = service.QueryParentProductCategories(); return Json(listCategories, JsonRequestBehavior.AllowGet); }
private string BuildConsultSearchString(ProductConsultSearchModel model, string fromDateTime, string toDateTime) { StringBuilder sb=new StringBuilder(); const string selectStr = " productID in (Select ID ProductID from Product where "; #region 如果用户选了类别 if (model.ParentCategoryID > 0 && model.CategoryID > 0) { // 若选择了二级分类 if (model.BrandId > 0) { sb.Append("ProductBrandID in (").Append(model.BrandId).Append(")"); } else { sb.Append("ProductCategoryID in (").Append(model.CategoryID).Append(")"); } } else if (model.ParentCategoryID > 0 && model.CategoryID <= 0) { // 若没有选择二级分类 var service = new ProductConsultService(); var list = service.QuerySubCategoriesByParentId(model.ParentCategoryID); sb.Append("ProductCategoryID in ("); if (list != null && list.Count > 0) { // 有一级分类和二级分类 foreach (var category in list) { sb.Append(category.ID).Append(","); } sb.Remove(sb.Length - 1, 1); // 去除最后一个"," } else { // 只有一级分类,没有二级分类,则将0作为子分类的ID号 sb.Append("0"); } sb.Append(")"); // 添加”)“结束 } if (sb.Length > 0) { sb.Insert(0, selectStr).Append(")"); // 加上头部和尾部 } #endregion if (!string.IsNullOrWhiteSpace(model.ProductName)) { sb.Append( sb.Length > 0 ? " And ProductName like '%" + model.ProductName + "%'" : " ProductName like '%" + model.ProductName + "%'"); } if (!string.IsNullOrWhiteSpace(model.UserName)) { sb.Append( sb.Length > 0 ? " And UserName like '%" + model.UserName + "%'" : " UserName like '%" + model.UserName + "%'"); } if (!string.IsNullOrWhiteSpace(fromDateTime)) { sb.Append( sb.Length > 0 ? " And ConsultTime >= '" + fromDateTime + "'" : " ConsultTime >= '" + fromDateTime + "'"); } if (!string.IsNullOrWhiteSpace(toDateTime)) { sb.Append( sb.Length > 0 ? " And ConsultTime <= '" + toDateTime + "'" : " ConsultTime <= '" + toDateTime + "'"); } return sb.ToString(); }
public ActionResult RemoveProductConsultReply([DataSourceRequest] DataSourceRequest request, ProductConsultModel model) { var service = new ProductConsultService(); service.RemoveConsultReply(model.ID); return Json(null); }
public JsonResult GetProductConsult(int productID, int pageIndex, int pageSize) { try { var paging = new Paging("ProductID = " + productID, pageIndex, pageSize); int pageCount, totalCount; var comment = new ProductConsultService().QueryConsultReplies(paging, out pageCount, out totalCount); return this.Json(new { data = comment, rowsCount = totalCount }); } catch (Exception exception) { throw new Exception(exception.Message); } }
/// <summary> /// 根据父品牌编码查询子品牌数据 /// </summary> /// <param name="parentBrandId"> /// 父品牌编码 /// </param> /// <returns> /// 查询结果 /// </returns> public ActionResult QuerySubProductBrandByParentId(int parentBrandId) { var items = new List<SelectListItem>(); var service = new ProductConsultService(); var listSubBrand = service.QuerySubProductBrandByParentId(parentBrandId); if (listSubBrand == null) { return Json(null, JsonRequestBehavior.AllowGet); } foreach (var brand in listSubBrand) { var item = new SelectListItem() { Text = brand.BrandName, Value = brand.ID.ToString() }; items.Add(item); } return Json(items, JsonRequestBehavior.AllowGet); }
public ActionResult Advisory(string condition, int pageIndex = 1, int pageSize = 5) { ViewBag.searchText = condition; var service = new ProductConsultService(); int rowCount, pageCount; if (string.IsNullOrWhiteSpace(condition)) { condition = "[UserID] = " + this.UserSession.UserID; } else { condition = "[UserID] = " + this.UserSession.UserID + " And (Content like '%" + condition + "%' Or ConsultContent like '%" + condition + "%' Or ProductName like '%" + condition + "%')"; } var paging = new Paging("[view_Product_Consults_All]", null, "ID", condition, pageIndex, pageSize); var list = service.QueryConsult(paging, out pageCount, out rowCount); ViewBag.pageCount = pageCount; ViewBag.pageIndex = pageIndex; return this.View(list); }