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);
}
