/// <summary>
/// 商品评价列表
/// </summary>
public ActionResult ProductReviewList(string storeName, string message, string rateStartTime, string rateEndTime, string sortColumn, string sortDirection, int storeId = -1, int pid = 0, int pageNumber = 1, int pageSize = 15)
{
string condition = AdminProductReviews.AdminGetProductReviewListCondition(storeId, pid, message, rateStartTime, rateEndTime);
string sort = AdminProductReviews.AdminGetProductReviewListSort(sortColumn, sortDirection);
PageModel pageModel = new PageModel(pageSize, pageNumber, AdminProductReviews.AdminGetProductReviewCount(condition));
ProductReviewListModel model = new ProductReviewListModel()
{
PageModel = pageModel,
SortColumn = sortColumn,
SortDirection = sortDirection,
ProductReviewList = AdminProductReviews.AdminGetProductReviewList(pageModel.PageSize, pageModel.PageNumber, condition, sort),
StoreId = storeId,
StoreName = string.IsNullOrWhiteSpace(storeName) ? "全部店铺" : storeName,
Pid = pid,
Message = message,
StartTime = rateStartTime,
EndTime = rateEndTime
};
MallUtils.SetAdminRefererCookie(string.Format("{0}?pageNumber={1}&pageSize={2}&sortColumn={3}&sortDirection={4}&storeId={5}&storeName={6}&pid={7}&message={8}&startTime={9}&endTime={10}",
Url.Action("productreviewlist"),
pageModel.PageNumber, pageModel.PageSize,
sortColumn, sortDirection,
storeId, storeName, pid,
message, rateStartTime, rateEndTime));
return View(model);
}
/// <summary>
/// 优惠劵类型列表
/// </summary>
/// <param name="couponTypeName">优惠劵类型名称</param>
/// <param name="type">类型0代表正在发放，1代表正在使用，-1代表全部</param>
/// <param name="pageNumber">当前页数</param>
/// <param name="pageSize">每页数</param>
/// <returns></returns>
public ActionResult CouponTypeList(string couponTypeName, int type = -1, int pageNumber = 1, int pageSize = 15)
{
if (!SecureHelper.IsSafeSqlString(couponTypeName)) couponTypeName = "";
string condition = AdminCoupons.AdminGetCouponTypeListCondition(WorkContext.StoreId, type, couponTypeName);
PageModel pageModel = new PageModel(pageSize, pageNumber, AdminCoupons.AdminGetCouponTypeCount(condition));
CouponTypeListModel model = new CouponTypeListModel()
{
CouponTypeList = AdminCoupons.AdminGetCouponTypeList(pageModel.PageSize, pageModel.PageNumber, condition),
PageModel = pageModel,
Type = type,
CouponTypeName = couponTypeName
};
List<SelectListItem> itemList = new List<SelectListItem>();
itemList.Add(new SelectListItem() { Text = "全部", Value = "-1" });
itemList.Add(new SelectListItem() { Text = "正在发放", Value = "0" });
itemList.Add(new SelectListItem() { Text = "正在使用", Value = "1" });
ViewData["typeList"] = itemList;
MallUtils.SetAdminRefererCookie(string.Format("{0}?pageNumber={1}&pageSize={2}&CouponTypeName={3}&type={4}",
Url.Action("coupontypelist"),
pageModel.PageNumber, pageModel.PageSize,
couponTypeName, type));
return View(model);
}
/// <summary>
/// 下架商品列表
/// </summary>
/// <param name="storeName">店铺名称</param>
/// <param name="productName">商品名称</param>
/// <param name="categoryName">分类名称</param>
/// <param name="brandName">品牌名称</param>
/// <param name="storeId">店铺id</param>
/// <param name="cateId">分类id</param>
/// <param name="brandId">品牌id</param>
/// <param name="pageNumber">当前页数</param>
/// <param name="pageSize">每页数</param>
/// <returns></returns>
public ActionResult OutSaleProductList(string storeName, string productName, string categoryName, string brandName, string sortColumn, string sortDirection, int storeId = -1, int cateId = -1, int brandId = -1, int pageNumber = 1, int pageSize = 15)
{
string condition = AdminProducts.AdminGetProductListCondition(storeId, 0, productName, cateId, brandId, (int)ProductState.OutSale);
string sort = AdminProducts.AdminGetProductListSort(sortColumn, sortDirection);
PageModel pageModel = new PageModel(pageSize, pageNumber, AdminProducts.AdminGetProductCount(condition));
ProductListModel model = new ProductListModel()
{
ProductList = AdminProducts.AdminGetProductList(pageModel.PageSize, pageModel.PageNumber, condition, sort),
PageModel = pageModel,
SortColumn = sortColumn,
SortDirection = sortDirection,
StoreId = storeId,
ProductName = productName,
CateId = cateId,
BrandId = brandId,
StoreName = string.IsNullOrWhiteSpace(storeName) ? "全部店铺" : storeName,
CategoryName = string.IsNullOrWhiteSpace(categoryName) ? "全部分类" : categoryName,
BrandName = string.IsNullOrWhiteSpace(brandName) ? "全部品牌" : brandName
};
MallUtils.SetAdminRefererCookie(string.Format("{0}?pageNumber={1}&pageSize={2}&sortColumn={3}&sortDirection={4}&storeId={5}&ProductName={6}&cateId={7}&brandId={8}&storeName={9}&categoryName={10}&brandName={11}",
Url.Action("outsaleproductlist"),
pageModel.PageNumber, pageModel.PageSize,
sortColumn, sortDirection,
storeId, productName, cateId, brandId,
storeName, categoryName, brandName));
return View(model);
}
/// <summary>
/// 活动专题列表
/// </summary>
public ActionResult List(string topicSN, string topicTitle, string startTime, string endTime, string sortColumn, string sortDirection, int pageSize = 15, int pageNumber = 1)
{
string condition = AdminTopic.AdminGetTopicListCondition(topicSN, topicTitle, startTime, endTime);
string sort = AdminTopic.AdminGetTopicListSort(sortColumn, sortDirection);
PageModel pageModel = new PageModel(pageSize, pageNumber, AdminTopic.AdminGetTopicCount(condition));
TopicListModel model = new TopicListModel()
{
TopicList = AdminTopic.AdminGetTopicList(pageModel.PageSize, pageModel.PageNumber, condition, sort),
PageModel = pageModel,
SortColumn = sortColumn,
SortDirection = sortDirection,
TopicTitle = topicTitle,
StartTime = startTime,
EndTime = endTime
};
MallUtils.SetAdminRefererCookie(string.Format("{0}?pageNumber={1}&pageSize={2}&sortColumn={3}&sortDirection={4}&topicSN={5}&topicTitle={6}&startTime={7}&endTime={8}",
Url.Action("list"),
pageModel.PageNumber,
pageModel.PageSize,
sortColumn,
sortDirection,
topicSN,
topicTitle,
startTime,
endTime));
return View(model);
}
/// <summary>
/// 商品评价列表
/// </summary>
public ActionResult ProductReviewList(string productName, string message, string rateStartTime, string rateEndTime, string sortColumn, string sortDirection, int pid = -1, int pageNumber = 1, int pageSize = 15)
{
if (!SecureHelper.IsSafeSqlString(message)) message = "";
if (!SecureHelper.IsSafeSqlString(rateStartTime)) rateStartTime = "";
if (!SecureHelper.IsSafeSqlString(rateEndTime)) rateEndTime = "";
if (!SecureHelper.IsSafeSqlString(sortColumn)) sortColumn = "";
if (!SecureHelper.IsSafeSqlString(sortDirection)) sortDirection = "";
string condition = AdminProductReviews.AdminGetProductReviewListCondition(WorkContext.StoreId, pid, message, rateStartTime, rateEndTime);
string sort = AdminProductReviews.AdminGetProductReviewListSort(sortColumn, sortDirection);
PageModel pageModel = new PageModel(pageSize, pageNumber, AdminProductReviews.AdminGetProductReviewCount(condition));
ProductReviewListModel model = new ProductReviewListModel()
{
PageModel = pageModel,
SortColumn = sortColumn,
SortDirection = sortDirection,
ProductReviewList = AdminProductReviews.AdminGetProductReviewList(pageModel.PageSize, pageModel.PageNumber, condition, sort),
Pid = pid,
ProductName = string.IsNullOrWhiteSpace(productName) ? "选择商品" : productName,
Message = message,
StartTime = rateStartTime,
EndTime = rateEndTime
};
MallUtils.SetAdminRefererCookie(string.Format("{0}?pageNumber={1}&pageSize={2}&sortColumn={3}&sortDirection={4}&message={5}&pid={6}&productName={7}&startTime={8}&endTime={9}",
Url.Action("productreviewlist"),
pageModel.PageNumber, pageModel.PageSize,
sortColumn, sortDirection,
message,
pid, productName,
rateStartTime, rateEndTime));
return View(model);
}
/// <summary>
/// 优惠劵类型列表
/// </summary>
/// <param name="storeName">店铺名称</param>
/// <param name="couponTypeName">优惠劵类型名称</param>
/// <param name="storeId">店铺id</param>
/// <param name="type">类型0代表正在发放，1代表正在使用，-1代表全部</param>
/// <param name="pageNumber">当前页数</param>
/// <param name="pageSize">每页数</param>
/// <returns></returns>
public ActionResult CouponTypeList(string storeName, string couponTypeName, int storeId = -1, int type = -1, int pageNumber = 1, int pageSize = 15)
{
string condition = AdminCoupons.AdminGetCouponTypeListCondition(storeId, type, couponTypeName);
PageModel pageModel = new PageModel(pageSize, pageNumber, AdminCoupons.AdminGetCouponTypeCount(condition));
CouponTypeListModel model = new CouponTypeListModel()
{
CouponTypeList = AdminCoupons.AdminGetCouponTypeList(pageModel.PageSize, pageModel.PageNumber, condition),
PageModel = pageModel,
StoreId = storeId,
StoreName = string.IsNullOrWhiteSpace(storeName) ? "全部店铺" : storeName,
Type = type,
CouponTypeName = couponTypeName
};
List<SelectListItem> itemList = new List<SelectListItem>();
itemList.Add(new SelectListItem() { Text = "全部", Value = "-1" });
itemList.Add(new SelectListItem() { Text = "正在发放", Value = "0" });
itemList.Add(new SelectListItem() { Text = "正在使用", Value = "1" });
ViewData["typeList"] = itemList;
MallUtils.SetAdminRefererCookie(string.Format("{0}?pageNumber={1}&pageSize={2}&storeId={3}&storeName={4}&CouponTypeName={5}&type={6}",
Url.Action("coupontypelist"),
pageModel.PageNumber, pageModel.PageSize,
storeId, storeName, couponTypeName, type));
return View(model);
}
/// <summary>
/// 单品促销活动列表
/// </summary>
/// <param name="storeName">店铺名称</param>
/// <param name="promotionName">活动名称</param>
/// <param name="promotionTime">活动时间</param>
/// <param name="storeId">店铺id</param>
/// <param name="pid">商品id</param>
/// <returns></returns>
public ActionResult SinglePromotionList(string storeName, string promotionName, string promotionTime, string sortColumn, string sortDirection, int storeId = -1, int pid = -1, int pageSize = 15, int pageNumber = 1)
{
string condition = AdminPromotions.AdminGetSinglePromotionListCondition(storeId, pid, promotionName, promotionTime);
string sort = AdminPromotions.AdminGetSinglePromotionListSort(sortColumn, sortDirection);
PageModel pageModel = new PageModel(pageSize, pageNumber, AdminPromotions.AdminGetSinglePromotionCount(condition));
SinglePromotionListModel model = new SinglePromotionListModel()
{
SinglePromotionList = AdminPromotions.AdminGetSinglePromotionList(pageModel.PageSize, pageModel.PageNumber, condition, sort),
PageModel = pageModel,
SortColumn = sortColumn,
SortDirection = sortDirection,
StoreId = storeId,
StoreName = string.IsNullOrWhiteSpace(storeName) ? "全部店铺" : storeName,
Pid = pid,
PromotionName = promotionName,
PromotionTime = promotionTime
};
MallUtils.SetAdminRefererCookie(string.Format("{0}?pageNumber={1}&pageSize={2}&sortColumn={3}&sortDirection={4}&storeId={5}&storeName={6}&pid={7}&promotionName={8}&promotionTime={9}",
Url.Action("singlepromotionlist"),
pageModel.PageNumber, pageModel.PageSize,
sortColumn, sortDirection,
storeId, storeName, pid, promotionName, promotionTime));
return View(model);
}
/// <summary>
/// 单品促销活动列表
/// </summary>
/// <param name="productName">商品名称</param>
/// <param name="promotionName">活动名称</param>
/// <param name="promotionTime">活动时间</param>
/// <param name="pid">商品id</param>
public ActionResult SinglePromotionList(string productName, string promotionName, string promotionTime, string sortColumn, string sortDirection, int pid = -1, int pageSize = 15, int pageNumber = 1)
{
if (!SecureHelper.IsSafeSqlString(promotionName)) promotionName = "";
if (!SecureHelper.IsSafeSqlString(promotionTime)) promotionTime = "";
if (!SecureHelper.IsSafeSqlString(sortColumn)) sortColumn = "";
if (!SecureHelper.IsSafeSqlString(sortDirection)) sortDirection = "";
string condition = AdminPromotions.AdminGetSinglePromotionListCondition(WorkContext.StoreId, pid, promotionName, promotionTime);
string sort = AdminPromotions.AdminGetSinglePromotionListSort(sortColumn, sortDirection);
PageModel pageModel = new PageModel(pageSize, pageNumber, AdminPromotions.AdminGetSinglePromotionCount(condition));
SinglePromotionListModel model = new SinglePromotionListModel()
{
SinglePromotionList = AdminPromotions.AdminGetSinglePromotionList(pageModel.PageSize, pageModel.PageNumber, condition, sort),
PageModel = pageModel,
SortColumn = sortColumn,
SortDirection = sortDirection,
Pid = pid,
ProductName = string.IsNullOrWhiteSpace(productName) ? "选择商品" : productName,
PromotionName = promotionName,
PromotionTime = promotionTime
};
MallUtils.SetAdminRefererCookie(string.Format("{0}?pageNumber={1}&pageSize={2}&sortColumn={3}&sortDirection={4}&pid={5}&productName={6}&promotionName={7}&promotionTime={8}",
Url.Action("singlepromotionlist"),
pageModel.PageNumber,
pageModel.PageSize,
sortColumn, sortDirection,
pid, productName, promotionName, promotionTime));
return View(model);
}
/// <summary>
/// 配送公司列表
/// </summary>
/// <param name="pageSize">每页数</param>
/// <param name="pageNumber">当前页数</param>
/// <returns></returns>
public ActionResult List(int pageSize = 15, int pageNumber = 1)
{
PageModel pageModel = new PageModel(pageSize, pageNumber, AdminShipCompanies.GetShipCompanyCount());
ShipCompanyListModel model = new ShipCompanyListModel()
{
ShipCompanyList = AdminShipCompanies.GetShipCompanyList(pageModel.PageSize, pageModel.PageNumber),
PageModel = pageModel
};
MallUtils.SetAdminRefererCookie(string.Format("{0}?pageNumber={1}&pageSize={2}",
Url.Action("list"),
pageModel.PageNumber,
pageModel.PageSize));
return View(model);
}
/// <summary>
/// 配送公司选择列表
/// </summary>
/// <param name="pageSize">每页数</param>
/// <param name="pageNumber">当前页数</param>
/// <returns></returns>
public ActionResult SelectList(int pageSize = 15, int pageNumber = 1)
{
PageModel pageModel = new PageModel(pageSize, pageNumber, AdminShipCompanies.GetShipCompanyCount());
List<ShipCompanyInfo> shipCompanyList = AdminShipCompanies.GetShipCompanyList(pageModel.PageSize, pageModel.PageNumber);
StringBuilder result = new StringBuilder("{");
result.AppendFormat("\"totalPages\":\"{0}\",\"pageNumber\":\"{1}\",\"items\":[", pageModel.TotalPages, pageModel.PageNumber);
foreach (ShipCompanyInfo shipCompanyInfo in shipCompanyList)
result.AppendFormat("{0}\"id\":\"{1}\",\"name\":\"{2}\"{3},", "{", shipCompanyInfo.ShipCoId, shipCompanyInfo.Name, "}");
if (shipCompanyList.Count > 0)
result.Remove(result.Length - 1, 1);
result.Append("]}");
return Content(result.ToString());
}
private RouteValueDictionary _routevalues = new RouteValueDictionary();//路由值集合
public WebPager(PageModel pageModel, ViewContext viewContext)
: base(pageModel)
{
_viewcontext = viewContext;
NameValueCollection queryString = _viewcontext.RequestContext.HttpContext.Request.QueryString;
foreach (string key in queryString.AllKeys)
{
if (key != null)
_routevalues.Add(key, queryString[key]);
}
if (!_routevalues.ContainsKey(_pageparamname))
_routevalues.Add(_pageparamname, 1);
}
/// <summary>
/// 订单列表
/// </summary>
/// <param name="osn">订单编号</param>
/// <param name="accountName">账户名</param>
/// <param name="consignee">收货人</param>
/// <param name="orderState">订单状态</param>
/// <param name="pageSize">每页数</param>
/// <param name="pageNumber">当前页数</param>
/// <returns></returns>
public ActionResult OrderList(string osn, string accountName, string consignee, string sortColumn, string sortDirection, int orderState = 0, int pageSize = 15, int pageNumber = 1)
{
if (!SecureHelper.IsSafeSqlString(osn)) osn = "";
if (!SecureHelper.IsSafeSqlString(consignee)) consignee = "";
if (!SecureHelper.IsSafeSqlString(sortColumn)) sortColumn = "";
if (!SecureHelper.IsSafeSqlString(sortDirection)) sortDirection = "";
//获取用户id
int uid = Users.GetUidByAccountName(accountName);
string condition = AdminOrders.GetOrderListCondition(WorkContext.StoreId, osn, uid, consignee, orderState);
string sort = AdminOrders.GetOrderListSort(sortColumn, sortDirection);
PageModel pageModel = new PageModel(pageSize, pageNumber, AdminOrders.GetOrderCount(condition));
OrderListModel model = new OrderListModel()
{
OrderList = AdminOrders.GetOrderList(pageModel.PageSize, pageModel.PageNumber, condition, sort),
PageModel = pageModel,
SortColumn = sortColumn,
SortDirection = sortDirection,
OSN = osn,
AccountName = accountName,
Consignee = consignee,
OrderState = orderState
};
MallUtils.SetAdminRefererCookie(string.Format("{0}?pageNumber={1}&pageSize={2}&sortColumn={3}&sortDirection={4}&OSN={5}&AccountName={6}&Consignee={7}&OrderState={8}",
Url.Action("orderlist"),
pageModel.PageNumber,
pageModel.PageSize,
sortColumn, sortDirection,
osn, accountName, consignee, orderState));
List<SelectListItem> itemList = new List<SelectListItem>();
itemList.Add(new SelectListItem() { Text = "全部", Value = "0" });
itemList.Add(new SelectListItem() { Text = "已提交", Value = ((int)OrderState.Submitted).ToString() });
itemList.Add(new SelectListItem() { Text = "等待付款", Value = ((int)OrderState.WaitPaying).ToString() });
itemList.Add(new SelectListItem() { Text = "待确认", Value = ((int)OrderState.Confirming).ToString() });
itemList.Add(new SelectListItem() { Text = "已确认", Value = ((int)OrderState.Confirmed).ToString() });
itemList.Add(new SelectListItem() { Text = "备货中", Value = ((int)OrderState.PreProducting).ToString() });
itemList.Add(new SelectListItem() { Text = "已发货", Value = ((int)OrderState.Sended).ToString() });
itemList.Add(new SelectListItem() { Text = "已完成", Value = ((int)OrderState.Completed).ToString() });
itemList.Add(new SelectListItem() { Text = "已锁定", Value = ((int)OrderState.Locked).ToString() });
itemList.Add(new SelectListItem() { Text = "已取消", Value = ((int)OrderState.Cancelled).ToString() });
itemList.Add(new SelectListItem() { Text = "已退货", Value = ((int)OrderState.Returned).ToString() });
ViewData["orderStateList"] = itemList;
return View(model);
}
/// <summary>
/// banner列表
/// </summary>
public ActionResult List(int pageSize = 15, int pageNumber = 1)
{
PageModel pageModel = new PageModel(pageSize, pageNumber, AdminBanners.AdminGetBannerCount());
BannerListModel model = new BannerListModel()
{
PageModel = pageModel,
BannerList = AdminBanners.AdminGetBannerList(pageSize, pageNumber)
};
MallUtils.SetAdminRefererCookie(string.Format("{0}?pageNumber={1}&pageSize={2}",
Url.Action("list"),
pageModel.PageNumber,
pageModel.PageSize));
return View(model);
}
/// <summary>
/// 广告位置列表
/// </summary>
public ActionResult AdvertPositionList(int pageSize = 15, int pageNumber = 1)
{
PageModel pageModel = new PageModel(pageSize, pageNumber, AdminAdverts.GetAdvertPositionCount());
AdvertPositionListModel model = new AdvertPositionListModel()
{
PageModel = pageModel,
AdvertPositionList = AdminAdverts.GetAdvertPositionList(pageSize, pageNumber)
};
MallUtils.SetAdminRefererCookie(string.Format("{0}?pageNumber={1}&pageSize={2}",
Url.Action("advertpositionlist"),
pageModel.PageNumber,
pageModel.PageSize));
return View(model);
}
/// <summary>
/// 店铺列表
/// </summary>
public ActionResult StoreList(string storeName, string sortColumn, string sortDirection, int storeRid = 0, int storeIid = 0, int state = -1, int pageNumber = 1, int pageSize = 15)
{
string condition = AdminStores.AdminGetStoreListCondition(storeName, storeRid, storeIid, state);
string sort = AdminStores.AdminGetStoreListSort(sortColumn, sortDirection);
PageModel pageModel = new PageModel(pageSize, pageNumber, AdminStores.AdminGetStoreCount(condition));
StoreListModel model = new StoreListModel()
{
StoreList = AdminStores.AdminGetStoreList(pageModel.PageSize, pageModel.PageNumber, condition, sort),
PageModel = pageModel,
SortColumn = sortColumn,
SortDirection = sortDirection,
StoreName = storeName,
StoreRid = storeRid,
StoreIid = storeIid,
State = state
};
List<SelectListItem> storeRankList = new List<SelectListItem>();
storeRankList.Add(new SelectListItem() { Text = "全部等级", Value = "0" });
foreach (StoreRankInfo storeRankInfo in AdminStoreRanks.GetStoreRankList())
{
storeRankList.Add(new SelectListItem() { Text = storeRankInfo.Title, Value = storeRankInfo.StoreRid.ToString() });
}
ViewData["storeRankList"] = storeRankList;
List<SelectListItem> storeIndustryList = new List<SelectListItem>();
storeIndustryList.Add(new SelectListItem() { Text = "全部行业", Value = "0" });
foreach (StoreIndustryInfo storeIndustryInfo in AdminStoreIndustries.GetStoreIndustryList())
{
storeIndustryList.Add(new SelectListItem() { Text = storeIndustryInfo.Title, Value = storeIndustryInfo.StoreIid.ToString() });
}
ViewData["storeIndustryList"] = storeIndustryList;
List<SelectListItem> storeStateList = new List<SelectListItem>();
storeStateList.Add(new SelectListItem() { Text = "全部", Value = "-1" });
storeStateList.Add(new SelectListItem() { Text = "营业", Value = ((int)StoreState.Open).ToString() });
storeStateList.Add(new SelectListItem() { Text = "关闭", Value = ((int)StoreState.Close).ToString() });
ViewData["storeStateList"] = storeStateList;
MallUtils.SetAdminRefererCookie(string.Format("{0}?pageNumber={1}&pageSize={2}&sortColumn={3}&sortDirection={4}&storeName={5}&storeRid={6}&storeIid={7}&state={8}",
Url.Action("storelist"),
pageModel.PageNumber, pageModel.PageSize,
sortColumn, sortDirection,
storeName, storeRid, storeIid, state));
return View(model);
}
/// <summary>
/// 商品咨询列表
/// </summary>
public ActionResult ProductConsultList(string accountName, string productName, string consultMessage, string consultStartTime, string consultEndTime, string sortColumn, string sortDirection, int pid = -1, int consultTypeId = -1, int pageNumber = 1, int pageSize = 15)
{
if (!SecureHelper.IsSafeSqlString(consultMessage)) consultMessage = "";
if (!SecureHelper.IsSafeSqlString(consultStartTime)) consultStartTime = "";
if (!SecureHelper.IsSafeSqlString(consultEndTime)) consultEndTime = "";
if (!SecureHelper.IsSafeSqlString(sortColumn)) sortColumn = "";
if (!SecureHelper.IsSafeSqlString(sortDirection)) sortDirection = "";
int uid = AdminUsers.GetUidByAccountName(accountName);
string condition = AdminProductConsults.AdminGetProductConsultListCondition(consultTypeId, WorkContext.StoreId, pid, uid, consultMessage, consultStartTime, consultEndTime);
string sort = AdminProductConsults.AdminGetProductConsultListSort(sortColumn, sortDirection);
PageModel pageModel = new PageModel(pageSize, pageNumber, AdminProductConsults.AdminGetProductConsultCount(condition));
ProductConsultListModel model = new ProductConsultListModel()
{
PageModel = pageModel,
SortColumn = sortColumn,
SortDirection = sortDirection,
ProductConsultList = AdminProductConsults.AdminGetProductConsultList(pageModel.PageSize, pageModel.PageNumber, condition, sort),
AccountName = accountName,
Pid = pid,
ProductName = string.IsNullOrWhiteSpace(productName) ? "选择商品" : productName,
ConsultTypeId = consultTypeId,
ConsultMessage = consultMessage,
ConsultStartTime = consultStartTime,
ConsultEndTime = consultEndTime
};
List<SelectListItem> productConsultTypeList = new List<SelectListItem>();
productConsultTypeList.Add(new SelectListItem() { Text = "全部类型", Value = "0" });
foreach (ProductConsultTypeInfo productConsultTypeInfo in AdminProductConsults.GetProductConsultTypeList())
{
productConsultTypeList.Add(new SelectListItem() { Text = productConsultTypeInfo.Title, Value = productConsultTypeInfo.ConsultTypeId.ToString() });
}
ViewData["productConsultTypeList"] = productConsultTypeList;
MallUtils.SetAdminRefererCookie(string.Format("{0}?pageNumber={1}&pageSize={2}&sortColumn={3}&sortDirection={4}&consultMessage={5}&pid={6}&productName={7}&consultStartTime={8}&consultEndTime={9}&consultTypeId={10}&accountName={11}",
Url.Action("productconsultlist"),
pageModel.PageNumber, pageModel.PageSize,
sortColumn, sortDirection,
consultMessage,
pid, productName,
consultStartTime, consultEndTime,
consultTypeId, accountName));
return View(model);
}
/// <summary>
/// 品牌选择列表
/// </summary>
/// <param name="brandName">品牌名称</param>
/// <param name="pageSize">每页数</param>
/// <param name="pageNumber">当前页数</param>
/// <returns></returns>
public ContentResult SelectList(string brandName, int pageNumber = 1, int pageSize = 24)
{
string condition = AdminBrands.AdminGetBrandListCondition(brandName);
PageModel pageModel = new PageModel(pageSize, pageNumber, AdminBrands.AdminGetBrandCount(condition));
DataTable brandSelectList = AdminBrands.AdminGetBrandSelectList(pageModel.PageSize, pageModel.PageNumber, condition);
StringBuilder result = new StringBuilder("{");
result.AppendFormat("\"totalPages\":\"{0}\",\"pageNumber\":\"{1}\",\"items\":[", pageModel.TotalPages, pageModel.PageNumber);
foreach (DataRow row in brandSelectList.Rows)
result.AppendFormat("{0}\"id\":\"{1}\",\"name\":\"{2}\"{3},", "{", row["brandid"], row["name"].ToString().Trim(), "}");
if (brandSelectList.Rows.Count > 0)
result.Remove(result.Length - 1, 1);
result.Append("]}");
return Content(result.ToString());
}
/// <summary>
/// 店铺选择列表
/// </summary>
/// <param name="storeName">店铺名称</param>
/// <param name="pageSize">每页数</param>
/// <param name="pageNumber">当前页数</param>
/// <returns></returns>
public ContentResult StoreSelectList(string storeName, int pageNumber = 1, int pageSize = 12)
{
string condition = AdminStores.AdminGetStoreListCondition(storeName, 0, 0, (int)StoreState.Open);
PageModel pageModel = new PageModel(pageSize, pageNumber, AdminStores.AdminGetStoreCount(condition));
DataTable storeSelectList = AdminStores.AdminGetStoreSelectList(pageModel.PageSize, pageModel.PageNumber, condition);
StringBuilder result = new StringBuilder("{");
result.AppendFormat("\"totalPages\":\"{0}\",\"pageNumber\":\"{1}\",\"items\":[", pageModel.TotalPages, pageModel.PageNumber);
foreach (DataRow row in storeSelectList.Rows)
result.AppendFormat("{0}\"id\":\"{1}\",\"name\":\"{2}\"{3},", "{", row["storeid"], row["name"].ToString().Trim(), "}");
if (storeSelectList.Rows.Count > 0)
result.Remove(result.Length - 1, 1);
result.Append("]}");
return Content(result.ToString());
}
/// <summary>
/// 在售商品列表
/// </summary>
/// <param name="productName">商品名称</param>
/// <param name="categoryName">分类名称</param>
/// <param name="brandName">品牌名称</param>
/// <param name="storeCid">店铺分类id</param>
/// <param name="cateId">分类id</param>
/// <param name="brandId">品牌id</param>
/// <param name="pageNumber">当前页数</param>
/// <param name="pageSize">每页数</param>
/// <returns></returns>
public ActionResult OnSaleProductList(string productName, string categoryName, string brandName, string sortColumn, string sortDirection, int storeCid = -1, int cateId = -1, int brandId = -1, int pageNumber = 1, int pageSize = 15)
{
if (!SecureHelper.IsSafeSqlString(productName)) productName = "";
if (!SecureHelper.IsSafeSqlString(sortColumn)) sortColumn = "";
if (!SecureHelper.IsSafeSqlString(sortDirection)) sortDirection = "";
string condition = AdminProducts.AdminGetProductListCondition(WorkContext.StoreId, storeCid, productName, cateId, brandId, (int)ProductState.OnSale);
string sort = AdminProducts.AdminGetProductListSort(sortColumn, sortDirection);
PageModel pageModel = new PageModel(pageSize, pageNumber, AdminProducts.AdminGetProductCount(condition));
ProductListModel model = new ProductListModel()
{
ProductList = AdminProducts.AdminGetProductList(pageModel.PageSize, pageModel.PageNumber, condition, sort),
PageModel = pageModel,
SortColumn = sortColumn,
SortDirection = sortDirection,
StoreCid = storeCid,
ProductName = productName,
CateId = cateId,
BrandId = brandId,
CategoryName = string.IsNullOrWhiteSpace(categoryName) ? "全部分类" : categoryName,
BrandName = string.IsNullOrWhiteSpace(brandName) ? "全部品牌" : brandName
};
List<SelectListItem> itemList = new List<SelectListItem>();
itemList.Add(new SelectListItem() { Text = "全部分类", Value = "0" });
foreach (StoreClassInfo storeClassInfo in AdminStores.GetStoreClassList(WorkContext.StoreId).FindAll(x => x.HasChild == 0))
{
itemList.Add(new SelectListItem() { Text = storeClassInfo.Name, Value = storeClassInfo.StoreCid.ToString() });
}
ViewData["storeClassList"] = itemList;
MallUtils.SetAdminRefererCookie(string.Format("{0}?pageNumber={1}&pageSize={2}&sortColumn={3}&sortDirection={4}&storeCid={5}&productName={6}&cateId={7}&brandId={8}&categoryName={9}&brandName={10}",
Url.Action("onsaleproductlist"),
pageModel.PageNumber, pageModel.PageSize,
sortColumn, sortDirection,
storeCid, productName,
cateId, brandId,
categoryName, brandName));
return View(model);
}
/// <summary>
/// 店铺管理日志列表
/// </summary>
/// <param name="storeName">店铺名称</param>
/// <param name="operation">操作动作</param>
/// <param name="startTime">操作开始时间</param>
/// <param name="endTime">操作结束时间</param>
/// <param name="storeId">店铺id</param>
/// <param name="pageNumber">当前页数</param>
/// <param name="pageSize">每页数</param>
/// <returns></returns>
public ActionResult StoreAdminLogList(string storeName, string operation, string startTime, string endTime, int storeId = -1, int pageNumber = 1, int pageSize = 15)
{
string condition = StoreAdminLogs.GetStoreAdminLogListCondition(storeId, operation, startTime, endTime);
PageModel pageModel = new PageModel(pageSize, pageNumber, StoreAdminLogs.GetStoreAdminLogCount(condition));
StoreAdminLogListModel model = new StoreAdminLogListModel()
{
StoreAdminLogList = StoreAdminLogs.GetStoreAdminLogList(pageModel.PageSize, pageModel.PageNumber, condition),
PageModel = pageModel,
StoreId = storeId,
StoreName = string.IsNullOrWhiteSpace(storeName) ? "全部店铺" : storeName,
Operation = operation,
StartTime = startTime,
EndTime = endTime
};
MallUtils.SetAdminRefererCookie(string.Format("{0}?pageNumber={1}&pageSize={2}&storeId={3}&storeName={4}&operation={5}&startTime={6}&endTime={7}",
Url.Action("storeadminloglist"),
pageModel.PageNumber,
pageModel.PageSize,
storeId, storeName, operation, startTime, endTime));
return View(model);
}
/// <summary>
/// 筛选词列表
/// </summary>
/// <param name="searchFilterWord">搜索筛选词</param>
/// <param name="pageSize">每页数</param>
/// <param name="pageNumber">当前页数</param>
/// <returns></returns>
public ActionResult List(string searchFilterWord, int pageSize = 15, int pageNumber = 1)
{
List<FilterWordInfo> filterWordList = AdminFilterWords.GetFilterWordList();
if (!string.IsNullOrWhiteSpace(searchFilterWord))
filterWordList = filterWordList.FindAll(x => x.Match.Contains(searchFilterWord));
PageModel pageModel = new PageModel(pageSize, pageNumber, filterWordList.Count);
FilterWordListModel model = new FilterWordListModel()
{
FilterWordList = filterWordList,
PageModel = pageModel,
SearchFilterWord = searchFilterWord
};
MallUtils.SetAdminRefererCookie(string.Format("{0}?pageNumber={1}&pageSize={2}&searchFilterWord={3}",
Url.Action("list"),
pageModel.PageNumber,
pageModel.PageSize,
searchFilterWord));
return View(model);
}
/// <summary>
/// 在线用户列表
/// </summary>
/// <param name="provinceId">省id</param>
/// <param name="cityId">市id</param>
/// <param name="regionId">区/县id</param>
/// <param name="sortColumn">排序列</param>
/// <param name="sortDirection">排序方向</param>
/// <param name="pageNumber">当前页数</param>
/// <param name="pageSize">每页数</param>
/// <returns></returns>
public ActionResult OnlineUserList(string sortColumn, string sortDirection, int provinceId = -1, int cityId = -1, int regionId = -1, int pageNumber = 1, int pageSize = 15)
{
int locationType = 0, locationId = 0;
if (regionId > 0)
{
locationType = 2;
locationId = regionId;
}
else if (cityId > 0)
{
locationType = 1;
locationId = cityId;
}
else if (provinceId > 0)
{
locationType = 0;
locationId = provinceId;
}
string sort = OnlineUsers.GetOnlineUserListSort(sortColumn, sortDirection);
PageModel pageModel = new PageModel(pageSize, pageNumber, OnlineUsers.GetOnlineUserCount(locationType, locationId));
OnlineUserListModel model = new OnlineUserListModel()
{
OnlineUserList = OnlineUsers.GetOnlineUserList(pageModel.PageSize, pageModel.PageNumber, locationType, locationId, sort),
PageModel = pageModel,
SortColumn = sortColumn,
SortDirection = sortDirection,
ProvinceId = provinceId,
CityId = cityId,
RegionId = regionId
};
MallUtils.SetAdminRefererCookie(string.Format("{0}?pageNumber={1}&pageSize={2}&sortColumn={3}&sortDirection={4}&provinceId={5}&cityId={6}®ionId={7}",
Url.Action("onlineuserlist"),
pageModel.PageNumber, pageModel.PageSize,
sortColumn, sortDirection,
provinceId, cityId, regionId));
return View(model);
}
/// <summary>
/// 新闻列表
/// </summary>
public ActionResult List()
{
string newsTitle = WebHelper.GetQueryString("newsTitle");
int newsTypeId = WebHelper.GetQueryInt("newsTypeId");
int page = WebHelper.GetQueryInt("page");
if (!SecureHelper.IsSafeSqlString(newsTitle))
return PromptView(WorkContext.UrlReferrer, "您搜索的新闻不存在");
string condition = News.GetNewsListCondition(newsTypeId, newsTitle);
PageModel pageModel = new PageModel(10, page, News.GetNewsCount(condition));
NewsListModel model = new NewsListModel()
{
PageModel = pageModel,
NewsList = News.GetNewsList(pageModel.PageSize, pageModel.PageNumber, condition),
NewsTitle = newsTitle,
NewsTypeId = newsTypeId,
NewsTypeList = News.GetNewsTypeList()
};
return View(model);
}
/// <summary>
/// 店铺分类
/// </summary>
public ActionResult Class()
{
//店铺分类id
int storeCid = GetRouteInt("storeCid");
if (storeCid == 0)
storeCid = WebHelper.GetQueryInt("storeCid");
//排序列
int sortColumn = GetRouteInt("sortColumn");
if (sortColumn == 0)
sortColumn = WebHelper.GetQueryInt("sortColumn");
//排序方向
int sortDirection = GetRouteInt("sortDirection");
if (sortDirection == 0)
sortDirection = WebHelper.GetQueryInt("sortDirection");
//当前页数
int page = GetRouteInt("page");
if (page == 0)
page = WebHelper.GetQueryInt("page");
//店铺分类信息
StoreClassInfo storeClassInfo = Stores.GetStoreClassByStoreIdAndStoreCid(WorkContext.StoreId, storeCid);
if (storeClassInfo == null)
return View("~/views/shared/prompt.cshtml", new PromptModel("/", "此店铺分类不存在"));
//分页对象
PageModel pageModel = new PageModel(20, page, Products.GetStoreClassProductCount(storeCid, 0, 0));
//视图对象
StoreClassModel model = new StoreClassModel()
{
StoreCid = storeCid,
SortColumn = sortColumn,
SortDirection = sortDirection,
PageModel = pageModel,
ProductList = Products.GetStoreClassProductList(pageModel.PageSize, pageModel.PageNumber, storeCid, 0, 0, sortColumn, sortDirection),
StoreClassInfo = storeClassInfo
};
return View(model);
}
/// <summary>
/// 用户列表
/// </summary>
public ActionResult List(string userName, string email, string mobile, int userRid = 0, int mallAGid = 0,
int pageNumber = 1, int pageSize = 15)
{
string condition = AdminUsers.AdminGetUserListCondition(userName, email, mobile, userRid, mallAGid);
string sort = AdminUsers.AdminGetUserListSort("", "");
PageModel pageModel = new PageModel(pageSize, pageNumber, AdminUsers.AdminGetUserCount(condition));
UserListModel model = new UserListModel()
{
UserList = AdminUsers.AdminGetUserList(pageModel.PageSize, pageModel.PageNumber, condition, sort),
PageModel = pageModel,
UserName = userName,
Email = email,
Mobile = mobile,
UserRid = userRid,
MallAGid = mallAGid
};
List<SelectListItem> userRankList = new List<SelectListItem>();
userRankList.Add(new SelectListItem() { Text = "全部等级", Value = "0" });
foreach (UserRankInfo info in AdminUserRanks.GetUserRankList())
{
userRankList.Add(new SelectListItem() { Text = info.Title, Value = info.UserRid.ToString() });
}
ViewData["userRankList"] = userRankList;
List<SelectListItem> mallAdminGroupList = new List<SelectListItem>();
mallAdminGroupList.Add(new SelectListItem() { Text = "全部组", Value = "0" });
foreach (MallAdminGroupInfo info in MallAdminGroups.GetMallAdminGroupList())
{
mallAdminGroupList.Add(new SelectListItem() { Text = info.Title, Value = info.MallAGid.ToString() });
}
ViewData["mallAdminGroupList"] = mallAdminGroupList;
MallUtils.SetAdminRefererCookie(string.Format("{0}?pageNumber={1}&pageSize={2}&userName={3}&email={4}&mobile={5}&userRid={6}&mallAGid={7}",
Url.Action("list"), pageModel.PageNumber, pageModel.PageSize,
userName, email, mobile, userRid, mallAGid));
return View(model);
}
/// <summary>
/// 禁止IP列表
/// </summary>
/// <param name="ip">ip</param>
/// <param name="sortOptions">排序</param>
/// <param name="pageSize">每页数</param>
/// <param name="pageNumber">当前页数</param>
/// <returns></returns>
public ActionResult List(string ip, string sortColumn, string sortDirection, int pageSize = 15, int pageNumber = 1)
{
string sort = AdminBannedIPs.AdminGetBannedIPListSort(sortColumn, sortDirection);
PageModel pageModel = new PageModel(pageSize, pageNumber, AdminBannedIPs.AdminGetBannedIPCount(ip));
BannedIPListModel model = new BannedIPListModel()
{
BannedIPList = AdminBannedIPs.AdminGetBannedIPList(pageModel.PageSize, pageModel.PageNumber, ip, sort),
PageModel = pageModel,
SortColumn = sortColumn,
SortDirection = sortDirection,
IP = ip
};
MallUtils.SetAdminRefererCookie(string.Format("{0}?pageNumber={1}&pageSize={2}&sortColumn={3}&sortDirection={4}&ip={5}",
Url.Action("list"),
pageModel.PageNumber,
pageModel.PageSize,
sortColumn,
sortDirection,
ip));
return View(model);
}
/// <summary>
/// 品牌列表
/// </summary>
/// <param name="brandName">品牌名称</param>
/// <param name="sortColumn">排序列</param>
/// <param name="sortDirection">排序方向</param>
/// <param name="pageSize">每页数</param>
/// <param name="pageNumber">当前页数</param>
/// <returns></returns>
public ActionResult List(string brandName, string sortColumn, string sortDirection, int pageSize = 15, int pageNumber = 1)
{
string condition = AdminBrands.AdminGetBrandListCondition(brandName);
string sort = AdminBrands.AdminGetBrandListSort(sortColumn, sortDirection);
PageModel pageModel = new PageModel(pageSize, pageNumber, AdminBrands.AdminGetBrandCount(condition));
BrandListModel model = new BrandListModel()
{
BrandList = AdminBrands.AdminGetBrandList(pageModel.PageSize, pageModel.PageNumber, condition, sort),
PageModel = pageModel,
SortColumn = sortColumn,
SortDirection = sortDirection,
BrandName = brandName
};
MallUtils.SetAdminRefererCookie(string.Format("{0}?pageNumber={1}&pageSize={2}&sortColumn={3}&sortDirection={4}&brandName={5}",
Url.Action("list"),
pageModel.PageNumber,
pageModel.PageSize,
sortColumn,
sortDirection,
brandName));
return View(model);
}
/// <summary>
/// 商城管理日志列表
/// </summary>
/// <param name="accountName">操作人</param>
/// <param name="operation">操作动作</param>
/// <param name="startTime">操作开始时间</param>
/// <param name="endTime">操作结束时间</param>
/// <param name="pageNumber">当前页数</param>
/// <param name="pageSize">每页数</param>
/// <returns></returns>
public ActionResult MallAdminLogList(string accountName, string operation, string startTime, string endTime, int pageNumber = 1, int pageSize = 15)
{
int uid = AdminUsers.GetUidByAccountName(accountName);
string condition = MallAdminLogs.GetMallAdminLogListCondition(uid, operation, startTime, endTime);
PageModel pageModel = new PageModel(pageSize, pageNumber, MallAdminLogs.GetMallAdminLogCount(condition));
MallAdminLogListModel model = new MallAdminLogListModel()
{
MallAdminLogList = MallAdminLogs.GetMallAdminLogList(pageModel.PageSize, pageModel.PageNumber, condition),
PageModel = pageModel,
AccountName = accountName,
Operation = operation,
StartTime = startTime,
EndTime = endTime
};
MallUtils.SetAdminRefererCookie(string.Format("{0}?pageNumber={1}&pageSize={2}&accountName={3}&operation={4}&startTime={5}&endTime={6}",
Url.Action("malladminloglist"),
pageModel.PageNumber,
pageModel.PageSize,
accountName, operation, startTime, endTime));
return View(model);
}
protected bool _showgopage = true;//是否显示页数输入框
public Pager(PageModel pageModel)
{
_pagemodel = pageModel;
}
/// <summary>
/// 商城后台分页
/// </summary>
/// <param name="helper">HtmlHelper</param>
/// <param name="pageModel">分页对象</param>
/// <returns></returns>
public static MallAdminPager MallAdminPager(this HtmlHelper helper, PageModel pageModel)
{
return new MallAdminPager(pageModel);
}
/// <summary>
/// 商城前台分页
/// </summary>
/// <param name="helper">HtmlHelper</param>
/// <param name="pageModel">分页对象</param>
/// <returns></returns>
public static WebPager WebPager(this HtmlHelper helper, PageModel pageModel)
{
return(new WebPager(pageModel, helper.ViewContext));
}
protected bool _showgopage = true; //是否显示页数输入框
public Pager(PageModel pageModel)
{
_pagemodel = pageModel;
}
/// <summary>
/// 店铺后台分页
/// </summary>
/// <param name="helper">HtmlHelper</param>
/// <param name="pageModel">分页对象</param>
/// <returns></returns>
public static StoreAdminPager StoreAdminPager(this HtmlHelper helper, PageModel pageModel)
{
return(new StoreAdminPager(pageModel));
}
/// <summary>
/// 商城后台分页
/// </summary>
/// <param name="helper">HtmlHelper</param>
/// <param name="pageModel">分页对象</param>
/// <returns></returns>
public static MallAdminPager MallAdminPager(this HtmlHelper helper, PageModel pageModel)
{
return(new MallAdminPager(pageModel));
}
public StoreAdminPager(PageModel pageModel)
: base(pageModel)
{
}
