public void select各地區人氣排序()
{
selectStar();
string siteId = Request["siteId"];
var table = from t in db.tServices
join a in db.tServicesPic on t.fIdServices equals a.fIdServices
join b in db.tGalleryPhoto on a.fIdPhoto equals b.fIdPhoto
join c in db.tMember on t.fIdStores equals c.fIdMember
join d in db.tStores on t.fIdStores equals d.fIdStores
join e in db.tCity on d.fIdCity equals e.fIdCity
where t.fIdSubServicesClass == 10 & e.fIdCity == Convert.ToInt32(siteId) & t.fDelete == null
orderby t.fUploadTime ascending
select new
{
f婚宴場地方案封面照 = b.fPhoto,
f會員名稱 = c.fName,
f金額 = t.fMaxMoney,
f大頭照 = c.fPhoto,
f方案名稱 = t.fName,
f方案描述 = t.fDescription,
fIdServices = t.fIdServices,
fIdStores = t.fIdStores
};
DataList111.DataSource = table;
DataList111.DataBind();
}
public void select各地區()
{
string siteId = Request["siteId"];
var table = from t in db.tGallery
join a in db.tGalleryPhoto on t.fIdGallery equals a.fIdGallery
join b in db.tStores on t.fIdStores equals b.fIdStores
join c in db.tCity on b.fIdCity equals c.fIdCity
join d in db.tMember on t.fIdStores equals d.fIdMember
where t.fIdServicesSubClass == 10 & c.fIdCity == Convert.ToInt32(siteId) & t.fIdPhotoCover == a.fIdPhoto & t.fDelete == null
orderby t.fUploadTime descending
select new
{
f作品集照片 = a.fPhoto,
f作品集名稱 = t.fName,
f大頭照 = d.fPhoto,
f作品集描述 = t.fDescription,
f廠商名稱 = d.fName,
fIdgallery = t.fIdGallery,
fIdStores = t.fIdStores
};
DataList111.DataSource = table;
DataList111.DataBind();
}
