private void BindGifts() { GiftQuery query = new GiftQuery(); query.Page.PageSize = 10; query.Page.PageIndex = pager.PageIndex; query.Name = txtSearchText.Text.Trim(); DbQueryResult gifts = SubsiteSalesHelper.GetGifts(query); dlstGifts.DataSource = gifts.Data; dlstGifts.DataBind(); pager.TotalRecords = gifts.TotalRecords; }
private 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 gifts = SubsiteGiftHelper.GetGifts(query); grdGift.DataSource = gifts.Data; grdGift.DataBind(); pager.TotalRecords = gifts.TotalRecords; pager1.TotalRecords = gifts.TotalRecords; }
public static DbQueryResult GetGifts(GiftQuery query) { return SalesProvider.Instance().GetGifts(query); }
public override DbQueryResult GetGifts(GiftQuery query) { string filter = null; if (!string.IsNullOrEmpty(query.Name)) { filter = string.Format("[Name] LIKE '%{0}%'", 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, "*"); }
public static IList<GiftInfo> GetGiftList(GiftQuery query) { return SalesProvider.Instance().GetGiftList(query); }
public abstract DbQueryResult GetGifts(GiftQuery query);
public override IList<GiftInfo> GetGiftList(GiftQuery query) { IList<GiftInfo> list = new List<GiftInfo>(); string str = string.Format("SELECT * FROM Hishop_Gifts WHERE [Name] LIKE '%{0}%'", DataHelper.CleanSearchString(query.Name)); DbCommand sqlStringCommand = database.GetSqlStringCommand(str); using (IDataReader reader = database.ExecuteReader(sqlStringCommand)) { while (reader.Read()) { list.Add(DataMapper.PopulateGift(reader)); } } return list; }
public abstract IList<GiftInfo> GetGiftList(GiftQuery query);
public override DbQueryResult GetGifts(GiftQuery query) { string filter = "IsDownLoad=1 and GiftId not in (select GiftId from distro_Gifts where DistributorUserId=" + HiContext.Current.User.UserId + ")"; if (!string.IsNullOrEmpty(query.Name)) { filter = filter + string.Format(" and [Name] LIKE '%{0}%'", 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, "*"); }
public override DbQueryResult GetAbstroGiftsById(GiftQuery query) { string filter = "d_DistributorUserId=" + HiContext.Current.User.UserId; if (!string.IsNullOrEmpty(query.Name)) { filter = string.Format(" ([Name] LIKE '%{0}%' or d_Name like '%{1}%')", DataHelper.CleanSearchString(query.Name), DataHelper.CleanSearchString(query.Name)); } Pagination page = query.Page; return DataHelper.PagingByRownumber(page.PageIndex, page.PageSize, page.SortBy, page.SortOrder, page.IsCount, "vw_distro_Gifts", "d_GiftId", filter, "d_GiftId,d_DistributorUserId,d_Name,d_NeedPoint,Name,GiftId,PurchasePrice"); }
public abstract DbQueryResult GetAbstroGiftsById(GiftQuery query);
public static DbQueryResult GetGifts(GiftQuery query) { return SubsitePromotionsProvider.Instance().GetGifts(query); }