public ActionResult Index() { IntegralMallPageModel integralMallPageModel = new IntegralMallPageModel() { CouponPageSize = 6 }; PageModel <CouponInfo> integralCoupons = couponser.GetIntegralCoupons(1, integralMallPageModel.CouponPageSize); integralMallPageModel.CouponList = integralCoupons.Models.ToList(); integralMallPageModel.CouponTotal = integralCoupons.Total; integralMallPageModel.CouponMaxPage = GetMaxPage(integralMallPageModel.CouponTotal, integralMallPageModel.CouponPageSize); integralMallPageModel.GiftPageSize = 12; GiftQuery giftQuery = new GiftQuery() { skey = "", status = new GiftInfo.GiftSalesStatus?(GiftInfo.GiftSalesStatus.Normal), PageSize = integralMallPageModel.GiftPageSize, PageNo = 1 }; PageModel <GiftModel> gifts = giftser.GetGifts(giftQuery); integralMallPageModel.GiftList = gifts.Models.ToList(); integralMallPageModel.GiftTotal = gifts.Total; integralMallPageModel.GiftMaxPage = GetMaxPage(integralMallPageModel.GiftTotal, integralMallPageModel.GiftPageSize); return(View(integralMallPageModel)); }
public void LoadGift() { if (!string.IsNullOrEmpty(this.context.Request["PageSize"]) && !string.IsNullOrEmpty(this.context.Request["CurrentPage"])) { int pageSize = int.Parse(this.context.Request["PageSize"]); int pageIndex = int.Parse(this.context.Request["CurrentPage"]); GiftQuery giftQuery = new GiftQuery(); giftQuery.IsOnline = true; giftQuery.Page.PageSize = pageSize; giftQuery.Page.PageIndex = pageIndex; giftQuery.Page.SortBy = "GiftId"; giftQuery.Page.SortOrder = SortAction.Desc; DbQueryResult gifts = GiftHelper.GetGifts(giftQuery); DataTable data = gifts.Data; string str = "{\"totalCount\":\"" + gifts.TotalRecords + "\",\"data\":["; string text = ""; for (int i = 0; i < data.Rows.Count; i++) { if (text != "") { text += ","; } text = text + "{\"GiftId\":\"" + data.Rows[i]["GiftId"] + "\",\"Name\":\"" + data.Rows[i]["Name"] + "\",\"NeedPoint\":\"" + data.Rows[i]["NeedPoint"] + "\",\"ThumbnailUrl180\":\"" + Globals.GetImageServerUrl("http://", data.Rows[i]["ThumbnailUrl180"].ToNullString()) + "\"}"; } str += text; str += "]}"; this.context.Response.Write(str); } }
public void GetList(HttpContext context) { int num = 1; int num2 = 10; num = base.GetIntParam(context, "page", false).Value; if (num < 1) { num = 1; } num2 = base.GetIntParam(context, "rows", false).Value; if (num2 < 1) { num2 = 10; } GiftQuery giftQuery = new GiftQuery(); giftQuery.Name = context.Request["Name"]; giftQuery.IsPromotion = base.GetBoolParam(context, "IsPromotion", false).Value; giftQuery.Page.PageIndex = num; giftQuery.Page.PageSize = num2; giftQuery.Page.SortBy = "GiftId"; giftQuery.Page.SortOrder = SortAction.Desc; DataGridViewModel <Dictionary <string, object> > dataList = this.GetDataList(giftQuery); string s = base.SerializeObjectToJson(dataList); context.Response.Write(s); context.Response.End(); }
public JsonResult GiftList(int page, int rows = 12) { GiftQuery query = new GiftQuery(); query.skey = ""; query.status = GiftInfo.GiftSalesStatus.Normal; query.PageSize = rows; query.PageNo = page; ObsoletePageModel <GiftModel> gifts = _iGiftService.GetGifts(query); List <GiftModel> datalist = gifts.Models.ToList(); var result = datalist.Select(d => new { Id = d.Id, GiftName = d.GiftName, NeedIntegral = d.NeedIntegral, LimtQuantity = d.LimtQuantity, StockQuantity = d.StockQuantity, EndDate = d.EndDate, NeedGrade = d.NeedGrade, SumSales = d.SumSales, SalesStatus = d.SalesStatus, ImagePath = d.ImagePath, GiftValue = d.GiftValue, ShowImagePath = Core.HimallIO.GetProductSizeImage(d.ShowImagePath, 1, (int)ImageSize.Size_350), NeedGradeName = d.NeedGradeName }).ToList(); return(Json(result)); }
public DbQueryResult GetGifts(GiftQuery query) { string text = $"[Name] LIKE '%{DataHelper.CleanSearchString(query.Name)}%'"; if (query.IsPromotion) { text += " AND IsPromotion = 1"; } if (query.IsOnline) { text += " AND NeedPoint > 0"; } if (!string.IsNullOrEmpty(query.FilterGiftIds)) { text += $" and GiftId not in ({query.FilterGiftIds})"; } Pagination page = query.Page; if (query.IsOnline) { text += " AND IsPointExchange = 1"; page.SortBy = " NeedPoint ASC,GiftId"; } return(DataHelper.PagingByRownumber(page.PageIndex, page.PageSize, page.SortBy, page.SortOrder, page.IsCount, "Hishop_Gifts", "GiftId", text, "*")); }
private void GetList(HttpContext context) { GiftQuery dataQuery = this.GetDataQuery(context); DataGridViewModel <Dictionary <string, object> > listSplittinDraws = this.GetListSplittinDraws(dataQuery); string s = base.SerializeObjectToJson(listSplittinDraws); context.Response.Write(s); context.Response.End(); }
private void GetGiftsList(HttpContext context) { GiftQuery giftsQuery = this.GetGiftsQuery(context); DataGridViewModel <Dictionary <string, object> > giftses = this.GetGiftses(giftsQuery); string s = base.SerializeObjectToJson(giftses); context.Response.Write(s); context.Response.End(); }
private GiftQuery GetGiftsQuery(HttpContext context) { GiftQuery giftQuery = new GiftQuery(); giftQuery.Name = base.GetParameter(context, "Name", true); giftQuery.Page.PageSize = base.CurrentPageSize; giftQuery.Page.PageIndex = base.CurrentPageIndex; Globals.EntityCoding(giftQuery, true); return(giftQuery); }
private DataGridViewModel <Dictionary <string, object> > GetGiftses(GiftQuery query) { DataGridViewModel <Dictionary <string, object> > dataGridViewModel = new DataGridViewModel <Dictionary <string, object> >(); if (query != null) { DbQueryResult gifts = OrderHelper.GetGifts(query); dataGridViewModel.rows = DataHelper.DataTableToDictionary(gifts.Data); dataGridViewModel.total = gifts.TotalRecords; } return(dataGridViewModel); }
public IList <GiftInfo> GetGiftList(GiftQuery query) { IList <GiftInfo> result = null; string query2 = $"SELECT * FROM Hishop_Gifts WHERE [Name] LIKE '%{DataHelper.CleanSearchString(query.Name)}%'"; DbCommand sqlStringCommand = base.database.GetSqlStringCommand(query2); using (IDataReader objReader = base.database.ExecuteReader(sqlStringCommand)) { result = DataHelper.ReaderToList <GiftInfo>(objReader); } return(result); }
public DbQueryResult GetGifts(GiftQuery query) { string filter = null; if (!string.IsNullOrEmpty(query.Name)) { filter = $"[Name] LIKE '%{DataHelper.CleanSearchString(query.Name)}%'"; } Pagination page = query.Page; return(DataHelper.PagingByRownumber(page.PageIndex, page.PageSize, page.SortBy, page.SortOrder, page.IsCount, "Hishop_Gifts", "GiftId", filter, "*")); }
private void BindGift() { GiftQuery giftQuery = new GiftQuery(); giftQuery.Page.PageIndex = this.pager.PageIndex; giftQuery.Page.PageSize = this.pager.PageSize; DbQueryResult onlineGifts = ProductBrowser.GetOnlineGifts(giftQuery); this.rptGifts.DataSource = onlineGifts.Data; this.rptGifts.DataBind(); this.pager.TotalRecords = onlineGifts.TotalRecords; }
private GiftQuery GetDataQuery(HttpContext context) { GiftQuery giftQuery = new GiftQuery(); giftQuery.Name = base.GetParameter(context, "Name", true); giftQuery.FilterGiftIds = base.GetParameter(context, "FilterGiftIds", true); giftQuery.IsPromotion = true; giftQuery.Page.PageSize = base.CurrentPageSize; giftQuery.Page.PageIndex = base.CurrentPageIndex; giftQuery.Page.SortBy = "GiftId"; giftQuery.Page.SortOrder = SortAction.Desc; return(giftQuery); }
private void BindGifts() { GiftQuery query = new GiftQuery(); query.Page.PageSize = 10; query.Page.PageIndex = pager.PageIndex; query.Name = txtSearchText.Text.Trim(); DbQueryResult gifts = OrderHelper.GetGifts(query); dlstGifts.DataSource = gifts.Data; dlstGifts.DataBind(); pager.TotalRecords = gifts.TotalRecords; }
private void BindGifts() { GiftQuery query = new GiftQuery(); query.Page.PageSize = 10; query.Page.PageIndex = this.pager.PageIndex; query.Name = this.txtSearchText.Text.Trim(); DbQueryResult gifts = SubsiteSalesHelper.GetGifts(query); this.dlstGifts.DataSource = gifts.Data; this.dlstGifts.DataBind(); this.pager.TotalRecords = gifts.TotalRecords; }
public JsonResult List(GiftInfo.GiftSalesStatus?status, string skey, int rows, int page) { GiftQuery giftQuery = new GiftQuery() { skey = skey, status = status, PageSize = rows, PageNo = page }; PageModel <GiftModel> gifts = giftser.GetGifts(giftQuery); List <GiftModel> list = gifts.Models.ToList(); return(Json(new { rows = list, total = gifts.Total })); }
public JsonResult List(GiftInfo.GiftSalesStatus?status, string skey, int rows, int page) { GiftQuery query = new GiftQuery(); query.skey = skey; query.status = status; query.PageSize = rows; query.PageNo = page; var datalist = _iGiftService.GetGifts(query); var data = datalist.Models.ToList(); var result = new { rows = data, total = datalist.Total }; return(Json(result)); }
public IList <GiftInfo> GetGiftList(GiftQuery query) { IList <GiftInfo> list = new List <GiftInfo>(); string query2 = string.Format("SELECT * FROM Ecshop_Gifts WHERE [Name] LIKE '%{0}%'", DataHelper.CleanSearchString(query.Name)); DbCommand sqlStringCommand = this.database.GetSqlStringCommand(query2); using (IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand)) { while (dataReader.Read()) { list.Add(DataMapper.PopulateGift(dataReader)); } } return(list); }
public DbQueryResult GetGifts(GiftQuery query) { string text = string.Format("[Name] LIKE '%{0}%'", DataHelper.CleanSearchString(query.Name)); if (query.IsPromotion) { text += " AND IsPromotion = 1"; } if (query.IsOnline) { text += " AND NeedPoint > 0"; } Pagination page = query.Page; return(DataHelper.PagingByRownumber(page.PageIndex, page.PageSize, page.SortBy, page.SortOrder, page.IsCount, "Ecshop_Gifts", "GiftId", text, "*")); }
private DataGridViewModel <Dictionary <string, object> > GetDataList(GiftQuery query) { DataGridViewModel <Dictionary <string, object> > dataGridViewModel = new DataGridViewModel <Dictionary <string, object> >(); if (query != null) { DbQueryResult gifts = GiftHelper.GetGifts(query); dataGridViewModel.rows = DataHelper.DataTableToDictionary(gifts.Data); dataGridViewModel.total = gifts.TotalRecords; foreach (Dictionary <string, object> row in dataGridViewModel.rows) { row["ThumbnailUrl40"] = base.GetImageOrDefaultImage(row["ThumbnailUrl40"], base.CurrentSiteSetting.DefaultProductImage); } } return(dataGridViewModel); }
public JsonResult GiftList(int page, int rows = 12) { GiftQuery giftQuery = new GiftQuery() { skey = "", status = new GiftInfo.GiftSalesStatus?(GiftInfo.GiftSalesStatus.Normal), PageSize = rows, PageNo = page }; PageModel <GiftModel> gifts = giftser.GetGifts(giftQuery); var list = ( from d in gifts.Models.ToList() select new { Id = d.Id, GiftName = d.GiftName, NeedIntegral = d.NeedIntegral, LimtQuantity = d.LimtQuantity, StockQuantity = d.StockQuantity, EndDate = d.EndDate, NeedGrade = d.NeedGrade, SumSales = d.SumSales, SalesStatus = d.SalesStatus, ImagePath = d.ImagePath, GiftValue = d.GiftValue, ShowImagePath = d.ShowImagePath, NeedGradeName = d.NeedGradeName }).ToList(); return(Json(list)); }
public JsonResult GetList(int pageno = 1, int pagesize = 10) { GiftQuery query = new GiftQuery(); query.skey = ""; query.status = GiftInfo.GiftSalesStatus.Normal; query.PageSize = pagesize; query.PageNo = pageno; QueryPageModel <GiftModel> gifts = _iGiftService.GetGifts(query); var data = gifts.Models.ToList(); foreach (var item in data) { item.DefaultShowImage = HimallIO.GetRomoteImagePath(item.GetImage(ImageSize.Size_350)); } var result = SuccessResult <List <GiftModel> >(data: data); return(Json(result, JsonRequestBehavior.AllowGet)); }
private void BindData() { GiftQuery query = new GiftQuery { Name = this.giftName, IsPromotion = this.isPromotion }; query.Page.PageSize = this.pager.PageSize; query.Page.PageIndex = this.pager.PageIndex; query.Page.SortBy = this.grdGift.SortOrderBy; if (this.grdGift.SortOrder.ToLower() == "desc") { query.Page.SortOrder = SortAction.Desc; } DbQueryResult gifts = GiftHelper.GetGifts(query); this.grdGift.DataSource = gifts.Data; this.grdGift.DataBind(); this.pager.TotalRecords = gifts.TotalRecords; this.pager1.TotalRecords = gifts.TotalRecords; }
public ActionResult Detail(long id) { GiftDetailPageModel giftDetailPageModel = new GiftDetailPageModel() { GiftData = giftser.GetById(id) }; if (giftDetailPageModel.GiftData == null) { throw new HimallException("Gift information invalid!"); } int num = 10; GiftQuery giftQuery = new GiftQuery() { skey = "", status = new GiftInfo.GiftSalesStatus?(GiftInfo.GiftSalesStatus.Normal), PageSize = num, PageNo = 1, Sort = GiftQuery.GiftSortEnum.SalesNumber, IsAsc = false }; PageModel <GiftModel> gifts = giftser.GetGifts(giftQuery); giftDetailPageModel.HotGifts = gifts.Models.ToList(); giftDetailPageModel.GiftCanBuy = true; if (giftDetailPageModel.GiftCanBuy && giftDetailPageModel.GiftData.GetSalesStatus != GiftInfo.GiftSalesStatus.Normal) { giftDetailPageModel.GiftCanBuy = false; } if (giftDetailPageModel.GiftCanBuy && giftDetailPageModel.GiftData.StockQuantity < 1) { giftDetailPageModel.GiftCanBuy = false; } if (giftDetailPageModel.GiftCanBuy && giftDetailPageModel.GiftData.NeedIntegral < 1) { giftDetailPageModel.GiftCanBuy = false; } if (giftDetailPageModel.GiftCanBuy && base.CurrentUser != null && giftDetailPageModel.GiftData.LimtQuantity > 0 && orderser.GetOwnBuyQuantity(base.CurrentUser.Id, id) >= giftDetailPageModel.GiftData.LimtQuantity) { giftDetailPageModel.GiftCanBuy = false; } return(View(giftDetailPageModel)); }
void BindData() { GiftQuery query = new GiftQuery(); query.Name = Globals.HtmlEncode(giftName); query.Page.PageSize = pager.PageSize; query.Page.PageIndex = pager.PageIndex; query.Page.SortBy = grdGift.SortOrderBy; if (grdGift.SortOrder.ToLower() == "desc") { query.Page.SortOrder = SortAction.Desc; } DbQueryResult abstroGiftsById = SubsiteGiftHelper.GetAbstroGiftsById(query); grdGift.DataSource = abstroGiftsById.Data; grdGift.DataBind(); pager.TotalRecords = abstroGiftsById.TotalRecords; pager1.TotalRecords = abstroGiftsById.TotalRecords; }
private void BindData() { GiftQuery query = new GiftQuery(); query.Name = giftName; query.Page.PageSize = pager.PageSize; query.Page.PageIndex = pager.PageIndex; query.Page.SortBy = grdGift.SortOrderBy; if (grdGift.SortOrder.ToLower() == "desc") { query.Page.SortOrder = SortAction.Desc; } DbQueryResult gifts = GiftHelper.GetGifts(query); grdGift.DataSource = gifts.Data; grdGift.DataBind(); pager.TotalRecords = gifts.TotalRecords; pager1.TotalRecords = gifts.TotalRecords; }
private void BindData() { GiftQuery giftQuery = new GiftQuery(); giftQuery.Name = Globals.HtmlEncode(this.giftName); giftQuery.Page.PageSize = this.pager.PageSize; giftQuery.Page.PageIndex = this.pager.PageIndex; giftQuery.Page.SortBy = this.grdGift.SortOrderBy; if (this.grdGift.SortOrder.ToLower() == "desc") { giftQuery.Page.SortOrder = SortAction.Desc; } DbQueryResult gifts = SubsiteGiftHelper.GetGifts(giftQuery); this.grdGift.DataSource = gifts.Data; this.grdGift.DataBind(); this.pager.TotalRecords = gifts.TotalRecords; this.pager1.TotalRecords = gifts.TotalRecords; }
/// <summary> /// 绑定TOP类控件 /// </summary> private void BindGiftTop(Control c) { //声明变量 object dtGiftTop = null; //找到控件后,获取对应的数据集 string topName = c.ID.Substring(c.ID.IndexOf("_") + 1); switch (topName) { case "Hot": dtGiftTop = ProductBrowser.GetGifts(4); break; case "All": GiftQuery query = new GiftQuery { Page = new Pagination { PageSize = this.pager.PageSize, PageIndex = this.pager.PageIndex, SortBy = "Giftid", SortOrder = SortAction.Desc } }; dtGiftTop = ProductBrowser.GetGifts(query).Data; break; default: //dtProductTop = ProductBrowser.GetHomeProductTop(3, pt); break; } //数据集处理 switch (SettingsManager.GetMasterSettings(true).VTheme.ToLower()) { default: break; } //绑定 (c as VshopTemplatedRepeater).DataSource = dtGiftTop; (c as VshopTemplatedRepeater).DataBind(); }
/// <summary> /// 积分商城 /// </summary> /// <returns></returns> public ActionResult Index() { IntegralMallPageModel result = new IntegralMallPageModel(); //Logo ViewBag.Logo = SiteSettings.Logo; //优惠券数据 result.CouponPageSize = 6; QueryPageModel <Entities.CouponInfo> coupons = _iCouponService.GetIntegralCoupons(1, result.CouponPageSize); result.CouponList = coupons.Models.ToList(); result.CouponTotal = coupons.Total; result.CouponMaxPage = GetMaxPage(result.CouponTotal, result.CouponPageSize); //礼品数据 result.GiftPageSize = 12; GiftQuery query = new GiftQuery(); query.skey = ""; query.status = GiftInfo.GiftSalesStatus.Normal; query.PageSize = result.GiftPageSize; query.PageNo = 1; QueryPageModel <GiftModel> gifts = _iGiftService.GetGifts(query); result.GiftList = gifts.Models.ToList(); result.GiftTotal = gifts.Total; result.GiftMaxPage = GetMaxPage(result.GiftTotal, result.GiftPageSize); if (CurrentUser != null) { //登录后处理会员积分 var userInte = MemberIntegralApplication.GetMemberIntegral(CurrentUser.Id); var userGrade = MemberGradeApplication.GetMemberGradeByUserIntegral(userInte.HistoryIntegrals); result.MemberAvailableIntegrals = userInte.AvailableIntegrals; result.MemberGradeName = userGrade.GradeName; } ViewBag.Keyword = SiteSettings.Keyword; return(View(result)); }
public object GetList(int pageNo = 1, int pageSize = 10) { //礼品数据 GiftQuery query = new GiftQuery(); query.skey = ""; query.status = Mall.Entities.GiftInfo.GiftSalesStatus.Normal; query.PageSize = pageSize; query.PageNo = pageNo; QueryPageModel <GiftModel> gifts = GiftApplication.GetGifts(query); var list = gifts.Models.ToList(); foreach (var item in list) { item.DefaultShowImage = MallIO.GetRomoteImagePath(item.GetImage(ImageSize.Size_350)); } return(Json(new { Gifts = list, Total = gifts.Total, MaxPage = GetMaxPage(gifts.Total, pageSize) })); }