private void BindData(int PageIndex)
{
DataTable dt = new DataTable();
int RecordCount = 0;
if (CategoryID == 0)
{
dt = bll.GetList(PageIndex, AspNetPager.PageSize, " and starttime>getdate() and status=" + (int)AuctionProductStatus.审核通过, " auctionid desc", out RecordCount);
}
else
{
MagicCategoryModel cate = new MagicCategoryBll().GetModel(CategoryID);
if (cate != null)
{
dt = bll.GetList(PageIndex, AspNetPager.PageSize, " and starttime>getdate() and catepath+'/' like '" + cate.CategoryPath + "/%' and status=" + (int)AuctionProductStatus.审核通过, " auctionid desc", out RecordCount);
}
else
{
Response.End();
}
}
foreach (DataRow row in dt.Rows)
{
row["mediumimage"] = MagicWorldImageRule.GetMainImageUrl(row["mediumimage"].ToString());
}
Repeater_ProductList.DataSource = dt;
Repeater_ProductList.DataBind();
AspNetPager.RecordCount = RecordCount;
}
public void Load_Data()
{
void Load_Detail()
{
int ID = int.Parse(Request.QueryString["id"]);
DBEntities db = new DBEntities();
var data = db.Products.Where(x => x.ProductID == ID).Select(x => new
{
x.Avatar,
x.Price,
x.Title
});
Repeater_Detail.DataSource = data.ToList();
Repeater_Detail.DataBind();
}
Load_Detail();
void Load_ProductList()
{
DBEntities db = new DBEntities();
var data = db.Products.Where(x => x.Status == true).Select(x => new
{
x.ProductID,
x.Avatar,
x.Price,
x.OldPrice,
x.Title
});
Repeater_ProductList.DataSource = data.Take(8).ToList();
Repeater_ProductList.DataBind();
}
Load_ProductList();
void Load_BestSeller()
{
DBEntities db = new DBEntities();
var data = db.Products.Where(x => x.Status == true).OrderBy(x => x.Price).Select(x => new
{
x.ProductID,
x.Avatar,
x.Title,
x.Price
});
Repeater_BestSeller.DataSource = data.Take(4).ToList();
Repeater_BestSeller.DataBind();
}
Load_BestSeller();
}
protected void DropDownList_Option_SelectedIndexChanged(object sender, EventArgs e)
{
DBEntities db = new DBEntities();
var data = from c in db.Products
where c.Status == true
select new
{
c.ProductID,
c.Avatar,
c.Title,
c.OldPrice,
c.Price,
c.ViewTime
};
if (DropDownList_Option.SelectedItem.Value == 1.ToString())
{
int min = Convert.ToInt32(data.Min(x => x.Price));
data = data.Where(x => x.Price == min);
SeeMore.Visible = false;
}
else
if (DropDownList_Option.SelectedItem.Value == 2.ToString())
{
int max = Convert.ToInt32(data.Max(x => x.Price));
data = data.Where(x => x.Price == max);
SeeMore.Visible = false;
}
else
if (DropDownList_Option.SelectedItem.Value == 3.ToString())
{
int viewTime = Convert.ToInt32(data.Max(x => x.ViewTime));
data = data.Where(x => x.ViewTime == viewTime);
SeeMore.Visible = false;
}
else if (DropDownList_Option.SelectedItem.Value == 0.ToString())
{
Load_Data();
SeeMore.Visible = true;
}
else
{
return;
}
Repeater_ProductList.DataSource = data.Take(9).ToList();
Repeater_ProductList.DataBind();
}
private void BindData()
{
int MatchCount = 0, PageCount = 0;
List <ProductModel> SearchResult = GetSearchResult(out MatchCount, out PageCount);
Literal_SearchInfo.Text = String.Format("以\"{0}\"为检索词，共搜索到{1}条数据，共{2}页", SearchWord, MatchCount, PageCount);
Repeater_ProductList.DataSource = SearchResult;
Repeater_ProductList.DataBind();
Pagination.InnerHtml = GetPaginateHtml(PageCount);
}
public void Load_Data()
{
void Load_Product_List()
{
DBEntities db = new DBEntities();
var data = (from c in db.Products
orderby c.Price
where c.Status == true
select new
{
c.ProductID,
c.Avatar,
c.Title,
c.OldPrice,
c.Price
});
Repeater_ProductList.DataSource = data.Take(8).ToList();
Repeater_ProductList.DataBind();
}
Load_Product_List();
void Load_Best_Seller()
{
DBEntities db2 = new DBEntities();
var query = (from b in db2.Products
orderby b.Quantity
where b.Status == true
select new
{
b.ProductID,
b.Avatar,
b.Title,
b.OldPrice,
b.Price
});
Repeater_Best_Seller.DataSource = query.Take(8).ToList();
Repeater_Best_Seller.DataBind();
}
Load_Best_Seller();
}
public void Load_Data(int pageSize = 9)
{
void Load_ProductList()
{
DBEntities db = new DBEntities();
var data = from c in db.ProductCategories
from m in c.Products
orderby m.Price
where m.Status == true
select new
{
c.ProductCategoryID,
m.ProductID,
m.Avatar,
m.Title,
m.OldPrice,
m.Price
};
string url = Request.QueryString.ToString();
if (url.Contains("keyword"))
{
string keyword = Request.QueryString["keyword"].ToString();
data = data.Where(x => x.Title.Contains(keyword));
}
if (url.Contains("sid"))
{
int sid = int.Parse(Request.QueryString["sid"]);
if (sid > 0)
{
data = data.Where(x => x.ProductCategoryID == sid);
}
}
Repeater_ProductList.DataSource = data.Take(pageSize).ToList();
Repeater_ProductList.DataBind();
}
Load_ProductList();
void Load_LeftData()
{
DBEntities db = new DBEntities();
var query = from l in db.Products
where l.Status == true
orderby Guid.NewGuid()
select new
{
l.ProductID,
l.Avatar,
l.OldPrice,
l.Price,
l.Title
};
Repeater_leftData.DataSource = query.Take(5).ToList();
Repeater_leftData.DataBind();
}
Load_LeftData();
void Load_Category()
{
DBEntities db = new DBEntities();
var data = db.ProductCategories.Where(x => x.Status == true).Select(x => new
{
x.ProductCategoryID,
x.Title
});
Repeater_Category.DataSource = data.ToList();
Repeater_Category.DataBind();
}
Load_Category();
}