ssss

ContractedBlock.gif ExpandedBlockStart.gif 代码
 
   
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; }
        }
    }
}

转载于:https://www.cnblogs.com/game3939/archive/2010/05/06/1728672.html

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值