/// <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) { }