Exemple #1
0
    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();
    }