ssss

using System;
using System.Linq;
using Arab.Web.DomainModel;

namespace Arab.Web
{
    public partial class index : System.Web.UI.Page
    {
        // fields 
        public static readonly ARDataContext db = new ARDataContext();

        protected void Page_Load(object sender, EventArgs e)
        {
            db.ObjectTrackingEnabled = false;
        }

        // Kuaixun
        public IQueryable<CustomArticle> Kuaixun = (from a in db.VArticles where a.isvalid == 'y' && (a.parent == 13 || a.cat == 13) orderby a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(7);
        public IQueryable<CustomArticle> ARKuaixun = (from a in db.VArticles where a.isvalid == 'y' && (a.parent == 2 || a.cat == 2) orderby a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(7);

        public IQueryable<CustomArticle> MyLove = (from a in db.Articles where a.isvalid == 'y' && a.cat == 58 orderby a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> ARMyLove = (from a in db.Articles where a.isvalid == 'y' && a.cat == 154 orderby a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);

        public IQueryable<CustomArticle> Touziweiyuanhui = (from a in db.VArticles where a.isvalid == 'y' && (a.parent == 21 || a.cat == 21) orderby a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> ARTouziweiyuanhui = (from a in db.VArticles where a.isvalid == 'y' && (a.parent == 11 || a.cat == 11) orderby a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);

        public IQueryable<CustomArticle> ZhengzhishiwuPhoto = (from a in db.Articles where a.isvalid == 'y' && a.cat == 12 && a.pic.Trim() != string.Empty orderby a.id descending select new CustomArticle { id = a.id, title = a.title, pic = a.pic, adddate = a.adddate }).Take(1);
        public IQueryable<CustomArticle> ARZhengzhishiwuPhoto = (from a in db.Articles where a.isvalid == 'y' && a.cat == 1 && a.pic.Trim() != string.Empty orderby a.id descending select new CustomArticle { id = a.id, title = a.title, pic = a.pic, adddate = a.adddate }).Take(1);

        public IQueryable<CustomArticle> AZhongguanxi = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 58 || a.parent == 58) orderby a.cat ascending, a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> Zhongdongwenti = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 59 || a.parent == 59) orderby a.cat ascending, a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> ZzswQita = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 60 || a.parent == 60) orderby a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);

        public IQueryable<CustomArticle> ARZhengzhishiwuTop = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 22 || a.parent == 22) orderby a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> ARZhengzhishiwuLeft = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 23 || a.parent == 23) orderby a.cat ascending, a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> ARZhengzhishiwuRight = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 22 || a.parent == 22) orderby a.cat ascending, a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);

        public IQueryable<CustomArticle> PhotoJmtz = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 193 || a.parent == 193) && a.pic.Trim() != string.Empty orderby a.id descending select new CustomArticle { id = a.id, title = a.title, pic = a.pic, adddate = a.adddate }).Take(1);
        public IQueryable<CustomArticle> Jmtzzgjj = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 194 || a.parent == 194) orderby a.cat ascending, a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> Jmtzzawl = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 195 || a.parent == 195) orderby a.cat ascending, a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> JmtzQita = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 196 || a.parent == 196) orderby a.cat ascending, a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);

        public IQueryable<CustomArticle> ArJmtzPhoto = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 3) && a.pic.Trim() != string.Empty orderby a.id descending select new CustomArticle { id = a.id, title = a.title, pic = a.pic, adddate = a.adddate }).Take(1);
        public IQueryable<CustomArticle> ArJmtz1 = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 110 || a.parent == 110) orderby a.cat ascending, a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> ArJmtz2 = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 109 || a.parent == 109) orderby a.cat ascending, a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> ArJmtz3 = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 108 || a.parent == 108) orderby a.cat ascending, a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);

        public IQueryable<CustomArticle> Zasq = (from a in db.Articles where a.isvalid == 'y' && a.cat == 19 orderby a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> ArZasq = (from a in db.Articles where a.isvalid == 'y' && a.cat == 8 orderby a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);

        public IQueryable<CustomArticle> Lyjk = (from a in db.VArticles where a.isvalid == 'y' && (a.parent == 234 || a.cat == 234) orderby a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> ArLyjk = (from a in db.VArticles where a.isvalid == 'y' && (a.parent == 235 || a.cat == 235) orderby a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);

        public IQueryable<CustomArticle> Szss = (from a in db.Articles where a.isvalid == 'y' && a.cat == 20 orderby a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> ArSzss = (from a in db.Articles where a.isvalid == 'y' && a.cat == 9 orderby a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);

        public IQueryable<CustomArticle> Zlyj = (from a in db.Articles where a.isvalid == 'y' && a.cat == 154 orderby a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> ArZlyj = (from a in db.Articles where a.isvalid == 'y' && a.cat == 273 orderby a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);

        public IQueryable<CustomArticle> News = (from a in db.VArticles where a.isvalid == 'y' && (a.parent == 189 || a.cat == 189) orderby a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> News2 = (from a in db.Articles where a.isvalid == 'y' && a.cat == 190 orderby a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);

        public IQueryable<CustomArticle> PhotoQyfw = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 16 || a.cat == 174) && a.pic.Trim() != string.Empty orderby a.id descending select new CustomArticle { id = a.id, title = a.title, pic = a.pic, adddate = a.adddate }).Take(1);
        public IQueryable<CustomArticle> PhotoArQyfw = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 5 || a.parent == 5) && a.pic.Trim() != string.Empty orderby a.id descending select new CustomArticle { id = a.id, title = a.title, pic = a.pic, adddate = a.adddate }).Take(1);
        public IQueryable<CustomArticle> Qyfw1 = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 174 || a.parent == 174) orderby a.cat ascending, a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> Qyfw2 = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 175 || a.parent == 175) orderby a.cat ascending, a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> Qyfw3 = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 176 || a.parent == 176) orderby a.cat ascending, a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> ArQyfw1 = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 156 || a.parent == 156) orderby a.cat ascending, a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> ArQyfw2 = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 155 || a.parent == 155) orderby a.cat ascending, a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> ArQyfw3 = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 157 || a.parent == 157) orderby a.cat ascending, a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);

        public IQueryable<CustomArticle> ZsyzPhoto = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 17 || a.cat == 185) && a.pic.Trim() != string.Empty orderby a.id descending select new CustomArticle { id = a.id, title = a.title, pic = a.pic, adddate = a.adddate }).Take(1);
        public IQueryable<CustomArticle> ArZsyzPhoto = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 215 || a.cat == 213) && a.pic.Trim() != string.Empty orderby a.id descending select new CustomArticle { id = a.id, title = a.title, pic = a.pic, adddate = a.adddate }).Take(1);
        public IQueryable<CustomArticle> Zsyz1 = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 185 || a.parent == 185) orderby a.cat ascending, a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> Zsyz2 = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 186 || a.parent == 186) orderby a.cat ascending, a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> Zsyz3 = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 187 || a.parent == 187) orderby a.cat ascending, a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> ArZsyz1 = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 213 || a.parent == 213) orderby a.cat ascending, a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> ArZsyz2 = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 214 || a.parent == 214) orderby a.cat ascending, a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> ArZsyz3 = (from a in db.VArticles where a.isvalid == 'y' &&(a.cat == 215 || a.parent == 215) orderby a.cat ascending, a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);

        public IQueryable<CustomArticle> WhjyPhoto = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 15 || a.cat == 128) && a.pic.Trim() != string.Empty orderby a.id descending select new CustomArticle { id = a.id, title = a.title, pic = a.pic, adddate = a.adddate }).Take(1);
        public IQueryable<CustomArticle> ArWhjyPhoto = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 4 || a.cat == 141) && a.pic.Trim() != string.Empty orderby a.id descending select new CustomArticle { id = a.id, title = a.title, pic = a.pic, adddate = a.adddate }).Take(1);
        public IQueryable<CustomArticle> Whjy1 = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 128 || a.parent == 128) orderby a.cat ascending, a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> Whjy2 = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 132 || a.parent == 132) orderby a.cat ascending, a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> Whjy3 = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 15 || a.parent == 15) orderby a.cat ascending, a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Skip(10).Take(5);
        public IQueryable<CustomArticle> ArWhjy1 = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 141 || a.parent == 141) orderby a.cat ascending, a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> ArWhjy2 = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 145 || a.parent == 145) orderby a.cat ascending, a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> ArWhjy3 = (from a in db.VArticles where a.isvalid == 'y' &&(a.cat == 142 || a.parent == 4) orderby a.cat ascending, a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Skip(10).Take(5);

        public IQueryable<CustomArticle> Zthd = (from a in db.Articles where a.isvalid == 'y' && a.cat == 18 orderby a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> ArZthd = (from a in db.Articles where a.isvalid == 'y' && a.cat == 7 orderby a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);

        public IQueryable<CustomArticle> Shipin = (from a in db.Articles where a.isvalid == 'y' && a.cat == 201 && a.pic.Trim() != string.Empty orderby a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate, pic = a.pic.Trim(), desc = a.desc }).Take(3);
        public IQueryable<CustomArticle> Renwu = (from a in db.Articles where a.isvalid == 'y' && a.cat == 199 && a.pic.Trim() != string.Empty orderby a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate, pic = a.pic.Trim(), desc = a.desc }).Take(3);
        public IQueryable<CustomArticle> Tushu = (from a in db.Articles where a.isvalid == 'y' && a.cat == 270 && a.pic.Trim() != string.Empty orderby a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate, pic = a.pic.Trim(), desc = a.desc }).Take(3);

        public class CustomArticle
        {
            public int id { get; set; }
            public string title { get; set; }
            public DateTime adddate { get; set; }
            public string pic { get; set; }
            public string desc { get; set; }
        }
    }
}

 

using System;
using System.Linq;
using Arab.Web.DomainModel;

namespace Arab.Web
{
    public partial class index : System.Web.UI.Page
    {
        // fields 
        public static readonly ARDataContext db = new ARDataContext();

        protected void Page_Load(object sender, EventArgs e)
        {
            db.ObjectTrackingEnabled = false;
        }

        // Kuaixun
        public IQueryable<CustomArticle> Kuaixun = (from a in db.VArticles where a.isvalid == 'y' && (a.parent == 13 || a.cat == 13) orderby a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(7);
        public IQueryable<CustomArticle> ARKuaixun = (from a in db.VArticles where a.isvalid == 'y' && (a.parent == 2 || a.cat == 2) orderby a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(7);

        public IQueryable<CustomArticle> MyLove = (from a in db.Articles where a.isvalid == 'y' && a.cat == 58 orderby a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> ARMyLove = (from a in db.Articles where a.isvalid == 'y' && a.cat == 154 orderby a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);

        public IQueryable<CustomArticle> Touziweiyuanhui = (from a in db.VArticles where a.isvalid == 'y' && (a.parent == 21 || a.cat == 21) orderby a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> ARTouziweiyuanhui = (from a in db.VArticles where a.isvalid == 'y' && (a.parent == 11 || a.cat == 11) orderby a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);

        public IQueryable<CustomArticle> ZhengzhishiwuPhoto = (from a in db.Articles where a.isvalid == 'y' && a.cat == 12 && a.pic.Trim() != string.Empty orderby a.id descending select new CustomArticle { id = a.id, title = a.title, pic = a.pic, adddate = a.adddate }).Take(1);
        public IQueryable<CustomArticle> ARZhengzhishiwuPhoto = (from a in db.Articles where a.isvalid == 'y' && a.cat == 1 && a.pic.Trim() != string.Empty orderby a.id descending select new CustomArticle { id = a.id, title = a.title, pic = a.pic, adddate = a.adddate }).Take(1);

        public IQueryable<CustomArticle> AZhongguanxi = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 58 || a.parent == 58) orderby a.cat ascending, a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> Zhongdongwenti = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 59 || a.parent == 59) orderby a.cat ascending, a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> ZzswQita = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 60 || a.parent == 60) orderby a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);

        public IQueryable<CustomArticle> ARZhengzhishiwuTop = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 22 || a.parent == 22) orderby a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> ARZhengzhishiwuLeft = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 23 || a.parent == 23) orderby a.cat ascending, a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> ARZhengzhishiwuRight = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 22 || a.parent == 22) orderby a.cat ascending, a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);

        public IQueryable<CustomArticle> PhotoJmtz = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 193 || a.parent == 193) && a.pic.Trim() != string.Empty orderby a.id descending select new CustomArticle { id = a.id, title = a.title, pic = a.pic, adddate = a.adddate }).Take(1);
        public IQueryable<CustomArticle> Jmtzzgjj = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 194 || a.parent == 194) orderby a.cat ascending, a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> Jmtzzawl = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 195 || a.parent == 195) orderby a.cat ascending, a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> JmtzQita = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 196 || a.parent == 196) orderby a.cat ascending, a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);

        public IQueryable<CustomArticle> ArJmtzPhoto = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 3) && a.pic.Trim() != string.Empty orderby a.id descending select new CustomArticle { id = a.id, title = a.title, pic = a.pic, adddate = a.adddate }).Take(1);
        public IQueryable<CustomArticle> ArJmtz1 = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 110 || a.parent == 110) orderby a.cat ascending, a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> ArJmtz2 = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 109 || a.parent == 109) orderby a.cat ascending, a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> ArJmtz3 = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 108 || a.parent == 108) orderby a.cat ascending, a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);

        public IQueryable<CustomArticle> Zasq = (from a in db.Articles where a.isvalid == 'y' && a.cat == 19 orderby a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> ArZasq = (from a in db.Articles where a.isvalid == 'y' && a.cat == 8 orderby a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);

        public IQueryable<CustomArticle> Lyjk = (from a in db.VArticles where a.isvalid == 'y' && (a.parent == 234 || a.cat == 234) orderby a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> ArLyjk = (from a in db.VArticles where a.isvalid == 'y' && (a.parent == 235 || a.cat == 235) orderby a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);

        public IQueryable<CustomArticle> Szss = (from a in db.Articles where a.isvalid == 'y' && a.cat == 20 orderby a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> ArSzss = (from a in db.Articles where a.isvalid == 'y' && a.cat == 9 orderby a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);

        public IQueryable<CustomArticle> Zlyj = (from a in db.Articles where a.isvalid == 'y' && a.cat == 154 orderby a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> ArZlyj = (from a in db.Articles where a.isvalid == 'y' && a.cat == 273 orderby a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);

        public IQueryable<CustomArticle> News = (from a in db.VArticles where a.isvalid == 'y' && (a.parent == 189 || a.cat == 189) orderby a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> News2 = (from a in db.Articles where a.isvalid == 'y' && a.cat == 190 orderby a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);

        public IQueryable<CustomArticle> PhotoQyfw = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 16 || a.cat == 174) && a.pic.Trim() != string.Empty orderby a.id descending select new CustomArticle { id = a.id, title = a.title, pic = a.pic, adddate = a.adddate }).Take(1);
        public IQueryable<CustomArticle> PhotoArQyfw = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 5 || a.parent == 5) && a.pic.Trim() != string.Empty orderby a.id descending select new CustomArticle { id = a.id, title = a.title, pic = a.pic, adddate = a.adddate }).Take(1);
        public IQueryable<CustomArticle> Qyfw1 = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 174 || a.parent == 174) orderby a.cat ascending, a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> Qyfw2 = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 175 || a.parent == 175) orderby a.cat ascending, a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> Qyfw3 = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 176 || a.parent == 176) orderby a.cat ascending, a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> ArQyfw1 = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 156 || a.parent == 156) orderby a.cat ascending, a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> ArQyfw2 = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 155 || a.parent == 155) orderby a.cat ascending, a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> ArQyfw3 = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 157 || a.parent == 157) orderby a.cat ascending, a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);

        public IQueryable<CustomArticle> ZsyzPhoto = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 17 || a.cat == 185) && a.pic.Trim() != string.Empty orderby a.id descending select new CustomArticle { id = a.id, title = a.title, pic = a.pic, adddate = a.adddate }).Take(1);
        public IQueryable<CustomArticle> ArZsyzPhoto = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 215 || a.cat == 213) && a.pic.Trim() != string.Empty orderby a.id descending select new CustomArticle { id = a.id, title = a.title, pic = a.pic, adddate = a.adddate }).Take(1);
        public IQueryable<CustomArticle> Zsyz1 = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 185 || a.parent == 185) orderby a.cat ascending, a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> Zsyz2 = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 186 || a.parent == 186) orderby a.cat ascending, a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> Zsyz3 = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 187 || a.parent == 187) orderby a.cat ascending, a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> ArZsyz1 = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 213 || a.parent == 213) orderby a.cat ascending, a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> ArZsyz2 = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 214 || a.parent == 214) orderby a.cat ascending, a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> ArZsyz3 = (from a in db.VArticles where a.isvalid == 'y' &&(a.cat == 215 || a.parent == 215) orderby a.cat ascending, a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);

        public IQueryable<CustomArticle> WhjyPhoto = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 15 || a.cat == 128) && a.pic.Trim() != string.Empty orderby a.id descending select new CustomArticle { id = a.id, title = a.title, pic = a.pic, adddate = a.adddate }).Take(1);
        public IQueryable<CustomArticle> ArWhjyPhoto = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 4 || a.cat == 141) && a.pic.Trim() != string.Empty orderby a.id descending select new CustomArticle { id = a.id, title = a.title, pic = a.pic, adddate = a.adddate }).Take(1);
        public IQueryable<CustomArticle> Whjy1 = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 128 || a.parent == 128) orderby a.cat ascending, a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> Whjy2 = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 132 || a.parent == 132) orderby a.cat ascending, a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> Whjy3 = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 15 || a.parent == 15) orderby a.cat ascending, a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Skip(10).Take(5);
        public IQueryable<CustomArticle> ArWhjy1 = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 141 || a.parent == 141) orderby a.cat ascending, a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> ArWhjy2 = (from a in db.VArticles where a.isvalid == 'y' && (a.cat == 145 || a.parent == 145) orderby a.cat ascending, a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> ArWhjy3 = (from a in db.VArticles where a.isvalid == 'y' &&(a.cat == 142 || a.parent == 4) orderby a.cat ascending, a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Skip(10).Take(5);

        public IQueryable<CustomArticle> Zthd = (from a in db.Articles where a.isvalid == 'y' && a.cat == 18 orderby a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);
        public IQueryable<CustomArticle> ArZthd = (from a in db.Articles where a.isvalid == 'y' && a.cat == 7 orderby a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate }).Take(5);

        public IQueryable<CustomArticle> Shipin = (from a in db.Articles where a.isvalid == 'y' && a.cat == 201 && a.pic.Trim() != string.Empty orderby a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate, pic = a.pic.Trim(), desc = a.desc }).Take(3);
        public IQueryable<CustomArticle> Renwu = (from a in db.Articles where a.isvalid == 'y' && a.cat == 199 && a.pic.Trim() != string.Empty orderby a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate, pic = a.pic.Trim(), desc = a.desc }).Take(3);
        public IQueryable<CustomArticle> Tushu = (from a in db.Articles where a.isvalid == 'y' && a.cat == 270 && a.pic.Trim() != string.Empty orderby a.id descending select new CustomArticle { id = a.id, title = a.title, adddate = a.adddate, pic = a.pic.Trim(), desc = a.desc }).Take(3);

        public class CustomArticle
        {
            public int id { get; set; }
            public string title { get; set; }
            public DateTime adddate { get; set; }
            public string pic { get; set; }
            public string desc { get; set; }
        }
    }
}